PostgreSQL Connection attempts to connect to the wrong host

Joe_Spencer · March 4, 2026, 5:04pm

I have the JDBC Driver installed, and am trying to remotely connect to a PostgreSQL DB.

In the connection details, I am specifying a host ###.##.###.119:5432

The error thrown clearly shows that it is attempting to connect to ###.##.###.115:5432

Cannot create PoolableConnectionFactory (FATAL: no pg_hba.conf entry for host "###.##.###.115", user "######", database "#######", SSL encryption)

I tried changing it to other host parts and it still shows .115 in the error.

paul-griffith · March 4, 2026, 5:27pm

~~What version of Ignition are you using?~~

~~Can you show a screenshot of the configuration in the web interface, and if you're on 8.3, also cross-compare with the configuration on disk?~~

Joe_Spencer · March 4, 2026, 5:38pm

8.3.2

Config in the web interface:

paul-griffith · March 4, 2026, 5:40pm

~~Is your gateway a redundant pair/are you using deployment modes/have you created an "override" definition of the connection resource by any chance?~~

Joe_Spencer · March 4, 2026, 5:51pm

No to all

paul-griffith · March 4, 2026, 5:54pm

Wait.

That's an error coming back from Postgres.

Ignition is running on .115 and trying to connect, and Postgres is rejecting it. We're correctly talking to the DB at the host you specified, and it's rejecting you.