Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-admin-owner+M41127=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1UfVRM-0007Ce-KJ
	for pgsql-admin@arkaria.postgresql.org; Thu, 23 May 2013 13:20:20 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-admin-owner+M41127=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1UfVRL-0002TQ-SG
	for pgsql-admin@arkaria.postgresql.org; Thu, 23 May 2013 13:20:19 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <sql-pgsql-admin@m.gmane.org>) id 1UfVRI-0002RB-6r
	for pgsql-admin@postgresql.org; Thu, 23 May 2013 13:20:16 +0000
Received: from plane.gmane.org ([80.91.229.3])
	by makus.postgresql.org with esmtp (Exim 4.80)
	(envelope-from <sql-pgsql-admin@m.gmane.org>) id 1UfVRB-0005gS-8O
	for pgsql-admin@postgresql.org; Thu, 23 May 2013 13:20:15 +0000
Received: from list by plane.gmane.org with local (Exim 4.69)
	(envelope-from <sql-pgsql-admin@m.gmane.org>) id 1UfVR4-0004OL-7t
	for pgsql-admin@postgresql.org; Thu, 23 May 2013 15:20:02 +0200
Received: from squid5.ncc.eurodata.de ([212.89.134.21])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-admin@postgresql.org>; Thu, 23 May 2013 15:20:02 +0200
Received: from maletin by squid5.ncc.eurodata.de with local (Gmexim 0.1
	(Debian)) id 1AlnuQ-0007hv-00
	for <pgsql-admin@postgresql.org>; Thu, 23 May 2013 15:20:02 +0200
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-admin@postgresql.org
From: Maletin von Oertzen <maletin@cpan.org>
Subject: Re: HOT Standby - slave does not appear to be removing wal files
Date: Thu, 23 May 2013 13:02:10 +0000 (UTC)
Lines: 34
Message-ID: <loom.20130515T102902-507@post.gmane.org>
References: <5137EE26.6010405@consistentstate.com>
	<CAMBytETi_gNZfY441CDhdqvB0kF_AGVAL2Rn76adNGcZaZXniA@mail.gmail.com>
	<5137F6E7.2000300@consistentstate.com>
	<20130307111834.5fbda1de419a5f042c13f5b7@yahoo.es>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@ger.gmane.org
X-Gmane-NNTP-Posting-Host: sea.gmane.org
User-Agent: Loom/3.14 (http://gmane.org/)
X-Loom-IP: 212.89.134.21 (Mozilla/5.0 (Windows NT 5.1;
	rv:20.0) Gecko/20100101 Firefox/20.0)
X-Pg-Spam-Score: -0.3 (/)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Eduardo Morras <emorrasg <at> yahoo.es> writes:
> 
> On Wed, 06 Mar 2013 19:09:43 -0700
> CS DBA <cs_dba <at> consistentstate.com> 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 <emorrasg <at> yahoo.es>
> 

We have the same problem, when we drop a big schema
and import it again (with \i and autocommit on).
To use pg_basebackup with the option -x, we have
wal_keep_segments set to 32.

And we use pg_archive_cleanup_command:
archive_cleanup_command='/usr/lib/postgresql/9.2/bin/pg_archivecleanup
/var/lib/postgresql/9.2/main/pg_xlog %r'

But we get at least 118 WAL-Files.

In the past, we did not set ssl_renegotiation_limit=0
and the archive_command copied quickly so many
WAL-Files to pg_xlog, that the postgresql-database
stopped with no space left on device /var.
https://bugs.launchpad.net/ubuntu/+source/postgresql-9.1/+bug/1018307



-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin