summaryrefslogtreecommitdiff
path: root/databases/postgresql91-replicationtools
diff options
context:
space:
mode:
authoradam <adam@pkgsrc.org>2011-09-15 08:27:38 +0000
committeradam <adam@pkgsrc.org>2011-09-15 08:27:38 +0000
commitbfd12bfb1edc31693ca2b3ac46752e60f3f5f362 (patch)
treee4278cd9abc25bd225f1dd7ef33d4023332332b6 /databases/postgresql91-replicationtools
parentd162e8d1617159d190abd1e6ec4d1fdca0c6bdb2 (diff)
downloadpkgsrc-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-replicationtools')
-rw-r--r--databases/postgresql91-replicationtools/DESCR12
-rw-r--r--databases/postgresql91-replicationtools/Makefile14
-rw-r--r--databases/postgresql91-replicationtools/PLIST3
3 files changed, 29 insertions, 0 deletions
diff --git a/databases/postgresql91-replicationtools/DESCR b/databases/postgresql91-replicationtools/DESCR
new file mode 100644
index 00000000000..781934b4da0
--- /dev/null
+++ b/databases/postgresql91-replicationtools/DESCR
@@ -0,0 +1,12 @@
+This package provides the following PostgreSQL tools:
+ - pg_archivecleanup
+ - pg_standby
+
+pg_standby supports creation of a "warm standby" database server.
+It is designed to be a waiting restore_command, which is needed
+to turn a standard archive recovery into a warm standby operation.
+
+pg_archivecleanup is designed to cleanup an archive when used as
+an archive_cleanup_command when running with standby_mode = on.
+pg_archivecleanup can also be used as a standalone program to
+clean WAL file archives.
diff --git a/databases/postgresql91-replicationtools/Makefile b/databases/postgresql91-replicationtools/Makefile
new file mode 100644
index 00000000000..1e5c87bedd6
--- /dev/null
+++ b/databases/postgresql91-replicationtools/Makefile
@@ -0,0 +1,14 @@
+# $NetBSD: Makefile,v 1.1.1.1 2011/09/15 08:33:19 adam Exp $
+
+PKGNAME= ${DISTNAME:C/-/91-replicationtools-/}
+COMMENT= PostgreSQL replication tools
+
+PKG_DESTDIR_SUPPORT= user-destdir
+
+.include "../../databases/postgresql91/Makefile.common"
+
+BUILD_DIRS+= contrib/pg_archivecleanup
+BUILD_DIRS+= contrib/pg_standby
+
+.include "../../databases/postgresql91-client/buildlink3.mk"
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql91-replicationtools/PLIST b/databases/postgresql91-replicationtools/PLIST
new file mode 100644
index 00000000000..1936edec3dc
--- /dev/null
+++ b/databases/postgresql91-replicationtools/PLIST
@@ -0,0 +1,3 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2011/09/15 08:33:19 adam Exp $
+bin/pg_archivecleanup
+bin/pg_standby