Re: Postgresql logical replication restore

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(at)gmail(dot)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
>