Thread: Clean up of archived Xlogs in postgres-9.

Clean up of archived Xlogs in postgres-9.

From
Nimesh Satam
Date:
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".

Regards,
Nimesh.

Re: Clean up of archived Xlogs in postgres-9.

From
"Erik Rijkers"
Date:
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