
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@hub.org           secondary: scrappy@{freebsd|postgresql}.org 



Tue, 26 Sep 2000 22:07:05 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
recovery after massive system corruption ...