Message-ID: <4EFB29E2.3060104@gmail.com>
Date: Wed, 28 Dec 2011 15:38:26 +0100
From: Alexander Fortin <alexander.fortin@gmail.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7;
	rv:8.0) Gecko/20111105 Thunderbird/8.0
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: Can't get pg_upgrade work for 8.4
References: <4EF0A59B.9080202@gmail.com>
In-Reply-To: <4EF0A59B.9080202@gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Seems that the problem resides in the pg_ctl packaged with Ubuntu 10.04, 
the only way we found to fix this was to recompile Postgresql 8.4.9 from 
sources using the following patch, than instruct pg_upgrade (9.1.2) to 
use the hand compiled pg_ctl instead of the original one (a raw symlink 
did the job).

Here's the patch, maybe someone could need it.


*** pg_ctl.c.orig       2011-12-27 14:52:27.000000000 +0000
--- pg_ctl.c    2011-12-27 15:20:25.000000000 +0000
***************
*** 503,509 ****
          * probably timeout first
          */
         snprintf(connstr, sizeof(connstr),
!                        "dbname=postgres port=%s connect_timeout=5", 
portstr);

         for (i = 0; i < wait_seconds; i++)
         {
--- 503,509 ----
          * probably timeout first
          */
         snprintf(connstr, sizeof(connstr),
!                        "dbname=postgres port=%s connect_timeout=5 
host=localhost", portstr);

         for (i = 0; i < wait_seconds; i++)
         {


Happy new year!

-- 
Alexander Fortin
http://about.me/alexanderfortin/