Skip to main content

Cant create accounts due to postgreSQL error

Paul Western
  • Updated

Symptoms

When attempting to create a new cPanel account, the following error will be presented:

(XID yt745u) The system failed to connect to the “PostgreSQL” database “postgres”
 because of an error: connection_failure (could not connect to server: No such
 file or directory Is the server running locally and accepting connections on
 Unix domain socket "/tmp/.s.PGSQL.5432"?) at 
/usr/local/cpanel/Whostmgr/Accounts/Create.pm line 1305.

Description 

This happens when PostgreSQL is installed but has not been fully initialized.

Workaround

Our developers have pushed an update that resolved this issue in cPanel v98+ under the case CPANEL-36613.

The prior workaround is provided below, but we advise you update to the latest version of cPanel to resolve this issue.

To reinitialize PostgreSQL follow the steps below:

  1. Back up any PostgreSQL databases if you're using it.
  2. Move the old data directory out of the way: 
    mv -v /var/lib/pgsql/data{,.bak}
  3. Run the install script to start the reinitialization: 
    /scripts/installpostgres

Alternatively, if you are not using PostgreSQL, you can disable the PostgreSQL Server service at (WHM » Service configuration » Service Manager) and click "Save".

 

Related articles