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

[Nimesh Satam <nimesh.zedo@xxxxxxxxx>]

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@xxxxxxxxx>
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@xxxxxxxxx>
Cc: pgsql-performance@xxxxxxxxxxxxxx

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