Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 29 Aug 2019 21:29:23 +0000 (UTC)
From:      Torsten Zuehlsdorff <tz@FreeBSD.org>
To:        ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org
Subject:   svn commit: r510189 - in head: . Mk
Message-ID:  <201908292129.x7TLTNPK061988@repo.freebsd.org>

next in thread | raw e-mail | index | archive | help
Author: tz
Date: Thu Aug 29 21:29:23 2019
New Revision: 510189
URL: https://svnweb.freebsd.org/changeset/ports/510189

Log:
  Switch default version of PostgreSQL from 9.5 to 11
  
  Two important changes arise with it:
  - Default user switches from "pgsql" to "postgres"
  - Default data-dir switches from "/usr/local/pgsql/data" to "/var/db/postgres/data11"
  
  Also add a migration procedure, which takes the user-switch into account by preventing
  it on database-side.
  
  Exp-Run: https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=239514
  
  Thanks to: tobik, antoine, mfechner
  
  Sponsored by:	Professionelles Bounce Management

Modified:
  head/Mk/bsd.default-versions.mk
  head/UPDATING

Modified: head/Mk/bsd.default-versions.mk
==============================================================================
--- head/Mk/bsd.default-versions.mk	Thu Aug 29 21:14:21 2019	(r510188)
+++ head/Mk/bsd.default-versions.mk	Thu Aug 29 21:29:23 2019	(r510189)
@@ -81,7 +81,7 @@ _EXPORTED_VARS+=	_PERL5_FROM_BIN
 PERL5_DEFAULT:=		${_PERL5_FROM_BIN:R}
 .endif
 # Possible values: 9.4, 9.5, 9.6, 10, 11, 12
-PGSQL_DEFAULT?=		9.5
+PGSQL_DEFAULT?=		11
 # Possible values: 7.1, 7.2, 7.3
 PHP_DEFAULT?=		7.2
 # Possible values: 2.7, 3.5, 3.6, 3.7

Modified: head/UPDATING
==============================================================================
--- head/UPDATING	Thu Aug 29 21:14:21 2019	(r510188)
+++ head/UPDATING	Thu Aug 29 21:29:23 2019	(r510189)
@@ -5,6 +5,63 @@ they are unavoidable.
 You should get into the habit of checking this file for changes each time
 you update your ports collection, before attempting any port upgrades.
 
+20190829:
+  AFFECTS: users of database/postgresql* and other software using PostgreSQL to run
+  AUTHOR: tz@FreeBSD.org
+
+  The default version of PostgreSQL has been switched from 9.5 to 11.
+  The upgrade procedure can use up twice the space the databases
+  currently needs. If you have a big amount of stored data take a
+  closer look at the manpage of pg_upgrade for avoidance and/or
+  speedup of the upgrade.
+
+  The upgrade instructions consider a basic usage and do not match
+  complex scenarious like replication, sharding or similar.
+
+  Upgrade instructions:
+
+  First stop your PostgreSQL, create PostgreSQL-binaries and backup your data.
+  If you have another Version of PostgreSQL installed, for example 9.5.19, your
+  files are named accourding to this.
+
+  # service postgresql stop
+  # pkg create postgresql95-server postgresql95-contrib
+  # mkdir /tmp/pg-upgrade
+  # tar xf postgresql95-server-9.5.19.txz -C /tmp/pg-upgrade
+  # tar xf postgresql95-contrib-9.5.19.txz -C /tmp/pg-upgrade
+  # pkg delete -f databases/postgresql95-server databases/postgresql95-contrib databases/postgresql95-client
+
+  Now update PostgreSQL:
+
+    pkg user:
+    # pkg install databases/postgresql11-server databases/postgresql11-contrib
+    # pkg upgrade
+
+    Portmaster users:
+    # portmaster databases/postgresql11-server databases/postgresql11-contrib
+    # portmaster -a
+
+    Portupgrade users:
+    # portinstall databases/postgresql11-server databases/postgresql11-contrib
+    # portupgrade -a
+
+  After installing the new PostgreSQL version you need to convert
+  all your databases to new version:
+
+  # su -l postgres -c "/usr/local/bin/initdb --encoding=utf-8 --lc-collate=C -D /var/db/postgres/data11 -U pgsql"
+  # chown -R postgres /usr/local/pgsql/data/
+  # su -l postgres -c "pg_upgrade -b /tmp/pg-upgrade/usr/local/bin/ -d /usr/local/pgsql/data/ -B /usr/local/bin/ -D /var/db/postgres/data11/ -U pgsql "
+
+  Now the migration is finished. You can start PostgreSQL again with:
+
+  # service postgresql start
+
+  ATTENTION:
+  1) The default user changed from "pgsql" to "postgres". The migration steps above prevent the
+     user "pgsql" as database user while the database itself is executed using the "postgres" user of FreeBSD
+  2) The default data dir changed from "/usr/local/pgsql/data/" to "/var/db/postgres/data11/"
+  3) If you use non-default initdb options, you have to adjust the initdb-command accordingly
+
 20190816:
   AFFECTS: users of net-im/ejabberd
   AUTHOR: ashish@FreeBSD.org



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201908292129.x7TLTNPK061988>