Database faulted after adding a secondary NIC

Greetings All,

I have Ignition 8.1.26 connected to a Postgresql database. All was working well. We added a second NIC to the system to allow for internet connection for alarming notification. Soon as we did that, database became faulted. I looked at the setup and thought well maybe localhost isn't localhost anymore and so I put in the IP address of the gateway (the original IP address) instead of localhost but that didn't' make a difference.

The Gateway IP is 192.168.1.50 / 255.255.255.0 (all was fine this way)
The new NIC is 192.168.200.50 / 255.255.255.0 (causes the faulted connection)

The database connect URL is jdbc:postgresql://localhost:5432/postgres

I've tried replacing "localhost" with 192.168.1.50.

Anybody have any thoughts on this?

Many Thanks to you all

What is the specific fault?

"Cannot create poolable connection factory (connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections"

Again, all was fine till I added the second NIC so I'm thinking it's looking at the wrong binding or something along those lines?

Is the DB service running?

Yes. If I disable the other NIC all is well again.

I recommend you move the database to a separate server. That way you can isolate DB issues from gateway issues in a less-than-ideal networking environment. (Anything that breaks localhost's definition as 127.0.0.1 is suspicious.)