Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group