Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

PostgreSQL service is down

Discussion in 'Database Discussion' started by Protocore Hosting, Jun 25, 2016.

Tags:
  1. Protocore Hosting

    Protocore Hosting Registered

    Joined:
    Apr 8, 2015
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Manchester, United Kingdom
    cPanel Access Level:
    Root Administrator
    Everything was working fine until today I go to create an account and get this error. Create a New Account Account Creation Status: failed The PostgreSQL service is down. When I scroll down to SQL Services, I click on Configure PostGresql and it shows normal. I'm at a loss here, trying to find some logs that tell me what the issue is, no luck.

    Error message I get when trying to start PostgreSQL

    [root@ip-****]# service postgresql start

    /var/lib/pgsql/data is missing. Use "service postgresql initdb" to initialize the cluster first.
    [FAILED]
    [root@ip-****]# service postgresql initdb
    Initializing database: mkdir: cannot create directory `/var/lib/pgsql/data/pg_log': File exists
    [FAILED]
     
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,888
    Likes Received:
    90
    Trophy Points:
    78
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,827
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    A similar issue was addressed in an older internal case. Would you mind sharing the cPanel and OS versions installed on your system? You can use the following commands:

    Code:
    cat /usr/local/cpanel/version
    cat /etc/redhat-release
    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice