Recovering a broken database
От | Ciprian Popovici |
---|---|
Тема | Recovering a broken database |
Дата | |
Msg-id | 1120060837.42c2c5a5c21d7@imp.online.net обсуждение исходный текст |
Ответы |
Re: Recovering a broken database
|
Список | pgsql-general |
Hello, I'm having the almost exact problem described here: http://archives.postgresql.org/pgsql-admin/2004-12/msg00110.php That is, a 8.0 which started on a 7.4.2 repository. After noticing, I switched back to 7.4.2, but now it gives this error and won't start: FATAL: database files are incompatible with server DETAIL: The database cluster was initialized with PG_CONTROL_VERSION 74, but the server was compiled with PG_CONTROL_VERSION 72. HINT: It looks like you need to initdb. I read the pointer about using pg_resetxlog, but I obtain a seemingly empty database (no tables). Here's the output from pg_resetxlog: ------------------------- pg_resetxlog: pg_control exists but is broken or unknown version; ignoring it Guessed pg_control values: pg_control version number: 72 Catalog version number: 200310211 Current log file ID: 0 Next log file segment: 1 Latest checkpoint's StartUpID: 0 Latest checkpoint's NextXID: 514 Latest checkpoint's NextOID: 16384 Database block size: 8192 Blocks per segment of large relation: 131072 Maximum length of identifiers: 64 Maximum number of function arguments: 32 Date/time type storage: floating-point numbers Maximum length of locale name: 128 LC_COLLATE: en_US.UTF-8 LC_CTYPE: en_US.UTF-8 If these values seem acceptable, use -f to force reset. ------------------------- Then I use -f and it resets, but to no use. I also tried recompiling 7.4.2 (I install it from source anyway) but no use. I did a backup of the repository before I attempted the reset. Is there any other way I can try to recover the database? -- Ciprian Popovici
В списке pgsql-general по дате отправления: