Setting up second PGSQL when first is using built-in PostgreSQL module

Dan2097

11/23/23, 12:46 AM

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.

0 + 0

postgresql

centos

yum

multiple-instances

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Setting up second PGSQL when first is using built-in PostgreSQL module

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.