Re: [HACKERS] problems recovering 6.1 db - Mailing list pgsql-hackers

From Andrey V Khavryutchenko
Subject Re: [HACKERS] problems recovering 6.1 db
Date
Msg-id x77lv8k33g.fsf@netmaster.compchem.kiev.ua
Whole thread Raw
In response to problems recovering 6.1 db  (Andrey V Khavryutchenko <akhavr@compchem.kiev.ua>)
List pgsql-hackers
Hi, Thomas! 

>>>>> "TGL" == Thomas G Lockhart writes:

>> I have to recover old db, produced by pgsql 6.1.  The binaries are lost
>> and fresh compiled postgres dumps core.  Can anyone suggest the way to
>> fix the bug, so I can dump out the db and reload it to the last stable
>> postgresql version?

TGL> Out of curiosity, what platform are you running on? I've still got
TGL> v6.1 (and v6.1.1) tar files and source trees on my linux/libc5
TGL> machine, and could build binaries for you if they happen to match. Are
TGL> you *sure* you had a v6.1 installation, as opposed to a v6.1.1? 

I'm running linux/libc5.  And, yes, I'm not sure, that which version was
used to create db.  I've tried to use 6.1.1, now I'll try to build 6.1 and
retry.

TGL> Both releases had fixes for some hashing operations, and I'll bet they
TGL> need to match exactly with your database.

TGL> Also, if your "mailingad" database is small, not confidential, and
TGL> binary compatible with my machine I could try reading it here.

Unfortunately, it's impossible.  It's several hunderds megabytes and
limited access. 

Thanks!  If I'll fail with 6.1 too, I'll repost.

-- 
SY, Andrey V Khavryutchenko    http://www.kbi.kiev.ua/~akhavr

Shick's Law:There is no problem a good miracle can't solve.


pgsql-hackers by date:

Previous
From: "Jose' Soares"
Date:
Subject: create rule
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] psql: stdout or stderr?