Date: Mon, 15 Aug 2011 15:56:22 +0100 From: Chris Rees <utisoft@gmail.com> To: Jason Helfman <jhelfman@e-e.com> Cc: girgen@freebsd.org, freebsd-ports@freebsd.org, sahil@freebsd.org Subject: Re: PostgreSQL 9.0.4 %%PG_USER%% not changed Message-ID: <CADLo83_wtFUzxn_aC05tWzd8Fu9pedD6pHptHAixdSNJ-snyaw@mail.gmail.com> In-Reply-To: <CADLo839v==biyxnS8KDQiS8tY_TrCZG9tuy6geKkBHSxsTZqWA@mail.gmail.com> References: <4E47C7F7.9030001@mail.ru> <20110814162721.GA2609@magic.hamla.org> <12cf50a875ef98bf7c7e1c745956eee7.squirrel@mail.experts-exchange.com> <CADLo839v==biyxnS8KDQiS8tY_TrCZG9tuy6geKkBHSxsTZqWA@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On 15 August 2011 09:04, Chris Rees <utisoft@gmail.com> wrote:
> This might be my fault, I'll invest8gate. Sorry.
>
> On 14 Aug 2011 21:02, "Jason Helfman" <jhelfman@e-e.com> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CADLo83_wtFUzxn_aC05tWzd8Fu9pedD6pHptHAixdSNJ-snyaw>