SOLVED Problem with PostgreSQL in WHM

[Keves5]

Hello, I would like your help with the following problem I tried to create a CPanel account to associate a domain from the WHM panel, when creating the account it gives me the following error:

Account Creation Status: failed (XID cpt5j9) The system failed to connect to the “PostgreSQL” database “postgres” because of an error: connection_failure (could not connect to server: Connection refused Is the server running on host "localhost" (127.0.0.1) and accepting TCP /IP connections on port 5432? could not connect to server: Connection refused Is the server running on host "localhost" ( ::1) and accepting TCP/IP connections on port 5432?) at /usr/local/cpanel/Whostmgr/ Accounts/Create.pm line 1374.

I tried restarting the PostgreSQL service thinking it would solve the problem, but it also gives me an error:

The Postgres database is not initialized. The system will now initialize it.initdb: directory "/var/lib/pgsql/data" exists but is not empty If you want to create a new database system, either remove or empty the directory "/var/lib/pgsql/data" or run initdb with an argument other than "/var/lib/pgsql/data". The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale "en_US.UTF-8". The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Done Waiting for “postgresql” to start ………failed.

Cpanel::Exception::Services::StartError Service Status
undefined status from Cpanel::ServiceManager::Services::Postgresql

Service Error
(XID 2u4952) The “postgresql” service failed to start.

Startup Log
Mar 15 16:36:57 vps-139996.iegrupo.co systemd[1]: Starting PostgreSQL database server...
Mar 15 16:36:57 vps-139996.iegrupo.co systemd[1]: postgresql.service: control process exited, code=exited status=1
Mar 15 16:36:57 vps-139996.iegrupo.co systemd[1]: Failed to start PostgreSQL database server.
Mar 15 16:36:57 vps-139996.iegrupo.co systemd[1]: Unit postgresql.service entered failed state.
Mar 15 16:36:57 vps-139996.iegrupo.co systemd[1]: postgresql.service failed.

postgresql has failed. Contact your system administrator if the service does not automagically recover.

I appreciate the help you can give me

 

[cPRex]

Hey there! Can you try the fix mentioned in the following article and let me know if that gets things working?

https://support.cpanel.net/hc/en-us/articles/1500008215741-Cant-create-accounts-due-to-postgreSQL-error

 

[Keves5]

Hello, thank you very much for the answer, I tried to reinstall it, but the error persisted

info [installpostgres] Installing Postgres...
Loaded plugins: fastestmirror, langpacks, universal-hooks
Loading mirror speeds from cached hostfile
* EA4: 208.74.123.61
* cpanel-addons-production-feed: 208.74.123.61
* cpanel-plugins: 208.74.123.61
Package postgresql-9.2.24-7.el7_9.x86_64 already installed and latest version
Package postgresql-devel-9.2.24-7.el7_9.x86_64 already installed and latest version
Package postgresql-libs-9.2.24-7.el7_9.x86_64 already installed and latest version
Package postgresql-server-9.2.24-7.el7_9.x86_64 already installed and latest version
No package rh-postgresql available.
No package rh-postgresql-devel available.
No package rh-postgresql-libs available.
No package rh-postgresql-server available.
Nothing to do
Use of uninitialized value $pg_data in concatenation (.) or string at /scripts/installpostgres line 135, <STDIN> line 1.
info [installpostgres] Updating postgresql configuration now...
warn [installpostgres] Failed to reload PostgreSQL: The “/usr/bin/pg_ctl -D /var/lib/pgsql/data reload” command (process 14114) reported error number 1 when it ended.
info [installpostgres] Failed to _update_db_passwd for postgres: psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
,
warn [installpostgres] Failed to reload PostgreSQL: The “/usr/bin/pg_ctl -D /var/lib/pgsql/data reload” command (process 14116) reported error number 1 when it ended.
Configuration successfully updated
info [installpostgres] Attempting to restart postgresql...
The PostgreSQL installation failed!

I decided to deactivate the service because I am not using PostgreSQL, I thought that WHM needed it, but apparently it is not, Will I have a problem if I leave it disabled?

 

[cPRex]

There's no reason you are required to have that software on the machine. I would still be interested in seeing a root cause of this if you could submit a ticket to our team so we could check the server directly.

 

[Keves5]

Sure, I send the ticket through the link that appears below your post?

 

[cPRex]

That will work, or you can do that through WHM.

 

[Keves5]

Done, they helped me and fixed the problem, PostgreSQL is working again.

Thanks for your help

 

[cPRex]

Great - can you post the ticket number here so I can get some details I could share here?

 

[Keves5]

Great - can you post the ticket number here so I can get some details I could share here?

Sure, Ticket ID #94426743

 

[cPRex]

Here's the notes from Ausaf on that ticket:

"I enabled the service in WHM > Service Manager. Afterward, I installed the PostgreSQL config and added the users by navigating to WHM > Configure PostgreSQL."

After that work was performed, the PostGreSQL service was up and running normally.