PostgreSQL {could not create any TCP/IP sockets}

000

Well-Known Member
Jun 3, 2008
242
8
68
Hi.

In answer to http://forums.cpanel.net/f5/postgre-do-not-start-191162.html (old and cPanel no accept comments)

I run
PHP:
[email protected] [~]# /etc/init.d/postgresql restart
Stopping postgresql service:                               [FAILED]
Starting postgresql service:                               [  OK  ]
[email protected] [~]#
Then I run recomendation of Staff cPanel:
PHP:
[email protected] [~]# service csf stop;service iptables stop;
WARNING: This script should ONLY be used by the init process. To restart csf use the CLI command 'csf -r'

Stopping csf:(saving iptables)                             [  OK  ]

iptables: Flushing firewall rules:                         [  OK  ]
iptables: Setting chains to policy ACCEPT: mangle filter na[  OK  ]
iptables: Unloading modules:                               [  OK  ]
[email protected] [~]#
And with iptables off:
PHP:
[email protected] [~]# /etc/init.d/postgresql restart
Stopping postgresql service:                               [FAILED]
Starting postgresql service:                               [  OK  ]
[email protected] [~]#
And pgstartup.log
PHP:
could not create any TCP/IP sockets
Then please more commands of help.

Thanks
 
Last edited:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,203
363
Hello :)

Please post the output of the following commands:

Code:
lsof -i :5432
netstat -an|grep :5432
Thank you.