From: | Christoph Berg <myon(at)debian(dot)org> |
---|---|
To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, Petr Jelinek <petr(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | pg_upgrade 9.6->9.6: column "amtype" does not exist |
Date: | 2016-04-01 21:31:20 |
Message-ID: | 20160401213120.GA16543@msg.df7cb.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I'm not sure this is a bug, but before it bites back too late, I'm
reporting it now.
On pg_upgrading my catversion 201603111 9.6 cluster to 201603301, I
got the following error:
-----------------------------------------------------------------
pg_upgrade run on Fri Apr 1 22:50:07 2016
-----------------------------------------------------------------
Performing Consistency Checks
-----------------------------
Checking cluster versions ok
Checking database user is the install user ok
Checking database connection settings ok
Checking for prepared transactions ok
Checking for reg* system OID user data types ok
Checking for contrib/isn with bigint-passing mismatch ok
Creating dump of global objects ok
Creating dump of database schemas
*failure*
Consult the last few lines of "pg_upgrade_dump_13007.log" for
the probable cause of the failure.
command: "/usr/lib/postgresql/9.6/bin/pg_dump" --host "/var/log/postgresql/pg_upgradecluster-9.6-9.6-main.lLkW" --port 5433 --username "postgres" --schema-only --quote-all-identifiers --binary-upgrade --format=custom --file="pg_upgrade_dump_13007.custom" "postgres" >> "pg_upgrade_dump_13007.log" 2>&1
pg_dump: [Archivierer (DB)] Anfrage fehlgeschlagen: FEHLER: Spalte „amtype“ existiert nicht
ZEILE 1: SELECT tableoid, oid, amname, amtype, amhandler::pg_catalog....
^
TIP: Perhaps you meant to reference the column "pg_am.amname".
pg_dump: [Archivierer (DB)] Anfrage war: SELECT tableoid, oid, amname, amtype, amhandler::pg_catalog.regproc AS amhandler FROM pg_am
'FEHLER...' translates to 'ERROR: Column "amtype" does not exist'.
Christoph
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2016-04-01 21:37:19 | Re: pg_upgrade 9.6->9.6: column "amtype" does not exist |
Previous Message | Tom Lane | 2016-04-01 21:14:41 | Re: More stable query plans via more predictable column statistics |