automatic crash recovery

Поиск
Список
Период
Сортировка
От Alfred Perlstein
Тема automatic crash recovery
Дата
Msg-id 20000420092615.A3024@fw.wintelcom.net
обсуждение исходный текст
Ответы Revisited: Transactions, insert unique.  (Lincoln Yeoh <lylyeoh@mecomb.com>)
Список pgsql-general
Generally after a crash most of the database indices need to
be rebuilt, has anyone put together a script to bring up the
database in 'single user mode' where network connections are
refused, then drop and recreate all indices and vacuum?

This sort of functionality would be very helpful in assisting
automatic-restart, sort of like fsck after crash and restart.

Any pointers?

thanks,
--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: full-text indexing
Следующее
От: "Steve Wolfe"
Дата:
Сообщение: Re: And to make things even better...