Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 21F119FB46F for ; Thu, 12 Jul 2007 13:59:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 06895-01 for ; Thu, 12 Jul 2007 13:59:35 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id B75309FA5A0 for ; Thu, 12 Jul 2007 13:59:38 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l6CGx0XN021850; Thu, 12 Jul 2007 12:59:00 -0400 (EDT) To: "George Wilk" cc: pgsql-admin@postgresql.org Subject: Re: building from source requires postgres user account In-reply-to: <000001c7c490$03ff5bb0$1f7ca8c0@ellacoya.com> References: <000001c7c490$03ff5bb0$1f7ca8c0@ellacoya.com> Comments: In-reply-to "George Wilk" message dated "Thu, 12 Jul 2007 10:22:02 -0400" Date: Thu, 12 Jul 2007 12:59:00 -0400 Message-ID: <21849.1184259540@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/119 X-Sequence-Number: 26100 "George Wilk" writes: > I'd like to use my own user account when building postgres from source. > When I follow directions on Sun's page: > http://docs.sun.com/app/docs/doc/819-5578/6n7lcpcl5?a=view I don't have a > problem, but running build under my own account runs into file permission > issues after the build is done. Well, the default place to put the executables (/usr/local) is normally not world-writable, so you should expect to have to do "make install" as root. If you want an entirely unprivileged installation, specify an unprivileged install location to configure --prefix. However, such setups are normally not useful for much beyond testing purposes; if you intend the database to be autostarted at system boot then the executables really ought to be root-owned for security. You certainly don't need to do configure and make as any particular user. The user you do "make install" as will determine the ownership of the installed executables and other static files. The user you do "initdb" as will own the PGDATA directory and will need to be the userid that the postmaster is started under. These three can be different, and none of them need to be named "postgres". regards, tom lane