| From: | Sam Mason <sam(at)samason(dot)me(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to reduce WAL file Size |
| Date: | 2009-10-09 11:18:40 |
| Message-ID: | 20091009111840.GH5407@samason.me.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rich Shepard | 2009-10-09 12:45:02 | Re: Best data type to use for sales tax percent |
| Previous Message | Sam Mason | 2009-10-09 11:13:27 | Re: Best data type to use for sales tax percent |