The PostgreSQL Global Development Group announces PostgreSQL 9.2, the latest release of the leader in open source databases. Since the beta release was announced in May, developers and vendors have praised it as a leap forward in performance, scalability and flexibility. Users are expected to switch to this version in record numbers.

PostgreSQL 9.2 will ship with native JSON support, covering indexes, replication and performance improvements, and many more features. We are eagerly awaiting this release and will make it available in Early Access as soon as it’s released by the PostgreSQL community," said Ines Sombra, Lead Data Engineer, Engine Yard.

1 files changed, 83 insertions, 0 deletions

diff --git a/databases/postgresql92-server/Makefile b/databases/postgresql92-server/Makefile
new file mode 100644
index 00000000000..71365f734b4
--- /dev/null
+++ b/databases/postgresql92-server/Makefile
@@ -0,0 +1,83 @@
+# $NetBSD: Makefile,v 1.1 2012/10/05 21:03:12 adam Exp $
+
+PKGNAME=	${DISTNAME:C/-/92-server-/}
+COMMENT=	PostgreSQL database server programs
+
+# mips has no TAS implementation
+NOT_FOR_PLATFORM=	*-*-mips
+
+.include "../../databases/postgresql92/Makefile.common"
+
+CONFIGURE_ARGS+=	--with-openssl
+
+INSTALL_DIRS=	src/backend
+INSTALL_DIRS+=	src/backend/replication/libpqwalreceiver
+INSTALL_DIRS+=	src/backend/utils/mb/conversion_procs
+INSTALL_DIRS+=	src/backend/snowball
+INSTALL_DIRS+=	src/timezone
+INSTALL_DIRS+=	src/pl
+BUILD_DIRS=	src/port
+BUILD_DIRS+=	${INSTALL_DIRS}
+
+LIBS.SunOS+=	-lintl
+
+# PostgreSQL has loadable server-side language modules.
+#
+# Explicitly set DLOPEN_REQUIRE_PTHREADS to "no" on NetBSD as NetBSD-2.x
+# had problems with mixing dlopen() and pthreads, which blows up in
+# PostgreSQL's backend (pkg/28729).  This works on older and newer
+# versions of NetBSD as well since they don't have the bad interaction
+# between dlopen() and pthreads.
+.if ${OPSYS} == "NetBSD"
+DLOPEN_REQUIRE_PTHREADS=	no
+.endif
+.include "../../mk/dlopen.buildlink3.mk"
+
+# If we're using libltdl to provide "dlopen" functionality, then add the
+# dependency and make sure that we link against -lltdl.
+.if !empty(USE_LIBLTDL:M[yY][eE][sS])
+DL_LIBS+=	-lltdl
+.  include "../../devel/libltdl/buildlink3.mk"
+.endif
+
+# PGUSER	username of the database administrator
+# PGGROUP	group of the database administrator
+# PGHOME	home directory of the database administrator and location of
+#		the databases
+PGUSER?=		pgsql
+PGGROUP?=		pgsql
+PGHOME?=		${PREFIX}/${PGUSER}
+FILES_SUBST+=		PGUSER=${PGUSER}
+FILES_SUBST+=		PGGROUP=${PGGROUP}
+FILES_SUBST+=		PGHOME=${PGHOME}
+BUILD_DEFS+=		PGHOME
+
+ALL_ENV+=		INSTALLED_LIBPQ=yes
+
+PKG_GROUPS_VARS+=	PGGROUP
+PKG_USERS_VARS+=	PGUSER
+
+PKG_GROUPS=		${PGGROUP}
+PKG_USERS=		${PGUSER}:${PGGROUP}
+PKG_GECOS.${PGUSER}=	PostgreSQL database administrator
+PKG_HOME.${PGUSER}=	${PGHOME}
+
+RCD_SCRIPTS=		pgsql
+
+.include "../../databases/postgresql92-client/buildlink3.mk"
+.include "../../security/openssl/buildlink3.mk"
+
+# Avoid conflict between "${SSLBASE}/include/openssl/des.h" and
+# "/usr/include/crypt.h" -- we want the definitions in the former.
+post-wrapper:
+.if ${OPSYS} == "SunOS"
+	touch ${BUILDLINK_DIR}/include/crypt.h
+.endif
+
+.include "../../mk/bsd.pkg.mk"
+
+# Because RCD_SCRIPTS_EXAMPLEDIR isn't configurable (yet?),
+# we override it here:
+.if !empty(PG_SUBPREFIX)
+RCD_SCRIPTS_EXAMPLEDIR:=	$(PG_SUBPREFIX:/=)/$(RCD_SCRIPTS_EXAMPLEDIR)
+.endif