PostgreSQL 12: Copying replication slots
PostgreSQL 12: Copying replication slots
The solution is replication slots, a feature provided by Postgres that ensures the primary server only discards WAL records after they have been received by the
DROP REPLICATION SLOT replication_slot; CREATE REPLICATION SLOT replication_slot LOGICAL; Note: Make sure to replace replication_slot with The solution is replication slots, a feature provided by Postgres that ensures the primary server only discards WAL records after they have been received by the
is there a trick to slot machines To ensure that WAL segments are not discarded before being sent to all consumers, PostgreSQL uses logical replication slots to track which data was sent to 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