[GENERAL] 9.6beta3

[rob stone]

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

[Adrian Klaver]

Post by rob stone
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."

Post by rob stone
PGDATA is definitely pointing to the correct path.
Thanks,
Rob

[Joshua D. Drake]

Post by rob stone
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/
[phone]
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.

[Tom Lane]

Post by rob stone
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

[rob stone]

Post by Tom Lane

Post by rob stone
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