Earlier this year I had to provision a new Aurora Postgresql serverless v2 cluster with version 13.10 as none of the newer versions that i tested worked with Quicksight.
However this version is reaching EOL and it looks like I’ll need to update to a newer version of Postgresql.
What versions of Postgresql are compatible with Quicksight, I’m using Aurora Serverless V2 (I/O optimized)?
Hi @Sean_B - As per the documentation, QuickSight supported " * PostgreSQL 9.3.1 or later" , I believe any version grater than 9.3.1 ( for postgres) should be supported.
Tagging @duncan @royyung @DylanM for their advise on this as well.
Regards - Sanjeeb
@Sanjeeb2022 ok I’ll give the latest version a try. In the past about 6 months ago I tried different versions of 15 and 14 neither worked. I came across a post elsewhere that said version 13 worked, which it did and just stuck with that the past 6 months.
Amazon QuickSight now offers the latest PostgreSQL driver version for the connectors: RDS hosted PostgreSQL, Aurora PostgreSQL and Vanilla PostgreSQL thereby supporting SCRAM based authentication to PostgreSQL from QuickSight. No additional configuration is needed in Amazon QuickSight as long as you use the appropriate PostgreSQL engine version and have the correct configurations in PostgreSQL for SCRAM. If you still see any issues around establishing a SCRAM authentication to PostgreSQL from QuickSight, please create a support ticket.
– Amazon QuickSight Connectivity Team