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 On Sat, Nov 23, 2013 at 1:48 AM, Kevin Grittner <kgrittn@xxxxxxxxx> wrote:
Pankaj <pankaj.mimit@xxxxxxxxx> 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
