Skip to content

Instantly share code, notes, and snippets.

@taiar

taiar/connect-heroku-app-to-postgres-rds-with-ssl.md

Forked from glarrain/connect-heroku-app-to-postgres-rds-with-ssl.md
Created August 4, 2017 17:45
Show Gist options
  • Save taiar/8f3f62cde2670303abf0c89f4f8ca45c to your computer and use it in GitHub Desktop.
Save taiar/8f3f62cde2670303abf0c89f4f8ca45c to your computer and use it in GitHub Desktop.
Download ZIP
How to connect a Heroku application to an Amazon RDS PostgreSQL instance, forcing SSL and certificate chain verification
Raw
connect-heroku-app-to-postgres-rds-with-ssl.md

1 - Download the RDS certificates (root plus region-specific intermediate ones) bundle:

wget -O config/rds-combined-ca-bundle.pem https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem

2 - Add config/rds-combined-ca-bundle.pem to the repository and redeploy to Heroku.

3 - Update the DATABASE_URL env var:

'postgres://user:password@host/db_name?sslmode=verify-full&sslrootcert=config/rds-combined-ca-bundle.pem'

do not forget to surround with quotes

References:

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