Re: detecting binary backup in progress

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