Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 2B6AC633C64 for ; Thu, 25 Feb 2010 05:21:00 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 23311-07 for ; Thu, 25 Feb 2010 09:20:49 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ww0-f46.google.com (mail-ww0-f46.google.com [74.125.82.46]) by mail.postgresql.org (Postfix) with ESMTP id CCB8663423E for ; Thu, 25 Feb 2010 05:20:04 -0400 (AST) Received: by wwf26 with SMTP id 26so1837411wwf.19 for ; Thu, 25 Feb 2010 01:20:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :from:date:message-id:subject:to:cc:content-type :content-transfer-encoding; bh=s/XHa+H7xzbDHAHB3tJXGMQvYppGZ4qO7AT1/qXziNA=; b=FA2CFV4rdPRa9PN3UVN3RumsGNvIzLohu0C/JrRZghmaCAPgJ8JGyAXTDxw6Hn1mZK hAilHcbXHesISWWhoIAlUDUrQtISGF6L7k2sdv+tYJL0hKJeO0DbGTyfWlpMFOikWvNM VLoadF6B28QoHG/1Vv9ttHWH926NDF5yQXGIY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type:content-transfer-encoding; b=fj492bYkfmf7k+Jx2qf89EGYhzeoxyeqjwR9jLymBEr7EglJ8MWP72X6U76OsXUuCo Zv4XtZhpEvRtV0ulajjMlHxYG2bFvc0cta/CsiuHPkyDh0QlABn6vxmEkOrnbn3+lVRq cXNeZZ/3kKsGfOdQ91SiBDqB/J9IaGIVl6Uy0= MIME-Version: 1.0 Received: by 10.216.90.131 with SMTP id e3mr508160wef.69.1267089603151; Thu, 25 Feb 2010 01:20:03 -0800 (PST) In-Reply-To: <4B863FA6.90706@enterprisedb.com> References: <3f0b79eb1002111757y3d11102n7fdfcee8f332f6d4@mail.gmail.com> <3f0b79eb1002241845p782c5e49v53a48be5aa67abf0@mail.gmail.com> <3f0b79eb1002250020y81e9f44g54e3021edcaebdc3@mail.gmail.com> <4B863FA6.90706@enterprisedb.com> From: Thom Brown Date: Thu, 25 Feb 2010 09:19:43 +0000 Message-ID: Subject: Re: Confusing link in streaming replication section To: Heikki Linnakangas Cc: Fujii Masao , pgsql-docs@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.838 tagged_above=-10 required=5 tests=BAYES_00=-2.599, FS_REPLICA=1.041, SARE_SPEC_REPLICA=0.72 X-Spam-Level: X-Archive-Number: 201002/34 X-Sequence-Number: 5350 On 25 February 2010 09:15, Heikki Linnakangas wrote: > Fujii Masao wrote: >> On Thu, Feb 25, 2010 at 5:03 PM, Thom Brown wrote: >>> It looks as if Heikki has already changed the page anyway, which >>> includes and example of a parameter setting for primary_conninfo and >>> removes links to the libpq connection stuff. =A0Problem solved :) >> >> Yeah, Heikki removed the link from >> http://developer.postgresql.org/pgdocs/postgres/streaming-replication.ht= ml#STREAMING-REPLICATION-SETUP >> >> but it still exists in >> http://developer.postgresql.org/pgdocs/postgres/standby-settings.html >> >> So I think that we still need to modify the document about >> primary_conninfo to suit your need. No? > > Yeah, it's not very clear as it is. > > How about this: > > --- a/doc/src/sgml/recovery-config.sgml > +++ b/doc/src/sgml/recovery-config.sgml > @@ -193,7 +193,8 @@ restore_command =3D 'copy "C:\\server\\archivedir\\%f= " > "%p"' > =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 Specifies a connection string to be used for the stan= dby server > - =A0 =A0 =A0 =A0 =A0to connect with the primary. This string is in the s= ame format as > + =A0 =A0 =A0 =A0 =A0to connect with the primary. This string is in the f= ormat > + =A0 =A0 =A0 =A0 =A0accepted by the libpq PQconnectdb function, > =A0 =A0 =A0 =A0 =A0 described in . If any= option is > =A0 =A0 =A0 =A0 =A0 unspecified in this string, then the corresponding en= vironment > =A0 =A0 =A0 =A0 =A0 variable (see ) is che= cked. If the > Yes, that'll do :) Thanks Thom