Postgres Pro
Downloads
Home   >   mailing lists

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

From sodik
Subject Re: Check if backup is in progress
Date
Msg-id CAEsx18tSdacijyBYU3Lq2Er-y+sc77V1Uybda1sXSfturJ9X+Q@mail.gmail.com
Whole thread Raw
In response to Re: Check if backup is in progress  (Marti Raudsepp <marti@juffo.org>)
List pgsql-general
Tree view
thanks, it looks exactly as I was searching for

On Thu, Feb 16, 2012 at 23:05, Marti Raudsepp <marti@juffo.org> wrote:
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: Durumdara
Date:
Subject: One transaction by connection - commit subdetails without release master transaction?
Next
From: premanand
Date:
Subject: MySQL search query is not executing in Postgres DB