From b8ca51749cfebb9294f1335a570a22420eaa603c Mon Sep 17 00:00:00 2001 From: Adis Nezirovic Date: Thu, 8 Jan 2015 17:03:57 +0700 Subject: system/postgresql: Updated for version 9.4.0. Signed-off-by: Willy Sudiarto Raharjo --- system/postgresql/README.SBo | 22 ++++++++++++++++------ system/postgresql/postgresql.SlackBuild | 11 +++++------ system/postgresql/postgresql.info | 6 +++--- system/postgresql/rc.postgresql.new | 22 ++++++---------------- 4 files changed, 30 insertions(+), 31 deletions(-) (limited to 'system/postgresql') diff --git a/system/postgresql/README.SBo b/system/postgresql/README.SBo index 6ec5736c3c..80148572e0 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.3/data --locale=en_US.UTF-8 -A md5 -W" + # su postgres -c "initdb -D /var/lib/pgsql/9.4/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.3/interactive/logfile-maintenance.html +http://www.postgresql.org/docs/9.4/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,12 +28,12 @@ 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.3/static/app-pg-ctl.html +See http://www.postgresql.org/docs/9.4/static/app-pg-ctl.html From PostgreSQL 9.3 we support in place database upgrades using pg_upgrade: http://www.postgresql.org/docs/9.3/static/pgupgrade.html -A few hints for (future) PostgreSQL 9.3 -> 9.4 upgrade: +A few hints for PostgreSQL 9.3 -> 9.4 upgrade: - Don't remove old PostgreSQL 9.3.x package - Install PostgreSQL 9.4.x, note that binaries are in '/usr/lib64/postgresql/9.4/bin' @@ -50,5 +50,15 @@ To build PostgreSQL with all extensions, use the following command: # PG_EXTENSIONS=ALL ./postgresql.SlackBuild -Please note that in order to actually use extension, you must execute -'CREATE EXTENSION [ IF NOT EXISTS ] extension_name' for each extension. +Please note that in order to actually use extension, you must execute 'CREATE EXTENSION [ IF NOT EXISTS ] extension_name' for each extension. + +OpenLDAP Notes + +With OpenLDAP versions 2.4.24 through 2.4.31, inclusive, each backend +process that loads libpq (via WAL receiver, dblink, or postgres_fdw) and +also uses LDAP will crash on exit. + +The LDAP wont be enabled (regardless of '--with-ldap' flag in slackbuild) +for affected OpenLDAP versions, so we've removed that build flag alltogether. + +(OpenLDAP 2.4.31 is the version included in Slackware 14.1) diff --git a/system/postgresql/postgresql.SlackBuild b/system/postgresql/postgresql.SlackBuild index 7e0f2e4ac1..d37d0142d3 100644 --- a/system/postgresql/postgresql.SlackBuild +++ b/system/postgresql/postgresql.SlackBuild @@ -2,8 +2,8 @@ # Slackware build script for PostgreSQL # -# $Revision: 48079e3de1a0 $ -# $Date: 2014/04/12 06:31:25 $ +# $Revision: 1fcb141fcfb8 $ +# $Date: 2015/01/08 06:56:14 $ # # Copyright 2007-2014 Adis Nezirovic # All rights reserved. @@ -28,11 +28,11 @@ # Modified by the SlackBuilds.org Project PRGNAM=postgresql -VERSION=${VERSION:-9.3.4} +VERSION=${VERSION:-9.4.0} BUILD=${BUILD:-1} TAG=${TAG:-_SBo} -PG_VERSION=${PG_VERSION:-9.3} +PG_VERSION=${PG_VERSION:-9.4} PG_PORT=${PG_PORT:-5432} PG_UID=${PG_UID:-209} PG_GID=${PG_GID:-209} @@ -111,7 +111,6 @@ CFLAGS="$SLKCFLAGS" \ --with-tcl \ --with-perl \ --with-python \ - --with-ldap \ --with-libxml \ --with-libxslt \ --enable-thread-safety \ @@ -135,7 +134,7 @@ make install-docs DESTDIR=$PKG ) # Some interesting additional modules: -# http://www.postgresql.org/docs/9.3/static/contrib.html +# http://www.postgresql.org/docs/9.4/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 84d1d4a57c..8e4d47823c 100644 --- a/system/postgresql/postgresql.info +++ b/system/postgresql/postgresql.info @@ -1,8 +1,8 @@ PRGNAM="postgresql" -VERSION="9.3.4" +VERSION="9.4.0" HOMEPAGE="http://www.postgresql.org" -DOWNLOAD="http://ftp.postgresql.org/pub/source/v9.3.4/postgresql-9.3.4.tar.bz2" -MD5SUM="d0a41f54c377b2d2fab4a003b0dac762" +DOWNLOAD="http://ftp.postgresql.org/pub/source/v9.4.0/postgresql-9.4.0.tar.bz2" +MD5SUM="8cd6e33e1f8d4d2362c8c08bd0e8802b" DOWNLOAD_x86_64="" MD5SUM_x86_64="" REQUIRES="" diff --git a/system/postgresql/rc.postgresql.new b/system/postgresql/rc.postgresql.new index f4475f3605..9369fca425 100644 --- a/system/postgresql/rc.postgresql.new +++ b/system/postgresql/rc.postgresql.new @@ -2,8 +2,8 @@ # PostgreSQL startup script for Slackware Linux # -# $Revision: 61c366027519 $ -# $Date: 2014/03/08 06:55:06 $ +# $Revision: b8124de4727c $ +# $Date: 2015/01/08 06:23:01 $ # # Copyright 2007-2014 Adis Nezirovic # All rights reserved. @@ -92,20 +92,10 @@ case "$1" in fi exit 1 - else # remove old socket, if it exists and no daemon is running. - - if [ ! -f $PIDFILE ]; then - rm -f /tmp/.s.PGSQL.$PG_PORT - rm -f /tmp/.s.PGSQL.$PG_PORT.lock - test x"$OOM_SCORE_ADJ" != x && echo "$OOM_SCORE_ADJ" > /proc/self/oom_score_adj - pg_ctl start -w -l $LOGFILE -D $DATADIR - exit 0 - else - echo "PostgreSQL daemon was not properly shut down" - echo "Please remove stale pid file $PIDFILE" - exit 7 - fi - + else + test x"$OOM_SCORE_ADJ" != x && echo "$OOM_SCORE_ADJ" > /proc/self/oom_score_adj + pg_ctl start -w -l $LOGFILE -D $DATADIR + exit 0 fi ;; -- cgit v1.2.3