Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VtaRj-0007iR-O3 for pgsql-committers@arkaria.postgresql.org; Thu, 19 Dec 2013 10:03:11 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VtaRj-0001P6-43 for pgsql-committers@arkaria.postgresql.org; Thu, 19 Dec 2013 10:03:11 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VtaRi-0001P0-DS for pgsql-committers@postgresql.org; Thu, 19 Dec 2013 10:03:10 +0000 Received: from dd2030.kasserver.com ([85.13.128.37]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VtaRa-0000ev-Bw for pgsql-committers@postgresql.org; Thu, 19 Dec 2013 10:03:09 +0000 Received: from [172.26.14.71] (wan3.credativ.com [94.79.138.166]) by dd2030.kasserver.com (Postfix) with ESMTPSA id 8F407E190E; Thu, 19 Dec 2013 11:02:59 +0100 (CET) Date: Thu, 19 Dec 2013 11:03:06 +0100 From: Bernd Helmle To: Simon Riggs , pgsql-committers@postgresql.org Subject: Re: pgsql: Allow time delayed standbys and recovery Message-ID: <0F09C6976302BC43D309B7AE@apophis.credativ.lan> In-Reply-To: References: X-Mailer: Mulberry/4.1.0a3 (Mac OS X) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline; size=1830 X-Pg-Spam-Score: -0.0 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-committers Precedence: bulk Sender: pgsql-committers-owner@postgresql.org --On 12. Dezember 2013 10:56:36 +0000 Simon Riggs wrote: > Set min_recovery_apply_delay to force a delay in recovery apply for > commit and restore point WAL records. Other records are replayed > immediately. Delay is measured between WAL record time and local standby > time. There's a small typo in the first paragraph, "paramater" should be "parameter": diff --git a/doc/src/sgml/recovery-config.sgml b/doc/src/sgml/recovery-config.sgml new file mode 100644 index ee5dc86..550cdce *** a/doc/src/sgml/recovery-config.sgml --- b/doc/src/sgml/recovery-config.sgml *************** restore_command = 'copy "C:\\server\\arc *** 152,158 **** By default, a standby server keeps restoring WAL records from the primary as soon as possible. It may be useful to have a time-delayed copy of the data, offering various options to correct data loss errors. ! This paramater allows you to delay recovery by a fixed period of time, specified in milliseconds if no unit is specified. For example, if you set this parameter to 5min, the standby will replay each transaction commit only when the system time on the standby --- 152,158 ---- By default, a standby server keeps restoring WAL records from the primary as soon as possible. It may be useful to have a time-delayed copy of the data, offering various options to correct data loss errors. ! This parameter allows you to delay recovery by a fixed period of time, specified in milliseconds if no unit is specified. For example, if you set this parameter to 5min, the standby will replay each transaction commit only when the system time on the standby -- Thanks Bernd -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers