Thread: How to install specific postgres version / downgrade in Ubuntu

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

Thanks for your response, 

I would like to get the exact commands to use.

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

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