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 E64B03A5DFD for ; Thu, 13 Jan 2005 00:51:05 +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 04501-09 for ; Thu, 13 Jan 2005 00:50:58 +0000 (GMT) Received: from mail2.dbitech.ca (radius.wavefire.com [64.141.13.252]) by svr1.postgresql.org (Postfix) with SMTP id 2E1003A5025 for ; Thu, 13 Jan 2005 00:51:00 +0000 (GMT) Received: (qmail 4606 invoked from network); 13 Jan 2005 02:06:10 -0000 Received: from dbitech.wavefire.com (HELO ?64.141.15.253?) (darcy@64.141.15.253) by radius.wavefire.com with SMTP; 13 Jan 2005 02:06:10 -0000 From: Darcy Buskermolen Organization: Wavefire Technologies Corp. To: "Joshua D. Drake" Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate! Date: Wed, 12 Jan 2005 16:50:58 -0800 User-Agent: KMail/1.6.2 Cc: Peter Eisentraut , "Tomeh, Husam" , PgSQL ADMIN References: <200501130100.32307.peter_e@gmx.net> <41E5C177.1000804@commandprompt.com> In-Reply-To: <41E5C177.1000804@commandprompt.com> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200501121650.58255.darcy@wavefire.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.054 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200501/92 X-Sequence-Number: 15951 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). -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759 http://www.wavefire.com