From owner-freebsd-ports@FreeBSD.ORG Sun Aug 14 20:01:19 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 209DF1065708; Sun, 14 Aug 2011 20:01:18 +0000 (UTC) (envelope-from jhelfman@e-e.com) Received: from mail.experts-exchange.com (mail.experts-exchange.com [72.29.183.251]) by mx1.freebsd.org (Postfix) with ESMTP id CC7AD8FC1B; Sun, 14 Aug 2011 20:01:18 +0000 (UTC) Received: from mail.experts-exchange.com (localhost [127.0.0.1]) by mail.experts-exchange.com (Postfix) with ESMTP id B75896FDF6C; Sun, 14 Aug 2011 12:42:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=e-e.com; h= content-transfer-encoding:content-type:content-type:mime-version :user-agent:from:from:subject:subject:date:date:references :in-reply-to:message-id:received:received:received; s=ee; t= 1313350957; x=1315165357; bh=SC5Ci1e8FcM+cuuiom8QGQMJaRo4lS+yROz h0GtuFZY=; b=HodIx2lXeVcrd02kiera6D+Z9xHcJywfBfd35Z9KdSlui2Gb9Qh VNT7pmLur4BSvPXdc8RQn7V7i4JWH2AwdrAKev9JMpE8fa0/CnGmYdSp+dXbd6K+ GyKt6ckxwn3lpQ3ASuaOll72S8Lx+WozzIRjuxTDgSGNzhatg/1MfbCk= X-Virus-Scanned: amavisd-new at experts-exchange.com Received: from mail.experts-exchange.com ([127.0.0.1]) by mail.experts-exchange.com (mail.experts-exchange.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id maEzEbDKL321; Sun, 14 Aug 2011 12:42:37 -0700 (PDT) Received: from mail.experts-exchange.com (localhost [127.0.0.1]) by mail.experts-exchange.com (Postfix) with ESMTP id 761456FDF6B; Sun, 14 Aug 2011 12:42:37 -0700 (PDT) Received: from 63.201.14.88 (SquirrelMail authenticated user jhelfman) by mail.experts-exchange.com with HTTP; Sun, 14 Aug 2011 12:42:37 -0700 Message-ID: <12cf50a875ef98bf7c7e1c745956eee7.squirrel@mail.experts-exchange.com> In-Reply-To: <20110814162721.GA2609@magic.hamla.org> References: <4E47C7F7.9030001@mail.ru> <20110814162721.GA2609@magic.hamla.org> Date: Sun, 14 Aug 2011 12:42:37 -0700 From: "Jason Helfman" To: freebsd-ports@FreeBSD.org User-Agent: SquirrelMail/1.4.20 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal Cc: girgen@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: Sun, 14 Aug 2011 20:01:19 -0000 > [ 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