Re: detecting binary backup in progress

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: detecting binary backup in progress
Дата
Msg-id 51A8E202.1070906@vmware.com
обсуждение исходный текст
Ответ на detecting binary backup in progress  (Joe Conway <mail@joeconway.com>)
Ответы Re: detecting binary backup in progress
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: removing PD_ALL_VISIBLE
Следующее
От: Alexander Korotkov
Дата:
Сообщение: Re: Behavior of a pg_trgm index for 2 (or < 3) character LIKE queries