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 292333A586F for ; Thu, 13 Jan 2005 18:00:01 +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 78232-01 for ; Thu, 13 Jan 2005 17:59:55 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 1E1713A517C 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 j0DHxsLI035216 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 j0DHo6ka034040 for pgsql-admin@postgresql.org; Thu, 13 Jan 2005 17:50:06 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:40:03 -0500 Organization: cbbrowne Computing Inc Lines: 28 Message-ID: References: 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:lsu5dE+iO9V0QkijMxElnqhYg78= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200501/120 X-Sequence-Number: 15979 In an attempt to throw the authorities off his trail, htomeh@firstam.com ("Tomeh, Husam") transmitted: > 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? "Best practices" tend to vary. If you are installing software using "package management" tools, then it is mandatory that you install it as some form of "administrative" user (e.g. - root) because typical package management tools require root access. (That's true whether we're talking about the RPM package manager that Caldera paid RHAT to develop, dpkg used by Debian, BSD Ports, or pkgadd used by sundry systems.) I happen to do much of my work in "managed hosting" environments where I may not even have root access. In those environments, the "best practice" is the "mandatory practice" and is to get a postgres user set up and to have that user install the software. -- wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','acm.org'). http://www.ntlug.org/~cbbrowne/emacs.html Rules of the Evil Overlord #94. "When arresting prisoners, my guards will not allow them to stop and grab a useless trinket of purely sentimental value."