9.6beta3

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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&amp;a=commitdiff&amp;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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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&amp;a=commitdiff&amp;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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general