Postgre do not start

[duranduran]

Hi, i have problems with Pgsql in one server. When i try to access CPANEL i have the message "The PostgreSQL server is currently offline.".

My pgstartup.log :

LOG:  could not bind IPv4 socket: Address already in use
HINT:  Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
WARNING:  could not create listen socket for "localhost"
FATAL:  could not create any TCP/IP sockets
LOG:  logger shutting down
LOG:  logger shutting down
LOG:  logger shutting down
LOG:  logger shutting down
LOG:  logger shutting down

I have tried all, reconfigure, reboot, reinstall...

 

[cPanelTristan]

Hello duranduran,

Please run the following commands and provide the output:

lsof -i :5432
netstat -an|grep :5432

Thanks.

 

[duranduran]

Hi,

root@node [/var/lib/pgsql]# lsof -i :5432
root@node [/var/lib/pgsql]# netstat -an|grep :5432
tcp        0      0 213.239.201.145:80          200.195.42.200:54320        ESTABLISHED

 

[cPanelTristan]

Do you have a firewall that is running such as CSF or APF? Can you take the firewall down and try to restart postgres again?