Thanks Erik, I'll set up a cron job to remove them for now, however I'll have a look at pg_standby --- Erik Jones <erik@xxxxxxxxxx> wrote: > On Jan 18, 2008, at 11:17 AM, Glyn Astill wrote: > > > My server ran out of disk space because my archive directory was > full > > ow write ahead logs. > > > > My warm standby had lost it's mounted NFS volume and thus stopped > > reading in the archives from the master. > > > > Would I have run out of space if the standby hadn't stopped > reading > > them in? > > > > I.e, should I be deleting the old logs myself or should the warm > > standby be managing them? > > Depends on what you're using run your warm standby in your > recovery.conf. pg_standby has the -k flag for NUMFILESTOKEEP. > Where > I work, we have a cron job that deletes WAL archives more than > three > days old. Admittedly, using pg_standby's -k option is probably > more > reliable. > > 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 > > > > __________________________________________________________ Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
