Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ?
am 22.06.2010 09:11:14 von mcassianoThis is a multi-part message in MIME format.
------_=_NextPart_001_01CB11DA.0F9B12F8
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hi all,
=20
it's my very 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)
=20
Marco=20
=20
The output :
------------------------------
=20
=20
-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=3Dmysuperuser
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=3Doff -c
autovacuum_freeze_max_age=3D2000000000" 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
=20
=20
=20
------_=_NextPart_001_01CB11DA.0F9B12F8
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
charset=3Dus-ascii">
style=3D'font-size:10.0pt;font-family:"Courier New"'>Hi
all,
style=3D'font-size:10.0pt;font-family:"Courier =
New"'>
style=3D'font-size:10.0pt;font-family:"Courier New"'>it’s
my very first trial with pg_upgrade so I’m surely missing =
something....
style=3D'font-size:10.0pt;font-family:"Courier New"'>I’m
trying to launch pg_upgrade passing my super user name but pg_dumpall =
fails
with a permission denied =
error....
style=3D'font-size:10.0pt;font-family:"Courier New"'>I
don’t see the username in the pgdumpall call....could it be this =
the
problem ?
style=3D'font-size:10.0pt;font-family:"Courier New"'>Thank
you (I hope this is the right list to post =
this)
style=3D'font-size:10.0pt;font-family:"Courier =
New"'>
style=3D'font-size:10.0pt;font-family:"Courier New"'>Marco
style=3D'font-size:10.0pt;font-family:"Courier =
New"'>
style=3D'font-size:10.0pt;font-family:"Courier New";
color:#1F497D'>The output :
style=3D'font-size:10.0pt;color:#1F497D'>------------------- -----------
style=3D'font-size:10.0pt;color:#1F497D'>
style=3D'font-size:10.0pt;color:#1F497D'>
style=3D'font-size:10.0pt;font-family:"Courier New"'>-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=3Dmysuperuser
style=3D'font-size:10.0pt;font-family:"Courier New"'>Running
in verbose mode
style=3D'font-size:10.0pt;font-family:"Courier New"'>Performing
Consistency Checks
style=3D'font-size:10.0pt;font-family:"Courier =
New"'>-----------------------------
style=3D'font-size:10.0pt;font-family:"Courier New"'>Checking
old data directory
(/dbms/pgdata-8.4) &=
nbsp;
ok
style=3D'font-size:10.0pt;font-family:"Courier New"'>Checking
new data directory
(/dbms/pgdata) =
;
ok
style=3D'font-size:10.0pt;font-family:"Courier =
New"'>"/usr/local/pgsql-8.4/bin/pg_ctl"
-l "/tmp/pg_upgrade.log" -D "/dbms/pgdata-8.4" -o =
"-p
5432 -c autovacuum=3Doff -c autovacuum_freeze_max_age=3D2000000000" =
start
>> "/tmp/pg_upgrade.log" =
2>&1
style=3D'font-size:10.0pt;font-family:"Courier New"'>Checking
for /contrib/isn with bigint-passing =
mismatch ok
style=3D'font-size:10.0pt;font-family:"Courier New"'>Checking
for large
objects =
&=
nbsp;
ok
style=3D'font-size:10.0pt;font-family:"Courier New"'>Creating
catalog dump
&=
nbsp; &n=
bsp; "/usr/local/pgsql/bin/pg_dumpall"
--port 5432 --schema-only --binary-upgrade >
"/home/postgres/pg_upgrade_output/pg_upgrade_dump_all.sql"
style=3D'font-size:10.0pt;font-family:"Courier New"'>pg_dumpall:
query failed: ERROR: permission denied for relation =
pg_authid
style=3D'font-size:10.0pt;font-family:"Courier New"'>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
style=3D'font-size:9.0pt;font-family:"Tahoma","sans-serif"'>
style=3D'mso-margin-top-alt:5.0pt;margin-right:0cm;margin-bo ttom:
12.0pt;margin-left:0cm;text-autospace:none'> style=3D'font-size:
7.0pt;font-family:"Arial =
Narrow","sans-serif"'>
------_=_NextPart_001_01CB11DA.0F9B12F8--