Date: Mon, 14 Mar 2005 21:59:28 +1100 From: Edwin Groothuis <edwin@mavetju.org> To: David Landgren <david@landgren.net> Cc: freebsd-ports@FreeBSD.org Subject: Re: Changing username of postgresql port Message-ID: <20050314105928.GG1175@k7.mavetju> In-Reply-To: <42356AEF.7020408@landgren.net> References: <20050314094909.GA1080@tongi.org> <42356AEF.7020408@landgren.net>
next in thread | previous in thread | raw e-mail | index | archive | help
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?= pgsql" to bsd.port.mk, just under WWWGRP definition.
- Add "PGGRP?= pgsql" to bsd.port.mk, just under WWWGRP definition.
If you are really brave:
- Add "PGHOME?= ~${PGOWN}" to bsd.port.mk, just under WWWGRP definition.
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 :-)
Also, please talk with girgen@ about it.
Edwin
--
Edwin Groothuis | Personal website: http://www.mavetju.org
edwin@mavetju.org | Weblog: http://weblog.barnet.com.au/edwin/
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050314105928.GG1175>