Skip to main content

POstgress SQL installation

Gabriel Esteban

Hello, in cpanel WHM, I want to delete an account and I get the following error:

XID xjep6d) “PostgreSQL” is disabled but the user “XXXX” possesses 1 database. You must enable “PostgreSQL” to remove the user “XXXX”.

I think that if I install SQL postgres it will show users and databases. Perhaps the previous administrator installed Postgress but then uninstalled it because it was not necessary.

Postgress SQL installation it gives me the following error:

 [installpostgres] Installing Postgres...
 Loaded plugins: fastestmirror, universal-hooks Loading mirror speeds 
 from cached hostfile
  * EA4: 185.15.22.168
  * cpanel-addons-production-feed: 185.15.22.168
  * cpanel-plugins: 185.15.22.168
  * base: mirror.junda.nl
  * epel: mirror.dogado.de
  * extras: mirror.junda.nl
  * updates: de.mirrors.clouvider.net
 No package postgresql available.
 No package postgresql-devel available.
 No package postgresql-server available.
 No package rh-postgresql available.
 No package rh-postgresql-devel available.
 No package rh-postgresql-libs available.
 No package rh-postgresql-server available.
 Nothing to do
 Use of uninitialized value $pg_data in concatenation (.) or string at 
 /usr/local/cpanel/scripts/installpostgres line 135, <STDIN line 1.
 Use of uninitialized value $out in scalar chomp at 
 /usr/local/cpanel/scripts/installpostgres line 73, <STDIN line 1.
 info [installpostgres] Updating postgresql configuration now...
 Failed to determine postgresql data directory info [installpostgres] 
 Attempting to restart postgresql...
 The PostgreSQL installation failed!

 I hope you can help me

Comments

7 comments

Date Votes
  • cPRex Jurassic Moderator

    Hey there!  It seems like there may be a larger issue with Yum on the server if it's isn't able to find those packages.  Are you able to run "yum update" on the system without an issue?

    -1
  • Gabriel Esteban

    Yes, result:

    [root@xxxxxxx ~]# yum update
    Loaded plugins: fastestmirror, universal-hooks
    Loading mirror speeds from cached hostfile
     * EA4: 31.22.112.31
     * cpanel-addons-production-feed: 31.22.112.31
     * cpanel-plugins: 31.22.112.31
     * base: mirror.junda.nl
     * epel: mirror.dogado.de
     * extras: centosmirror.netcup.net
     * updates: centosmirror.netcup.net
    No packages marked for update
    [root@xxxxxx ~]#

    0
  • cPRex Jurassic Moderator

    Thanks for that - at least that looks good!  Can you let me know your operating system?  Running:

    cat /etc/redhat-release

    will show the OS details.

    0
  • Gabriel Esteban
    • Edited
    CentOS Linux release 7.9.2009 (Core)
    cPanel Version
    110.0.27
     
     

     

     

    0
  • cPRex Jurassic Moderator

    I don't have a good explanation as to why PostGreSQL wouldn't be available for that system.  It might be best to create a ticket so we can take a look.

    0
  • Gabriel Esteban
    • Edited

    DELIGHTED! but my system is hosted at Hetzner and you have not been able to give me support. Is there any way to look at it?

    More than not available, I understand that in some configuration error it does not accept the installation directory. I have another identical server and it has postgre installed correctly.

    0
  • cPRex Jurassic Moderator

    You'd have to contact Hetzner and then they would escalate the issue to us if necessary.

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post