Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi all,

 

it’s my first trial with pg_upgrade so I’m surely missing something....

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 (I hope this is the right list to post this)

 

Marco

 

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" 2>&1

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 > "/home/postgres/pg_upgrade_output/pg_upgrade_dump_all.sql"

pg_dumpall: query failed: ERROR:  permission denied for relation pg_authid

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

 



 


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux