From: | Richard Kuhns <rjk(at)wintek(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Recovering data from an old disk image |
Date: | 2016-07-15 17:58:30 |
Message-ID: | 2dfb08d2-1983-8e60-24e2-08019baa8173@wintek.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 07/15/16 12:13, Adrian Klaver wrote:
> On 07/15/2016 09:06 AM, Tom Lane wrote:
>> Richard Kuhns <rjk(at)wintek(dot)com> writes:
>>> I uninstalled 9.3 & installed the most recent 9.4. When I try to start
>>> it, it tells me:
>>
>>> postgres[99770]: [1-1] FATAL: database files are incompatible with
>>> server
>>> postgres[99770]: [1-2] DETAIL: The database cluster was initialized
>>> with PG_CONTROL_VERSION 937, but the server was compiled with
>>> PG_CONTROL_VERSION 942.
>>
>>> Based on a search of the mailing list archives I'm guessing that the
>>> original postgresql server was a 9.4 beta.
>>
>> [ digs in commit logs... ] Assuming that this actually was a release of
>> some sort, and not just a random git snapshot, it would have to have been
>> 9.4beta1. Betas later than that one used the newer PG_CONTROL_VERSION
>> value. The catalog_version_no would provide a finer-grain dating, but
>> trying beta1 seems like a good bet.
>>
>> I'm not sure if there are still tarballs of 9.4beta1 on our webservers,
>> but in any case you could easily check out that tag from our git server
>> to recover the matching source code.
>
> If you go here:
>
> https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=e6df2e1be6330660ba4d81daa726ae4a71535aa9
>
>
> would not fetching the snapshot also work?
>
>>
>> regards, tom lane
>>
>>
Thank you all! Fetching the snapshot worked just fine, and I have the
missing table.
I'm also dumping the entire database so I don't have to worry about it
again.
Thanks again,
- Richard
--
Richard Kuhns <rjk(at)wintek(dot)com>
Wintek Corporation
427 N 6th Street
Lafayette, IN 47901-2211
Main: 765-742-8428
Direct: 765-269-8541
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Keller | 2016-07-15 18:34:16 | Re: FTS with more than one language in body and with unknown query language? |
Previous Message | Miguel Ramos | 2016-07-15 17:34:10 | Re: pg_restore out of memory |