Initial import of PostgreSQL 7.4.2

meta-package

PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS),
derived from the Berkeley Postgres database management system.  While
PostgreSQL retains the powerful object-relational data model, rich data types
and easy extensibility of Postgres, it replaces the PostQuel query language
with an extended subset of SQL.

PostgreSQL is free and the complete source is available.

This is the meta-package for the PostgreSQL database system.

9 files changed, 225 insertions, 0 deletions

diff --git a/databases/postgresql74/DESCR b/databases/postgresql74/DESCR
new file mode 100644
index 00000000000..9f6b5b5b0f9
--- /dev/null
+++ b/databases/postgresql74/DESCR
@@ -0,0 +1,9 @@
+PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS),
+derived from the Berkeley Postgres database management system.  While
+PostgreSQL retains the powerful object-relational data model, rich data types
+and easy extensibility of Postgres, it replaces the PostQuel query language
+with an extended subset of SQL.
+
+PostgreSQL is free and the complete source is available.
+
+This is the meta-package for the PostgreSQL database system.
diff --git a/databases/postgresql74/Makefile b/databases/postgresql74/Makefile
new file mode 100644
index 00000000000..f47f0570a17
--- /dev/null
+++ b/databases/postgresql74/Makefile
@@ -0,0 +1,20 @@
+# $NetBSD: Makefile,v 1.1.1.1 2004/04/19 00:07:12 recht Exp $
+
+PKGNAME=	postgresql-${BASE_VERS}
+COMMENT=	Robust, next generation, object-relational DBMS
+
+DEPENDS+=	postgresql-client>=${BASE_VERS}:../../databases/postgresql74-client
+DEPENDS+=	postgresql-server>=${BASE_VERS}:../../databases/postgresql74-server
+DEPENDS+=	postgresql-docs>=${BASE_VERS}:../../databases/postgresql74-docs
+
+.include "Makefile.common"
+
+EXTRACT_ONLY=	# empty
+NO_CHECKSUM=	YES
+NO_CONFIGURE=	YES
+NO_BUILD=	YES
+
+do-install:	# empty
+do-patch:	# empty
+
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql74/Makefile.common b/databases/postgresql74/Makefile.common
new file mode 100644
index 00000000000..984a8db9393
--- /dev/null
+++ b/databases/postgresql74/Makefile.common
@@ -0,0 +1,101 @@
+# $NetBSD: Makefile.common,v 1.1.1.1 2004/04/19 00:07:13 recht Exp $
+#
+# This Makefile fragment is included by all PostgreSQL packages built from
+# the main sources of the PostgreSQL distribution except jdbc-postgresql.
+#
+# The PostgreSQL package naming scheme, aside from the obvious piecewise
+# packages, is as follows:
+#
+#	<lang>-postgresql	client-side interface to PostgreSQL
+#	postgresql-<lang>	server-side module for PostgreSQL backend
+
+DISTNAME?=		postgresql-${DIST_VERS}
+CATEGORIES+=		databases
+MASTER_SITES?=		http://www.postgresql.org/ftpsite/source/v${DIST_VERS}/ \
+			ftp://ftp.postgresql.org/pub/source/v${DIST_VERS}/ \
+			ftp://ftp.de.postgresql.org/mirror/postgresql/source/v${DIST_VERS}/ \
+			ftp://gd.tuwien.ac.at/db/www.postgresql.org/pub/source/v${DIST_VERS}/ \
+			ftp://ftp.sunsite.auc.dk/mirrors/postgresql/source/v${DIST_VERS}/ \
+			ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/source/v${DIST_VERS}/
+EXTRACT_SUFX=		.tar.bz2
+
+MAINTAINER?=		recht@NetBSD.org
+HOMEPAGE?=		http://www.postgresql.org/
+
+CONFLICTS+=		postgresql-[0-6]* postgresql-7.0*
+
+DISTINFO_FILE?=		${.CURDIR}/../postgresql74/distinfo
+COMMON_FILESDIR?=	${.CURDIR}/../postgresql74/files
+PATCHDIR?=		${.CURDIR}/../postgresql74/patches
+
+# Version numbering scheme:
+#
+# DIST_VERS		version number on the postgresql distfile
+# BASE_VERS		pkgsrc-mangled version number (convert pl -> .)
+#
+# Note: Do not forget jdbc-postgresql when updating version
+DIST_VERS?=		7.4.2
+BASE_VERS?=		${DIST_VERS}
+
+BUILDLINK_DEPENDS.postgresql-lib?=	postgresql-lib>=${BASE_VERS}
+BUILDLINK_DEPENDS.tcl-postgresql?=	tcl-postgresql>=${BASE_VERS}
+
+USE_BUILDLINK3=		yes
+GNU_CONFIGURE=		yes
+BUILD_USES_MSGFMT=	yes
+USE_PKGLOCALEDIR=	yes
+USE_GNU_TOOLS+=		make yacc
+PKG_SYSCONFSUBDIR=	postgresql
+
+.include "../../mk/bsd.prefs.mk"
+
+# Add support for hierarchical queries with Oracle like CONNECT BY syntax.
+# see http://gppl.terminal.ru/README.html for details.
+.if defined(PGSQL_USE_HIER) && !empty(PGSQL_USE_HIER:M[yY][eE][sS])
+PATCH_SITES=		http://gppl.terminal.ru/
+PATCHFILES=		hier-Pg7.4-0.5.2.tar.gz
+PATCH_DIST_STRIP=	-p1
+.endif
+BUILD_DEFS+=	PGSQL_USE_HIER
+
+PGSQL_TEMPLATE.SunOS=		solaris
+.if !defined(PGSQL_TEMPLATE.${OPSYS})
+PGSQL_TEMPLATE.${OPSYS}=	${LOWER_OPSYS}
+.endif
+
+CONFIGURE_ARGS+=	--with-template="${PGSQL_TEMPLATE.${OPSYS}}"
+CONFIGURE_ARGS+=	--without-readline
+CONFIGURE_ARGS+=	--with-zlib
+CONFIGURE_ARGS+=	--enable-nls
+
+CONFIGURE_ARGS+=	--sysconfdir=${PKG_SYSCONFDIR}
+CONFIGURE_ARGS+=	--with-htmldir=${PREFIX}/share/doc/html/postgresql
+
+CONFIGURE_ARGS+=	--without-java
+CONFIGURE_ARGS+=	--without-perl
+CONFIGURE_ARGS+=	--without-python
+CONFIGURE_ARGS+=	--without-tcl
+CONFIGURE_ARGS+=	--without-tk
+
+# Postgresql explicitly forbids any use of -ffast-math
+CFLAGS:=		${CFLAGS:S/-ffast-math//}
+
+post-extract:
+	if [ -d ${WRKSRC}/src ]; then					\
+		${RM} -f ${WRKSRC}/src/Makefile.custom;			\
+		${CP} -f ${COMMON_FILESDIR}/Makefile.custom		\
+			${WRKSRC}/src/Makefile.custom;			\
+	fi
+	if [ -d ${WRKSRC}/src/interfaces/libpq ]; then			\
+		${RM} -f ${WRKSRC}/src/interfaces/libpq/GNUmakefile;	\
+		${CP} -f ${COMMON_FILESDIR}/GNUmakefile.libpq		\
+			${WRKSRC}/src/interfaces/libpq/GNUmakefile;	\
+	fi
+	if [ -d ${WRKSRC}/src/interfaces/libpgtcl ]; then		\
+		${RM} -f ${WRKSRC}/src/interfaces/libpgtcl/GNUmakefile;	\
+		${CP} -f ${COMMON_FILESDIR}/GNUmakefile.libpgtcl	\
+			${WRKSRC}/src/interfaces/libpgtcl/GNUmakefile;	\
+	fi
+
+.include "../../devel/gettext-lib/buildlink3.mk"
+.include "../../devel/zlib/buildlink3.mk"
diff --git a/databases/postgresql74/PLIST b/databases/postgresql74/PLIST
new file mode 100644
index 00000000000..9602a97d957
--- /dev/null
+++ b/databases/postgresql74/PLIST
@@ -0,0 +1,2 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2004/04/19 00:07:13 recht Exp $
+@comment this plist intentionally left empty
diff --git a/databases/postgresql74/distinfo b/databases/postgresql74/distinfo
new file mode 100644
index 00000000000..b92860b9cdb
--- /dev/null
+++ b/databases/postgresql74/distinfo
@@ -0,0 +1,7 @@
+$NetBSD: distinfo,v 1.1.1.1 2004/04/19 00:07:13 recht Exp $
+
+SHA1 (postgresql-7.4.2.tar.bz2) = 52b8a8a3467298c659e424213b72a15b08be9d59
+Size (postgresql-7.4.2.tar.bz2) = 10100398 bytes
+SHA1 (hier-Pg7.4-0.5.2.tar.gz) = 8681cecbb0424a1c147b205a826816ea9146a261
+Size (hier-Pg7.4-0.5.2.tar.gz) = 34747 bytes
+SHA1 (patch-aa) = e9b99b04c02b3f04d21144a22489618948c378a8
diff --git a/databases/postgresql74/files/GNUmakefile.libpgtcl b/databases/postgresql74/files/GNUmakefile.libpgtcl
new file mode 100644
index 00000000000..e06ea358dda
--- /dev/null
+++ b/databases/postgresql74/files/GNUmakefile.libpgtcl
@@ -0,0 +1,20 @@
+# $NetBSD: GNUmakefile.libpgtcl,v 1.1.1.1 2004/04/19 00:07:13 recht Exp $
+#
+# This GNUmakefile overrides the `all' target of $(libpgtcl_srcdir)/Makefile
+# to be empty if INSTALLED_LIBPGTCL is defined.  This handles the submake
+# targets sprinkled throughout the PostgreSQL Makefiles that execute
+#
+#	@$(MAKE) -C $(libpgtcl_builddir) all
+#
+# to ensure that the libpgtcl libraries are built first.  If INSTALLED_LIBPGTCL
+# is defined, then have the `all' target simple return success.
+
+ifdef INSTALLED_LIBPGTCL
+all:
+	@test -f libpgtcl.a || touch libpgtcl.a
+endif
+
+%: force
+	@$(MAKE) -f Makefile $@
+
+force: ;
diff --git a/databases/postgresql74/files/GNUmakefile.libpq b/databases/postgresql74/files/GNUmakefile.libpq
new file mode 100644
index 00000000000..e9406c8995e
--- /dev/null
+++ b/databases/postgresql74/files/GNUmakefile.libpq
@@ -0,0 +1,20 @@
+# $NetBSD: GNUmakefile.libpq,v 1.1.1.1 2004/04/19 00:07:13 recht Exp $
+#
+# This GNUmakefile overrides the `all' target of $(libpq_srcdir)/Makefile
+# to be empty if INSTALLED_LIBPQ is defined.  This handles the submake
+# targets sprinkled throughout the PostgreSQL Makefiles that execute
+#
+#	@$(MAKE) -C $(libpq_builddir) all
+#
+# to ensure that the libpq libraries are built first.  If INSTALLED_LIBPQ
+# is defined, then have the `all' target simple return success.
+
+ifdef INSTALLED_LIBPQ
+all:
+	@test -f libpq.a || touch libpq.a
+endif
+
+%: force
+	@$(MAKE) -f Makefile $@
+
+force: ;
diff --git a/databases/postgresql74/files/Makefile.custom b/databases/postgresql74/files/Makefile.custom
new file mode 100644
index 00000000000..4748310aeb3
--- /dev/null
+++ b/databases/postgresql74/files/Makefile.custom
@@ -0,0 +1,15 @@
+# $NetBSD: Makefile.custom,v 1.1.1.1 2004/04/19 00:07:13 recht Exp $
+#
+# This file is included by Makefile.global, which is included by every
+# sub-Makefile in the build tree.  Makefiles for shared libraries include
+# Makefile.global then Makefile.shlib.
+
+pkglibdir = $(exec_prefix)/lib/postgresql
+
+ifdef INSTALLED_LIBPQ
+libpq = -lpq
+endif
+
+ifdef INSTALLED_LIBPGTCL
+libpgtcl = -lpgtcl
+endif
diff --git a/databases/postgresql74/patches/patch-aa b/databases/postgresql74/patches/patch-aa
new file mode 100644
index 00000000000..bba209f4b73
--- /dev/null
+++ b/databases/postgresql74/patches/patch-aa
@@ -0,0 +1,31 @@
+$NetBSD: patch-aa,v 1.1.1.1 2004/04/19 00:07:13 recht Exp $
+
+--- src/Makefile.shlib.orig	Sat Mar  6 05:59:18 2004
++++ src/Makefile.shlib
+@@ -108,7 +108,7 @@ endif
+ 
+ ifeq ($(PORTNAME), freebsd)
+   ifdef ELF_SYSTEM
+-    shlib		:= lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
++    shlib		:= lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
+     LINK.shared		= $(COMPILER) -shared -Wl,-x,-soname,$(soname)
+   else
+     shlib		:= lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
+@@ -126,7 +126,7 @@ ifeq ($(PORTNAME), netbsd)
+ endif
+ 
+ ifeq ($(PORTNAME), hpux)
+-  shlib			:= lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
++  shlib			:= lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
+   LINK.shared		= $(LD) +h $(soname) -b +b $(libdir)
+   ifeq ($(GCC), yes)
+     SHLIB_LINK		+= `$(CC) -print-libgcc-file-name`
+@@ -134,7 +134,7 @@ ifeq ($(PORTNAME), hpux)
+ endif
+ 
+ ifeq ($(PORTNAME), irix5)
+-  shlib			:= lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
++  shlib			:= lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
+   LINK.shared		= $(COMPILER) -shared -Wl,-set_version,sgi$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
+ endif
+