Detecting if the DB is in backup mode or not

Поиск
Список
Период
Сортировка
От
Тема Detecting if the DB is in backup mode or not
Дата
Msg-id 9CD8B4953C02C6429C78DB43FF5B71580150E19131@AMERSNCEXMB2.corp.nai.org
обсуждение исходный текст
Ответы Re: Detecting if the DB is in backup mode or not  (Thom Brown <thombrown@gmail.com>)
Список pgsql-general

Hello,

 

I am running pg 8.3, and I’m working on some scripts to take online backups of the database with backup mode and netapp snapshots.  I can successfully run the pg_start_backup/pg_stop_backup functions, but how to I query to see what mode the DB currently is in?  If my script fails to run the stop_backup, I’d like to have some external monitoring that can alert me to the database being stuck in backup mode.

 

Thanks

-Adam

 

 

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

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: [NOVICE] sum multiple tables gives wrong answer?
Следующее
От: Richard Broersma
Дата:
Сообщение: Re: [NOVICE] sum multiple tables gives wrong answer?