Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 456779F96E4 for ; Sat, 1 Sep 2007 21:12:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 27203-04 for ; Sat, 1 Sep 2007 21:12:35 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 775079F96E0 for ; Sat, 1 Sep 2007 21:12:40 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id A5A3D564CC; Sun, 2 Sep 2007 00:12:38 +0000 (UTC) Received: (hashcash-sendmail, from uid 1001); Sat, 1 Sep 2007 19:12:33 -0500 Date: Sat, 1 Sep 2007 19:12:33 -0500 From: Decibel! To: Tom Lane Cc: Jeff Frost , pgsql-admin@postgresql.org, Simon Riggs Subject: Re: pitr replica dies on startup Message-ID: <20070902001233.GD38801@decibel.org> References: <3673.1188602373@sss.pgh.pa.us> <5802.1188611110@sss.pgh.pa.us> <5916.1188611810@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="8jcWiON1L7A8HfS7" Content-Disposition: inline In-Reply-To: <5916.1188611810@sss.pgh.pa.us> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070902:tgl@sss.pgh.pa.us::a7uMliIvEwKy3/mg:00000000000000000000 0000000000000000000000001yME X-Hashcash: 1:20:070902:jeff@frostconsultingllc.com::AtkzItlbiNk8G6qV:0000000000 000000000000000000000000CBb6 X-Hashcash: 1:20:070902:pgsql-admin@postgresql.org::GRQKFhh65mrJVQ/d:00000000000 0000000000000000000000004Lz0 X-Hashcash: 1:20:070902:simon@2ndquadrant.com::iFlMsGUB7FTSX9s9:0000000000000000 0000000000000000000000002AbK X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/4 X-Sequence-Number: 26765 --8jcWiON1L7A8HfS7 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Aug 31, 2007 at 09:56:50PM -0400, Tom Lane wrote: > Jeff Frost writes: > > That all seems reasonable enough. Is it in the docs somewhere? I > > didn't find anything like this mentioned. If not, could we get it > > added as a note? >=20 > Yeah, it hadn't occurred to anyone to specify this, because we just > thought of recovery_command as fetching from a static archive. > We clearly need to document the expected semantics better. >=20 > I'm wondering whether we should discourage people from putting > side-effects into the recovery_command, period. You already found out > that recovery can ask for the same file more than once, but what if it > never asks for a particular file at all? I'm not sure that can happen, > just playing devil's advocate. I'd rather go the route of documenting the details of how (archive|recovery)_command is used; one of the huge benefits of our system over others is the flexibility you have in being able to run whatever command you want. I know Simon was working on some improvements to the PITR docs, but I don't know if that's been committed or not yet. --=20 Decibel!, aka Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) --8jcWiON1L7A8HfS7 Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iD8DBQFG2f/xdO30qud8SkgRAkGIAKCf1/VKlzI+A2qg4FbU+kR/nr/ukACcCUfu ukT2etfibUBGLFJkjBVMQ78= =IiG8 -----END PGP SIGNATURE----- --8jcWiON1L7A8HfS7--