Re: is it safe to clear oroginal xlog after archiving it? - Mailing list pgsql-general

From Simon Riggs
Subject Re: is it safe to clear oroginal xlog after archiving it?
Date
Msg-id 1244135153.23910.231.camel@ebony.2ndQuadrant
Whole thread Raw
In response to is it safe to clear oroginal xlog after archiving it?  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-general
On Thu, 2009-06-04 at 14:42 +0200, hubert depesz lubaczewski wrote:

> if zero-ing the files was safe, i could compress them more effectively.

Simple rule: Never, ever, ever remove or edit any file in pg_xlog.

There is a command called pg_resetxlog, though that is not designed to
reduce the amount of space in pg_xlog and using it can cause data loss
if used inappropriately.

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


pgsql-general by date:

Previous
From: Rastislav Hudak
Date:
Subject: Re: recursive execute
Next
From: Merlin Moncure
Date:
Subject: Re: Using a multi-valued function in a view