Re: Check if backup is in progress

[sodik <stanislav.miklik+pg@xxxxxxxxx>]

thanks, it looks exactly as I was searching for

On Thu, Feb 16, 2012 at 23:05, Marti Raudsepp <marti@xxxxxxxxx> wrote:

On Thu, Feb 16, 2012 at 18:53, sodik <stanislav.miklik+pg@xxxxxxxxx> wrote:
> is there any way how to check that postgres 9.1 is currently in backup
> mode?

You can check the existence of the "backup_label" file in your data
directory. If it's there, then a backup is in progress.

If your monitoring system is on a diferent server from the database,
then you can create a custom procedure to check for this file and call
it via SQL.

Regards,
Marti