From 617356e53ce0a7cb4d0c10a7a5e878fc78998cfc Mon Sep 17 00:00:00 2001
From: Tim Yardley <lst@openwrt.org>
Date: Mon, 9 Apr 2007 23:25:36 +0000
Subject: [PATCH] postgresql upgrade to 8.2.3, bringing in the server as
 well... this needs some data dir decisions to be made. to be discussed.

SVN-Revision: 6915
---
 libs/postgresql/Makefile                      | 156 ++++++++++++++++--
 libs/postgresql/files/postgresql.conf         |   5 +
 libs/postgresql/files/postgresql.init         |  45 +++++
 libs/postgresql/patches/200-ranlib.patch      |   8 +-
 .../750-configure-honor-cppflags.patch        |  12 +-
 .../patches/800-busybox-default-pager.patch   |  13 ++
 6 files changed, 211 insertions(+), 28 deletions(-)
 create mode 100644 libs/postgresql/files/postgresql.conf
 create mode 100755 libs/postgresql/files/postgresql.init
 create mode 100644 libs/postgresql/patches/800-busybox-default-pager.patch

diff --git a/libs/postgresql/Makefile b/libs/postgresql/Makefile
index c199856ed..17ee3e6e9 100644
--- a/libs/postgresql/Makefile
+++ b/libs/postgresql/Makefile
@@ -9,7 +9,7 @@
 include $(TOPDIR)/rules.mk
 
 PKG_NAME:=postgresql
-PKG_VERSION:=7.4.14
+PKG_VERSION:=8.2.3
 PKG_RELEASE:=1
 
 PKG_BUILD_DIR:=$(BUILD_DIR)/$(PKG_NAME)-$(PKG_VERSION)
@@ -17,7 +17,7 @@ PKG_SOURCE:=$(PKG_NAME)-$(PKG_VERSION).tar.bz2
 PKG_SOURCE_URL:=\
 	ftp://ftp.us.postgresql.org/pub/mirrors/postgresql/source/v$(PKG_VERSION) \
 	ftp://ftp-archives.postgresql.org/pub/source/v$(PKG_VERSION)
-PKG_MD5SUM:=2e0e82552f8463343df5d89348356481
+PKG_MD5SUM:=cb47771004d53505200ffd00ac45bc32
 PKG_CAT:=bzcat
 
 PKG_INSTALL_DIR:=$(PKG_BUILD_DIR)/ipkg-install
@@ -42,8 +42,57 @@ define Package/pgsql-cli
   URL:=http://www.postgresql.org/
 endef
 
-#	./configure advertise "--infodir", but does not support it, replaced with "--docdir"
+define Package/pgsql-server
+  SECTION:=utils
+  CATEGORY:=Utilities
+  DEPENDS:=+libpq @C99_MATH
+  TITLE:=PostgreSQL databases Server
+  DESCRIPTION:=PostgreSQL databases Server.
+  URL:=http://www.postgresql.org/
+endef
+
+# Need a native ecpg and zic for build
 define Build/Configure
+	(cd $(PKG_BUILD_DIR); rm -f config.cache; \
+		./configure \
+			--prefix=/usr \
+			--exec-prefix=/usr \
+			--bindir=/usr/bin \
+			--datadir=/usr/share \
+			--includedir=/usr/include \
+			--infodir=/usr/share/info \
+			--libdir=/usr/lib \
+			--libexecdir=/usr/lib \
+			--localstatedir=/var \
+			--mandir=/usr/share/man \
+			--sbindir=/usr/sbin \
+			--sysconfdir=/etc \
+			$(DISABLE_NLS) \
+			$(DISABLE_LARGEFILE) \
+			--enable-shared \
+			--enable-static \
+			--disable-integer-datetimes \
+			--disable-rpath \
+			--without-java \
+			--without-krb4 \
+			--without-krb5 \
+			--without-openssl \
+			--without-pam \
+			--without-perl \
+			--without-python \
+			--without-readline \
+			--without-rendezvous \
+			--without-tcl \
+			--without-tk \
+			--with-zlib="yes" \
+	);
+	$(MAKE) -C $(PKG_BUILD_DIR)/src/interfaces/ecpg/preproc CC="gcc" CFLAGS+="-I../../libpq"
+	mv $(PKG_BUILD_DIR)/src/interfaces/ecpg/preproc/ecpg \
+		$(PKG_BUILD_DIR)/src/interfaces/ecpg/preproc/ecpg.host
+	$(MAKE) -C $(PKG_BUILD_DIR)/src/timezone CC="gcc"
+	mv $(PKG_BUILD_DIR)/src/timezone/zic $(PKG_BUILD_DIR)/src/timezone/zic.host
+	$(MAKE) -C $(PKG_BUILD_DIR) distclean
+
 	(cd $(PKG_BUILD_DIR); rm -f config.cache; \
 		$(TARGET_CONFIGURE_OPTS) \
 		CFLAGS="$(TARGET_CFLAGS)" \
@@ -60,7 +109,7 @@ define Build/Configure
 			--bindir=/usr/bin \
 			--datadir=/usr/share \
 			--includedir=/usr/include \
-			--docdir=/usr/share/info \
+			--infodir=/usr/share/info \
 			--libdir=/usr/lib \
 			--libexecdir=/usr/lib \
 			--localstatedir=/var \
@@ -86,21 +135,12 @@ define Build/Configure
 			--without-tk \
 			--with-zlib="yes" \
 	);
+	$(SED) 's@ECPG = ../../preproc/ecpg@ECPG = ../../preproc/ecpg.host@' $(PKG_BUILD_DIR)/src/interfaces/ecpg/test/Makefile.regress
+	$(SED) 's@\./zic -d@./zic.host -d@' $(PKG_BUILD_DIR)/src/timezone/Makefile
 endef
 
 define Build/Compile
-	$(MAKE) -C "$(PKG_BUILD_DIR)/src/include" \
-		DESTDIR="$(PKG_INSTALL_DIR)" \
-		all install
-	$(MAKE) -C "$(PKG_BUILD_DIR)/src/interfaces/libpq" \
-		DESTDIR="$(PKG_INSTALL_DIR)" \
-		all install
-	$(MAKE) -C "$(PKG_BUILD_DIR)/src/bin/pg_config" \
-		DESTDIR="$(PKG_INSTALL_DIR)" \
-		includedir="$(STAGING_DIR)/usr/include" \
-		libdir="$(STAGING_DIR)/usr/lib" \
-		all install
-	$(MAKE) -C "$(PKG_BUILD_DIR)/src/bin/psql" \
+	$(MAKE) -C "$(PKG_BUILD_DIR)" \
 		DESTDIR="$(PKG_INSTALL_DIR)" \
 		all install
 endef
@@ -115,6 +155,83 @@ define Package/pgsql-cli/install
 	$(CP) $(PKG_INSTALL_DIR)/usr/bin/psql $(1)/usr/bin/
 endef
 
+define Package/pgsql-server/install
+	$(INSTALL_DIR) $(1)/usr/bin
+	$(INSTALL_DIR) $(1)/usr/share/postgresql
+	$(INSTALL_DIR) $(1)/usr/lib
+	$(INSTALL_DIR) $(1)/etc/init.d
+	$(INSTALL_DIR) $(1)/etc/config
+	$(INSTALL_BIN) \
+		$(PKG_INSTALL_DIR)/usr/bin/postgres \
+		$(PKG_INSTALL_DIR)/usr/bin/dropdb \
+		$(PKG_INSTALL_DIR)/usr/bin/createdb \
+		$(PKG_INSTALL_DIR)/usr/bin/createuser \
+		$(PKG_INSTALL_DIR)/usr/bin/dropuser \
+		$(PKG_INSTALL_DIR)/usr/bin/initdb \
+		$(PKG_INSTALL_DIR)/usr/bin/pg_config \
+		$(PKG_INSTALL_DIR)/usr/bin/pg_controldata \
+		$(PKG_INSTALL_DIR)/usr/bin/pg_ctl \
+		$(PKG_INSTALL_DIR)/usr/bin/pg_dump \
+		$(PKG_INSTALL_DIR)/usr/bin/pg_dumpall \
+		$(PKG_INSTALL_DIR)/usr/bin/pg_restore \
+		$(PKG_INSTALL_DIR)/usr/bin/vacuumdb \
+		$(1)/usr/bin
+
+	$(INSTALL_BIN) ./files/postgresql.init $(1)/etc/init.d/postgresql
+
+	$(INSTALL_DATA) \
+		$(PKG_INSTALL_DIR)/usr/share/postgresql/postgres.bki \
+		$(PKG_INSTALL_DIR)/usr/share/postgresql/postgres.description \
+		$(PKG_INSTALL_DIR)/usr/share/postgresql/conversion_create.sql \
+		$(PKG_INSTALL_DIR)/usr/share/postgresql/information_schema.sql \
+		$(PKG_INSTALL_DIR)/usr/share/postgresql/pg_hba.conf.sample \
+		$(PKG_INSTALL_DIR)/usr/share/postgresql/pg_ident.conf.sample \
+		$(PKG_INSTALL_DIR)/usr/share/postgresql/pg_service.conf.sample \
+		$(PKG_INSTALL_DIR)/usr/share/postgresql/postgresql.conf.sample \
+		$(PKG_INSTALL_DIR)/usr/share/postgresql/sql_features.txt \
+		$(PKG_INSTALL_DIR)/usr/share/postgresql/postgres.shdescription \
+		$(PKG_INSTALL_DIR)/usr/share/postgresql/psqlrc.sample \
+		$(PKG_INSTALL_DIR)/usr/share/postgresql/recovery.conf.sample \
+		$(PKG_INSTALL_DIR)/usr/share/postgresql/system_views.sql \
+		$(1)/usr/share/postgresql
+
+		$(INSTALL_DATA) ./files/postgresql.config $(1)/etc/config/postgres
+
+		$(CP) -r \
+			$(PKG_INSTALL_DIR)/usr/share/postgresql/timezone \
+			$(PKG_INSTALL_DIR)/usr/share/postgresql/timezonesets \
+			$(1)/usr/share/postgresql
+
+		$(CP) -r \
+			$(PKG_INSTALL_DIR)/usr/lib/postgresql \
+			$(1)/usr/lib
+endef
+
+define Package/pgsql-server/postinst
+#!/bin/sh
+grep -q '^postgres:' /etc/passwd && exit 0
+
+if [ -e /bin/addgroup ]; then
+  /bin/addgroup postgres
+  RG=$$?
+
+  if [ -e /bin/adduser ]; then
+    /bin/adduser -h /tmp -H -g 'PostgreSQL administrator' -s /bin/ash -D -H -G postgres postgres
+	RU=$$?
+  fi
+fi
+
+if [ -z "$${RG}" -o -z "$${RU}" ]; then
+  echo "Could not find user utils, you will need to create the postgres user by hand"
+  exit 
+fi
+
+if [ "$${RG}" != "0" -o "$${RU}" != "0" ]; then
+  echo "Failed to created postgres user"
+  exit 1
+fi
+endef
+
 define Build/InstallDev
 	mkdir -p $(STAGING_DIR)/usr/bin
 	$(CP) $(PKG_INSTALL_DIR)/usr/bin/pg_config $(STAGING_DIR)/usr/bin/
@@ -126,6 +243,8 @@ define Build/InstallDev
 	$(CP) $(PKG_INSTALL_DIR)/usr/include/postgresql $(STAGING_DIR)/usr/include/
 	mkdir -p $(STAGING_DIR)/usr/lib
 	$(CP) $(PKG_INSTALL_DIR)/usr/lib/libpq.{a,so*} $(STAGING_DIR)/usr/lib/
+	$(CP) $(PKG_BUILD_DIR)/src/interfaces/ecpg/preproc/ecpg.host $(STAGING_DIR)/usr/bin/ecpg
+	$(CP) $(PKG_BUILD_DIR)/src/timezone/zic.host $(STAGING_DIR)/usr/bin/zic
 endef
 
 define Build/UninstallDev
@@ -136,8 +255,11 @@ define Build/UninstallDev
 		$(STAGING_DIR)/usr/include/pg_config.h \
 		$(STAGING_DIR)/usr/include/postgres_ext.h \
 		$(STAGING_DIR)/usr/include/postgresql \
-		$(STAGING_DIR)/usr/lib/libpq.{a,so*}
+		$(STAGING_DIR)/usr/lib/libpq.{a,so*} \
+		$(STAGING_DIR)/usr/bin/ecpg \
+		$(STAGING_DIR)/usr/bin/zic
 endef
 
 $(eval $(call BuildPackage,libpq))
 $(eval $(call BuildPackage,pgsql-cli))
+$(eval $(call BuildPackage,pgsql-server))
diff --git a/libs/postgresql/files/postgresql.conf b/libs/postgresql/files/postgresql.conf
new file mode 100644
index 000000000..df17c1279
--- /dev/null
+++ b/libs/postgresql/files/postgresql.conf
@@ -0,0 +1,5 @@
+config postgresql config
+	option PGUSER	postgres
+	option PGDATA	/var/postgresql/data
+	option PGLOG	/var/postgresql/data/postgresql.log
+	option PG_CTL	/usr/bin/pg_ctl
diff --git a/libs/postgresql/files/postgresql.init b/libs/postgresql/files/postgresql.init
new file mode 100755
index 000000000..5d318a390
--- /dev/null
+++ b/libs/postgresql/files/postgresql.init
@@ -0,0 +1,45 @@
+#!/bin/sh /etc/rc.common
+# Copyright (C) 2006 OpenWrt.org
+
+start() {
+    config_load "postgresql"
+    if [ ! -e /bin/su ]; then
+        echo "The su command is requred to run postgres"
+        exit 1
+    fi
+    config_get pgdata config PGDATA
+
+    if [ ! -d ${pgdata} ]; then
+        echo "Create the data directory (${pgdata}) and try again"
+        exit 1
+    fi
+
+    if [ -f ${pgdata}/postmaster.pid ]; then
+        rm ${pgdata}/postmaster.pid
+    fi
+
+    config_get pguser config PGUSER
+    config_get pglog config PGLOG
+    config_get pgctl config PG_CTL
+    config_get pgopts config PGOPTS
+
+    /bin/su - ${pguser} -c "${pgctl} start -D '${pgdata}' -s -l '${pglog}' -o '${pgopts}'"
+
+    while :
+    do
+        cnt=$((${cnt} + 1))
+        if [ -f "${pgdata}/postmaster.pid" ]; then
+            ret=0
+            break
+        fi
+
+        if [ ${cnt} -eq 30 ]; then
+            echo "Postgres failed to start.  See ${pglog} for details"
+            ret=1
+            break
+        fi
+        sleep 1
+    done
+
+    return ${ret}
+}
diff --git a/libs/postgresql/patches/200-ranlib.patch b/libs/postgresql/patches/200-ranlib.patch
index 7029b0995..098963c59 100644
--- a/libs/postgresql/patches/200-ranlib.patch
+++ b/libs/postgresql/patches/200-ranlib.patch
@@ -1,10 +1,10 @@
---- postgresql.old/src/port/Makefile	Sun Oct 15 00:09:57 2006
-+++ postgresql.dev/src/port/Makefile	Sun Oct 15 00:10:05 2006
-@@ -21,6 +21,7 @@
+--- postgresql-8.2.3/src/port/Makefile	2006-07-14 11:45:43.000000000 -0500
++++ new-postgresql-8.2.3/src/port/Makefile	2007-04-09 12:14:11.906032000 -0500
+@@ -43,6 +43,7 @@
  
  libpgport.a: $(LIBOBJS)
  	$(AR) $(AROPT) $@ $^
 +	$(RANLIB) libpgport.a
  
  thread.o: thread.c
- 	$(CC) $(CFLAGS) $(CPPFLAGS) $(THREAD_CPPFLAGS) -c $<
+ 	$(CC) $(CFLAGS) $(CPPFLAGS) $(PTHREAD_CFLAGS) -c $<
diff --git a/libs/postgresql/patches/750-configure-honor-cppflags.patch b/libs/postgresql/patches/750-configure-honor-cppflags.patch
index 897c6c05a..aea7f09d3 100644
--- a/libs/postgresql/patches/750-configure-honor-cppflags.patch
+++ b/libs/postgresql/patches/750-configure-honor-cppflags.patch
@@ -1,10 +1,8 @@
-diff -ruN postgresql-7.4.6-old/src/template/linux postgresql-7.4.6-new/src/template/linux
---- postgresql-7.4.6-old/src/template/linux	2003-10-09 18:52:45.000000000 +0200
-+++ postgresql-7.4.6-new/src/template/linux	2005-04-13 03:12:49.000000000 +0200
-@@ -1,5 +1,5 @@
+--- postgresql-8.2.3/src/template/linux	2006-03-10 22:38:41.000000000 -0600
++++ new-postgresql-8.2.3/src/template/linux	2007-04-09 12:15:36.223301500 -0500
+@@ -1,4 +1,4 @@
+ # $PostgreSQL: pgsql/src/template/linux,v 1.28 2006/03/11 04:38:41 momjian Exp $
+ 
  # Force _GNU_SOURCE on; plperl is broken with Perl 5.8.0 otherwise
 -CPPFLAGS="-D_GNU_SOURCE"
 +CPPFLAGS="$CPPFLAGS -D_GNU_SOURCE"
- 
- THREAD_SUPPORT=yes
- NEED_REENTRANT_FUNCS=yes	# Debian kernel 2.2 2003-09-27
diff --git a/libs/postgresql/patches/800-busybox-default-pager.patch b/libs/postgresql/patches/800-busybox-default-pager.patch
new file mode 100644
index 000000000..11cc8efe0
--- /dev/null
+++ b/libs/postgresql/patches/800-busybox-default-pager.patch
@@ -0,0 +1,13 @@
+--- postgresql-8.2.3/src/bin/psql/print.h.old	2007-04-09 16:49:24.297992000 -0500
++++ postgresql-8.2.3/src/bin/psql/print.h	2007-04-09 16:49:40.983034750 -0500
+@@ -88,10 +88,6 @@
+ 
+ void		setDecimalLocale(void);
+ 
+-#ifndef __CYGWIN__
+-#define DEFAULT_PAGER "more"
+-#else
+ #define DEFAULT_PAGER "less"
+-#endif
+ 
+ #endif   /* PRINT_H */
-- 
2.30.2