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 <kgri...@ymail.com> wrote: > Pankaj <pankaj.mi...@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 >
