CODEWITHSUNDEEP
djangopostgresqlamazon-web-servicesheroku
Weier
Weier

Reputation: 1429

Connecting to RDS Postgres from Heroku

I'm in the process of migrating my Heroku app database from Heroku to AWS RDS Postgres.

On my computer, I can connect to my RDS DB using:

psql -d "postgres://user:[email protected]/mydb?sslrootcert=config/amazon-rds-ca-cert.pem&sslmode=require"

However, the same psql command run from within my heroku server just hangs forever.

Also, config/amazon-rds-ca-cert.pem is the RDS certificate that I added to my package as mentioned in the documentation https://devcenter.heroku.com/articles/amazon-rds#authorizing-access-to-rds-instance and here https://stackoverflow.com/a/29467638/943524 (I did combine certificates as I am using a eu-central-1 instance).

Would someone have an idea what is blocking the connection here ?

Upvotes: 1

Views: 727

Answers (1)

smcstewart
smcstewart

Reputation: 2085

From the sound of it, your Network ACL or Security Groups are blocking your access. It looks like they allow your computer (perhaps your entire company’s IP) but not Heroku. Check out the NACLs and Security Groups and you should find your answer (i.e. add Heroku IP range to your NACLs and/or Security Groups).

Upvotes: 3

Related Questions