From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Tony marston <tony(at)marston-home(dot)demon(dot)co(dot)uk> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5690: pg_upgrade fails |
Date: | 2010-10-04 23:33:46 |
Message-ID: | AANLkTin73DXhp7n3sKhZSL0t9-8VJNwXKzDw9=5AEdj-@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Sun, Oct 3, 2010 at 12:16 PM, Tony marston
<tony(at)marston-home(dot)demon(dot)co(dot)uk> wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5690
> Logged by: Tony marston
> Email address: tony(at)marston-home(dot)demon(dot)co(dot)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!!!
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?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-10-05 00:55:34 | Re: Planner producing 100% duplicate subplans when unneeded |
Previous Message | Robert Haas | 2010-10-04 21:54:28 | Re: BUG #5684: pg_restore does not restore schemas |