diff options
| author | adam <adam@pkgsrc.org> | 2011-09-15 08:27:38 +0000 |
|---|---|---|
| committer | adam <adam@pkgsrc.org> | 2011-09-15 08:27:38 +0000 |
| commit | bfd12bfb1edc31693ca2b3ac46752e60f3f5f362 (patch) | |
| tree | e4278cd9abc25bd225f1dd7ef33d4023332332b6 /databases/postgresql91-upgrade | |
| parent | d162e8d1617159d190abd1e6ec4d1fdca0c6bdb2 (diff) | |
| download | pkgsrc-bfd12bfb1edc31693ca2b3ac46752e60f3f5f362.tar.gz | |
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
Diffstat (limited to 'databases/postgresql91-upgrade')
| -rw-r--r-- | databases/postgresql91-upgrade/DESCR | 14 | ||||
| -rw-r--r-- | databases/postgresql91-upgrade/Makefile | 21 | ||||
| -rw-r--r-- | databases/postgresql91-upgrade/PLIST | 3 |
3 files changed, 38 insertions, 0 deletions
diff --git a/databases/postgresql91-upgrade/DESCR b/databases/postgresql91-upgrade/DESCR new file mode 100644 index 00000000000..18267e4ba9a --- /dev/null +++ b/databases/postgresql91-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/postgresql91-upgrade/Makefile b/databases/postgresql91-upgrade/Makefile new file mode 100644 index 00000000000..27dfd72f6b2 --- /dev/null +++ b/databases/postgresql91-upgrade/Makefile @@ -0,0 +1,21 @@ +# $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" diff --git a/databases/postgresql91-upgrade/PLIST b/databases/postgresql91-upgrade/PLIST new file mode 100644 index 00000000000..8bd3dcf5233 --- /dev/null +++ b/databases/postgresql91-upgrade/PLIST @@ -0,0 +1,3 @@ +@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 |