Postgres Pro
Downloads
Home   >   mailing lists

Fwd: [PERFORM] Clean up of archived Xlogs in postgres-9. - Mailing list pgsql-general

From Nimesh Satam
Subject Fwd: [PERFORM] Clean up of archived Xlogs in postgres-9.
Date
Msg-id AANLkTi=_+pG1snzoTqFrFW4Vw64pOtkG9BxSj7PsRN4u@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
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 by date:

Previous
From: Carlos Henrique Reimer
Date:
Subject: Debugger log
Next
From: Chris Barnes
Date:
Subject: Is there a plugin/script for nagios that monitors pitr being up to djavascript:;ate?