Date: Tue, 22 Oct 2019 17:32:24 +1030 From: Shane Ambler <FreeBSD@ShaneWare.Biz> To: David Newman <dnewman@networktest.com>, freebsd-questions@freebsd.org Subject: Re: changing the PostgreSQL default user Message-ID: <c19769d3-d1f8-0158-9cfe-49a2100a66b1@ShaneWare.Biz> In-Reply-To: <9fdcf15e-2f83-1cfd-1e04-cc08943485fa@networktest.com> References: <9fdcf15e-2f83-1cfd-1e04-cc08943485fa@networktest.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On 21/10/19 4:52 pm, David Newman wrote:
> Greetings.
>
> FreeBSD recently changed its default version of PostgreSQL from 9.5 to 11.
>
> However, attempts to run 'pg_upgrade' on the databases failed for me
> because my 9.5 install had a default user of 'pgsql' and version 11 goes
> with 'postgres' instead [1].
>
> My hack was to edit /usr/local/etc/rc.d/postgresql, set postgresql_user
No need - configure it in /etc/rc.conf
Config variables used by any rc script can be set in rc.conf, not just
the *_enable variables.
For postgresql*-server that is
postgresql_enable
postgresql_data
postgresql_flags
postgresql_initdb_flags
postgresql_class
postgresql_profiles
In the postgresql rc file, you will find -
postgresql_user=${postgresql_user:-"postgres"}
the part inside ${} means if this variable has not been set use this
default value.
--
FreeBSD - the place to B...Sharing Data
Shane Ambler
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?c19769d3-d1f8-0158-9cfe-49a2100a66b1>