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
Last activity: Aug 2, 2025, 11:04 AM