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

From Christoph Moench-Tegeder
Subject Re: detecting binary backup in progress
Date
Msg-id 20130601094339.GA2064@elch.exwg.net
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
## Joe Conway (mail@joeconway.com):

> 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?

When I did some research on the very same question just a few weeks
ago, I settled for external locks (lockfile, pg_advisory_lock(), ...,
depending on your exact situation) around the backup-taking code.

Regards,
Christoph

-- 
Spare Space



pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Combo xids
Next
From: Soroosh Sardari
Date:
Subject: Which table stored in which file in PGDATA/base/[db-oid]