Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 89E0EB5DC95
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 17 Oct 2011 10:45:40 -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 49720-08-2; Mon, 17 Oct 2011 13:45:33 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2
X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2
Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14])
	by mail.postgresql.org (Postfix) with ESMTP id 46E46B5DD40;
	Mon, 17 Oct 2011 10:44:57 -0300 (ADT)
Received: by locust.cns.vt.edu (Postfix, from userid 986)
	id A11EF118DD3; Mon, 17 Oct 2011 09:44:56 -0400 (EDT)
Date: Mon, 17 Oct 2011 09:44:56 -0400
From: Ray Stell <stellr@cns.vt.edu>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>, pgsql-docs@postgresql.org
Subject: Re: after failover?
Message-ID: <20111017134456.GA16432@cns.vt.edu>
References: <20111014140248.GB22060@cns.vt.edu>
	<CA+U5nMJpVn0tCohUTroVJRusxiZFoL4yucsSZTES83928aH67g@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CA+U5nMJpVn0tCohUTroVJRusxiZFoL4yucsSZTES83928aH67g@mail.gmail.com>
User-Agent: Mutt/1.5.17 (2007-11-01)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.404 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, RP_MATCHES_RCVD=-0.504
X-Spam-Level: 
X-Archive-Number: 201110/84
X-Sequence-Number: 38536

On Sun, Oct 16, 2011 at 08:21:31PM +0100, Simon Riggs wrote:
> On Fri, Oct 14, 2011 at 3:02 PM, Ray Stell <stellr@cns.vt.edu> wrote:
> 
> > The tutorial here excludes an important issue:
> > http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#Failing_Over_To_The_Standby
> > After the failover is complete, it seems like a restart is required to
> > make the new primary capable of supporting a new hot standby. ?Can the
> > config values be changed without an interuption of service? ?I'm using
> > a hotstandby config in 9.0.x. ?Anything different in this regard in 9.1?
> > Thanks.
> 
> There's no reason not to have  wal_level = hot_standby on the standby also.

That's helpful, thanks.  Seems like a worthy addition to the doc and
tutorial.