Connection timeout after upgrading to Central v1.2

I think the main issue is that the properties port and ssl were allowed in v1.1, but are now ignored. I actually don't see anywhere that we document port and ssl. Did you find those in the Knex.js documentation, or did you just notice that they worked?

To specify the port, I think you can include that in the host property.

We don't have a good way right now to specify named parameters, including ssl=true. If you must specify ssl=true, you could try shoving it into the database name, since that comes last in the connection string: "database": "mydb?ssl=true". However, I'm not sure I recommend that, because the database property is intended for the database name, and this approach might not be supported in a future version.

I can't tell whether there's an issue with your password. Central v1.2 does not currently encode the password for the connection string, so there can be an issue if your password contains a symbol with special meaning. In that case, you should either change your password to something without the symbol, or percent-encode the symbol.

For more background on all this, check out the documentation on Postgres connection URIs: https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING

I'll also file a GitHub issue so that we can think more about encoding the password and specifying named parameters.

2 Likes