The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Postgre do not start

Discussion in 'General Discussion' started by duranduran, Feb 11, 2011.

  1. duranduran

    duranduran Well-Known Member

    Joined:
    Apr 30, 2004
    Messages:
    198
    Likes Received:
    0
    Trophy Points:
    16
    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 :

    Code:
    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...
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Hello duranduran,

    Please run the following commands and provide the output:

    Code:
    lsof -i :5432
    netstat -an|grep :5432
    Thanks.
     
  3. duranduran

    duranduran Well-Known Member

    Joined:
    Apr 30, 2004
    Messages:
    198
    Likes Received:
    0
    Trophy Points:
    16
    Hi,

    Code:
    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
     
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    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?
     
Loading...

Share This Page