From owner-freebsd-ports@FreeBSD.ORG Mon Mar 14 10:59:33 2005 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 359B916A4CE; Mon, 14 Mar 2005 10:59:33 +0000 (GMT) Received: from mail2out.barnet.com.au (mail2out.barnet.com.au [202.83.176.14]) by mx1.FreeBSD.org (Postfix) with ESMTP id 58E1D43D2D; Mon, 14 Mar 2005 10:59:32 +0000 (GMT) (envelope-from edwin@mavetju.org) Received: by mail2out.barnet.com.au (Postfix, from userid 27) id C8EBD70743E; Mon, 14 Mar 2005 21:59:30 +1100 (EST) X-Viruscan-Id: <42356E9200000B5C4276EA@BarNet> Received: from mail2-auth.barnet.com.au (mail2.barnet.com.au [202.83.176.13]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) Authority" (verified OK)) by mail2.barnet.com.au (Postfix) with ESMTP id 8B7E370743C; Mon, 14 Mar 2005 21:59:30 +1100 (EST) Received: from k7.mavetju (edwin-3.int.barnet.com.au [10.10.12.2]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) Certificate Authority" (verified OK)) by mail2-auth.barnet.com.au (Postfix) with ESMTP id 01DA370742F; Mon, 14 Mar 2005 21:59:29 +1100 (EST) Received: by k7.mavetju (Postfix, from userid 1001) id B0083617C; Mon, 14 Mar 2005 21:59:28 +1100 (EST) Date: Mon, 14 Mar 2005 21:59:28 +1100 From: Edwin Groothuis To: David Landgren Message-ID: <20050314105928.GG1175@k7.mavetju> References: <20050314094909.GA1080@tongi.org> <42356AEF.7020408@landgren.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <42356AEF.7020408@landgren.net> User-Agent: Mutt/1.5.6i cc: Palle Girgensohn cc: freebsd-ports@FreeBSD.org Subject: Re: Changing username of postgresql port X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 14 Mar 2005 10:59:33 -0000 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/