Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UDXuI-0005At-Kz for pgsql-admin@arkaria.postgresql.org; Thu, 07 Mar 2013 10:18:39 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UDXuH-0002pS-IF for pgsql-admin@arkaria.postgresql.org; Thu, 07 Mar 2013 10:18:37 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UDXuG-0002pM-DW for pgsql-admin@postgresql.org; Thu, 07 Mar 2013 10:18:36 +0000 Received: from nm14.bullet.mail.ird.yahoo.com ([77.238.189.67]) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UDXuE-0006kF-CQ for pgsql-admin@postgresql.org; Thu, 07 Mar 2013 10:18:35 +0000 Received: from [212.82.105.244] by nm14.bullet.mail.ird.yahoo.com with NNFMP; 07 Mar 2013 10:18:32 -0000 Received: from [46.228.39.58] by tm16.bullet.mail.ird.yahoo.com with NNFMP; 07 Mar 2013 10:18:32 -0000 Received: from [127.0.0.1] by smtp191.mail.ir2.yahoo.com with NNFMP; 07 Mar 2013 10:18:32 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.es; s=s1024; t=1362651512; bh=DBSO91S9BNjWyjjPGJ7ojVRlJJgLGz8Zjfrrx0NbEA8=; h=X-Yahoo-Newman-Id:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:Date:From:To:Subject:Message-Id:In-Reply-To:References:X-Mailer:Mime-Version:Content-Type:Content-Transfer-Encoding; b=lV6Kdcv/S4HddZ7zA/TiE4dI23NVrh/XBzpPdFQHOqE+a3hfSSLQX3+M+vjaecv6oEGyBa8sXOSuckYz+hyP3LDN6agjmgBp9xhn61xuoWKBeEvFNao+8y5VYd39ilVRBnDDCVDBA7VCs1jlnzHPzjc2pu+ci+pOBW8hSZhbTRc= X-Yahoo-Newman-Id: 873180.5051.bm@smtp191.mail.ir2.yahoo.com X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: oisxodEVM1ngbaBoo.28QE2xuZlmXKP2AeJV1wo.L3q_Npb BlaZdYgKBSBaVTPMYgR5ewkPip0QH8qbtFRbqcdJOp05iBcurBci29cjKD9H CsLY6ulzgyAFmij2DdpdeVrTg1VB9K6ZhPPE.xVGeDqmi.B_VdyLzWFmjs6O BAJxSz4oZaCA.wN8LsANlK65dLwDhZeZ5Z5wZCGIGkDrD5v5O1SPHUsWVDRl WxivUO59XtnctdERUss8zYwDjNUQpFPOArzM0C.5..oRnw4yjz6ksbFaK46I byhrv8XsUaAa7MZOAcrqzJsu4iFX30.xz7KdYQoSeMI0clQDXelMakx89a9D CfZEQCxL5AxdIbNV2fCKe7Mdf3bCOBe2zozpiz3kLk0_PoVAAErVKRGF9b33 gqiiFSCw3XGs- X-Yahoo-SMTP: mX392iiswBAeJNdO_s.EW62LZDJR Received: from camibar.xroff.net (emorrasg@85.219.45.252 with plain) by smtp191.mail.ir2.yahoo.com with SMTP; 07 Mar 2013 10:18:32 +0000 UTC Date: Thu, 7 Mar 2013 11:18:34 +0100 From: Eduardo Morras To: pgsql-admin@postgresql.org Subject: Re: HOT Standby - slave does not appear to be removing wal files Message-Id: <20130307111834.5fbda1de419a5f042c13f5b7@yahoo.es> In-Reply-To: <5137F6E7.2000300@consistentstate.com> References: <5137EE26.6010405@consistentstate.com> <5137F6E7.2000300@consistentstate.com> X-Mailer: Sylpheed 3.3.0 (GTK+ 2.24.6; amd64-portbld-freebsd9.1) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.5 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Wed, 06 Mar 2013 19:09:43 -0700 CS DBA wrote: > We actually are in HOT standby mode, and it is working. However we are > also migrating a second db from an older (8.4) server into this master > so we did a dump (using the 9.2.2 pg_dump binary) from the 8.4 db and > then restored it into our current 9.2 master I don't know, but maybe the dump from 8.4 to your master is one big transaction that must be rolled by the slave. So the slave must store all wal files to be able to undo the big dump transaction. --- --- Eduardo Morras -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin