Question
Is it possible to install PostgreSQL 10.x on CentOS 7 with Plesk?
Answer
It is possible to install PostgreSQL 10.x on CentOS 7 with Plesk but only as a workaround. It's recommended to use a version of PostgreSQL which is supported by Plesk and OS vendor.
On CentOS 7 the PostgreSQL package is available through the CentOS-7 Updates repository. This repository downloads PostgreSQL 9.2 version and Plesk Installer uses this repo to install PostgreSQL.
Note: In case the CentOS 7 Updates is disabled, Plesk Installer will not show PostgreSQL available to install.
Note: If PostgreSQL 10.x is manually installed on CentOS 7 from the RedHat repository, Plesk will not recognize it under Plesk > Tools & Settings > Server Components.
Use the following workaround to install PostgreSQL 10.x on CentOS 7 with Plesk:
Installing PostgreSQL 10.x on CentOS 7 server
Warning: the steps below are done at your own risk.
-
Install the required PoestgreSQL version from https://www.postgresql.org/download/linux/redhat/
-
Add it as a remote server pointing to localhost at Tools & Settings > Database Servers:
It is advisable to set up PostgreSQL 10.x to a different port (not default one: 5432) so when by any chance Plesk PostgreSQL is installed it won't break the connection to the existing database management service.
Note: Such installation requires changes in the configuration files and general customization that should be performed by the server administrator, as described in the next article: How to enable remote access to PostgreSQL server on a Plesk server?