Re: Stupid question about WAL archiving

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(at)myemma(dot)com> 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(at)myemma(dot)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
>
>
>
>

__________________________________________________________
Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com