Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 3A4A52E0037 for ; Wed, 30 Apr 2008 11:38:24 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 67019-01 for ; Wed, 30 Apr 2008 11:38:10 -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 893B32E002D for ; Wed, 30 Apr 2008 11:38:16 -0300 (ADT) X-IronPort-AV: E=Sophos;i="4.25,727,1199660400"; d="scan'208";a="104891" Received: from unknown (HELO hermes.nexustelecom.com) ([172.29.1.4]) by typhon.nexustelecom.com with ESMTP; 30 Apr 2008 12:59:50 +0200 Received: from hermes.nexustelecom.com (localhost [127.0.0.1]) by hermes.nexustelecom.com (Postfix) with ESMTP id 6884A159F64; Wed, 30 Apr 2008 12:59:50 +0200 (CEST) Received: from EROS.nexus-ag.com (eros.nexus-ag.com [172.29.2.99]) by hermes.nexustelecom.com (Postfix) with ESMTP id 54F02159F63; Wed, 30 Apr 2008 12:59:50 +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 12:59:49 +0200 Message-ID: <46F5921DF52F6E40860287B30CADADC785F48D@EROS.nexus-ag.com> In-Reply-To: <4817EE2E.2060705@sun.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] Remove Postgres from Solaris 10 Thread-Index: AciqdlXWQIkJKfvUTxmxYDc+jlviSgAOlLcg References: <46F5921DF52F6E40860287B30CADADC78172B9@EROS.nexus-ag.com> <48168B9A.8060704@sun.com> <46F5921DF52F6E40860287B30CADADC785F3EA@EROS.nexus-ag.com> <20080429165224.6d95756a@jd-laptop> <46F5921DF52F6E40860287B30CADADC785F3EE@EROS.nexus-ag.com> <20080429173304.3332f298@jd-laptop> <46F5921DF52F6E40860287B30CADADC785F3F4@EROS.nexus-ag.com> <4817EE2E.2060705@sun.com> From: =?iso-8859-1?Q?Thomas_Br=E4utigam?= To: Cc: "Joshua D. Drake" , , X-TBoneOriginalFrom: =?iso-8859-1?Q?Thomas_Br=E4utigam?= X-TBoneOriginalTo: X-TBoneOriginalCc: "Joshua D. Drake" , , X-TBoneDomainSigned: false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.223 tagged_above=0 required=5 tests=AWL=0.223 X-Spam-Level: X-Archive-Number: 200804/307 X-Sequence-Number: 29071 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.K.Shah@Sun.COM [mailto:J.K.Shah@Sun.COM]=20 Sent: Mittwoch, 30. April 2008 05:58 To: Thomas Br=E4utigam Cc: Joshua D. Drake; Robert.Lor@Sun.COM; pgsql-admin@postgresql.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..=20 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=E4utigam 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=20 > etc.) > - with Solaris 10 postgres is already installed as standart > - I need to replace this Solaris 10 postgres installation with my=20 > 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@commandprompt.com] > Sent: Mittwoch, 30. April 2008 02:33 > To: 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 > > On Wed, 30 Apr 2008 01:59:08 +0200 > Thomas Br=E4utigam wrote: > > =20 >> Hi Joshua >> >> The problem is this that I need this ports for my default postgres=20 >> database. >> >> 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. > > Joshua D. Drake > > > -- > The PostgreSQL Company since 1997: http://www.commandprompt.com/=20 > 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 > > > > > =20