Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D8CB09FB4D1 for ; Thu, 12 Jul 2007 14:15:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 42827-04 for ; Thu, 12 Jul 2007 14:15:24 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail02.ellacoya.com (67-135-29-172.dia.static.qwest.net [67.135.29.172]) by postgresql.org (Postfix) with ESMTP id 9115C9FB3C0 for ; Thu, 12 Jul 2007 14:15:27 -0300 (ADT) Received: from YZANGXP ([192.168.124.31]) by mail02.ellacoya.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 12 Jul 2007 13:15:22 -0400 From: "George Wilk" To: Subject: Re: building from source requires postgres user account Date: Thu, 12 Jul 2007 13:15:19 -0400 Message-ID: <002101c7c4a8$392ed9b0$1f7ca8c0@ellacoya.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 Thread-Index: AcfEpgWLSUESJkJcToKvH8bLMkxrAgAAXLBg X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 In-Reply-To: <21849.1184259540@sss.pgh.pa.us> X-OriginalArrivalTime: 12 Jul 2007 17:15:22.0900 (UTC) FILETIME=[3B224540:01C7C4A8] X-TM-AS-Product-Ver: SMEX-8.0.0.1181-5.000.1021-15294.000 X-TM-AS-Result: No--16.464700-4.000000-31 X-TM-AS-User-Approved-Sender: No X-TM-AS-User-Blocked-Sender: No X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/121 X-Sequence-Number: 26102 Tom, I fixed my build problem. Our build scenario is slightly atypical. We are building and installing postgres into a fake root directory and then creating a Solaris package for bundling with our configuration manager component. I am all set. Thanks! Cheers, ~george -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Thursday, July 12, 2007 12:59 PM To: George Wilk Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] building from source requires postgres user account "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