PostgreSQL Logical replication Practical use case

active f xmin catalog_xmin 937 restart_lsn

This command shows information about logical replication slots that are setup on the database It shows if the slot is active, the state of the WAL sender

replication slot does not exist active active_pid xmin catalog_xmin

replication slot is active for pid Confirm that the connector has created a new replication slot and that it is in active state by querying the pg_replication_slots table Resume the write