From gwilk@ellacoya.com Thu Jul 12 14:22:20 2007 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 149169FBFBA for ; Thu, 12 Jul 2007 11:22:20 -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 15408-06 for ; Thu, 12 Jul 2007 11:22:11 -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 3AA499FBF5C for ; Thu, 12 Jul 2007 11:22:13 -0300 (ADT) Received: from YZANGXP ([192.168.124.31]) by mail02.ellacoya.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 12 Jul 2007 10:22:05 -0400 From: "George Wilk" To: Subject: building from source requires postgres user account Date: Thu, 12 Jul 2007 10:22:02 -0400 Message-ID: <000001c7c490$03ff5bb0$1f7ca8c0@ellacoya.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01C7C46E.7CEDBBB0" X-Mailer: Microsoft Office Outlook 11 Thread-Index: AcfEkAOnOZ/Ua+7KQMO9ChfZRHM2tA== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 X-OriginalArrivalTime: 12 Jul 2007 14:22:05.0947 (UTC) FILETIME=[061124B0:01C7C490] X-TM-AS-Product-Ver: SMEX-8.0.0.1181-5.000.1021-15294.000 X-TM-AS-Result: No--14.798800-4.000000-4 X-TM-AS-User-Approved-Sender: No X-TM-AS-User-Blocked-Sender: No X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.381 tagged_above=0 required=5 tests=AWL=-1.220, BAYES_50=0.001, CTYPE_001C_A=1.498, FH_MSGID_01C67=0.001, HTML_MESSAGE=0.001, RDNS_DYNAMIC=0.1 X-Spam-Level: X-Archive-Number: 200707/114 X-Sequence-Number: 26095 This is a multi-part message in MIME format. ------=_NextPart_000_0001_01C7C46E.7CEDBBB0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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. This is an important issue for me, as the postgres build is an integral part of a larger build process involving suite of products. Is there a way to configure the account to be used during build? My build.log shows: LOG ############################# END ################################ LOG LOG LOG ############################# START ################################ LOG LOG Setting permissions LOG LOG ---------------------------------------------------------------------- ERR cannot set file permissions Thanks in advance, ~george ------=_NextPart_000_0001_01C7C46E.7CEDBBB0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I’d like to use my own user account when = building postgres from source.  When I follow directions on Sun’s = page: htt= p://docs.sun.com/app/docs/doc/819-5578/6n7lcpcl5?a=3Dview I don’t have a problem, but running build under my own account = runs into file permission issues after the build is = done.

 

This is an important issue for me, as the postgres = build is an integral part of a larger build process involving suite of = products.  Is there a way to configure the account to be used during build? =

 

My build.log shows:

 

LOG ############################# END ################################

LOG

LOG

LOG ############################# START ################################

LOG

LOG Setting permissions

LOG

LOG = ----------------------------------------------------------------------

ERR cannot set file = permissions

 

Thanks in advance,

 

~george

------=_NextPart_000_0001_01C7C46E.7CEDBBB0-- From tgl@sss.pgh.pa.us Thu Jul 12 16:59:42 2007 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 From peter_e@gmx.net Thu Jul 12 17:11:56 2007 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id AB6EB9FB400 for ; Thu, 12 Jul 2007 14:11:56 -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 15659-01 for ; Thu, 12 Jul 2007 14:11:52 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gauss.credativ.com (gauss.credativ.com [212.112.227.254]) by postgresql.org (Postfix) with ESMTP id 3D4CA9FB3FA for ; Thu, 12 Jul 2007 14:11:56 -0300 (ADT) Received: from hawking.credativ.lan (exit.credativ.com [87.139.82.80]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 055177850E; Thu, 12 Jul 2007 19:10:46 +0200 (CEST) From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Re: building from source requires postgres user account Date: Thu, 12 Jul 2007 19:11:49 +0200 User-Agent: KMail/1.9.5 Cc: "George Wilk" References: <000001c7c490$03ff5bb0$1f7ca8c0@ellacoya.com> In-Reply-To: <000001c7c490$03ff5bb0$1f7ca8c0@ellacoya.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200707121911.49720.peter_e@gmx.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/120 X-Sequence-Number: 26101 Am Donnerstag, 12. Juli 2007 16:22 schrieb George Wilk: > 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. > My build.log shows: Nothing in the build process requires a special user account or writes a file named build.log or writes messages of that kind. So please be more specific. -- Peter Eisentraut http://developer.postgresql.org/~petere/ From gwilk@ellacoya.com Thu Jul 12 17:15:35 2007 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 From jd@commandprompt.com Thu Jul 12 17:17:48 2007 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 66DC39FB63E for ; Thu, 12 Jul 2007 14:17:48 -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 49336-02-7 for ; Thu, 12 Jul 2007 14:17:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 34C4F9FB531 for ; Thu, 12 Jul 2007 14:17:42 -0300 (ADT) Received: from [192.168.1.50] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l6CHH60p025248; Thu, 12 Jul 2007 10:17:06 -0700 Message-ID: <46966273.1010703@commandprompt.com> Date: Thu, 12 Jul 2007 10:18:43 -0700 From: "Joshua D. Drake" User-Agent: Thunderbird 1.5.0.12 (X11/20070604) MIME-Version: 1.0 To: George Wilk CC: pgsql-admin@postgresql.org Subject: Re: building from source requires postgres user account References: <000001c7c490$03ff5bb0$1f7ca8c0@ellacoya.com> In-Reply-To: <000001c7c490$03ff5bb0$1f7ca8c0@ellacoya.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: ClamAV 0.90.3/3641/Wed Jul 11 18:57:08 2007 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Thu, 12 Jul 2007 10:17:06 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/122 X-Sequence-Number: 26103 George Wilk wrote: > I=92d like to use my own user account when building postgres from sourc= e. =20 > When I follow directions on Sun=92s page:=20 > http://docs.sun.com/app/docs/doc/819-5578/6n7lcpcl5?a=3Dview I don=92t = have=20 > a problem, but running build under my own account runs into file=20 > permission issues after the build is done. Well there is very little info here from you on the actual problem=20 but... my guess is that you didn't use --prefix to have postgresql=20 install into a directory structure that you control. Joshua D. Drake >=20 > =20 >=20 > This is an important issue for me, as the postgres build is an integral= =20 > part of a larger build process involving suite of products. Is there a= =20 > way to configure the account to be used during build? >=20 > =20 >=20 > My build.log shows: >=20 > =20 >=20 > LOG ############################# END ################################ >=20 > LOG >=20 > LOG >=20 > LOG ############################# START ###############################= # >=20 > LOG >=20 > LOG Setting permissions >=20 > LOG >=20 > LOG -------------------------------------------------------------------= --- >=20 > ERR cannot set file permissions >=20 > =20 >=20 > Thanks in advance, >=20 > =20 >=20 > ~george >=20 --=20 =3D=3D=3D The PostgreSQL Company: Command Prompt, Inc. =3D=3D=3D Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/