In my attempts I changed all pg_hba.conf (8.4 & 9.0) to trusted, turned off
firewall,followed instructions to shut down db(s) and ran cmd.exe as postgres:
C:\WINDOWS\system32>pg_upgrade.exe -p 5432 -P 5433 -d "c:/program
files/postgresql/8.4/data" -D "c:/program files/postgresql/9.0/data" -b
"c:/program files/postgresql/8.4/bin" -B "c:/program
files/postgresql/9.0/bin"Performing Consistency
Checks-----------------------------Checking old data directory (c:/program
files/postgresql/8.4/data)okChecking old bin directory (c:/program
files/postgresql/8.4/bin)okChecking new data directory (c:/program
files/postgresql/9.0/data)okChecking new bin directory (c:/program
files/postgresql/9.0/bin)okChecking for reg* system oid user data types
okChecking for /contrib/isn with bigint-passing mismatch okChecking
for large objects okCreating catalog dump
Access is denied.
There were problems executing ""c:/program
files/postgresql/9.0/bin/pg_dumpall"--port 5432 --username "postgres"
--schema-only --binary-upgrade > "C:\WINDOWS\system32/pg_upgrade_dump_all.sql""
I'm not clear if it picked up the 8.4 -p 5432 and 9.0 -P 5433
C:\WINDOWS\system32>pg_dumpall.exe --port 5433 username--"postgres"
--schema-only >"c:/windows/system32/pg_upgrade_dump_all.sql"Access is denied.
C:\WINDOWS\system32>pg_dumpall.exe --port 5433 username--"postgres" --password
"********" --schema-only >"c:/windows/system32/pg_upgrade_dump_all.sql"Access
is denied.
C:\WINDOWS\system32>pg_dumpall.exe --port 5433 username--"postgres" --password
******* --schema-only >"c:/windows/system32/pg_upgrade_dump_all.sql"Access is
denied.
C:\WINDOWS\system32>pg_dumpall.exe --port 5432 username--"postgres" --password
******* --schema-only >"c:/windows/system32/pg_upgrade_dump_all.sql"Access is
denied.
C:\WINDOWS\system32>pg_dumpall.exe --port 5432 username--"postgres" --password
******** --schema-only >"c:/windows/system32/pg_upgrade_dump_all.sql"Access is
denied.
8.4 Log2010-10-11 18:14:28 EDTLOG: database system was shut down at 2010-10-11
17:59:17 EDT2010-10-11 18:14:29 EDTLOG: database system is ready to accept
connections2010-10-11 18:14:35 EDTLOG: received fast shutdown
request2010-10-11 18:14:35 EDTLOG: aborting any active transactions2010-10-11
18:14:35 EDTLOG: shutting down2010-10-11 18:14:35 EDTLOG: database system is
shut down
9.0 Log2010-10-11 17:14:18 EDT LOG: database system was shut down at
2010-10-11 16:25:16 EDT2010-10-11 17:14:18 EDT FATAL: the database system is
starting up2010-10-11 17:14:19 EDT LOG: database system is ready to accept
connections2010-10-11 17:14:19 EDT LOG: autovacuum launcher started2010-10-11
17:34:58 EDT LOG: received fast shutdown request2010-10-11 17:34:58 EDT LOG:
aborting any active transactions2010-10-11 17:34:58 EDT LOG: autovacuum
launcher shutting down2010-10-11 17:34:58 EDT LOG: shutting down2010-10-11
17:34:58 EDT LOG: database system is shut down
And there we sit, dejected. Any thoughts would be greatly appreciated.
Chris English
