How do I stop/disable PITR and safely clean WAL segments?

From: "Gnanakumar" <gnanam(at)zoniac(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: How do I stop/disable PITR and safely clean WAL segments?
Date: 2011-01-18 05:18:13
Message-ID: 00fe01cbb6cf$1cb1a200$5614e600$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2011-01-18 06:30:39 Re: Migrating a live database
Previous Message Vladislav Geller 2011-01-18 05:07:31 Migrating a live database