Hello,
I am trying to connect from Quick Sight to an AWS RDS PostgreSQL database within a VPC but the connection validation fails. I do have Quick Sight Enterprise Edition so VPCs are supported and the PostgreSQL database has no public accessibility so it cannot be reached from the internet. I am receiving the following error:
GENERIC_SQL_EXCEPTION
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 followed pretty much the same steps that are described in this AWS article:
I also ran the Reachability Analyzer between the Quick Sight ENI address and the RDS database IP address and it was successful, the status is shown as Reachable.
Any idea why the DB connection can fail?
Thanks a lot in advance,
Istvan