what is pg_replication_slot_advance() function in logical replication

created replication slot sub1 on publisher CREATE SUBSCRIPTION mydbops=# On node1: mydbops=# create subscription sub2 CONNECTION 'host

If you use a logical decoding plug-in which supports logical replication messages — like pgoutput since Postgres 14 — then that's all that's

postgresql drop replication slot A replication slot is the mechanism used in this scheme to track progress of a subscription For Aurora PostgreSQL DB clusters, the WAL records are saved on

postgres drop replication slot This is an example using wal2json A replication slot must be created on the PostgreSQL server SELECT * FROM