# HG changeset patch
# User Pascal Bellard <pascal.bellard@slitaz.org>
# Date 1217082230 0
# Node ID 443dbfefc6bf1df707cf6d85479710133b94299c
# Parent  14dc2f3537330848287859b70802238b8f1890b4
Add postgresql

diff -r 14dc2f353733 -r 443dbfefc6bf libpostgresqlclient/receipt
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/libpostgresqlclient/receipt	Sat Jul 26 14:23:50 2008 +0000
@@ -0,0 +1,20 @@
+# SliTaz package receipt.
+
+PACKAGE="libpostgresqlclient"
+VERSION="8.3.3"
+CATEGORY="system"
+SHORT_DESC="SQL database system libraries."
+MAINTAINER="pascal.bellard@slitaz.org"
+WEB_SITE="http://www.pgsql.com/"
+WANTED="postgresql"
+
+# Rules to gen a SliTaz package suitable for Tazpkg.
+genpkg_rules()
+{
+	while read file; do
+		dir=$(dirname $file)
+		[ -d $fs$dir ] || mkdir -p $fs$dir
+		cp -a $_pkg$file $fs$file
+	done < $src/$PACKAGE.files-list
+}
+
diff -r 14dc2f353733 -r 443dbfefc6bf php-pgsql/receipt
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/php-pgsql/receipt	Sat Jul 26 14:23:50 2008 +0000
@@ -0,0 +1,37 @@
+# SliTaz package receipt.
+
+PACKAGE="php-pgsql"
+VERSION="5.2.5"
+CATEGORY="development"
+SHORT_DESC="postgresql module for PHP web programming language."
+MAINTAINER="pascal.bellard@slitaz.org"
+DEPENDS="postgresql php"
+WEB_SITE="http://www.php.net/"
+WANTED="php"
+
+# Rules to gen a SliTaz package suitable for Tazpkg.
+genpkg_rules()
+{
+	mkdir -p $fs/usr/share/php
+	cp $(find $_pkg | grep pgsql.so) $fs/usr/share/php/
+}
+
+# Post and pre install commans to stop
+# and restart Web server if needed.
+pre_install()
+{
+	if [ -z "$1" -a -f "/var/run/lighttpd.pid" ]; then
+		/etc/init.d/lighttpd stop
+	fi
+}
+
+post_install()
+{
+	grep -q ^extension=msql.so $1/etc/php.ini || \
+	    sed -e 's|;.*extension=msql.so|;   extension=msql.so\nextension=pgsql.so|' -i $1/etc/php.ini
+	# Start Web server.
+	if [ -z "$1" -a ! -f "/var/run/lighttpd.pid" ]; then
+		/etc/init.d/lighttpd start
+	fi
+}
+
diff -r 14dc2f353733 -r 443dbfefc6bf php/receipt
--- a/php/receipt	Sat Jul 26 13:42:32 2008 +0000
+++ b/php/receipt	Sat Jul 26 14:23:50 2008 +0000
@@ -6,7 +6,7 @@
 SHORT_DESC="PHP web programming language."
 MAINTAINER="pankso@slitaz.org"
 DEPENDS="lighttpd zlib libxml2 sqlite"
-BUILD_DEPENDS="sqlite-dev libxml2-dev zlib-dev mysql-dev"
+BUILD_DEPENDS="sqlite-dev libxml2-dev zlib-dev mysql-dev postgresql postgresql-dev"
 TARBALL="$PACKAGE-$VERSION.tar.bz2"
 WEB_SITE="http://www.php.net/"
 WGET_URL="http://us2.php.net/distributions/$TARBALL"
@@ -27,6 +27,7 @@
 		--with-config-file-path=/etc \
 		--with-zlib \
 		--with-mysql=shared,usr \
+		--with-pgsql=shared,usr \
 		--disable-cli \
 		$CONFIGURE_ARGS
 	make
diff -r 14dc2f353733 -r 443dbfefc6bf phppgadmin/receipt
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/phppgadmin/receipt	Sat Jul 26 14:23:50 2008 +0000
@@ -0,0 +1,45 @@
+# SliTaz package receipt.
+
+PACKAGE="phppgadmin"
+VERSION="4.2"
+CATEGORY="misc"
+SHORT_DESC="Administration of postgresql over the Web."
+MAINTAINER="pascal.bellard@slitaz.org"
+SOURCE="phpPgAdmin"
+TARBALL="$SOURCE-$VERSION.tar.bz2"
+WEB_SITE="http://$PACKAGE.sourceforge.net/"
+WGET_URL="$SF_MIRROR/$PACKAGE/$TARBALL"
+DEPENDS="php-pgsql"
+
+# Rules to configure and make the package.
+compile_rules()
+{
+	echo "$src compiled..."
+}
+
+# Rules to gen a SliTaz package suitable for Tazpkg.
+genpkg_rules()
+{
+	mkdir -p $fs/usr/share/phppgadmin $fs/etc
+	cp -a $src/. $fs/usr/share/phppgadmin
+	mv $fs/usr/share/phppgadmin/conf $fs/etc/phppgadmin
+	ln -s /etc/phppgadmin $fs/usr/share/phppgadmin/conf
+	chown -R www.www $fs/usr/share/phppgadmin $fs/etc/phppgadmin
+	chmod 700 $fs/etc/phppgadmin
+	chmod 600 $fs/etc/phppgadmin/*
+}
+
+post_install()
+{
+	if [ -f $1/etc/lighttpd/lighttpd.conf ]; then
+		if ! grep -q /usr/share/phppgadmin/ $1/etc/lighttpd/lighttpd.conf; then
+	    		sed -e 's|.*"/examples/" => "/usr/share/examples/",|    "/examples/" => "/usr/share/examples/",\n    "/phppgadmin/" => "/usr/share/phppgadmin/",|g' -i $1/etc/lighttpd/lighttpd.conf
+			if [ -z "$1" ]; then
+				# Start Web server.
+				/etc/init.d/lighttpd stop
+				/etc/init.d/lighttpd start
+			fi
+		fi
+	fi
+}
+
diff -r 14dc2f353733 -r 443dbfefc6bf postgresql-client/receipt
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/postgresql-client/receipt	Sat Jul 26 14:23:50 2008 +0000
@@ -0,0 +1,21 @@
+# SliTaz package receipt.
+
+PACKAGE="postgresql-client"
+VERSION="8.3.3"
+CATEGORY="system"
+SHORT_DESC="SQL database system client files."
+MAINTAINER="pascal.bellard@slitaz.org"
+WEB_SITE="http://www.pgsql.com/"
+DEPENDS="libpostgresqlclient zlib ncurses readline"
+WANTED="postgresql"
+
+# Rules to gen a SliTaz package suitable for Tazpkg.
+genpkg_rules()
+{
+	while read file; do
+		dir=$(dirname $file)
+		[ -d $fs$dir ] || mkdir -p $fs$dir
+		cp -a $_pkg$file $fs$file
+	done < $src/$PACKAGE.files-list
+}
+
diff -r 14dc2f353733 -r 443dbfefc6bf postgresql-dev/receipt
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/postgresql-dev/receipt	Sat Jul 26 14:23:50 2008 +0000
@@ -0,0 +1,18 @@
+# SliTaz package receipt.
+
+PACKAGE="postgresql-dev"
+VERSION="8.3.3"
+CATEGORY="system"
+SHORT_DESC="SQL database system development files"
+MAINTAINER="pascal.bellard@slitaz.org"
+WEB_SITE="http://www.pgsql.com/"
+WANTED="postgresql"
+
+# Rules to gen a SliTaz package suitable for Tazpkg.
+genpkg_rules()
+{
+	mkdir -p $fs/usr/lib/postgresql
+	cp -a $_pkg/usr/include $fs/usr
+	cp -a $_pkg/usr/lib/postgresql/*a $fs/usr/lib/postgresql
+}
+
diff -r 14dc2f353733 -r 443dbfefc6bf postgresql-doc/receipt
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/postgresql-doc/receipt	Sat Jul 26 14:23:50 2008 +0000
@@ -0,0 +1,17 @@
+# SliTaz package receipt.
+
+PACKAGE="postgresql-doc"
+VERSION="8.3.3"
+CATEGORY="system"
+SHORT_DESC="SQL database system documentation"
+MAINTAINER="pascal.bellard@slitaz.org"
+WEB_SITE="http://www.pgsql.com/"
+WANTED="postgresql"
+
+# Rules to gen a SliTaz package suitable for Tazpkg.
+genpkg_rules()
+{
+	mkdir -p $fs/usr
+	cp -a $_pkg/usr/doc $fs/
+}
+
diff -r 14dc2f353733 -r 443dbfefc6bf postgresql/receipt
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/postgresql/receipt	Sat Jul 26 14:23:50 2008 +0000
@@ -0,0 +1,82 @@
+# SliTaz package receipt.
+
+PACKAGE="postgresql"
+VERSION="8.3.3"
+CATEGORY="system"
+SHORT_DESC="SQL database system."
+MAINTAINER="pascal.bellard@slitaz.org"
+TARBALL="$PACKAGE-$VERSION.tar.bz2"
+WEB_SITE="http://www.pgsql.com/"
+WGET_URL="ftp://ftp.fr.postgresql.org/v$VERSION/$TARBALL"
+DEPENDS="postgresql-client zlib"
+BUILD_DEPENDS="zlib-dev readline-dev ncurses-dev"
+
+# Rules to configure and make the package.
+compile_rules()
+{
+	cd $src
+	[ -d ../postgrpsql-$VERSION ] && cp -a ../postgrpsql-$VERSION/* .
+	./configure --prefix=/usr --infodir=/usr/share/info \
+	--sysconfdir=/etc --includedir=/usr/include/postgresql --with-gnu-ld \
+	--with-includes=/usr/include/readline --enable-integer-datetimes \
+	--enable-thread-safety --with-system-tzdata=/usr/share/zoneinfo \
+	--libdir=/usr/lib/postgresql --mandir=/usr/share/man $CONFIGURE_ARGS
+	make
+	make DESTDIR=$PWD/_pkg install
+	cp ../stuff/*.files-list .
+}
+
+# Rules to gen a SliTaz package suitable for Tazpkg.
+genpkg_rules()
+{
+	mkdir -p $fs/usr/share $fs/usr/lib $fs/var/lib/pgsql \
+		 $fs/var/log/postgresql
+	cp -a $_pkg/usr/bin $fs/usr
+	cp -a $_pkg/usr/lib/postgresql $fs/usr/lib
+	rm -f $fs/usr/lib/postgresql/*a
+	cp -a $_pkg/usr/share/postgresql $fs/usr/share
+	cp -a stuff/etc $fs
+	ln -s /var/lib/pgsql/postgresql.conf $fs/etc
+	chmod 700 $fs/var/lib/pgsql
+	cat $src/*.files-list | while read file; do
+		[ -f $fs$file ] && rm -f $fs$file
+	done
+	# Package all pgsql pkgs
+	for i in $(cd $WOK; ls -d postgresql-* libpostgresql* )
+	do
+		tazwok genpkg $i
+	done
+}
+
+# Pre and post install commands for Tazpkg.
+post_install()
+{
+        # adduser postgres if needed
+	if ! grep -q postgres $1/etc/passwd; then
+		echo -n "Adding user postgres..."
+		chroot $1/ adduser postgres -D -H -h /var/lib/pgsql
+		status
+	fi
+	# addgroup postgres if needed
+	if ! grep -q postgres $1/etc/group; then
+		echo -n "Adding group postgres..."
+		chroot $1/ addgroup postgres && addgroup postgres postgres
+		status
+	fi
+	chroot $1/ chown -R postgres.postgres /var/lib/pgsql /var/log/postgresql
+	cat <<EOF
+----
+To start $PACKAGE server you can run :
+
+    /etc/init.d/$PACKAGE start
+
+Or add $PACKAGE to RUN_DAEMONS in /etc/rcS.conf
+----
+EOF
+}
+
+post_remove()
+{
+	deluser postgres
+	delgroup postgres
+}
diff -r 14dc2f353733 -r 443dbfefc6bf postgresql/stuff/etc/init.d/postgresql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/postgresql/stuff/etc/init.d/postgresql	Sat Jul 26 14:23:50 2008 +0000
@@ -0,0 +1,53 @@
+#!/bin/sh
+# /etc/init.d/postgresql : Start, stop and restart PostgreSQL server on SliTaz,
+# at boot time or with the command line.
+#
+# To start postgresql server at boot time, just put mysql in the $RUN_DAEMONS
+# variable of /etc/rcS.conf and configure options with /etc/daemons.conf
+#
+. /etc/init.d/rc.functions
+. /etc/daemons.conf
+
+NAME=Postgresql
+DESC="PostgreSQL server"
+su -c "postgres -D /var/lib/pgsql >logfile 2>&1" - postgres &
+OPTIONS=$PGSQL_OPTIONS
+[ -n "$OPTIONS" ] || OPTIONS="-D /var/lib/pgsql -s"
+
+case "$1" in
+  start)
+    if [ ! -f /var/lib/pgsql/PG_VERSION ]; then
+        echo "Initializing $DESC database"
+	rm -rf /var/lib/pgsql/* 2> /dev/null
+        su -c "initdb -D /var/lib/pgsql" - postgres
+    fi
+    echo -n "Starting $DESC: $NAME... "
+    su -c "pg_ctl start -w $OPTIONS -l /var/log/postgresql/postgresql.log" - postgres
+    status
+# su -c "createdb test" - postgres
+# su -c "psql test" - postgres
+    ;;
+  stop)
+    echo -n "Stopping $DESC: $NAME... "
+    su -c "pg_ctl stop $OPTIONS -m smart" - postgres
+    status
+    ;;
+  restart)
+    echo -n "Restarting $DESC: $NAME... "
+    su -c "pg_ctl restart $OPTIONS -m smart" - postgres
+    status
+    ;;
+  reload)
+    echo -n "Reloading $DESC: $NAME... "
+    su -c "pg_ctl reload $OPTIONS" - postgres
+    status
+    ;;
+  *)
+    echo ""
+    echo -e "\033[1mUsage:\033[0m /etc/init.d/`basename $0` [start|stop|restart|reload]"
+    echo ""
+    exit 1
+    ;;
+esac
+
+exit 0
diff -r 14dc2f353733 -r 443dbfefc6bf postgresql/stuff/etc/logrotate.d/postgresql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/postgresql/stuff/etc/logrotate.d/postgresql	Sat Jul 26 14:23:50 2008 +0000
@@ -0,0 +1,9 @@
+/var/log/postgresql/postgres.log {
+	daily
+	rotate 10
+	copytruncate
+	delaycompress
+	compress
+	notifempty
+	create 640 postgres postgres
+}
diff -r 14dc2f353733 -r 443dbfefc6bf postgresql/stuff/libpostgresqlclient.files-list
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/postgresql/stuff/libpostgresqlclient.files-list	Sat Jul 26 14:23:50 2008 +0000
@@ -0,0 +1,3 @@
+/usr/lib/postgresql/libpq.so
+/usr/lib/postgresql/libpq.so.5
+/usr/lib/postgresql/libpq.so.5.1
diff -r 14dc2f353733 -r 443dbfefc6bf postgresql/stuff/postgresql-client.files-list
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/postgresql/stuff/postgresql-client.files-list	Sat Jul 26 14:23:50 2008 +0000
@@ -0,0 +1,13 @@
+/usr/bin/pg_dump
+/usr/bin/pg_restore
+/usr/bin/pg_dumpall
+/usr/bin/psql
+/usr/bin/createdb
+/usr/bin/dropdb
+/usr/bin/createlang
+/usr/bin/droplang
+/usr/bin/createuser
+/usr/bin/dropuser
+/usr/bin/clusterdb
+/usr/bin/vacuumdb
+/usr/bin/reindexdb