Skip site navigation (1) Skip section navigation (2)

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

From: "Erik Rijkers" <er(at)xs4all(dot)nl>
To: "Nimesh Satam" <nimesh(dot)zedo(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Clean up of archived Xlogs in postgres-9.
Date: 2010-09-28 12:29:47
Message-ID: 38e67d2e089857373f9bf8170911a368.squirrel@webmail.xs4all.nl (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
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


In response to

Responses

pgsql-performance by date

Next:From: Robert HaasDate: 2010-09-28 16:03:10
Subject: Re: Query much faster with enable_seqscan=0
Previous:From: Nimesh SatamDate: 2010-09-28 10:01:13
Subject: Clean up of archived Xlogs in postgres-9.

pgsql-general by date

Next:From: Dave PageDate: 2010-09-28 12:35:34
Subject: Re: PostgreSQL 9 Mac OS X one-click install - PL/perl broken
Previous:From: Peter EisentrautDate: 2010-09-28 12:27:12
Subject: Re: ECPG - Some errno definitions don't match to the manual

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group