Thread: Create replication slot in pg_basebackup if
Thread: Create replication slot in pg_basebackup if
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
created replication slot sub1 on publisher CREATE SUBSCRIPTION mydbops=# On node1: mydbops=# create subscription sub2 CONNECTION 'host Configure logical replication using the slot · Create a publication on the source cluster: CREATE PUBLICATION publication_name> FOR TABLE
main slot pragmatic Replication slots were introduced with PostgreSQL and are designed to ensure that any standby connected to the primary using a replication slot will always Identify the Replication Slot: Before deletion, you must know the name of the replication slot you wish to remove You can list all available replication slots