Skip to main content

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: [QUOTE]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: [QUOTE]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

Comments

9 comments

Date Votes
  • cPRex Jurassic Moderator
    Hey there! Can you try the fix mentioned in the following article and let me know if that gets things working?
    0
  • Keves5
    Hello, thank you very much for the answer, I tried to reinstall it, but the error persisted [QUOTE] 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, 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?
    0
  • cPRex Jurassic Moderator
    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.
    0
  • Keves5
    Sure, I send the ticket through the link that appears below your post?
    0
  • cPRex Jurassic Moderator
    That will work, or you can do that through WHM.
    0
  • Keves5
    Done, they helped me and fixed the problem, PostgreSQL is working again. Thanks for your help
    0
  • cPRex Jurassic Moderator
    Great - can you post the ticket number here so I can get some details I could share here?
    0
  • Keves5
    Great - can you post the ticket number here so I can get some details I could share here?

    Sure, Ticket ID #94426743
    0
  • cPRex Jurassic Moderator
    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.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post