Attachment 183654 Details for Bug 201796 – Patch to update default version of PostgreSQL to 9.5 with UPDATING

[patch] Patch to update default version of PostgreSQL to 9.5 with UPDATING

PostgreSQL-95-update.diff (text/plain), 2.20 KB, created by Torsten Zuehlsdorff on 2017-06-20 14:19:55 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Torsten Zuehlsdorff

Created: 2017-06-20 14:19:55 UTC

Size: 2.20 KB

patch

obsolete

>Index: Mk/bsd.default-versions.mk
>===================================================================
>--- Mk/bsd.default-versions.mk	(Revision 443975)
>+++ Mk/bsd.default-versions.mk	(Arbeitskopie)
>@@ -72,7 +72,7 @@
> 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
>Index: UPDATING
>===================================================================
>--- UPDATING	(Revision 443975)
>+++ UPDATING	(Arbeitskopie)
>@@ -5,6 +5,47 @@
> You should get into the habit of checking this file for changes each time
> you update your ports collection, before attempting any port upgrades.
> 
>+20170620:
>+  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.
>+  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
>+
>+  Now update PostgreSQL:
>+
>+    pkg user:
>+    # 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

Actions: View | Diff

Attachments on bug 201796: 159116 | 180458 | 183354 | 183428 | 183654 | 183673