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:
I already did some querys in Pgadmin.
Kindly, let me know what I can do to solve this.
Regards.
Hi @miedumni
Thanks for the report. I can think of two separate areas to check:
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.
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.
Hi there! I’ve tried this with both a neon.tech and supabase, postgresql database and I get the “connection terminated unexpectedly” response when trying to select a Schema. Any suggestions on troubleshooting? I also followed along with this video from the team and I still have the issue.
Hi @ben.loschen,
I’m sorry for the cryptic message. I have tesed on my side and I see that the Postgres action can fetch the schema just fine
I would recommend you to verify your Postgres credentials you inputed to Pipedream. Also please confirm if your postgres instance can be reached from the internet
Thank you! I got the supabase working!
