Re: Postgresql logical replication restore

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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 

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux