Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id C446C2E004C for ; Tue, 29 Apr 2008 23:05:12 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 94486-04 for ; Tue, 29 Apr 2008 23:05:00 -0300 (ADT) X-Greylist: delayed 00:07:18.442058 by SQLgrey-1.7.5 Received: from exprod6og103.obsmtp.com (exprod6og103.obsmtp.com [64.18.1.185]) by developer.postgresql.org (Postfix) with SMTP id D60862E0033 for ; Tue, 29 Apr 2008 23:05:08 -0300 (ADT) Received: from source ([63.240.6.3]) (using TLSv1) by exprod6ob103.postini.com ([64.18.5.12]) with SMTP; Tue, 29 Apr 2008 19:05:06 PDT Received: from d01smtp03.Mi8.com ([172.16.1.24]) by Outbound02.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Tue, 29 Apr 2008 22:00:21 -0400 Received: from MI8NYCMAIL15.Mi8.com ([172.16.1.198]) by d01smtp03.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Tue, 29 Apr 2008 22:00:21 -0400 Received: from 71.5.1.212 ([71.5.1.212]) by MI8NYCMAIL15.Mi8.com ([172.16.1.215]) via Exchange Front-End Server mi8owa.mi8.com ([172.16.1.105]) with Microsoft Exchange Server HTTP-DAV ; Wed, 30 Apr 2008 01:59:27 +0000 User-Agent: Microsoft-Entourage/12.1.0.080305 Date: Tue, 29 Apr 2008 18:56:51 -0700 Subject: Re: Remove Postgres from Solaris 10 From: Igor Polishchuk To: "Joshua D. Drake" , Thomas =?ISO-8859-1?B?QnLkdXRpZ2Ft?= CC: , , Message-ID: Thread-Topic: [ADMIN] Remove Postgres from Solaris 10 Thread-Index: AciqZXTqz6h+81uY60iWc7sO4yHBeA== In-Reply-To: <20080429173304.3332f298@jd-laptop> Mime-version: 1.0 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable X-OriginalArrivalTime: 30 Apr 2008 02:00:21.0677 (UTC) FILETIME=[F27D35D0:01C8AA65] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.624 tagged_above=0 required=5 tests=DNS_FROM_AHBL_RHSBL=2.025, RCVD_IN_DNSWL_MED=-4, RCVD_NUMERIC_HELO=2.599 X-Spam-Level: X-Archive-Number: 200804/301 X-Sequence-Number: 29065 In our organization, we are running multiple databases on the same box on the default port. However, they all have their own data directories and the= y listen on different VIP's. Here are the parameters in postrgresql.conf to make it work: unix_socket_directory =3D 'data directory for a particular DB here' listen_addresses =3D 'VIP here' port =3D 5432 On 4/29/08 5:33 PM, "Joshua D. Drake" wrote: > On Wed, 30 Apr 2008 01:59:08 +0200 > Thomas Br=E4utigam wrote: >=20 >> Hi Joshua=20 >>=20 >> The problem is this that I need this ports for my default postgres >> database. >>=20 >> Is it than possible to have 2 default postgres databases in parallel? >> Same ports etc.....? >=20 > I am afraid I don't understand what you are asking. You can't have two > postgresql installations bound to the same port. You can have two > postgresql installations pointing to different ports on the same > machine. >=20 > Joshua D. Drake >=20 --=20