Re: Stupid question about WAL archiving

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@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