| From: | sodik <stanislav(dot)miklik+pg(at)gmail(dot)com> |
|---|---|
| To: | Marti Raudsepp <marti(at)juffo(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Check if backup is in progress |
| Date: | 2012-02-17 09:43:26 |
| Message-ID: | CAEsx18tSdacijyBYU3Lq2Er-y+sc77V1Uybda1sXSfturJ9X+Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
thanks, it looks exactly as I was searching for
On Thu, Feb 16, 2012 at 23:05, Marti Raudsepp <marti(at)juffo(dot)org> wrote:
> 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | premanand | 2012-02-17 13:01:47 | MySQL search query is not executing in Postgres DB |
| Previous Message | Durumdara | 2012-02-17 08:13:29 | One transaction by connection - commit subdetails without release master transaction? |