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/