Re: Stupid question about WAL archiving

Поиск
Список
Период
Сортировка
От Darcy Buskermolen
Тема Re: Stupid question about WAL archiving
Дата
Msg-id 200801181018.06877.darcyb@commandprompt.com
обсуждение исходный текст
Ответ на Stupid question about WAL archiving  (Glyn Astill <glynastill@yahoo.co.uk>)
Список 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@postgresql.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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: Forgot to dump old data before re-installing machine
Следующее
От: Erik Jones
Дата:
Сообщение: Re: Replication Using Triggers