postgresql select replication slots
PostgreSQL: Documentation: 17: 52.19. pg_replication_slots
CREATE USER replicator WITH REPLICATION ENCRYPTED PASSWORD 'replicator_password'; SELECT pg_create_physical_replication_slot('repl. ...
How to gain insight into the pg_stat_replication_slots view by examining logical replication
Takamichi Osumi explains how to pg_stat_replication_slots to gain a better understanding of how logical replication is carried out by PostgreSQL.
PostgreSQL: Documentation: 16: 20.6. Replication
The maximum number of replication slots in PostgreSQL is controlled by the ‘max_replication_slots’ configuration parameter.
PostgreSQL: Documentation: 17: 9.28. System Administration Functions
One of the interesting new features in PostgreSQL for some time now is the ability to control removal of WAL files using replication slots.