- Download the AWS RDS public certificate (https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem)
- use Google library to install openssl(https://code.google.com/archive/p/openssl-for-windows/downloads) and set it to path variable.(http://stackoverflow.com/questions/11896304/openssl-is-not-recognized-as-an-internal-or-external-command)
- To Create a .crt file from the .pem file downloaded. use this in command line (openssl x509 -outform der -in rds-combined-ca-bundle.pem -out rds-combined-ca-bundle.crt)
- Install the certificate from the newly created (.crt) file.(http://www.cs.virginia.edu/~gsw2c/GridToolsDir/Documentation/ImportTrustedCertificates.htm)
- Connect!
Forum Discussion
Connect PowerBI Desktop with PostgreSQL
I'm tring to connect power BI to a Posgres 9.4 database installed into the same machine (my windows 10 laptop). I've overcome the error about Npgsql intalling Npgsql.dll with GACutil and modifying t...
IF you are using AWS hosted Postgre then use the public key certificate provided by AWS.
Please follow the following instruction after installing Npgsql latest version
My Postgres database is hosted on and EC2 instance on AWS. Can you provide public certificate for AWS EC2 instance. I followed these steps but din't work.