From owner-freebsd-ports@FreeBSD.ORG Mon Mar 14 09:49:16 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 09DFB16A4CE; Mon, 14 Mar 2005 09:49:16 +0000 (GMT) Received: from drop.bsdchat.com (drop.bsdchat.com [209.237.225.38]) by mx1.FreeBSD.org (Postfix) with ESMTP id 090F843D53; Mon, 14 Mar 2005 09:49:15 +0000 (GMT) (envelope-from clive@tongi.org) Received: from CARTIER (drag.bsdchat.com [209.237.225.37]) by drop.bsdchat.com (8.13.1/8.13.1) with SMTP id j2E9nBFO026646; Mon, 14 Mar 2005 09:49:13 GMT (envelope-from clive@tongi.org) Received: (nullmailer pid 1188 invoked by uid 1000); Mon, 14 Mar 2005 09:49:10 -0000 Date: Mon, 14 Mar 2005 17:49:09 +0800 From: Clive Lin To: Palle Girgensohn Message-ID: <20050314094909.GA1080@tongi.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline X-PGP-key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xA008C03E User-Agent: Mutt/1.5.8i cc: freebsd-ports@FreeBSD.org Subject: 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 09:49:16 -0000 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 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 ;) This is just a thought. If you feel like it, I could start doing patches for it. Cheers, -- Clive Tong-I Lin | http://tongi.org | PGP KeyID: A008C03E