How to setup PostgreSQL Streaming Replication with

PostgreSQL and later come with a feature called “replication slots” They can be used to make WAL archiving and streaming replication

Replication Slots Replication slots were introduced in Postgres They are a mechanism to accurately and durably keep track of how far a standby is lagging

start replication slot postgres I have 2 logical replication slots in Postgres 12 Suddenly one of them failed couple of days ago

start_replication slot start consuming it and moving the cursor set in the replication slot forward Putting it all together With the WAL sorted, we're able to