From: | FattahRozzaq <ssoorruu(at)gmail(dot)com> |
---|---|
To: | pgsql-cluster-hackers(at)postgresql(dot)org |
Subject: | Can we limit the total size of WAL? |
Date: | 2015-09-09 06:41:22 |
Message-ID: | CAKnA-A1u2k_8Ovh=QGjtp_hege30qGVsAuctEYMCbpQkTGrVrA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2015-09-09 06:52:55 | Re: Can we limit the total size of WAL? |
Previous Message | Rainer Brestan | 2015-08-17 10:16:50 | [pg_rewind] Request for command line switch to prevent removal of stored procedures |