Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 628401EC5BE6 for ; Thu, 2 Feb 2012 19:00:58 -0400 (AST) Received: from dd2030.kasserver.com ([85.13.128.37]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Rt5eD-0003oS-2c for pgsql-hackers@postgresql.org; Thu, 02 Feb 2012 23:00:58 +0000 Received: from [192.168.1.11] (dslb-094-221-090-020.pools.arcor-ip.net [94.221.90.20]) by dd2030.kasserver.com (Postfix) with ESMTPA id 8D20BE0095; Fri, 3 Feb 2012 00:00:42 +0100 (CET) Date: Fri, 03 Feb 2012 00:00:41 +0100 From: Bernd Helmle To: Gilles Darold , pgsql-hackers@postgresql.org Subject: Re: Patch pg_is_in_backup() Message-ID: In-Reply-To: <4F2ACC37.9030902@dalibo.com> References: <4F26E291.9020605@dalibo.com> <4F2ACC37.9030902@dalibo.com> X-Mailer: Mulberry/4.1.0a1 (Mac OS X) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline; size=639 X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201202/106 X-Sequence-Number: 202471 --On 2. Februar 2012 18:47:35 +0100 Gilles Darold wrote: > For now the internal function BackupInProgress() only return a boolean. > I like the idea that pg_is_in_backup() just works as pg_is_in_recovery() > do. I mean it doesn't return the timestamp of the recovery starting time > but only true or false. > > Maybe we can have an other function that will return all information > available in the backup_label file ? I've seen customers using pg_read_file() to do exactly this. E.g. they are searching for the START TIME value, if backup_label is present, to report the backup start. -- Thanks Bernd