Re: How to install specific postgres version / downgrade in Ubuntu - Mailing list pgsql-admin

From Zaid Shabbir
Subject Re: How to install specific postgres version / downgrade in Ubuntu
Date
Msg-id CABCJe_XvFEDTs2hmhfLLg5NPs_p2cmLEzxiiEPR=+utdvNqZfA@mail.gmail.com
Whole thread Raw
In response to Re: How to install specific postgres version / downgrade in Ubuntu  (kamal deen <kamaldeendba@gmail.com>)
Responses Re: How to install specific postgres version / downgrade in Ubuntu
List pgsql-admin


On Thu, Sep 19, 2024 at 3:27 PM kamal deen <kamaldeendba@gmail.com> wrote:
Thanks for your response, 

I would like to get the exact commands to use.

apt-cache showpkg postgresql-15
apt install <package-name>=<version> 

Note: Before downgrade operation please make sure you take the proper backup.


SK


On Thu, Sep 19, 2024, 3:35 PM Muhammad Usman Khan <usman.k@bitnine.net> wrote:
Hi,
I think the only solution is to:

Backup Your Data
Stop PostgreSQL
Uninstall PostgreSQL 15.8
Install PostgreSQL 15.7
Check Replication

On Thu, 19 Sept 2024 at 15:00, kamal deen <kamaldeendba@gmail.com> wrote:
Hi Team,

We have observed post OS patching one of our replica server got auto upgraded from 15.7 to 15.8 in Ubuntu , we wanted to downgrade the postgres version to match with our primary node.

( replic sync also not happening due this version mis match )

Pls advise.

Thanks in advance.

SK

pgsql-admin by date:

Previous
From: kamal deen
Date:
Subject: Re: How to install specific postgres version / downgrade in Ubuntu
Next
From: kamal deen
Date:
Subject: Re: How to install specific postgres version / downgrade in Ubuntu