Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DC3EF2E00F4 for ; Sat, 9 Feb 2008 04:12:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 84022-06 for ; Sat, 9 Feb 2008 04:12:08 -0400 (AST) Received: from gw.blueface.com (unknown [213.200.94.184]) by postgresql.org (Postfix) with ESMTP id B66892E0090 for ; Sat, 9 Feb 2008 04:12:10 -0400 (AST) Received: (qmail 26963 invoked by uid 20008); 9 Feb 2008 08:12:08 -0000 Received: from 89.100.128.76 (bruce.mcalister@blueface.ie@89.100.128.76) by bfiemail (envelope-from , uid 0) with qmail-scanner-2.01st (clamdscan: 0.88.6/2242. spamassassin: 3.1.7. perlscan: 2.01st. Clear:RC:1(89.100.128.76):. Processed in 0.111806 secs); 09 Feb 2008 08:12:08 -0000 Received: from unknown (HELO ?192.168.10.2?) (bruce.mcalister@blueface.ie@89.100.128.76) by gw.blueface.com with ESMTPA; 9 Feb 2008 08:12:08 -0000 Message-ID: <47AD6056.6050007@blueface.ie> Date: Sat, 09 Feb 2008 08:12:06 +0000 From: Bruce McAlister Reply-To: bruce.mcalister@blueface.ie Organization: Blueface Ireland Ltd User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: n0g0013 CC: Bhella Paramjeet-PFCW67 , pgsql-admin@postgresql.org Subject: Re: Postgres 8.2 install on solaris 10 References: <20080205195839.GD297@holyman.cobbled.net> <20080208113221.GB17558@holyman.cobbled.net> In-Reply-To: <20080208113221.GB17558@holyman.cobbled.net> X-Enigmail-Version: 0.95.6 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.709 tagged_above=0 required=5 tests=AWL=-0.459, BAYES_50=0.001, RCVD_NUMERIC_HELO=2.067, RDNS_NONE=0.1 X-Spam-Level: * X-Archive-Number: 200802/113 X-Sequence-Number: 28187 PostgreSQL 8.2 is released with Solaris 10 Update 4 (8/07). With regards the Cluster requiring the binaries to be in a shared home, this is not strictly true. If you have 2 nodes in the cluster, both nodes running S10U4, then the binaries will both be located in the same area. You could have the data area and configuration files on the cluster file system (shared area) which would be read by each invocation of the local binaries on each node if failed over. n0g0013 wrote: > On 06.02-12:40, Bhella Paramjeet-PFCW67 wrote: >> [ ... ] >>> We are considering having postgres 8.2 on solaris 10 machine for our >>> production environment. While reading through sun docs, it looks like >>> the solaris 10 update 6 onwards comes with the postgres 8.2 installed >>> under /usr/postgres/8.2 . My question is can we have postgres binaries >>> under a different location like /usr/local/a01 ( shared home ). I know >>> I can install from source and can have postgres binaries where ever I >>> want but here we have to use sun compiled postgres binaries in order >>> to get support. So is there an option during solaris install to have >>> postgres installed in a different location. Any help will be highly >>> appreciated. >> short answer is no but you shouldn't need to move the binaries and >> libraries in order to move the database. if you explain why that's a >> requirement i'll put some more thought into it (creating a zone in that >> location springs to mind but it's not exactly the same thing). > [ ... ] >> We wanted to have the postgres binaries in shared home. One of the main >> requirement for sun cluster is to have the binaries in shared home. > > hmmm. that's a pain. i would create a zone and leave it inactive. > if that was undesired i'd probably get the pre-comiled binaries from > sunfreeware and link /usr/local to my shared home. but, to be honest > i feel that building from source is by far the best option. > -- +-------------------------------------------------------+ | Bruce McAlister Blueface Ltd | | http://www.blueface.ie | +-------------------------------------------------------+