Version 9.1 delivers several features which users have been requesting for
years, removing roadblocks to deploying new or ported applications on
PostgreSQL. These include:
* Synchronous Replication: enable high-availability with consistency across
  multiple servers
* Per-Column Collations: support linguistically-correct sorting per database,
  table or column.
* Unlogged Tables: greatly improves performance for ephemeral data

Our community of contributors innovates with cutting-edge features. Version 9.1
includes several which are new to the database industry, such as:
* K-Nearest-Neighbor Indexing: index on "distance" for faster location and text
  search queries
* Serializable Snapshot Isolation: keeps concurrent transactions consistent
  without blocking, using "true serializability"
* Writeable Common Table Expressions: execute complex multi-stage data updates
  in a single query
* Security-Enhanced Postgres: deploy military-grade security and Mandatory
  Access Control

Status:

Vendor Tag:	TNF
Release Tags:	pkgsrc-base


(adam)

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.

# $NetBSD: Makefile,v 1.1.1.1 2011/09/15 08:32:40 adam Exp $

PKGNAME=	${DISTNAME:C/-/91-upgrade-/}
COMMENT=	PostgreSQL binary upgrade tool
MAINTAINER=	pkgsrc-users@NetBSD.org

PKG_DESTDIR_SUPPORT=	user-destdir

DEPENDS+=	postgresql91-server>=${PKGVERSION_NOREV}:../../databases/postgresql91-server

.include "../../databases/postgresql91/Makefile.common"

BUILD_MAKE_FLAGS=	PGXS=1

BUILD_DIRS+=		contrib/pg_upgrade
BUILD_DIRS+=		contrib/pg_upgrade_support

LIBS.SunOS+=	-lintl

.include "../../databases/postgresql91-client/buildlink3.mk"
.include "../../mk/bsd.pkg.mk"

@comment $NetBSD: PLIST,v 1.1.1.1 2011/09/15 08:32:40 adam Exp $
bin/pg_upgrade
lib/postgresql/pg_upgrade_support.so