Обсуждение: pgsql: New SQL functons pg_backup_in_progress() and pg_backup_start_tim

Поиск
Список
Период
Сортировка

pgsql: New SQL functons pg_backup_in_progress() and pg_backup_start_tim

От
Robert Haas
Дата:
New SQL functons pg_backup_in_progress() and pg_backup_start_time()

Darold Gilles, reviewed by Gabriele Bartolini and others, rebased by
Marco Nenciarini.  Stylistic cleanup and OID fixes by me.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/68de499bda40fdf1395b714bb63febad61046700

Modified Files
--------------
doc/src/sgml/func.sgml                 |   20 +++++++++
src/backend/access/transam/xlogfuncs.c |   73 +++++++++++++++++++++++++++++++-
src/include/access/xlog_internal.h     |    2 +
src/include/catalog/catversion.h       |    2 +-
src/include/catalog/pg_proc.h          |    4 ++
5 files changed, 99 insertions(+), 2 deletions(-)


Re: pgsql: New SQL functons pg_backup_in_progress() and pg_backup_start_tim

От
Magnus Hagander
Дата:
On Fri, Jun 15, 2012 at 1:29 AM, Robert Haas <rhaas@postgresql.org> wrote:
> New SQL functons pg_backup_in_progress() and pg_backup_start_time()
>
> Darold Gilles, reviewed by Gabriele Bartolini and others, rebased by
> Marco Nenciarini.  Stylistic cleanup and OID fixes by me.

How well is the term "on-line exclusive backup" really settled with
people? I wonder if we need to add a specific note to the docs saying
that the function doesn't consider streaming base backups at all, and
that one should refer to pg_stat_replication for info about those? Or
really, should the function be pg_exclusive_backup_in_progress()
perhaps?

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/