Re: Postgresql logical replication restore - Mailing list pgsql-admin

From Nikhil Shetty
Subject Re: Postgresql logical replication restore
Date
Msg-id CAFpL5Vz7KWJqqH40c=yA+RYwc4VKB9Z42F0Or_9E7THod93Hhg@mail.gmail.com
Whole thread Raw
In response to Postgresql logical replication restore  (Mohammed Afsar <vmdapsar@gmail.com>)
List 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 by date:

Previous
From: Mohammed Afsar
Date:
Subject: Postgresql logical replication restore
Next
From: Dirk Krautschick
Date:
Subject: Problems with upgrade from 9.6 to 10 or 11 (column pg_stat_replication.sent_location does not exist)