From owner-freebsd-ports@FreeBSD.ORG  Mon Mar 14 10:44:03 2005
Return-Path: <owner-freebsd-ports@FreeBSD.ORG>
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 8724D16A4CE; Mon, 14 Mar 2005 10:44:03 +0000 (GMT)
Received: from sferics.mongueurs.net (sferics.mongueurs.net [81.80.147.197])
	by mx1.FreeBSD.org (Postfix) with ESMTP
	id A5B2043D2F; Mon, 14 Mar 2005 10:44:02 +0000 (GMT)
	(envelope-from david@landgren.net)
Received: from [127.0.0.1] (exo.bpinet.com [81.80.147.206])
	by sferics.mongueurs.net (Postfix) with ESMTP id 3C1D1A92A;
	Mon, 14 Mar 2005 11:44:01 +0100 (CET)
Message-ID: <42356AEF.7020408@landgren.net>
Date: Mon, 14 Mar 2005 11:43:59 +0100
From: David Landgren <david@landgren.net>
Organization: The Lusty Decadent Delights of Imperial Pompeii
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Clive Lin <clive@tongi.org>
References: <20050314094909.GA1080@tongi.org>
In-Reply-To: <20050314094909.GA1080@tongi.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
cc: Palle Girgensohn <girgen@FreeBSD.org>
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 <freebsd-ports.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports>
List-Post: <mailto:freebsd-ports@freebsd.org>
List-Help: <mailto:freebsd-ports-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 14 Mar 2005 10:44:03 -0000

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.

Making it configurable (and being able to pick up the site default from 
a system config file) would be a definite improvement.

> application developers who do their code on their favorite, fully
> isolated, environment. This means they have full set of IIS, apache,
> or whatever, installed on their computers, and of course the database
> server. Each time we want to exchange SQL dump files, we have to
> change the super username 'pgsql' in the dump file. This does not
> costs much time, but is indeed pretty annoying ;)

A scratch worth itching, indeed.

David