Error while installing postgres in cpanel

prakashnplink

• February 23, 2020 01:14

Hi, I am using CLOUDLINUX 7.7 and WHM version 84.0.21. When I tried to install postgresql according to this [CODE=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, line 1. Failed to locate postgresql user The PostgreSQL installation failed. Building global cache for cpanel...Done

• 

  ffeingol

  • February 24, 2020 00:03

  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.

  0
• 

  cPanelLauren

  • February 24, 2020 21:01

  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

  0
• 

  prakashnplink

  • March 03, 2020 07:34

  Thanks I have opened a ticket.

  0
• 

  prakashnplink

  • March 03, 2020 09:38

  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.

  0

Please sign in to leave a comment.