Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 3290A64FFE0 for ; Thu, 27 Nov 2008 13:10:47 -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 15441-04 for ; Thu, 27 Nov 2008 13:10:42 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail136083.authsmtp.com (outmail136083.authsmtp.com [62.13.136.83]) by mail.postgresql.org (Postfix) with ESMTP id 95E9E64FE91 for ; Thu, 27 Nov 2008 13:10:41 -0400 (AST) Received: from mail-c189.authsmtp.com (mail-c189.authsmtp.com [62.13.128.71]) by punt5.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id mARHAVwk088733; Thu, 27 Nov 2008 17:10:31 GMT Received: from [192.168.0.3] (85-211-228-1.dyn.gotadsl.co.uk [85.211.228.1]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id mARHAUmH018364; Thu, 27 Nov 2008 17:10:30 GMT Subject: Re: pg_standby supported versions From: Simon Riggs To: Mark Kirkwood Cc: Decibel! , pgsql-docs@postgresql.org In-Reply-To: <492D1392.2020004@paradise.net.nz> References: <48A2B07E.2060608@paradise.net.nz> <1219743030.5343.1265.camel@ebony.2ndQuadrant> <492D1392.2020004@paradise.net.nz> Content-Type: text/plain Date: Thu, 27 Nov 2008 17:11:42 +0000 Message-Id: <1227805902.20796.69.camel@hp_dx2400_1> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 4b816963-bca6-11dd-bc7a-001f29070be2 X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadRtFagJbY1ZH HGQLW1xEUVp7WGN/ aAofZQBDYEtPQQdo WFZIXVBXFgB3AVJc d3xmI3wvDwVHcH12 YQhjWnZdEkAofUd7 S0hXCD9VNGF9aWFL BF0KJAQFbQNKf0lH Y1B4VCFYYytlM3Bw LCMUFAsEdS1QHz9J SwcBJ0NaWlsTBjkm Wx0OVSsiB1YEQCMo RyAn X-Authentic-SMTP: 61633235383639.kestrel.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: 200811/21 X-Sequence-Number: 5006 On Wed, 2008-11-26 at 22:14 +1300, Mark Kirkwood wrote: > Simon Riggs wrote: > > > > You'll have problems stopping and starting standby, but the most > > important change is that the process is not restartable. So if you > run > > it for a month and then crash, you'll need to re-run the whole > month's > > WAL data. > > > > > Exactly, after posting this I discovered the relevant CVS logs for > changes to support restartable recovery. It seems to me that perhaps a > little more detail in the docs would be good here. I would hope that the complete absence of anything would be all that is required to dissuade people. We don't ever update the docs to say "BTW feature X is not supported until next release". Not sure we should start now. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support