svn commit: r444116 - in head: . Mk

[Torsten Zuehlsdorff]

Author: tz
Date: Thu Jun 22 14:16:02 2017
New Revision: 444116
URL: https://svnweb.freebsd.org/changeset/ports/444116

Log:
  Change PostgreSQL default version from 9.3 to 9.5
  
  PR:          201796, 217515
  Reviewed by: mat, girgen, xmj, Jov <amutu at amutu.com> and more

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

Modified: head/Mk/bsd.default-versions.mk
==============================================================================
--- head/Mk/bsd.default-versions.mk	Thu Jun 22 13:24:29 2017	(r444115)
+++ head/Mk/bsd.default-versions.mk	Thu Jun 22 14:16:02 2017	(r444116)
@@ -72,7 +72,7 @@ _EXPORTED_VARS+=	_PERL5_FROM_BIN
 PERL5_DEFAULT:=		${_PERL5_FROM_BIN:R}
 .endif
 # Possible values: 9.2, 9.3, 9.4, 9.5, 9.6
-PGSQL_DEFAULT?=		9.3
+PGSQL_DEFAULT?=		9.5
 # Possible values: 5.6, 7.0, 7.1
 PHP_DEFAULT?=		5.6
 # Possible values: 2.7, 3.3, 3.4, 3.5, 3.6

Modified: head/UPDATING
==============================================================================
--- head/UPDATING	Thu Jun 22 13:24:29 2017	(r444115)
+++ head/UPDATING	Thu Jun 22 14:16:02 2017	(r444116)
@@ -5,6 +5,57 @@ 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.
 
+20170622:
+  AFFECTS: users of database/postgresql* and other software using PostgreSQL to run
+  AUTHOR: tz at FreeBSD.org
+
+  The default version of PostgreSQL has been switched from 9.3 to 9.5.
+  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.3.12, your
+  files are named accourding to this.
+  
+  # service postgresql stop
+  # pkg create postgresql93-server postgresql93-contrib
+  # mkdir /tmp/pg-upgrade
+  # tar xf postgresql93-server-9.3.17.txz -C /tmp/pg-upgrade
+  # tar xf postgresql93-contrib-9.3.17.txz -C /tmp/pg-upgrade
+  # mv /usr/local/pgsql/data /usr/local/pgsql/data93
+  # pkg delete -f databases/postgresql93-server databases/postgresql93-contrib databases/postgresql93-client
+
+  Now update PostgreSQL:
+
+    pkg user:
+    # pkg install databases/postgresql95-server databases/postgresql95-contrib
+    # pkg upgrade
+
+    Portmaster users:
+    # portmaster databases/postgresql95-server databases/postgresql95-contrib
+    # portmaster -a
+
+    Portupgrade users:
+    # portinstall databases/postgresql95-server databases/postgresql95-contrib
+    # portupgrade -a
+
+  After installing the new PostgreSQL version you need to convert
+  all your databases to new version:
+  
+  # service postgresql initdb
+  # su -l pgsql -c "pg_upgrade -b /tmp/pg-upgrade/usr/local/bin/ -d /usr/local/pgsql/data93/ -B /usr/local/bin/ -D /usr/local/pgsql/data/"
+
+  Now the migration is finished. You can start PostgreSQL again with:
+
+  # service postgresql start
+
 20170614:
   AFFECTS: users of editors/calligra
   AUTHOR: groot at kde.org