Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 8BBCC2E2DAD for ; Sun, 30 Dec 2007 07:23:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 04223-07 for ; Sun, 30 Dec 2007 07:23:33 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.181]) by postgresql.org (Postfix) with ESMTP id 380AA2E2D3E for ; Sun, 30 Dec 2007 07:23:36 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so7119778waf.5 for ; Sun, 30 Dec 2007 03:23:35 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=80X4WUOnhGkhinYw2plPJK4omaJtn14t6xV6MTS9280=; b=TUa5FWEQcYgJ8fPXKLZaqJyfmdAFor9wU0nYA3yds5kOBQKHR8catkW5vk5YDOUlKa2S+CEoPXJFr781hxLUgtFk15NI9n99kb++SG+3w/8C876ekd1qXCss9s6oHz3L86p+7oZorwPHiuFsOwTRTBSf5TDDP4m+7Y2W4p1R9+Y= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=PBUWgBOFkwyYi05le8QubB8N1J9O+X/fH+96FKZ0l+cxmmOgS0pLKDVWp0U5VasepWk7bbb8+REXz9pX7eoWQx6pfsaDmey5A/uKAUXTVtSHXV4Cegc9c26S8StKoR9laeuf+7REFZPBmecjrwnH5/EHaT9OhE4MxO8So+Rm92A= Received: by 10.142.251.9 with SMTP id y9mr2013405wfh.43.1199013815757; Sun, 30 Dec 2007 03:23:35 -0800 (PST) Received: by 10.142.153.3 with HTTP; Sun, 30 Dec 2007 03:23:35 -0800 (PST) Message-ID: <9ef66fac0712300323v7f4f043ay89f29fc584953c7b@mail.gmail.com> Date: Sun, 30 Dec 2007 06:23:35 -0500 From: "Albretch Mueller" To: pgsql-admin@postgresql.org Subject: Re: separating PG binaries into a ro mounted partition Cc: phillip.smith@weatherbeeta.com.au In-Reply-To: <1198993317.5591.19.camel@cassandra-desktop> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <9ef66fac0712291840k5174fd7bp3558c0944eecd64a@mail.gmail.com> <1198993317.5591.19.camel@cassandra-desktop> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.069 tagged_above=0 required=5 tests=AWL=1.316, BAYES_00=-2.599, FROM_LOCAL_NOVOWEL=3.196, SUBJECT_FUZZY_TION=0.156 X-Spam-Level: ** X-Archive-Number: 200712/244 X-Sequence-Number: 27761 > Phillip Smith wrote: > What are you trying to acheive by making the binaries read-only? ~ * convinience: If I have PG on a baseline Linux distro running from a USB stick or CD (or a mini-DVD) and I go around with my micro drive, I could just sit anywhere they have a PC with a USB port or CD-player and an available USB/or firewire port for my micro device. ~ This is why I need to also be able to configure the mount point my PGDATA will be in. I have done that before with mysql and it works just fine, but PG is more appealing for me because it has features I need and it is more committed to java. ~ * security: I could go anywhere knowing that as long as I mount/configure PG and other apps I have, such as tomcat, as read-only it is impossibly hard for people to alter my files even though they could tinker with the BIOS and RAM ~ Also config files could stay where they be, because they don't/shouldn't change as PG runs. I only need to put in a separate writable (&/|| updatable) and appendable filesystem areas all other data ~ So, what are the installation options to acheive what I specified in the OP? ~ thanks lbrtchx