pkgsrc-Changes-HG archive
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]
[pkgsrc/trunk]: pkgsrc/databases Many of the changes in PostgreSQL 8.4 are ne...
details: https://anonhg.NetBSD.org/pkgsrc/rev/6be2302df185
branches: trunk
changeset: 396621:6be2302df185
user: adam <adam%pkgsrc.org@localhost>
date: Wed Jul 29 06:26:17 2009 +0000
description:
Many of the changes in PostgreSQL 8.4 are new or improved administration and
monitoring tools and commands. Each user has their own favorite features which
will make day-to-day work with PostgreSQL easier and more productive for them.
Among the most popular enhancements are:
* Parallel Database Restore, speeding up recovery from backup up to 8 times
* Per-Column Permissions, allowing more granular control of sensitive data
* Per-database Collation Support, making PostgreSQL more useful in
multi-lingual environments
* In-place Upgrades through pg_migrator (beta), enabling upgrades from 8.3 to
8.4 without extensive downtime
* New Query Monitoring Tools, giving administrators more insight into query
activity
* Greatly Reduced VACUUM Overhead through the Visibility Map
* New Monitoring Tools for current queries, query load and deadlocks
Version 8.4 also makes data analysis easier through the advanced ANSI SQL2003
features of windowing functions, common table expressions and recursive queries.
Enhancements to stored procedures, such as default parameters and variadic
parameters, make database server programming simpler and more compact.
Of course, there are also performance improvements included in this version.
diffstat:
databases/postgresql84-adminpack/DESCR | 4 +
databases/postgresql84-adminpack/Makefile | 22 +
databases/postgresql84-adminpack/PLIST | 4 +
databases/postgresql84-client/DESCR | 9 +
databases/postgresql84-client/Makefile | 76 +
databases/postgresql84-client/PLIST | 1748 ++++++++++++++++++++++++
databases/postgresql84-client/buildlink3.mk | 28 +
databases/postgresql84-plperl/DESCR | 5 +
databases/postgresql84-plperl/MESSAGE | 7 +
databases/postgresql84-plperl/Makefile | 26 +
databases/postgresql84-plperl/PLIST | 8 +
databases/postgresql84-plpython/DESCR | 9 +
databases/postgresql84-plpython/MESSAGE | 17 +
databases/postgresql84-plpython/Makefile | 23 +
databases/postgresql84-plpython/PLIST | 8 +
databases/postgresql84-pltcl/DESCR | 4 +
databases/postgresql84-pltcl/MESSAGE | 7 +
databases/postgresql84-pltcl/Makefile | 25 +
databases/postgresql84-pltcl/PLIST | 12 +
databases/postgresql84-server/DEINSTALL | 20 +
databases/postgresql84-server/DESCR | 9 +
databases/postgresql84-server/MESSAGE | 18 +
databases/postgresql84-server/Makefile | 91 +
databases/postgresql84-server/PLIST | 654 ++++++++
databases/postgresql84-server/files/pgsql.sh | 148 ++
databases/postgresql84/DESCR | 9 +
databases/postgresql84/Makefile | 13 +
databases/postgresql84/Makefile.common | 171 ++
databases/postgresql84/Makefile.mirrors | 101 +
databases/postgresql84/PLIST | 2 +
databases/postgresql84/distinfo | 15 +
databases/postgresql84/files/GNUmakefile.libpq | 20 +
databases/postgresql84/files/Makefile.custom | 42 +
databases/postgresql84/files/Makefile.libtool | 141 +
databases/postgresql84/files/dynloader-ltdl.h | 17 +
databases/postgresql84/options.mk | 13 +
databases/postgresql84/patches/patch-aa | 15 +
databases/postgresql84/patches/patch-ab | 23 +
databases/postgresql84/patches/patch-ac | 15 +
databases/postgresql84/patches/patch-ad | 78 +
databases/postgresql84/patches/patch-ae | 45 +
databases/postgresql84/patches/patch-af | 31 +
databases/postgresql84/patches/patch-ag | 15 +
databases/postgresql84/patches/patch-ah | 13 +
databases/postgresql84/patches/patch-ai | 78 +
databases/postgresql84/patches/patch-an | 13 +
46 files changed, 3852 insertions(+), 0 deletions(-)
diffs (truncated from 4036 to 300 lines):
diff -r 7ef397f0e3f8 -r 6be2302df185 databases/postgresql84-adminpack/DESCR
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql84-adminpack/DESCR Wed Jul 29 06:26:17 2009 +0000
@@ -0,0 +1,4 @@
+The ``adminpack'' PostgreSQL contrib module implements a number of
+support functions which pgAdmin and other administration and management
+tools can use to provide additional functionality if installed on a
+server.
diff -r 7ef397f0e3f8 -r 6be2302df185 databases/postgresql84-adminpack/Makefile
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql84-adminpack/Makefile Wed Jul 29 06:26:17 2009 +0000
@@ -0,0 +1,22 @@
+# $NetBSD: Makefile,v 1.1.1.1 2009/07/29 06:29:33 adam Exp $
+
+PKGNAME= postgresql84-adminpack-${BASE_VERS}
+COMMENT= Admin pack module for pgAdmin management
+
+PKG_DESTDIR_SUPPORT= user-destdir
+
+DEPENDS+= postgresql84-server>=${BASE_VERS}:../../databases/postgresql84-server
+
+.include "../../databases/postgresql84/Makefile.common"
+
+BUILD_DIRS= contrib/adminpack
+
+USE_LIBTOOL= yes
+PKG_LIBTOOL= ${PKG_SHLIBTOOL}
+
+REQD_DIRS+= ${PG_SUBPREFIX}share/doc/postgresql/contrib
+REQD_DIRS+= ${PG_SUBPREFIX}share/postgresql/contrib
+
+.include "../../databases/postgresql84-client/buildlink3.mk"
+
+.include "../../mk/bsd.pkg.mk"
diff -r 7ef397f0e3f8 -r 6be2302df185 databases/postgresql84-adminpack/PLIST
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql84-adminpack/PLIST Wed Jul 29 06:26:17 2009 +0000
@@ -0,0 +1,4 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2009/07/29 06:29:33 adam Exp $
+${PG_SUBPREFIX}lib/postgresql/adminpack.la
+${PG_SUBPREFIX}share/postgresql/contrib/adminpack.sql
+${PG_SUBPREFIX}share/postgresql/contrib/uninstall_adminpack.sql
diff -r 7ef397f0e3f8 -r 6be2302df185 databases/postgresql84-client/DESCR
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql84-client/DESCR Wed Jul 29 06:26:17 2009 +0000
@@ -0,0 +1,9 @@
+PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS),
+derived from the Berkeley Postgres database management system. While
+PostgreSQL retains the powerful object-relational data model, rich data types
+and easy extensibility of Postgres, it replaces the PostQuel query language
+with an extended subset of SQL.
+
+PostgreSQL is free and the complete source is available.
+
+This package contains the database client programs.
diff -r 7ef397f0e3f8 -r 6be2302df185 databases/postgresql84-client/Makefile
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql84-client/Makefile Wed Jul 29 06:26:17 2009 +0000
@@ -0,0 +1,76 @@
+# $NetBSD: Makefile,v 1.1.1.1 2009/07/29 06:27:56 adam Exp $
+
+PKGNAME= postgresql84-client-${BASE_VERS}
+COMMENT= PostgreSQL database client programs
+
+PKG_DESTDIR_SUPPORT= user-destdir
+
+.include "../../databases/postgresql84/Makefile.common"
+
+USE_TOOLS+= gzip tar
+USE_LIBTOOL= yes
+CONFIGURE_ARGS+= --with-openssl
+CONFIGURE_ARGS+= --with-readline
+CONFIGURE_ARGS+= --with-zlib
+
+# 1. The thread-safety test in ${WRSRC}/src/tools/thread does not pass on
+# NetBSD earler than 4.0 or DragonFly.
+# 2. configure with --enable-thread-safety fails on OpenBSD.
+#
+.if (${OPSYS} == "NetBSD" && !empty(OS_VERSION:M[0-3].*)) || \
+ ${OPSYS} == "DragonFly" || ${OPSYS} == "OpenBSD"
+PGSQL_THREAD_SAFETY?= no
+.endif
+PGSQL_THREAD_SAFETY?= yes
+BUILD_DEFS+= PGSQL_THREAD_SAFETY
+
+.if !empty(PGSQL_THREAD_SAFETY:M[yY][eE][sS])
+. include "../../mk/pthread.buildlink3.mk"
+. if (${PTHREAD_TYPE} == "native")
+CONFIGURE_ARGS+= --enable-thread-safety
+. endif
+.endif
+
+LIBS.SunOS+= -lintl
+
+INSTALL_DIRS= src/include
+INSTALL_DIRS+= src/interfaces
+INSTALL_DIRS+= src/bin
+INSTALL_DIRS+= src/port
+INSTALL_DIRS+= doc
+
+BUILD_DIRS= ${INSTALL_DIRS}
+
+# Without this, the Darwin build fails (related to -bundle_loader).
+BUILD_DIRS+= src/backend
+
+PKG_OPTIONS_VAR= PKG_OPTIONS.postgresql84-client
+.include "../../databases/postgresql84/options.mk"
+
+.for _file_ in pg_service.conf psqlrc
+CONF_FILES+= ${PG_DATA_DIR}/${_file_}.sample ${PG_ETC_DIR}/${_file_}
+.endfor
+
+# XXX work around core dumps with the native libedit
+USE_GNU_READLINE= yes
+
+.include "../../devel/readline/buildlink3.mk"
+.include "../../devel/zlib/buildlink3.mk"
+.include "../../security/openssl/buildlink3.mk"
+
+# On Solaris, avoid conflicts between "${SSLBASE}/include/openssl/des.h"
+# and "/usr/include/crypt.h" -- we want the definitions in the former.
+.if ${OPSYS} == "SunOS"
+post-wrapper:
+ touch ${BUILDLINK_DIR}/include/crypt.h
+.endif
+
+post-install:
+ cd ${WRKSRC}/doc; for file in \
+ FAQ* KNOWN_BUGS MISSING_FEATURES README.* TODO \
+ bug.template; \
+ do \
+ ${INSTALL_DATA} $$file ${DESTDIR}${PG_DOC_DIR}/$$file; \
+ done
+
+.include "../../mk/bsd.pkg.mk"
diff -r 7ef397f0e3f8 -r 6be2302df185 databases/postgresql84-client/PLIST
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql84-client/PLIST Wed Jul 29 06:26:17 2009 +0000
@@ -0,0 +1,1748 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2009/07/29 06:27:58 adam Exp $
+${PG_SUBPREFIX}bin/clusterdb
+${PG_SUBPREFIX}bin/createdb
+${PG_SUBPREFIX}bin/createlang
+${PG_SUBPREFIX}bin/createuser
+${PG_SUBPREFIX}bin/dropdb
+${PG_SUBPREFIX}bin/droplang
+${PG_SUBPREFIX}bin/dropuser
+${PG_SUBPREFIX}bin/ecpg
+${PG_SUBPREFIX}bin/initdb
+${PG_SUBPREFIX}bin/pg_config
+${PG_SUBPREFIX}bin/pg_controldata
+${PG_SUBPREFIX}bin/pg_ctl
+${PG_SUBPREFIX}bin/pg_dump
+${PG_SUBPREFIX}bin/pg_dumpall
+${PG_SUBPREFIX}bin/pg_resetxlog
+${PG_SUBPREFIX}bin/pg_restore
+${PG_SUBPREFIX}bin/psql
+${PG_SUBPREFIX}bin/reindexdb
+${PG_SUBPREFIX}bin/vacuumdb
+${PG_SUBPREFIX}include/ecpg_config.h
+${PG_SUBPREFIX}include/ecpg_informix.h
+${PG_SUBPREFIX}include/ecpgerrno.h
+${PG_SUBPREFIX}include/ecpglib.h
+${PG_SUBPREFIX}include/ecpgtype.h
+${PG_SUBPREFIX}include/libpq-events.h
+${PG_SUBPREFIX}include/libpq-fe.h
+${PG_SUBPREFIX}include/libpq/libpq-fs.h
+${PG_SUBPREFIX}include/pg_config.h
+${PG_SUBPREFIX}include/pg_config_manual.h
+${PG_SUBPREFIX}include/pg_config_os.h
+${PG_SUBPREFIX}include/pgtypes_date.h
+${PG_SUBPREFIX}include/pgtypes_error.h
+${PG_SUBPREFIX}include/pgtypes_interval.h
+${PG_SUBPREFIX}include/pgtypes_numeric.h
+${PG_SUBPREFIX}include/pgtypes_timestamp.h
+${PG_SUBPREFIX}include/postgres_ext.h
+${PG_SUBPREFIX}include/postgresql/informix/esql/datetime.h
+${PG_SUBPREFIX}include/postgresql/informix/esql/decimal.h
+${PG_SUBPREFIX}include/postgresql/informix/esql/sqlda.h
+${PG_SUBPREFIX}include/postgresql/informix/esql/sqltypes.h
+${PG_SUBPREFIX}include/postgresql/internal/c.h
+${PG_SUBPREFIX}include/postgresql/internal/libpq-int.h
+${PG_SUBPREFIX}include/postgresql/internal/libpq/pqcomm.h
+${PG_SUBPREFIX}include/postgresql/internal/port.h
+${PG_SUBPREFIX}include/postgresql/internal/postgres_fe.h
+${PG_SUBPREFIX}include/postgresql/internal/pqexpbuffer.h
+${PG_SUBPREFIX}include/postgresql/server/access/attnum.h
+${PG_SUBPREFIX}include/postgresql/server/access/clog.h
+${PG_SUBPREFIX}include/postgresql/server/access/genam.h
+${PG_SUBPREFIX}include/postgresql/server/access/gin.h
+${PG_SUBPREFIX}include/postgresql/server/access/gist.h
+${PG_SUBPREFIX}include/postgresql/server/access/gist_private.h
+${PG_SUBPREFIX}include/postgresql/server/access/gistscan.h
+${PG_SUBPREFIX}include/postgresql/server/access/hash.h
+${PG_SUBPREFIX}include/postgresql/server/access/heapam.h
+${PG_SUBPREFIX}include/postgresql/server/access/hio.h
+${PG_SUBPREFIX}include/postgresql/server/access/htup.h
+${PG_SUBPREFIX}include/postgresql/server/access/itup.h
+${PG_SUBPREFIX}include/postgresql/server/access/multixact.h
+${PG_SUBPREFIX}include/postgresql/server/access/nbtree.h
+${PG_SUBPREFIX}include/postgresql/server/access/printtup.h
+${PG_SUBPREFIX}include/postgresql/server/access/reloptions.h
+${PG_SUBPREFIX}include/postgresql/server/access/relscan.h
+${PG_SUBPREFIX}include/postgresql/server/access/rewriteheap.h
+${PG_SUBPREFIX}include/postgresql/server/access/rmgr.h
+${PG_SUBPREFIX}include/postgresql/server/access/sdir.h
+${PG_SUBPREFIX}include/postgresql/server/access/skey.h
+${PG_SUBPREFIX}include/postgresql/server/access/slru.h
+${PG_SUBPREFIX}include/postgresql/server/access/subtrans.h
+${PG_SUBPREFIX}include/postgresql/server/access/sysattr.h
+${PG_SUBPREFIX}include/postgresql/server/access/transam.h
+${PG_SUBPREFIX}include/postgresql/server/access/tupdesc.h
+${PG_SUBPREFIX}include/postgresql/server/access/tupmacs.h
+${PG_SUBPREFIX}include/postgresql/server/access/tuptoaster.h
+${PG_SUBPREFIX}include/postgresql/server/access/twophase.h
+${PG_SUBPREFIX}include/postgresql/server/access/twophase_rmgr.h
+${PG_SUBPREFIX}include/postgresql/server/access/valid.h
+${PG_SUBPREFIX}include/postgresql/server/access/visibilitymap.h
+${PG_SUBPREFIX}include/postgresql/server/access/xact.h
+${PG_SUBPREFIX}include/postgresql/server/access/xlog.h
+${PG_SUBPREFIX}include/postgresql/server/access/xlog_internal.h
+${PG_SUBPREFIX}include/postgresql/server/access/xlogdefs.h
+${PG_SUBPREFIX}include/postgresql/server/access/xlogutils.h
+${PG_SUBPREFIX}include/postgresql/server/bootstrap/bootstrap.h
+${PG_SUBPREFIX}include/postgresql/server/c.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/catalog.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/catversion.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/dependency.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/genbki.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/heap.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/index.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/indexing.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/namespace.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_aggregate.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_am.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_amop.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_amproc.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_attrdef.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_attribute.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_auth_members.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_authid.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_cast.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_class.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_constraint.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_control.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_conversion.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_conversion_fn.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_database.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_depend.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_description.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_enum.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_foreign_data_wrapper.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_foreign_server.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_index.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_inherits.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_inherits_fn.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_language.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_largeobject.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_listener.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_namespace.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_opclass.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_operator.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_opfamily.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_pltemplate.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_proc.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_proc_fn.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_rewrite.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_shdepend.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_shdescription.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_statistic.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_tablespace.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_trigger.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_ts_config.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_ts_config_map.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_ts_dict.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_ts_parser.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_ts_template.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_type.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_type_fn.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_user_mapping.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/storage.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/toasting.h
+${PG_SUBPREFIX}include/postgresql/server/commands/alter.h
+${PG_SUBPREFIX}include/postgresql/server/commands/async.h
+${PG_SUBPREFIX}include/postgresql/server/commands/cluster.h
+${PG_SUBPREFIX}include/postgresql/server/commands/comment.h
+${PG_SUBPREFIX}include/postgresql/server/commands/conversioncmds.h
+${PG_SUBPREFIX}include/postgresql/server/commands/copy.h
+${PG_SUBPREFIX}include/postgresql/server/commands/dbcommands.h
+${PG_SUBPREFIX}include/postgresql/server/commands/defrem.h
+${PG_SUBPREFIX}include/postgresql/server/commands/discard.h
+${PG_SUBPREFIX}include/postgresql/server/commands/explain.h
+${PG_SUBPREFIX}include/postgresql/server/commands/lockcmds.h
+${PG_SUBPREFIX}include/postgresql/server/commands/portalcmds.h
+${PG_SUBPREFIX}include/postgresql/server/commands/prepare.h
+${PG_SUBPREFIX}include/postgresql/server/commands/proclang.h
+${PG_SUBPREFIX}include/postgresql/server/commands/schemacmds.h
+${PG_SUBPREFIX}include/postgresql/server/commands/sequence.h
+${PG_SUBPREFIX}include/postgresql/server/commands/tablecmds.h
+${PG_SUBPREFIX}include/postgresql/server/commands/tablespace.h
Home |
Main Index |
Thread Index |
Old Index