Changing username of postgresql port
david at landgren.net
Mon Mar 14 02:44:03 PST 2005
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.
More information about the freebsd-ports