From owner-freebsd-questions@freebsd.org Tue Oct 22 07:02:36 2019 Return-Path: Delivered-To: freebsd-questions@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id EEF3D151FFB for ; Tue, 22 Oct 2019 07:02:36 +0000 (UTC) (envelope-from FreeBSD@shaneware.biz) Received: from ipmail02.adl2.internode.on.net (ipmail02.adl2.internode.on.net [150.101.137.139]) by mx1.freebsd.org (Postfix) with ESMTP id 46y4Fk0sz9z4PZm for ; Tue, 22 Oct 2019 07:02:33 +0000 (UTC) (envelope-from FreeBSD@shaneware.biz) Received: from unknown (HELO leader.local) ([118.211.93.194]) by ipmail02.adl2.internode.on.net with ESMTP; 22 Oct 2019 17:32:26 +1030 Subject: Re: changing the PostgreSQL default user To: David Newman , freebsd-questions@freebsd.org References: <9fdcf15e-2f83-1cfd-1e04-cc08943485fa@networktest.com> From: Shane Ambler Message-ID: Date: Tue, 22 Oct 2019 17:32:24 +1030 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:68.0) Gecko/20100101 Thunderbird/68.1.0 MIME-Version: 1.0 In-Reply-To: <9fdcf15e-2f83-1cfd-1e04-cc08943485fa@networktest.com> Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 7bit X-Rspamd-Queue-Id: 46y4Fk0sz9z4PZm X-Spamd-Bar: ++++ Authentication-Results: mx1.freebsd.org; dkim=none; dmarc=none; spf=none (mx1.freebsd.org: domain of FreeBSD@shaneware.biz has no SPF policy when checking 150.101.137.139) smtp.mailfrom=FreeBSD@shaneware.biz X-Spamd-Result: default: False [4.73 / 15.00]; ARC_NA(0.00)[]; RCVD_COUNT_TWO(0.00)[2]; FROM_HAS_DN(0.00)[]; TO_DN_SOME(0.00)[]; MIME_GOOD(-0.10)[text/plain]; DMARC_NA(0.00)[ShaneWare.Biz]; AUTH_NA(1.00)[]; NEURAL_SPAM_MEDIUM(0.95)[0.948,0]; TO_MATCH_ENVRCPT_SOME(0.00)[]; RCPT_COUNT_TWO(0.00)[2]; NEURAL_SPAM_LONG(0.98)[0.977,0]; R_SPF_NA(0.00)[]; RCVD_NO_TLS_LAST(0.10)[]; RCVD_IN_DNSWL_LOW(-0.10)[139.137.101.150.list.dnswl.org : 127.0.5.1]; R_DKIM_NA(0.00)[]; MIME_TRACE(0.00)[0:+]; ASN(0.00)[asn:4739, ipnet:150.101.0.0/16, country:AU]; MID_RHS_MATCH_FROM(0.00)[]; IP_SCORE(1.90)[ip: (5.72), ipnet: 150.101.0.0/16(2.50), asn: 4739(1.29), country: AU(0.01)]; FROM_EQ_ENVFROM(0.00)[] X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 22 Oct 2019 07:02:37 -0000 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