How To Configure PostgreSQL 12 Streaming Replication in CentOS 8

This tutorial assumes you have already setup streaming replication between a primary and a replica PostgreSQL server If you need to set that up first, run

replication slot, increasing this value just causes a different connection error saying the replication slot is already in use Here is the

replication slot postgres replication table > synchronization worker for subscription slot > pg_37986_sync_37922_7210774007126708177 already exists

replication slot Attempting to drop a non-existent replication slot: postgres=# SELECT pg_drop_replication_slot; ERROR: replication slot foo does not exist