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@xxxxxxxxxx> 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@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin