From: | "Aaron Mark" <aaronmarkmn(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Database "template1" does not exist in the system catalog |
Date: | 2005-01-11 04:59:29 |
Message-ID: | BAY21-F41CDD49DCB554F28A0B5BCAA880@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I apologize if this is a duplicate of a message I just sent. The message
didn't appear to go through. I seem to have encountered a major corruption
error. I am currently running PostgreSQL 7.3.6. Here is an example of an
error I received:
# psql -h 127.0.0.1 -p 5432 -U postgres template1
psql: FATAL: Database "template1" does not exist in the system catalog.
In digging around the list, I have tried running pgfsck:
# pgfsck -s 8192 -D /Applications/altona/data-corruption template1
-- Detected database format 7.3
-- Table pg_class(1259):Page 0: Incorrect value in header (incorrect
blocksize?)
-- 00 00 00 00 00 47 A7 CC 00 00 00 09 00 E8 01 5C 20 00 20 01
-- Table pg_class(1259):Page 0: Incorrect value in header (incorrect
blocksize?)
-- 00 00 00 00 00 47 FE CC 00 00 00 09 00 E8 01 58 20 00 20 01
-- Table pg_class(1259):Page 0: Incorrect value in header (incorrect
blocksize?)
-- 00 00 00 00 00 48 35 88 00 00 00 09 00 E8 0E E8 20 00 20 01
Couldn't find class 'pg_attribute'
I'm 99% sure the block size is 8192, but I could be wrong. I proceeded to
try out pg_filedump on data-corrupt/base/1/1259, but I didn't see anything
out of the ordinary. Can't say that I know what I was looking for, though.
Any ideas on what I can try to potentially fix this problem and/or recover
any of this data?
Thanks,
Aaron
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Tenorio Avila | 2005-01-11 05:09:04 | Benchmarks |
Previous Message | Aaron Mark | 2005-01-11 04:23:50 | Database "template1" does not exist in the system catalog. |