From: | brorfred(at)gmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #11090: Unclear error message in pg_upgrade |
Date: | 2014-07-29 17:40:23 |
Message-ID: | 20140729174023.16601.48893@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 11090
Logged by: Bror Jonsson
Email address: brorfred(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2014-07-29 18:55:15 | Re: BUG #11088: posgres blocks when i don't commit |
Previous Message | guido | 2014-07-29 17:14:23 | BUG #11088: posgres blocks when i don't commit |