Question How to upgrade to PostgreSQL 9.4 in Plesk 12.5 over CentOS 6.8

[AntonioSanchez]

Hi all,

I have been searching all over Internet and Forum but no luck.

I have tried to run PostgreSQL in parallel to 8.4 (Default) in a different port and it works on console but it given me a lot of different errors configuring the new server in the CP.

Is there any correct approach for it? Could you share it with me?

 

[AntonioSanchez]

I have manage to make it, but I have found a weird situation appear.

I have two postgresql servers working in the host 8.4 and 9.4 but in CP it shows two 8.4 instances



T-101-bash-4.1# sudo -u postgres psql
Password:
psql (8.4.20)
Type "help" for help.

postgres=# SELECT version();
version
-------------------------------------------------------------------------------------------------------------------
PostgreSQL 8.4.20 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-17), 64-bit
(1 row)

postgres=# SHOW data_directory;
data_directory
---------------------
/var/lib/pgsql/data
(1 row)

=================================================

CT-101-bash-4.1# sudo -u postgres psql -p 5433
psql (8.4.20, server 9.4.11)
WARNING: psql version 8.4, server version 9.4.
Some psql features might not work.
Type "help" for help.

postgres=# SELECT version();
version
----------------------------------------------------------------------------------------------------------------
PostgreSQL 9.4.11 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-17), 64-bit
(1 row)

postgres=# SHOW data_directory;
data_directory
-------------------------
/var/lib/pgsql/9.4/data
(1 row)