From 90a9130fb1dc6d91893bf6db57ae0d6cc49dc17d Mon Sep 17 00:00:00 2001 From: jlam Date: Thu, 4 Apr 2002 07:41:00 +0000 Subject: Update postgresql and related packages to 7.2. Thanks to Michael Graff for most of the work on this update. Pkgsrc changes from the previous version include removing Makefile.ssl and some patches that have been integrated into this release of PostgreSQL. We leave open the question of when to byte-compile the Python modules for the PyGreSQL interface and just do it as before, although we should consider doing the compilation as a post-install step to ensure that the timestamps are correct. We also reorder some lines in the Makefile to include Makefile.common below certain definitions (GNU_CONFIGURE, USE_BUILDLINK_ONLY) as they may possibly trigger different portions of Makefile.common. *** Please note that a dump/restore is required to migrate an existing *** *** PostgreSQL installation to 7.2. *** Major changes from version 7.1.3 are geared toward improving use in high-volume applications and include: VACUUM Vacuuming no longer locks tables, thus allowing normal user access during the vacuum. A new "VACUUM FULL" command does old-style vacuum by locking the table and shrinking the on-disk copy of the table. Transactions There is no longer a problem with installations that exceed four billion transactions. OID's OID's are now optional. Users can now create tables without OID's for cases where OID usage is excessive. Optimizer The system now computes histogram column statistics during "ANALYZE", allowing much better optimizer choices. Security A new MD5 encryption option allows more secure storage and transfer of passwords. A new Unix-domain socket authentication option is available on Linux and BSD systems. PAM authentication is also available. Statistics Administrators can use the new table access statistics module to get fine-grained information about table and index usage. --- databases/postgresql-docs/Makefile | 30 +++---- databases/postgresql-docs/PLIST | 162 +++++++++++++++++++++++++------------ 2 files changed, 125 insertions(+), 67 deletions(-) (limited to 'databases/postgresql-docs') diff --git a/databases/postgresql-docs/Makefile b/databases/postgresql-docs/Makefile index bd86434b15c..116bc578fe3 100644 --- a/databases/postgresql-docs/Makefile +++ b/databases/postgresql-docs/Makefile @@ -1,31 +1,33 @@ -# $NetBSD: Makefile,v 1.2 2001/12/03 08:06:26 jlam Exp $ +# $NetBSD: Makefile,v 1.3 2002/04/04 07:41:01 jlam Exp $ -.include "../../databases/postgresql/Makefile.common" - -PKGNAME= postgresql-docs-${PG_BASE_VERS} +PKGNAME= postgresql-docs-${BASE_VERS} COMMENT= PostgreSQL database system documentation -DOC_DIR= doc +USE_BUILDLINK_ONLY= YES + +.include "../../databases/postgresql/Makefile.common" + DOCDIR= ${PREFIX}/share/doc/postgresql # The manpage documentation is installed with the relevant packages. pre-build: - cd ${WRKSRC}/${DOC_DIR} && ${RM} -f man.tar.gz + cd ${WRKSRC}/doc && ${RM} -f man.tar.gz do-build: - cd ${WRKSRC}/${DOC_DIR} && \ - ${SETENV} ${MAKE_ENV} ${MAKE_PROGRAM} ${ALL_TARGET} + cd ${WRKSRC}/doc && ${SETENV} ${MAKE_ENV} \ + ${MAKE_PROGRAM} ${ALL_TARGET} do-install: - cd ${WRKSRC}/${DOC_DIR} && \ - ${SETENV} ${MAKE_ENV} ${MAKE_PROGRAM} ${INSTALL_TARGET} + cd ${WRKSRC}/doc && ${SETENV} ${MAKE_ENV} \ + ${MAKE_PROGRAM} ${INSTALL_TARGET} post-install: ${INSTALL_DATA_DIR} ${DOCDIR} - cd ${WRKSRC}/${DOC_DIR}; \ - ${INSTALL_DATA} \ + cd ${WRKSRC}/doc; for file in \ FAQ* KNOWN_BUGS MISSING_FEATURES README.* TODO \ - bug.template internals.ps \ - ${DOCDIR} + bug.template; \ + do \ + ${INSTALL_DATA} $${file} ${DOCDIR}/$${file}; \ + done .include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql-docs/PLIST b/databases/postgresql-docs/PLIST index 1af76ff69d9..089524727d0 100644 --- a/databases/postgresql-docs/PLIST +++ b/databases/postgresql-docs/PLIST @@ -1,7 +1,5 @@ -@comment $NetBSD: PLIST,v 1.1 2001/11/01 00:12:36 zuntum Exp $ +@comment $NetBSD: PLIST,v 1.2 2002/04/04 07:41:01 jlam Exp $ share/doc/html/postgresql/admin.html -share/doc/html/postgresql/advanced.html -share/doc/html/postgresql/altern-locations.html share/doc/html/postgresql/app-createdb.html share/doc/html/postgresql/app-createlang.html share/doc/html/postgresql/app-createuser.html @@ -16,7 +14,6 @@ share/doc/html/postgresql/app-pg-ctl.html share/doc/html/postgresql/app-pg-dumpall.html share/doc/html/postgresql/app-pg-passwd.html share/doc/html/postgresql/app-pgaccess.html -share/doc/html/postgresql/app-pgadmin.html share/doc/html/postgresql/app-pgconfig.html share/doc/html/postgresql/app-pgdump.html share/doc/html/postgresql/app-pgrestore.html @@ -28,7 +25,6 @@ share/doc/html/postgresql/app-psql.html share/doc/html/postgresql/app-vacuumdb.html share/doc/html/postgresql/applevel-consistency.html share/doc/html/postgresql/arch-pg.html -share/doc/html/postgresql/arch.html share/doc/html/postgresql/arrays.html share/doc/html/postgresql/auth-methods.html share/doc/html/postgresql/backup-file.html @@ -48,17 +44,21 @@ share/doc/html/postgresql/catalog-pg-group.html share/doc/html/postgresql/catalog-pg-index.html share/doc/html/postgresql/catalog-pg-inherits.html share/doc/html/postgresql/catalog-pg-language.html +share/doc/html/postgresql/catalog-pg-largeobject.html +share/doc/html/postgresql/catalog-pg-listener.html share/doc/html/postgresql/catalog-pg-operator.html share/doc/html/postgresql/catalog-pg-proc.html share/doc/html/postgresql/catalog-pg-relcheck.html +share/doc/html/postgresql/catalog-pg-rewrite.html share/doc/html/postgresql/catalog-pg-shadow.html +share/doc/html/postgresql/catalog-pg-statistic.html +share/doc/html/postgresql/catalog-pg-trigger.html share/doc/html/postgresql/catalog-pg-type.html share/doc/html/postgresql/catalogs.gif share/doc/html/postgresql/catalogs.html share/doc/html/postgresql/charset.html share/doc/html/postgresql/client-authentication-problems.html share/doc/html/postgresql/client-authentication.html -share/doc/html/postgresql/clientserver.gif share/doc/html/postgresql/compiler.html share/doc/html/postgresql/connect-estab.html share/doc/html/postgresql/connections.gif @@ -66,6 +66,7 @@ share/doc/html/postgresql/creating-cluster.html share/doc/html/postgresql/cvs-tree.html share/doc/html/postgresql/cvs.html share/doc/html/postgresql/cvsup.html +share/doc/html/postgresql/datatype-binary.html share/doc/html/postgresql/datatype-bit.html share/doc/html/postgresql/datatype-boolean.html share/doc/html/postgresql/datatype-character.html @@ -91,7 +92,10 @@ share/doc/html/postgresql/ecpg.html share/doc/html/postgresql/executor.html share/doc/html/postgresql/explicit-joins.html share/doc/html/postgresql/extend.html +share/doc/html/postgresql/failure-disk-failed.html +share/doc/html/postgresql/failure.html share/doc/html/postgresql/functions-aggregate.html +share/doc/html/postgresql/functions-binarystring.html share/doc/html/postgresql/functions-comparison.html share/doc/html/postgresql/functions-conditional.html share/doc/html/postgresql/functions-datetime.html @@ -101,8 +105,11 @@ share/doc/html/postgresql/functions-matching.html share/doc/html/postgresql/functions-math.html share/doc/html/postgresql/functions-misc.html share/doc/html/postgresql/functions-net.html +share/doc/html/postgresql/functions-sequence.html share/doc/html/postgresql/functions-string.html +share/doc/html/postgresql/functions-subquery.html share/doc/html/postgresql/functions.html +share/doc/html/postgresql/geqo-biblio.html share/doc/html/postgresql/geqo-intro2.html share/doc/html/postgresql/geqo-pg-intro.html share/doc/html/postgresql/geqo.html @@ -111,12 +118,14 @@ share/doc/html/postgresql/groups.html share/doc/html/postgresql/history.html share/doc/html/postgresql/index.html share/doc/html/postgresql/indexcost.html -share/doc/html/postgresql/indices-functional.html -share/doc/html/postgresql/indices-multicolumn.html -share/doc/html/postgresql/indices-opclass.html -share/doc/html/postgresql/indices-types.html -share/doc/html/postgresql/indices-unique.html -share/doc/html/postgresql/indices.html +share/doc/html/postgresql/indexes-examine.html +share/doc/html/postgresql/indexes-functional.html +share/doc/html/postgresql/indexes-multicolumn.html +share/doc/html/postgresql/indexes-opclass.html +share/doc/html/postgresql/indexes-partial.html +share/doc/html/postgresql/indexes-types.html +share/doc/html/postgresql/indexes-unique.html +share/doc/html/postgresql/indexes.html share/doc/html/postgresql/inherit.html share/doc/html/postgresql/install-getsource.html share/doc/html/postgresql/install-post.html @@ -125,8 +134,9 @@ share/doc/html/postgresql/install-requirements.html share/doc/html/postgresql/install-upgrading.html share/doc/html/postgresql/install-win32.html share/doc/html/postgresql/installation.html +share/doc/html/postgresql/jdbc-binary-data.html +share/doc/html/postgresql/jdbc-ddl.html share/doc/html/postgresql/jdbc-ext.html -share/doc/html/postgresql/jdbc-lo.html share/doc/html/postgresql/jdbc-query.html share/doc/html/postgresql/jdbc-reading.html share/doc/html/postgresql/jdbc-thread.html @@ -136,9 +146,11 @@ share/doc/html/postgresql/jdbc.html share/doc/html/postgresql/kernel-resources.html share/doc/html/postgresql/keys.html share/doc/html/postgresql/largeobjects.html -share/doc/html/postgresql/libpgtcl-examples.html +share/doc/html/postgresql/libpgtcl-loading.html share/doc/html/postgresql/libpgtcl-ref.html share/doc/html/postgresql/libpq-async.html +share/doc/html/postgresql/libpq-build.html +share/doc/html/postgresql/libpq-connect.html share/doc/html/postgresql/libpq-control.html share/doc/html/postgresql/libpq-copy.html share/doc/html/postgresql/libpq-envars.html @@ -154,46 +166,46 @@ share/doc/html/postgresql/libpqpp-classes.html share/doc/html/postgresql/libpqpp-connect.html share/doc/html/postgresql/libpqpp-copy.html share/doc/html/postgresql/libpqpp-exec.html +share/doc/html/postgresql/libpqpp-init.html share/doc/html/postgresql/libpqpp-notify.html -share/doc/html/postgresql/lisp.html -share/doc/html/postgresql/ln11330.html -share/doc/html/postgresql/ln1274.html -share/doc/html/postgresql/ln15181.html -share/doc/html/postgresql/ln24.html -share/doc/html/postgresql/ln25010.html -share/doc/html/postgresql/ln37176.html +share/doc/html/postgresql/ln13544.html +share/doc/html/postgresql/ln19341.html +share/doc/html/postgresql/ln25.html +share/doc/html/postgresql/ln31695.html +share/doc/html/postgresql/ln43726.html +share/doc/html/postgresql/ln650.html share/doc/html/postgresql/ln8.html share/doc/html/postgresql/lo-funcs.html share/doc/html/postgresql/lo-implementation.html share/doc/html/postgresql/lo-interfaces.html share/doc/html/postgresql/lo-libpq.html -share/doc/html/postgresql/lo-sample.html -share/doc/html/postgresql/locking-indices.html +share/doc/html/postgresql/locking-indexes.html share/doc/html/postgresql/locking-tables.html -share/doc/html/postgresql/manage-ag-accessdb.html +share/doc/html/postgresql/logfile-maintenance.html +share/doc/html/postgresql/maintenance.html share/doc/html/postgresql/manage-ag-dropdb.html share/doc/html/postgresql/manage.html share/doc/html/postgresql/managing-databases.html share/doc/html/postgresql/migration.html -share/doc/html/postgresql/more-advanced.html +share/doc/html/postgresql/monitoring-stats.html +share/doc/html/postgresql/monitoring.html share/doc/html/postgresql/multibyte.html share/doc/html/postgresql/mvcc.html -share/doc/html/postgresql/non-atomic-values.html +share/doc/html/postgresql/nls-programmer.html +share/doc/html/postgresql/nls.html share/doc/html/postgresql/notation.html share/doc/html/postgresql/odbc-applixware.html share/doc/html/postgresql/odbc-config.html share/doc/html/postgresql/odbc-install.html share/doc/html/postgresql/odbc-windows.html share/doc/html/postgresql/odbc.html -share/doc/html/postgresql/organization.html share/doc/html/postgresql/overview.html share/doc/html/postgresql/page.html share/doc/html/postgresql/parser-stage.html -share/doc/html/postgresql/partial-index.html share/doc/html/postgresql/performance-tips.html share/doc/html/postgresql/perm-functions.html share/doc/html/postgresql/pg-system-catalogs.html -share/doc/html/postgresql/pgeasy-chapter.html +share/doc/html/postgresql/pgeasy.html share/doc/html/postgresql/pgtcl-pgconndefaults.html share/doc/html/postgresql/pgtcl-pgconnect.html share/doc/html/postgresql/pgtcl-pgdisconnect.html @@ -213,17 +225,27 @@ share/doc/html/postgresql/pgtcl-pgresult.html share/doc/html/postgresql/pgtcl-pgselect.html share/doc/html/postgresql/pgtcl.html share/doc/html/postgresql/planner-optimizer.html -share/doc/html/postgresql/plperl-use.html +share/doc/html/postgresql/planner-stats.html +share/doc/html/postgresql/plperl-description.html +share/doc/html/postgresql/plperl-install.html share/doc/html/postgresql/plperl.html -share/doc/html/postgresql/plpgsql-description.html +share/doc/html/postgresql/plpgsql-control-structures.html +share/doc/html/postgresql/plpgsql-cursors.html +share/doc/html/postgresql/plpgsql-declarations.html +share/doc/html/postgresql/plpgsql-errors-and-messages.html share/doc/html/postgresql/plpgsql-examples.html +share/doc/html/postgresql/plpgsql-expressions.html share/doc/html/postgresql/plpgsql-porting.html +share/doc/html/postgresql/plpgsql-statements.html +share/doc/html/postgresql/plpgsql-structure.html share/doc/html/postgresql/plpgsql-trigger.html share/doc/html/postgresql/plpgsql.html +share/doc/html/postgresql/plpython-install.html +share/doc/html/postgresql/plpython-using.html +share/doc/html/postgresql/plpython.html share/doc/html/postgresql/pltcl-description.html share/doc/html/postgresql/pltcl.html share/doc/html/postgresql/populate.html -share/doc/html/postgresql/postgres.html share/doc/html/postgresql/postmaster-shutdown.html share/doc/html/postgresql/postmaster-start.html share/doc/html/postgresql/preface.html @@ -293,24 +315,18 @@ share/doc/html/postgresql/pygresql.html share/doc/html/postgresql/queries-limit.html share/doc/html/postgresql/queries-order.html share/doc/html/postgresql/queries-select-lists.html +share/doc/html/postgresql/queries-table-expressions.html share/doc/html/postgresql/queries-union.html share/doc/html/postgresql/queries.html -share/doc/html/postgresql/query-agg.html -share/doc/html/postgresql/query-concepts.html -share/doc/html/postgresql/query-delete.html -share/doc/html/postgresql/query-join.html -share/doc/html/postgresql/query-populate.html -share/doc/html/postgresql/query-query.html -share/doc/html/postgresql/query-selectinto.html -share/doc/html/postgresql/query-table.html -share/doc/html/postgresql/query-update.html -share/doc/html/postgresql/query.html +share/doc/html/postgresql/querytree.html share/doc/html/postgresql/recode.html -share/doc/html/postgresql/recovery.html share/doc/html/postgresql/reference-client.html +share/doc/html/postgresql/reference-preface.html share/doc/html/postgresql/reference-server.html share/doc/html/postgresql/reference.html +share/doc/html/postgresql/regress-evaluation.html share/doc/html/postgresql/regress-platform.html +share/doc/html/postgresql/regress-run.html share/doc/html/postgresql/regress.html share/doc/html/postgresql/release-0-01.html share/doc/html/postgresql/release-0-02.html @@ -338,13 +354,13 @@ share/doc/html/postgresql/release-7-0-1.html share/doc/html/postgresql/release-7-0-2.html share/doc/html/postgresql/release-7-0-3.html share/doc/html/postgresql/release-7-0.html -share/doc/html/postgresql/release-7-1.html share/doc/html/postgresql/release-7-1-1.html share/doc/html/postgresql/release-7-1-2.html +share/doc/html/postgresql/release-7-1-3.html +share/doc/html/postgresql/release-7-1.html share/doc/html/postgresql/release.html -share/doc/html/postgresql/relmodel-formal.html -share/doc/html/postgresql/relmodel-oper.html share/doc/html/postgresql/resources.html +share/doc/html/postgresql/routine-vacuuming.html share/doc/html/postgresql/rule-system.html share/doc/html/postgresql/rules-insert.html share/doc/html/postgresql/rules-permissions.html @@ -353,17 +369,28 @@ share/doc/html/postgresql/rules-views.html share/doc/html/postgresql/rules.html share/doc/html/postgresql/runtime-config.html share/doc/html/postgresql/runtime.html +share/doc/html/postgresql/setindex.html share/doc/html/postgresql/source.html share/doc/html/postgresql/spi-examples.html share/doc/html/postgresql/spi-interface-support.html share/doc/html/postgresql/spi-memory.html share/doc/html/postgresql/spi-spiconnect.html share/doc/html/postgresql/spi-spicopytuple.html +share/doc/html/postgresql/spi-spicopytupledesc.html +share/doc/html/postgresql/spi-spicopytupleintoslot.html +share/doc/html/postgresql/spi-spicursor-close.html +share/doc/html/postgresql/spi-spicursor-fetch.html +share/doc/html/postgresql/spi-spicursor-find.html +share/doc/html/postgresql/spi-spicursor-move.html +share/doc/html/postgresql/spi-spicursor-open.html share/doc/html/postgresql/spi-spiexec.html share/doc/html/postgresql/spi-spiexecp.html share/doc/html/postgresql/spi-spifinish.html share/doc/html/postgresql/spi-spifname.html share/doc/html/postgresql/spi-spifnumber.html +share/doc/html/postgresql/spi-spifreeplan.html +share/doc/html/postgresql/spi-spifreetuple.html +share/doc/html/postgresql/spi-spifreetuptable.html share/doc/html/postgresql/spi-spigetbinval.html share/doc/html/postgresql/spi-spigetrelname.html share/doc/html/postgresql/spi-spigettype.html @@ -381,6 +408,7 @@ share/doc/html/postgresql/sql-abort.html share/doc/html/postgresql/sql-altergroup.html share/doc/html/postgresql/sql-altertable.html share/doc/html/postgresql/sql-alteruser.html +share/doc/html/postgresql/sql-analyze.html share/doc/html/postgresql/sql-begin.html share/doc/html/postgresql/sql-checkpoint.html share/doc/html/postgresql/sql-close.html @@ -428,7 +456,6 @@ share/doc/html/postgresql/sql-fetch.html share/doc/html/postgresql/sql-grant.html share/doc/html/postgresql/sql-insert.html share/doc/html/postgresql/sql-keywords-appendix.html -share/doc/html/postgresql/sql-language.html share/doc/html/postgresql/sql-listen.html share/doc/html/postgresql/sql-load.html share/doc/html/postgresql/sql-lock.html @@ -442,6 +469,7 @@ share/doc/html/postgresql/sql-rollback.html share/doc/html/postgresql/sql-select.html share/doc/html/postgresql/sql-selectinto.html share/doc/html/postgresql/sql-set-constraints.html +share/doc/html/postgresql/sql-set-session-authorization.html share/doc/html/postgresql/sql-set-transaction.html share/doc/html/postgresql/sql-set.html share/doc/html/postgresql/sql-show.html @@ -451,24 +479,42 @@ share/doc/html/postgresql/sql-truncate.html share/doc/html/postgresql/sql-unlisten.html share/doc/html/postgresql/sql-update.html share/doc/html/postgresql/sql-vacuum.html -share/doc/html/postgresql/sql.html share/doc/html/postgresql/ssh-tunnels.html share/doc/html/postgresql/ssl-tcp.html -share/doc/html/postgresql/start-manage-db.html -share/doc/html/postgresql/start-psql.html -share/doc/html/postgresql/start.html share/doc/html/postgresql/storage.html +share/doc/html/postgresql/stylesheet.css share/doc/html/postgresql/supported-platforms.html -share/doc/html/postgresql/timing-results.html +share/doc/html/postgresql/timezones.html share/doc/html/postgresql/transaction-iso.html share/doc/html/postgresql/trigger-datachanges.html share/doc/html/postgresql/trigger-examples.html share/doc/html/postgresql/trigger-manager.html share/doc/html/postgresql/triggers.html +share/doc/html/postgresql/tutorial-accessdb.html +share/doc/html/postgresql/tutorial-advanced.html +share/doc/html/postgresql/tutorial-agg.html +share/doc/html/postgresql/tutorial-arch.html +share/doc/html/postgresql/tutorial-concepts.html +share/doc/html/postgresql/tutorial-conclusion.html +share/doc/html/postgresql/tutorial-createdb.html +share/doc/html/postgresql/tutorial-delete.html +share/doc/html/postgresql/tutorial-fk.html +share/doc/html/postgresql/tutorial-inheritance.html +share/doc/html/postgresql/tutorial-join.html +share/doc/html/postgresql/tutorial-populate.html +share/doc/html/postgresql/tutorial-select.html +share/doc/html/postgresql/tutorial-sql.html +share/doc/html/postgresql/tutorial-start.html +share/doc/html/postgresql/tutorial-table.html +share/doc/html/postgresql/tutorial-transactions.html +share/doc/html/postgresql/tutorial-update.html +share/doc/html/postgresql/tutorial-views.html +share/doc/html/postgresql/tutorial-welcome.html share/doc/html/postgresql/tutorial.html share/doc/html/postgresql/type-system.html share/doc/html/postgresql/typeconv-func.html share/doc/html/postgresql/typeconv-oper.html +share/doc/html/postgresql/typeconv-overview.html share/doc/html/postgresql/typeconv-query.html share/doc/html/postgresql/typeconv-union-case.html share/doc/html/postgresql/typeconv.html @@ -485,9 +531,19 @@ share/doc/html/postgresql/xfunc-c.html share/doc/html/postgresql/xfunc-internal.html share/doc/html/postgresql/xfunc-overload.html share/doc/html/postgresql/xfunc-pl.html +share/doc/html/postgresql/xfunc-plhandler.html +share/doc/html/postgresql/xfunc-sql.html share/doc/html/postgresql/xfunc.html +share/doc/html/postgresql/xindex-am.html +share/doc/html/postgresql/xindex-opclass.html +share/doc/html/postgresql/xindex-operators.html +share/doc/html/postgresql/xindex-strategies.html +share/doc/html/postgresql/xindex-support.html share/doc/html/postgresql/xindex.html +share/doc/html/postgresql/xoper-example.html +share/doc/html/postgresql/xoper-optimization.html share/doc/html/postgresql/xoper.html +share/doc/html/postgresql/xplang-install.html share/doc/html/postgresql/xplang.html share/doc/html/postgresql/xtypes.html share/doc/html/postgresql/y2k.html @@ -495,6 +551,7 @@ share/doc/postgresql/FAQ share/doc/postgresql/FAQ_AIX share/doc/postgresql/FAQ_DEV share/doc/postgresql/FAQ_HPUX +share/doc/postgresql/FAQ_IRIX share/doc/postgresql/FAQ_MSWIN share/doc/postgresql/FAQ_QNX4 share/doc/postgresql/FAQ_SCO @@ -507,6 +564,5 @@ share/doc/postgresql/README.mb.big5 share/doc/postgresql/README.mb.jp share/doc/postgresql/TODO share/doc/postgresql/bug.template -share/doc/postgresql/internals.ps @dirrm share/doc/postgresql @dirrm share/doc/html/postgresql -- cgit v1.2.3