automatic crash recovery - Mailing list pgsql-general

From Alfred Perlstein
Subject automatic crash recovery
Date
Msg-id 20000420092615.A3024@fw.wintelcom.net
Whole thread Raw
Responses Revisited: Transactions, insert unique.
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: full-text indexing
Next
From: "Steve Wolfe"
Date:
Subject: Re: And to make things even better...