Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 2EC031337B2F
	for <pgsql-hackers-postgresql.org@mail.postgresql.org>;
	Tue, 26 Oct 2010 22:59:44 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 10915-08
	for <pgsql-hackers-postgresql.org@mail.postgresql.org>;
	Wed, 27 Oct 2010 01:59:37 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from glacier.frostconsultingllc.com (glacier.frostconsultingllc.com
	[69.36.227.170])
	by mail.postgresql.org (Postfix) with ESMTP id DDF25133798E
	for <pgsql-hackers@postgresql.org>;
	Tue, 26 Oct 2010 22:59:36 -0300 (ADT)
Received: from dsl081-245-111.sfo1.dsl.speakeasy.net ([64.81.245.111]
	helo=Sidney-Stratton.local)
	by glacier.frostconsultingllc.com with esmtpsa
	(TLSv1:CAMELLIA256-SHA:256) (Exim 4.69)
	(envelope-from <josh@agliodbs.com>)
	id 1PAvIX-0002fo-Oh; Tue, 26 Oct 2010 18:59:31 -0700
Message-ID: <4CC78781.4000206@agliodbs.com>
Date: Tue, 26 Oct 2010 18:59:29 -0700
From: Josh Berkus <josh@agliodbs.com>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US;
	rv:1.9.1b3pre) Gecko/20090223 Thunderbird/3.0b2
MIME-Version: 1.0
To: Robert Haas <robertmhaas@gmail.com>
CC: Simon Riggs <simon@2ndquadrant.com>, Greg Stark <gsstark@mit.edu>,
	Bruce Momjian <bruce@momjian.us>, pgsql-hackers@postgresql.org
Subject: Re: Simplifying replication
References: <201010220022.o9M0M8Q29438@momjian.us>
	<4CC0DEDE.7060707@agliodbs.com>
	<AANLkTin0RfGOvk20vLYYfCDzdf5Sf94aQ5V-xOBB+Kqx@mail.gmail.com>
	<AANLkTik-L-68UpwgyBh5HtROzkEYQ297fiy7C-c6qRfX@mail.gmail.com>
	<1288096049.1587.253.camel@ebony>
	<AANLkTi=Usaoa6aZ7jSuunFLpPssKZqcRb-f_6FJ6Xz4C@mail.gmail.com>
In-Reply-To: <AANLkTi=Usaoa6aZ7jSuunFLpPssKZqcRb-f_6FJ6Xz4C@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.419 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	FS_REPLICA=3.599, SARE_SPEC_REPLICA=0.72
X-Spam-Level: **
X-Archive-Number: 201010/1916
X-Sequence-Number: 172956


> If you set wal_keep_segments=0, archive_mode=on, and
> archive_command=<something>, you might run out of disk space.
> 
> If you set wal_keep_segments=-1, you might run out of disk space.
> 
> Are you any more screwed in the second case than you are in the first
> case?

It is the same to the user either way.  In either case you have to
change some settings and restart the master.

Well, for the archive case, you could conceivably mass-delete the
archive files.

-- 
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com