X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5CD293A5ED5 for ; Thu, 13 Jan 2005 01:34:35 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 09969-02 for ; Thu, 13 Jan 2005 01:34:24 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 851973A5EC4 for ; Thu, 13 Jan 2005 01:34:27 +0000 (GMT) Received: from [192.168.1.20] (clbb-248.saw.net [64.146.135.248]) (authenticated bits=0) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id j0D1YNQ0031627; Wed, 12 Jan 2005 17:34:23 -0800 Message-ID: <41E5D032.1050702@commandprompt.com> Date: Wed, 12 Jan 2005 17:34:42 -0800 From: "Joshua D. Drake" User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Christopher Petrilli Cc: Peter Eisentraut , "Tomeh, Husam" , PgSQL ADMIN Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate! References: <200501130100.32307.peter_e@gmx.net> <59d991c405011216274c899584@mail.gmail.com> In-Reply-To: <59d991c405011216274c899584@mail.gmail.com> Content-Type: multipart/mixed; boundary="------------080902030206000007050905" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.034 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/93 X-Sequence-Number: 15952 This is a multi-part message in MIME format. --------------080902030206000007050905 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit >>The current recommendation, which is reflected in the installation >>instructions, is to install the software as root and to use the >>postgres user for the database files. The advice seen elsewhere in >>this thread to use the postgres user also for the software files is >>wrong. >> >> > >As a security professional, why would the root user need to be >involved in the ownership of PostgreSQL? > The root does not need to be involved. You don't even have to be root to install it ;). The only possible reason I can come up with is that if the root user (or any other user for that matter) owns the installation files, then the postgres user would not be able to accidently delete something. Sincerely, Joshua D. Drake > I see no reason for this, >but perhaps I'm missing something important. > >Chris > > -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL --------------080902030206000007050905 Content-Type: text/x-vcard; charset=utf-8; name="jd.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jd.vcf" begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard --------------080902030206000007050905--