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 AE9783A62EE for ; Thu, 13 Jan 2005 21:03:09 +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 14636-06 for ; Thu, 13 Jan 2005 21:02:51 +0000 (GMT) Received: from mail.gmx.net (pop.gmx.net [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 808593A60B0 for ; Thu, 13 Jan 2005 20:53:39 +0000 (GMT) Received: (qmail invoked by alias); 13 Jan 2005 20:53:39 -0000 Received: from dsl-082-082-232-233.arcor-ip.net (EHLO colt.pezone.net) (82.82.232.233) by mail.gmx.net (mp015) with SMTP; 13 Jan 2005 21:53:39 +0100 X-Authenticated: #495269 From: Peter Eisentraut To: "Goulet, Dick" Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate! Date: Thu, 13 Jan 2005 21:53:37 +0100 User-Agent: KMail/1.7.1 Cc: "Doug Quale" , "PostgreSQL Admin" References: <4001DEAF7DF9BD498B58B45051FBEA650207AB73@25exch1.vicorpower.vicr.com> In-Reply-To: <4001DEAF7DF9BD498B58B45051FBEA650207AB73@25exch1.vicorpower.vicr.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200501132153.38075.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200501/127 X-Sequence-Number: 15986 Goulet, Dick wrote: > And in my book the executables are > of zero value whereas the data files, and their contained data, are > of infinite value. So under your scheme we're protecting the least > valuable part of the system at the expense of the most valuable. No, there is no expense in that sense. We are protecting as much as possible while leaving as little as possible vulnerable. The fact that the data files are owned by postgres is merely a necessary evil because the database would otherwise be unusable. But there is no reason to have more than that owned by postgres, even if it is of little value. -- Peter Eisentraut http://developer.postgresql.org/~petere/