aboutsummaryrefslogtreecommitdiff
path: root/system/postgresql
diff options
context:
space:
mode:
authorAdis Nezirovic <adis@linux.org.ba>2015-01-08 17:03:57 +0700
committerWilly Sudiarto Raharjo <willysr@slackbuilds.org>2015-01-08 17:03:57 +0700
commitb8ca51749cfebb9294f1335a570a22420eaa603c (patch)
tree9fdb5c037f0c77f9db0cbc64205e142897942ce0 /system/postgresql
parent5aff91909fbd42d91f861862c413f7e05f27be47 (diff)
system/postgresql: Updated for version 9.4.0.
Signed-off-by: Willy Sudiarto Raharjo <willysr@slackbuilds.org>
Diffstat (limited to 'system/postgresql')
-rw-r--r--system/postgresql/README.SBo22
-rw-r--r--system/postgresql/postgresql.SlackBuild11
-rw-r--r--system/postgresql/postgresql.info6
-rw-r--r--system/postgresql/rc.postgresql.new22
4 files changed, 30 insertions, 31 deletions
diff --git a/system/postgresql/README.SBo b/system/postgresql/README.SBo
index 6ec5736c3ce3..80148572e071 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 7e0f2e4ac12e..d37d0142d33a 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 <adis_at_linux.org.ba>
# 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 84d1d4a57c7b..8e4d47823cad 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 f4475f36058b..9369fca4254a 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 <adis_at_linux.org.ba>
# 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
;;