Lists: | pgsql-bugs |
---|
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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | Chris English <sglish(at)hotmail(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: pg_dumpall -> by hand without --binary-upgrade or BUG #5690: pg_upgrade fails |
Date: | 2010-10-11 23:15:52 |
Message-ID: | 4CB39AA8.9000906@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
On 10/11/10 4:09 PM, Chris English wrote:
>
> C:\WINDOWS\system32>pg_dumpall.exe --port 5433 username--"postgres"
> --schema-onl
> y >"c:/windows/system32/pg_upgrade_dump_all.sql"
> Access is denied.
>
why are you writing the .sql output to the windows system32 directory?!?!?
thats a TERRIBLE place to put that.
From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Chris English <sglish(at)hotmail(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org, Bruce Momjian <bruce(at)momjian(dot)us> |
Subject: | Re: pg_dumpall -> by hand without --binary-upgrade or BUG #5690: pg_upgrade fails |
Date: | 2010-10-12 00:49:23 |
Message-ID: | AANLkTimY6UKs5eAB1Rens_hji9rGLNtLB-xGcPQnoo2i@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
On Mon, Oct 11, 2010 at 7:09 PM, Chris English <sglish(at)hotmail(dot)com> wrote:
> 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/postgres
> ql/8.4/data" -D "c:/program files/postgresql/9.0/data" -b "c:/program
> files/post
> gresql/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)ok
> Checking old bin directory (c:/program files/postgresql/8.4/bin)ok
> Checking new data directory (c:/program files/postgresql/9.0/data)ok
> Checking new bin directory (c:/program files/postgresql/9.0/bin)ok
> Checking for reg* system oid user data types ok
> Checking for /contrib/isn with bigint-passing mismatch ok
> Checking for large objects ok
> Creating 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\s
> ystem32/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-onl
> y >"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 Log
> 2010-10-11 18:14:28 EDTLOG: database system was shut down at 2010-10-11
> 17:59:17 EDT
> 2010-10-11 18:14:29 EDTLOG: database system is ready to accept connections
> 2010-10-11 18:14:35 EDTLOG: received fast shutdown request
> 2010-10-11 18:14:35 EDTLOG: aborting any active transactions
> 2010-10-11 18:14:35 EDTLOG: shutting down
> 2010-10-11 18:14:35 EDTLOG: database system is shut down
> 9.0 Log
> 2010-10-11 17:14:18 EDT LOG: database system was shut down at 2010-10-11
> 16:25:16 EDT
> 2010-10-11 17:14:18 EDT FATAL: the database system is starting up
> 2010-10-11 17:14:19 EDT LOG: database system is ready to accept connections
> 2010-10-11 17:14:19 EDT LOG: autovacuum launcher started
> 2010-10-11 17:34:58 EDT LOG: received fast shutdown request
> 2010-10-11 17:34:58 EDT LOG: aborting any active transactions
> 2010-10-11 17:34:58 EDT LOG: autovacuum launcher shutting down
> 2010-10-11 17:34:58 EDT LOG: shutting down
> 2010-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
Is there any way we can crank up the debug level during those 20
minutes the new database is up? Or look at pg_stat_activity? What is
it doing during all that time?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From: | Harald Armin Massa <chef(at)ghum(dot)de> |
---|---|
To: | Chris English <sglish(at)hotmail(dot)com> |
Cc: | "<pgsql-bugs(at)postgresql(dot)org>" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: pg_dumpall -> by hand without --binary-upgrade or BUG #5690: pg_upgrade fails |
Date: | 2010-10-12 02:29:36 |
Message-ID: | CD6566F2-BBC2-47E2-88D3-49A306298087@ghum.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
Please try to change you cuttent working directory to a place you have Write-Access before pg_upgrade
As in cd \temp or cd %Home%
Harald
Am 12.10.2010 um 01:09 schrieb Chris English <sglish(at)hotmail(dot)com>:
> 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/postgres
> ql/8.4/data" -D "c:/program files/postgresql/9.0/data" -b "c:/program files/post
> gresql/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)ok
> Checking old bin directory (c:/program files/postgresql/8.4/bin)ok
> Checking new data directory (c:/program files/postgresql/9.0/data)ok
> Checking new bin directory (c:/program files/postgresql/9.0/bin)ok
> Checking for reg* system oid user data types ok
> Checking for /contrib/isn with bigint-passing mismatch ok
> Checking for large objects ok
> Creating 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\s
> ystem32/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-onl
> y >"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 Log
> 2010-10-11 18:14:28 EDTLOG: database system was shut down at 2010-10-11 17:59:17 EDT
> 2010-10-11 18:14:29 EDTLOG: database system is ready to accept connections
> 2010-10-11 18:14:35 EDTLOG: received fast shutdown request
> 2010-10-11 18:14:35 EDTLOG: aborting any active transactions
> 2010-10-11 18:14:35 EDTLOG: shutting down
> 2010-10-11 18:14:35 EDTLOG: database system is shut down
>
> 9.0 Log
> 2010-10-11 17:14:18 EDT LOG: database system was shut down at 2010-10-11 16:25:16 EDT
> 2010-10-11 17:14:18 EDT FATAL: the database system is starting up
> 2010-10-11 17:14:19 EDT LOG: database system is ready to accept connections
> 2010-10-11 17:14:19 EDT LOG: autovacuum launcher started
> 2010-10-11 17:34:58 EDT LOG: received fast shutdown request
> 2010-10-11 17:34:58 EDT LOG: aborting any active transactions
> 2010-10-11 17:34:58 EDT LOG: autovacuum launcher shutting down
> 2010-10-11 17:34:58 EDT LOG: shutting down
> 2010-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
>
>
>
>