Thank you Bruce, I applied the patch and found two things you might want to take in consideration : 1) dump.c Line 25 should be : SYSTEMQUOTE, ctx->new.bindir, ctx->old.port, ctx->user, ctx->output_dir); And not SYSTEMQUOTE, ctx->new.bindir, ctx->old.port, ctx->user, ctx->cwd); (sorry, I'm not confident at producing patch files....) 2) I then recompiled pg_upgrade and reinstalled it. Now it goes a little bit further but I think there's another point (vacuumdb of the new cluster) in which the username is missing. You might want to take a look at this output (/tmp/pg_upgrade.log) .... Checking for presence of required libraries ok | If pg_upgrade fails after this point, you must | re-initdb the new cluster before continuing. | You will also need to remove the ".old" suffix | from /dbms/pgdata-8.4/global/pg_control.old. Performing Migration -------------------- Adding ".old" suffix to old global/pg_control ok Analyzing all rows in the new cluster "/usr/local/pgsql/bin/vacuumdb" --port 5432 --all --analyze >> /tmp/pg_upgrade.log 2>&1 FATAL: role "postgres" does not exist vacuumdb: could not connect to database postgres: FATAL: role "postgres" does not exist .............. If I launch it manually adding the -U mysuperuser option it works... Hope this is somehow useful Regards Marco -----Messaggio originale----- Da: Bruce Momjian [mailto:bruce@xxxxxxxxxx] Inviato: martedì 22 giugno 2010 18:48 A: Cassiano, Marco Cc: pgsql-admin@xxxxxxxxxxxxxx Oggetto: Re: Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ? Cassiano, Marco wrote: > 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) Turns out I was missing the user name designation. I am attaching the patch that fixes this, and a pg_ctl issue on Win32. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + None of us is going to be here forever. + -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
