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:
- Back up any PostgreSQL databases if you're using it.
- Move the old data directory out of the way:
mv -v /var/lib/pgsql/data{,.bak}
- 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".
Comments
0 comments
Article is closed for comments.