PostgreSQL Replication Slots

website postgresql replication slot Logical replication uses a publish and subscribe model with one or more subscribers subscribing to one or more publications on a publisher node Subscribers postgresql replication slot A physical replication slot prevents a source DB instance from removing WAL data before it's consumed by all read replicas Each read replica has its own

postgresql replication slot PostgreSQL Streaming Physical Replication With Slots · Introduction · Create a sandbox with two PostgreSQL servers · Test table · Filling WAL  Persistent Replication Slots: PostgreSQL uses a concept called “replication slots” for logical replication When you create a replication slot  Store replication slot name , type , plugin , database and datoid If PostgreSQL version is 10 or newer also store catalog_xmin and confirmed_flush_lsn When

Share

Share

Link

Turn off sharing Copy link

See all details