From owner-freebsd-ports@freebsd.org Fri Sep 30 10:18:55 2016 Return-Path: Delivered-To: freebsd-ports@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 235C4C01E46 for ; Fri, 30 Sep 2016 10:18:55 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: from elsa.codelab.cz (elsa.codelab.cz [94.124.105.4]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id DA414958 for ; Fri, 30 Sep 2016 10:18:54 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: from elsa.codelab.cz (localhost [127.0.0.1]) by elsa.codelab.cz (Postfix) with ESMTP id CFC1C28489; Fri, 30 Sep 2016 12:18:51 +0200 (CEST) Received: from illbsd.quip.test (ip-86-49-16-209.net.upcbroadband.cz [86.49.16.209]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by elsa.codelab.cz (Postfix) with ESMTPSA id DA23C2848A; Fri, 30 Sep 2016 12:18:50 +0200 (CEST) Subject: Re: postgresql96-server system changes from postgresql95-server To: =?UTF-8?Q?Lo=c3=afc_Blot?= , freebsd-ports@freebsd.org References: From: Miroslav Lachman <000.fbsd@quip.cz> Message-ID: <57EE3C0A.6030404@quip.cz> Date: Fri, 30 Sep 2016 12:18:50 +0200 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:42.0) Gecko/20100101 Firefox/42.0 SeaMonkey/2.39 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 30 Sep 2016 10:18:55 -0000 Loïc Blot wrote on 09/30/2016 10:28: > Hello, > > i upgraded this morning my postgresql 9.5 instance to 9.6 and i see that the postgresql user changes (pgsql to postgres) and the database path too (/usr/local/pgsql to /var/db/postgres/data96) > > I think pkg-message should warn user about this change, as it advertise user about postgresql 8.3 to 8.4 migration. It was mentioned in UPDATING file which should be reed before each upgrade. But I agree with you, it should be in pkg-message too. UPDATING file is useless for users installing packages and not using /usr/ports at all because UPDATING is not distributed with pkg metadata so "pkg updating" command doesn't work. I posted about it in the past. It is severe shortcoming in pkg concept. I have a workaround for our servers with own poudriere repository - we are serving UPDATING file thru nginx with packages. UPDATING file is periodically checked from cron and downloaded if it was changed so we can run "pkg updating" on all our machines without full ports tree. 20160905: AFFECTS: users of databases/postgresql96-server AUTHOR: girgen@FreeBSD.org The default unix user used by the PostgreSQL daemon has changed to `postgres' to reflect the long time upstream's convention. Any scripts you have using the old `pgsql' unix user should be modified when upgrading to PostgreSQL version 9.6. Older versions of PostgreSQL will continue using `pgsql' until their end-of-life. For users with UTF-8 locales in the database: The ICU patch is *activated by default* for the PostgreSQL-9.6 server. For previous versions it was optional and default off, but this has changed. Please read the entry here below from 20160811 and understand the consequences of changing between ICU and system locale for database collation (short version: don't). pg_upgrade requires the collation method to be the same (or a reindex), while pg_dump/restore does not. Also, the default home directory for the postgres user is now /var/db/postgres, and the default data directory for PostgreSQL 9.6 is /var/db/postgres/data96.