How to Set Up PostgreSQL Streaming Replication

website postgresql replication slot postgresql_slot module postgresql drop 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 replication slot Replication slots are marked as 'inactive' when the replication client connected to the slot disconnects Inactive replication slots cause WAL files to be  It's about 10 tables in the schema, so that means 11 replication slots per subscriber cluster So in production could be up to 99 slots, let's  Physical slots are created automatically based on replica hosts and used for data replication within the Managed Service for PostgreSQL cluster

Share

Share

Link

Turn off sharing Copy link

See all details