Re: Postgresql logical replication restore

Поиск
Список
Период
Сортировка
От Nikhil Shetty
Тема Re: Postgresql logical replication restore
Дата
Msg-id CAFpL5Vz7KWJqqH40c=yA+RYwc4VKB9Z42F0Or_9E7THod93Hhg@mail.gmail.com
обсуждение исходный текст
Ответ на Postgresql logical replication restore  (Mohammed Afsar <vmdapsar@gmail.com>)
Список pgsql-admin
Hi Afsar,

Logical replication slot will keep all WALs which are not applied on the subscriber. As soon as your subscriber node comes back it should be able to replay from where it left off.

If you remove the slot because WALs are using up the disk then you will have to rebuild. Also, is there any particular scenario you are looking for? There can be multiple reasons logical replication may break.

Thanks,
Nikhil

On Fri, Nov 12, 2021 at 7:11 PM Mohammed Afsar <vmdapsar@gmail.com> wrote:
Dear Team,

We have postgresql logical replication publisher and subscriber configuration in 11 version.

How we need to restore in case replication breaks apart from rebuild the entire replication. 

Is there any possibility of restore the logical replication instead of rebuild without delta data loss.

Regards,
Mohammed Afsar 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Mohammed Afsar
Дата:
Сообщение: Postgresql logical replication restore
Следующее
От: Dirk Krautschick
Дата:
Сообщение: Problems with upgrade from 9.6 to 10 or 11 (column pg_stat_replication.sent_location does not exist)