From: | Erik Jones <erik(at)myemma(dot)com> |
---|---|
To: | Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Stupid question about WAL archiving |
Date: | 2008-01-18 18:30:49 |
Message-ID: | D0B63608-BEBD-4495-BD68-EFB35364D54F@myemma.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Zelinskiy Alexander | 2008-01-18 18:50:50 | Re: Postgresql 8.2.4 on linux-sparc problem |
Previous Message | Erik Jones | 2008-01-18 18:23:30 | Re: Replication Using Triggers |