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

TeknikL

Registered
Oct 3, 2014
4
0
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,268
463
Hello :)

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

Thank you.
 

philadcock

Registered
Feb 14, 2015
2
0
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,268
463
Re: [Case 133489] Create a New Account Account Creation Status: failed The PostgreSQL service is d

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
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.