|
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
|
