Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id D08691A78D89
	for <pgsql-hackers@postgresql.org>;
	Thu,  2 Feb 2012 22:34:19 -0400 (AST)
Received: from oproxy7.bluehost.com ([2605:dc00:100:2::a7]
	helo=oproxy7-pub.bluehost.com)
	by magus.postgresql.org with smtp (Exim 4.72)
	(envelope-from <euler@timbira.com>) id 1Rt8yc-0007sK-Ol
	for pgsql-hackers@postgresql.org; Fri, 03 Feb 2012 02:34:18 +0000
Received: (qmail 936 invoked by uid 0); 3 Feb 2012 02:33:58 -0000
Received: from unknown (HELO host159.hostmonster.com) (74.220.207.159)
	by oproxy7.bluehost.com with SMTP; 3 Feb 2012 02:33:58 -0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed;
 d=timbira.com;
	s=default;
	h=Content-Transfer-Encoding:Content-Type:In-Reply-To:References:Subject:CC:To:MIME-Version:From:Date:Message-ID;
	bh=zOE68yj52EJxPf91bZQ9SbrnRsn4mCXWFELixoOZX+s=;
	b=at9QJAW9udnccQ+etd6PvELMkuX0gMSVdIZEU7x88iQ9zAOtgys3BzOP3o8pbP9IWjc0xPj7l0gTyZHytxLodIR08Rj7Ujj2O+S356zn9Jyu8g7yUZRSc4l+kUSylnlQ;
Received: from [189.31.60.211] (helo=[10.3.2.3])
	by host159.hostmonster.com with esmtpsa (TLSv1:AES256-SHA:256)
	(Exim 4.76) (envelope-from <euler@timbira.com>)
	id 1Rt8yL-0000Ou-Aa; Thu, 02 Feb 2012 19:33:58 -0700
Message-ID: <4F2B470F.5070107@timbira.com>
Date: Thu, 02 Feb 2012 23:31:43 -0300
From: Euler Taveira de Oliveira <euler@timbira.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.2.24) Gecko/20111114 Icedove/3.1.16
MIME-Version: 1.0
To: Magnus Hagander <magnus@hagander.net>
CC: Marti Raudsepp <marti@juffo.org>,
	Gilles Darold <gilles.darold@dalibo.com>, pgsql-hackers@postgresql.org
Subject: Re: Patch pg_is_in_backup()
References: <4F26E291.9020605@dalibo.com>
	<CABRT9RAo_xTOVdBAEDqzcP+QvoHa0SZW1Ud1p3vjmA5tJUnYLw@mail.gmail.com>
	<CABUevExm4_a-Yw3pt=weppb5ckzAYZwK3e79m__sznQNjjDveg@mail.gmail.com>
In-Reply-To: 
 <CABUevExm4_a-Yw3pt=weppb5ckzAYZwK3e79m__sznQNjjDveg@mail.gmail.com>
X-Enigmail-Version: 1.1.2
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Identified-User: {1651:host159.hostmonster.com:timbirac:timbira.com}
	{sentby:smtp auth 189.31.60.211 authed with euler@timbira.com}
X-Pg-Spam-Score: -2.0 (--)
X-Archive-Number: 201202/113
X-Sequence-Number: 202478

On 02-02-2012 20:06, Magnus Hagander wrote:
> If there is more than one concurrent backup running, which one do you
> return? The first one or the latest one? Or perhaps you need an
> interface thta can return them all...
> 
IMHO, pg_is_in_backup() should return true if one or more backup copies are
running. As about returning the backup timestamp, we could return an array
like array[['label_1', '2012-01-28 02:00:01 BRST'], ['label_2', '2012-01-28
03:40:34 BRST']] or NULL if none.


-- 
   Euler Taveira de Oliveira - Timbira       http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento