Re: pg_xlog is getting bigger - Mailing list pgsql-general

From Pankaj Mishra
Subject Re: pg_xlog is getting bigger
Date
Msg-id CADgijrguDpk_Xg=XBeH2mNHtOYLJvz=QGmchT4xx1de+sg4epQ@mail.gmail.com
Whole thread Raw
In response to Re: pg_xlog is getting bigger  (Kevin Grittner <kgrittn@ymail.com>)
Responses Re: pg_xlog is getting bigger
Re: pg_xlog is getting bigger
List pgsql-general
Dera Kevin,

If you run checkpoint in database then you can delete the pg_xlog other then current timestamp. We do this to our customer on regular basis when pg_xlog exceed more then 15 gb
Regards
Pankaj


On Sat, Nov 23, 2013 at 1:48 AM, Kevin Grittner <kgrittn@ymail.com> wrote:
Pankaj <pankaj.mimit@gmail.com> wrote:

> now go to pg_xlog folder you can can see a pattern in file names of logs.
> Just remove the file other then current time stamp. Or for safety remove
> logs other then current date.

No!!!  NEVER remove ANY files from the pg_xlog sub-directory!  That
will corrupt your database.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-general by date:

Previous
From: "Mahlon E. Smith"
Date:
Subject: Re: Streaming replication slave crash
Next
From: Tobadao
Date:
Subject: Slony-I installation Help !