Backups with continuous archiving

From: runner <runner(at)winning(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Backups with continuous archiving
Date: 2011-03-21 23:50:52
Message-ID: 8CDB639F2168C43-2344-1D92@web-mmc-d04.sysops.aol.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Using Postgres 9.0.3 on Solaris 10 (Sparc). I have a few questions concerning hot backups with continuous archiving. We have read and think we understand the Postgres documentation on backup and restore located here: http://www.postgresql.org/docs/9.0/static/continuous-archiving.html

We plan on doing the following

archive mode is on all the time already

1) run pg_start_backup
2) take a filesystem snapshot of data, wal and archive directories
3) run pg_stop_backup
4) tar up the data directory in the snapshot and then delete the data snapshot
5) tar up the archive directory (not the snapshot)
6) tar up the wal directory (not the snapshot)

Here are my questions:

A) CREATING FILESSYSTEM SNAPSHOTS - We're snapping the data, wal and archive directories. We only plan on using the data snap and that's just so we can perform the backup faster. Will the wal and archive snapshots be useful for anything?

B) DELETING THE OLD ARCHIVE LOGS - After you have the data, wal and archive directories tarred up and saved somewhere, how do you manage the deletion of the old archive logs? Do you run a find command and delete based on the age of the file? What the the best way to manage the removal of old archive logs?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2011-03-22 00:04:06 Re: postgres conferences missing videos?
Previous Message Tomas Vondra 2011-03-21 23:47:28 Re: postgres conferences missing videos?