public inbox for [email protected]  
help / color / mirror / Atom feed
How to install specific postgres version / downgrade in Ubuntu
6+ messages / 3 participants
[nested] [flat]

* How to install specific postgres version / downgrade in Ubuntu
@ 2024-09-19 09:59 kamal deen <[email protected]>
  2024-09-19 10:05 ` Re: How to install specific postgres version / downgrade in Ubuntu Muhammad Usman Khan <[email protected]>
  0 siblings, 1 reply; 6+ messages in thread

From: kamal deen @ 2024-09-19 09:59 UTC (permalink / raw)
  To: pgsql-admin

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


^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: How to install specific postgres version / downgrade in Ubuntu
  2024-09-19 09:59 How to install specific postgres version / downgrade in Ubuntu kamal deen <[email protected]>
@ 2024-09-19 10:05 ` Muhammad Usman Khan <[email protected]>
  2024-09-19 10:26   ` Re: How to install specific postgres version / downgrade in Ubuntu kamal deen <[email protected]>
  0 siblings, 1 reply; 6+ messages in thread

From: Muhammad Usman Khan @ 2024-09-19 10:05 UTC (permalink / raw)
  To: kamal deen <[email protected]>; +Cc: pgsql-admin

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 <[email protected]> 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
>


^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: How to install specific postgres version / downgrade in Ubuntu
  2024-09-19 09:59 How to install specific postgres version / downgrade in Ubuntu kamal deen <[email protected]>
  2024-09-19 10:05 ` Re: How to install specific postgres version / downgrade in Ubuntu Muhammad Usman Khan <[email protected]>
@ 2024-09-19 10:26   ` kamal deen <[email protected]>
  2024-09-19 10:31     ` Re: How to install specific postgres version / downgrade in Ubuntu Zaid Shabbir <[email protected]>
  2024-09-19 11:08     ` Re: How to install specific postgres version / downgrade in Ubuntu kamal deen <[email protected]>
  0 siblings, 2 replies; 6+ messages in thread

From: kamal deen @ 2024-09-19 10:26 UTC (permalink / raw)
  To: Muhammad Usman Khan <[email protected]>; +Cc: pgsql-admin

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 <[email protected]>
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 <[email protected]> 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
>>
>


^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: How to install specific postgres version / downgrade in Ubuntu
  2024-09-19 09:59 How to install specific postgres version / downgrade in Ubuntu kamal deen <[email protected]>
  2024-09-19 10:05 ` Re: How to install specific postgres version / downgrade in Ubuntu Muhammad Usman Khan <[email protected]>
  2024-09-19 10:26   ` Re: How to install specific postgres version / downgrade in Ubuntu kamal deen <[email protected]>
@ 2024-09-19 10:31     ` Zaid Shabbir <[email protected]>
  2024-09-19 11:08       ` Re: How to install specific postgres version / downgrade in Ubuntu kamal deen <[email protected]>
  1 sibling, 1 reply; 6+ messages in thread

From: Zaid Shabbir @ 2024-09-19 10:31 UTC (permalink / raw)
  To: kamal deen <[email protected]>; +Cc: Muhammad Usman Khan <[email protected]>; pgsql-admin

On Thu, Sep 19, 2024 at 3:27 PM kamal deen <[email protected]> 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 <[email protected]>
> 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 <[email protected]> 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
>>>
>>


^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: How to install specific postgres version / downgrade in Ubuntu
  2024-09-19 09:59 How to install specific postgres version / downgrade in Ubuntu kamal deen <[email protected]>
  2024-09-19 10:05 ` Re: How to install specific postgres version / downgrade in Ubuntu Muhammad Usman Khan <[email protected]>
  2024-09-19 10:26   ` Re: How to install specific postgres version / downgrade in Ubuntu kamal deen <[email protected]>
  2024-09-19 10:31     ` Re: How to install specific postgres version / downgrade in Ubuntu Zaid Shabbir <[email protected]>
@ 2024-09-19 11:08       ` kamal deen <[email protected]>
  0 siblings, 0 replies; 6+ messages in thread

From: kamal deen @ 2024-09-19 11:08 UTC (permalink / raw)
  To: Zaid Shabbir <[email protected]>; +Cc: Muhammad Usman Khan <[email protected]>; pgsql-admin

Appreciate, Thanks for your response.

SK

On Thu, Sep 19, 2024, 4:01 PM Zaid Shabbir <[email protected]> wrote:

>
>
> On Thu, Sep 19, 2024 at 3:27 PM kamal deen <[email protected]> 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 <[email protected]>
>> 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 <[email protected]>
>>> 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
>>>>
>>>


^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: How to install specific postgres version / downgrade in Ubuntu
  2024-09-19 09:59 How to install specific postgres version / downgrade in Ubuntu kamal deen <[email protected]>
  2024-09-19 10:05 ` Re: How to install specific postgres version / downgrade in Ubuntu Muhammad Usman Khan <[email protected]>
  2024-09-19 10:26   ` Re: How to install specific postgres version / downgrade in Ubuntu kamal deen <[email protected]>
@ 2024-09-19 11:08     ` kamal deen <[email protected]>
  1 sibling, 0 replies; 6+ messages in thread

From: kamal deen @ 2024-09-19 11:08 UTC (permalink / raw)
  To: Muhammad Usman Khan <[email protected]>; +Cc: pgsql-admin

Appreciate,  Thanks for your response.

SK

On Thu, Sep 19, 2024, 3:56 PM kamal deen <[email protected]> wrote:

> 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 <[email protected]>
> 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 <[email protected]> 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
>>>
>>


^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2024-09-19 11:08 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-09-19 09:59 How to install specific postgres version / downgrade in Ubuntu kamal deen <[email protected]>
2024-09-19 10:05 ` Muhammad Usman Khan <[email protected]>
2024-09-19 10:26   ` kamal deen <[email protected]>
2024-09-19 10:31     ` Zaid Shabbir <[email protected]>
2024-09-19 11:08       ` kamal deen <[email protected]>
2024-09-19 11:08     ` kamal deen <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox