From owner-freebsd-ports@FreeBSD.ORG Mon Aug 15 14:56:53 2011 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 3D8141065673; Mon, 15 Aug 2011 14:56:53 +0000 (UTC) (envelope-from utisoft@gmail.com) Received: from mail-iy0-f172.google.com (mail-iy0-f172.google.com [209.85.210.172]) by mx1.freebsd.org (Postfix) with ESMTP id E12A18FC15; Mon, 15 Aug 2011 14:56:52 +0000 (UTC) Received: by iye7 with SMTP id 7so14137365iye.17 for ; Mon, 15 Aug 2011 07:56:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type:content-transfer-encoding; bh=pfOzNdJoiLiG12XAVE4tjels/F0tMV0VGl6QTPjs5e4=; b=Ixa5zBEFYvcOvt5tXz0LM4N8Hl7AEJQNMKraB6xx1QMt2FToe6strgkc4Uf3HeMWiA btvBL55hXlWw30uoYFa+NnV5WxJrhmTJ/mrhwld8pqTTlaaFzj6ea0Ox1n/bYuqt/X/l 0fLocXohijnLB2/GBchOzFpjBEQNoOvojRfjc= Received: by 10.43.53.73 with SMTP id vp9mr4280482icb.415.1313420212147; Mon, 15 Aug 2011 07:56:52 -0700 (PDT) MIME-Version: 1.0 Received: by 10.231.182.77 with HTTP; Mon, 15 Aug 2011 07:56:22 -0700 (PDT) In-Reply-To: References: <4E47C7F7.9030001@mail.ru> <20110814162721.GA2609@magic.hamla.org> <12cf50a875ef98bf7c7e1c745956eee7.squirrel@mail.experts-exchange.com> From: Chris Rees Date: Mon, 15 Aug 2011 15:56:22 +0100 Message-ID: To: Jason Helfman Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Cc: girgen@freebsd.org, freebsd-ports@freebsd.org, sahil@freebsd.org Subject: Re: PostgreSQL 9.0.4 %%PG_USER%% not changed X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 15 Aug 2011 14:56:53 -0000 On 15 August 2011 09:04, Chris Rees wrote: > This might be my fault, I'll invest8gate. Sorry. > > On 14 Aug 2011 21:02, "Jason Helfman" wrote: >>> [ mantainer added to Cc: ] >>> >>> On Sun, 2011-08-14 at 18:04:55 +0500, rihad wrote: >>> >>>> Hi, I have installed the latest >>>> postgresql-server-9.0.4_2 >>>> postgresql-client-9.0.4_1 >>>> >>>> In several places, namely in /usr/local/etc/rc.d/postgresql: >>>> postgresql_user=3D${postgresql_user:-"%%PG_USER%%"} >>>> >>>> and throughout all of /usr/local/etc/periodic/daily/502.pgsql >>>> >>>> %%PG_USER%% is left as is, which should have presumably been changed >>>> to pgsql by the installation script. >>>> What gives? >>> >>> Based on a quick glance, it seems that the expansion does occur because >>> PG_USER is not set in SUB_LIST. >> >> This commit also changed the ability to configure a different user, as t= he >> pgsql isn't part of the base operating system installation, and having a >> configurable user, group and id, allowed users to change what user was >> running postgresql as. This is now not the case. This patch was used in >> addressing this: http://www.freebsd.org/cgi/query-pr.cgi?pr=3Dports/1536= 68 >> >> The aforementioned PR was submitted as a fix for this PR ( >> http://www.freebsd.org/cgi/query-pr.cgi?pr=3Dports/113707 ) which addres= sed >> the issue in a non-standard way. >> >> I really don't understand why this was done, as this really broke the >> essence of why this port was changed to support "any" user one would wan= t >> to run the postgresql server as, and now this functionality is gone. >> >> It would be great to see this change back in place so one may run the >> server as any user they choose, and not just "pgsql," especially since >> this user isn't in the base system. >> >> -jgh OK, I've reverted the problem commit (s) [1]. I'm going to take a look at how to do this properly -- we really do need to use the code in bsd.port.mk for creating users rather than using pkg-install files. Rihad, please try csupping / portsnap and check that in postgresql90-server has the line: $FreeBSD: ports/databases/postgresql90-server/Makefile,v 1.222 2011/08/15 14:52:31 crees Exp $ Then reinstall and your problem will be gone. Sorry for the disruption. Chris [1] http://lists.freebsd.org/pipermail/cvs-ports/2011-August/223423.html --=20 Chris Rees =A0 =A0 =A0 =A0 =A0| FreeBSD Developer crees@FreeBSD.org =A0 | http://people.freebsd.org/~crees