Thread: BUG #5690: pg_upgrade fails

The following bug has been logged online:

Bug reference:      5690
Logged by:          Tony marston
Email address:      tony@marston-home.demon.co.uk
PostgreSQL version: 9.0
Operating system:   Windows XP
Description:        pg_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   Access is denied"

There were problems executing "f:/postgresql/9.0/bin/pg_dumpall --port 5432
--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!!!

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