Re: Check if backup is in progress - Mailing list pgsql-general

From Marti Raudsepp
Subject Re: Check if backup is in progress
Date
Msg-id CABRT9RC6mHPyQfotxF1KZY6OYym=cUDN_t60dZuhcFhHqWaUeA@mail.gmail.com
Whole thread Raw
In response to Check if backup is in progress  (sodik <stanislav.miklik+pg@gmail.com>)
Responses Re: Check if backup is in progress
List pgsql-general
On Thu, Feb 16, 2012 at 18:53, sodik <stanislav.miklik+pg@gmail.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

pgsql-general by date:

Previous
From: Diego Schulz
Date:
Subject: Re: [GENERAL] conexão no windows 7
Next
From: Heine Ferreira
Date:
Subject: running multiple versions