Sudden Connection Error to Postgres

Hi all,

We have been using Make for some time and a lot of our scenarios make use of a connection to our Postgres databases.

We have dev and prod versions of our scenarios.

Suddenly last night, all our scenarios using connections to our prod postgres databases have stopped working and throw a non descript error (see screenshot). Has anyone seen this before? it isn’t affecting our dev scenarios.

We have tried the following troubleshooting:

  • Reviewed and confirmed connection details
  • Reverified Connection
  • Created new connection and updated scenario
  • Reviewed where our databases are hosted for any software release/update that might have caused it.

Some help would really be appreciated as this is making it all unusable at the moment!

Thank you!

Use the Chrome extension “Integromat Dev Tool” to retrieve additional logs.

If that doesn’t help, contact Make’s Support.

Chrome Extension Link

Thanks - tried this and had it up and running whilst I tried to run the scenario but it shows no data or information on any part of it. Is there a trick to using it?

Go to Scenario Debugger:

SC_1

And find the module that causes problems:

Log will be on the right.

The problem is the module isn’t even getting as far as making an API call.
Without that attempt there will be no data in Scenario Debugger.

1 Like

Update: Make support has so far been unhelpful. Digging in deeper to support from our database host side.

Is there a way to confirm what version of postgres library that Make uses?

Unfortunately, it looks like from our database side, the error is along these lines:

ERROR: The endpoint ID is not specified. Either upgrade the Postgres client library (libpq) for SNI support or pass the endpoint ID (the first part of the domain name) as a parameter: ‘&options=endpoint%3D’. See https://neon.tech/sni for more information.