#Maintainer: Pedro Pinto (pnboy~AT~pinguix.com)

pkgname=postgresql
pkgver=8.3.7
pkgrel=1
zenver=62
arch=i486
source=(ftp://ftp.pt.postgresql.org/pub/postgresql/source/v$pkgver/postgresql-$pkgver.tar.bz2 postgresql.logrotate rc.postgresql)
sourcetemplate=http://pnboy.pinguix.com/my_packages/zenwalk/$pkgname/$pkgver/
docs=(COPYRIGHT HISTORY README)
url=http://www.postgresql.org
extradepends=(libtermcap openssl python readline tcl zlib lib$pkgname)
dotnew=(etc/rc.d/rc.postgresql etc/logrotate.d/postgresql var/lib/pgsql/postgresql.conf)
options=('norequiredbuilder')

doinst() {
# Define minimum values for UID and GID
MUID=26
MGID=26
USERNAME="postgres"
GROUPNAME="postgres"
COMMENT="PostgreSQL"
HOMEDIR="/var/lib/pgsql"
(
if ! grep -qe "^$GROUPNAME:" etc/group; then
        NEXTGID="$(MGID=$MGID awk -F: '{uid[$3]=1} END { for (i=ENVIRON["MGID"];i in uid;i++);print i}' etc/group)"
        echo creating group $GROUPNAME with GID $NEXTGID...
        chroot . /usr/sbin/groupadd -g $NEXTGID $GROUPNAME

fi
)
(
if ! grep -qe "^$USERNAME:" etc/passwd; then
        NEXTUID="$(MUID=$MUID awk -F: '{uid[$3]=1} END { for (i=ENVIRON["MUID"];i in uid;i++);print i}' etc/passwd)"
        echo creating user $USERNAME with UID $NEXTUID...
        chroot . /usr/sbin/useradd -g $GROUPNAME -u $NEXTUID -d $HOMEDIR -c $COMMENT $USERNAME
fi
)
chown -R postgres:postgres var/lib/pgsql
chmod 700 var/lib/pgsql
chmod 700 var/lib/pgsql/data
}

slackdesc=\
(
#|-----handy-ruler------------------------------------------------------|
"PostgreSQL (A robust Object-Relational DBMS)"
"PostgreSQL is an advanced object-relational database management"
"system (ORDBMS) based on POSTGRES. With more than 15 years of"
"development history, it is quickly becoming the de facto"
"database for enterprise level open source solutions."
"This build includes full text search support (tsearch2)."
)


build() {
	cd $startdir/src/$pkgname-$pkgver
	./configure --prefix=/usr --localstatedir=/var --sysconfdir=/etc  --with-openssl --with-tcl --with-perl --with-python --enable-thread-safety
	make || return 1
	make install-strip DESTDIR=$startdir/pkg
	# Two nice extensions:
	#   adminpack for pgAdmin
	#   tsearch2 for full text search
	(cd contrib/adminpack
	make || return 1
	make DESTDIR=$startdir/pkg install-strip || return 1 )
	(cd contrib/tsearch2
	make || return 1
	make DESTDIR=$startdir/pkg install-strip || return 1 )
	# Relocation
	mv $startdir/pkg/usr/doc/$pkgname $startdir/pkg/usr/doc/$pkgname-$pkgver
	mkdir -p $startdir/pkg/var/lib/pgsql/data
	mkdir -p $startdir/pkg/etc/rc.d/
	cp $startdir/src/$pkgname-$pkgver/src/backend/utils/misc/postgresql.conf.sample $startdir/pkg/var/lib/pgsql/postgresql.conf
	mkdir -p $startdir/pkg/usr/doc/$pkgname-$pkgver
	cp -r doc/* $startdir/pkg/usr/doc/$pkgname-$pkgver/
	mkdir -p $startdir/pkg/etc/logrotate.d/
	cp $startdir/src/postgresql.logrotate $startdir/pkg/etc/logrotate.d/postgresql
	cp $startdir/src/rc.postgresql $startdir/pkg/etc/rc.d/rc.postgresql
        # build a iceweasel-devel package
        package2=lib$pkgname-$pkgver-$arch-$zenver.$pkgrel
        [ -d $startdir/pkg2 ] && rm -rf $startdir/pkg2
        mkdir -p $startdir/pkg2/usr/{share/locale,bin}
        mv $startdir/pkg/usr/include $startdir/pkg2/usr/
	mv $startdir/pkg/usr/lib $startdir/pkg2/usr/
	mv $startdir/pkg/usr/share/locale/ $startdir/pkg2/usr/share/locale/
	mv $startdir/pkg/usr/bin/pg_config $startdir/pkg2/usr/bin
        cd $startdir/pkg2
        mkdir -p $startdir/pkg2/install/
        cat << EOF > $startdir/pkg2/install/slack-desc
lib$pkgname: lib$pkgname (Development files for posgresql)
lib$pkgname:
lib$pkgname: Development files for posgresql.
EOF
        /sbin/makepkg -l y -c n $startdir/$package2.tgz
        cd $startdir
        md5sum $package2.tgz > $startdir/$package2.md5
        #empty dep file
        echo "">$startdir/$package2.dep
        rm -rvf $startdir/pkg2
        unset package2
}