pg_upgrade could not create catalog dump while upgrading from 9.0 to 9.2

From: "shankar(dot)kotamarthy(at)gmail(dot)com" <shankar(dot)kotamarthy(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_upgrade could not create catalog dump while upgrading from 9.0 to 9.2
Date: 2013-07-12 11:56:23
Message-ID: 1373630182476-5763576.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
I am upgrading from postgresql 9.0 to 9.2 using the utility pg_upgrade.
Creation of catalog dump failed .The reason is in 9.2 view pg_roles has a
column "rolecreatedblink" which is missing in 9.0.Please help me to move
forward.
Thanks in Advance

*****Last lines in pg_upgradeutility.log******************************
command: "/u01/PostgresPlus/9.2AS/bin/pg_dumpall" --port 50432 --username
"postgres" --schema-only --binary-upgrade -f pg_upgrade_dump_all.sql >>
"pg_upgrade_utility.log" 2>&1
pg_dumpall: query failed: ERROR: column "rolcreatedblink" does not exist
LINE 1: ...rolsuper, rolinherit, rolcreaterole, rolcreatedb, rolcreated...
^
pg_dumpall: query was: SELECT oid, rolname, rolsuper, rolinherit,
rolcreaterole, rolcreatedb, rolcreatedblink, rolcreatepublicdblink,
roldroppublicdblink, false as rolpolicyexempt, rolcanlogin, rolconnlimit,
rolpassword, rolvaliduntil, false as rolreplication,
pg_catalog.shobj_description(oid, 'pg_authid') as rolcomment FROM pg_authid
ORDER BY 2

Shankar Kotamarthy
Postgresql DBA

--
View this message in context: http://postgresql.1045698.n5.nabble.com/pg-upgrade-could-not-create-catalog-dump-while-upgrading-from-9-0-to-9-2-tp5763576.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Clodoaldo Neto 2013-07-12 12:41:25 Changing the function used in an index.
Previous Message Vincenzo Romano 2013-07-12 11:23:40