1. J

    PostgreSQL 2022

    hi guys A) via command console, how do I get the version of postgresql currently installed? B) Through whm or console command, what is the procedure to update posgreSQL to the latest version C) how to uninstall postgreSQL? posgresql is currently at version 15 Thank
  2. G

    Mysql and Postgresql datbases count

    Hello, I have recently got Postgresql activated on my hosting service. The problem is that it is doubling the database number a customer may have in a single account. If I give 10 databases to a user, cPanel is displaying 10 databases for mysql and 10 for postresql. When mysql databases are...
  3. L

    SOLVED Uninstall PostgreSQL

    Is there any way to uninstall PostgreSQL after it's been installed with the /usr/local/cpanel/scripts/installpostgres script?
  4. L

    Supporting a PostgreSQL version newer than 10 years old

    PostgreSQL 9.2 was released in 2012 and is no longer supported (PostgreSQL: Versioning Policy). CentOS 7 supports PostgreSQL 9.6, 10, 11, 12 and 13 (PostgreSQL: Linux downloads (Red Hat family)). How can I run a supported version of PostgreSQL on WHM/cPanel?
  5. E

    How to know if anyone has a PostgreSQL database?

    Hello, we are considering to shut down the PostgreSQL Database Server to try and save memory and resources. It seems PostgreSQL is not very popular. Before we disable PostgreSQL on our server, how can we find out if anyone is actually using it? Is there a way to see if any user has created a...
  6. I

    How to upgrade PostgreSql 9.2 to PostgreSql 9.6

    Just upgraded from PostgreSQL 9.6 to 10.3 on CloudLinux 6.9 but cPanel seems to only partially work with it. In cPanel, all of the PostgreSQL links have gone. But in WHM, its still visible such as the Configure PostgreSQL page and its listed in the Service Manager. However, if I run Install...
  7. m.eid

    [CPANEL-27658] cPanel update fails with PostgreSQL error

    I've tried o retry update the system and the error has disappeared but new one appeared [2019-05-30 03:20:24 +0300] E [/usr/local/cpanel/bin/postgrescheck] The “/usr/local/cpanel/bin/postgrescheck --check-auth --reset-pass-on-fail” command (process 23260) reported error number 1 when it ended...
  8. K

    The system failed to connect to the PostgreSQL database error

    Account Creation Status: failed (XID 3xxp4q) The system failed to connect to the “PostgreSQL” database “postgres” because of an error: connection_failure (could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket...
  9. L

    SOLVED Failed to determine postgresql data directory

    Hi, My problem is the same as the topic: PostgreSQL is not running I tried to remove the RPMs, and install again as described but it did not work. [email protected] [lib]# yum remove postgresql Loaded plugins: fastestmirror, langpacks, universal-hooks Resolving Dependencies --> Running...
  10. J

    Upgrade PostgreSQL Version?

    Hello friends I use Linux centos + CloudLinux + cPanel v76.0.14 What is the latest version of PostgreSQL for this version? my current version of postgresql is: [[email protected] ~]# postgres --version postgres (PostgreSQL) 8.4.20 what is the procedure to update postgresql, to the latest version in...
  11. E

    Which Script Installs PostgreSQL on a cPanel & WHM server?

    Hi, I am confused while installing script on a cPanel. Please guide me
  12. Bashed

    FATAL: no pg_hba.conf entry for host

    Hey folks, how do I fix this? "Error: SQLSTATE[08006] [7] FATAL: no pg_hba.conf entry for host "", user "user_usuario", database "user_beneficios", SSL off"
  13. S

    installpostgres script never runs as intended

    Hi there. I've been looking at this problem for at least 2 hours, but cannot find a solution. I hope a member of cPanel staff can assist. I have been trying repeatedly to run the /usr/local/cpanel/scripts/installpostgres script. I needed to edit the file in order for it to be pointed to the...
  14. M

    Postgresql error pktacct/transfer tool

    Hello, Since 68.0.25, this started on my servers: This occur on backup, pkgacct and transfer tool.
  15. Kent Brockman

    How to completely disable PostgreSQL

    Hello guys. I want to completely disable/uninstall PostgreSQL in my servers. What's the recommended procedure? I googled around a bit and found cPanel Docs don't provide this information and there are some tuts with dates around 5-10 years ago, like this one: how to remove postgresql out of...
  16. B

    Failed to start the postgresql service

    Need help my server has this error what can I do Reiniciando Servidor PostgresSQL:[ The Postgres database is not initialized. The system will now initialize it.The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The...
  17. M

    Blind SQL Injection in PostgreSQL

    Hello, I'm checking my web security by, I found the severe issue found in cPanel. It's found at http://mydomain:2082/unprotected/loader.html. it said that there is Vulnerable GET variable goto_uri on that file, and An attacker can execute SQL code, which includes reading/writing...
  18. Oldiesmann

    Cannot manage PostgreSQL DBs/Tables with phpPgAdmin

    I am running CentOS 7 with PostgreSQL 9.2.18 and the latest release version of cPanel/WHM (it's a VPS). I mostly use PostgreSQL to test a forum script that I am a developer for. Recently we added a few more columns to one of the database tables. Since it's a development version, the simplest...
  19. A

    Error configuring PostgreSQL Error: PostgreSQL is not running.

    But it is running, and rather fine. I can configure Postgresql from cli, so this is not a big issue for me, but I would like to get it fixed somehow. this is the content of /var/lib/pgsql/pgstartup.log : The files belonging to this database system will be owned by user "postgres". This user...
  20. E

    Postgresql Failed despite following documentation

    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...