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 16E873A58AC for ; Thu, 13 Jan 2005 17:08:28 +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 69046-10 for ; Thu, 13 Jan 2005 17:08:17 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 73BDB3A5363 for ; Thu, 13 Jan 2005 17:08:17 +0000 (GMT) Received: (qmail 15019 invoked by uid 500); 13 Jan 2005 17:22:07 -0000 Date: Thu, 13 Jan 2005 11:22:07 -0600 From: Bruno Wolff III To: "Tomeh, Husam" Cc: "Joshua D. Drake" , "Goulet, Dick" , Stephan Szabo , Peter Eisentraut , PgSQL ADMIN Subject: Re: Installing PostgreSQL as "postgress" versus "root" Message-ID: <20050113172207.GC13594@wolff.to> Mail-Followup-To: "Tomeh, Husam" , "Joshua D. Drake" , "Goulet, Dick" , Stephan Szabo , Peter Eisentraut , PgSQL ADMIN References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/118 X-Sequence-Number: 15977 On Thu, Jan 13, 2005 at 08:06:05 -0800, "Tomeh, Husam" wrote: > So does that mean there's no security issue using the root account to > install postrgeSQL as the first book indicated? Thanks. This depends on who you trust. The install scripts could potentially do bad things. Generally you will need to do at least some part of the install process as root. It is also a good idea to install the binaries using a different user (and root is fine if there aren't any setuid/setgid binaries) than the database will run under so that database users can't corrupt the binaries via untrusted languages or bugs.