Re: upgrade from 8.0.3 to 8.1.0 - Mailing list pgsql-admin

From Tom Lane
Subject Re: upgrade from 8.0.3 to 8.1.0
Date
Msg-id 15950.1131552029@sss.pgh.pa.us
Whole thread Raw
In response to Re: upgrade from 8.0.3 to 8.1.0  (Rafael Martinez Guerrero <r.m.guerrero@usit.uio.no>)
List pgsql-admin
Rafael Martinez Guerrero <r.m.guerrero@usit.uio.no> writes:
> On Tue, 2005-11-08 at 18:23, Moises Alberto Lindo Gutarra wrote:
>> you only need make postgres 8.1.0 run using another port, example 5438

> Or another IP/address (listen_addresses) and the same port 5432. ;)

No, because both postmasters will try to open /tmp/.s.PGSQL.5432 ...

You could maybe make the same-port trick work if you chroot one or both
postmasters, or relocate the socket directory to someplace besides /tmp,
but either of those approaches will make life difficult for clients
trying to make local non-TCP connections.  On the whole, separate port
number is the path of least resistance in almost all cases.

            regards, tom lane

pgsql-admin by date:

Previous
From: Joe Maldonado
Date:
Subject: autovacuum daemon question...
Next
From: Martin Fandel
Date:
Subject: Re: Fwd: resetting superuser password