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 AAE873A5E55 for ; Thu, 13 Jan 2005 01:35:53 +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 10222-03 for ; Thu, 13 Jan 2005 01:35:46 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 6F3A23A501C for ; Thu, 13 Jan 2005 01:35:49 +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 j0D1ZkQ0031760; Wed, 12 Jan 2005 17:35:46 -0800 Message-ID: <41E5D084.6070401@commandprompt.com> Date: Wed, 12 Jan 2005 17:36:04 -0800 From: "Joshua D. Drake" User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Darcy Buskermolen Cc: Peter Eisentraut , "Tomeh, Husam" , PgSQL ADMIN Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate! References: <200501130100.32307.peter_e@gmx.net> <41E5C177.1000804@commandprompt.com> <200501121650.58255.darcy@wavefire.com> In-Reply-To: <200501121650.58255.darcy@wavefire.com> Content-Type: multipart/mixed; boundary="------------020807090901010501080408" 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/94 X-Sequence-Number: 15953 This is a multi-part message in MIME format. --------------020807090901010501080408 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Darcy Buskermolen wrote: >On January 12, 2005 04:31 pm, Joshua D. Drake wrote: > > >>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 >> >> > >Isn't there a requiremnet of writing libpq.so to a location that ldconfig can >make use of it? By default FreeBSD won't let you ldconfig a file that isn't >owned by root (or that is in a directory that is writeable by anybody other >than members of group 0). > > Now that is interesting. That is not a problem on Linux. I didn't know that FreeBSD was like that. Sincerely, Joshua D. Drake > > > > -- 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 --------------020807090901010501080408 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 --------------020807090901010501080408--