X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D2F7153251 for ; Tue, 19 Apr 2005 02:48:49 -0300 (ADT) 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 51810-09 for ; Tue, 19 Apr 2005 05:48:41 +0000 (GMT) Received: from mail.eulerhermes.pl (mail.hermes-kredit.pl [217.153.119.83]) by svr1.postgresql.org (Postfix) with ESMTP id 091175336B for ; Tue, 19 Apr 2005 02:48:37 -0300 (ADT) Received: from [192.168.69.4] (helo=[127.0.0.1] ident=nobody) by mail.eulerhermes.pl with esmtpa (Exim 4.42) id 1DNlbB-00060S-25; Tue, 19 Apr 2005 07:48:37 +0200 Message-ID: <426498D7.5020802@eulerhermes.pl> Date: Tue, 19 Apr 2005 07:36:23 +0200 From: Marcin Giedz User-Agent: Mozilla/5.0 (X11; U; Linux i686; pl-PL; rv:1.7.3) Gecko/20040913 X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: Marek Dabrowski Cc: pgsql-admin@postgresql.org Subject: Re: Lock file References: <42649719.2040005@infor.pl> In-Reply-To: <42649719.2040005@infor.pl> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.083 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/254 X-Sequence-Number: 17267 Użytkownik Marek Dabrowski napisał: > Hello > > I've server with two addresses IP on one net interface. I would like > start on it two instances postgresql, eg: 192.168.1.2:5432 (7.4.6) and > 192.168.1.3:5432 (8.0.2). But when try to start second one, postmaster > write error that /tmp/.s.PGSQL.5432.lock alredy exist. How to avoid > this problem? > Hi, You have to change port parameter in postgresql.conf - default is 5432 so leave 5432 for first instance and change to 5433 for the second one. That's all. BR, Marcin > Regards > Marek > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend >