Fwd: [PERFORM] Clean up of archived Xlogs in postgres-9.

Поиск
Список
Период
Сортировка
От Nimesh Satam
Тема Fwd: [PERFORM] Clean up of archived Xlogs in postgres-9.
Дата
Msg-id AANLkTi=_+pG1snzoTqFrFW4Vw64pOtkG9BxSj7PsRN4u@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
Дерево обсуждения
Hi all,


We are trying to use the streaming replication of postgres9 and hence we archive the WAL logs in the archive location. But we are not able find the right documentation to clean the archive location.

As suggested by Erik Rijkers we tried using the pg_archivecleanup but we are not sure, from which WAL location should the cleanup take place.

Can anybody suggest how we find which wal logs are safe to be dropped from the archive location while using the pg_archivecleanup or any other options? Any kind of documentation would be of great help.



Regards,
Nimesh.


---------- Forwarded message ----------
From: Erik Rijkers <er@xs4all.nl>
Date: Tue, Sep 28, 2010 at 5:59 PM
Subject: Re: [PERFORM] Clean up of archived Xlogs in postgres-9.
To: Nimesh Satam <nimesh.zedo@gmail.com>
Cc: pgsql-performance@postgresql.org


On Tue, September 28, 2010 12:01, Nimesh Satam wrote:
> Hi,
>
> Can any one of you suggest how the archived Xlogs can be cleaned in
> postgres-9.
>
> We want to use streaming replication and have set the "wal_level" to
> "hot_standby" and "archive_mode" to "on".
>

See contrib/pg_archivecleanup:

http://www.postgresql.org/docs/9.0/static/pgarchivecleanup.html

hth,

Erik Rijkers


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

Предыдущее
От: Carlos Henrique Reimer
Дата:
Сообщение: Debugger log
Следующее
От: Chris Barnes
Дата:
Сообщение: Is there a plugin/script for nagios that monitors pitr being up to djavascript:;ate?