Date: Thu, 17 Mar 2005 10:12:50 -0500 From: Vivek Khera <vivek@khera.org> To: Palle Girgensohn <girgen@freebsd.org> Cc: FreeeBSD Ports <freebsd-ports@freebsd.org> Subject: Re: Changing username of postgresql port Message-ID: <b4fe545e40a2b9055cad54d30f446611@khera.org> In-Reply-To: <22FD04521EA81D6E4C8D2402@rambutan.pingpong.net> References: <20050314094909.GA1080@tongi.org> <22FD04521EA81D6E4C8D2402@rambutan.pingpong.net>
next in thread | previous in thread | raw e-mail | index | archive | help
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. 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 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. I suppose we could also set the PGUSER equivalent command line args via twiddles in rc.conf. Vivek Khera, Ph.D. +1-301-869-4449 x806
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?b4fe545e40a2b9055cad54d30f446611>