postgresql

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

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

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

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?

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

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

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

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

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

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

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

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

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

Hello, Since 68.0.25, this started on my servers: s14.postimg.org/wved8oj81/Screen_Shot_2018-01-13_at_10.21.13.png This occur on backup, pkgacct and transfer tool.

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

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

Hello, I'm checking my web security by detectify.com, 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...

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

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

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