From: | "Cassiano, Marco" <mcassiano(at)manord(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ? |
Date: | 2010-06-21 16:33:27 |
Message-ID: | BC53C974C3B9E542BC0A9BD4C5B1168A0CC2D371@NEWMAIL.manord.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-testers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Broers | 2010-06-21 18:18:01 | alter column resize triggers question |
Previous Message | Vishnu S. | 2010-06-21 10:52:33 | Postgre Server stopped during continuous run. |
From | Date | Subject | |
---|---|---|---|
Next Message | Lou Picciano | 2010-06-21 21:16:21 | Single-statement INSERT with multiple VALUES clauses behaving strangely... |
Previous Message | Josh Berkus | 2010-06-18 20:33:11 | Re: local_preload_libraries converts path to lowercase? |