From: Gnanakumar <gnanam@zoniac.com>
To: pgsql-admin@postgresql.org
Subject: How do I stop/disable PITR and safely clean WAL segments?
Date: Tue, 18 Jan 2011 10:48:13 +0530
Message-ID: <00fe01cbb6cf$1cb1a200$5614e600$@com> (raw)
Hi,
Our production server is running PostgreSQL v8.2.3 on CentOS release 5.2
(Final).
We've setup PITR in our production server. For some reasons, after setting
up PITR, we're not able to manage and maintain it. Eventually, our WAL
archive drive (secondary drive) has become full (100% use) and additional
WAL archive segments that are to be archived got accumulated in pg_xlog/
directory itself (which is available in primary drive)
PITR SETUP DETAILS
There are 2 drives:
1. Primary drive (pgsql/data/ directory resides) is 400 GB.
2. Secondary drive (WAL archives) is 300 GB. All WAL archives are written
to this secondary drive.
Now, we've decided to stop/disable PITR.
My question is, in this situation, how do I stop/disable PITR and safely
clean up all WAL segments from both the drives?
What are the recommended/suggested ways? Experts advice/idea/suggestion on
this are highly appreciated.
Regards,
Gnanam
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gnanam@zoniac.com
Subject: Re: How do I stop/disable PITR and safely clean WAL segments?
In-Reply-To: <00fe01cbb6cf$1cb1a200$5614e600$@com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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