Essential PostgreSQL Monitoring - Part 1

Replication Slot in Postgres postgresql replication slot Replication in PostgreSQL works by processing WAL files In order for this to work, all WAL files have to be transiently available until they postgresql create replication slot A replication slot is created on the primary database server for each standby server The slot keeps track of the last confirmed receive location of WAL data on

postgresql replication slot When dropping a subscription, the replication slot should be kept This could be useful when the subscriber database is being moved to a different host and will