Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id F08F9B5DC19 for ; Fri, 14 Oct 2011 11:02:54 -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 23791-03 for ; Fri, 14 Oct 2011 14:02:48 +0000 (UTC) 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 881B9B5DBDE for ; Fri, 14 Oct 2011 11:02:48 -0300 (ADT) Received: by locust.cns.vt.edu (Postfix, from userid 986) id B2B00118E38; Fri, 14 Oct 2011 10:02:48 -0400 (EDT) Date: Fri, 14 Oct 2011 10:02:48 -0400 From: Ray Stell To: pgsql-admin@postgresql.org Subject: after failover? Message-ID: <20111014140248.GB22060@cns.vt.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline 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/75 X-Sequence-Number: 38527 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.