From: Alexander Fortin <alexander.fortin@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Can't get pg_upgrade work for 8.4
Date: Wed, 28 Dec 2011 15:38:26 +0100
Message-ID: <4EFB29E2.3060104@gmail.com> (raw)
In-Reply-To: <4EF0A59B.9080202@gmail.com>
References: <4EF0A59B.9080202@gmail.com>
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.
inline patch 1: pg_ctl.c (+0/-1 lines) download inline-1.patch*** 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/
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: alexander.fortin@gmail.com
Subject: Re: Can't get pg_upgrade work for 8.4
In-Reply-To: <4EFB29E2.3060104@gmail.com>
* 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