• PostgreSQL Documentation: max_replication_slots parameter
• How to Use RETURNING Clause in PostgreSQL - CommandPrompt Inc.
• PostgreSQL Replication Monitoring
• Move-Out Information | USH Communities

---

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.