Re: How to reduce WAL file Size

On Thu, Oct 08, 2009 at 11:48:29PM -0700, Mitesh51 wrote:
> I am dealing with backup of databases. Now eventhough there are not many
> changes in the DB, it creates WAL file of 16 mb. Now because I am working on
> a application which takes full & inc backup of db after specific
> intervals..if for small changes it creates 16 mb files then storing them
> will eat up lot many space.

I think the following utility would help you here:

  http://pgfoundry.org/projects/clearxlogtail/

Also I'd recommend reading the articles Alban pointed to, it can be
somewhat tricky to backup PG correctly.

--
  Sam  http://samason.me.uk/