recovery after massive system corruption ... - Mailing list pgsql-hackers

From The Hermit Hacker
Subject recovery after massive system corruption ...
Date
Msg-id Pine.BSF.4.21.0009262158540.4209-100000@thelab.hub.org
Whole thread Raw
List pgsql-hackers
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 




pgsql-hackers by date:

Previous
From: "Finn Kettner"
Date:
Subject: libpq static link library dowsn't work (M$ VS6)
Next
From: Tatsuo Ishii
Date:
Subject: Re: [GENERAL] \l+ dumps core