X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 688ACD9598 for ; Wed, 9 Nov 2005 12:00:40 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 80760-09 for ; Wed, 9 Nov 2005 16:00:39 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id E337FD93E9 for ; Wed, 9 Nov 2005 12:00:38 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id jA9G0Tj0015951; Wed, 9 Nov 2005 11:00:29 -0500 (EST) To: Rafael Martinez Guerrero Cc: Moises Alberto Lindo Gutarra , Dan The Man , pgsql-admin@postgresql.org Subject: Re: upgrade from 8.0.3 to 8.1.0 In-reply-to: <1131537444.30063.164.camel@bbking.uio.no> References: <5db591c00511080923u36c20fc8u@mail.gmail.com> <1131537444.30063.164.camel@bbking.uio.no> Comments: In-reply-to Rafael Martinez Guerrero message dated "Wed, 09 Nov 2005 12:57:25 +0100" Date: Wed, 09 Nov 2005 11:00:29 -0500 Message-ID: <15950.1131552029@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.006 required=5 tests=[AWL=0.006] X-Spam-Score: 0.006 X-Spam-Level: X-Archive-Number: 200511/89 X-Sequence-Number: 19462 Rafael Martinez Guerrero 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