Re: detecting binary backup in progress - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: detecting binary backup in progress
Date
Msg-id 51A8E202.1070906@vmware.com
Whole thread Raw
In response to detecting binary backup in progress  (Joe Conway <mail@joeconway.com>)
Responses Re: detecting binary backup in progress
List pgsql-hackers
On 31.05.2013 20:38, Joe Conway wrote:
> I can check for the presence of $PGDATA/backup_label in order to detect
> a backup in progress (i.e. pg_start_backup() has been run and
> pg_stop_backup() has not yet been run).
>
> However there is a period of time after pg_start_backup() is first
> executed to when it completes, during which backup_label file does not
> exist yet, but the backup has essentially been started. Is there any
> way to detect this state?

What are you trying to accomplish? Even if you eliminate that window, 
it's always possible that a backup starts just after you've checked that 
there is no backup in progress.

- Heikki



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: removing PD_ALL_VISIBLE
Next
From: Alexander Korotkov
Date:
Subject: Re: Behavior of a pg_trgm index for 2 (or < 3) character LIKE queries