On Wed, Dec 28, 2011 at 03:38:26PM +0100, Alexander Fortin wrote: > 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++) > { Sorry for the late reply. Did you have a PGHOST variable set to something? That might have caused the problem. Your change basically forces it to do a tcp connection to the local database --- the default is to do a unix-domain socket/local connection to the database. Glad you finally got it working. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin