Date: Mon, 14 Mar 2005 13:04:33 +0100 From: Palle Girgensohn <girgen@FreeBSD.org> To: Edwin Groothuis <edwin@mavetju.org>, David Landgren <david@landgren.net> Cc: freebsd-ports@FreeBSD.org Subject: Re: Changing username of postgresql port Message-ID: <E4891B40F0AB295971B19480@rambutan.pingpong.net> In-Reply-To: <20050314105928.GG1175@k7.mavetju> References: <20050314094909.GA1080@tongi.org> <42356AEF.7020408@landgren.net> <20050314105928.GG1175@k7.mavetju>
next in thread | previous in thread | raw e-mail | index | archive | help
--On m=E5ndag, mars 14, 2005 21.59.28 +1100 Edwin Groothuis=20
<edwin@mavetju.org> wrote:
> On Mon, Mar 14, 2005 at 11:43:59AM +0100, David Landgren wrote:
>> Clive Lin wrote:
>> > Hello Palle,
>> >
>> > I have a proposal of changing PostgreSQL username, from 'pgsql' to
>> > 'postgres', or at least make it not hard-coded. The reason is trivial:
>> > consistency across other platforms. My case is, we have web
>>
>> Don't hard code it to something else. Make it configurable (with pgsql
>> as a default for backwards compatibility). For instance, I use 'pg' as
>> the Pg user name, so hard-coding it to 'postgres' doesn't buy me
>> anything.
>
> Suggested line of action:
>
> - Add "PGOWN?=3D pgsql" to bsd.port.mk, just under WWWGRP definition.
> - Add "PGGRP?=3D pgsql" to bsd.port.mk, just under WWWGRP definition.
>
> If you are really brave:
> - Add "PGHOME?=3D ~${PGOWN}" to bsd.port.mk, just under WWWGRP =
definition.
A must, IMO.
> Then:
> - Do "grep -r pgsql postgresq*" in ports/databases and see what has
> to be changed.
>
> And then:
> - make build, make install, make package, make deinstall, rm -rf
> /usr/local/pgsql, pkg_add pgsqlpackage and check.
>
>
> This is not for people with a heart disease :-)
Oh, it's not *that* bad. Just sometimes you need to do Woodoo-like stuff to =
get ~${USER} to evalutate. Other than, you need some time to mangle through =
all the files and test, test, test... :)
> Also, please talk with girgen@ about it.
I'm in the loop. :-) Right now, it's not on the top of my agenda though,=20
but as I said, if you send me patches I'll be much obliged :)
/Palle
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?E4891B40F0AB295971B19480>