Sample Header Ad - 728x90

Why pg_wal dir does not clean up while logical replication

0 votes
1 answer
2658 views
my main question - why pg_wal dir is extremely growing up? I have two postgresql instances. The first was set up as master:
wal_level: "logical"
max_wal_senders: 5
max_replication_slots: 10
Also, I was enable archiving for pg_wal:
archive_mode: on
archive_command: 'gzip  /.../data/pg_wal_archive/%f'
After that, PUBLICATION was created for some of my tables (not ALL TABLES) For replication psql instance - I using default psql config, only created SUBSCRIPTION to master. And I have two questions: 1. I run some script on master, which pulling ~ 10 Gb data to one table, which was **not included** in the PUBLICATION. And, I see, that my pg_wal dir size is increasing anyway. Why? 2. Why pg_wal dir does not cleaning? Is it normal? Looks like I have some data for restore table which is not using in replication, how to delete this data?
Asked by vintik (1 rep)
Aug 12, 2019, 11:46 AM
Last activity: Aug 2, 2025, 11:04 AM