Re: Stupid question about WAL archiving - Mailing list pgsql-general

From Tom Lane
Subject Re: Stupid question about WAL archiving
Date
Msg-id 12378.1200688479@sss.pgh.pa.us
Whole thread Raw
In response to Re: Stupid question about WAL archiving  (Glyn Astill <glynastill@yahoo.co.uk>)
Responses Re: Stupid question about WAL archiving  (Erik Jones <erik@myemma.com>)
List pgsql-general
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.

            regards, tom lane

pgsql-general by date:

Previous
From: "Marko Kreen"
Date:
Subject: Re: plpythonu
Next
From: Andrew Sullivan
Date:
Subject: Re: Replication Using Triggers