Connecting quicksight to aws postgres

[apjvinod]

Hi @datawispcam

Could you please share the postgre-sql version of the datasource instance . Currently we support only ‘MD5’ based password encryption , you might need to change the password encyption to MD5 as mentioned in the below community post.

My QuickSight cannot connect to RDS PostgreSQL DB via VPC

QuickSight is not working with default Postgres 14 configuration. Postgres 14 changed the default password encryption from MD5 to SCRAM (see PostgreSQL 14 and Recent SCRAM Authentication Changes - Should I Migrate to SCRAM?). This looks like requiring a driver upgrade to 42.2.0 (see java - Unable to connect to Postgres DB due to the authentication type 10 is not supported - Stack Overflow) and QS is using 42.0 (see Maven Central Repository Search). The workaround is explicitly set the password_…

Alternatively you may reach out to your AWS account team for further assistance in the non-production accounts to get beta access.

Thanks
Vinod