The Insatiable Postgres Replication Slot

website 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 postgresql drop 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 replication slot A replication slot ensures that the WAL will not go away if the replica lags behind Without a replication slot, a primary will recycle its WAL as soon as it  If the max_wal_size parameter is too low, PostgreSQL may delete WAL data before it has been streamed to BigQuery, which can cause the  restart_lsn will also be moved forward if possible For a physical replication slot, this function updates restart_lsn Share

Share

Share

Link

Turn off sharing Copy link

See all details