Forum Academy Marketplace Showcase Pricing Features

Can't connect to Postgres Database

My Postgres is on Heroku, I pasted Heroku’s URI into the connection string on Bubble but I get this error:

Connection issue: SQL Database Connector issue: Connection attempt failed: connect ECONNREFUSED 127.0.0.1:5432

My URI should work because I successfully connected via Retool. Looked through related threads here, but no resolution yet. Please help, thank you!

Wanted to give this another bump. Anyone know how to resolve this?

Figured this out. In case anyone else runs into this:

  • Heroku Postgres requires SSL connection, but Bubble does not support that
  • To work around it, I migrated my database from Heroku to Amazon RDS