Re: Lost replication slots after pg_upgrade.

From: Victor Sudakov <vas(at)sibptus(dot)ru>
To: Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Lost replication slots after pg_upgrade.
Date: 2022-02-08 03:34:28
Message-ID: YgHkxM8Ocn4F3zWi@admin.sibptus.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Nikhil Shetty wrote:
>
> Thank you for the update. Is there a way we can retain the physical slot
> during and after upgrade?

What exactly are you trying to achieve?

A minor upgrade does not destroy your slots, actually it does not
modify $PGDATA.

A major upgrade requires creating your replicas from scratch with
pg_basebackup (unless you are adventurous enough to go the rsync way).
pg_basebackup can create the slots for you automagically (-C -S) if
they are gone.

--
Victor Sudakov VAS4-RIPE
http://vas.tomsk.ru/
2:5005/49(at)fidonet

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ram Pratap Maurya 2022-02-08 06:25:01 PostgreSQL Full Vacuum Taking 5 to 6 hrs.
Previous Message Axel Rau 2022-02-07 17:00:01 Re: restarting logical replication after upgrading standby