Error while installing postgres in cpanel

prakashnplink

Active Member
Apr 8, 2014
35
1
8
cPanel Access Level
Root Administrator
Hi,

I am using CLOUDLINUX 7.7 and WHM version 84.0.21. When I tried to install postgresql according to this link I got the following error.
Bash:
# /usr/local/cpanel/scripts/installpostgres

This script installs PostgreSQL 9.2.x or later.
Are you certain that you wish to proceed? [y/(n)]:y
Installing Postgres...
info [installpostgres] Starting yum execution “--assumeyes --config /etc/yum.conf install rh-postgresql rh-postgresql-devel rh-postgresql-libs
rh-postgresql-server postgresql postgresql-devel postgresql-libs postgresql-server --disablerepo=epel”.
Loaded plugins: fastestmirror, rhnplugin, universal-hooks
Error communicating with server. The message was:  
There was an error communicating with CLN.
Loading mirror speeds from cached hostfile
* EA4: 185.53.12.144
* cpanel-addons-production-feed: 185.53.12.144
* cpanel-plugins: 185.53.12.144
No package rh-postgresql available.
No package rh-postgresql-devel available.
No package rh-postgresql-libs available.
No package rh-postgresql-server available.
No package postgresql available.
No package postgresql-devel available.
No package postgresql-server available.
Nothing to do
info [installpostgres] Completed yum execution “--assumeyes --config /etc/yum.conf install rh-postgresql rh-postgresql-devel rh-postgresql-lib
s rh-postgresql-server postgresql postgresql-devel postgresql-libs postgresql-server --disablerepo=epel”: in 10.869 second(s).
Use of uninitialized value $pg_data in concatenation (.) or string at /usr/local/cpanel/scripts/installpostgres line 97, <STDIN> line 1.
Failed to locate postgresql user
The PostgreSQL installation failed.
Building global cache for cpanel...Done
 

ffeingol

Well-Known Member
PartnerNOC
Nov 9, 2001
438
107
343
cPanel Access Level
DataCenter Provider
I can't help you directly (as we don't use PostgreSQL) but have you opened a cPanel support ticket? I'm sure they can help you.
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,296
1,252
313
Houston
Hello,

This output indicates that the postgres packages are not able to be found in the repository:

Code:
No package rh-postgresql available.
No package rh-postgresql-devel available.
No package rh-postgresql-libs available.
No package rh-postgresql-server available.
No package postgresql available.
No package postgresql-devel available.
No package postgresql-server available.
Nothing to do
This is because of the more important error listed above that:

Code:
Error communicating with server. The message was: 
There was an error communicating with CLN.
The issue of communicating with CLN needs to be addressed in order to be able to download packages from their repositories. If you haven't renewed your CloudLinux license this may be a cause for this issue but ultimately if you're unsure why this is occurring you should open a support ticket. If you purchased your CloudLinux license through us you can open a ticket with us using the link in my signature. If you purchased your license with CloudLinux or another 3rd party provider you can open a ticket with CloudLinux here: CloudLinux - Main | New template
 

prakashnplink

Active Member
Apr 8, 2014
35
1
8
cPanel Access Level
Root Administrator
Cloudlinux team said it was because we have installed MySQL governor which is incompatible with PostgreSQL. To install it we need to remove MySQL governor.

Thank you all.