Date: Mon, 14 Mar 2005 12:56:11 +0100 From: Palle Girgensohn <girgen@FreeBSD.org> To: Clive Lin <clive@tongi.org> Cc: freebsd-ports@FreeBSD.org Subject: Re: Changing username of postgresql port Message-ID: <22FD04521EA81D6E4C8D2402@rambutan.pingpong.net> In-Reply-To: <20050314094909.GA1080@tongi.org> References: <20050314094909.GA1080@tongi.org>
next in thread | previous in thread | raw e-mail | index | archive | help
--On m=E5ndag, mars 14, 2005 17.49.09 +0800 Clive Lin <clive@tongi.org> = 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?22FD04521EA81D6E4C8D2402>