From: Bruce Momjian <bruce@momjian.us>
To: Alexander Fortin <alexander.fortin@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Can't get pg_upgrade work for 8.4
Date: Thu, 19 Jan 2012 17:12:02 -0500
Message-ID: <20120119221202.GA24409@momjian.us> (raw)
In-Reply-To: <4EFB29E2.3060104@gmail.com>
References: <4EF0A59B.9080202@gmail.com>
<4EFB29E2.3060104@gmail.com>
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@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bruce@momjian.us, alexander.fortin@gmail.com
Subject: Re: Can't get pg_upgrade work for 8.4
In-Reply-To: <20120119221202.GA24409@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox