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 6852B3A5E5F for ; Thu, 13 Jan 2005 00:27:55 +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 01389-10 for ; Thu, 13 Jan 2005 00:27:48 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.196]) by svr1.postgresql.org (Postfix) with ESMTP id 5BC943A5E2E for ; Thu, 13 Jan 2005 00:27:50 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id g11so134212rne for ; Wed, 12 Jan 2005 16:27:51 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=jzHDX4k35YiTGM2qANsYkHEh+O7v7QP4JhoIEkTRNrC5MTmTD2CR5wJhf2rhh9hIiDLnSXjg2Y10jCH4o5ArH9bRNLczFLeWatTFTmzNZDf89/O4VxTsqwGXCa1PP+kcxJPHLt5/KC5dfN2wDrPO01bHTkvTfvFIq7TmVZtead0= Received: by 10.38.98.7 with SMTP id v7mr63373rnb; Wed, 12 Jan 2005 16:27:51 -0800 (PST) Received: by 10.38.162.36 with HTTP; Wed, 12 Jan 2005 16:27:51 -0800 (PST) Message-ID: <59d991c405011216274c899584@mail.gmail.com> Date: Wed, 12 Jan 2005 19:27:51 -0500 From: Christopher Petrilli Reply-To: Christopher Petrilli To: Peter Eisentraut Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate! Cc: "Tomeh, Husam" , PgSQL ADMIN In-Reply-To: <200501130100.32307.peter_e@gmx.net> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <200501130100.32307.peter_e@gmx.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200501/90 X-Sequence-Number: 15949 On Thu, 13 Jan 2005 01:00:31 +0100, 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. As a security professional, why would the root user need to be involved in the ownership of PostgreSQL? I see no reason for this, but perhaps I'm missing something important. Chris -- | Christopher Petrilli | petrilli@gmail.com