Date: Thu, 22 Jun 2017 14:16:03 +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: r444116 - in head: . Mk Message-ID: <201706221416.v5MEG3OS059134@repo.freebsd.org>
next in thread | raw e-mail | index | archive | help
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@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@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@kde.org
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201706221416.v5MEG3OS059134>