Error connecting Postgres

#1

Hi guys, I’m getting this error trying to connect with Postgres dabatase in a free database from Heroku:

Connection terminated unexpectedly

The connection with pipedream is ok, as you can see in this screenshot:

Error Postgres
Error Postgres1628×658 47.6 KB

I already did some querys in Pgadmin.

Kindly, let me know what I can do to solve this.

Regards.

#2

Hi @miedumni

Thanks for the report. I can think of two separate areas to check:

  1. Make sure you’re await'ing all Postgres operations in your code steps. It’s possible the operation isn’t completing before the step finishes executing the connection closes.

  2. Review the Heroku documentation on outside connections to Heroku hosted Postgres databases. It sounds like you may have established a connection, but there might be additional steps to take they have outlined in these docs.