I am trying to connect to a PG instance hosted on AWS RDS using a secure SSL connection. Where do I store the public key on windows so that it is automatically applied to the connection?
Please note that when I open PGAdmin it only lets me specify .crt and .key files. Is there a way to point it to .pem files?
I downloaded the public key referenced here: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.SSL
On Linux it is a simple matter of putting this key into the default OpenSSL directory and postgres seems to detect it and take care of the rest itself.
On Windows I have not figured out how to do this or where to store the .pem file or how to point PGAdmin to a .pem file.