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