Changing username of postgresql port
girgen at FreeBSD.org
Fri Mar 18 19:11:24 PST 2005
--On torsdag, mars 17, 2005 10.12.50 -0500 Vivek Khera <vivek at khera.org>
> 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.
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.
More information about the freebsd-ports