centos – Setting up second PGSQL when first is using built-in PostgreSQL module
I have a Centos 8 server running PostgreSQL 10. I would like to add a PostgreSQL 14 database to this server (which would run on a different port), which will replace the PostgreSQL 10 instance after a transition period.
PostgreSQL 10 was installed via Centos’ built-in PostgreSQL module. I believe this module only supports one installation of PostgreSQL, while installations from PostgreSQL’s Yum repo should allow multiple major versions to be installed at the same time.
In this scenario, is a viable solution to disable the PostgreSQL module (sudo dnf -qy module disable postgresql
) then install both PostgreSQL 10 and 14 from PostgreSQL’s Yum repo, with the new PostgreSQL 10 then configured to point at the existing database’s directory? Is there a simpler solution that doesn’t require temporarily taking down the existing PostgreSQL 10 service.
Read more here: Source link