Skip to content

Instantly share code, notes, and snippets.

@jonyt

jonyt/connect_heroku_to_amazon_rds

Last active April 13, 2017 00:11
Show Gist options
  • Star 8 You must be signed in to star a gist
  • Fork 4 You must be signed in to fork a gist
  • Save jonyt/69e486c95c26f4dd6a3c to your computer and use it in GitHub Desktop.
Save jonyt/69e486c95c26f4dd6a3c to your computer and use it in GitHub Desktop.
Download ZIP
How to connect a Heroku application to an Amazon RDS Postgresql instance
Raw
connect_heroku_to_amazon_rds
Download the certificate with:
`wget -O config/rds-combined-ca-bundle.pem http://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem`
Then connect with:
`postgres://user:password@amazon-host/db_name?sslmode=require&sslrootcert=config/rds-combined-ca-bundle.pem`
References:
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.SSL
https://github.com/jeremyevans/sequel/issues/897
http://www.postgresql.org/docs/9.3/static/libpq-connect.html#LIBPQ-CONNECT-SSLROOTCERT
http://dba.stackexchange.com/questions/77811/how-to-connect-to-an-amazon-postgresql-database-using-ssl
@bithavoc
Copy link

💪

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment