Clean up of archived Xlogs in postgres-9.

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

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