Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id C2F652E0049 for ; Wed, 30 Apr 2008 11:40:23 -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 91210-01-5 for ; Wed, 30 Apr 2008 11:39:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from typhon.nexustelecom.com (typhon.nexustelecom.com [212.203.104.229]) by developer.postgresql.org (Postfix) with ESMTP id 711A22E0064 for ; Wed, 30 Apr 2008 11:39:43 -0300 (ADT) X-IronPort-AV: E=Sophos;i="4.25,727,1199660400"; d="scan'208";a="104893" Received: from unknown (HELO hermes.nexustelecom.com) ([172.29.1.4]) by typhon.nexustelecom.com with ESMTP; 30 Apr 2008 13:01:28 +0200 Received: from hermes.nexustelecom.com (localhost [127.0.0.1]) by hermes.nexustelecom.com (Postfix) with ESMTP id 4C6C1159F64; Wed, 30 Apr 2008 13:01:28 +0200 (CEST) Received: from EROS.nexus-ag.com (nexus-ag.com [172.29.2.99]) by hermes.nexustelecom.com (Postfix) with ESMTP id BC26B159F63; Wed, 30 Apr 2008 13:01:15 +0200 (CEST) X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: Re: Remove Postgres from Solaris 10 Date: Wed, 30 Apr 2008 13:01:13 +0200 Message-ID: <46F5921DF52F6E40860287B30CADADC785F48E@EROS.nexus-ag.com> In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] Remove Postgres from Solaris 10 Thread-Index: AciqZXTqz6h+81uY60iWc7sO4yHBeAAS99EQ References: <20080429173304.3332f298@jd-laptop> From: =?iso-8859-1?Q?Thomas_Br=E4utigam?= To: "Igor Polishchuk" , "Joshua D. Drake" Cc: , , X-TBoneOriginalFrom: =?iso-8859-1?Q?Thomas_Br=E4utigam?= X-TBoneOriginalTo: "Igor Polishchuk" , "Joshua D. Drake" X-TBoneOriginalCc: , , X-TBoneDomainSigned: false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.207 tagged_above=0 required=5 tests=AWL=0.207 X-Spam-Level: X-Archive-Number: 200804/308 X-Sequence-Number: 29072 Is this than everyhting I need to take care when I run this both = standard databases or do I need to configure or change something else? unix_socket_directory =3D 'data directory for a particular DB here' listen_addresses =3D 'VIP here' port =3D 5432 Cheers Thomas -----Original Message----- From: Igor Polishchuk [mailto:ipolishchuk@hi5.com]=20 Sent: Mittwoch, 30. April 2008 03:57 To: Joshua D. Drake; Thomas Br=E4utigam Cc: J.K.Shah@Sun.COM; Robert.Lor@Sun.COM; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Remove Postgres from Solaris 10 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 they 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 >> The problem is this that I need this ports for my default postgres=20 >> 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=20 > postgresql installations pointing to different ports on the same=20 > machine. >=20 > Joshua D. Drake >=20 --=20