Re: BUG #5690: pg_upgrade fails

On Sun, Oct 3, 2010 at 12:16 PM, Tony marston
<tony@marston-home.demon.co.uk> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05690
> Logged by: =A0 =A0 =A0 =A0 =A0Tony marston
> Email address: =A0 =A0 =A0tony@marston-home.demon.co.uk
> PostgreSQL version: 9.0
> Operating system: =A0 Windows XP
> Description: =A0 =A0 =A0 =A0pg_upgrade fails
> Details:
>
> I am trying to upgrade from version 8.4 to 9.0, but when I run pg_upgrade=
 it
> fails with the following error:
>
> "Creating catalog dump =A0 Access is denied"
>
> There were problems executing "f:/postgresql/9.0/bin/pg_dumpall --port 54=
32
> --username "postgres" --schema-only --binary-upgrade >
> "C:\WINDOWS\system32\pg_upgrade_dump_all.sql"
>
> How can this be? If it's running as superuser then surely it has automatic
> access to everything!!!

Hmm.  Does anything should up in the server log?

What do you get if you run that command by hand?  What if you run it
by hand without --binary-upgrade?

--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company