Error while installing postgres in cpanel

[prakashnplink]

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.

# /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]

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]

Hello,

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

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:

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]

Thanks I have opened a ticket.

 

[prakashnplink]

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.