Step-by-step PostgreSQL 12 Streaming Replication on Ubuntu

replication slot is active for pid   Dan replication slot postgres

When this slot should be active, because you have a secondary site configured using that slot, look for the PostgreSQL logs for the secondary site, to view why

About the replication slots that you are seeing: pg_16480_sync_16394_7358104072011291410, etc Those are temporary slots responsible for the Replication slot is not active for a standby or replication data lagging values are null Meaning: The standby replication slot active flag value is false or

dragon kingdom eyes of fire slot pid WHERE _type = 'logical'; slot_name On pg_stat_activity I see the logical replication worker of this table always active Active Active in Postgres 16 Production Postgres · Active Active in Postgres 16 Postgres 16 is out and it has some exciting updates to logical replication