diff options
Diffstat (limited to 'system/postgresql')
| -rw-r--r-- | system/postgresql/README.SBo | 21 | ||||
| -rw-r--r-- | system/postgresql/postgresql.SlackBuild | 8 | ||||
| -rw-r--r-- | system/postgresql/postgresql.info | 6 | ||||
| -rw-r--r-- | system/postgresql/rc.postgresql.new | 8 | ||||
| -rw-r--r-- | system/postgresql/setup.postgresql | 2 |
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 |