Changing username of postgresql port

[Palle Girgensohn]

--On torsdag, mars 17, 2005 10.12.50 -0500 Vivek Khera <vivek at khera.org> 
wrote:

>
> On Mar 14, 2005, at 6:56 AM, Palle Girgensohn wrote:
>
>> 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. :-)
>
>
> I don't think it is so much important that the *system* user be
> configurable as it is that the postgres super-user be configurable.
> That's all the postgres server cares about, and that's what shows up in
> the dumps.  It doesn't matter that the superuser name is not the same as
> that of the system account.

Actually, it might even be A Good Thing (tm) to keep them separated, so ppl 
won't mix them up. I installed postgresql on a windows system yesterday 
(first time hardly ever use the OS). Anyway, the installer stressed that 
there shoudl be a system user and postgres super user, and that shoudl 
prefereably *not* be the same. That said, on unix it is a bit practical to 
keep them the same, I guess.

And I guess you want to be able to configure both user names?

>  Please see my PR from a few days ago.  It is
> *trivial* to support this.
>
> http://www.freebsd.org/cgi/query-pr.cgi?pr=78630

Ah, yes, that's quite trivial. Dunno why I didn't use -l in the first 
place, plain stupid I guess ;^)  I'll commit it promptly!

> With this in place, I just edit ~pgsql/.profile to set PGUSER=postgres
> (and export it), then
>
> su - pgsql -c 'initdb -U postgres'
>
> and my whole PG system is now using "postgres" as the super user.

Yeah, that was the idea. I guess I forgot somewhere along the line... :)

> I suppose we could also set the PGUSER equivalent command line args via
> twiddles in rc.conf.

Nah, better to fix the startup script.

/Palle