Skip site navigation (1) Skip section navigation (2)

Re: Patch pg_is_in_backup()

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: Gilles Darold <gilles(dot)darold(at)dalibo(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Patch pg_is_in_backup()
Date: 2012-02-02 23:00:41
Message-ID: C729A6E0B91CEDC4ADEDCE6C@apophis.local (view raw or flat)
Thread:
Lists: pgsql-hackers

--On 2. Februar 2012 18:47:35 +0100 Gilles Darold <gilles(dot)darold(at)dalibo(dot)com> 
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

In response to

pgsql-hackers by date

Next:From: Magnus HaganderDate: 2012-02-02 23:06:16
Subject: Re: Patch pg_is_in_backup()
Previous:From: Tom LaneDate: 2012-02-02 21:56:30
Subject: Re: BUG #6425: Bus error in slot_deform_tuple

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group