On Fri, Feb 3, 2012 at 11:31 AM, Euler Taveira de Oliveira <eu...@timbira.com> wrote: > 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.
It seems to be more user-friendly to introduce a view like pg_stat_backup rather than the function returning an array. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers