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 C1CB83A5BE2 for ; Thu, 13 Jan 2005 11:38:44 +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 28450-06 for ; Thu, 13 Jan 2005 11:38:39 +0000 (GMT) Received: from mail.kzsdabas.sulinet.hu (szerver2.kzsdabas.sulinet.hu [195.199.159.210]) by svr1.postgresql.org (Postfix) with SMTP id 423093A5A79 for ; Thu, 13 Jan 2005 11:38:38 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by mail.kzsdabas.sulinet.hu (Postfix) with ESMTP id BCF4C64740C0; Thu, 13 Jan 2005 12:38:36 +0100 (CET) Received: from mail.kzsdabas.sulinet.hu ([127.0.0.1]) by localhost (mail.kzsdabas.sulinet.hu [127.0.0.1]) (amavisd-new, port 10025) with LMTP id 22795-03-2; Thu, 13 Jan 2005 12:38:35 +0100 (CET) Received: from [10.0.13.1] (kag.kzsdabas.hu [10.0.13.1]) by mail.kzsdabas.sulinet.hu (Postfix) with ESMTP id C4AA364784E1; Thu, 13 Jan 2005 12:38:35 +0100 (CET) Message-ID: <41E65DD4.6020201@kzsdabas.sulinet.hu> Date: Thu, 13 Jan 2005 12:39:00 +0100 From: =?ISO-8859-1?Q?G=E9mes_G=E9za?= User-Agent: Mozilla/5.0 (X11; U; Linux i686; hu; rv:1.7.2) Gecko/20040804 X-Accept-Language: hu, en-us MIME-Version: 1.0 To: "Goulet, Dick" Cc: Peter Eisentraut , "Tomeh, Husam" , PgSQL ADMIN Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate! References: <4001DEAF7DF9BD498B58B45051FBEA650207AAD2@25exch1.vicorpower.vicr.com> In-Reply-To: <4001DEAF7DF9BD498B58B45051FBEA650207AAD2@25exch1.vicorpower.vicr.com> X-Enigmail-Version: 0.85.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed X-Virus-Scanned: by amavisd-new at kzsdabas.sulinet.hu Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.28 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200501/105 X-Sequence-Number: 15964 Goulet, Dick =EDrta: >Peter, > > You may well be on the development team, but you are wrong for >one very important reason. If the Postgresql executables are owned by >root they execute with the priviledges of root. Thereby any local >created extensions like database_size also execute with the priviledges >of root. Wouldn't it be wonderful if some disgruntled person or a >hacker wrote & installed a package that did an rm -fr /?? Install >Postgres in it's own account where it's priviledges to destroy the >server are restricted. Anything else is begging for trouble. > > >Dick Goulet >Senior Oracle DBA >Oracle Certified 8i DBA >-----Original Message----- >From: Peter Eisentraut [mailto:peter_e@gmx.net]=20 >Sent: Wednesday, January 12, 2005 7:01 PM >To: Tomeh, Husam >Cc: PgSQL ADMIN >Subject: Re: [ADMIN] Installing PostgreSQL as "postgress" versus "root" >Debate! > >Tomeh, Husam wrote: > =20 > >>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? >> =20 >> > >The current recommendation, which is reflected in the installation=20 >instructions, is to install the software as root and to use the=20 >postgres user for the database files. The advice seen elsewhere in=20 >this thread to use the postgres user also for the software files is=20 >wrong. > > =20 > Sorry, but under the UNIX security modell each process (except special=20 seteuid and setruid calls) get loaded, with the priviledges of the=20 process which loaded it. Just try executing postmaster as an ordinary=20 user, you will see, that it won't be able to access its data files. Cheers Geza