PostgreSQL Logical Replication Gotchas

Creating a publication and a slot Postgres requires all replicas to register themselves ahead of time in a two-step process First, create a

PostgreSQL Logical Replication Gotchas No more configuration is needed on the secondary server Finally, we created a replication slot What is the purpose of a replication slot in PostgreSQL?

Creating a publication and a slot Postgres requires all replicas to register themselves ahead of time in a two-step process First, create a

postgres replication slot Replication allows a client to receive a continuous stream of updates from a PostgreSQL database, providing a near-realtime view of all changes as they occur

Orphaned Replication Slot: The WAL files are retained by the master when the replica disconnects This also means that the pg_wal directory may

postgresql replication slot Resolution · Turn on logical replication · Connect to source database in source DB instance · Create a publication for source tables · Connect to target database

By themselves, replication slots occupy very little disk space They just store tiny bit of metadata, including a pointer to a position in WAL