system/postgresql: Updated for version 9.3.0.

Signed-off-by: Robby Workman <rworkman@slackbuilds.org>

1 files changed, 34 insertions, 21 deletions

diff --git a/system/postgresql/postgresql.SlackBuild b/system/postgresql/postgresql.SlackBuild
index 5640c542fe..3dc0dbbad8 100644
--- a/system/postgresql/postgresql.SlackBuild
+++ b/system/postgresql/postgresql.SlackBuild
@@ -1,8 +1,8 @@
 #!/bin/sh
 
 ## Slackware build script for PostgreSQL
-## $Revision: 09a9051874b3 $
-## $Date: 2013/04/04 14:52:11 $
+## $Revision: dbf620a11266 $
+## $Date: 2013/09/19 10:35:00 $
 ##
 ## Copyright 2007-2013 Adis Nezirovic <adis _at_ linux.org.ba>
 ## Licensed under GNU GPL v2
@@ -10,10 +10,12 @@
 # Modified by the SlackBuilds.org Project
 
 PRGNAM=postgresql
-VERSION=${VERSION:-9.2.4}
+VERSION=${VERSION:-9.3.0}
 BUILD=${BUILD:-1}
 TAG=${TAG:-_SBo}
 
+PG_VERSION=${PG_VERSION:-9.3}
+PG_PORT=${PG_PORT:-5432}
 PG_UID=${PG_UID:-209}
 PG_GID=${PG_GID:-209}
 
@@ -77,9 +79,10 @@ chmod -R a-s,u+w,go+r-w .
 
 CFLAGS="$SLKCFLAGS" \
 ./configure \
-  --prefix=/usr \
-  --libdir=/usr/lib${LIBDIRSUFFIX} \
-  --sysconfdir=/etc \
+  --prefix=/usr/lib${LIBDIRSUFFIX}/$PRGNAM/$PG_VERSION \
+  --sysconfdir=/etc/$PRGNAM/$PG_VERSION \
+  --includedir=/usr/include \
+  --datarootdir=/usr/share \
   --mandir=/usr/man \
   --docdir=/usr/doc/$PRGNAM-$VERSION \
   --with-openssl \
@@ -100,15 +103,17 @@ make install-docs DESTDIR=$PKG
 
 
 # Some interesting additional modules:
-#   http://www.postgresql.org/docs/9.2/static/contrib.html
+#   http://www.postgresql.org/docs/9.3/static/contrib.html
 #
-#  adminpack - helper extension for pgAdmin
-#  pgcrypto - extension for some business applications
-#  hstore, ltree, xml2 - useful extensions for developers
-#  pg_archivecleanup, pg_standby - high availability helpers
-#  pg_upgrade, pg_upgrade_support - online upgrade between postgresql versions
+# adminpack - helper extension for pgAdmin
+# pgcrypto - extension for some business applications
+# hstore, ltree, xml2 - useful extensions for developers
+# pg_archivecleanup, pg_standby - high availability helpers
+# pg_upgrade, pg_upgrade_support - online upgrade between postgresql versions
+# postgres_fdw - foreign-data wrapper for access to external PostgreSQL servers 
+# file_fdw - foreign-data wrapper for access to data files on filesystem
 
-PG_EXTENSIONS=${PG_EXTENSIONS:-"adminpack pgcrypto hstore ltree xml2 pg_archivecleanup pg_standby pg_upgrade pg_upgrade_support"}
+PG_EXTENSIONS=${PG_EXTENSIONS:-"adminpack pgcrypto hstore ltree xml2 pg_archivecleanup pg_standby pg_upgrade pg_upgrade_support postgres_fdw file_fdw"}
 
 if [ "x$PG_EXTENSIONS" = "xALL" ];then
   cd $TMP/$PRGNAM-$VERSION/contrib
@@ -134,29 +139,37 @@ cat $CWD/README.SBo > $PKG/usr/doc/$PRGNAM-$VERSION/README.SBo
 
 # base database directory
 # assumes you are using /var/lib/pgsql as a homedir for postgres user
-mkdir -p $PKG/var/lib/pgsql/data
+mkdir -p $PKG/var/lib/pgsql/$PG_VERSION/data
 chown -R postgres:postgres $PKG/var/lib/pgsql
 chmod 700 $PKG/var/lib/pgsql
 # permissions for DATADIR should be u=rwx (0700)
-chmod 700 $PKG/var/lib/pgsql/data
+chmod 700 $PKG/var/lib/pgsql/$PG_VERSION/data
 
 # Install init script
 mkdir -p $PKG/etc/rc.d
-cat $CWD/rc.postgresql.new > $PKG/etc/rc.d/rc.postgresql.new
-chmod 0755 $PKG/etc/rc.d/rc.postgresql.new
+sed -e "s%@PG_VERSION@%$PG_VERSION%" \
+  -e "s%@PG_PORT@%$PG_PORT%" \
+  -e "s%@LIBDIRSUFFIX@%$LIBDIRSUFFIX%" \
+  $CWD/rc.$PRGNAM.new > $PKG/etc/rc.d/rc.$PRGNAM.new 
+chmod 0755 $PKG/etc/rc.d/rc.$PRGNAM.new
 
 # Install logrotate script
 mkdir -p $PKG/etc/logrotate.d
-cat $CWD/postgresql.logrotate > $PKG/etc/logrotate.d/postgresql.new
+sed -e "s%@PG_VERSION@%$PG_VERSION%" \
+  $CWD/$PRGNAM.logrotate > $PKG/etc/logrotate.d/$PRGNAM.new
 
 mkdir -p $PKG/var/log/setup
-sed -e "s%@UID@%$PG_UID%" -e "s%@GID@%$PG_GID%" $CWD/setup.$PRGNAM \
-  > $PKG/var/log/setup/setup.$PRGNAM
+sed -e "s%@UID@%$PG_UID%" \
+  -e "s%@GID@%$PG_GID%" \
+  -e "s%@PG_VERSION@%$PG_VERSION%" \
+  $CWD/setup.$PRGNAM  > $PKG/var/log/setup/setup.$PRGNAM
 chmod 755 $PKG/var/log/setup/setup.$PRGNAM
 
 mkdir -p $PKG/install
 cat $CWD/slack-desc > $PKG/install/slack-desc
-cat $CWD/doinst.sh > $PKG/install/doinst.sh
+sed -e "s%@PG_VERSION@%$PG_VERSION%" \
+  -e "s%@LIBDIRSUFFIX@%$LIBDIRSUFFIX%" \
+  $CWD/doinst.sh > $PKG/install/doinst.sh 
 
 cd $PKG
 /sbin/makepkg -l y -c n $OUTPUT/$PRGNAM-$VERSION-$ARCH-$BUILD$TAG.${PKGTYPE:-tgz}