Recovering a broken database

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

Responses

Browse pgsql-general by date

  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