postgreSQL logical replication backup and restore


I have a logical replication setup from node A to node B , both have postgreSQL version (11.10)

Is there a way that we can restore our logical replication to the current state from point in time backups taken of the replica before.

Suppose I have a point in time backup of the replica saved in some other directory. I can start that instance as a standalone node and can I run the logical replication process again from where that replica’s latest lsn is? Unlike streaming replication, I dont think we have an option to replay the wals in logical replication.

The reason is I don’t want to rebuild the whole logical replica node in case of data corruption or node outage as the data size is large.

1 Like