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

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
>>>
>>