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: <J(dot)K(dot)Shah(at)Sun(dot)COM>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(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 10:59:49
Message-ID: 46F5921DF52F6E40860287B30CADADC785F48D@EROS.nexus-ag.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi Jignesh

What things do I all need to take care when I want to run both postgres databases on the same box. Like the Solaris 10 postgres db and my postgres db.

What parameters to I need to change in the postgresql.conf file? Is there something else I need to take care?

Cheers Thomas

-----Original Message-----
From: J(dot)K(dot)Shah(at)Sun(dot)COM [mailto:J(dot)K(dot)Shah(at)Sun(dot)COM] 
Sent: Mittwoch, 30. April 2008 05:58
To: Thomas Bräutigam
Cc: Joshua D. Drake; Robert(dot)Lor(at)Sun(dot)COM; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Remove Postgres from Solaris 10

Here are my two cents:

You dont want to remove packages installed with Solaris by default.. 
However you may use your own Postgres packages or binaries in different location and not enable Postgres by default. (PostgreSQL is an integral part of Solaris 10 )

Don't forget some of Solaris's own tools like SunMC now uses the bundled postgres in the operating system and hence depends on its existence  and tested against it.

http://www.sun.com/bigadmin/sundocs/articles/sunmcnew.jsp


Removing PostgreSQL packages installed by default is not supported since upgrades to the Operating system will depend on those file installations to exist out in the preset locations. However that does not mean you cannot have your own binaries and use them at the default port. The default database is not enabled by default which means there is no collision of port numbers unless you want both database clusters to be enabled. If thats the case than changing Port numbers in either your database cluster or the default db instance (if init'ed by using svcadm start postgres_82:default  for the first time) in /var/postgres/8.2/data/postgresql.conf  should be fairly easy.


Other option is to use "OpenSolaris" CD images which does not have PostgreSQL installed by default as part of the "CD image" install as of now.

http://opensolaris.org/os/project/indiana/resources/getit/

-Jignesh


Thomas Bräutigam wrote:
> Hi Joshua,
>
> I think I have to explain it a little more detailed
>
> - my product uses a postgres database with the standart config (ports 
> etc.)
> - with Solaris 10 postgres is already installed as standart
> - I need to replace this Solaris 10 postgres installation with my 
> standart postgres database of my product
>
> That is the reason I need to remove the standart postgres installation from Solaris 10 that I can use my own postgres database.
>
> My concern is how I can remove this standart Solaris 10 postgres database as quick and efficient as possible that I can put in my postgres database?
>
> Cheers Thomas
>
>
>
> -----Original Message-----
> From: Joshua D. Drake [mailto:jd(at)commandprompt(dot)com]
> Sent: Mittwoch, 30. April 2008 02:33
> To: 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
>
> 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
>
>
> --
> The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
> PostgreSQL Community Conference: http://www.postgresqlconference.org/
> United States PostgreSQL Association: http://www.postgresql.us/ Donate 
> to the PostgreSQL Project: http://www.postgresql.org/about/donate
>
>
>
>
>   



In response to

Responses

pgsql-admin by date

Next:From: Thomas BräutigamDate: 2008-04-30 11:01:13
Subject: Re: Remove Postgres from Solaris 10
Previous:From: Joshua D. DrakeDate: 2008-04-30 04:07:30
Subject: Re: Remove Postgres from Solaris 10

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