Check if backup is in progress

Поиск
Список
Период
Сортировка
От sodik
Тема Check if backup is in progress
Дата
Msg-id CAEsx18sE1D54NF=UmsHfvg8_D5Usyn0UQZNqNXz0uCQ_S7uhtg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Check if backup is in progress  (Marti Raudsepp <marti@juffo.org>)
Список pgsql-general
Hi,

is there any way how to check that postgres 9.1 is currently in backup mode? 

Imagine the situation that my DB is running and the backup is remotely started by 

# select pg_start_backup('backup', true);

However the remote site crashed and can't stop the backup. Is there any way how to check if something like it happen or somehow configure the timeout for backup procedure? 
Currently only solution that comes to my mind is to try to start another backup, if this fails, I know that it is in progress.

Thanks
Stano

В списке pgsql-general по дате отправления:

Предыдущее
От: "Musial, Jan (GIUB)"
Дата:
Сообщение: Re: Dynamic update of a date field
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Unable to execute \copy from Client Application