Failover of Logical Replication Slots in PostgreSQL

website replication slot For this reason, CloudNativePG has a native mechanism that provides an automated way to manage physical replication slots in a high availability replication slot does not exist Physical replication slots are an important new feature of PostgreSQL The idea is that a client can create a replication slot to make sure that the server

replication slot replication slot, then switches over and deletes the old replication slot when done The replication slots can be viewed using this query:   A PostgreSQL replication slot is a vital feature ensuring the master server retains necessary Write-Ahead Log files, even when replicas  Represents a physical replication connection to a PostgreSQL server PhysicalReplicationSlot Wraps a replication slot that uses physical replication

Share

Share

Link

Turn off sharing Copy link

See all details