From c361f5eb42fcfcfa0663cb89c38b2eb8fab1bb2c Mon Sep 17 00:00:00 2001 From: James Meyer Date: Sat, 14 Mar 2009 13:29:26 -0500 Subject: Adding posgresql, which is needed to make qt3. Probably could have removed psql support from qt3, but psql might come in handy later. --- abs/extra-testing/postgresql-libs/PKGBUILD | 6 +- abs/extra-testing/postgresql/PKGBUILD | 79 +++++++++++++++++++++++++++ abs/extra-testing/postgresql/build.patch | 11 ++++ abs/extra-testing/postgresql/postgresql | 59 ++++++++++++++++++++ abs/extra-testing/postgresql/postgresql.confd | 4 ++ abs/extra-testing/postgresql/postgresql.pam | 3 + 6 files changed, 159 insertions(+), 3 deletions(-) create mode 100644 abs/extra-testing/postgresql/PKGBUILD create mode 100644 abs/extra-testing/postgresql/build.patch create mode 100755 abs/extra-testing/postgresql/postgresql create mode 100644 abs/extra-testing/postgresql/postgresql.confd create mode 100644 abs/extra-testing/postgresql/postgresql.pam diff --git a/abs/extra-testing/postgresql-libs/PKGBUILD b/abs/extra-testing/postgresql-libs/PKGBUILD index 50ba785..ac037c7 100644 --- a/abs/extra-testing/postgresql-libs/PKGBUILD +++ b/abs/extra-testing/postgresql-libs/PKGBUILD @@ -1,8 +1,8 @@ -# $Id: PKGBUILD 18408 2008-11-04 22:14:34Z douglas $ +# $Id: PKGBUILD 27764 2009-02-25 16:30:54Z douglas $ # Maintainer: Paul Mattal pkgname=postgresql-libs -pkgver=8.3.5 +pkgver=8.3.6 pkgrel=1 pkgdesc="Libraries for use with PostgreSQL" arch=(i686 x86_64) @@ -55,4 +55,4 @@ build() { set +e } -md5sums=('3bc028774d7a79e926be0c6a9c7ca209') +md5sums=('4f8c67d802bd03b5b844e268bba7d44a') diff --git a/abs/extra-testing/postgresql/PKGBUILD b/abs/extra-testing/postgresql/PKGBUILD new file mode 100644 index 0000000..1fda9a4 --- /dev/null +++ b/abs/extra-testing/postgresql/PKGBUILD @@ -0,0 +1,79 @@ +# $Id: PKGBUILD 27762 2009-02-25 16:29:49Z douglas $ +# Maintainer: Paul Mattal + +pkgname=postgresql +pkgver=8.3.6 +pkgrel=1 +pkgdesc="A sophisticated object-relational DBMS" +arch=(i686 x86_64) +license=('BSD') +backup=('etc/conf.d/postgresql' '/etc/pam.d/postgresql') +url="http://www.postgresql.org/" +depends=("postgresql-libs>=$pkgver" "libxml2") +options=('!makeflags') +source=(ftp://ftp.postgresql.org/pub/source/v${pkgver}/postgresql-${pkgver}.tar.bz2 \ + postgresql postgresql.confd build.patch postgresql.pam) + +build() { + cd ${startdir}/src/$pkgname-$pkgver || return 1 + + # patch to remove regress/test make target (won't build with it present) + patch -Np1 -i ../build.patch || return 1 + + # configure + ./configure --prefix=/usr --mandir=/usr/share/man \ + --with-docdir=/usr/share/doc --with-openssl \ + --datadir=/usr/share/postgresql --with-pam --with-libxml || return 1 + + sed -i -e '/interfaces/d' src/Makefile || return 1 + + # build + make || return 1 + + # install + make DESTDIR=${startdir}/pkg install || return 1 + + ( + cd contrib/adminpack; + make || return 1; + make DESTDIR=${startdir}/pkg install || return 1; + ); + + + # clean up unneeded installed items + rm -rf $startdir/pkg/usr/include/postgresql/internal || return 1 + rm -rf $startdir/pkg/usr/include/libpq || return 1 + # the below line is expected to produce an error; fix this one day + rm -f $startdir/pkg/usr/include/* + rm -f $startdir/pkg/usr/bin/pg_config || return 1 + + # Maintaining the lib below because of qt + #rm -f $startdir/pkg/usr/lib/libpgport.a || return 1 + + # install launch script + install -D -m755 ../postgresql $startdir/pkg/etc/rc.d/postgresql \ + || return 1 + + # install license + install -D -m644 COPYRIGHT $startdir/pkg/usr/share/licenses/$pkgname/LICENSE || return 1 + + # install conf file + install -D -m644 $startdir/src/postgresql.confd \ + $startdir/pkg/etc/conf.d/postgresql || return 1 + + install -D -m644 $startdir/src/postgresql.pam \ + $startdir/pkg/etc/pam.d/postgresql + + chown root:root $startdir/pkg/usr/share/doc/postgresql/html/* +} + +md5sums=('4f8c67d802bd03b5b844e268bba7d44a' + '7d8ea2abb6a8cdacf35604bda659a34a' + 'df6ddf9e2ab4700a3415f17c0f4f4172' + '4d74f4227dc5e12bf95b3490758d86c9' + '96f82c38f3f540b53f3e5144900acf17') +md5sums=('4f8c67d802bd03b5b844e268bba7d44a' + '7d8ea2abb6a8cdacf35604bda659a34a' + 'df6ddf9e2ab4700a3415f17c0f4f4172' + '4d74f4227dc5e12bf95b3490758d86c9' + '96f82c38f3f540b53f3e5144900acf17') diff --git a/abs/extra-testing/postgresql/build.patch b/abs/extra-testing/postgresql/build.patch new file mode 100644 index 0000000..c8f665d --- /dev/null +++ b/abs/extra-testing/postgresql/build.patch @@ -0,0 +1,11 @@ +diff -Naur postgresql-8.2.3-orig/src/Makefile postgresql-8.2.3/src/Makefile +--- postgresql-8.2.3-orig/src/Makefile 2006-06-22 16:50:35.000000000 -0700 ++++ postgresql-8.2.3/src/Makefile 2007-03-05 10:46:24.000000000 -0800 +@@ -23,7 +23,6 @@ + $(MAKE) -C bin $@ + $(MAKE) -C pl $@ + $(MAKE) -C makefiles $@ +- $(MAKE) -C test/regress $@ + + install: install-local + diff --git a/abs/extra-testing/postgresql/postgresql b/abs/extra-testing/postgresql/postgresql new file mode 100755 index 0000000..c6aedfb --- /dev/null +++ b/abs/extra-testing/postgresql/postgresql @@ -0,0 +1,59 @@ +#!/bin/bash + +. /etc/rc.conf +. /etc/rc.d/functions +. /etc/conf.d/postgresql + +case "$1" in + start) + stat_busy "Starting PostgreSQL" + # initialization + if [ ! `egrep '^postgres:' /etc/group` ]; then + stat_busy "Adding postgres group" + groupadd -g 88 postgres + stat_done + fi + if [ ! `egrep '^postgres:' /etc/passwd` ]; then + stat_busy "Adding postgres user" + useradd -u 88 -g postgres -d $PGROOT -s /bin/bash postgres + [ -d $PGROOT ] && chown -R postgres.postgres $PGROOT + stat_done + fi + if [ ! -d $PGROOT ]; then + mkdir -p $PGROOT/data && chown postgres.postgres $PGROOT/data + su - postgres -c "/usr/bin/initdb -D $PGROOT/data" + fi + if [ ! -e /var/log/postgresql.log ]; then + touch /var/log/postgresql.log + chown postgres /var/log/postgresql.log + fi + # start the process + su - postgres -c \ + "/usr/bin/pg_ctl -D $PGROOT/data -l /var/log/postgresql.log -W start" + if [ $? -gt 0 ]; then + stat_fail + else + add_daemon postgresql + stat_done + fi + ;; + stop) + stat_busy "Stopping PostgreSQL" + su - postgres -c \ + "/usr/bin/pg_ctl -D $PGROOT/data -l /var/log/postgresql.log -w stop" + if [ $? -gt 0 ]; then + stat_fail + else + rm_daemon postgresql + stat_done + fi + ;; + restart) + $0 stop + sleep 3 + $0 start + ;; + *) + echo "usage: $0 {start|stop|restart}" +esac +exit 0 diff --git a/abs/extra-testing/postgresql/postgresql.confd b/abs/extra-testing/postgresql/postgresql.confd new file mode 100644 index 0000000..7bbf016 --- /dev/null +++ b/abs/extra-testing/postgresql/postgresql.confd @@ -0,0 +1,4 @@ +# +# Parameters to be passed to postgresql +# +PGROOT="/var/lib/postgres" \ No newline at end of file diff --git a/abs/extra-testing/postgresql/postgresql.pam b/abs/extra-testing/postgresql/postgresql.pam new file mode 100644 index 0000000..53724d1 --- /dev/null +++ b/abs/extra-testing/postgresql/postgresql.pam @@ -0,0 +1,3 @@ +auth required pam_unix.so +account required pam_unix.so +session required pam_unix.so -- cgit v0.12