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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
