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 DAB353A596E for ; Thu, 13 Jan 2005 18:00:02 +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 78035-03 for ; Thu, 13 Jan 2005 17:59:57 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 22E193A522F for ; Thu, 13 Jan 2005 17:59:56 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j0DHxsLK035216 for ; Thu, 13 Jan 2005 17:59:54 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j0DHo4UN034027 for pgsql-admin@postgresql.org; Thu, 13 Jan 2005 17:50:04 GMT (envelope-from news) From: Christopher Browne X-Newsgroups: pgsql.admin Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate! Date: Thu, 13 Jan 2005 12:26:04 -0500 Organization: cbbrowne Computing Inc Lines: 43 Message-ID: References: <4001DEAF7DF9BD498B58B45051FBEA650207AB24@25exch1.vicorpower.vicr.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4 (Corporate Culture, linux) Cancel-Lock: sha1:rXayn5AzdD7TxDZpbbdYvXqJPDk= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200501/121 X-Sequence-Number: 15980 Martha Stewart called it a Good Thing when DGoulet@vicr.com ("Goulet, Dick") wrote: > Well, thanks for the leeway, but getting one's nose rubbed in things for > good and bad comes with the turf. If there's one thing I've learned > about software over the years it's that there are many ways to skin the > same cat, just some are less painful than others. > > Anyway, to the discussion: Commercial software, not just databases > and outside of MicroSludge, always want to be installed in their own > user accounts. PostGreSql does not recommend the same since it > recommends being installed by root. This sets off auditors and > sysadmins, especially those with little open source experience. > Management is not too happy about it as well, nor are security > folks. Excuse me? Where is there any such recommendation? The one place which documents this is the following: ---------------------------------------------------------------------- "To install PostgreSQL enter gmake install This will install files into the directories that were specified in step 1. Make sure that you have appropriate permissions to write into that area. Normally you need to do this step as root. Alternatively, you could create the target directories in advance and arrange for appropriate permissions to be granted." ---------------------------------------------------------------------- That does not _recommend_ having root install the software; it says "Normally you need to do this step as root" which does not look like a recommendation to me. -- (reverse (concatenate 'string "moc.liamg" "@" "enworbbc")) http://cbbrowne.com/info/oses.html Rules of the Evil Overlord #157. "Whenever plans are drawn up that include a time-table, I'll post-date the completion 3 days after it's actually scheduled to occur and not worry too much if they get stolen."