Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 25ADAB5DBC1 for ; Fri, 20 May 2011 12:30:45 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 89707-10 for ; Fri, 20 May 2011 15:30:37 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ww0-f50.google.com (mail-ww0-f50.google.com [74.125.82.50]) by mail.postgresql.org (Postfix) with ESMTP id D7D2FB5DBF1 for ; Fri, 20 May 2011 12:30:36 -0300 (ADT) Received: by wwc33 with SMTP id 33so3812142wwc.19 for ; Fri, 20 May 2011 08:30:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=AKOnESRujExokanka7AmJ2zPzEo4XRAQGfW/bGC5rhk=; b=f6D/nPzpMk3e11COfHkvWJQdhXC1PE1eVSw9Mn7nKY19xVCCh4xfm/9L9BZ7qiMt7K qy3VJ+B1GDe18WB8R/5zUdTeCz3D0LdojQrCNN+vwvBtagCOYwcIgU3qBCPZ8Dwelu6t I9lTPf/u58+F2/du8j3pDk+EJW24wUxrJvtTQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=VTIYvp2CKmYqjxgRgS6Zc8qkPsCRZtR652Rs+fRhzjpIbquDxrOkUDXYSTiJWW41xc Ts3KZl+O27FFyMB5+lyNwGgJoDqvaosFPQBTvb1ujad/LfDg9cS8dF8KChqnPgvjbpxL T4OJF4kD5ygSJ/cCWRMcOLw8IQEef7amBR7rI= MIME-Version: 1.0 Received: by 10.216.230.153 with SMTP id j25mr749316weq.22.1305905435322; Fri, 20 May 2011 08:30:35 -0700 (PDT) Received: by 10.216.179.72 with HTTP; Fri, 20 May 2011 08:30:35 -0700 (PDT) In-Reply-To: References: Date: Sat, 21 May 2011 00:30:35 +0900 Message-ID: Subject: Re: pg_archivecleanup with multiple slaves From: Fujii Masao To: Ben Lancaster Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.898 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RFC_ABUSE_POST=0.001 X-Spam-Level: X-Archive-Number: 201105/131 X-Sequence-Number: 37568 On Fri, May 20, 2011 at 7:59 PM, Ben Lancaster wrote: > The problem I have is that pg_archivecleanup (running on one of the slave= s) was removing WAL logs before the other slave had picked up the changes, = thus breaking replication for the second slave. As an interim fix, I simply= disabled the automatic cleanup and figured I'd worry about it later. I'm afraid there is no clean solution. In order to address this problem, we probably should change the master for 9.2 so that it collects the information about the cutoff point from each standby and calls pg_archivecleanup. Regards, --=20 Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center