Changing username of postgresql port

[Palle Girgensohn]

--On måndag, mars 14, 2005 17.49.09 +0800 Clive Lin <clive at 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 
dynamic. I do think it shall default to pgsql though, at least if the 
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