• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

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

AntonioSanchez

New Pleskian
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?
 
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

upload_2017-3-17_16-57-25.png

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)
 
Back
Top