Postgresql – posgresql9.4 remote connection fail


We have issues connecting to our PostgreSQL server. Sometimes nobody can connect, sometimes some can and some can't. We have no idea why.

The PostgreSQL server is on a virtual machine with 4GB of memory. We have 3 poeple who want to connect to that server. Could it be possible that number of connections are over the default max_connection?

Error message:

could not connect to server: Connection refused Is the server running on host "192.x.x.x" and accepting TCP/IP connections on port 5432?

Best Answer

This sounds to me like a network problem, restart the virtual machine and try again. The whole vm might be needing just a restart.