pkgsrc-Changes-HG archive
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]
[pkgsrc/trunk]: pkgsrc/databases PostgreSQL 8.3
details: https://anonhg.NetBSD.org/pkgsrc/rev/505e08c62ecc
branches: trunk
changeset: 539370:505e08c62ecc
user: adam <adam%pkgsrc.org@localhost>
date: Tue Mar 04 12:41:36 2008 +0000
description:
PostgreSQL 8.3
With significant new functionality and performance enhancements, this
release represents a major leap forward for PostgreSQL. This was made
possible by a growing community that has dramatically accelerated the
pace of development. This release adds the following major features:
* Full text search is integrated into the core database system
* Support for the SQL/XML standard, including new operators and an
XML data type
* Enumerated data types (ENUM)
* Arrays of composite types
* Universally Unique Identifier (UUID) data type
* Add control over whether NULLs sort first or last
* Updatable cursors
* Server configuration parameters can now be set on a per-function
basis
* User-defined types can now have type modifiers
* Automatically re-plan cached queries when table definitions change
or statistics are updated
* Numerous improvements in logging and statistics collection
* Support Security Service Provider Interface (SSPI) for
authentication on Windows
* Support multiple concurrent autovacuum processes, and other
autovacuum improvements
* Allow the whole PostgreSQL distribution to be compiled with
Microsoft Visual C++
diffstat:
databases/postgresql83-adminpack/DESCR | 4 +
databases/postgresql83-adminpack/Makefile | 20 +
databases/postgresql83-adminpack/PLIST | 4 +
databases/postgresql83-client/DESCR | 9 +
databases/postgresql83-client/Makefile | 87 +
databases/postgresql83-client/PLIST | 1761 ++++++++++++++++++++++++
databases/postgresql83-client/buildlink3.mk | 35 +
databases/postgresql83-plperl/DESCR | 5 +
databases/postgresql83-plperl/MESSAGE | 7 +
databases/postgresql83-plperl/Makefile | 24 +
databases/postgresql83-plperl/PLIST | 2 +
databases/postgresql83-plpython/DESCR | 9 +
databases/postgresql83-plpython/MESSAGE | 17 +
databases/postgresql83-plpython/Makefile | 21 +
databases/postgresql83-plpython/PLIST | 2 +
databases/postgresql83-pltcl/DESCR | 4 +
databases/postgresql83-pltcl/MESSAGE | 7 +
databases/postgresql83-pltcl/Makefile | 23 +
databases/postgresql83-pltcl/PLIST | 6 +
databases/postgresql83-server/DEINSTALL | 20 +
databases/postgresql83-server/DESCR | 9 +
databases/postgresql83-server/MESSAGE | 19 +
databases/postgresql83-server/Makefile | 97 +
databases/postgresql83-server/PLIST | 683 +++++++++
databases/postgresql83-server/files/pgsql.sh | 144 +
databases/postgresql83-server/xx | 1477 ++++++++++++++++++++
databases/postgresql83/DESCR | 9 +
databases/postgresql83/Makefile | 20 +
databases/postgresql83/Makefile.common | 175 ++
databases/postgresql83/Makefile.mirrors | 101 +
databases/postgresql83/PLIST | 2 +
databases/postgresql83/distinfo | 16 +
databases/postgresql83/files/GNUmakefile.libpq | 20 +
databases/postgresql83/files/Makefile.custom | 42 +
databases/postgresql83/files/Makefile.libtool | 124 +
databases/postgresql83/files/dynloader-ltdl.h | 17 +
databases/postgresql83/options.mk | 13 +
databases/postgresql83/patches/patch-aa | 14 +
databases/postgresql83/patches/patch-ab | 63 +
databases/postgresql83/patches/patch-ac | 15 +
databases/postgresql83/patches/patch-ad | 79 +
databases/postgresql83/patches/patch-ae | 45 +
databases/postgresql83/patches/patch-af | 28 +
databases/postgresql83/patches/patch-ag | 15 +
databases/postgresql83/patches/patch-ah | 13 +
databases/postgresql83/patches/patch-ai | 78 +
databases/postgresql83/patches/patch-aj | 18 +
databases/postgresql83/patches/patch-an | 13 +
48 files changed, 5416 insertions(+), 0 deletions(-)
diffs (truncated from 5608 to 300 lines):
diff -r 505b7e34f748 -r 505e08c62ecc databases/postgresql83-adminpack/DESCR
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql83-adminpack/DESCR Tue Mar 04 12:41:36 2008 +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 505b7e34f748 -r 505e08c62ecc databases/postgresql83-adminpack/Makefile
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql83-adminpack/Makefile Tue Mar 04 12:41:36 2008 +0000
@@ -0,0 +1,20 @@
+# $NetBSD: Makefile,v 1.1.1.1 2008/03/04 12:42:13 adam Exp $
+
+PKGNAME= postgresql83-adminpack-${BASE_VERS}
+COMMENT= Admin pack module for pgAdmin management
+
+DEPENDS+= postgresql83-server>=${BASE_VERS}:../../databases/postgresql83-server
+
+.include "../../databases/postgresql83/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/postgresql83-client/buildlink3.mk"
+
+.include "../../mk/bsd.pkg.mk"
diff -r 505b7e34f748 -r 505e08c62ecc databases/postgresql83-adminpack/PLIST
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql83-adminpack/PLIST Tue Mar 04 12:41:36 2008 +0000
@@ -0,0 +1,4 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2008/03/04 12:42:13 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 505b7e34f748 -r 505e08c62ecc databases/postgresql83-client/DESCR
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql83-client/DESCR Tue Mar 04 12:41:36 2008 +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 505b7e34f748 -r 505e08c62ecc databases/postgresql83-client/Makefile
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql83-client/Makefile Tue Mar 04 12:41:36 2008 +0000
@@ -0,0 +1,87 @@
+# $NetBSD: Makefile,v 1.1.1.1 2008/03/04 12:42:53 adam Exp $
+
+PKGNAME= postgresql83-client-${BASE_VERS}
+COMMENT= PostgreSQL database client programs
+
+PKG_DESTDIR_SUPPORT= user-destdir
+
+.include "../../databases/postgresql83/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" || ${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
+
+INSTALL_DIRS= src/include
+INSTALL_DIRS+= src/interfaces
+INSTALL_DIRS+= src/bin
+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.postgresql83-client
+.include "../../databases/postgresql83/options.mk"
+
+.for _file_ in pg_service.conf psqlrc
+CONF_FILES+= ${PG_DATA_DIR}/${_file_}.sample ${PG_ETC_DIR}/${_file_}
+.endfor
+.if !empty(PG_SUBPREFIX)
+PLIST_SUBST+= PG_DIRRM_SUBPREFIX="@dirrm ${PG_SUBPREFIX}"
+.else
+PLIST_SUBST+= PG_DIRRM_SUBPREFIX="@comment empty line"
+.endif
+
+# 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
+
+pre-build:
+ ${_PKG_SILENT}${_PKG_DEBUG}${_ULIMIT_CMD} \
+ cd ${WRKSRC}/src/backend && \
+ env ${MAKE_ENV} ${MAKE_PROGRAM} ${BUILD_MAKE_FLAGS} \
+ ../../src/include/parser/parse.h \
+ ../../src/include/utils/fmgroids.h
+
+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
+ cp -R ${WRKSRC}/doc/TODO.detail ${DESTDIR}${PG_DOC_DIR}
+ chown -R ${DOCOWN}:${DOCGRP} ${DESTDIR}${PG_DOC_DIR}/TODO.detail
+
+.include "../../mk/bsd.pkg.mk"
diff -r 505b7e34f748 -r 505e08c62ecc databases/postgresql83-client/PLIST
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql83-client/PLIST Tue Mar 04 12:41:36 2008 +0000
@@ -0,0 +1,1761 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2008/03/04 12:42:56 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/ipcclean
+${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-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/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/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/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_autovacuum.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_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_index.h
+${PG_SUBPREFIX}include/postgresql/server/catalog/pg_inherits.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_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/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
+${PG_SUBPREFIX}include/postgresql/server/commands/trigger.h
Home |
Main Index |
Thread Index |
Old Index