From: | Ciprian Popovici <ciprian(at)zuavra(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Recovering a broken database |
Date: | 2005-06-29 16:00:37 |
Message-ID: | 1120060837.42c2c5a5c21d7@imp.online.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2005-06-29 16:04:08 | Re: Advice on merging two primary keys... |
Previous Message | Douglas McNaught | 2005-06-29 15:29:05 | Re: how to use pg_dump and then restored onto development server |