PostgreSQL Documentation: max_replication_slots parameter
Postgres comes with built-in support for replication via publications and replication slots. Refer to the Concepts and terms section to learn how replication works.
How to Use RETURNING Clause in PostgreSQL - CommandPrompt Inc.
In Postgres, the “RETURNING” clause is used with the INSERT, DELETE or UPDATE queries to retrieve the newly inserted, deleted, or updated data.
PostgreSQL Replication Monitoring
postgres=# select usename,application_name,client_addr,back from pg_stat_replication ; usename | application_name | client_addr | backend_start | state | sync_state.
Move-Out Information | USH Communities
As Debezium processes logical decoding messages, it reports the last successfully consumed message back to Postgres, which tracks this in the pg_replication_slots table.