Logical Replication in PostgreSQL Explained

How CloudNativePG manages physical replication slots for postgres create replication slot 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 postgres drop replication slot By themselves, replication slots occupy very little disk space They just store tiny bit of metadata, including a pointer to a position in WAL

postgresql create replication slot Also on the Supabase database, create a replication slot : 1 select pg_create_logical_replication_slot('example_slot', 'pgoutput