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 084B93A5E41 for ; Thu, 13 Jan 2005 00:00:40 +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 00225-01 for ; Thu, 13 Jan 2005 00:00:32 +0000 (GMT) Received: from mail.gmx.net (pop.gmx.net [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 70F153A5EA0 for ; Thu, 13 Jan 2005 00:00:33 +0000 (GMT) Received: (qmail invoked by alias); 13 Jan 2005 00:00:33 -0000 Received: from dsl-213-023-249-025.arcor-ip.net (EHLO colt.pezone.net) (213.23.249.25) by mail.gmx.net (mp006) with SMTP; 13 Jan 2005 01:00:33 +0100 X-Authenticated: #495269 From: Peter Eisentraut To: "Tomeh, Husam" Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate! Date: Thu, 13 Jan 2005 01:00:31 +0100 User-Agent: KMail/1.7.1 Cc: "PgSQL ADMIN" References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200501130100.32307.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/89 X-Sequence-Number: 15948 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. -- Peter Eisentraut http://developer.postgresql.org/~petere/