Thread: 9.6beta3
Hi, Some weeks ago I downloaded 9.6beta1 source, compiled it and used initdb to create a cluster, then psql to create roles, schema, etc., etc. I loaded some data into tables using COPY FROM. Today I downloaded the 9.6beta3 source, compiled it and tried to start postgres using pg_ctl but pulled the following error:- "The database cluster was initialized with PG_CONTROL_VERSION 942, but the server was compiled with PG_CONTROL_VERSION 960." So, could somebody tell me if the 9.6beta1 version of initdb contained an incorrect version constant? PGDATA is definitely pointing to the correct path. Thanks, Rob
On 07/29/2016 09:06 AM, rob stone wrote: > Hi, > Some weeks ago I downloaded 9.6beta1 source, compiled it and used > initdb to create a cluster, then psql to create roles, schema, etc., > etc. I loaded some data into tables using COPY FROM. > > Today I downloaded the 9.6beta3 source, compiled it and tried to start > postgres using pg_ctl but pulled the following error:- > > "The database cluster was initialized with PG_CONTROL_VERSION 942, but > the server was compiled with PG_CONTROL_VERSION 960." > > So, could somebody tell me if the 9.6beta1 version of initdb contained > an incorrect version constant? https://www.postgresql.org/about/news/1686/ "Due to changes in system catalogs, a pg_upgrade or dump and restore will be required for users migrating databases from earlier betas. This includes a version update to the pg_control tool, making it incompatible with PostgreSQL 9.4 and earlier. This beta also includes patches to many issues shared with earlier versions, which will be updated in an upcoming minor release." > > PGDATA is definitely pointing to the correct path. > > Thanks, > Rob > > -- Adrian Klaver adrian.klaver@aklaver.com
On 07/29/2016 09:06 AM, rob stone wrote: > Hi, > "The database cluster was initialized with PG_CONTROL_VERSION 942, but > the server was compiled with PG_CONTROL_VERSION 960." > > So, could somebody tell me if the 9.6beta1 version of initdb contained > an incorrect version constant? 9.3Beta3 requires a new initdb as discussed here: https://www.postgresql.org/docs/9.6/static/release-9-6.html Sincerely, JD -- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full stack support, consulting and development. Everyone appreciates your honesty, until you are honest with them. Unless otherwise stated, opinions are my own.
rob stone <floriparob@gmail.com> writes: > So, could somebody tell me if the 9.6beta1 version of initdb contained > an incorrect version constant? It did, see https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=99dd8b05aa5647a59f30ca67e67e2e3377f50094 You would have had to do an initdb or pg_upgrade for the new version anyway because of other catalog changes. regards, tom lane
On Fri, 2016-07-29 at 12:15 -0400, Tom Lane wrote: > rob stone <floriparob@gmail.com> writes: > > So, could somebody tell me if the 9.6beta1 version of initdb > > contained > > an incorrect version constant? > > It did, see > > https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=99 > dd8b05aa5647a59f30ca67e67e2e3377f50094 > > You would have had to do an initdb or pg_upgrade for the new version > anyway because of other catalog changes. > > regards, tom lane Thanks for that. Back to the drawing board. Only testing the beta versions so no real harm done. Cheers, rob