Re: Lost replication slots after pg_upgrade.

Hi Victor,

I am doing a major version upgrade from pg 11 to 13. The point is if I lose
the replication slot after upgrade then how will I sync standby from
primary after rsync.

I can create the slot after upgrading but won't there be dataloss?

pg_basebackup takes time for large databases (> 5TB). I feel rsync should
be faster.

Thanks,
Nikhil

On Tue, Feb 8, 2022 at 9:04 AM Victor Sudakov <vas(at)sibptus(dot)ru> wrote:

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