Re: Lost replication slots after pg_upgrade. - Mailing list pgsql-admin

From Victor Sudakov
Subject Re: Lost replication slots after pg_upgrade.
Date
Msg-id YgHkxM8Ocn4F3zWi@admin.sibptus.ru
Whole thread Raw
In response to Re: Lost replication slots after pg_upgrade.  (Nikhil Shetty <nikhil.dba04@gmail.com>)
Responses Re: Lost replication slots after pg_upgrade.  (Nikhil Shetty <nikhil.dba04@gmail.com>)
List 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@fidonet



pgsql-admin by date:

Previous
From: Axel Rau
Date:
Subject: Re: restarting logical replication after upgrading standby
Next
From: Ram Pratap Maurya
Date:
Subject: PostgreSQL Full Vacuum Taking 5 to 6 hrs.