Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id ADF61632F6D for ; Mon, 16 Feb 2009 13:12:30 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 62986-05 for ; Mon, 16 Feb 2009 13:12:21 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14]) by mail.postgresql.org (Postfix) with ESMTP id 3DB476322D4 for ; Mon, 16 Feb 2009 13:12:20 -0400 (AST) Received: by locust.cns.vt.edu (Postfix, from userid 986) id 5F859118DE9; Mon, 16 Feb 2009 12:12:19 -0500 (EST) Date: Mon, 16 Feb 2009 12:12:19 -0500 From: Ray Stell To: pgsql-admin@postgresql.org Subject: standby role reversal Message-ID: <20090216171219.GA25653@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=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/104 X-Sequence-Number: 31325 I was trying to script a standby role reversal in a 8.3.5 test environment and something didn't go right. After the reverse of roles the new standby said: LOG: invalid resource manager ID in primary checkpoint record but recovery seemed to pick up. I think the old standby did not go down correctly. How big a mess is this and how might I clean it up if that has not already happened?