WAL archive deletion methodology

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

Browse pgsql-general by date

  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