recovery after massive system corruption ...

Wow, has this been just one of those days ...

Trying to clean up a few of the database, I'm wondering how to fix some of
these things, if its even possible, without having to rebuild the whole
database:

%~/bin/postgres -O -P -D/pgsql/special/sales.org swissre
DEBUG: Data Base System is starting up at Tue Sep 26 20:59:31 2000
DEBUG: Data Base System was shut down at Tue Sep 26 20:59:24 2000
DEBUG: Data Base System is in production state at Tue Sep 26 20:59:31 2000
FATAL 1: RelationBuildTriggers: 1 record(s) not found for rel pg_shadow
FATAL 1: RelationBuildTriggers: 1 record(s) not found for rel pg_shadow

-----------------

%~/bin/postgres -O -P -D/pgsql/special/sales.org tcg
DEBUG: Data Base System is starting up at Tue Sep 26 21:03:55 2000
DEBUG: Data Base System was interrupted being in production at Tue Sep 26 20:59:31 2000
DEBUG: Data Base System is in production state at Tue Sep 26 21:03:55 2000
TRAP: Too Large Allocation Request("!(0 < (size) && (size) <= (0xfffffff)):size=0 [0x0]", File: "mcxt.c", Line: 222)

!(0 < (size) && (size) <= (0xfffffff)) (0) [No such file or directory]
Abort(core dumped)

----------------

%~/bin/postgres -O -P -D/pgsql/special/sales.org vancity
DEBUG: Data Base System is starting up at Tue Sep 26 21:04:40 2000
DEBUG: Data Base System was shut down at Tue Sep 26 21:04:32 2000
DEBUG: Data Base System is in production state at Tue Sep 26 21:04:40 2000

POSTGRES backend interactive interface
$Revision: 1.155.2.1 $ $Date: 2000/08/30 21:19:32 $

backend> reindex database vancity force;
backend>

----------------

%~/bin/postgres -O -P -D/pgsql/special/sales.org bellsouth
DEBUG: Data Base System is starting up at Tue Sep 26 21:05:39 2000
DEBUG: Data Base System was shut down at Tue Sep 26 21:05:30 2000
DEBUG: Data Base System is in production state at Tue Sep 26 21:05:39 2000
FATAL 1: catalog is missing 8 attributes for relid 1260
FATAL 1: catalog is missing 8 attributes for relid 1260

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org