Skip site navigation (1) Skip section navigation (2)

Re: Decreasing WAL size effects

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: Jason Long <mailing(dot)list(at)supernovasoftware(dot)com>, pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Decreasing WAL size effects
Date: 2008-10-30 17:13:16
Message-ID: 1225386796.32621.23.camel@jd-laptop.pragmaticzealot.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
On Wed, 2008-10-29 at 09:05 -0400, Greg Smith wrote:
> On Tue, 28 Oct 2008, Jason Long wrote:
> 
> > I also have to ship them off site using a T1 so setting the time to 
> > automatically switch files will just waste bandwidth if they are still going 
> > to be 16 MB anyway.
> 
> The best way to handle this is to clear the unused portion of the WAL file 
> and then compress it before sending over the link.  There is a utility 
> named pg_clearxlogtail available at 
> http://www.2ndquadrant.com/replication.htm that handles the first part of 
> that you may find useful here.
> 
> This reminds me yet again that pg_clearxlogtail should probably get added 
> to the next commitfest for inclusion into 8.4; it's really essential for a 
> WAN-based PITR setup and it would be nice to include it with the 
> distribution.

What is to be gained over just using rsync with -z?

Joshua D. Drake

> 
> --
> * Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
> 
-- 


In response to

Responses

pgsql-hackers by date

Next:From: Jonah H. HarrisDate: 2008-10-30 17:13:17
Subject: Re: Block-level CRC checks
Previous:From: Robert HaasDate: 2008-10-30 17:11:42
Subject: Re: WIP patch: convert SQL-language functions to return tuplestores

pgsql-general by date

Next:From: Glyn AstillDate: 2008-10-30 17:27:58
Subject: bytea field, a c function and pgcrypto driving me mad
Previous:From: Joshua D. DrakeDate: 2008-10-30 15:54:23
Subject: Re: Are there plans to add data compression feature to postgresql?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group