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.

PostgreSQL service is down

Discussion in 'Database Discussions' 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,146
    Likes Received:
    34
    Trophy Points:
    48
    Location:
    India
    cPanel Access Level:
    Root Administrator
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page