system/postgresql: Updated for version 10.2.

Signed-off-by: David Spencer <idlemoor@slackbuilds.org>

5 files changed, 22 insertions, 23 deletions

diff --git a/system/postgresql/README.SBo b/system/postgresql/README.SBo
index 04080f0be41d3..d4b48e11d77ec 100644
--- a/system/postgresql/README.SBo
+++ b/system/postgresql/README.SBo
@@ -1,11 +1,11 @@
 Before you can run postgresql you'll need to create the
 database files in /var/lib/pgsql. The following should do
 the trick.
-	# su postgres -c "initdb -D /var/lib/pgsql/9.6/data --locale=en_US.UTF-8 -A md5 -W --data-checksums"
+	# su postgres -c "initdb -D /var/lib/pgsql/10.2/data --locale=en_US.UTF-8 -A md5 -W"
 
 Additionally, a logrotation script and init script are included.
 For production level log file handling please read
-http://www.postgresql.org/docs/9.6/interactive/logfile-maintenance.html
+http://www.postgresql.org/docs/10.2/interactive/logfile-maintenance.html
 
 In order to start postgresql at boot and stop it properly at shutdown, 
 make sure rc.postgresql is executable and add the following lines to 
@@ -28,21 +28,20 @@ the following files:
 Additionally, rc.postgresql script has additional modes for stop/restart:
   force-stop|force-restart (i.e. pg_ctl 'fast' mode)
   unclean-stop|unclean-restart (i.e. pg_ctl 'immediate' mode)
-See http://www.postgresql.org/docs/9.6/static/app-pg-ctl.html
+See http://www.postgresql.org/docs/10.2/static/app-pg-ctl.html
 
 From PostgreSQL 9.3 we support in place database upgrades using pg_upgrade:
-  http://www.postgresql.org/docs/9.6/static/pgupgrade.html
+  http://www.postgresql.org/docs/10.2/static/pgupgrade.html
 
-A few hints for PostgreSQL 9.5 -> 9.6 upgrade:
-  - Don't remove old PostgreSQL 9.5.x package
-  - Install PostgreSQL 9.6.x, note that binaries are in
-    '/usr/lib64/postgresql/9.6/bin'
+A few hints for PostgreSQL 9.6 -> 10.2 upgrade:
+  - Don't remove old PostgreSQL 9.6.x package
+  - Install PostgreSQL 10.2.x, note that binaries are in
+    '/usr/lib64/postgresql/10.2/bin'
   - Follow regular pg_upgrade docs
   - Remove old package when transition is over, or read comments in
     rc.postgresql  if you want to run multiple PostgreSQL versions in parallel
-  - Run '/var/log/scripts/postgresql-9.6.x-x86_64-1_SBo' (doinst.sh script)
-    from filesystem root, to create symlinks in /usr/bin to PostgreSQL binaries
-
+  - Check the /usr/bin for stale symlinks for old binaries_
+    e.g. in v10.0 pg_xlogdump got renamed to pg_waldump.
 
 This script builds postgresql with some useful extension modules from
 the contrib directory, see PG_EXTENSIONS in SlackBuild file.
diff --git a/system/postgresql/postgresql.SlackBuild b/system/postgresql/postgresql.SlackBuild
index 5104dcb0794f2..6eb97b2e1a1b7 100644
--- a/system/postgresql/postgresql.SlackBuild
+++ b/system/postgresql/postgresql.SlackBuild
@@ -2,7 +2,7 @@
 
 # Slackware build script for PostgreSQL
 #
-# Copyright 2007-2017 Adis Nezirovic <adis_at_linux.org.ba>
+# Copyright 2007-2018 Adis Nezirovic <adis_at_linux.org.ba>
 # All rights reserved.
 #
 # Redistribution and use of this script, with or without modification, is
@@ -25,11 +25,11 @@
 # Modified by the SlackBuilds.org Project
 
 PRGNAM=postgresql
-VERSION=${VERSION:-9.6.4}
+VERSION=${VERSION:-10.2}
 BUILD=${BUILD:-1}
 TAG=${TAG:-_SBo}
 
-PG_VERSION=${PG_VERSION:-9.6}
+PG_VERSION=${PG_VERSION:-10.2}
 PG_PORT=${PG_PORT:-5432}
 PG_UID=${PG_UID:-209}
 PG_GID=${PG_GID:-209}
@@ -132,7 +132,7 @@ make install-docs DESTDIR=$PKG
 )
 
 # Some interesting additional modules:
-#   http://www.postgresql.org/docs/9.6/static/contrib.html
+#   http://www.postgresql.org/docs/10.2/static/contrib.html
 #
 # adminpack - helper extension for pgAdmin
 # pgcrypto - extension for some business applications
diff --git a/system/postgresql/postgresql.info b/system/postgresql/postgresql.info
index efc28309af25a..a73180c6c62b5 100644
--- a/system/postgresql/postgresql.info
+++ b/system/postgresql/postgresql.info
@@ -1,8 +1,8 @@
 PRGNAM="postgresql"
-VERSION="9.6.4"
+VERSION="10.2"
 HOMEPAGE="https://www.postgresql.org"
-DOWNLOAD="https://ftp.postgresql.org/pub/source/v9.6.4/postgresql-9.6.4.tar.bz2"
-MD5SUM="67b01523a75271fd6cb2638eb2b55795"
+DOWNLOAD="https://ftp.postgresql.org/pub/source/v10.2/postgresql-10.2.tar.bz2"
+MD5SUM="e97c3cc72bdf661441f29069299b260a"
 DOWNLOAD_x86_64=""
 MD5SUM_x86_64=""
 REQUIRES=""
diff --git a/system/postgresql/rc.postgresql.new b/system/postgresql/rc.postgresql.new
index db5c40ca050b8..243ba527bb18b 100644
--- a/system/postgresql/rc.postgresql.new
+++ b/system/postgresql/rc.postgresql.new
@@ -5,7 +5,7 @@
 # $Revision$
 # $Date$
 #
-# Copyright 2007-2016 Adis Nezirovic <adis_at_linux.org.ba>
+# Copyright 2007-2018 Adis Nezirovic <adis_at_linux.org.ba>
 # All rights reserved.
 #
 # Redistribution and use of this script, with or without modification, is
@@ -30,7 +30,7 @@
 # Since version 9.3 this startup script can run multiple PostgreSQL
 # versions on different ports and with different data dirs.
 # 
-# e.g. PG_VERSION=9.6 PG_PORT=6432 /etc/rc.d/rc.@PRGNAM@ start
+# e.g. PG_VERSION=10.2 PG_PORT=6432 /etc/rc.d/rc.@PRGNAM@ start
 
 PG_VERSION=${PG_VERSION:-@PG_VERSION@}
 PG_PORT=${PG_PORT:-@PG_PORT@}
@@ -43,7 +43,7 @@ PIDFILE=$DATADIR/postmaster.pid
 
 # oom-killer score
 #
-# http://www.postgresql.org/docs/9.6/static/kernel-resources.html#LINUX-MEMORY-OVERCOMMIT
+# http://www.postgresql.org/docs/10.2/static/kernel-resources.html#LINUX-MEMORY-OVERCOMMIT
 PG_OOM_ADJUST_FILE=/proc/self/oom_score_adj
 PG_MASTER_OOM_SCORE_ADJ=-1000
 PG_CHILD_OOM_SCORE_ADJ=0
@@ -80,7 +80,7 @@ case "$1" in
 	
 		if [ ! -e $DATADIR/PG_VERSION ]; then
 			echo "You should initialize the PostgreSQL database at location $DATADIR"
-			echo "e.g. su postgres -c \"initdb -D $DATADIR --locale=en_US.UTF-8 -A md5 -W --data-checksums\""
+			echo "e.g. su postgres -c \"initdb -D $DATADIR --locale=en_US.UTF-8 -A md5 -W\""
 			exit 6
 		fi
 	
diff --git a/system/postgresql/setup.postgresql b/system/postgresql/setup.postgresql
index 32fc3e1e718ab..2f0ec5f5496aa 100644
--- a/system/postgresql/setup.postgresql
+++ b/system/postgresql/setup.postgresql
@@ -23,7 +23,7 @@ chmod 700 $PG_HOME/$PG_VERSION/data
 ## database cluster
 if [ ! -f $PG_HOME/$PG_VERSION/data/PG_VERSION ]; then
 	echo "Creating database cluster in $PG_HOME/$PG_VERSION/data..."
-	su $PG_USER -c "initdb -D $PG_HOME/$PG_VERSION/data --locale=en_US.UTF-8 -A md5 -W --data-checksums"
+	su $PG_USER -c "initdb -D $PG_HOME/$PG_VERSION/data --locale=en_US.UTF-8 -A md5 -W"
 else
 	echo "*** WARNING ***" >&2
 	echo "  There is already a database cluster in $PG_HOME/$PG_VERSION/data." >&2