Re: BUG #5690: pg_upgrade fails - Mailing list pgsql-bugs

From Robert Haas
Subject Re: BUG #5690: pg_upgrade fails
Date
Msg-id AANLkTin73DXhp7n3sKhZSL0t9-8VJNwXKzDw9=5AEdj-@mail.gmail.com
Whole thread Raw
In response to BUG #5690: pg_upgrade fails  ("Tony marston" <tony@marston-home.demon.co.uk>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: BUG #5684: pg_restore does not restore schemas
Next
From: Tom Lane
Date:
Subject: Re: Planner producing 100% duplicate subplans when unneeded