From: | Darcy Buskermolen <darcyb(at)commandprompt(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Stupid question about WAL archiving |
Date: | 2008-01-18 18:18:06 |
Message-ID: | 200801181018.06877.darcyb@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Friday 18 January 2008 09:17:10 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?
either delete them yourself, use a cron job to delete them (something like
find . -mtime 60 -delete) , or if you are using pg_standby look at -k (which
specifies the number of old files to keep
>
>
> ___________________________________________________________
> Yahoo! Answers - Got a question? Someone out there knows the answer. Try it
> now.
> http://uk.answers.yahoo.com/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
--
Darcy Buskermolen
Command Prompt, Inc.
+1.503.667.4564 X 102
http://www.commandprompt.com/
PostgreSQL solutions since 1997
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Jones | 2008-01-18 18:23:30 | Re: Replication Using Triggers |
Previous Message | Dave Page | 2008-01-18 18:15:28 | Re: Forgot to dump old data before re-installing machine |