pg_upgrade v9.1 issues

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.

Responses

Browse pgsql-bugs by date

  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