From: | lalong <lalong1(at)charter(dot)net> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | pg_upgrade v9.1 issues |
Date: | 2011-10-11 17:35:19 |
Message-ID: | 1318354519039-4892564.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I have 2 instances of postgres installed on same machine under Vista and have
run into the following issues when trying to migrate my data from one
instance into the other....
1) If the upgrade process fails, the postmaster.tid file may remain even
though the postmaster service is no longer running. I have to manually
delete it to re-try. This may occur in either the source or target area.
2) Recommend adding additional parameters to allow specifying target and
source roles & pw's. I was getting errors when the same role does not exist
in both instances.
3) Received the following error
*********
C:\Program Files\PostgreSQL\9.1\bin>pg_upgrade --old-datadir
"D:\servoy6\application_server\database" --new-datadir "c:\program
files\postgresql\9.1\data" --old-bindir
"D:\servoy6\application_server\postgres_db\bin" --new-bindir "c:\program
files\postgresql\9.1\bin"
Performing Consistency Checks
-----------------------------
Checking current, bin, and data directories ok
Checking cluster versions ok
Checking database user is a superuser ok
Checking for prepared transactions ok
Checking for reg* system oid user data types ok
Checking for contrib/isn with bigint-passing mismatch ok
Creating catalog dump ok
There were problems executing
""D:\servoy6\application_server\postgres_db\bin/pg_ctl" -w -l "nul" -D
"D:\servoy6\application_server\database" stop >> "nul" 2>&1"
Failure, exiting
*********
Note: I don't know if this matters, but the target (new v9.1) source has
instance set to start automatically in services. The source (old v9.0) is
not. The error is referring to the source instance. Apparently, it is
trying to shut the service down and if it is already down, then it errors
out as opposed to continuing on.
Thanks,
Larry Long
--
View this message in context: http://postgresql.1045698.n5.nabble.com/pg-upgrade-v9-1-issues-tp4892564p4892564.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2011-10-11 18:39:28 | Re: pg_upgrade v9.1 issues |
Previous Message | Robert Haas | 2011-10-11 15:53:34 | Re: BUG #6251: cannot create roles that can actually login |