Skip site navigation (1) Skip section navigation (2)

pg_upgrade fails with "permission denied for relation pg_authid"

From: "Cassiano, Marco" <mcassiano(at)manord(dot)com>
To: <pgsql-testers(at)postgresql(dot)org>
Subject: pg_upgrade fails with "permission denied for relation pg_authid"
Date: 2010-06-22 16:13:48
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-testers

[Release]: 9.0Beta2

[Test Type]: CUSTOM

[Test]: pg_upgrade on my production database (v 8.4.4)

[Platform]: Linux Redhat Enterprise 5 x86_64 - Vmware Virtual Machine


[Failure]: Yes


it's my very first trial with pg_upgrade so I'm surely missing

I'm trying to launch pg_upgrade passing my super user name but
pg_dumpall fails with a permission denied error....

I don't see the username in the pgdumpall call....could it be this the
problem ?

Thank you 




The output :




-bash-3.2$ /usr/local/pgsql/bin/pg_upgrade -d /dbms/pgdata-8.4 -D
/dbms/pgdata -b /usr/local/pgsql-8.4/bin -B /usr/local/pgsql/bin -l
/tmp/pg_upgrade.log -v  --user=mysuperuser

Running in verbose mode

Performing Consistency Checks


Checking old data directory (/dbms/pgdata-8.4)              ok

Checking new data directory (/dbms/pgdata)                  ok

"/usr/local/pgsql-8.4/bin/pg_ctl" -l "/tmp/pg_upgrade.log" -D
"/dbms/pgdata-8.4" -o "-p 5432 -c autovacuum=off -c
autovacuum_freeze_max_age=2000000000" start >> "/tmp/pg_upgrade.log"

Checking for /contrib/isn with bigint-passing mismatch      ok

Checking for large objects                                  ok

Creating catalog dump
"/usr/local/pgsql/bin/pg_dumpall" --port 5432 --schema-only
--binary-upgrade >

pg_dumpall: query failed: ERROR:  permission denied for relation

pg_dumpall: query was: SELECT rolname, rolsuper, rolinherit,
rolcreaterole, rolcreatedb, rolcatupdate, rolcanlogin, rolconnlimit,
rolpassword, rolvaliduntil, pg_catalog.shobj_description(oid,
'pg_authid') as rolcomment FROM pg_authid ORDER BY 1




pgsql-testers by date

Next:From: Bruce MomjianDate: 2010-06-22 16:48:12
Subject: Re: Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ?
Previous:From: Lou PiccianoDate: 2010-06-21 21:16:21
Subject: Single-statement INSERT with multiple VALUES clauses behaving strangely...

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group