On Mon, Jan 30, 2012 at 20:33, Gilles Darold <gilles(dot)darold(at)dalibo(dot)com> wrote:
> After some time searching for a Pg system administration function like
> pg_is_in_recovery(), let's say pg_is_in_backup(), I couldn't find one.
> The minor patch attached here adds this administrative function that can
> be used with others backup control functions. This is a very little
> patch outside documentation because the function is only a wrapper to
> the internal BackupInProgress() function, just like pg_is_in_recovery()
> is calling RecoveryInProgress().

I think it would be more useful to have a function that returns a
timestamp when the backup started. That way, it's possible to write a
generic monitoring script that alerts the sysadmin only when a backup
has been running for too long, but is silent for well-behaved backups.

Regards,
Marti

In response to

• Patch pg_is_in_backup() at 2012-01-30 18:33:53 from Gilles Darold

Responses

• Re: Patch pg_is_in_backup() at 2012-02-02 11:44:01 from Pavel Stehule
• Re: Patch pg_is_in_backup() at 2012-02-02 17:47:35 from Gilles Darold
• Re: Patch pg_is_in_backup() at 2012-02-02 23:06:16 from Magnus Hagander

pgsql-hackers by date

Next:	From: hubert depesz lubaczewski	Date: 2012-02-02 11:24:00
	Subject: Re: pg_dump -s dumps data?!
Previous:	From: Marti Raudsepp	Date: 2012-02-02 10:16:26
	Subject: Re: [PATCH] Fix float8 parsing of denormal values (on some platforms?)