Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E670065011B for ; Tue, 26 Aug 2008 06:48:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 84026-06 for ; Tue, 26 Aug 2008 06:48:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail129180.authsmtp.net (outmail129180.authsmtp.net [62.13.129.180]) by postgresql.org (Postfix) with ESMTP id 0288864FCE8 for ; Tue, 26 Aug 2008 06:48:37 -0300 (ADT) Received: from mail-c187.authsmtp.com (mail-c187.authsmtp.com [62.13.128.33]) by punt3.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m7Q9lJhR014643; Tue, 26 Aug 2008 10:47:19 +0100 (BST) Received: from [192.168.10.100] (LAubervilliers-151-12-98-86.w193-252.abo.wanadoo.fr [193.252.201.86]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m7Q9lGFB078886; Tue, 26 Aug 2008 10:47:17 +0100 (BST) Subject: Re: pg_standby supported versions From: Simon Riggs To: Decibel! Cc: Mark Kirkwood , pgsql-docs@postgresql.org In-Reply-To: References: <48A2B07E.2060608@paradise.net.nz> Content-Type: text/plain Date: Tue, 26 Aug 2008 10:30:30 +0100 Message-Id: <1219743030.5343.1265.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: f8b3d47e-7353-11dd-8155-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadRtFagNbbExW HGQLW1xEUV17XWR/ agIfbAxefEhLXRto UElXSlRNFgBqBAMB SEMZMxAuAHM0eHl4 bU5kEHFZWkM0I04v QRpQEjgbYmRla30e URQMagtVdQZXfh9E a1h6AHAKZjZWKBg1 TUcAExcaBgAXMCti WR0EK14YUA4QAyYk QAoeEDlnA0AfXCQ0 KQdO X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:1186/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: 200808/17 X-Sequence-Number: 4957 On Fri, 2008-08-22 at 00:50 -0500, Decibel! wrote: > On Aug 13, 2008, at 4:59 AM, Mark Kirkwood wrote: > > I noticed in the docs for pg_standby (docs/src/sgml/pgstandby.sgml) > > that we have supported version >= 8.2. However it does seem to work > > ok with earlier versions (e.g 8.1) - or am I missing something? > > Hrm, AFAIK it works... Simon? It works, yes. But in basic form only. 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. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support