need help for PostgreSQL consistency check mechanism

Поиск
Список
Период
Сортировка
От Chen, Dongdong (GE Healthcare)
Тема need help for PostgreSQL consistency check mechanism
Дата
Msg-id 0332CB5EB6327940B291055AAD964221042DF9C9@SHAMLVEM02.e2k.ad.ge.com
обсуждение исходный текст
Ответы Re: need help for PostgreSQL consistency check mechanism  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-general
Дерево обсуждения
We are now working on database check mechanism in our application. The situation is when server shutdown abnormally, the postmaster.pid file still exists when reboot, But the PostgreSQL database itself may not be damaged. We just do not want to restore from backups when the database is still good even if server shutdown abnormally. If the PostgreSQL database records are damaged for sure when server reboots, then the restoration should be executed automatically.
So, is there any way or tool to automatically check the consistency status of PostgreSQL database when server starts up (like the DBCC in SQL server)?
 
Thanks for the suggestion.
 
B.R.
Kevin Chen

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

Предыдущее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: Re: varchar vs. text + constraint/triggers was: Help request to improve function performance
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_lsclusters error after pg_dropcluster