Re: Can't get pg_upgrade work for 8.4 - Mailing list pgsql-admin

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/