Can't connect to Postgres Database

Need help Database
1

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!

2

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

3

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
1 Like