Configuring AWS Quicksight to connect to an RDS PostgreSQL

Hi all,

I’m having trouble connecting AWS QuickSight to my Read Replica RDS PostgreSQL database. Here’s the situation:

**Main RDS Database: **Located in private subnets with a route table allowing only local traffic. Access is provided through another private subnet with a route table allowing both local and NAT traffic (used by our Website API and AWS VPN Client). Read Replica: Created for BI requirements, also in private subnets but in a different subnet group from the main database. This setup allows developer access via the VPN. Both databases are PostgreSQL 15. When setting up a VPC Connection in QuickSight, I’m unsure about which subnets to choose. Should I select the subnets of the read replicas or those where traffic can be routed by the NAT gateway (since these subnets are allowed to access the database)? I assume creating an ENI requires a VPC endpoint or a NAT gateway, but I’m not certain.

Additionally, I’m encountering this error when trying to connect QuickSight to the read replica: "The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supported by the driver."

I’ve already modified the parameter group for the read replica to set password_encryption to md5, but the issue persists. I’m confused about whether the problem lies in the database configuration or the VPC connection setup.

Any insights or help would be appreciated.

Thanks!