From owner-freebsd-ports@FreeBSD.ORG Mon Aug 15 08:04:55 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 E097C106566C; Mon, 15 Aug 2011 08:04:55 +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 8CEFA8FC12; Mon, 15 Aug 2011 08:04:55 +0000 (UTC) Received: by mail-iy0-f172.google.com with SMTP id 7so13376669iye.17 for ; Mon, 15 Aug 2011 01:04:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=R0Me1kQFvI7re0uVNPrcJMeneEcz1lwLOGqYbmbAMwY=; b=GUz+whrj+C1lWs1QL1+LDTPk4/nmrTdISw3wL9A0BACQijFz8JOKAy79K3Y+qkJ7ln pJESg/VO+Lb9I7mFTsNPqEid8xtqOXUJfC9P2a7Enar7tg9atsWXqoBDDgXC6TB2gAEi vopzlN7vKb1cFyVHk0FeBwWzU1Tzr4pAKWETk= MIME-Version: 1.0 Received: by 10.231.4.99 with SMTP id 35mr7143185ibq.85.1313395495380; Mon, 15 Aug 2011 01:04:55 -0700 (PDT) Received: by 10.231.182.77 with HTTP; Mon, 15 Aug 2011 01:04:53 -0700 (PDT) Received: by 10.231.182.77 with HTTP; Mon, 15 Aug 2011 01:04:53 -0700 (PDT) In-Reply-To: <12cf50a875ef98bf7c7e1c745956eee7.squirrel@mail.experts-exchange.com> References: <4E47C7F7.9030001@mail.ru> <20110814162721.GA2609@magic.hamla.org> <12cf50a875ef98bf7c7e1c745956eee7.squirrel@mail.experts-exchange.com> Date: Mon, 15 Aug 2011 09:04:53 +0100 Message-ID: From: Chris Rees To: Jason Helfman Content-Type: text/plain; charset=ISO-8859-1 X-Content-Filtered-By: Mailman/MimeDel 2.1.5 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 08:04:56 -0000 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=${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 the > 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=ports/153668 > > The aforementioned PR was submitted as a fix for this PR ( > http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/113707 ) which addressed > 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 want > 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 > > _______________________________________________ > freebsd-ports@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-ports > To unsubscribe, send any mail to "freebsd-ports-unsubscribe@freebsd.org" >