Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 2CCE39FBB7F for ; Wed, 13 Jun 2007 13:12:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 06696-01 for ; Wed, 13 Jun 2007 13:12:34 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.243]) by postgresql.org (Postfix) with ESMTP id 9E8709FB59D for ; Wed, 13 Jun 2007 13:12:41 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so50811ana for ; Wed, 13 Jun 2007 09:12:39 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=JX6LBUPwrM6eOpw24m9wfozPqfN0si4tfzuaL5a9gvhi80DXhkVYLUUc8WMtx+0szsjB4jeoThuXUi2rfJMxSWZGEdmebVyxiUze/2pNfGrwZMK6qCXbNjBDs3wKbLASxlq8bKoeSLrcrTcCmMa9wpTDMbXpGslb4Apy54mmaXM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=ZTu9sgJyQVVBypbqo+uAmR9LCXYI7KBem5WW7xav+BHypjYWKTBDUi2ibRZpjcZerrnorFoZL5s593fGSXcuMUtbVzuEG1MXc4TyjzZnTW7H5mIQ5bBkhr0IFjQLybYYurXpqdcaqZCf7fZqhi3vj1Mfmz6Cd48tQ0pUkL0drZk= Received: by 10.100.191.5 with SMTP id o5mr461308anf.1181751159807; Wed, 13 Jun 2007 09:12:39 -0700 (PDT) Received: by 10.100.134.10 with HTTP; Wed, 13 Jun 2007 09:12:39 -0700 (PDT) Message-ID: Date: Wed, 13 Jun 2007 12:12:39 -0400 From: "Michael Dengler" To: "Merlin Moncure" Subject: Re: WAL shipping and ever expanding pg_xlog Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_31776_15747351.1181751159761" References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/239 X-Sequence-Number: 25272 ------=_Part_31776_15747351.1181751159761 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Doug Knight just informed me about the pg_standby module. Works like a charm! Thanks Mike On 6/13/07, Merlin Moncure wrote: > > On 6/13/07, Michael Dengler wrote: > > OK....it looks like the slave machine has run out of space and that > caused > > the xlog files to pile up on the master. > > > > Still...how do I prevent such all of the shipped WAL segments from > remaining > > on the slave machine? Do I need to retain every single one? Can they be > > safely removed after the slave machine has restored the particular > segment? > > Are you using the pg_standy utility? It has options to control this... > > merlin > ------=_Part_31776_15747351.1181751159761 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Doug Knight just informed me about the pg_standby module.

Works like a charm!

Thanks

Mike


On 6/13/07, Merlin Moncure < mmoncure@gmail.com> wrote:
On 6/13/07, Michael Dengler < michael.dengler@gmail.com> wrote:
> OK....it looks like the slave machine has run out of space and that caused
> the xlog files to pile up on the master.
>
> Still...how do I prevent such all of the shipped WAL segments from remaining
> on the slave machine? Do I need to retain every single one? Can they be
> safely removed after the slave machine has restored the particular segment?

Are you using the pg_standy utility?  It has options to control this...

merlin

------=_Part_31776_15747351.1181751159761--