Re: Can't upgrade a DB from 8.4 to 9.3 with pg_uprade: pg 9 not started

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux