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.

3 files changed, 36 insertions, 0 deletions

diff --git a/databases/postgresql92-upgrade/DESCR b/databases/postgresql92-upgrade/DESCR
new file mode 100644
index 00000000000..18267e4ba9a
--- /dev/null
+++ b/databases/postgresql92-upgrade/DESCR
@@ -0,0 +1,14 @@
+pg_upgrade (formerly called pg_migrator) allows data stored
+in PostgreSQL data files to be migrated to a later PostgreSQL
+major version without the data dump/reload typically required
+for major version upgrades, e.g. from 8.4.7 to the current
+major release of PostgreSQL. It is not required for minor
+version upgrades, e.g. from 9.0.1 to 9.0.4.
+
+pg_upgrade works because, though new features are regularly
+added to PostgreSQL major releases, the internal data storage
+format rarely changes. pg_upgrade does its best to make sure the
+old and new clusters are binary-compatible, e.g. by checking for
+compatible compile-time settings, including 32/64-bit binaries.
+It is important that any external modules are also binary
+compatible, though this cannot be checked by pg_upgrade.
diff --git a/databases/postgresql92-upgrade/Makefile b/databases/postgresql92-upgrade/Makefile
new file mode 100644
index 00000000000..7cc5529ab77
--- /dev/null
+++ b/databases/postgresql92-upgrade/Makefile
@@ -0,0 +1,19 @@
+# $NetBSD: Makefile,v 1.1 2012/10/05 21:03:12 adam Exp $
+
+PKGNAME=	${DISTNAME:C/-/92-upgrade-/}
+COMMENT=	PostgreSQL binary upgrade tool
+MAINTAINER=	pkgsrc-users@NetBSD.org
+
+DEPENDS+=	postgresql92-server>=${PKGVERSION_NOREV}:../../databases/postgresql92-server
+
+.include "../../databases/postgresql92/Makefile.common"
+
+BUILD_MAKE_FLAGS=	PGXS=1
+
+BUILD_DIRS+=		contrib/pg_upgrade
+BUILD_DIRS+=		contrib/pg_upgrade_support
+
+LIBS.SunOS+=	-lintl
+
+.include "../../databases/postgresql92-client/buildlink3.mk"
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql92-upgrade/PLIST b/databases/postgresql92-upgrade/PLIST
new file mode 100644
index 00000000000..f186b895d14
--- /dev/null
+++ b/databases/postgresql92-upgrade/PLIST
@@ -0,0 +1,3 @@
+@comment $NetBSD: PLIST,v 1.1 2012/10/05 21:03:12 adam Exp $
+bin/pg_upgrade
+lib/postgresql/pg_upgrade_support.so