On Jan 18, 2008, at 2:34 PM, Tom Lane wrote:
Glyn Astill <glynastill@xxxxxxxxxxx> 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@xxxxxxxxxx
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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
