Database "template1" does not exist in the system catalog
От | Aaron Mark |
---|---|
Тема | Database "template1" does not exist in the system catalog |
Дата | |
Msg-id | BAY21-F41CDD49DCB554F28A0B5BCAA880@phx.gbl обсуждение исходный текст |
Список | 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/
В списке pgsql-general по дате отправления: