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!

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

Discussion in 'Database Discussion' 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 Technical Support Community Manager
    Staff Member

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

    Do you notice any output to /usr/local/cpanel/logs/error_log when attempting to create the account?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    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