| From: | Greg Smith <gsmith(at)gregsmith(dot)com> |
|---|---|
| To: | Mason Hale <masonhale(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PITR and warm standby setup questions |
| Date: | 2007-11-13 05:07:55 |
| Message-ID: | Pine.GSO.4.64.0711122359090.23904@westnet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 12 Nov 2007, Mason Hale wrote:
> After the wal segment file is copied by the restore_command script, is
> it safe to delete it from my archive?
While I believe you can toss them immediately, you should considering
keeping those around for a bit regardless as an additional layer of
disaster recovery resources. I try to avoid deleting them until a new
base backup is made, because if you have the last backup and all the
archived segments it gives you another potential way to rebuild the
database in case of a large disaster damages both the primary and the
secondary. You can never have too many ways to try and recover from such
a situation.
--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2007-11-13 05:27:36 | Re: Regression in 8.3? |
| Previous Message | Mason Hale | 2007-11-13 04:03:59 | Re: PITR and warm standby setup questions |