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

From: kamal deen <kamaldeendba(at)gmail(dot)com>
To: Zaid Shabbir <zaidshabbir(at)gmail(dot)com>
Cc: Muhammad Usman Khan <usman(dot)k(at)bitnine(dot)net>, pgsql-admin(at)postgresql(dot)org
Subject: Re: How to install specific postgres version / downgrade in Ubuntu
Date: 2024-09-19 11:08:47
Message-ID: CAAGAcEd21VPWG9SR_jtaWLmnqjYmxWNFxYWjRjLq68YHLo=6Zg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Appreciate, Thanks for your response.

SK

On Thu, Sep 19, 2024, 4:01 PM Zaid Shabbir <zaidshabbir(at)gmail(dot)com> wrote:

>
>
> On Thu, Sep 19, 2024 at 3:27 PM kamal deen <kamaldeendba(at)gmail(dot)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(dot)k(at)bitnine(dot)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(at)gmail(dot)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
>>>>
>>>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Narendran .j 2024-09-19 11:16:28 Failover and Failback
Previous Message kamal deen 2024-09-19 11:08:29 Re: How to install specific postgres version / downgrade in Ubuntu