Database faulted after adding a secondary NIC

Ignition
1

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

2

What is the specific fault?

3

"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?

4

Is the DB service running?

5

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

6

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.)