Re: Remove Postgres from Solaris 10

From: Thomas Bräutigam <thomas(dot)braeutigam(at)nexustelecom(dot)com>
To: "Igor Polishchuk" <ipolishchuk(at)hi5(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: <J(dot)K(dot)Shah(at)Sun(dot)COM>, <Robert(dot)Lor(at)Sun(dot)COM>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Remove Postgres from Solaris 10
Date: 2008-04-30 11:01:13
Message-ID: 46F5921DF52F6E40860287B30CADADC785F48E@EROS.nexus-ag.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 = 'data directory for a particular DB here'
listen_addresses = 'VIP here'
port = 5432

Cheers Thomas

-----Original Message-----
From: Igor Polishchuk [mailto:ipolishchuk(at)hi5(dot)com]
Sent: Mittwoch, 30. April 2008 03:57
To: Joshua D. Drake; Thomas Bräutigam
Cc: J(dot)K(dot)Shah(at)Sun(dot)COM; Robert(dot)Lor(at)Sun(dot)COM; pgsql-admin(at)postgresql(dot)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 = 'data directory for a particular DB here'
listen_addresses = 'VIP here'
port = 5432

On 4/29/08 5:33 PM, "Joshua D. Drake" <jd(at)commandprompt(dot)com> wrote:

> On Wed, 30 Apr 2008 01:59:08 +0200
> Thomas Bräutigam <thomas(dot)braeutigam(at)nexustelecom(dot)com> wrote:
>
>> Hi Joshua
>>
>> The problem is this that I need this ports for my default postgres
>> database.
>>
>> Is it than possible to have 2 default postgres databases in parallel?
>> Same ports etc.....?
>
> 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.
>
> Joshua D. Drake
>

--

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message e t 2008-04-30 12:15:36 Re: server crash, need to restore DB functionality
Previous Message Thomas Bräutigam 2008-04-30 10:59:49 Re: Remove Postgres from Solaris 10