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.

[Case 133489] Create a New Account Account Creation Status: failed The PostgreSQL service is down.

Discussion in 'Database Discussions' started by TeknikL, Nov 6, 2014.

  1. TeknikL

    TeknikL Registered

    Joined:
    Oct 3, 2014
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    DataCenter Provider
    This is very weird, 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. Any help would be great!

    I think cPanel upgraded to the latest version, maybe that's it.

    Mike
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,852
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. philadcock

    philadcock Registered

    Joined:
    Feb 14, 2015
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Today I am getting this same error. PostgreSQL service is running but when I try to create a new account it tells me it isn't. Any help on this?
     
  4. philadcock

    philadcock Registered

    Joined:
    Feb 14, 2015
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    If it helps, I did have this as output to my /usr/local/cpanel/logs/error_log:

    psql: FATAL: no pg_hba.conf entry for host "[local]", user "postgres", database "postgres", SSL off
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,852
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Re: [Case 133489] Create a New Account Account Creation Status: failed The PostgreSQL service is d

    Please browse to "WHM Home » SQL Services » Configure PostgreSQL" and select the following option:

    "Install Config"

    Let us know if the error message persists after completing this action.

    Thank you.
     
Loading...

Share This Page