From owner-freebsd-ports@FreeBSD.ORG Mon Mar 14 11:56:14 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 B231416A4CE for ; Mon, 14 Mar 2005 11:56:14 +0000 (GMT) Received: from melon.pingpong.net (82.milagro.bahnhof.net [195.178.168.82]) by mx1.FreeBSD.org (Postfix) with ESMTP id 199C743D55 for ; Mon, 14 Mar 2005 11:56:14 +0000 (GMT) (envelope-from girgen@FreeBSD.org) Received: from localhost (localhost.pingpong.net [127.0.0.1]) by melon.pingpong.net (Postfix) with ESMTP id D1AE64AF61; Mon, 14 Mar 2005 12:56:12 +0100 (CET) Received: from melon.pingpong.net ([127.0.0.1]) by localhost (melon.pingpong.net [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 68620-03-15; Mon, 14 Mar 2005 12:56:12 +0100 (CET) Received: from [192.168.1.187] (81.milagro.bahnhof.net [195.178.168.81]) by melon.pingpong.net (Postfix) with ESMTP id AC8574AF58; Mon, 14 Mar 2005 12:56:11 +0100 (CET) Date: Mon, 14 Mar 2005 12:56:11 +0100 From: Palle Girgensohn To: Clive Lin Message-ID: <22FD04521EA81D6E4C8D2402@rambutan.pingpong.net> In-Reply-To: <20050314094909.GA1080@tongi.org> References: <20050314094909.GA1080@tongi.org> X-Mailer: Mulberry/3.1.6 (Linux/x86) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at pingpong.net 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 11:56:14 -0000 --On m=E5ndag, mars 14, 2005 17.49.09 +0800 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 > 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. Hi! You're not the first to ask about this, and I'd like to make the username=20 dynamic. I do think it shall default to pgsql though, at least if the=20 userid already exists, so running configs will not break. If you want to send me patches, please do, I'll be much obliged. :-) Cheers, Palle