pg_wal eat disk because inactive replication slot #2012

DROP TABLE removes tables from the database Only the table owner, the schema owner, and superuser can drop a table To empty a table of rows without destroying

Postgresql during DELETE events, it is necessary to configure the replication identity of the tables Postgres offers 4 different types of REPLICA IDENTITY

postgresql replication slot Specify that this replication slot is a temporary one Temporary slots are not saved to disk and are automatically dropped on error or when the session has

postgresql create replication slot After you complete your testing, drop the replication slot you created by running: -d postgres --slot test_slot --drop-slot Notes and limitations