Skip site navigation (1) Skip section navigation (2)

pg_dumpall -> by hand without --binary-upgrade or BUG #5690: pg_upgrade fails

From: Chris English <sglish(at)hotmail(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: pg_dumpall -> by hand without --binary-upgrade or BUG #5690: pg_upgrade fails
Date: 2010-10-11 23:09:48
Message-ID: SNT117-W305811A705A3000CAB9C13C5530@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-bugs
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



 		 	   		  

Responses

pgsql-bugs by date

Next:From: John R PierceDate: 2010-10-11 23:15:52
Subject: Re: pg_dumpall -> by hand without --binary-upgrade or BUG #5690: pg_upgrade fails
Previous:From: Tom LaneDate: 2010-10-11 23:07:19
Subject: Re: BUG #5703: Streaming replication: FATAL: bad buffer id: 0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group