Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id A5372632563 for ; Wed, 28 Apr 2010 03:19:26 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 81226-04 for ; Wed, 28 Apr 2010 06:19:14 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og104.obsmtp.com (exprod7og104.obsmtp.com [64.18.2.161]) by mail.postgresql.org (Postfix) with SMTP id CE1316324D0 for ; Wed, 28 Apr 2010 03:19:13 -0300 (ADT) Received: from source ([209.85.219.216]) by exprod7ob104.postini.com ([64.18.6.12]) with SMTP ID DSNKS9fTYPo2RZRg4/2MJPoJWPmLr2BQ/qNK@postini.com; Tue, 27 Apr 2010 23:19:13 PDT Received: by ewy8 with SMTP id 8so4247860ewy.28 for ; Tue, 27 Apr 2010 23:19:11 -0700 (PDT) Received: by 10.213.110.135 with SMTP id n7mr2592038ebp.66.1272435548974; Tue, 27 Apr 2010 23:19:08 -0700 (PDT) Received: from [192.168.1.117] (dsl-hkibrasgw2-ff67c300-165.dhcp.inet.fi [88.195.103.165]) by mx.google.com with ESMTPS id 14sm3181989ewy.2.2010.04.27.23.19.07 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 27 Apr 2010 23:19:08 -0700 (PDT) Message-ID: <4BD7D35A.7080308@enterprisedb.com> Date: Wed, 28 Apr 2010 09:19:06 +0300 From: Heikki Linnakangas Organization: EnterpriseDB User-Agent: Mozilla-Thunderbird 2.0.0.22 (X11/20090706) MIME-Version: 1.0 To: Fujii Masao CC: pgsql-docs@postgresql.org Subject: Re: recovery configuration parameters References: <4BD7407E.5050507@enterprisedb.com> In-Reply-To: Content-Type: multipart/mixed; boundary="------------080708010100050901070700" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-3.817 tagged_above=-10 required=5 tests=AWL=0.383, BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3 X-Spam-Level: X-Archive-Number: 201004/90 X-Sequence-Number: 5489 This is a multi-part message in MIME format. --------------080708010100050901070700 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Fujii Masao wrote: > On Wed, Apr 28, 2010 at 4:52 AM, Heikki Linnakangas > wrote: >> Fujii Masao wrote: >>> While the server configuration parameters are listed in >>> the index page, why not the recovery ones? It's very >>> inconvenient to be unable to reach the document of them >>> immediately when setting up the standby server. >>> >>> How about listing the recovery configuration parameters >>> in the index page? >> Agreed. This patch should do it. > > Which patch? Ah, crap. This one. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com --------------080708010100050901070700 Content-Type: text/x-diff; name="recovery-config-index.patch" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="recovery-config-index.patch" diff --git a/doc/src/sgml/recovery-config.sgml b/doc/src/sgml/recovery-config.sgml index 3aff445..439db3f 100644 --- a/doc/src/sgml/recovery-config.sgml +++ b/doc/src/sgml/recovery-config.sgml @@ -36,6 +36,9 @@ restore_command (string) + + restore_command recovery parameter + The shell command to execute to retrieve an archived segment of @@ -72,6 +75,9 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows restartpoint_command (string) + + restartpoint_command recovery parameter + This parameter specifies a shell command that will be executed at @@ -98,6 +104,9 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows recovery_end_command (string) + + recovery_end_command recovery parameter + This parameter specifies a shell command that will be executed once only @@ -129,6 +138,9 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows recovery_target_time (timestamp) + + recovery_target_time recovery parameter + This parameter specifies the time stamp up to which recovery @@ -144,6 +156,9 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows recovery_target_xid (string) + + recovery_target_xid recovery parameter + This parameter specifies the transaction ID up to which recovery @@ -166,6 +181,9 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows recovery_target_inclusive (boolean) + + recovery_target_inclusive recovery parameter + Specifies whether we stop just after the specified recovery target @@ -185,6 +203,9 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows recovery_target_timeline (string) + + recovery_target_timeline recovery parameter + Specifies recovering into a particular timeline. The default is @@ -207,6 +228,9 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows standby_mode (boolean) + + standby_mode recovery parameter + Specifies whether to start the PostgreSQL server as @@ -221,6 +245,9 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows primary_conninfo (string) + + primary_conninfo recovery parameter + Specifies a connection string to be used for the standby server @@ -254,6 +281,9 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows trigger_file (string) + + trigger_file recovery parameter + Specifies a trigger file whose presence ends recovery in the --------------080708010100050901070700--