From: | Marinos Yannikos <mjy(at)geizhals(dot)at> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | WAL archive deletion methodology |
Date: | 2007-12-22 17:02:00 |
Message-ID: | 476D4308.1010202@geizhals.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
when a warm standby "slave" database is being maintained, what is the
best way to keep the WAL archive files from cluttering up the disk?
According to
http://www.postgresql.org/docs/8.2/interactive/warm-standby.html it
seems to me that one could either initiate periodic backups (stop PITR
slave; pg_start_backup() & rsync & pg_stop_backuo(); start recovery) and
delete all files before the "START WAL LOCATION" mentioned in the
*.backup file, or just keep the PITR slave running and use
pg_controldata to identify the files that are no longer needed (although
I'm not sure how to translate a checkpoint location to a WAL archive
filename).
What's a reliable way to do this?
Thanks,
Marinos
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-12-22 17:49:12 | Re: Constraint Trigger's referenced_table |
Previous Message | Richard Broersma Jr | 2007-12-22 16:38:33 | Re: Requirements for Constraint Trigger's Function |