pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedClean up of archived Xlogs in postgres-9.
3+ messages / 2 participants
[nested] [flat]
* Clean up of archived Xlogs in postgres-9.
@ 2010-09-28 10:01 Nimesh Satam <nimesh.zedo@gmail.com>
2010-09-28 12:29 ` Re: Clean up of archived Xlogs in postgres-9. Erik Rijkers <er@xs4all.nl>
0 siblings, 1 reply; 3+ messages in thread
From: Nimesh Satam @ 2010-09-28 10:01 UTC (permalink / raw)
To: pgsql-performance
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Clean up of archived Xlogs in postgres-9.
2010-09-28 10:01 Clean up of archived Xlogs in postgres-9. Nimesh Satam <nimesh.zedo@gmail.com>
@ 2010-09-28 12:29 ` Erik Rijkers <er@xs4all.nl>
2010-10-22 11:14 ` Fwd: [PERFORM] Clean up of archived Xlogs in postgres-9. Nimesh Satam <nimesh.zedo@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Erik Rijkers @ 2010-09-28 12:29 UTC (permalink / raw)
To: Nimesh Satam <nimesh.zedo@gmail.com>; +Cc: pgsql-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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Fwd: [PERFORM] Clean up of archived Xlogs in postgres-9.
2010-09-28 10:01 Clean up of archived Xlogs in postgres-9. Nimesh Satam <nimesh.zedo@gmail.com>
2010-09-28 12:29 ` Re: Clean up of archived Xlogs in postgres-9. Erik Rijkers <er@xs4all.nl>
@ 2010-10-22 11:14 ` Nimesh Satam <nimesh.zedo@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Nimesh Satam @ 2010-10-22 11:14 UTC (permalink / raw)
To: pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-10-22 11:14 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-09-28 10:01 Clean up of archived Xlogs in postgres-9. Nimesh Satam <nimesh.zedo@gmail.com>
2010-09-28 12:29 ` Erik Rijkers <er@xs4all.nl>
2010-10-22 11:14 ` Nimesh Satam <nimesh.zedo@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox