Date: Mon, 14 Mar 2005 11:43:59 +0100 From: David Landgren <david@landgren.net> To: Clive Lin <clive@tongi.org> Cc: freebsd-ports@FreeBSD.org Subject: Re: Changing username of postgresql port Message-ID: <42356AEF.7020408@landgren.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
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?42356AEF.7020408>