Can we limit the total size of WAL?
От | FattahRozzaq |
---|---|
Тема | Can we limit the total size of WAL? |
Дата | |
Msg-id | CAKnA-A1u2k_8Ovh=QGjtp_hege30qGVsAuctEYMCbpQkTGrVrA@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Can we limit the total size of WAL?
|
Список | pgsql-cluster-hackers |
Hi all, I hope this email finds you well. I'm new to PostgreSQL, please correct me if I'm mislead/incorrect. I have setup streaming replication using WAL The archive_command that was generated by Postgres-XL in postgresql.conf was: archive_command = 'rsync %p postgres@node03:/home/postgres/PGXL/nodes/datanodearchlog/02/%f' If I run check the total size of the folder in datanode master, it contains only 14GB: # du -sh /home/postgres/PGXL/nodes/datanodemaster/03/ 14G /home/postgres/PGXL/nodes/datanodemaster/03/ But if I check the total size of the archive folder in datanode slave, it contains 90GB, each file has 16MB size, with total files 5749: # du -sh /home/postgres/PGXL/nodes/datanodearchlog/03/ 90G /home/postgres/PGXL/nodes/datanodearchlog/03/ # ls -al /home/postgres/PGXL/nodes/datanodearchlog/03/ | grep 16777216 | wc -l 5749 How to limit the amount of files generated by WAL archiving? Or maybe if we can, how to recycle the files generated by WAL archiving? Thank you, FattahRozzaq
В списке pgsql-cluster-hackers по дате отправления: