Postgresql Failed despite following documentation

Edmund Ong

Registered
Sep 2, 2016
2
0
76
Singapore
cPanel Access Level
Root Administrator
Hi There,

I had similar errors as the other who had posted earlier on, however after dumping it all, it still didn't work after re installing using the following command: /scripts/installpostgres.

I have also followed the documentation method:

Install or Update PostgreSQL on Your cPanel Server - cPanel Knowledge Base - cPanel Documentation

Code:
[[email protected] ~]# /scripts/installpostgres
This script installs PostgreSQL 9.2.x or later.
If your system runs an older version of PostgreSQL, you must
dump your databases to a file, and then restore them after
installation.
PostgreSQL 9.2.x is NOT backwards compatible.
If no PostgreSQL databases exist on your system, run the
following command to force the creation of a PostgreSQL 9.2.x -style
setup:
   mv /var/lib/pgsql /var/lib/pgsql.old
   systemctl restart postgresql
Do not run this command if databases exist that you wish to keep!
Are you certain that you wish to proceed? [y/(n)]:y
Loaded plugins: fastestmirror, langpacks, tsflags, universal-hooks
Loading mirror speeds from cached hostfile
* EA4: 216.12.197.42
* base: mirror.readyspace.com
* extras: mirror.readyspace.com
* updates: mirror.0x.sg
No package rh-postgresql available.
No package rh-postgresql-devel available.
No package rh-postgresql-libs available.
No package rh-postgresql-server available.
Package postgresql-9.2.15-1.el7_2.x86_64 already installed and latest version
Package postgresql-devel-9.2.15-1.el7_2.x86_64 already installed and latest version
Package postgresql-libs-9.2.15-1.el7_2.x86_64 already installed and latest version
Package postgresql-server-9.2.15-1.el7_2.x86_64 already installed and latest version
Nothing to do
Failed to determine postgresql data directory
The PostgreSQL installation failed.
Building global cache for cpanel...Done
Yet, in the above log it still states that it fails to determine the postgresql data directory, despite using the given script to install postgresql.

Hope to seek your help.
 
Last edited by a moderator:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,218
463
Hello,

Could you let us know the output from the "systemctl status postgresql.service" command on this system?

Thank you.