postgresql_replication_slot Resources
postgresql_replication_slot Resources
Answer If you do not see the replication slot under the slot_name column then the slot does not exist There are two potential reasons for this: If you do
The pg_replication_slots view provides a listing of all replication slots that currently exist on the database cluster, along with their current state For more A replication slot is created on the primary database server for each standby server The slot keeps track of the last confirmed receive location of WAL data on
imei (slot 1) 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 HVR uses the following naming convention for these replication slots: hvr_hub_channel_location For example: hvr_myhub_mychn_myloc This should allow multi