Issue Upgrading Postgresql from 9.2 to 10.x ?

[Justrop]

Hi,

I spent two days on upgrading to postgresql 9.2 to 10 on my centos 7.

But i didn't get it well installed. When we install postgresql with plesk, it comes with the version 9.2 which is not supported anymore. this version has many security vulnerabilities!

How can i upgrade it? In plesk there is no option or way to do that.
I tried to use pg_upgrade, but because the paths are different i also didn't get it work.

Thanks!

 

[IgorG]

Basically Plesk installs PostgreSQL from default vendor's OS repository, on CentOS 7 it is PostgreSQL 9.2. Thus, we don't have guidelines on how to upgrade it to 10.x.

I may recommend to check official PostgreSQL documentation or try to find any guide on CentOS community forums about how to upgrade to 10.x on CentOS 7 and try it out. https://www.postgresql.org/docs/10/pgupgrade.html

However, please note we do test Plesk capability with default OS repositories only, means we did not test upgrade to PostgreSQL 10.x. If you want a safe way to use PostgreSQL 10, you may consider deploying and using it as a Docker container.

 

[Justrop]

As i said, i tried but couldnt get it worked via pg upgrade.

I dont know what to do now..

 

[Justrop]

Basically Plesk installs PostgreSQL from default vendor's OS repository, on CentOS 7 it is PostgreSQL 9.2. Thus, we don't have guidelines on how to upgrade it to 10.x.

I may recommend to check official PostgreSQL documentation or try to find any guide on CentOS community forums about how to upgrade to 10.x on CentOS 7 and try it out. https://www.postgresql.org/docs/10/pgupgrade.html

However, please note we do test Plesk capability with default OS repositories only, means we did not test upgrade to PostgreSQL 10.x. If you want a safe way to use PostgreSQL 10, you may consider deploying and using it as a Docker container.