# 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/
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])