How to setup PostgreSQL Streaming Replication with

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

With the change in Postgres 16, when you're on a standby, you can actually create a logical replication slot There are a few mechanics around

postgres delete replication slot The function pg_create_physical_replication_slot is used to create a physical replication slot This command has to be run in the master node

postgresql replication slot A logical decoding output plug-in You might need to install the output plug-in that you choose to use You must configure a replication slot that uses your