From: Bruce Momjian <bruce@momjian.us>
To: Sebastien Douche <sdouche@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Can't upgrade a DB from 8.4 to 9.3 with pg_uprade: pg 9 not started
Date: Mon, 17 Feb 2014 12:54:02 -0500
Message-ID: <20140217175402.GA18934@momjian.us> (raw)
In-Reply-To: <CAAGHeXGjTR0=4sb0584f3PhkVwwZUJaA-Cb4nxrTctg-4mst=g@mail.gmail.com>
References: <CAAGHeXGgzByn_eP72eDDVEUyDJDcCK6HL+-sDWev8y0f8smtzA@mail.gmail.com>
<20140214021551.GB3244@momjian.us>
<CAAGHeXGjTR0=4sb0584f3PhkVwwZUJaA-Cb4nxrTctg-4mst=g@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On Fri, Feb 14, 2014 at 06:16:02PM +0100, Sebastien Douche wrote:
> On Fri, Feb 14, 2014 at 3:15 AM, Bruce Momjian <bruce@momjian.us> wrote:\
>
> Hi Bruce,
> thanks for your time.
>
> > This is using /tmp because the old server is pre-9.1; it would normally
> > use the current directory for the socket file. Are you perhaps using a
> > non-standard setting? Our docs say:
> >
> > If using a pre-9.1 old server that is using a non-default Unix-domain
> > socket directory or a default that differs from the default of the
> > new cluster, set <envar>PGHOST</> to point to the old server's socket
> > location. (This is not relevant on Windows.)
>
> Right, but It's broken also if I set unix_socket_directory to /tmp.
Oh.
> > Does that help? Did you use a different environment for the check and
> > non-check phases?
>
> I found a fiable solution: remove the -w option on the pg_ctl' wrapper
> (and added sleep 5 for waiting the launch) when pg_upgrade want to
> start PG. Tested on several db w/o issues. This option is broken on PG
> <9 (several workaround exist in the code of pg_upgrade for it).
Oh, that's interesting. We used to have a loop in there for cases where
you we couldn't use -w, like for non-default connection settings, but I
thought -w still worked for defaults, even back to 8.4.
It is possible we removed something that we should no one needed anymore
but that 8.4 needs, but I am unclear what that would be.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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, sdouche@gmail.com
Subject: Re: Can't upgrade a DB from 8.4 to 9.3 with pg_uprade: pg 9 not started
In-Reply-To: <20140217175402.GA18934@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