Re: Lost replication slots after pg_upgrade.

Поиск
Список
Период
Сортировка
От Victor Sudakov
Тема Re: Lost replication slots after pg_upgrade.
Дата
Msg-id YgHkxM8Ocn4F3zWi@admin.sibptus.ru
обсуждение исходный текст
Ответ на Re: Lost replication slots after pg_upgrade.  (Nikhil Shetty <nikhil.dba04@gmail.com>)
Ответы Re: Lost replication slots after pg_upgrade.  (Nikhil Shetty <nikhil.dba04@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Axel Rau
Дата:
Сообщение: Re: restarting logical replication after upgrading standby
Следующее
От: Ram Pratap Maurya
Дата:
Сообщение: PostgreSQL Full Vacuum Taking 5 to 6 hrs.