Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id CA17F634677 for ; Wed, 4 Mar 2009 16:34:06 -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 48427-02 for ; Wed, 4 Mar 2009 16:34:03 -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 DDFDE6345ED for ; Wed, 4 Mar 2009 16:34:03 -0400 (AST) Received: by locust.cns.vt.edu (Postfix, from userid 986) id 6EA0B118DDE; Wed, 4 Mar 2009 15:34:02 -0500 (EST) Date: Wed, 4 Mar 2009 15:34:02 -0500 From: Ray Stell To: Simon Riggs Cc: pgsql-admin@postgresql.org Subject: Re: standby waiting for what? Message-ID: <20090304203402.GD25611@cns.vt.edu> References: <20090304200612.GA25611@cns.vt.edu> <20090304201451.GB25611@cns.vt.edu> <1236198676.31880.109.camel@ebony.2ndQuadrant> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1236198676.31880.109.camel@ebony.2ndQuadrant> 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: 200903/52 X-Sequence-Number: 31552 On Wed, Mar 04, 2009 at 08:31:16PM +0000, Simon Riggs wrote: > You've set archive_timeout? > no, but new WAL files seem to be getting created and replicated to the standby, just the pg_standby command seems snagged on something. I probably have done something dumb, ready, fire, aim. I'm more interested in how to analyze the state. Thanks.