On Thu, Feb 16, 2012 at 18:53, sodik <stanislav(dot)miklik+pg(at)gmail(dot)com> 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