Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 0A8D163350E for ; Wed, 4 Mar 2009 16:27: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 37884-09 for ; Wed, 4 Mar 2009 16:27:24 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail137142.authsmtp.co.uk (outmail137142.authsmtp.co.uk [62.13.137.142]) by mail.postgresql.org (Postfix) with ESMTP id 57397632FD8 for ; Wed, 4 Mar 2009 16:27:23 -0400 (AST) Received: from mail-c187.authsmtp.com (mail-c187.authsmtp.com [62.13.128.33]) by punt6.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n24KRIaj005937; Wed, 4 Mar 2009 20:27:18 GMT Received: from [192.168.0.3] (85-211-101-172.dyn.gotadsl.co.uk [85.211.101.172]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n24KRI3q022334; Wed, 4 Mar 2009 20:27:18 GMT Subject: Re: standby waiting for what? From: Simon Riggs To: Ray Stell Cc: pgsql-admin@postgresql.org In-Reply-To: <20090304201451.GB25611@cns.vt.edu> References: <20090304200612.GA25611@cns.vt.edu> <20090304201451.GB25611@cns.vt.edu> Content-Type: text/plain Date: Wed, 04 Mar 2009 20:31:16 +0000 Message-Id: <1236198676.31880.109.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: db8ee18c-08fa-11de-8156-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFaAFbYFhD HGQLW11EUl17W2R/ agIfZQBDYEtPQQRq UVZIRVBNFgBqBAMB SEAcVmIQDgYHeHxy ZkVmEHFdXEc0IRR1 FxtVHT4bZW82OX0e URQNagtVdQVXfh9E a1h6AHAKZjZWKBg1 TUcAFhwUHBNqYD9J SwcBJ0NaXk8KAj86 SFgMGi9nAk0MW3Jb X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:1378/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system. 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/51 X-Sequence-Number: 31551 On Wed, 2009-03-04 at 15:14 -0500, Ray Stell wrote: > On Wed, Mar 04, 2009 at 03:06:12PM -0500, Ray Stell wrote: > > Testing pg_standby in 8.3.6. I've gotten this standby into some sort of > > bind. It seems like it may be waiting for some WAL. How can I tell > > what it is waiting on? I don't really know how this works, so I may > > > say something silly. The standby log says: > > ,2512,,2009-03-04 12:23:01.483 EST,49aeb8f5.9d0,1,2009-03-04 12:23:01 EST,0, LOG: database system was interrupted; last known up at 2009-03-04 12:20:29 EST > ,2512,,2009-03-04 12:23:01.483 EST,49aeb8f5.9d0,2,2009-03-04 12:23:01 EST,0, LOG: starting archive recovery > ,2512,,2009-03-04 12:23:01.484 EST,49aeb8f5.9d0,3,2009-03-04 12:23:01 EST,0, LOG: restore_command = '/usr/local/pgsql/bin/pg_standby /data/pgsql/wals/alerts_oamp %f %p %r >> /home/postgresql/log/alerts_oamp/recovery.log' You've set archive_timeout? http://developer.postgresql.org/pgdocs/postgres/runtime-config-wal.html#RUNTIME-CONFIG-WAL-ARCHIVING -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support