Upgrade PostgreSQL Version?

[jlucho]

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:
[root@s20 ~]# postgres --version
postgres (PostgreSQL) 8.4.20


what is the procedure to update postgresql, to the latest version in force

 

[cPanelMichael]

Hello @jlucho,

We only support versions of PostgreSQL that you install with the /usr/local/cpanel/scripts/installpostgres script. This script installs the version of PostgreSQL offered with your operating system.

Can you let me know which version of CloudLinux is installed on your system? You can check by running the following command:

cat /etc/redhat-release

Thank you.

 

[jlucho]

[root@s1 ~]# cat /etc/redhat-release
CloudLinux Server release 6.10 (Vladimir Lyakhov)

 

[cPanelMichael]

Hello @jlucho,

The version of PostgreSQL installed on the system is dictated by what your OS provides. PostgreSQL version 8.4 is provided with CloudLinux/CentOS 6. To use a newer version (e.g. 9.2) in a supported fashion, you'd need to setup a new server using CentOS/CloudLinux version 7, and transfer your accounts over to the new server.

Thank you.

 

[jlucho]

whats is last version stable of PostgreSQL for cPanel/Centos 6.9 ??

whats is last version stable of PostgreSQL for cPanel/Centos 7.x ??

 

[dalem]

centos 7 postgresql.x86_64 9.2.24-1.el7_5
centos 6 postgresql.x86_64 8.4.20-8.el6_9

a yum list would have given you the info