Re: pg_upgrade v9.1 issues - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: pg_upgrade v9.1 issues
Date
Msg-id 20120118144934.GA3050@momjian.us
Whole thread Raw
In response to Re: pg_upgrade v9.1 issues  (shitake <shitake83@googlemail.com>)
List pgsql-bugs
On Tue, Jan 17, 2012 at 06:38:46AM -0800, shitake wrote:
> I am having the same exact problem, migrating from 8.4SS to 9.1 .
>
> @Bruce_Momjian: Do you have a solution for this ??
>
> I have also opened a thread for this because I didn't find this thread
> before.
>
> http://postgresql.1045698.n5.nabble.com/Upgrade-Postgres-8-4SS-gt-gt-9-1-td5151661.html

Well, the first problem, which you solved, was that somehow the system
was not setup for 'trust'.

The second problem is that the server isn't stopping:

    There were problems executing ""D:/Program
    Files/PostgresPlus/8.4SS/bin/pg_ctl"
    -w -l "nul" -D "D:/Program Files/PostgresPlus/8.4SS/data" -m fast stop
                                                                        ------
    >> "nul" 2>&1"

Note the "stop" word at the end of the third line.  It is odd that
stopping is a problem, but it is on Windows, so perhaps there is some
odd configuration on that machine.  You might try starting and stopping
the system manually using the commands displayed and see if that works.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #6399: knngist sometimes returns tuples in incorrect order
Next
From: kenaniah@gmail.com
Date:
Subject: BUG #6401: IS DISTINCT FROM improperly compares geomoetric datatypes