pg_wal eat disk because inactive replication slot #2012

Amit Kapila amitkapila16gmailcom>, PostgreSQL Hackers pgsql-hackerslistspostgresqlorg>

pg_wal eat disk because inactive replication slot #2012 Replication slots in PostgreSQL are a mechanism for streaming physical and logical replication to keep the standby servers current with

Amit Kapila amitkapila16gmailcom>, PostgreSQL Hackers pgsql-hackerslistspostgresqlorg>

slot naar ajax Physical replication slots were introduced to PostgreSQL with version , while logical replication slots were added beginning with version · The default

True if this is a temporary replication slot Temporary slots are not saved to disk and are automatically dropped on error or when the session has finished

postgresql create replication slot Now a common cause for this kind of issue are replication slots which are not advanced: in that case, Postgres will hold on to all WAL segments

You can list all available replication slots and their details using the pg_replication_slots view SELECT * FROM pg_replication_slots;