• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

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