On 07/15/16 12:13, Adrian Klaver wrote:
On 07/15/2016 09:06 AM, Tom Lane wrote:
Richard Kuhns <rjk@xxxxxxxxxx> 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@xxxxxxxxxx>
Wintek Corporation
427 N 6th Street
Lafayette, IN 47901-2211
Main: 765-742-8428
Direct: 765-269-8541
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
