Forum Discussion
Helper IIIConnecting to PostgresSQL hosted on AWS RDS?
Anonymous the PostgresSQL connector doesn't work out of the box, you need to do quite a few things first
1. Install Npgsql which allows .NET access to PostgresSQL. I installed it using the Pakagae Manager Console in Visual Studio; detailed instructions are here: https://www.nuget.org/packages/Npgsql/
You need to connect over SSL to AWS which isn't setup by default (on my Windows 10 machine anway)
2. Download the AWS public key from here https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem
3. Convert that to a certificate using https://www.sslshopper.com/ssl-converter.html (convert to PKCS#7/P7B)
4. Import that certificate to the Trusted Room Certificate described here http://www.cs.virginia.edu/~gsw2c/GridToolsDir/Documentation/ImportTrustedCertificates.htm
5. Test access from Power BI desktop using the PostgresSQL connector and it should work
In conclusion it's possible to connect to PostgresSQL on AWS RDS databases but it isn't easy
Recently Amazon changed the link to download the certificate. To download the latest certificate go to: Using SSL/TLS to encrypt a connection to a DB instance or cluster - Amazon Relational Database Service
Download the global-bundle.p7b or the bundle that corresponds to the region of the RDS. Then add certificate to Trusted Root Certificate.
I've added the global bundle cert from the AWS to Trusted Root Certificate, but I still get the error on Power BI - "The remote certificate is invalid according to the validation procedure". Have you managed to connect to Postgresql database with encryption?