Re: Stupid question about WAL archiving

On Jan 18, 2008, at 2:34 PM, Tom Lane wrote:

> Glyn Astill <glynastill@yahoo.co.uk> writes:
>> I'll set up a cron job to remove them for now, however I'll have a
>> look at pg_standby
>
> Keep in mind that if you delete a log segment that's not yet been sent
> to the standby, you've hosed the standby --- you'll have to take a
> fresh
> base backup and reload the standby with it.  This is probably okay for
> disaster recovery, but you don't want your script creating the
> disaster
> all by itself.

Which is exactly why I pointed out that using pg_standby's -k switch
was the more reliable option.

Erik Jones

DBA | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com