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 92E3E3A5F13 for ; Thu, 13 Jan 2005 04:35:52 +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 40191-06 for ; Thu, 13 Jan 2005 04:35:47 +0000 (GMT) Received: from frankenbride.clueinc.net (xd84b4366.ip.e-nt.net [216.75.67.102]) by svr1.postgresql.org (Postfix) with ESMTP id A20103A5EEB for ; Thu, 13 Jan 2005 04:35:46 +0000 (GMT) Received: by frankenbride.clueinc.net (Postfix, from userid 16220) id A8A87B88A; Wed, 12 Jan 2005 23:35:45 -0500 (EST) Date: Wed, 12 Jan 2005 23:35:45 -0500 From: postgres@jal.org To: "Goulet, Dick" Cc: Stephan Szabo , Peter Eisentraut , "Tomeh, Husam" , PgSQL ADMIN Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate! Message-ID: <20050113043545.GA16815@clueinc.net> Mail-Followup-To: "Goulet, Dick" , Stephan Szabo , Peter Eisentraut , "Tomeh, Husam" , PgSQL ADMIN References: <4001DEAF7DF9BD498B58B45051FBEA650207AAD3@25exch1.vicorpower.vicr.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4001DEAF7DF9BD498B58B45051FBEA650207AAD3@25exch1.vicorpower.vicr.com> User-Agent: Mutt/1.3.28i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.228 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200501/101 X-Sequence-Number: 15960 On Wed, 12 Jan 2005, Goulet, Dick wrote: > Whatever, I'll keep root only for absolutely restricted use & install > under a separate user account. Works just fine & it makes the auditors > & sysadmin feel better. Unfortunately, I _know_ how auditors think, but I would hope that a sensible company would have admins that know better. After a few years in that role... ah, probably better not to say. If you stop and look at the binaries you use as that separate account to do, well, just about anything - specifically who owns them, and why, you might find a few interesting thoughts about how actual unix security works bubbling around. But this is just technical advice, not career advice. -j, glad to be where he is now. -- Jamie Lawrence jal@jal.org I have come to believe that the whole world is an enigma, a harmless enigma that is made terrible by our own mad attempt to interpret it as though it had an underlying truth. - Umberto Eco