From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | recovery after massive system corruption ... |
Date: | 2000-09-27 01:07:05 |
Message-ID: | Pine.BSF.4.21.0009262158540.4209-100000@thelab.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2000-09-27 01:26:44 | Re: \l+ dumps core |
Previous Message | Finn Kettner | 2000-09-27 00:32:01 | libpq static link library dowsn't work (M$ VS6) |