Обсуждение: Postgresql logical replication restore
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
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