Hi @vkhilari ,
There’s an article on connecting quicksight to postgres14 here.
To verify these steps, I created an rds postgres 14.5 instance and duplicated your error, “…can’t create the datasource”.
Further, to verify that the issue was postgres 14 (and not the vpc connector or the security groups) I created an rds postgres 13.12 instance and re-used the exact same security groups. I was able to connect to the 13.12 instance using this VPC connection in quicksight.
With that, I was able to get past the error above and connect to 14.5 after I issued the following sql commands (per the article above):
set password_encryption = ‘md5’;
create user qs_user with password ‘xxxxxxxxxxx’;
grant connect on database dev to qs_user;
Note that I had to use this new qs_user in the dataset connection window.
Hope that helps. Let me know if that doesn’t work.
ws