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 EA1DA3A4FE6 for ; Thu, 13 Jan 2005 00:32:09 +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 01201-10 for ; Thu, 13 Jan 2005 00:31:59 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id C82783A4B23 for ; Thu, 13 Jan 2005 00:32:01 +0000 (GMT) Received: from [192.168.1.51] (dsl093-038-087.pdx1.dsl.speakeasy.net [66.93.38.87]) (authenticated bits=0) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id j0D0VwQ0027925; Wed, 12 Jan 2005 16:31:58 -0800 Message-ID: <41E5C177.1000804@commandprompt.com> Date: Wed, 12 Jan 2005 16:31:51 -0800 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Peter Eisentraut Cc: "Tomeh, Husam" , PgSQL ADMIN Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate! References: <200501130100.32307.peter_e@gmx.net> In-Reply-To: <200501130100.32307.peter_e@gmx.net> Content-Type: multipart/mixed; boundary="------------000806060006040702020407" 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/91 X-Sequence-Number: 15950 This is a multi-part message in MIME format. --------------000806060006040702020407 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Peter Eisentraut wrote: > Tomeh, Husam wrote: > >>I've seen book that prefer installing PostgreSQL as root and another >>one recommends otherwise by first creating a postgres account and >>then installing it as postgres. In the Oracle world, you don't use >>root to install the software. What is the best practice as far as >>PostgreSQL goes? > > > 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. If the user owns the catalog, there is no reason for that user to not also own the files. Sincerely, Joshua D. Drake > -- Command Prompt, Inc., your source for PostgreSQL replication, professional support, programming, managed services, shared and dedicated hosting. Home of the Open Source Projects plPHP, plPerlNG, pgManage, and pgPHPtoolkit. Contact us now at: +1-503-667-4564 - http://www.commandprompt.com --------------000806060006040702020407 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 D. Drake n:Drake;Joshua D. org:Command Prompt, Inc. adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl. x-mozilla-html:FALSE url:http://www.commandprompt.com/ version:2.1 end:vcard --------------000806060006040702020407--