Documentation: 16: Streaming Replication Protocol

Replication slots for High Availability A replication slot exists solely on the instance that created it, and PostgreSQL does not replicate it on the standby

Replication allows a client to receive a continuous stream of updates from a PostgreSQL database, providing a near-realtime view of all changes as they occur

postgresql create replication slot The concept of replication slots was introduced in PostgreSQL and was created to prevent a primary instance to delete WAL that a replica

postgres create logical replication slot Create a new replication slot and mark it as used by this backend * * name: Name of the slot * db_specific: logical decoding is db specific; if the slot is