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 по дате отправления:

Предыдущее
От: "Rainer Brestan"
Дата:
Сообщение: [pg_rewind] Request for command line switch to prevent removal of stored procedures
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Can we limit the total size of WAL?