Physical Replication Mechanisms in PostgreSQL

website postgresql create replication slot Replication slots for High Availability A replication slot exists solely on the instance that created it, and PostgreSQL does not replicate it on the standby postgresql create replication slot A replication slot is a feature in PostgreSQL that ensures that the master server will retain the WAL logs that are needed by the replicas

postgresql create replication slot Allow you to replicate data out of Postgres · Use the write-ahead log as the source of changes · Use logical replication slots to send out  Streaming replication in PostgreSQL involves creating an active copy of a database on a database instance This copy, commonly called a  The function pg_create_physical_replication_slot is used to create a physical replication slot This command has to be run in the master node

Share

Share

Link

Turn off sharing Copy link

See all details