BUG #11090: Unclear error message in pg_upgrade - Mailing list pgsql-bugs

From brorfred@gmail.com
Subject BUG #11090: Unclear error message in pg_upgrade
Date
Msg-id 20140729174023.16601.48893@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #11090: Unclear error message in pg_upgrade
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      11090
Logged by:          Bror Jonsson
Email address:      brorfred@gmail.com
PostgreSQL version: 9.2.0
Operating system:   Mac OS X
Description:


pg_upgrade requires that the old and new database has the same install
superuser (superuser that ran initdb). If this requirement isn't fulfilled,
you'll get the following error:

"Old and new cluster install users have different values for
pg_authid.oid.\n"

(https://github.com/postgres/postgres/blob/master/contrib/pg_upgrade/check.c,
line 168)

This was very confusing to me. A suggested rephrase would be:

"Old and new cluster must be created by the same user. Try to re-init the
new database with the flag "-U %s" \n"

Where %s is the the install user in the old cluster.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #11078: this query crash on array_agg, but there is no array_agg
Next
From: guido@sofer.com.ar
Date:
Subject: BUG #11088: posgres blocks when i don't commit