diff options
author | Palle Girgensohn <girgen@FreeBSD.org> | 2005-11-10 02:23:38 +0000 |
---|---|---|
committer | Palle Girgensohn <girgen@FreeBSD.org> | 2005-11-10 02:23:38 +0000 |
commit | d587b3a37a4a02fadb87e491df608d71c7f86e07 (patch) | |
tree | 855d5cfe02114a5d512e29fa5e6051ee4416d6cb | |
parent | Update to 3.14b (diff) |
Welcome to PostgreSQL 8.1.
The new release includes performance improvements and advanced SQL
features which will support bigger data warehouses, higher-volume
transaction processing, and more complex distributed enterprise
software.
Major new features in this release include:
Roles:
PostgreSQL now supports database roles, which simplify the
management of large numbers of users with complex
overlapping database rights.
IN/OUT Parameters:
PostgreSQL functions now support IN, OUT and INOUT
parameters, which substantially improves support of complex
business logic for J2EE and .NET applications.
Two-Phase Commit (2PC):
Long in demand for WAN applications and heterogeneous data
centers using PostgreSQL, this feature allows
ACID-compliant transactions across widely separated
servers.
Some Performance Enhancements found in this release include:
Improved Multiprocessor (SMP) Performance:
The buffer manager for 8.1 has been enhanced to scale almost
linearly with the number of processors, leading to significant
performance gains on 8-way, 16-way, dual-core, and multi-core
CPU servers.
Bitmap Scan:
Indexes will be dynamically converted to bitmaps in memory when
appropriate, giving up to twenty times faster index performance
on complex queries against very large tables.
Table Partitioning:
The query planner is now able to avoid scanning whole sections
of a large table using a technique known as Constraint
Exclusion.
Shared Row Locking:
PostgreSQL's "better than row-level locking" now supports even
higher levels of concurrency through the addition of shared
row locks for foreign keys.
For a more complete listing of changes in this release, please see the
Release Notes visible at:
http://www.postgresql.org/docs/current/static/release.html#RELEASE-8-1
Notes
Notes:
svn path=/head/; revision=147772
51 files changed, 571 insertions, 715 deletions
diff --git a/databases/postgresql-contrib/Makefile b/databases/postgresql-contrib/Makefile index ffc336f65ead..59047eb3c512 100644 --- a/databases/postgresql-contrib/Makefile +++ b/databases/postgresql-contrib/Makefile @@ -25,7 +25,7 @@ SED?= /usr/bin/sed # Setting/finding PostgreSQL version we want. .if exists(${LOCALBASE}/bin/pg_config) -PGSQL_VER!= ${LOCALBASE}/bin/pg_config --version | ${SED} -n 's/PostgreSQL[^0-9]*\([0-9][0-9]*\)\.\([0-9][0-9]*\)\..*/\1\2/p' +PGSQL_VER!= ${LOCALBASE}/bin/pg_config --version | ${SED} -n 's/PostgreSQL[^0-9]*\([0-9][0-9]*\)\.\([0-9][0-9]*\)[^0-9].*/\1\2/p' .else PGSQL_VER= ${DEFAULT_PGSQL_VER} .endif @@ -39,10 +39,12 @@ SLAVE_ONLY= yes PKGMESSAGE= ${.CURDIR}/pkg-message post-install: +.if ${PGSQL_VER} < 81 @- ${INSTALL_SCRIPT} ${WRKSRC}/contrib/ipc_check/ipc_check.pl ${PREFIX}/bin/ipc_check ;\ ${INSTALL_DATA} ${WRKSRC}/contrib/ipc_check/README ${DOCSDIR}/contrib/README.ipc_check ;\ ${INSTALL_SCRIPT} ${WRKSRC}/contrib/reindexdb/reindexdb ${PREFIX}/bin/reindexdb ;\ ${INSTALL_DATA} ${WRKSRC}/contrib/reindexdb/README ${DOCSDIR}/contrib/README.reindexdb +.endif @- ${INSTALL_DATA} ${WRKSRC}/contrib/README ${DOCSDIR}/contrib/README .include "${MASTERDIR}/Makefile" diff --git a/databases/postgresql81-client/Makefile b/databases/postgresql81-client/Makefile new file mode 100644 index 000000000000..017f558f90b5 --- /dev/null +++ b/databases/postgresql81-client/Makefile @@ -0,0 +1,22 @@ +# New ports collection makefile for: PostgreSQL-client +# Date created: Wed Nov 2 00:13:57 CET 2005 +# Whom: Palle Girgensohn <girgen@FreeBSD.org> +# +# $FreeBSD$ +# +# To depend on postgresql-client, set USE_PGSQL=yes. +# See Mk/bsd.databases.mk for more info + +PORTNAME= postgresql +PKGNAMESUFFIX= -client +PORTREVISION= 0 + +COMMENT= PostgreSQL database (client) + +MASTERDIR= ${.CURDIR}/../postgresql81-server + +BUILD_DIRS= src/include src/interfaces src/bin doc src/makefiles +CLIENT_ONLY= yes +INSTALLS_SHLIB= yes + +.include "${MASTERDIR}/Makefile" diff --git a/databases/postgresql81-server/Makefile b/databases/postgresql81-server/Makefile index ac0672bbd051..4398586e3e22 100644 --- a/databases/postgresql81-server/Makefile +++ b/databases/postgresql81-server/Makefile @@ -7,7 +7,7 @@ PORTNAME?= postgresql PKGNAMESUFFIX?= -server -PORTVERSION?= 8.0.3 +PORTVERSION?= 8.1.0 PORTREVISION?= 0 CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_PGSQL} @@ -21,8 +21,6 @@ COMMENT?= The most advanced open-source database available anywhere CONFLICTS?= ${PORTNAME}-client-7.[0-9]* \ ${PORTNAME}${PKGNAMESUFFIX}-7.[0-9]* -BROKEN= Work in progress, nothing to see, please move along... - WRKSRC= ${WRKDIR}/postgresql-${PORTVERSION} DIST_SUBDIR= postgresql @@ -97,24 +95,25 @@ OPTIONS+= DEBUG "Builds with debugging symbols" off OPTIONS+= ICU "Use ICU for unicode collation (server)" off # See http://gppl.moonbone.ru/ for more info -OPTIONS+= HIER "Builds with query hierarchy (server)" off +#OPTIONS+= HIER "Builds with query hierarchy (server)" off # See http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/76999 for more info # (requires dump/restore if modified.) OPTIONS+= INTDATE "Builds with 64-bit date/time type (server)" off . if defined(SERVER_ONLY) && defined(WITH_HIER) +BROKEN= no HIER patch for 8.1 series exists PATCH_SITES+= http://gppl.moonbone.ru/:hier801054 PATCHFILES+= hier-Pg8.0.1-0.5.4.diff.gz:hier801054 USE_BISON= yes . endif . if defined(SERVER_ONLY) && defined(WITH_ICU) -USE_AUTOCONF_VER=253 +USE_AUTOCONF_VER=259 CONFIGURE_ARGS+=--with-icu -LIB_DEPENDS= icudata.32:${PORTSDIR}/devel/icu +LIB_DEPENDS= icudata.34:${PORTSDIR}/devel/icu PATCH_SITES+= http://people.freebsd.org/~girgen/postgresql-icu/:icu -PATCHFILES+= pg-803-icu-2005-08-16.diff.gz:icu +PATCHFILES+= pg-810-icu-34-2005-11-09.diff.gz:icu . endif PATCH_DIST_STRIP=-p1 @@ -152,6 +151,9 @@ INSTALL_TARGET= install-strip . endif . if defined(WITH_MIT_KRB5) +. if exists(/usr/lib/libkrb5.so) +BROKEN= "You must remove heimdal's /usr/lib/libkrb5.so* to build successfully with MIT-KRB" +. endif WITH_KRB5= yes KRB5_HOME?= ${LOCALBASE} KRB5CONF= ${KRB5_HOME}/bin/krb5-config @@ -160,20 +162,17 @@ LIB_DEPENDS+= krb5.3:${PORTSDIR}/security/krb5 . if defined(WITH_HEIMDAL_KRB5) WITH_KRB5= yes -. if defined(HEIMDAL_HOME) && exists(${HEIMDAL_HOME}/lib/libgssapi.a) -KRB5CONF= ${HEIMDAL_HOME}/bin/krb5-config -. elif ( defined(MAKE_KERBEROS5) || ${OSVERSION} > 500105 ) && exists(${DESTDIR}/usr/lib/libkrb5.a) -KRB5CONF= ${DESTDIR}/usr/bin/krb5-config -. else +# Base heimdal in /usr will not link properly with postgresql, we must +# use the port. See +# http://lists.freebsd.org/pipermail/freebsd-stable/2005-October/018809.html LIB_DEPENDS+= krb5:${PORTSDIR}/security/heimdal KRB5CONF= ${LOCALBASE}/bin/krb5-config -. endif . endif . if defined(WITH_KRB5) CONFIGURE_ARGS+= --with-krb5 -LDFLAGS+= `${KRB5CONF} --libs krb5` -CONFIGURE_ENV+= LDFLAGS="${LDFLAGS}" +LIBS= `${KRB5CONF} --libs krb5` +CONFIGURE_ENV+= LIBS="${LIBS}" . endif . if defined(SERVER_ONLY) && defined(WITH_TESTS) @@ -196,19 +195,22 @@ MAN1= clusterdb.1 createdb.1 createlang.1 createuser.1 \ dropdb.1 droplang.1 dropuser.1 ecpg.1 initdb.1 \ ipcclean.1 pg_config.1 pg_controldata.1 pg_ctl.1 \ pg_dump.1 pg_dumpall.1 pg_resetxlog.1 pg_restore.1 \ - postgres.1 postmaster.1 psql.1 vacuumdb.1 + postgres.1 postmaster.1 psql.1 reindexdb.1 vacuumdb.1 MAN7= abort.7 alter_aggregate.7 alter_conversion.7 alter_database.7 \ alter_domain.7 alter_function.7 alter_group.7 \ alter_index.7 alter_language.7 alter_operator_class.7 \ + alter_role.7 \ alter_schema.7 alter_sequence.7 alter_table.7 \ alter_trigger.7 alter_user.7 analyze.7 begin.7 \ checkpoint.7 close.7 cluster.7 comment.7 commit.7 \ + commit_prepared.7 \ copy.7 create_aggregate.7 create_cast.7 \ create_constraint_trigger.7 create_conversion.7 \ create_database.7 create_domain.7 create_function.7 \ create_group.7 create_index.7 create_language.7 \ create_operator.7 create_operator_class.7 \ + create_role.7 \ create_rule.7 create_schema.7 create_sequence.7 \ create_table.7 create_table_as.7 create_trigger.7 \ create_type.7 create_user.7 create_view.7 deallocate.7 \ @@ -216,25 +218,17 @@ MAN7= abort.7 alter_aggregate.7 alter_conversion.7 alter_database.7 \ drop_aggregate.7 drop_cast.7 drop_conversion.7 \ drop_database.7 drop_domain.7 drop_function.7 \ drop_group.7 drop_index.7 drop_language.7 \ - drop_operator.7 drop_operator_class.7 drop_rule.7 \ + drop_operator.7 drop_operator_class.7 drop_role.7 \ + drop_rule.7 \ drop_schema.7 drop_sequence.7 drop_table.7 drop_trigger.7 \ drop_type.7 drop_user.7 drop_view.7 end.7 execute.7 \ explain.7 fetch.7 grant.7 insert.7 listen.7 load.7 \ - lock.7 move.7 notify.7 prepare.7 reindex.7 reset.7 \ - revoke.7 rollback.7 select.7 select_into.7 set.7 \ - set_constraints.7 set_transaction.7 show.7 \ + lock.7 move.7 notify.7 prepare.7 prepare_transaction.7 \ + reindex.7 reset.7 \ + revoke.7 rollback.7 rollback_prepared.7 select.7 \ + select_into.7 set.7 \ + set_constraints.7 set_role.7 set_transaction.7 show.7 \ set_session_authorization.7 start_transaction.7 \ - spi_connect.7 spi_copytuple.7 spi_cursor_close.7 \ - spi_cursor_fetch.7 spi_cursor_find.7 spi_cursor_move.7 \ - spi_cursor_open.7 spi_exec.7 spi_execp.7 spi_execute.7 \ - spi_execute_plan.7 \ - spi_finish.7 spi_fname.7 spi_fnumber.7 spi_freeplan.7 \ - spi_freetuple.7 spi_freetuptable.7 spi_getargcount.7 \ - spi_getargtypeid.7 spi_getbinval.7 spi_getrelname.7 \ - spi_gettype.7 spi_gettypeid.7 spi_getvalue.7 \ - spi_is_cursor_plan.7 spi_modifytuple.7 spi_palloc.7 \ - spi_pfree.7 spi_pop.7 spi_prepare.7 spi_push.7 \ - spi_repalloc.7 spi_returntuple.7 spi_saveplan.7 \ truncate.7 unlisten.7 update.7 vacuum.7 \ alter_operator.7 alter_tablespace.7 alter_type.7 \ create_tablespace.7 drop_tablespace.7 \ diff --git a/databases/postgresql81-server/distinfo b/databases/postgresql81-server/distinfo index 0a61ebc5441a..df22506b50e5 100644 --- a/databases/postgresql81-server/distinfo +++ b/databases/postgresql81-server/distinfo @@ -1,12 +1,15 @@ -MD5 (postgresql/postgresql-base-8.0.3.tar.bz2) = 35ff2b9a3bc5c65f55b4192a334b0e88 -SIZE (postgresql/postgresql-base-8.0.3.tar.bz2) = 7818251 -MD5 (postgresql/postgresql-docs-8.0.3.tar.bz2) = a9bb1e0dbc7ff862a30b6b9ca00b6470 -SIZE (postgresql/postgresql-docs-8.0.3.tar.bz2) = 2213693 -MD5 (postgresql/postgresql-opt-8.0.3.tar.bz2) = ea1ce6f570a4408e934af914de71da0e -SIZE (postgresql/postgresql-opt-8.0.3.tar.bz2) = 133623 -MD5 (postgresql/postgresql-test-8.0.3.tar.bz2) = 4dac47d2c87bb83ba6f2cd788ec794a6 -SIZE (postgresql/postgresql-test-8.0.3.tar.bz2) = 959642 -MD5 (postgresql/hier-Pg8.0.1-0.5.4.diff.gz) = 1d410cfb38253675fee36c8f9ee655e2 -SIZE (postgresql/hier-Pg8.0.1-0.5.4.diff.gz) = 30662 -MD5 (postgresql/pg-803-icu-2005-08-16.diff.gz) = 83cb174132c5dd7aeec622bc5c9a8b0d -SIZE (postgresql/pg-803-icu-2005-08-16.diff.gz) = 4190 +MD5 (postgresql/postgresql-base-8.1.0.tar.bz2) = 61ada6238aebbe6f3850895af25df37b +SHA256 (postgresql/postgresql-base-8.1.0.tar.bz2) = 604b6be364d88a2d0b0a4bae2165be0072bb8e79129c874f9a7fa1734dc8cb38 +SIZE (postgresql/postgresql-base-8.1.0.tar.bz2) = 8027880 +MD5 (postgresql/postgresql-docs-8.1.0.tar.bz2) = 544a41caa516cd9c6a07fa5d604a91bd +SHA256 (postgresql/postgresql-docs-8.1.0.tar.bz2) = 9ef412d3859646ec6d3478cd828c395e56610cc7a54daa18381da53153847d7b +SIZE (postgresql/postgresql-docs-8.1.0.tar.bz2) = 2443376 +MD5 (postgresql/postgresql-opt-8.1.0.tar.bz2) = 5fd9e43abc22e6af1ca819e43eb1fbd2 +SHA256 (postgresql/postgresql-opt-8.1.0.tar.bz2) = a9dbb375428f2250e7fcb5e66be2eaf3b87644f33f36b195b0d87ad91432bb40 +SIZE (postgresql/postgresql-opt-8.1.0.tar.bz2) = 141420 +MD5 (postgresql/postgresql-test-8.1.0.tar.bz2) = 594b045aa80aef1907bbd6b922a1e02b +SHA256 (postgresql/postgresql-test-8.1.0.tar.bz2) = 1fd3b5fb35d39b0fe703124b982cf4b10d6495f99eb3519cb2c59134a8bfcb2f +SIZE (postgresql/postgresql-test-8.1.0.tar.bz2) = 968672 +MD5 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = b1f6f40f6fcc887f35d57bb7aee2ed09 +SHA256 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 714d030be73d3df1fd5f47409e0b059ef1d04ad9cb56255b5d803f25b8c93f1a +SIZE (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 3956 diff --git a/databases/postgresql81-server/files/patch-src-makefiles-Makefile.freebsd b/databases/postgresql81-server/files/patch-src-makefiles-Makefile.freebsd index 89aaa9a2c0cc..81339e98e8db 100644 --- a/databases/postgresql81-server/files/patch-src-makefiles-Makefile.freebsd +++ b/databases/postgresql81-server/files/patch-src-makefiles-Makefile.freebsd @@ -1,14 +1,5 @@ --- src/makefiles/Makefile.freebsd.orig Fri Nov 19 01:41:39 2004 +++ src/makefiles/Makefile.freebsd Tue Dec 21 02:44:09 2004 -@@ -11,7 +11,7 @@ - ifeq ($(findstring sparc,$(host_cpu)), sparc) - CFLAGS_SL = -fPIC -DPIC - else --CFLAGS_SL = -fpic -DPIC -+CFLAGS_SL = -fPIC -DPIC - endif - - @@ -29,3 +29,5 @@ endif diff --git a/databases/postgresql81-server/files/patch-src:backend:utils:misc:postgresql.conf.sample b/databases/postgresql81-server/files/patch-src:backend:utils:misc:postgresql.conf.sample index 07363e882113..da57f46e3552 100644 --- a/databases/postgresql81-server/files/patch-src:backend:utils:misc:postgresql.conf.sample +++ b/databases/postgresql81-server/files/patch-src:backend:utils:misc:postgresql.conf.sample @@ -1,18 +1,18 @@ ---- src/backend/utils/misc/postgresql.conf.sample~ Fri Nov 5 20:16:16 2004 -+++ src/backend/utils/misc/postgresql.conf.sample Tue Dec 21 02:06:45 2004 -@@ -172,6 +172,7 @@ +--- src/backend/utils/misc/postgresql.conf.sample~ Tue Nov 8 00:45:49 2005 ++++ src/backend/utils/misc/postgresql.conf.sample Tue Nov 8 00:47:16 2005 +@@ -206,6 +206,7 @@ # - Where to Log - +log_destination = 'syslog' - #log_destination = 'stderr' # Valid values are combinations of stderr, - # syslog and eventlog, depending on - # platform. -@@ -219,6 +220,7 @@ - - #log_min_duration_statement = -1 # -1 is disabled, in milliseconds. + #log_destination = 'stderr' # Valid values are combinations of + # stderr, syslog and eventlog, + # depending on platform. +@@ -283,6 +284,7 @@ + #log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements + # and their durations, in milliseconds. -+silent_mode = true - #silent_mode = false # DO NOT USE without syslog or redirect_stderr ++silent_mode = on + #silent_mode = off # DO NOT USE without syslog or + # redirect_stderr - # - What to Log - diff --git a/databases/postgresql81-server/pkg-plist-client b/databases/postgresql81-server/pkg-plist-client index 5810e57ecead..cda05962118f 100644 --- a/databases/postgresql81-server/pkg-plist-client +++ b/databases/postgresql81-server/pkg-plist-client @@ -16,19 +16,21 @@ bin/pg_dumpall bin/pg_resetxlog bin/pg_restore bin/psql +bin/reindexdb bin/vacuumdb include/postgresql/server/access/attnum.h include/postgresql/server/access/clog.h include/postgresql/server/access/genam.h include/postgresql/server/access/gist.h +include/postgresql/server/access/gist_private.h include/postgresql/server/access/gistscan.h include/postgresql/server/access/hash.h include/postgresql/server/access/heapam.h include/postgresql/server/access/hio.h include/postgresql/server/access/htup.h -include/postgresql/server/access/ibit.h include/postgresql/server/access/iqual.h include/postgresql/server/access/itup.h +include/postgresql/server/access/multixact.h include/postgresql/server/access/nbtree.h include/postgresql/server/access/printtup.h include/postgresql/server/access/relscan.h @@ -43,6 +45,8 @@ include/postgresql/server/access/transam.h include/postgresql/server/access/tupdesc.h include/postgresql/server/access/tupmacs.h include/postgresql/server/access/tuptoaster.h +include/postgresql/server/access/twophase.h +include/postgresql/server/access/twophase_rmgr.h include/postgresql/server/access/valid.h include/postgresql/server/access/xact.h include/postgresql/server/access/xlog.h @@ -52,7 +56,6 @@ include/postgresql/server/access/xlogutils.h include/postgresql/server/bootstrap/bootstrap.h include/postgresql/server/c.h include/postgresql/server/catalog/catalog.h -include/postgresql/server/catalog/catname.h include/postgresql/server/catalog/catversion.h include/postgresql/server/catalog/dependency.h include/postgresql/server/catalog/heap.h @@ -65,6 +68,9 @@ include/postgresql/server/catalog/pg_amop.h include/postgresql/server/catalog/pg_amproc.h include/postgresql/server/catalog/pg_attrdef.h include/postgresql/server/catalog/pg_attribute.h +include/postgresql/server/catalog/pg_auth_members.h +include/postgresql/server/catalog/pg_authid.h +include/postgresql/server/catalog/pg_autovacuum.h include/postgresql/server/catalog/pg_cast.h include/postgresql/server/catalog/pg_class.h include/postgresql/server/catalog/pg_constraint.h @@ -73,7 +79,6 @@ include/postgresql/server/catalog/pg_conversion.h include/postgresql/server/catalog/pg_database.h include/postgresql/server/catalog/pg_depend.h include/postgresql/server/catalog/pg_description.h -include/postgresql/server/catalog/pg_group.h include/postgresql/server/catalog/pg_index.h include/postgresql/server/catalog/pg_inherits.h include/postgresql/server/catalog/pg_language.h @@ -82,14 +87,14 @@ include/postgresql/server/catalog/pg_listener.h include/postgresql/server/catalog/pg_namespace.h include/postgresql/server/catalog/pg_opclass.h include/postgresql/server/catalog/pg_operator.h +include/postgresql/server/catalog/pg_pltemplate.h include/postgresql/server/catalog/pg_proc.h include/postgresql/server/catalog/pg_rewrite.h -include/postgresql/server/catalog/pg_shadow.h +include/postgresql/server/catalog/pg_shdepend.h include/postgresql/server/catalog/pg_statistic.h include/postgresql/server/catalog/pg_tablespace.h include/postgresql/server/catalog/pg_trigger.h include/postgresql/server/catalog/pg_type.h -include/postgresql/server/catalog/pg_version.h include/postgresql/server/commands/alter.h include/postgresql/server/commands/async.h include/postgresql/server/commands/cluster.h @@ -124,6 +129,10 @@ include/postgresql/server/executor/hashjoin.h include/postgresql/server/executor/instrument.h include/postgresql/server/executor/nodeAgg.h include/postgresql/server/executor/nodeAppend.h +include/postgresql/server/executor/nodeBitmapAnd.h +include/postgresql/server/executor/nodeBitmapHeapscan.h +include/postgresql/server/executor/nodeBitmapIndexscan.h +include/postgresql/server/executor/nodeBitmapOr.h include/postgresql/server/executor/nodeFunctionscan.h include/postgresql/server/executor/nodeGroup.h include/postgresql/server/executor/nodeHash.h @@ -178,6 +187,7 @@ include/postgresql/server/nodes/primnodes.h include/postgresql/server/nodes/print.h include/postgresql/server/nodes/readfuncs.h include/postgresql/server/nodes/relation.h +include/postgresql/server/nodes/tidbitmap.h include/postgresql/server/nodes/value.h include/postgresql/server/optimizer/clauses.h include/postgresql/server/optimizer/cost.h @@ -196,6 +206,7 @@ include/postgresql/server/optimizer/paths.h include/postgresql/server/optimizer/plancat.h include/postgresql/server/optimizer/planmain.h include/postgresql/server/optimizer/planner.h +include/postgresql/server/optimizer/predtest.h include/postgresql/server/optimizer/prep.h include/postgresql/server/optimizer/restrictinfo.h include/postgresql/server/optimizer/subselect.h @@ -293,6 +304,7 @@ include/postgresql/server/storage/pg_shmem.h include/postgresql/server/storage/pmsignal.h include/postgresql/server/storage/pos.h include/postgresql/server/storage/proc.h +include/postgresql/server/storage/procarray.h include/postgresql/server/storage/relfilenode.h include/postgresql/server/storage/s_lock.h include/postgresql/server/storage/shmem.h @@ -320,6 +332,7 @@ include/postgresql/server/utils/dynahash.h include/postgresql/server/utils/dynamic_loader.h include/postgresql/server/utils/elog.h include/postgresql/server/utils/errcodes.h +include/postgresql/server/utils/flatfiles.h include/postgresql/server/utils/fmgroids.h include/postgresql/server/utils/fmgrtab.h include/postgresql/server/utils/formatting.h @@ -340,6 +353,7 @@ include/postgresql/server/utils/palloc.h include/postgresql/server/utils/pg_crc.h include/postgresql/server/utils/pg_locale.h include/postgresql/server/utils/pg_lzcompress.h +include/postgresql/server/utils/pg_rusage.h include/postgresql/server/utils/portal.h include/postgresql/server/utils/ps_status.h include/postgresql/server/utils/rel.h diff --git a/databases/postgresql81-server/pkg-plist-contrib b/databases/postgresql81-server/pkg-plist-contrib index fd3f553e5b25..aba5a7b1cc19 100644 --- a/databases/postgresql81-server/pkg-plist-contrib +++ b/databases/postgresql81-server/pkg-plist-contrib @@ -1,25 +1,17 @@ bin/DBMirror.pl bin/clean_pending.pl bin/dbf2pg -bin/findoidjoins bin/fti.pl -bin/ipc_check -bin/make_oidjoins_check -bin/my2pg.pl -bin/mysql2pgsql bin/oid2name -bin/pg_autovacuum -bin/pg_dumplo bin/pgbench -bin/reindexdb bin/vacuumlo lib/postgresql/_int.so lib/postgresql/autoinc.so lib/postgresql/btree_gist.so +lib/postgresql/pg_buffercache.so lib/postgresql/chkpass.so lib/postgresql/cube.so lib/postgresql/dblink.so -lib/postgresql/dbsize.so lib/postgresql/earthdistance.so lib/postgresql/fti.so lib/postgresql/fuzzystrmatch.so @@ -28,20 +20,15 @@ lib/postgresql/int_aggregate.so lib/postgresql/isbn_issn.so lib/postgresql/lo.so lib/postgresql/ltree.so -lib/postgresql/misc_utils.so lib/postgresql/moddatetime.so -lib/postgresql/noup.so lib/postgresql/pending.so lib/postgresql/pg_trgm.so lib/postgresql/pgcrypto.so lib/postgresql/pgstattuple.so lib/postgresql/refint.so -lib/postgresql/rtree_gist.so lib/postgresql/seg.so -lib/postgresql/string_io.so lib/postgresql/tablefunc.so lib/postgresql/timetravel.so -lib/postgresql/tsearch.so lib/postgresql/tsearch2.so lib/postgresql/user_locks.so %%DOCSDIR%%/README-contrib @@ -53,37 +40,26 @@ lib/postgresql/user_locks.so %%DOCSDIR%%/contrib/README.dbf2pg %%DOCSDIR%%/contrib/README.dblink %%DOCSDIR%%/contrib/README.dbmirror -%%DOCSDIR%%/contrib/README.dbsize %%DOCSDIR%%/contrib/README.earthdistance -%%DOCSDIR%%/contrib/README.findoidjoins %%DOCSDIR%%/contrib/README.fti %%DOCSDIR%%/contrib/README.fuzzystrmatch %%DOCSDIR%%/contrib/README.int_aggregate %%DOCSDIR%%/contrib/README.intarray -%%DOCSDIR%%/contrib/README.ipc_check %%DOCSDIR%%/contrib/README.isbn_issn %%DOCSDIR%%/contrib/README.lo %%DOCSDIR%%/contrib/README.ltree -%%DOCSDIR%%/contrib/README.misc_utils -%%DOCSDIR%%/contrib/README.mysql -%%DOCSDIR%%/contrib/README.noup %%DOCSDIR%%/contrib/README.oid2name -%%DOCSDIR%%/contrib/README.pg_autovacuum -%%DOCSDIR%%/contrib/README.pg_dumplo +%%DOCSDIR%%/contrib/README.pg_buffercache %%DOCSDIR%%/contrib/README.pg_trgm %%DOCSDIR%%/contrib/README.pgbench %%DOCSDIR%%/contrib/README.pgbench_jis %%DOCSDIR%%/contrib/README.pgcrypto %%DOCSDIR%%/contrib/README.pgstattuple %%DOCSDIR%%/contrib/README.pgstattuple.euc_jp -%%DOCSDIR%%/contrib/README.reindexdb -%%DOCSDIR%%/contrib/README.rtree_gist %%DOCSDIR%%/contrib/README.seg %%DOCSDIR%%/contrib/README.soundex %%DOCSDIR%%/contrib/README.spi -%%DOCSDIR%%/contrib/README.string_io %%DOCSDIR%%/contrib/README.tablefunc -%%DOCSDIR%%/contrib/README.tsearch %%DOCSDIR%%/contrib/README.tsearch2 %%DOCSDIR%%/contrib/README.user_locks %%DOCSDIR%%/contrib/README.vacuumlo @@ -100,7 +76,6 @@ share/postgresql/contrib/btree_gist.sql share/postgresql/contrib/chkpass.sql share/postgresql/contrib/cube.sql share/postgresql/contrib/dblink.sql -share/postgresql/contrib/dbsize.sql share/postgresql/contrib/earthdistance.sql share/postgresql/contrib/english.stop share/postgresql/contrib/fti.sql @@ -112,21 +87,17 @@ share/postgresql/contrib/lo.sql share/postgresql/contrib/lo_drop.sql share/postgresql/contrib/lo_test.sql share/postgresql/contrib/ltree.sql -share/postgresql/contrib/misc_utils.sql share/postgresql/contrib/moddatetime.sql -share/postgresql/contrib/noup.sql +share/postgresql/contrib/pg_buffercache.sql share/postgresql/contrib/pg_trgm.sql share/postgresql/contrib/pgcrypto.sql share/postgresql/contrib/pgstattuple.sql share/postgresql/contrib/refint.sql -share/postgresql/contrib/rtree_gist.sql share/postgresql/contrib/russian.stop share/postgresql/contrib/seg.sql share/postgresql/contrib/slaveDatabase.conf -share/postgresql/contrib/string_io.sql share/postgresql/contrib/tablefunc.sql share/postgresql/contrib/timetravel.sql -share/postgresql/contrib/tsearch.sql share/postgresql/contrib/tsearch2.sql share/postgresql/contrib/untsearch2.sql share/postgresql/contrib/user_locks.sql diff --git a/databases/postgresql81-server/pkg-plist-server b/databases/postgresql81-server/pkg-plist-server index 24cff6b753f0..9c00caef50c8 100644 --- a/databases/postgresql81-server/pkg-plist-server +++ b/databases/postgresql81-server/pkg-plist-server @@ -24,10 +24,11 @@ lib/postgresql/utf8_and_iso8859.so lib/postgresql/utf8_and_iso8859_1.so lib/postgresql/utf8_and_johab.so lib/postgresql/utf8_and_sjis.so -lib/postgresql/utf8_and_tcvn.so lib/postgresql/utf8_and_uhc.so lib/postgresql/utf8_and_win1250.so +lib/postgresql/utf8_and_win1252.so lib/postgresql/utf8_and_win1256.so +lib/postgresql/utf8_and_win1258.so lib/postgresql/utf8_and_win874.so lib/postgresql/plpgsql.so %%DOCSDIR%%/README-server @@ -246,6 +247,7 @@ share/postgresql/timezone/Asia/Ujung_Pandang share/postgresql/timezone/Asia/Tel_Aviv share/postgresql/timezone/Asia/Thimbu share/postgresql/timezone/Asia/Ulan_Bator +share/postgresql/timezone/Australia/Currie share/postgresql/timezone/Australia/Darwin share/postgresql/timezone/Australia/Perth share/postgresql/timezone/Australia/Brisbane @@ -365,6 +367,7 @@ share/postgresql/timezone/CET share/postgresql/timezone/MET share/postgresql/timezone/EET share/postgresql/timezone/America/Danmarkshavn +share/postgresql/timezone/America/Coral_Harbour share/postgresql/timezone/America/Scoresbysund share/postgresql/timezone/America/Godthab share/postgresql/timezone/America/Thule diff --git a/databases/postgresql82-server/Makefile b/databases/postgresql82-server/Makefile index ac0672bbd051..4398586e3e22 100644 --- a/databases/postgresql82-server/Makefile +++ b/databases/postgresql82-server/Makefile @@ -7,7 +7,7 @@ PORTNAME?= postgresql PKGNAMESUFFIX?= -server -PORTVERSION?= 8.0.3 +PORTVERSION?= 8.1.0 PORTREVISION?= 0 CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_PGSQL} @@ -21,8 +21,6 @@ COMMENT?= The most advanced open-source database available anywhere CONFLICTS?= ${PORTNAME}-client-7.[0-9]* \ ${PORTNAME}${PKGNAMESUFFIX}-7.[0-9]* -BROKEN= Work in progress, nothing to see, please move along... - WRKSRC= ${WRKDIR}/postgresql-${PORTVERSION} DIST_SUBDIR= postgresql @@ -97,24 +95,25 @@ OPTIONS+= DEBUG "Builds with debugging symbols" off OPTIONS+= ICU "Use ICU for unicode collation (server)" off # See http://gppl.moonbone.ru/ for more info -OPTIONS+= HIER "Builds with query hierarchy (server)" off +#OPTIONS+= HIER "Builds with query hierarchy (server)" off # See http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/76999 for more info # (requires dump/restore if modified.) OPTIONS+= INTDATE "Builds with 64-bit date/time type (server)" off . if defined(SERVER_ONLY) && defined(WITH_HIER) +BROKEN= no HIER patch for 8.1 series exists PATCH_SITES+= http://gppl.moonbone.ru/:hier801054 PATCHFILES+= hier-Pg8.0.1-0.5.4.diff.gz:hier801054 USE_BISON= yes . endif . if defined(SERVER_ONLY) && defined(WITH_ICU) -USE_AUTOCONF_VER=253 +USE_AUTOCONF_VER=259 CONFIGURE_ARGS+=--with-icu -LIB_DEPENDS= icudata.32:${PORTSDIR}/devel/icu +LIB_DEPENDS= icudata.34:${PORTSDIR}/devel/icu PATCH_SITES+= http://people.freebsd.org/~girgen/postgresql-icu/:icu -PATCHFILES+= pg-803-icu-2005-08-16.diff.gz:icu +PATCHFILES+= pg-810-icu-34-2005-11-09.diff.gz:icu . endif PATCH_DIST_STRIP=-p1 @@ -152,6 +151,9 @@ INSTALL_TARGET= install-strip . endif . if defined(WITH_MIT_KRB5) +. if exists(/usr/lib/libkrb5.so) +BROKEN= "You must remove heimdal's /usr/lib/libkrb5.so* to build successfully with MIT-KRB" +. endif WITH_KRB5= yes KRB5_HOME?= ${LOCALBASE} KRB5CONF= ${KRB5_HOME}/bin/krb5-config @@ -160,20 +162,17 @@ LIB_DEPENDS+= krb5.3:${PORTSDIR}/security/krb5 . if defined(WITH_HEIMDAL_KRB5) WITH_KRB5= yes -. if defined(HEIMDAL_HOME) && exists(${HEIMDAL_HOME}/lib/libgssapi.a) -KRB5CONF= ${HEIMDAL_HOME}/bin/krb5-config -. elif ( defined(MAKE_KERBEROS5) || ${OSVERSION} > 500105 ) && exists(${DESTDIR}/usr/lib/libkrb5.a) -KRB5CONF= ${DESTDIR}/usr/bin/krb5-config -. else +# Base heimdal in /usr will not link properly with postgresql, we must +# use the port. See +# http://lists.freebsd.org/pipermail/freebsd-stable/2005-October/018809.html LIB_DEPENDS+= krb5:${PORTSDIR}/security/heimdal KRB5CONF= ${LOCALBASE}/bin/krb5-config -. endif . endif . if defined(WITH_KRB5) CONFIGURE_ARGS+= --with-krb5 -LDFLAGS+= `${KRB5CONF} --libs krb5` -CONFIGURE_ENV+= LDFLAGS="${LDFLAGS}" +LIBS= `${KRB5CONF} --libs krb5` +CONFIGURE_ENV+= LIBS="${LIBS}" . endif . if defined(SERVER_ONLY) && defined(WITH_TESTS) @@ -196,19 +195,22 @@ MAN1= clusterdb.1 createdb.1 createlang.1 createuser.1 \ dropdb.1 droplang.1 dropuser.1 ecpg.1 initdb.1 \ ipcclean.1 pg_config.1 pg_controldata.1 pg_ctl.1 \ pg_dump.1 pg_dumpall.1 pg_resetxlog.1 pg_restore.1 \ - postgres.1 postmaster.1 psql.1 vacuumdb.1 + postgres.1 postmaster.1 psql.1 reindexdb.1 vacuumdb.1 MAN7= abort.7 alter_aggregate.7 alter_conversion.7 alter_database.7 \ alter_domain.7 alter_function.7 alter_group.7 \ alter_index.7 alter_language.7 alter_operator_class.7 \ + alter_role.7 \ alter_schema.7 alter_sequence.7 alter_table.7 \ alter_trigger.7 alter_user.7 analyze.7 begin.7 \ checkpoint.7 close.7 cluster.7 comment.7 commit.7 \ + commit_prepared.7 \ copy.7 create_aggregate.7 create_cast.7 \ create_constraint_trigger.7 create_conversion.7 \ create_database.7 create_domain.7 create_function.7 \ create_group.7 create_index.7 create_language.7 \ create_operator.7 create_operator_class.7 \ + create_role.7 \ create_rule.7 create_schema.7 create_sequence.7 \ create_table.7 create_table_as.7 create_trigger.7 \ create_type.7 create_user.7 create_view.7 deallocate.7 \ @@ -216,25 +218,17 @@ MAN7= abort.7 alter_aggregate.7 alter_conversion.7 alter_database.7 \ drop_aggregate.7 drop_cast.7 drop_conversion.7 \ drop_database.7 drop_domain.7 drop_function.7 \ drop_group.7 drop_index.7 drop_language.7 \ - drop_operator.7 drop_operator_class.7 drop_rule.7 \ + drop_operator.7 drop_operator_class.7 drop_role.7 \ + drop_rule.7 \ drop_schema.7 drop_sequence.7 drop_table.7 drop_trigger.7 \ drop_type.7 drop_user.7 drop_view.7 end.7 execute.7 \ explain.7 fetch.7 grant.7 insert.7 listen.7 load.7 \ - lock.7 move.7 notify.7 prepare.7 reindex.7 reset.7 \ - revoke.7 rollback.7 select.7 select_into.7 set.7 \ - set_constraints.7 set_transaction.7 show.7 \ + lock.7 move.7 notify.7 prepare.7 prepare_transaction.7 \ + reindex.7 reset.7 \ + revoke.7 rollback.7 rollback_prepared.7 select.7 \ + select_into.7 set.7 \ + set_constraints.7 set_role.7 set_transaction.7 show.7 \ set_session_authorization.7 start_transaction.7 \ - spi_connect.7 spi_copytuple.7 spi_cursor_close.7 \ - spi_cursor_fetch.7 spi_cursor_find.7 spi_cursor_move.7 \ - spi_cursor_open.7 spi_exec.7 spi_execp.7 spi_execute.7 \ - spi_execute_plan.7 \ - spi_finish.7 spi_fname.7 spi_fnumber.7 spi_freeplan.7 \ - spi_freetuple.7 spi_freetuptable.7 spi_getargcount.7 \ - spi_getargtypeid.7 spi_getbinval.7 spi_getrelname.7 \ - spi_gettype.7 spi_gettypeid.7 spi_getvalue.7 \ - spi_is_cursor_plan.7 spi_modifytuple.7 spi_palloc.7 \ - spi_pfree.7 spi_pop.7 spi_prepare.7 spi_push.7 \ - spi_repalloc.7 spi_returntuple.7 spi_saveplan.7 \ truncate.7 unlisten.7 update.7 vacuum.7 \ alter_operator.7 alter_tablespace.7 alter_type.7 \ create_tablespace.7 drop_tablespace.7 \ diff --git a/databases/postgresql82-server/distinfo b/databases/postgresql82-server/distinfo index 0a61ebc5441a..df22506b50e5 100644 --- a/databases/postgresql82-server/distinfo +++ b/databases/postgresql82-server/distinfo @@ -1,12 +1,15 @@ -MD5 (postgresql/postgresql-base-8.0.3.tar.bz2) = 35ff2b9a3bc5c65f55b4192a334b0e88 -SIZE (postgresql/postgresql-base-8.0.3.tar.bz2) = 7818251 -MD5 (postgresql/postgresql-docs-8.0.3.tar.bz2) = a9bb1e0dbc7ff862a30b6b9ca00b6470 -SIZE (postgresql/postgresql-docs-8.0.3.tar.bz2) = 2213693 -MD5 (postgresql/postgresql-opt-8.0.3.tar.bz2) = ea1ce6f570a4408e934af914de71da0e -SIZE (postgresql/postgresql-opt-8.0.3.tar.bz2) = 133623 -MD5 (postgresql/postgresql-test-8.0.3.tar.bz2) = 4dac47d2c87bb83ba6f2cd788ec794a6 -SIZE (postgresql/postgresql-test-8.0.3.tar.bz2) = 959642 -MD5 (postgresql/hier-Pg8.0.1-0.5.4.diff.gz) = 1d410cfb38253675fee36c8f9ee655e2 -SIZE (postgresql/hier-Pg8.0.1-0.5.4.diff.gz) = 30662 -MD5 (postgresql/pg-803-icu-2005-08-16.diff.gz) = 83cb174132c5dd7aeec622bc5c9a8b0d -SIZE (postgresql/pg-803-icu-2005-08-16.diff.gz) = 4190 +MD5 (postgresql/postgresql-base-8.1.0.tar.bz2) = 61ada6238aebbe6f3850895af25df37b +SHA256 (postgresql/postgresql-base-8.1.0.tar.bz2) = 604b6be364d88a2d0b0a4bae2165be0072bb8e79129c874f9a7fa1734dc8cb38 +SIZE (postgresql/postgresql-base-8.1.0.tar.bz2) = 8027880 +MD5 (postgresql/postgresql-docs-8.1.0.tar.bz2) = 544a41caa516cd9c6a07fa5d604a91bd +SHA256 (postgresql/postgresql-docs-8.1.0.tar.bz2) = 9ef412d3859646ec6d3478cd828c395e56610cc7a54daa18381da53153847d7b +SIZE (postgresql/postgresql-docs-8.1.0.tar.bz2) = 2443376 +MD5 (postgresql/postgresql-opt-8.1.0.tar.bz2) = 5fd9e43abc22e6af1ca819e43eb1fbd2 +SHA256 (postgresql/postgresql-opt-8.1.0.tar.bz2) = a9dbb375428f2250e7fcb5e66be2eaf3b87644f33f36b195b0d87ad91432bb40 +SIZE (postgresql/postgresql-opt-8.1.0.tar.bz2) = 141420 +MD5 (postgresql/postgresql-test-8.1.0.tar.bz2) = 594b045aa80aef1907bbd6b922a1e02b +SHA256 (postgresql/postgresql-test-8.1.0.tar.bz2) = 1fd3b5fb35d39b0fe703124b982cf4b10d6495f99eb3519cb2c59134a8bfcb2f +SIZE (postgresql/postgresql-test-8.1.0.tar.bz2) = 968672 +MD5 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = b1f6f40f6fcc887f35d57bb7aee2ed09 +SHA256 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 714d030be73d3df1fd5f47409e0b059ef1d04ad9cb56255b5d803f25b8c93f1a +SIZE (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 3956 diff --git a/databases/postgresql82-server/files/patch-src-makefiles-Makefile.freebsd b/databases/postgresql82-server/files/patch-src-makefiles-Makefile.freebsd index 89aaa9a2c0cc..81339e98e8db 100644 --- a/databases/postgresql82-server/files/patch-src-makefiles-Makefile.freebsd +++ b/databases/postgresql82-server/files/patch-src-makefiles-Makefile.freebsd @@ -1,14 +1,5 @@ --- src/makefiles/Makefile.freebsd.orig Fri Nov 19 01:41:39 2004 +++ src/makefiles/Makefile.freebsd Tue Dec 21 02:44:09 2004 -@@ -11,7 +11,7 @@ - ifeq ($(findstring sparc,$(host_cpu)), sparc) - CFLAGS_SL = -fPIC -DPIC - else --CFLAGS_SL = -fpic -DPIC -+CFLAGS_SL = -fPIC -DPIC - endif - - @@ -29,3 +29,5 @@ endif diff --git a/databases/postgresql82-server/files/patch-src:backend:utils:misc:postgresql.conf.sample b/databases/postgresql82-server/files/patch-src:backend:utils:misc:postgresql.conf.sample index 07363e882113..da57f46e3552 100644 --- a/databases/postgresql82-server/files/patch-src:backend:utils:misc:postgresql.conf.sample +++ b/databases/postgresql82-server/files/patch-src:backend:utils:misc:postgresql.conf.sample @@ -1,18 +1,18 @@ ---- src/backend/utils/misc/postgresql.conf.sample~ Fri Nov 5 20:16:16 2004 -+++ src/backend/utils/misc/postgresql.conf.sample Tue Dec 21 02:06:45 2004 -@@ -172,6 +172,7 @@ +--- src/backend/utils/misc/postgresql.conf.sample~ Tue Nov 8 00:45:49 2005 ++++ src/backend/utils/misc/postgresql.conf.sample Tue Nov 8 00:47:16 2005 +@@ -206,6 +206,7 @@ # - Where to Log - +log_destination = 'syslog' - #log_destination = 'stderr' # Valid values are combinations of stderr, - # syslog and eventlog, depending on - # platform. -@@ -219,6 +220,7 @@ - - #log_min_duration_statement = -1 # -1 is disabled, in milliseconds. + #log_destination = 'stderr' # Valid values are combinations of + # stderr, syslog and eventlog, + # depending on platform. +@@ -283,6 +284,7 @@ + #log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements + # and their durations, in milliseconds. -+silent_mode = true - #silent_mode = false # DO NOT USE without syslog or redirect_stderr ++silent_mode = on + #silent_mode = off # DO NOT USE without syslog or + # redirect_stderr - # - What to Log - diff --git a/databases/postgresql82-server/pkg-plist-client b/databases/postgresql82-server/pkg-plist-client index 5810e57ecead..cda05962118f 100644 --- a/databases/postgresql82-server/pkg-plist-client +++ b/databases/postgresql82-server/pkg-plist-client @@ -16,19 +16,21 @@ bin/pg_dumpall bin/pg_resetxlog bin/pg_restore bin/psql +bin/reindexdb bin/vacuumdb include/postgresql/server/access/attnum.h include/postgresql/server/access/clog.h include/postgresql/server/access/genam.h include/postgresql/server/access/gist.h +include/postgresql/server/access/gist_private.h include/postgresql/server/access/gistscan.h include/postgresql/server/access/hash.h include/postgresql/server/access/heapam.h include/postgresql/server/access/hio.h include/postgresql/server/access/htup.h -include/postgresql/server/access/ibit.h include/postgresql/server/access/iqual.h include/postgresql/server/access/itup.h +include/postgresql/server/access/multixact.h include/postgresql/server/access/nbtree.h include/postgresql/server/access/printtup.h include/postgresql/server/access/relscan.h @@ -43,6 +45,8 @@ include/postgresql/server/access/transam.h include/postgresql/server/access/tupdesc.h include/postgresql/server/access/tupmacs.h include/postgresql/server/access/tuptoaster.h +include/postgresql/server/access/twophase.h +include/postgresql/server/access/twophase_rmgr.h include/postgresql/server/access/valid.h include/postgresql/server/access/xact.h include/postgresql/server/access/xlog.h @@ -52,7 +56,6 @@ include/postgresql/server/access/xlogutils.h include/postgresql/server/bootstrap/bootstrap.h include/postgresql/server/c.h include/postgresql/server/catalog/catalog.h -include/postgresql/server/catalog/catname.h include/postgresql/server/catalog/catversion.h include/postgresql/server/catalog/dependency.h include/postgresql/server/catalog/heap.h @@ -65,6 +68,9 @@ include/postgresql/server/catalog/pg_amop.h include/postgresql/server/catalog/pg_amproc.h include/postgresql/server/catalog/pg_attrdef.h include/postgresql/server/catalog/pg_attribute.h +include/postgresql/server/catalog/pg_auth_members.h +include/postgresql/server/catalog/pg_authid.h +include/postgresql/server/catalog/pg_autovacuum.h include/postgresql/server/catalog/pg_cast.h include/postgresql/server/catalog/pg_class.h include/postgresql/server/catalog/pg_constraint.h @@ -73,7 +79,6 @@ include/postgresql/server/catalog/pg_conversion.h include/postgresql/server/catalog/pg_database.h include/postgresql/server/catalog/pg_depend.h include/postgresql/server/catalog/pg_description.h -include/postgresql/server/catalog/pg_group.h include/postgresql/server/catalog/pg_index.h include/postgresql/server/catalog/pg_inherits.h include/postgresql/server/catalog/pg_language.h @@ -82,14 +87,14 @@ include/postgresql/server/catalog/pg_listener.h include/postgresql/server/catalog/pg_namespace.h include/postgresql/server/catalog/pg_opclass.h include/postgresql/server/catalog/pg_operator.h +include/postgresql/server/catalog/pg_pltemplate.h include/postgresql/server/catalog/pg_proc.h include/postgresql/server/catalog/pg_rewrite.h -include/postgresql/server/catalog/pg_shadow.h +include/postgresql/server/catalog/pg_shdepend.h include/postgresql/server/catalog/pg_statistic.h include/postgresql/server/catalog/pg_tablespace.h include/postgresql/server/catalog/pg_trigger.h include/postgresql/server/catalog/pg_type.h -include/postgresql/server/catalog/pg_version.h include/postgresql/server/commands/alter.h include/postgresql/server/commands/async.h include/postgresql/server/commands/cluster.h @@ -124,6 +129,10 @@ include/postgresql/server/executor/hashjoin.h include/postgresql/server/executor/instrument.h include/postgresql/server/executor/nodeAgg.h include/postgresql/server/executor/nodeAppend.h +include/postgresql/server/executor/nodeBitmapAnd.h +include/postgresql/server/executor/nodeBitmapHeapscan.h +include/postgresql/server/executor/nodeBitmapIndexscan.h +include/postgresql/server/executor/nodeBitmapOr.h include/postgresql/server/executor/nodeFunctionscan.h include/postgresql/server/executor/nodeGroup.h include/postgresql/server/executor/nodeHash.h @@ -178,6 +187,7 @@ include/postgresql/server/nodes/primnodes.h include/postgresql/server/nodes/print.h include/postgresql/server/nodes/readfuncs.h include/postgresql/server/nodes/relation.h +include/postgresql/server/nodes/tidbitmap.h include/postgresql/server/nodes/value.h include/postgresql/server/optimizer/clauses.h include/postgresql/server/optimizer/cost.h @@ -196,6 +206,7 @@ include/postgresql/server/optimizer/paths.h include/postgresql/server/optimizer/plancat.h include/postgresql/server/optimizer/planmain.h include/postgresql/server/optimizer/planner.h +include/postgresql/server/optimizer/predtest.h include/postgresql/server/optimizer/prep.h include/postgresql/server/optimizer/restrictinfo.h include/postgresql/server/optimizer/subselect.h @@ -293,6 +304,7 @@ include/postgresql/server/storage/pg_shmem.h include/postgresql/server/storage/pmsignal.h include/postgresql/server/storage/pos.h include/postgresql/server/storage/proc.h +include/postgresql/server/storage/procarray.h include/postgresql/server/storage/relfilenode.h include/postgresql/server/storage/s_lock.h include/postgresql/server/storage/shmem.h @@ -320,6 +332,7 @@ include/postgresql/server/utils/dynahash.h include/postgresql/server/utils/dynamic_loader.h include/postgresql/server/utils/elog.h include/postgresql/server/utils/errcodes.h +include/postgresql/server/utils/flatfiles.h include/postgresql/server/utils/fmgroids.h include/postgresql/server/utils/fmgrtab.h include/postgresql/server/utils/formatting.h @@ -340,6 +353,7 @@ include/postgresql/server/utils/palloc.h include/postgresql/server/utils/pg_crc.h include/postgresql/server/utils/pg_locale.h include/postgresql/server/utils/pg_lzcompress.h +include/postgresql/server/utils/pg_rusage.h include/postgresql/server/utils/portal.h include/postgresql/server/utils/ps_status.h include/postgresql/server/utils/rel.h diff --git a/databases/postgresql82-server/pkg-plist-contrib b/databases/postgresql82-server/pkg-plist-contrib index fd3f553e5b25..aba5a7b1cc19 100644 --- a/databases/postgresql82-server/pkg-plist-contrib +++ b/databases/postgresql82-server/pkg-plist-contrib @@ -1,25 +1,17 @@ bin/DBMirror.pl bin/clean_pending.pl bin/dbf2pg -bin/findoidjoins bin/fti.pl -bin/ipc_check -bin/make_oidjoins_check -bin/my2pg.pl -bin/mysql2pgsql bin/oid2name -bin/pg_autovacuum -bin/pg_dumplo bin/pgbench -bin/reindexdb bin/vacuumlo lib/postgresql/_int.so lib/postgresql/autoinc.so lib/postgresql/btree_gist.so +lib/postgresql/pg_buffercache.so lib/postgresql/chkpass.so lib/postgresql/cube.so lib/postgresql/dblink.so -lib/postgresql/dbsize.so lib/postgresql/earthdistance.so lib/postgresql/fti.so lib/postgresql/fuzzystrmatch.so @@ -28,20 +20,15 @@ lib/postgresql/int_aggregate.so lib/postgresql/isbn_issn.so lib/postgresql/lo.so lib/postgresql/ltree.so -lib/postgresql/misc_utils.so lib/postgresql/moddatetime.so -lib/postgresql/noup.so lib/postgresql/pending.so lib/postgresql/pg_trgm.so lib/postgresql/pgcrypto.so lib/postgresql/pgstattuple.so lib/postgresql/refint.so -lib/postgresql/rtree_gist.so lib/postgresql/seg.so -lib/postgresql/string_io.so lib/postgresql/tablefunc.so lib/postgresql/timetravel.so -lib/postgresql/tsearch.so lib/postgresql/tsearch2.so lib/postgresql/user_locks.so %%DOCSDIR%%/README-contrib @@ -53,37 +40,26 @@ lib/postgresql/user_locks.so %%DOCSDIR%%/contrib/README.dbf2pg %%DOCSDIR%%/contrib/README.dblink %%DOCSDIR%%/contrib/README.dbmirror -%%DOCSDIR%%/contrib/README.dbsize %%DOCSDIR%%/contrib/README.earthdistance -%%DOCSDIR%%/contrib/README.findoidjoins %%DOCSDIR%%/contrib/README.fti %%DOCSDIR%%/contrib/README.fuzzystrmatch %%DOCSDIR%%/contrib/README.int_aggregate %%DOCSDIR%%/contrib/README.intarray -%%DOCSDIR%%/contrib/README.ipc_check %%DOCSDIR%%/contrib/README.isbn_issn %%DOCSDIR%%/contrib/README.lo %%DOCSDIR%%/contrib/README.ltree -%%DOCSDIR%%/contrib/README.misc_utils -%%DOCSDIR%%/contrib/README.mysql -%%DOCSDIR%%/contrib/README.noup %%DOCSDIR%%/contrib/README.oid2name -%%DOCSDIR%%/contrib/README.pg_autovacuum -%%DOCSDIR%%/contrib/README.pg_dumplo +%%DOCSDIR%%/contrib/README.pg_buffercache %%DOCSDIR%%/contrib/README.pg_trgm %%DOCSDIR%%/contrib/README.pgbench %%DOCSDIR%%/contrib/README.pgbench_jis %%DOCSDIR%%/contrib/README.pgcrypto %%DOCSDIR%%/contrib/README.pgstattuple %%DOCSDIR%%/contrib/README.pgstattuple.euc_jp -%%DOCSDIR%%/contrib/README.reindexdb -%%DOCSDIR%%/contrib/README.rtree_gist %%DOCSDIR%%/contrib/README.seg %%DOCSDIR%%/contrib/README.soundex %%DOCSDIR%%/contrib/README.spi -%%DOCSDIR%%/contrib/README.string_io %%DOCSDIR%%/contrib/README.tablefunc -%%DOCSDIR%%/contrib/README.tsearch %%DOCSDIR%%/contrib/README.tsearch2 %%DOCSDIR%%/contrib/README.user_locks %%DOCSDIR%%/contrib/README.vacuumlo @@ -100,7 +76,6 @@ share/postgresql/contrib/btree_gist.sql share/postgresql/contrib/chkpass.sql share/postgresql/contrib/cube.sql share/postgresql/contrib/dblink.sql -share/postgresql/contrib/dbsize.sql share/postgresql/contrib/earthdistance.sql share/postgresql/contrib/english.stop share/postgresql/contrib/fti.sql @@ -112,21 +87,17 @@ share/postgresql/contrib/lo.sql share/postgresql/contrib/lo_drop.sql share/postgresql/contrib/lo_test.sql share/postgresql/contrib/ltree.sql -share/postgresql/contrib/misc_utils.sql share/postgresql/contrib/moddatetime.sql -share/postgresql/contrib/noup.sql +share/postgresql/contrib/pg_buffercache.sql share/postgresql/contrib/pg_trgm.sql share/postgresql/contrib/pgcrypto.sql share/postgresql/contrib/pgstattuple.sql share/postgresql/contrib/refint.sql -share/postgresql/contrib/rtree_gist.sql share/postgresql/contrib/russian.stop share/postgresql/contrib/seg.sql share/postgresql/contrib/slaveDatabase.conf -share/postgresql/contrib/string_io.sql share/postgresql/contrib/tablefunc.sql share/postgresql/contrib/timetravel.sql -share/postgresql/contrib/tsearch.sql share/postgresql/contrib/tsearch2.sql share/postgresql/contrib/untsearch2.sql share/postgresql/contrib/user_locks.sql diff --git a/databases/postgresql82-server/pkg-plist-server b/databases/postgresql82-server/pkg-plist-server index 24cff6b753f0..9c00caef50c8 100644 --- a/databases/postgresql82-server/pkg-plist-server +++ b/databases/postgresql82-server/pkg-plist-server @@ -24,10 +24,11 @@ lib/postgresql/utf8_and_iso8859.so lib/postgresql/utf8_and_iso8859_1.so lib/postgresql/utf8_and_johab.so lib/postgresql/utf8_and_sjis.so -lib/postgresql/utf8_and_tcvn.so lib/postgresql/utf8_and_uhc.so lib/postgresql/utf8_and_win1250.so +lib/postgresql/utf8_and_win1252.so lib/postgresql/utf8_and_win1256.so +lib/postgresql/utf8_and_win1258.so lib/postgresql/utf8_and_win874.so lib/postgresql/plpgsql.so %%DOCSDIR%%/README-server @@ -246,6 +247,7 @@ share/postgresql/timezone/Asia/Ujung_Pandang share/postgresql/timezone/Asia/Tel_Aviv share/postgresql/timezone/Asia/Thimbu share/postgresql/timezone/Asia/Ulan_Bator +share/postgresql/timezone/Australia/Currie share/postgresql/timezone/Australia/Darwin share/postgresql/timezone/Australia/Perth share/postgresql/timezone/Australia/Brisbane @@ -365,6 +367,7 @@ share/postgresql/timezone/CET share/postgresql/timezone/MET share/postgresql/timezone/EET share/postgresql/timezone/America/Danmarkshavn +share/postgresql/timezone/America/Coral_Harbour share/postgresql/timezone/America/Scoresbysund share/postgresql/timezone/America/Godthab share/postgresql/timezone/America/Thule diff --git a/databases/postgresql83-server/Makefile b/databases/postgresql83-server/Makefile index ac0672bbd051..4398586e3e22 100644 --- a/databases/postgresql83-server/Makefile +++ b/databases/postgresql83-server/Makefile @@ -7,7 +7,7 @@ PORTNAME?= postgresql PKGNAMESUFFIX?= -server -PORTVERSION?= 8.0.3 +PORTVERSION?= 8.1.0 PORTREVISION?= 0 CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_PGSQL} @@ -21,8 +21,6 @@ COMMENT?= The most advanced open-source database available anywhere CONFLICTS?= ${PORTNAME}-client-7.[0-9]* \ ${PORTNAME}${PKGNAMESUFFIX}-7.[0-9]* -BROKEN= Work in progress, nothing to see, please move along... - WRKSRC= ${WRKDIR}/postgresql-${PORTVERSION} DIST_SUBDIR= postgresql @@ -97,24 +95,25 @@ OPTIONS+= DEBUG "Builds with debugging symbols" off OPTIONS+= ICU "Use ICU for unicode collation (server)" off # See http://gppl.moonbone.ru/ for more info -OPTIONS+= HIER "Builds with query hierarchy (server)" off +#OPTIONS+= HIER "Builds with query hierarchy (server)" off # See http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/76999 for more info # (requires dump/restore if modified.) OPTIONS+= INTDATE "Builds with 64-bit date/time type (server)" off . if defined(SERVER_ONLY) && defined(WITH_HIER) +BROKEN= no HIER patch for 8.1 series exists PATCH_SITES+= http://gppl.moonbone.ru/:hier801054 PATCHFILES+= hier-Pg8.0.1-0.5.4.diff.gz:hier801054 USE_BISON= yes . endif . if defined(SERVER_ONLY) && defined(WITH_ICU) -USE_AUTOCONF_VER=253 +USE_AUTOCONF_VER=259 CONFIGURE_ARGS+=--with-icu -LIB_DEPENDS= icudata.32:${PORTSDIR}/devel/icu +LIB_DEPENDS= icudata.34:${PORTSDIR}/devel/icu PATCH_SITES+= http://people.freebsd.org/~girgen/postgresql-icu/:icu -PATCHFILES+= pg-803-icu-2005-08-16.diff.gz:icu +PATCHFILES+= pg-810-icu-34-2005-11-09.diff.gz:icu . endif PATCH_DIST_STRIP=-p1 @@ -152,6 +151,9 @@ INSTALL_TARGET= install-strip . endif . if defined(WITH_MIT_KRB5) +. if exists(/usr/lib/libkrb5.so) +BROKEN= "You must remove heimdal's /usr/lib/libkrb5.so* to build successfully with MIT-KRB" +. endif WITH_KRB5= yes KRB5_HOME?= ${LOCALBASE} KRB5CONF= ${KRB5_HOME}/bin/krb5-config @@ -160,20 +162,17 @@ LIB_DEPENDS+= krb5.3:${PORTSDIR}/security/krb5 . if defined(WITH_HEIMDAL_KRB5) WITH_KRB5= yes -. if defined(HEIMDAL_HOME) && exists(${HEIMDAL_HOME}/lib/libgssapi.a) -KRB5CONF= ${HEIMDAL_HOME}/bin/krb5-config -. elif ( defined(MAKE_KERBEROS5) || ${OSVERSION} > 500105 ) && exists(${DESTDIR}/usr/lib/libkrb5.a) -KRB5CONF= ${DESTDIR}/usr/bin/krb5-config -. else +# Base heimdal in /usr will not link properly with postgresql, we must +# use the port. See +# http://lists.freebsd.org/pipermail/freebsd-stable/2005-October/018809.html LIB_DEPENDS+= krb5:${PORTSDIR}/security/heimdal KRB5CONF= ${LOCALBASE}/bin/krb5-config -. endif . endif . if defined(WITH_KRB5) CONFIGURE_ARGS+= --with-krb5 -LDFLAGS+= `${KRB5CONF} --libs krb5` -CONFIGURE_ENV+= LDFLAGS="${LDFLAGS}" +LIBS= `${KRB5CONF} --libs krb5` +CONFIGURE_ENV+= LIBS="${LIBS}" . endif . if defined(SERVER_ONLY) && defined(WITH_TESTS) @@ -196,19 +195,22 @@ MAN1= clusterdb.1 createdb.1 createlang.1 createuser.1 \ dropdb.1 droplang.1 dropuser.1 ecpg.1 initdb.1 \ ipcclean.1 pg_config.1 pg_controldata.1 pg_ctl.1 \ pg_dump.1 pg_dumpall.1 pg_resetxlog.1 pg_restore.1 \ - postgres.1 postmaster.1 psql.1 vacuumdb.1 + postgres.1 postmaster.1 psql.1 reindexdb.1 vacuumdb.1 MAN7= abort.7 alter_aggregate.7 alter_conversion.7 alter_database.7 \ alter_domain.7 alter_function.7 alter_group.7 \ alter_index.7 alter_language.7 alter_operator_class.7 \ + alter_role.7 \ alter_schema.7 alter_sequence.7 alter_table.7 \ alter_trigger.7 alter_user.7 analyze.7 begin.7 \ checkpoint.7 close.7 cluster.7 comment.7 commit.7 \ + commit_prepared.7 \ copy.7 create_aggregate.7 create_cast.7 \ create_constraint_trigger.7 create_conversion.7 \ create_database.7 create_domain.7 create_function.7 \ create_group.7 create_index.7 create_language.7 \ create_operator.7 create_operator_class.7 \ + create_role.7 \ create_rule.7 create_schema.7 create_sequence.7 \ create_table.7 create_table_as.7 create_trigger.7 \ create_type.7 create_user.7 create_view.7 deallocate.7 \ @@ -216,25 +218,17 @@ MAN7= abort.7 alter_aggregate.7 alter_conversion.7 alter_database.7 \ drop_aggregate.7 drop_cast.7 drop_conversion.7 \ drop_database.7 drop_domain.7 drop_function.7 \ drop_group.7 drop_index.7 drop_language.7 \ - drop_operator.7 drop_operator_class.7 drop_rule.7 \ + drop_operator.7 drop_operator_class.7 drop_role.7 \ + drop_rule.7 \ drop_schema.7 drop_sequence.7 drop_table.7 drop_trigger.7 \ drop_type.7 drop_user.7 drop_view.7 end.7 execute.7 \ explain.7 fetch.7 grant.7 insert.7 listen.7 load.7 \ - lock.7 move.7 notify.7 prepare.7 reindex.7 reset.7 \ - revoke.7 rollback.7 select.7 select_into.7 set.7 \ - set_constraints.7 set_transaction.7 show.7 \ + lock.7 move.7 notify.7 prepare.7 prepare_transaction.7 \ + reindex.7 reset.7 \ + revoke.7 rollback.7 rollback_prepared.7 select.7 \ + select_into.7 set.7 \ + set_constraints.7 set_role.7 set_transaction.7 show.7 \ set_session_authorization.7 start_transaction.7 \ - spi_connect.7 spi_copytuple.7 spi_cursor_close.7 \ - spi_cursor_fetch.7 spi_cursor_find.7 spi_cursor_move.7 \ - spi_cursor_open.7 spi_exec.7 spi_execp.7 spi_execute.7 \ - spi_execute_plan.7 \ - spi_finish.7 spi_fname.7 spi_fnumber.7 spi_freeplan.7 \ - spi_freetuple.7 spi_freetuptable.7 spi_getargcount.7 \ - spi_getargtypeid.7 spi_getbinval.7 spi_getrelname.7 \ - spi_gettype.7 spi_gettypeid.7 spi_getvalue.7 \ - spi_is_cursor_plan.7 spi_modifytuple.7 spi_palloc.7 \ - spi_pfree.7 spi_pop.7 spi_prepare.7 spi_push.7 \ - spi_repalloc.7 spi_returntuple.7 spi_saveplan.7 \ truncate.7 unlisten.7 update.7 vacuum.7 \ alter_operator.7 alter_tablespace.7 alter_type.7 \ create_tablespace.7 drop_tablespace.7 \ diff --git a/databases/postgresql83-server/distinfo b/databases/postgresql83-server/distinfo index 0a61ebc5441a..df22506b50e5 100644 --- a/databases/postgresql83-server/distinfo +++ b/databases/postgresql83-server/distinfo @@ -1,12 +1,15 @@ -MD5 (postgresql/postgresql-base-8.0.3.tar.bz2) = 35ff2b9a3bc5c65f55b4192a334b0e88 -SIZE (postgresql/postgresql-base-8.0.3.tar.bz2) = 7818251 -MD5 (postgresql/postgresql-docs-8.0.3.tar.bz2) = a9bb1e0dbc7ff862a30b6b9ca00b6470 -SIZE (postgresql/postgresql-docs-8.0.3.tar.bz2) = 2213693 -MD5 (postgresql/postgresql-opt-8.0.3.tar.bz2) = ea1ce6f570a4408e934af914de71da0e -SIZE (postgresql/postgresql-opt-8.0.3.tar.bz2) = 133623 -MD5 (postgresql/postgresql-test-8.0.3.tar.bz2) = 4dac47d2c87bb83ba6f2cd788ec794a6 -SIZE (postgresql/postgresql-test-8.0.3.tar.bz2) = 959642 -MD5 (postgresql/hier-Pg8.0.1-0.5.4.diff.gz) = 1d410cfb38253675fee36c8f9ee655e2 -SIZE (postgresql/hier-Pg8.0.1-0.5.4.diff.gz) = 30662 -MD5 (postgresql/pg-803-icu-2005-08-16.diff.gz) = 83cb174132c5dd7aeec622bc5c9a8b0d -SIZE (postgresql/pg-803-icu-2005-08-16.diff.gz) = 4190 +MD5 (postgresql/postgresql-base-8.1.0.tar.bz2) = 61ada6238aebbe6f3850895af25df37b +SHA256 (postgresql/postgresql-base-8.1.0.tar.bz2) = 604b6be364d88a2d0b0a4bae2165be0072bb8e79129c874f9a7fa1734dc8cb38 +SIZE (postgresql/postgresql-base-8.1.0.tar.bz2) = 8027880 +MD5 (postgresql/postgresql-docs-8.1.0.tar.bz2) = 544a41caa516cd9c6a07fa5d604a91bd +SHA256 (postgresql/postgresql-docs-8.1.0.tar.bz2) = 9ef412d3859646ec6d3478cd828c395e56610cc7a54daa18381da53153847d7b +SIZE (postgresql/postgresql-docs-8.1.0.tar.bz2) = 2443376 +MD5 (postgresql/postgresql-opt-8.1.0.tar.bz2) = 5fd9e43abc22e6af1ca819e43eb1fbd2 +SHA256 (postgresql/postgresql-opt-8.1.0.tar.bz2) = a9dbb375428f2250e7fcb5e66be2eaf3b87644f33f36b195b0d87ad91432bb40 +SIZE (postgresql/postgresql-opt-8.1.0.tar.bz2) = 141420 +MD5 (postgresql/postgresql-test-8.1.0.tar.bz2) = 594b045aa80aef1907bbd6b922a1e02b +SHA256 (postgresql/postgresql-test-8.1.0.tar.bz2) = 1fd3b5fb35d39b0fe703124b982cf4b10d6495f99eb3519cb2c59134a8bfcb2f +SIZE (postgresql/postgresql-test-8.1.0.tar.bz2) = 968672 +MD5 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = b1f6f40f6fcc887f35d57bb7aee2ed09 +SHA256 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 714d030be73d3df1fd5f47409e0b059ef1d04ad9cb56255b5d803f25b8c93f1a +SIZE (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 3956 diff --git a/databases/postgresql83-server/files/patch-src-makefiles-Makefile.freebsd b/databases/postgresql83-server/files/patch-src-makefiles-Makefile.freebsd index 89aaa9a2c0cc..81339e98e8db 100644 --- a/databases/postgresql83-server/files/patch-src-makefiles-Makefile.freebsd +++ b/databases/postgresql83-server/files/patch-src-makefiles-Makefile.freebsd @@ -1,14 +1,5 @@ --- src/makefiles/Makefile.freebsd.orig Fri Nov 19 01:41:39 2004 +++ src/makefiles/Makefile.freebsd Tue Dec 21 02:44:09 2004 -@@ -11,7 +11,7 @@ - ifeq ($(findstring sparc,$(host_cpu)), sparc) - CFLAGS_SL = -fPIC -DPIC - else --CFLAGS_SL = -fpic -DPIC -+CFLAGS_SL = -fPIC -DPIC - endif - - @@ -29,3 +29,5 @@ endif diff --git a/databases/postgresql83-server/files/patch-src:backend:utils:misc:postgresql.conf.sample b/databases/postgresql83-server/files/patch-src:backend:utils:misc:postgresql.conf.sample index 07363e882113..da57f46e3552 100644 --- a/databases/postgresql83-server/files/patch-src:backend:utils:misc:postgresql.conf.sample +++ b/databases/postgresql83-server/files/patch-src:backend:utils:misc:postgresql.conf.sample @@ -1,18 +1,18 @@ ---- src/backend/utils/misc/postgresql.conf.sample~ Fri Nov 5 20:16:16 2004 -+++ src/backend/utils/misc/postgresql.conf.sample Tue Dec 21 02:06:45 2004 -@@ -172,6 +172,7 @@ +--- src/backend/utils/misc/postgresql.conf.sample~ Tue Nov 8 00:45:49 2005 ++++ src/backend/utils/misc/postgresql.conf.sample Tue Nov 8 00:47:16 2005 +@@ -206,6 +206,7 @@ # - Where to Log - +log_destination = 'syslog' - #log_destination = 'stderr' # Valid values are combinations of stderr, - # syslog and eventlog, depending on - # platform. -@@ -219,6 +220,7 @@ - - #log_min_duration_statement = -1 # -1 is disabled, in milliseconds. + #log_destination = 'stderr' # Valid values are combinations of + # stderr, syslog and eventlog, + # depending on platform. +@@ -283,6 +284,7 @@ + #log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements + # and their durations, in milliseconds. -+silent_mode = true - #silent_mode = false # DO NOT USE without syslog or redirect_stderr ++silent_mode = on + #silent_mode = off # DO NOT USE without syslog or + # redirect_stderr - # - What to Log - diff --git a/databases/postgresql83-server/pkg-plist-client b/databases/postgresql83-server/pkg-plist-client index 5810e57ecead..cda05962118f 100644 --- a/databases/postgresql83-server/pkg-plist-client +++ b/databases/postgresql83-server/pkg-plist-client @@ -16,19 +16,21 @@ bin/pg_dumpall bin/pg_resetxlog bin/pg_restore bin/psql +bin/reindexdb bin/vacuumdb include/postgresql/server/access/attnum.h include/postgresql/server/access/clog.h include/postgresql/server/access/genam.h include/postgresql/server/access/gist.h +include/postgresql/server/access/gist_private.h include/postgresql/server/access/gistscan.h include/postgresql/server/access/hash.h include/postgresql/server/access/heapam.h include/postgresql/server/access/hio.h include/postgresql/server/access/htup.h -include/postgresql/server/access/ibit.h include/postgresql/server/access/iqual.h include/postgresql/server/access/itup.h +include/postgresql/server/access/multixact.h include/postgresql/server/access/nbtree.h include/postgresql/server/access/printtup.h include/postgresql/server/access/relscan.h @@ -43,6 +45,8 @@ include/postgresql/server/access/transam.h include/postgresql/server/access/tupdesc.h include/postgresql/server/access/tupmacs.h include/postgresql/server/access/tuptoaster.h +include/postgresql/server/access/twophase.h +include/postgresql/server/access/twophase_rmgr.h include/postgresql/server/access/valid.h include/postgresql/server/access/xact.h include/postgresql/server/access/xlog.h @@ -52,7 +56,6 @@ include/postgresql/server/access/xlogutils.h include/postgresql/server/bootstrap/bootstrap.h include/postgresql/server/c.h include/postgresql/server/catalog/catalog.h -include/postgresql/server/catalog/catname.h include/postgresql/server/catalog/catversion.h include/postgresql/server/catalog/dependency.h include/postgresql/server/catalog/heap.h @@ -65,6 +68,9 @@ include/postgresql/server/catalog/pg_amop.h include/postgresql/server/catalog/pg_amproc.h include/postgresql/server/catalog/pg_attrdef.h include/postgresql/server/catalog/pg_attribute.h +include/postgresql/server/catalog/pg_auth_members.h +include/postgresql/server/catalog/pg_authid.h +include/postgresql/server/catalog/pg_autovacuum.h include/postgresql/server/catalog/pg_cast.h include/postgresql/server/catalog/pg_class.h include/postgresql/server/catalog/pg_constraint.h @@ -73,7 +79,6 @@ include/postgresql/server/catalog/pg_conversion.h include/postgresql/server/catalog/pg_database.h include/postgresql/server/catalog/pg_depend.h include/postgresql/server/catalog/pg_description.h -include/postgresql/server/catalog/pg_group.h include/postgresql/server/catalog/pg_index.h include/postgresql/server/catalog/pg_inherits.h include/postgresql/server/catalog/pg_language.h @@ -82,14 +87,14 @@ include/postgresql/server/catalog/pg_listener.h include/postgresql/server/catalog/pg_namespace.h include/postgresql/server/catalog/pg_opclass.h include/postgresql/server/catalog/pg_operator.h +include/postgresql/server/catalog/pg_pltemplate.h include/postgresql/server/catalog/pg_proc.h include/postgresql/server/catalog/pg_rewrite.h -include/postgresql/server/catalog/pg_shadow.h +include/postgresql/server/catalog/pg_shdepend.h include/postgresql/server/catalog/pg_statistic.h include/postgresql/server/catalog/pg_tablespace.h include/postgresql/server/catalog/pg_trigger.h include/postgresql/server/catalog/pg_type.h -include/postgresql/server/catalog/pg_version.h include/postgresql/server/commands/alter.h include/postgresql/server/commands/async.h include/postgresql/server/commands/cluster.h @@ -124,6 +129,10 @@ include/postgresql/server/executor/hashjoin.h include/postgresql/server/executor/instrument.h include/postgresql/server/executor/nodeAgg.h include/postgresql/server/executor/nodeAppend.h +include/postgresql/server/executor/nodeBitmapAnd.h +include/postgresql/server/executor/nodeBitmapHeapscan.h +include/postgresql/server/executor/nodeBitmapIndexscan.h +include/postgresql/server/executor/nodeBitmapOr.h include/postgresql/server/executor/nodeFunctionscan.h include/postgresql/server/executor/nodeGroup.h include/postgresql/server/executor/nodeHash.h @@ -178,6 +187,7 @@ include/postgresql/server/nodes/primnodes.h include/postgresql/server/nodes/print.h include/postgresql/server/nodes/readfuncs.h include/postgresql/server/nodes/relation.h +include/postgresql/server/nodes/tidbitmap.h include/postgresql/server/nodes/value.h include/postgresql/server/optimizer/clauses.h include/postgresql/server/optimizer/cost.h @@ -196,6 +206,7 @@ include/postgresql/server/optimizer/paths.h include/postgresql/server/optimizer/plancat.h include/postgresql/server/optimizer/planmain.h include/postgresql/server/optimizer/planner.h +include/postgresql/server/optimizer/predtest.h include/postgresql/server/optimizer/prep.h include/postgresql/server/optimizer/restrictinfo.h include/postgresql/server/optimizer/subselect.h @@ -293,6 +304,7 @@ include/postgresql/server/storage/pg_shmem.h include/postgresql/server/storage/pmsignal.h include/postgresql/server/storage/pos.h include/postgresql/server/storage/proc.h +include/postgresql/server/storage/procarray.h include/postgresql/server/storage/relfilenode.h include/postgresql/server/storage/s_lock.h include/postgresql/server/storage/shmem.h @@ -320,6 +332,7 @@ include/postgresql/server/utils/dynahash.h include/postgresql/server/utils/dynamic_loader.h include/postgresql/server/utils/elog.h include/postgresql/server/utils/errcodes.h +include/postgresql/server/utils/flatfiles.h include/postgresql/server/utils/fmgroids.h include/postgresql/server/utils/fmgrtab.h include/postgresql/server/utils/formatting.h @@ -340,6 +353,7 @@ include/postgresql/server/utils/palloc.h include/postgresql/server/utils/pg_crc.h include/postgresql/server/utils/pg_locale.h include/postgresql/server/utils/pg_lzcompress.h +include/postgresql/server/utils/pg_rusage.h include/postgresql/server/utils/portal.h include/postgresql/server/utils/ps_status.h include/postgresql/server/utils/rel.h diff --git a/databases/postgresql83-server/pkg-plist-contrib b/databases/postgresql83-server/pkg-plist-contrib index fd3f553e5b25..aba5a7b1cc19 100644 --- a/databases/postgresql83-server/pkg-plist-contrib +++ b/databases/postgresql83-server/pkg-plist-contrib @@ -1,25 +1,17 @@ bin/DBMirror.pl bin/clean_pending.pl bin/dbf2pg -bin/findoidjoins bin/fti.pl -bin/ipc_check -bin/make_oidjoins_check -bin/my2pg.pl -bin/mysql2pgsql bin/oid2name -bin/pg_autovacuum -bin/pg_dumplo bin/pgbench -bin/reindexdb bin/vacuumlo lib/postgresql/_int.so lib/postgresql/autoinc.so lib/postgresql/btree_gist.so +lib/postgresql/pg_buffercache.so lib/postgresql/chkpass.so lib/postgresql/cube.so lib/postgresql/dblink.so -lib/postgresql/dbsize.so lib/postgresql/earthdistance.so lib/postgresql/fti.so lib/postgresql/fuzzystrmatch.so @@ -28,20 +20,15 @@ lib/postgresql/int_aggregate.so lib/postgresql/isbn_issn.so lib/postgresql/lo.so lib/postgresql/ltree.so -lib/postgresql/misc_utils.so lib/postgresql/moddatetime.so -lib/postgresql/noup.so lib/postgresql/pending.so lib/postgresql/pg_trgm.so lib/postgresql/pgcrypto.so lib/postgresql/pgstattuple.so lib/postgresql/refint.so -lib/postgresql/rtree_gist.so lib/postgresql/seg.so -lib/postgresql/string_io.so lib/postgresql/tablefunc.so lib/postgresql/timetravel.so -lib/postgresql/tsearch.so lib/postgresql/tsearch2.so lib/postgresql/user_locks.so %%DOCSDIR%%/README-contrib @@ -53,37 +40,26 @@ lib/postgresql/user_locks.so %%DOCSDIR%%/contrib/README.dbf2pg %%DOCSDIR%%/contrib/README.dblink %%DOCSDIR%%/contrib/README.dbmirror -%%DOCSDIR%%/contrib/README.dbsize %%DOCSDIR%%/contrib/README.earthdistance -%%DOCSDIR%%/contrib/README.findoidjoins %%DOCSDIR%%/contrib/README.fti %%DOCSDIR%%/contrib/README.fuzzystrmatch %%DOCSDIR%%/contrib/README.int_aggregate %%DOCSDIR%%/contrib/README.intarray -%%DOCSDIR%%/contrib/README.ipc_check %%DOCSDIR%%/contrib/README.isbn_issn %%DOCSDIR%%/contrib/README.lo %%DOCSDIR%%/contrib/README.ltree -%%DOCSDIR%%/contrib/README.misc_utils -%%DOCSDIR%%/contrib/README.mysql -%%DOCSDIR%%/contrib/README.noup %%DOCSDIR%%/contrib/README.oid2name -%%DOCSDIR%%/contrib/README.pg_autovacuum -%%DOCSDIR%%/contrib/README.pg_dumplo +%%DOCSDIR%%/contrib/README.pg_buffercache %%DOCSDIR%%/contrib/README.pg_trgm %%DOCSDIR%%/contrib/README.pgbench %%DOCSDIR%%/contrib/README.pgbench_jis %%DOCSDIR%%/contrib/README.pgcrypto %%DOCSDIR%%/contrib/README.pgstattuple %%DOCSDIR%%/contrib/README.pgstattuple.euc_jp -%%DOCSDIR%%/contrib/README.reindexdb -%%DOCSDIR%%/contrib/README.rtree_gist %%DOCSDIR%%/contrib/README.seg %%DOCSDIR%%/contrib/README.soundex %%DOCSDIR%%/contrib/README.spi -%%DOCSDIR%%/contrib/README.string_io %%DOCSDIR%%/contrib/README.tablefunc -%%DOCSDIR%%/contrib/README.tsearch %%DOCSDIR%%/contrib/README.tsearch2 %%DOCSDIR%%/contrib/README.user_locks %%DOCSDIR%%/contrib/README.vacuumlo @@ -100,7 +76,6 @@ share/postgresql/contrib/btree_gist.sql share/postgresql/contrib/chkpass.sql share/postgresql/contrib/cube.sql share/postgresql/contrib/dblink.sql -share/postgresql/contrib/dbsize.sql share/postgresql/contrib/earthdistance.sql share/postgresql/contrib/english.stop share/postgresql/contrib/fti.sql @@ -112,21 +87,17 @@ share/postgresql/contrib/lo.sql share/postgresql/contrib/lo_drop.sql share/postgresql/contrib/lo_test.sql share/postgresql/contrib/ltree.sql -share/postgresql/contrib/misc_utils.sql share/postgresql/contrib/moddatetime.sql -share/postgresql/contrib/noup.sql +share/postgresql/contrib/pg_buffercache.sql share/postgresql/contrib/pg_trgm.sql share/postgresql/contrib/pgcrypto.sql share/postgresql/contrib/pgstattuple.sql share/postgresql/contrib/refint.sql -share/postgresql/contrib/rtree_gist.sql share/postgresql/contrib/russian.stop share/postgresql/contrib/seg.sql share/postgresql/contrib/slaveDatabase.conf -share/postgresql/contrib/string_io.sql share/postgresql/contrib/tablefunc.sql share/postgresql/contrib/timetravel.sql -share/postgresql/contrib/tsearch.sql share/postgresql/contrib/tsearch2.sql share/postgresql/contrib/untsearch2.sql share/postgresql/contrib/user_locks.sql diff --git a/databases/postgresql83-server/pkg-plist-server b/databases/postgresql83-server/pkg-plist-server index 24cff6b753f0..9c00caef50c8 100644 --- a/databases/postgresql83-server/pkg-plist-server +++ b/databases/postgresql83-server/pkg-plist-server @@ -24,10 +24,11 @@ lib/postgresql/utf8_and_iso8859.so lib/postgresql/utf8_and_iso8859_1.so lib/postgresql/utf8_and_johab.so lib/postgresql/utf8_and_sjis.so -lib/postgresql/utf8_and_tcvn.so lib/postgresql/utf8_and_uhc.so lib/postgresql/utf8_and_win1250.so +lib/postgresql/utf8_and_win1252.so lib/postgresql/utf8_and_win1256.so +lib/postgresql/utf8_and_win1258.so lib/postgresql/utf8_and_win874.so lib/postgresql/plpgsql.so %%DOCSDIR%%/README-server @@ -246,6 +247,7 @@ share/postgresql/timezone/Asia/Ujung_Pandang share/postgresql/timezone/Asia/Tel_Aviv share/postgresql/timezone/Asia/Thimbu share/postgresql/timezone/Asia/Ulan_Bator +share/postgresql/timezone/Australia/Currie share/postgresql/timezone/Australia/Darwin share/postgresql/timezone/Australia/Perth share/postgresql/timezone/Australia/Brisbane @@ -365,6 +367,7 @@ share/postgresql/timezone/CET share/postgresql/timezone/MET share/postgresql/timezone/EET share/postgresql/timezone/America/Danmarkshavn +share/postgresql/timezone/America/Coral_Harbour share/postgresql/timezone/America/Scoresbysund share/postgresql/timezone/America/Godthab share/postgresql/timezone/America/Thule diff --git a/databases/postgresql84-server/Makefile b/databases/postgresql84-server/Makefile index ac0672bbd051..4398586e3e22 100644 --- a/databases/postgresql84-server/Makefile +++ b/databases/postgresql84-server/Makefile @@ -7,7 +7,7 @@ PORTNAME?= postgresql PKGNAMESUFFIX?= -server -PORTVERSION?= 8.0.3 +PORTVERSION?= 8.1.0 PORTREVISION?= 0 CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_PGSQL} @@ -21,8 +21,6 @@ COMMENT?= The most advanced open-source database available anywhere CONFLICTS?= ${PORTNAME}-client-7.[0-9]* \ ${PORTNAME}${PKGNAMESUFFIX}-7.[0-9]* -BROKEN= Work in progress, nothing to see, please move along... - WRKSRC= ${WRKDIR}/postgresql-${PORTVERSION} DIST_SUBDIR= postgresql @@ -97,24 +95,25 @@ OPTIONS+= DEBUG "Builds with debugging symbols" off OPTIONS+= ICU "Use ICU for unicode collation (server)" off # See http://gppl.moonbone.ru/ for more info -OPTIONS+= HIER "Builds with query hierarchy (server)" off +#OPTIONS+= HIER "Builds with query hierarchy (server)" off # See http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/76999 for more info # (requires dump/restore if modified.) OPTIONS+= INTDATE "Builds with 64-bit date/time type (server)" off . if defined(SERVER_ONLY) && defined(WITH_HIER) +BROKEN= no HIER patch for 8.1 series exists PATCH_SITES+= http://gppl.moonbone.ru/:hier801054 PATCHFILES+= hier-Pg8.0.1-0.5.4.diff.gz:hier801054 USE_BISON= yes . endif . if defined(SERVER_ONLY) && defined(WITH_ICU) -USE_AUTOCONF_VER=253 +USE_AUTOCONF_VER=259 CONFIGURE_ARGS+=--with-icu -LIB_DEPENDS= icudata.32:${PORTSDIR}/devel/icu +LIB_DEPENDS= icudata.34:${PORTSDIR}/devel/icu PATCH_SITES+= http://people.freebsd.org/~girgen/postgresql-icu/:icu -PATCHFILES+= pg-803-icu-2005-08-16.diff.gz:icu +PATCHFILES+= pg-810-icu-34-2005-11-09.diff.gz:icu . endif PATCH_DIST_STRIP=-p1 @@ -152,6 +151,9 @@ INSTALL_TARGET= install-strip . endif . if defined(WITH_MIT_KRB5) +. if exists(/usr/lib/libkrb5.so) +BROKEN= "You must remove heimdal's /usr/lib/libkrb5.so* to build successfully with MIT-KRB" +. endif WITH_KRB5= yes KRB5_HOME?= ${LOCALBASE} KRB5CONF= ${KRB5_HOME}/bin/krb5-config @@ -160,20 +162,17 @@ LIB_DEPENDS+= krb5.3:${PORTSDIR}/security/krb5 . if defined(WITH_HEIMDAL_KRB5) WITH_KRB5= yes -. if defined(HEIMDAL_HOME) && exists(${HEIMDAL_HOME}/lib/libgssapi.a) -KRB5CONF= ${HEIMDAL_HOME}/bin/krb5-config -. elif ( defined(MAKE_KERBEROS5) || ${OSVERSION} > 500105 ) && exists(${DESTDIR}/usr/lib/libkrb5.a) -KRB5CONF= ${DESTDIR}/usr/bin/krb5-config -. else +# Base heimdal in /usr will not link properly with postgresql, we must +# use the port. See +# http://lists.freebsd.org/pipermail/freebsd-stable/2005-October/018809.html LIB_DEPENDS+= krb5:${PORTSDIR}/security/heimdal KRB5CONF= ${LOCALBASE}/bin/krb5-config -. endif . endif . if defined(WITH_KRB5) CONFIGURE_ARGS+= --with-krb5 -LDFLAGS+= `${KRB5CONF} --libs krb5` -CONFIGURE_ENV+= LDFLAGS="${LDFLAGS}" +LIBS= `${KRB5CONF} --libs krb5` +CONFIGURE_ENV+= LIBS="${LIBS}" . endif . if defined(SERVER_ONLY) && defined(WITH_TESTS) @@ -196,19 +195,22 @@ MAN1= clusterdb.1 createdb.1 createlang.1 createuser.1 \ dropdb.1 droplang.1 dropuser.1 ecpg.1 initdb.1 \ ipcclean.1 pg_config.1 pg_controldata.1 pg_ctl.1 \ pg_dump.1 pg_dumpall.1 pg_resetxlog.1 pg_restore.1 \ - postgres.1 postmaster.1 psql.1 vacuumdb.1 + postgres.1 postmaster.1 psql.1 reindexdb.1 vacuumdb.1 MAN7= abort.7 alter_aggregate.7 alter_conversion.7 alter_database.7 \ alter_domain.7 alter_function.7 alter_group.7 \ alter_index.7 alter_language.7 alter_operator_class.7 \ + alter_role.7 \ alter_schema.7 alter_sequence.7 alter_table.7 \ alter_trigger.7 alter_user.7 analyze.7 begin.7 \ checkpoint.7 close.7 cluster.7 comment.7 commit.7 \ + commit_prepared.7 \ copy.7 create_aggregate.7 create_cast.7 \ create_constraint_trigger.7 create_conversion.7 \ create_database.7 create_domain.7 create_function.7 \ create_group.7 create_index.7 create_language.7 \ create_operator.7 create_operator_class.7 \ + create_role.7 \ create_rule.7 create_schema.7 create_sequence.7 \ create_table.7 create_table_as.7 create_trigger.7 \ create_type.7 create_user.7 create_view.7 deallocate.7 \ @@ -216,25 +218,17 @@ MAN7= abort.7 alter_aggregate.7 alter_conversion.7 alter_database.7 \ drop_aggregate.7 drop_cast.7 drop_conversion.7 \ drop_database.7 drop_domain.7 drop_function.7 \ drop_group.7 drop_index.7 drop_language.7 \ - drop_operator.7 drop_operator_class.7 drop_rule.7 \ + drop_operator.7 drop_operator_class.7 drop_role.7 \ + drop_rule.7 \ drop_schema.7 drop_sequence.7 drop_table.7 drop_trigger.7 \ drop_type.7 drop_user.7 drop_view.7 end.7 execute.7 \ explain.7 fetch.7 grant.7 insert.7 listen.7 load.7 \ - lock.7 move.7 notify.7 prepare.7 reindex.7 reset.7 \ - revoke.7 rollback.7 select.7 select_into.7 set.7 \ - set_constraints.7 set_transaction.7 show.7 \ + lock.7 move.7 notify.7 prepare.7 prepare_transaction.7 \ + reindex.7 reset.7 \ + revoke.7 rollback.7 rollback_prepared.7 select.7 \ + select_into.7 set.7 \ + set_constraints.7 set_role.7 set_transaction.7 show.7 \ set_session_authorization.7 start_transaction.7 \ - spi_connect.7 spi_copytuple.7 spi_cursor_close.7 \ - spi_cursor_fetch.7 spi_cursor_find.7 spi_cursor_move.7 \ - spi_cursor_open.7 spi_exec.7 spi_execp.7 spi_execute.7 \ - spi_execute_plan.7 \ - spi_finish.7 spi_fname.7 spi_fnumber.7 spi_freeplan.7 \ - spi_freetuple.7 spi_freetuptable.7 spi_getargcount.7 \ - spi_getargtypeid.7 spi_getbinval.7 spi_getrelname.7 \ - spi_gettype.7 spi_gettypeid.7 spi_getvalue.7 \ - spi_is_cursor_plan.7 spi_modifytuple.7 spi_palloc.7 \ - spi_pfree.7 spi_pop.7 spi_prepare.7 spi_push.7 \ - spi_repalloc.7 spi_returntuple.7 spi_saveplan.7 \ truncate.7 unlisten.7 update.7 vacuum.7 \ alter_operator.7 alter_tablespace.7 alter_type.7 \ create_tablespace.7 drop_tablespace.7 \ diff --git a/databases/postgresql84-server/distinfo b/databases/postgresql84-server/distinfo index 0a61ebc5441a..df22506b50e5 100644 --- a/databases/postgresql84-server/distinfo +++ b/databases/postgresql84-server/distinfo @@ -1,12 +1,15 @@ -MD5 (postgresql/postgresql-base-8.0.3.tar.bz2) = 35ff2b9a3bc5c65f55b4192a334b0e88 -SIZE (postgresql/postgresql-base-8.0.3.tar.bz2) = 7818251 -MD5 (postgresql/postgresql-docs-8.0.3.tar.bz2) = a9bb1e0dbc7ff862a30b6b9ca00b6470 -SIZE (postgresql/postgresql-docs-8.0.3.tar.bz2) = 2213693 -MD5 (postgresql/postgresql-opt-8.0.3.tar.bz2) = ea1ce6f570a4408e934af914de71da0e -SIZE (postgresql/postgresql-opt-8.0.3.tar.bz2) = 133623 -MD5 (postgresql/postgresql-test-8.0.3.tar.bz2) = 4dac47d2c87bb83ba6f2cd788ec794a6 -SIZE (postgresql/postgresql-test-8.0.3.tar.bz2) = 959642 -MD5 (postgresql/hier-Pg8.0.1-0.5.4.diff.gz) = 1d410cfb38253675fee36c8f9ee655e2 -SIZE (postgresql/hier-Pg8.0.1-0.5.4.diff.gz) = 30662 -MD5 (postgresql/pg-803-icu-2005-08-16.diff.gz) = 83cb174132c5dd7aeec622bc5c9a8b0d -SIZE (postgresql/pg-803-icu-2005-08-16.diff.gz) = 4190 +MD5 (postgresql/postgresql-base-8.1.0.tar.bz2) = 61ada6238aebbe6f3850895af25df37b +SHA256 (postgresql/postgresql-base-8.1.0.tar.bz2) = 604b6be364d88a2d0b0a4bae2165be0072bb8e79129c874f9a7fa1734dc8cb38 +SIZE (postgresql/postgresql-base-8.1.0.tar.bz2) = 8027880 +MD5 (postgresql/postgresql-docs-8.1.0.tar.bz2) = 544a41caa516cd9c6a07fa5d604a91bd +SHA256 (postgresql/postgresql-docs-8.1.0.tar.bz2) = 9ef412d3859646ec6d3478cd828c395e56610cc7a54daa18381da53153847d7b +SIZE (postgresql/postgresql-docs-8.1.0.tar.bz2) = 2443376 +MD5 (postgresql/postgresql-opt-8.1.0.tar.bz2) = 5fd9e43abc22e6af1ca819e43eb1fbd2 +SHA256 (postgresql/postgresql-opt-8.1.0.tar.bz2) = a9dbb375428f2250e7fcb5e66be2eaf3b87644f33f36b195b0d87ad91432bb40 +SIZE (postgresql/postgresql-opt-8.1.0.tar.bz2) = 141420 +MD5 (postgresql/postgresql-test-8.1.0.tar.bz2) = 594b045aa80aef1907bbd6b922a1e02b +SHA256 (postgresql/postgresql-test-8.1.0.tar.bz2) = 1fd3b5fb35d39b0fe703124b982cf4b10d6495f99eb3519cb2c59134a8bfcb2f +SIZE (postgresql/postgresql-test-8.1.0.tar.bz2) = 968672 +MD5 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = b1f6f40f6fcc887f35d57bb7aee2ed09 +SHA256 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 714d030be73d3df1fd5f47409e0b059ef1d04ad9cb56255b5d803f25b8c93f1a +SIZE (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 3956 diff --git a/databases/postgresql84-server/files/patch-src-makefiles-Makefile.freebsd b/databases/postgresql84-server/files/patch-src-makefiles-Makefile.freebsd index 89aaa9a2c0cc..81339e98e8db 100644 --- a/databases/postgresql84-server/files/patch-src-makefiles-Makefile.freebsd +++ b/databases/postgresql84-server/files/patch-src-makefiles-Makefile.freebsd @@ -1,14 +1,5 @@ --- src/makefiles/Makefile.freebsd.orig Fri Nov 19 01:41:39 2004 +++ src/makefiles/Makefile.freebsd Tue Dec 21 02:44:09 2004 -@@ -11,7 +11,7 @@ - ifeq ($(findstring sparc,$(host_cpu)), sparc) - CFLAGS_SL = -fPIC -DPIC - else --CFLAGS_SL = -fpic -DPIC -+CFLAGS_SL = -fPIC -DPIC - endif - - @@ -29,3 +29,5 @@ endif diff --git a/databases/postgresql84-server/files/patch-src:backend:utils:misc:postgresql.conf.sample b/databases/postgresql84-server/files/patch-src:backend:utils:misc:postgresql.conf.sample index 07363e882113..da57f46e3552 100644 --- a/databases/postgresql84-server/files/patch-src:backend:utils:misc:postgresql.conf.sample +++ b/databases/postgresql84-server/files/patch-src:backend:utils:misc:postgresql.conf.sample @@ -1,18 +1,18 @@ ---- src/backend/utils/misc/postgresql.conf.sample~ Fri Nov 5 20:16:16 2004 -+++ src/backend/utils/misc/postgresql.conf.sample Tue Dec 21 02:06:45 2004 -@@ -172,6 +172,7 @@ +--- src/backend/utils/misc/postgresql.conf.sample~ Tue Nov 8 00:45:49 2005 ++++ src/backend/utils/misc/postgresql.conf.sample Tue Nov 8 00:47:16 2005 +@@ -206,6 +206,7 @@ # - Where to Log - +log_destination = 'syslog' - #log_destination = 'stderr' # Valid values are combinations of stderr, - # syslog and eventlog, depending on - # platform. -@@ -219,6 +220,7 @@ - - #log_min_duration_statement = -1 # -1 is disabled, in milliseconds. + #log_destination = 'stderr' # Valid values are combinations of + # stderr, syslog and eventlog, + # depending on platform. +@@ -283,6 +284,7 @@ + #log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements + # and their durations, in milliseconds. -+silent_mode = true - #silent_mode = false # DO NOT USE without syslog or redirect_stderr ++silent_mode = on + #silent_mode = off # DO NOT USE without syslog or + # redirect_stderr - # - What to Log - diff --git a/databases/postgresql84-server/pkg-plist-client b/databases/postgresql84-server/pkg-plist-client index 5810e57ecead..cda05962118f 100644 --- a/databases/postgresql84-server/pkg-plist-client +++ b/databases/postgresql84-server/pkg-plist-client @@ -16,19 +16,21 @@ bin/pg_dumpall bin/pg_resetxlog bin/pg_restore bin/psql +bin/reindexdb bin/vacuumdb include/postgresql/server/access/attnum.h include/postgresql/server/access/clog.h include/postgresql/server/access/genam.h include/postgresql/server/access/gist.h +include/postgresql/server/access/gist_private.h include/postgresql/server/access/gistscan.h include/postgresql/server/access/hash.h include/postgresql/server/access/heapam.h include/postgresql/server/access/hio.h include/postgresql/server/access/htup.h -include/postgresql/server/access/ibit.h include/postgresql/server/access/iqual.h include/postgresql/server/access/itup.h +include/postgresql/server/access/multixact.h include/postgresql/server/access/nbtree.h include/postgresql/server/access/printtup.h include/postgresql/server/access/relscan.h @@ -43,6 +45,8 @@ include/postgresql/server/access/transam.h include/postgresql/server/access/tupdesc.h include/postgresql/server/access/tupmacs.h include/postgresql/server/access/tuptoaster.h +include/postgresql/server/access/twophase.h +include/postgresql/server/access/twophase_rmgr.h include/postgresql/server/access/valid.h include/postgresql/server/access/xact.h include/postgresql/server/access/xlog.h @@ -52,7 +56,6 @@ include/postgresql/server/access/xlogutils.h include/postgresql/server/bootstrap/bootstrap.h include/postgresql/server/c.h include/postgresql/server/catalog/catalog.h -include/postgresql/server/catalog/catname.h include/postgresql/server/catalog/catversion.h include/postgresql/server/catalog/dependency.h include/postgresql/server/catalog/heap.h @@ -65,6 +68,9 @@ include/postgresql/server/catalog/pg_amop.h include/postgresql/server/catalog/pg_amproc.h include/postgresql/server/catalog/pg_attrdef.h include/postgresql/server/catalog/pg_attribute.h +include/postgresql/server/catalog/pg_auth_members.h +include/postgresql/server/catalog/pg_authid.h +include/postgresql/server/catalog/pg_autovacuum.h include/postgresql/server/catalog/pg_cast.h include/postgresql/server/catalog/pg_class.h include/postgresql/server/catalog/pg_constraint.h @@ -73,7 +79,6 @@ include/postgresql/server/catalog/pg_conversion.h include/postgresql/server/catalog/pg_database.h include/postgresql/server/catalog/pg_depend.h include/postgresql/server/catalog/pg_description.h -include/postgresql/server/catalog/pg_group.h include/postgresql/server/catalog/pg_index.h include/postgresql/server/catalog/pg_inherits.h include/postgresql/server/catalog/pg_language.h @@ -82,14 +87,14 @@ include/postgresql/server/catalog/pg_listener.h include/postgresql/server/catalog/pg_namespace.h include/postgresql/server/catalog/pg_opclass.h include/postgresql/server/catalog/pg_operator.h +include/postgresql/server/catalog/pg_pltemplate.h include/postgresql/server/catalog/pg_proc.h include/postgresql/server/catalog/pg_rewrite.h -include/postgresql/server/catalog/pg_shadow.h +include/postgresql/server/catalog/pg_shdepend.h include/postgresql/server/catalog/pg_statistic.h include/postgresql/server/catalog/pg_tablespace.h include/postgresql/server/catalog/pg_trigger.h include/postgresql/server/catalog/pg_type.h -include/postgresql/server/catalog/pg_version.h include/postgresql/server/commands/alter.h include/postgresql/server/commands/async.h include/postgresql/server/commands/cluster.h @@ -124,6 +129,10 @@ include/postgresql/server/executor/hashjoin.h include/postgresql/server/executor/instrument.h include/postgresql/server/executor/nodeAgg.h include/postgresql/server/executor/nodeAppend.h +include/postgresql/server/executor/nodeBitmapAnd.h +include/postgresql/server/executor/nodeBitmapHeapscan.h +include/postgresql/server/executor/nodeBitmapIndexscan.h +include/postgresql/server/executor/nodeBitmapOr.h include/postgresql/server/executor/nodeFunctionscan.h include/postgresql/server/executor/nodeGroup.h include/postgresql/server/executor/nodeHash.h @@ -178,6 +187,7 @@ include/postgresql/server/nodes/primnodes.h include/postgresql/server/nodes/print.h include/postgresql/server/nodes/readfuncs.h include/postgresql/server/nodes/relation.h +include/postgresql/server/nodes/tidbitmap.h include/postgresql/server/nodes/value.h include/postgresql/server/optimizer/clauses.h include/postgresql/server/optimizer/cost.h @@ -196,6 +206,7 @@ include/postgresql/server/optimizer/paths.h include/postgresql/server/optimizer/plancat.h include/postgresql/server/optimizer/planmain.h include/postgresql/server/optimizer/planner.h +include/postgresql/server/optimizer/predtest.h include/postgresql/server/optimizer/prep.h include/postgresql/server/optimizer/restrictinfo.h include/postgresql/server/optimizer/subselect.h @@ -293,6 +304,7 @@ include/postgresql/server/storage/pg_shmem.h include/postgresql/server/storage/pmsignal.h include/postgresql/server/storage/pos.h include/postgresql/server/storage/proc.h +include/postgresql/server/storage/procarray.h include/postgresql/server/storage/relfilenode.h include/postgresql/server/storage/s_lock.h include/postgresql/server/storage/shmem.h @@ -320,6 +332,7 @@ include/postgresql/server/utils/dynahash.h include/postgresql/server/utils/dynamic_loader.h include/postgresql/server/utils/elog.h include/postgresql/server/utils/errcodes.h +include/postgresql/server/utils/flatfiles.h include/postgresql/server/utils/fmgroids.h include/postgresql/server/utils/fmgrtab.h include/postgresql/server/utils/formatting.h @@ -340,6 +353,7 @@ include/postgresql/server/utils/palloc.h include/postgresql/server/utils/pg_crc.h include/postgresql/server/utils/pg_locale.h include/postgresql/server/utils/pg_lzcompress.h +include/postgresql/server/utils/pg_rusage.h include/postgresql/server/utils/portal.h include/postgresql/server/utils/ps_status.h include/postgresql/server/utils/rel.h diff --git a/databases/postgresql84-server/pkg-plist-contrib b/databases/postgresql84-server/pkg-plist-contrib index fd3f553e5b25..aba5a7b1cc19 100644 --- a/databases/postgresql84-server/pkg-plist-contrib +++ b/databases/postgresql84-server/pkg-plist-contrib @@ -1,25 +1,17 @@ bin/DBMirror.pl bin/clean_pending.pl bin/dbf2pg -bin/findoidjoins bin/fti.pl -bin/ipc_check -bin/make_oidjoins_check -bin/my2pg.pl -bin/mysql2pgsql bin/oid2name -bin/pg_autovacuum -bin/pg_dumplo bin/pgbench -bin/reindexdb bin/vacuumlo lib/postgresql/_int.so lib/postgresql/autoinc.so lib/postgresql/btree_gist.so +lib/postgresql/pg_buffercache.so lib/postgresql/chkpass.so lib/postgresql/cube.so lib/postgresql/dblink.so -lib/postgresql/dbsize.so lib/postgresql/earthdistance.so lib/postgresql/fti.so lib/postgresql/fuzzystrmatch.so @@ -28,20 +20,15 @@ lib/postgresql/int_aggregate.so lib/postgresql/isbn_issn.so lib/postgresql/lo.so lib/postgresql/ltree.so -lib/postgresql/misc_utils.so lib/postgresql/moddatetime.so -lib/postgresql/noup.so lib/postgresql/pending.so lib/postgresql/pg_trgm.so lib/postgresql/pgcrypto.so lib/postgresql/pgstattuple.so lib/postgresql/refint.so -lib/postgresql/rtree_gist.so lib/postgresql/seg.so -lib/postgresql/string_io.so lib/postgresql/tablefunc.so lib/postgresql/timetravel.so -lib/postgresql/tsearch.so lib/postgresql/tsearch2.so lib/postgresql/user_locks.so %%DOCSDIR%%/README-contrib @@ -53,37 +40,26 @@ lib/postgresql/user_locks.so %%DOCSDIR%%/contrib/README.dbf2pg %%DOCSDIR%%/contrib/README.dblink %%DOCSDIR%%/contrib/README.dbmirror -%%DOCSDIR%%/contrib/README.dbsize %%DOCSDIR%%/contrib/README.earthdistance -%%DOCSDIR%%/contrib/README.findoidjoins %%DOCSDIR%%/contrib/README.fti %%DOCSDIR%%/contrib/README.fuzzystrmatch %%DOCSDIR%%/contrib/README.int_aggregate %%DOCSDIR%%/contrib/README.intarray -%%DOCSDIR%%/contrib/README.ipc_check %%DOCSDIR%%/contrib/README.isbn_issn %%DOCSDIR%%/contrib/README.lo %%DOCSDIR%%/contrib/README.ltree -%%DOCSDIR%%/contrib/README.misc_utils -%%DOCSDIR%%/contrib/README.mysql -%%DOCSDIR%%/contrib/README.noup %%DOCSDIR%%/contrib/README.oid2name -%%DOCSDIR%%/contrib/README.pg_autovacuum -%%DOCSDIR%%/contrib/README.pg_dumplo +%%DOCSDIR%%/contrib/README.pg_buffercache %%DOCSDIR%%/contrib/README.pg_trgm %%DOCSDIR%%/contrib/README.pgbench %%DOCSDIR%%/contrib/README.pgbench_jis %%DOCSDIR%%/contrib/README.pgcrypto %%DOCSDIR%%/contrib/README.pgstattuple %%DOCSDIR%%/contrib/README.pgstattuple.euc_jp -%%DOCSDIR%%/contrib/README.reindexdb -%%DOCSDIR%%/contrib/README.rtree_gist %%DOCSDIR%%/contrib/README.seg %%DOCSDIR%%/contrib/README.soundex %%DOCSDIR%%/contrib/README.spi -%%DOCSDIR%%/contrib/README.string_io %%DOCSDIR%%/contrib/README.tablefunc -%%DOCSDIR%%/contrib/README.tsearch %%DOCSDIR%%/contrib/README.tsearch2 %%DOCSDIR%%/contrib/README.user_locks %%DOCSDIR%%/contrib/README.vacuumlo @@ -100,7 +76,6 @@ share/postgresql/contrib/btree_gist.sql share/postgresql/contrib/chkpass.sql share/postgresql/contrib/cube.sql share/postgresql/contrib/dblink.sql -share/postgresql/contrib/dbsize.sql share/postgresql/contrib/earthdistance.sql share/postgresql/contrib/english.stop share/postgresql/contrib/fti.sql @@ -112,21 +87,17 @@ share/postgresql/contrib/lo.sql share/postgresql/contrib/lo_drop.sql share/postgresql/contrib/lo_test.sql share/postgresql/contrib/ltree.sql -share/postgresql/contrib/misc_utils.sql share/postgresql/contrib/moddatetime.sql -share/postgresql/contrib/noup.sql +share/postgresql/contrib/pg_buffercache.sql share/postgresql/contrib/pg_trgm.sql share/postgresql/contrib/pgcrypto.sql share/postgresql/contrib/pgstattuple.sql share/postgresql/contrib/refint.sql -share/postgresql/contrib/rtree_gist.sql share/postgresql/contrib/russian.stop share/postgresql/contrib/seg.sql share/postgresql/contrib/slaveDatabase.conf -share/postgresql/contrib/string_io.sql share/postgresql/contrib/tablefunc.sql share/postgresql/contrib/timetravel.sql -share/postgresql/contrib/tsearch.sql share/postgresql/contrib/tsearch2.sql share/postgresql/contrib/untsearch2.sql share/postgresql/contrib/user_locks.sql diff --git a/databases/postgresql84-server/pkg-plist-server b/databases/postgresql84-server/pkg-plist-server index 24cff6b753f0..9c00caef50c8 100644 --- a/databases/postgresql84-server/pkg-plist-server +++ b/databases/postgresql84-server/pkg-plist-server @@ -24,10 +24,11 @@ lib/postgresql/utf8_and_iso8859.so lib/postgresql/utf8_and_iso8859_1.so lib/postgresql/utf8_and_johab.so lib/postgresql/utf8_and_sjis.so -lib/postgresql/utf8_and_tcvn.so lib/postgresql/utf8_and_uhc.so lib/postgresql/utf8_and_win1250.so +lib/postgresql/utf8_and_win1252.so lib/postgresql/utf8_and_win1256.so +lib/postgresql/utf8_and_win1258.so lib/postgresql/utf8_and_win874.so lib/postgresql/plpgsql.so %%DOCSDIR%%/README-server @@ -246,6 +247,7 @@ share/postgresql/timezone/Asia/Ujung_Pandang share/postgresql/timezone/Asia/Tel_Aviv share/postgresql/timezone/Asia/Thimbu share/postgresql/timezone/Asia/Ulan_Bator +share/postgresql/timezone/Australia/Currie share/postgresql/timezone/Australia/Darwin share/postgresql/timezone/Australia/Perth share/postgresql/timezone/Australia/Brisbane @@ -365,6 +367,7 @@ share/postgresql/timezone/CET share/postgresql/timezone/MET share/postgresql/timezone/EET share/postgresql/timezone/America/Danmarkshavn +share/postgresql/timezone/America/Coral_Harbour share/postgresql/timezone/America/Scoresbysund share/postgresql/timezone/America/Godthab share/postgresql/timezone/America/Thule diff --git a/databases/postgresql90-server/Makefile b/databases/postgresql90-server/Makefile index ac0672bbd051..4398586e3e22 100644 --- a/databases/postgresql90-server/Makefile +++ b/databases/postgresql90-server/Makefile @@ -7,7 +7,7 @@ PORTNAME?= postgresql PKGNAMESUFFIX?= -server -PORTVERSION?= 8.0.3 +PORTVERSION?= 8.1.0 PORTREVISION?= 0 CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_PGSQL} @@ -21,8 +21,6 @@ COMMENT?= The most advanced open-source database available anywhere CONFLICTS?= ${PORTNAME}-client-7.[0-9]* \ ${PORTNAME}${PKGNAMESUFFIX}-7.[0-9]* -BROKEN= Work in progress, nothing to see, please move along... - WRKSRC= ${WRKDIR}/postgresql-${PORTVERSION} DIST_SUBDIR= postgresql @@ -97,24 +95,25 @@ OPTIONS+= DEBUG "Builds with debugging symbols" off OPTIONS+= ICU "Use ICU for unicode collation (server)" off # See http://gppl.moonbone.ru/ for more info -OPTIONS+= HIER "Builds with query hierarchy (server)" off +#OPTIONS+= HIER "Builds with query hierarchy (server)" off # See http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/76999 for more info # (requires dump/restore if modified.) OPTIONS+= INTDATE "Builds with 64-bit date/time type (server)" off . if defined(SERVER_ONLY) && defined(WITH_HIER) +BROKEN= no HIER patch for 8.1 series exists PATCH_SITES+= http://gppl.moonbone.ru/:hier801054 PATCHFILES+= hier-Pg8.0.1-0.5.4.diff.gz:hier801054 USE_BISON= yes . endif . if defined(SERVER_ONLY) && defined(WITH_ICU) -USE_AUTOCONF_VER=253 +USE_AUTOCONF_VER=259 CONFIGURE_ARGS+=--with-icu -LIB_DEPENDS= icudata.32:${PORTSDIR}/devel/icu +LIB_DEPENDS= icudata.34:${PORTSDIR}/devel/icu PATCH_SITES+= http://people.freebsd.org/~girgen/postgresql-icu/:icu -PATCHFILES+= pg-803-icu-2005-08-16.diff.gz:icu +PATCHFILES+= pg-810-icu-34-2005-11-09.diff.gz:icu . endif PATCH_DIST_STRIP=-p1 @@ -152,6 +151,9 @@ INSTALL_TARGET= install-strip . endif . if defined(WITH_MIT_KRB5) +. if exists(/usr/lib/libkrb5.so) +BROKEN= "You must remove heimdal's /usr/lib/libkrb5.so* to build successfully with MIT-KRB" +. endif WITH_KRB5= yes KRB5_HOME?= ${LOCALBASE} KRB5CONF= ${KRB5_HOME}/bin/krb5-config @@ -160,20 +162,17 @@ LIB_DEPENDS+= krb5.3:${PORTSDIR}/security/krb5 . if defined(WITH_HEIMDAL_KRB5) WITH_KRB5= yes -. if defined(HEIMDAL_HOME) && exists(${HEIMDAL_HOME}/lib/libgssapi.a) -KRB5CONF= ${HEIMDAL_HOME}/bin/krb5-config -. elif ( defined(MAKE_KERBEROS5) || ${OSVERSION} > 500105 ) && exists(${DESTDIR}/usr/lib/libkrb5.a) -KRB5CONF= ${DESTDIR}/usr/bin/krb5-config -. else +# Base heimdal in /usr will not link properly with postgresql, we must +# use the port. See +# http://lists.freebsd.org/pipermail/freebsd-stable/2005-October/018809.html LIB_DEPENDS+= krb5:${PORTSDIR}/security/heimdal KRB5CONF= ${LOCALBASE}/bin/krb5-config -. endif . endif . if defined(WITH_KRB5) CONFIGURE_ARGS+= --with-krb5 -LDFLAGS+= `${KRB5CONF} --libs krb5` -CONFIGURE_ENV+= LDFLAGS="${LDFLAGS}" +LIBS= `${KRB5CONF} --libs krb5` +CONFIGURE_ENV+= LIBS="${LIBS}" . endif . if defined(SERVER_ONLY) && defined(WITH_TESTS) @@ -196,19 +195,22 @@ MAN1= clusterdb.1 createdb.1 createlang.1 createuser.1 \ dropdb.1 droplang.1 dropuser.1 ecpg.1 initdb.1 \ ipcclean.1 pg_config.1 pg_controldata.1 pg_ctl.1 \ pg_dump.1 pg_dumpall.1 pg_resetxlog.1 pg_restore.1 \ - postgres.1 postmaster.1 psql.1 vacuumdb.1 + postgres.1 postmaster.1 psql.1 reindexdb.1 vacuumdb.1 MAN7= abort.7 alter_aggregate.7 alter_conversion.7 alter_database.7 \ alter_domain.7 alter_function.7 alter_group.7 \ alter_index.7 alter_language.7 alter_operator_class.7 \ + alter_role.7 \ alter_schema.7 alter_sequence.7 alter_table.7 \ alter_trigger.7 alter_user.7 analyze.7 begin.7 \ checkpoint.7 close.7 cluster.7 comment.7 commit.7 \ + commit_prepared.7 \ copy.7 create_aggregate.7 create_cast.7 \ create_constraint_trigger.7 create_conversion.7 \ create_database.7 create_domain.7 create_function.7 \ create_group.7 create_index.7 create_language.7 \ create_operator.7 create_operator_class.7 \ + create_role.7 \ create_rule.7 create_schema.7 create_sequence.7 \ create_table.7 create_table_as.7 create_trigger.7 \ create_type.7 create_user.7 create_view.7 deallocate.7 \ @@ -216,25 +218,17 @@ MAN7= abort.7 alter_aggregate.7 alter_conversion.7 alter_database.7 \ drop_aggregate.7 drop_cast.7 drop_conversion.7 \ drop_database.7 drop_domain.7 drop_function.7 \ drop_group.7 drop_index.7 drop_language.7 \ - drop_operator.7 drop_operator_class.7 drop_rule.7 \ + drop_operator.7 drop_operator_class.7 drop_role.7 \ + drop_rule.7 \ drop_schema.7 drop_sequence.7 drop_table.7 drop_trigger.7 \ drop_type.7 drop_user.7 drop_view.7 end.7 execute.7 \ explain.7 fetch.7 grant.7 insert.7 listen.7 load.7 \ - lock.7 move.7 notify.7 prepare.7 reindex.7 reset.7 \ - revoke.7 rollback.7 select.7 select_into.7 set.7 \ - set_constraints.7 set_transaction.7 show.7 \ + lock.7 move.7 notify.7 prepare.7 prepare_transaction.7 \ + reindex.7 reset.7 \ + revoke.7 rollback.7 rollback_prepared.7 select.7 \ + select_into.7 set.7 \ + set_constraints.7 set_role.7 set_transaction.7 show.7 \ set_session_authorization.7 start_transaction.7 \ - spi_connect.7 spi_copytuple.7 spi_cursor_close.7 \ - spi_cursor_fetch.7 spi_cursor_find.7 spi_cursor_move.7 \ - spi_cursor_open.7 spi_exec.7 spi_execp.7 spi_execute.7 \ - spi_execute_plan.7 \ - spi_finish.7 spi_fname.7 spi_fnumber.7 spi_freeplan.7 \ - spi_freetuple.7 spi_freetuptable.7 spi_getargcount.7 \ - spi_getargtypeid.7 spi_getbinval.7 spi_getrelname.7 \ - spi_gettype.7 spi_gettypeid.7 spi_getvalue.7 \ - spi_is_cursor_plan.7 spi_modifytuple.7 spi_palloc.7 \ - spi_pfree.7 spi_pop.7 spi_prepare.7 spi_push.7 \ - spi_repalloc.7 spi_returntuple.7 spi_saveplan.7 \ truncate.7 unlisten.7 update.7 vacuum.7 \ alter_operator.7 alter_tablespace.7 alter_type.7 \ create_tablespace.7 drop_tablespace.7 \ diff --git a/databases/postgresql90-server/distinfo b/databases/postgresql90-server/distinfo index 0a61ebc5441a..df22506b50e5 100644 --- a/databases/postgresql90-server/distinfo +++ b/databases/postgresql90-server/distinfo @@ -1,12 +1,15 @@ -MD5 (postgresql/postgresql-base-8.0.3.tar.bz2) = 35ff2b9a3bc5c65f55b4192a334b0e88 -SIZE (postgresql/postgresql-base-8.0.3.tar.bz2) = 7818251 -MD5 (postgresql/postgresql-docs-8.0.3.tar.bz2) = a9bb1e0dbc7ff862a30b6b9ca00b6470 -SIZE (postgresql/postgresql-docs-8.0.3.tar.bz2) = 2213693 -MD5 (postgresql/postgresql-opt-8.0.3.tar.bz2) = ea1ce6f570a4408e934af914de71da0e -SIZE (postgresql/postgresql-opt-8.0.3.tar.bz2) = 133623 -MD5 (postgresql/postgresql-test-8.0.3.tar.bz2) = 4dac47d2c87bb83ba6f2cd788ec794a6 -SIZE (postgresql/postgresql-test-8.0.3.tar.bz2) = 959642 -MD5 (postgresql/hier-Pg8.0.1-0.5.4.diff.gz) = 1d410cfb38253675fee36c8f9ee655e2 -SIZE (postgresql/hier-Pg8.0.1-0.5.4.diff.gz) = 30662 -MD5 (postgresql/pg-803-icu-2005-08-16.diff.gz) = 83cb174132c5dd7aeec622bc5c9a8b0d -SIZE (postgresql/pg-803-icu-2005-08-16.diff.gz) = 4190 +MD5 (postgresql/postgresql-base-8.1.0.tar.bz2) = 61ada6238aebbe6f3850895af25df37b +SHA256 (postgresql/postgresql-base-8.1.0.tar.bz2) = 604b6be364d88a2d0b0a4bae2165be0072bb8e79129c874f9a7fa1734dc8cb38 +SIZE (postgresql/postgresql-base-8.1.0.tar.bz2) = 8027880 +MD5 (postgresql/postgresql-docs-8.1.0.tar.bz2) = 544a41caa516cd9c6a07fa5d604a91bd +SHA256 (postgresql/postgresql-docs-8.1.0.tar.bz2) = 9ef412d3859646ec6d3478cd828c395e56610cc7a54daa18381da53153847d7b +SIZE (postgresql/postgresql-docs-8.1.0.tar.bz2) = 2443376 +MD5 (postgresql/postgresql-opt-8.1.0.tar.bz2) = 5fd9e43abc22e6af1ca819e43eb1fbd2 +SHA256 (postgresql/postgresql-opt-8.1.0.tar.bz2) = a9dbb375428f2250e7fcb5e66be2eaf3b87644f33f36b195b0d87ad91432bb40 +SIZE (postgresql/postgresql-opt-8.1.0.tar.bz2) = 141420 +MD5 (postgresql/postgresql-test-8.1.0.tar.bz2) = 594b045aa80aef1907bbd6b922a1e02b +SHA256 (postgresql/postgresql-test-8.1.0.tar.bz2) = 1fd3b5fb35d39b0fe703124b982cf4b10d6495f99eb3519cb2c59134a8bfcb2f +SIZE (postgresql/postgresql-test-8.1.0.tar.bz2) = 968672 +MD5 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = b1f6f40f6fcc887f35d57bb7aee2ed09 +SHA256 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 714d030be73d3df1fd5f47409e0b059ef1d04ad9cb56255b5d803f25b8c93f1a +SIZE (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 3956 diff --git a/databases/postgresql90-server/files/patch-src-makefiles-Makefile.freebsd b/databases/postgresql90-server/files/patch-src-makefiles-Makefile.freebsd index 89aaa9a2c0cc..81339e98e8db 100644 --- a/databases/postgresql90-server/files/patch-src-makefiles-Makefile.freebsd +++ b/databases/postgresql90-server/files/patch-src-makefiles-Makefile.freebsd @@ -1,14 +1,5 @@ --- src/makefiles/Makefile.freebsd.orig Fri Nov 19 01:41:39 2004 +++ src/makefiles/Makefile.freebsd Tue Dec 21 02:44:09 2004 -@@ -11,7 +11,7 @@ - ifeq ($(findstring sparc,$(host_cpu)), sparc) - CFLAGS_SL = -fPIC -DPIC - else --CFLAGS_SL = -fpic -DPIC -+CFLAGS_SL = -fPIC -DPIC - endif - - @@ -29,3 +29,5 @@ endif diff --git a/databases/postgresql90-server/files/patch-src:backend:utils:misc:postgresql.conf.sample b/databases/postgresql90-server/files/patch-src:backend:utils:misc:postgresql.conf.sample index 07363e882113..da57f46e3552 100644 --- a/databases/postgresql90-server/files/patch-src:backend:utils:misc:postgresql.conf.sample +++ b/databases/postgresql90-server/files/patch-src:backend:utils:misc:postgresql.conf.sample @@ -1,18 +1,18 @@ ---- src/backend/utils/misc/postgresql.conf.sample~ Fri Nov 5 20:16:16 2004 -+++ src/backend/utils/misc/postgresql.conf.sample Tue Dec 21 02:06:45 2004 -@@ -172,6 +172,7 @@ +--- src/backend/utils/misc/postgresql.conf.sample~ Tue Nov 8 00:45:49 2005 ++++ src/backend/utils/misc/postgresql.conf.sample Tue Nov 8 00:47:16 2005 +@@ -206,6 +206,7 @@ # - Where to Log - +log_destination = 'syslog' - #log_destination = 'stderr' # Valid values are combinations of stderr, - # syslog and eventlog, depending on - # platform. -@@ -219,6 +220,7 @@ - - #log_min_duration_statement = -1 # -1 is disabled, in milliseconds. + #log_destination = 'stderr' # Valid values are combinations of + # stderr, syslog and eventlog, + # depending on platform. +@@ -283,6 +284,7 @@ + #log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements + # and their durations, in milliseconds. -+silent_mode = true - #silent_mode = false # DO NOT USE without syslog or redirect_stderr ++silent_mode = on + #silent_mode = off # DO NOT USE without syslog or + # redirect_stderr - # - What to Log - diff --git a/databases/postgresql90-server/pkg-plist-client b/databases/postgresql90-server/pkg-plist-client index 5810e57ecead..cda05962118f 100644 --- a/databases/postgresql90-server/pkg-plist-client +++ b/databases/postgresql90-server/pkg-plist-client @@ -16,19 +16,21 @@ bin/pg_dumpall bin/pg_resetxlog bin/pg_restore bin/psql +bin/reindexdb bin/vacuumdb include/postgresql/server/access/attnum.h include/postgresql/server/access/clog.h include/postgresql/server/access/genam.h include/postgresql/server/access/gist.h +include/postgresql/server/access/gist_private.h include/postgresql/server/access/gistscan.h include/postgresql/server/access/hash.h include/postgresql/server/access/heapam.h include/postgresql/server/access/hio.h include/postgresql/server/access/htup.h -include/postgresql/server/access/ibit.h include/postgresql/server/access/iqual.h include/postgresql/server/access/itup.h +include/postgresql/server/access/multixact.h include/postgresql/server/access/nbtree.h include/postgresql/server/access/printtup.h include/postgresql/server/access/relscan.h @@ -43,6 +45,8 @@ include/postgresql/server/access/transam.h include/postgresql/server/access/tupdesc.h include/postgresql/server/access/tupmacs.h include/postgresql/server/access/tuptoaster.h +include/postgresql/server/access/twophase.h +include/postgresql/server/access/twophase_rmgr.h include/postgresql/server/access/valid.h include/postgresql/server/access/xact.h include/postgresql/server/access/xlog.h @@ -52,7 +56,6 @@ include/postgresql/server/access/xlogutils.h include/postgresql/server/bootstrap/bootstrap.h include/postgresql/server/c.h include/postgresql/server/catalog/catalog.h -include/postgresql/server/catalog/catname.h include/postgresql/server/catalog/catversion.h include/postgresql/server/catalog/dependency.h include/postgresql/server/catalog/heap.h @@ -65,6 +68,9 @@ include/postgresql/server/catalog/pg_amop.h include/postgresql/server/catalog/pg_amproc.h include/postgresql/server/catalog/pg_attrdef.h include/postgresql/server/catalog/pg_attribute.h +include/postgresql/server/catalog/pg_auth_members.h +include/postgresql/server/catalog/pg_authid.h +include/postgresql/server/catalog/pg_autovacuum.h include/postgresql/server/catalog/pg_cast.h include/postgresql/server/catalog/pg_class.h include/postgresql/server/catalog/pg_constraint.h @@ -73,7 +79,6 @@ include/postgresql/server/catalog/pg_conversion.h include/postgresql/server/catalog/pg_database.h include/postgresql/server/catalog/pg_depend.h include/postgresql/server/catalog/pg_description.h -include/postgresql/server/catalog/pg_group.h include/postgresql/server/catalog/pg_index.h include/postgresql/server/catalog/pg_inherits.h include/postgresql/server/catalog/pg_language.h @@ -82,14 +87,14 @@ include/postgresql/server/catalog/pg_listener.h include/postgresql/server/catalog/pg_namespace.h include/postgresql/server/catalog/pg_opclass.h include/postgresql/server/catalog/pg_operator.h +include/postgresql/server/catalog/pg_pltemplate.h include/postgresql/server/catalog/pg_proc.h include/postgresql/server/catalog/pg_rewrite.h -include/postgresql/server/catalog/pg_shadow.h +include/postgresql/server/catalog/pg_shdepend.h include/postgresql/server/catalog/pg_statistic.h include/postgresql/server/catalog/pg_tablespace.h include/postgresql/server/catalog/pg_trigger.h include/postgresql/server/catalog/pg_type.h -include/postgresql/server/catalog/pg_version.h include/postgresql/server/commands/alter.h include/postgresql/server/commands/async.h include/postgresql/server/commands/cluster.h @@ -124,6 +129,10 @@ include/postgresql/server/executor/hashjoin.h include/postgresql/server/executor/instrument.h include/postgresql/server/executor/nodeAgg.h include/postgresql/server/executor/nodeAppend.h +include/postgresql/server/executor/nodeBitmapAnd.h +include/postgresql/server/executor/nodeBitmapHeapscan.h +include/postgresql/server/executor/nodeBitmapIndexscan.h +include/postgresql/server/executor/nodeBitmapOr.h include/postgresql/server/executor/nodeFunctionscan.h include/postgresql/server/executor/nodeGroup.h include/postgresql/server/executor/nodeHash.h @@ -178,6 +187,7 @@ include/postgresql/server/nodes/primnodes.h include/postgresql/server/nodes/print.h include/postgresql/server/nodes/readfuncs.h include/postgresql/server/nodes/relation.h +include/postgresql/server/nodes/tidbitmap.h include/postgresql/server/nodes/value.h include/postgresql/server/optimizer/clauses.h include/postgresql/server/optimizer/cost.h @@ -196,6 +206,7 @@ include/postgresql/server/optimizer/paths.h include/postgresql/server/optimizer/plancat.h include/postgresql/server/optimizer/planmain.h include/postgresql/server/optimizer/planner.h +include/postgresql/server/optimizer/predtest.h include/postgresql/server/optimizer/prep.h include/postgresql/server/optimizer/restrictinfo.h include/postgresql/server/optimizer/subselect.h @@ -293,6 +304,7 @@ include/postgresql/server/storage/pg_shmem.h include/postgresql/server/storage/pmsignal.h include/postgresql/server/storage/pos.h include/postgresql/server/storage/proc.h +include/postgresql/server/storage/procarray.h include/postgresql/server/storage/relfilenode.h include/postgresql/server/storage/s_lock.h include/postgresql/server/storage/shmem.h @@ -320,6 +332,7 @@ include/postgresql/server/utils/dynahash.h include/postgresql/server/utils/dynamic_loader.h include/postgresql/server/utils/elog.h include/postgresql/server/utils/errcodes.h +include/postgresql/server/utils/flatfiles.h include/postgresql/server/utils/fmgroids.h include/postgresql/server/utils/fmgrtab.h include/postgresql/server/utils/formatting.h @@ -340,6 +353,7 @@ include/postgresql/server/utils/palloc.h include/postgresql/server/utils/pg_crc.h include/postgresql/server/utils/pg_locale.h include/postgresql/server/utils/pg_lzcompress.h +include/postgresql/server/utils/pg_rusage.h include/postgresql/server/utils/portal.h include/postgresql/server/utils/ps_status.h include/postgresql/server/utils/rel.h diff --git a/databases/postgresql90-server/pkg-plist-contrib b/databases/postgresql90-server/pkg-plist-contrib index fd3f553e5b25..aba5a7b1cc19 100644 --- a/databases/postgresql90-server/pkg-plist-contrib +++ b/databases/postgresql90-server/pkg-plist-contrib @@ -1,25 +1,17 @@ bin/DBMirror.pl bin/clean_pending.pl bin/dbf2pg -bin/findoidjoins bin/fti.pl -bin/ipc_check -bin/make_oidjoins_check -bin/my2pg.pl -bin/mysql2pgsql bin/oid2name -bin/pg_autovacuum -bin/pg_dumplo bin/pgbench -bin/reindexdb bin/vacuumlo lib/postgresql/_int.so lib/postgresql/autoinc.so lib/postgresql/btree_gist.so +lib/postgresql/pg_buffercache.so lib/postgresql/chkpass.so lib/postgresql/cube.so lib/postgresql/dblink.so -lib/postgresql/dbsize.so lib/postgresql/earthdistance.so lib/postgresql/fti.so lib/postgresql/fuzzystrmatch.so @@ -28,20 +20,15 @@ lib/postgresql/int_aggregate.so lib/postgresql/isbn_issn.so lib/postgresql/lo.so lib/postgresql/ltree.so -lib/postgresql/misc_utils.so lib/postgresql/moddatetime.so -lib/postgresql/noup.so lib/postgresql/pending.so lib/postgresql/pg_trgm.so lib/postgresql/pgcrypto.so lib/postgresql/pgstattuple.so lib/postgresql/refint.so -lib/postgresql/rtree_gist.so lib/postgresql/seg.so -lib/postgresql/string_io.so lib/postgresql/tablefunc.so lib/postgresql/timetravel.so -lib/postgresql/tsearch.so lib/postgresql/tsearch2.so lib/postgresql/user_locks.so %%DOCSDIR%%/README-contrib @@ -53,37 +40,26 @@ lib/postgresql/user_locks.so %%DOCSDIR%%/contrib/README.dbf2pg %%DOCSDIR%%/contrib/README.dblink %%DOCSDIR%%/contrib/README.dbmirror -%%DOCSDIR%%/contrib/README.dbsize %%DOCSDIR%%/contrib/README.earthdistance -%%DOCSDIR%%/contrib/README.findoidjoins %%DOCSDIR%%/contrib/README.fti %%DOCSDIR%%/contrib/README.fuzzystrmatch %%DOCSDIR%%/contrib/README.int_aggregate %%DOCSDIR%%/contrib/README.intarray -%%DOCSDIR%%/contrib/README.ipc_check %%DOCSDIR%%/contrib/README.isbn_issn %%DOCSDIR%%/contrib/README.lo %%DOCSDIR%%/contrib/README.ltree -%%DOCSDIR%%/contrib/README.misc_utils -%%DOCSDIR%%/contrib/README.mysql -%%DOCSDIR%%/contrib/README.noup %%DOCSDIR%%/contrib/README.oid2name -%%DOCSDIR%%/contrib/README.pg_autovacuum -%%DOCSDIR%%/contrib/README.pg_dumplo +%%DOCSDIR%%/contrib/README.pg_buffercache %%DOCSDIR%%/contrib/README.pg_trgm %%DOCSDIR%%/contrib/README.pgbench %%DOCSDIR%%/contrib/README.pgbench_jis %%DOCSDIR%%/contrib/README.pgcrypto %%DOCSDIR%%/contrib/README.pgstattuple %%DOCSDIR%%/contrib/README.pgstattuple.euc_jp -%%DOCSDIR%%/contrib/README.reindexdb -%%DOCSDIR%%/contrib/README.rtree_gist %%DOCSDIR%%/contrib/README.seg %%DOCSDIR%%/contrib/README.soundex %%DOCSDIR%%/contrib/README.spi -%%DOCSDIR%%/contrib/README.string_io %%DOCSDIR%%/contrib/README.tablefunc -%%DOCSDIR%%/contrib/README.tsearch %%DOCSDIR%%/contrib/README.tsearch2 %%DOCSDIR%%/contrib/README.user_locks %%DOCSDIR%%/contrib/README.vacuumlo @@ -100,7 +76,6 @@ share/postgresql/contrib/btree_gist.sql share/postgresql/contrib/chkpass.sql share/postgresql/contrib/cube.sql share/postgresql/contrib/dblink.sql -share/postgresql/contrib/dbsize.sql share/postgresql/contrib/earthdistance.sql share/postgresql/contrib/english.stop share/postgresql/contrib/fti.sql @@ -112,21 +87,17 @@ share/postgresql/contrib/lo.sql share/postgresql/contrib/lo_drop.sql share/postgresql/contrib/lo_test.sql share/postgresql/contrib/ltree.sql -share/postgresql/contrib/misc_utils.sql share/postgresql/contrib/moddatetime.sql -share/postgresql/contrib/noup.sql +share/postgresql/contrib/pg_buffercache.sql share/postgresql/contrib/pg_trgm.sql share/postgresql/contrib/pgcrypto.sql share/postgresql/contrib/pgstattuple.sql share/postgresql/contrib/refint.sql -share/postgresql/contrib/rtree_gist.sql share/postgresql/contrib/russian.stop share/postgresql/contrib/seg.sql share/postgresql/contrib/slaveDatabase.conf -share/postgresql/contrib/string_io.sql share/postgresql/contrib/tablefunc.sql share/postgresql/contrib/timetravel.sql -share/postgresql/contrib/tsearch.sql share/postgresql/contrib/tsearch2.sql share/postgresql/contrib/untsearch2.sql share/postgresql/contrib/user_locks.sql diff --git a/databases/postgresql90-server/pkg-plist-server b/databases/postgresql90-server/pkg-plist-server index 24cff6b753f0..9c00caef50c8 100644 --- a/databases/postgresql90-server/pkg-plist-server +++ b/databases/postgresql90-server/pkg-plist-server @@ -24,10 +24,11 @@ lib/postgresql/utf8_and_iso8859.so lib/postgresql/utf8_and_iso8859_1.so lib/postgresql/utf8_and_johab.so lib/postgresql/utf8_and_sjis.so -lib/postgresql/utf8_and_tcvn.so lib/postgresql/utf8_and_uhc.so lib/postgresql/utf8_and_win1250.so +lib/postgresql/utf8_and_win1252.so lib/postgresql/utf8_and_win1256.so +lib/postgresql/utf8_and_win1258.so lib/postgresql/utf8_and_win874.so lib/postgresql/plpgsql.so %%DOCSDIR%%/README-server @@ -246,6 +247,7 @@ share/postgresql/timezone/Asia/Ujung_Pandang share/postgresql/timezone/Asia/Tel_Aviv share/postgresql/timezone/Asia/Thimbu share/postgresql/timezone/Asia/Ulan_Bator +share/postgresql/timezone/Australia/Currie share/postgresql/timezone/Australia/Darwin share/postgresql/timezone/Australia/Perth share/postgresql/timezone/Australia/Brisbane @@ -365,6 +367,7 @@ share/postgresql/timezone/CET share/postgresql/timezone/MET share/postgresql/timezone/EET share/postgresql/timezone/America/Danmarkshavn +share/postgresql/timezone/America/Coral_Harbour share/postgresql/timezone/America/Scoresbysund share/postgresql/timezone/America/Godthab share/postgresql/timezone/America/Thule diff --git a/databases/postgresql91-server/Makefile b/databases/postgresql91-server/Makefile index ac0672bbd051..4398586e3e22 100644 --- a/databases/postgresql91-server/Makefile +++ b/databases/postgresql91-server/Makefile @@ -7,7 +7,7 @@ PORTNAME?= postgresql PKGNAMESUFFIX?= -server -PORTVERSION?= 8.0.3 +PORTVERSION?= 8.1.0 PORTREVISION?= 0 CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_PGSQL} @@ -21,8 +21,6 @@ COMMENT?= The most advanced open-source database available anywhere CONFLICTS?= ${PORTNAME}-client-7.[0-9]* \ ${PORTNAME}${PKGNAMESUFFIX}-7.[0-9]* -BROKEN= Work in progress, nothing to see, please move along... - WRKSRC= ${WRKDIR}/postgresql-${PORTVERSION} DIST_SUBDIR= postgresql @@ -97,24 +95,25 @@ OPTIONS+= DEBUG "Builds with debugging symbols" off OPTIONS+= ICU "Use ICU for unicode collation (server)" off # See http://gppl.moonbone.ru/ for more info -OPTIONS+= HIER "Builds with query hierarchy (server)" off +#OPTIONS+= HIER "Builds with query hierarchy (server)" off # See http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/76999 for more info # (requires dump/restore if modified.) OPTIONS+= INTDATE "Builds with 64-bit date/time type (server)" off . if defined(SERVER_ONLY) && defined(WITH_HIER) +BROKEN= no HIER patch for 8.1 series exists PATCH_SITES+= http://gppl.moonbone.ru/:hier801054 PATCHFILES+= hier-Pg8.0.1-0.5.4.diff.gz:hier801054 USE_BISON= yes . endif . if defined(SERVER_ONLY) && defined(WITH_ICU) -USE_AUTOCONF_VER=253 +USE_AUTOCONF_VER=259 CONFIGURE_ARGS+=--with-icu -LIB_DEPENDS= icudata.32:${PORTSDIR}/devel/icu +LIB_DEPENDS= icudata.34:${PORTSDIR}/devel/icu PATCH_SITES+= http://people.freebsd.org/~girgen/postgresql-icu/:icu -PATCHFILES+= pg-803-icu-2005-08-16.diff.gz:icu +PATCHFILES+= pg-810-icu-34-2005-11-09.diff.gz:icu . endif PATCH_DIST_STRIP=-p1 @@ -152,6 +151,9 @@ INSTALL_TARGET= install-strip . endif . if defined(WITH_MIT_KRB5) +. if exists(/usr/lib/libkrb5.so) +BROKEN= "You must remove heimdal's /usr/lib/libkrb5.so* to build successfully with MIT-KRB" +. endif WITH_KRB5= yes KRB5_HOME?= ${LOCALBASE} KRB5CONF= ${KRB5_HOME}/bin/krb5-config @@ -160,20 +162,17 @@ LIB_DEPENDS+= krb5.3:${PORTSDIR}/security/krb5 . if defined(WITH_HEIMDAL_KRB5) WITH_KRB5= yes -. if defined(HEIMDAL_HOME) && exists(${HEIMDAL_HOME}/lib/libgssapi.a) -KRB5CONF= ${HEIMDAL_HOME}/bin/krb5-config -. elif ( defined(MAKE_KERBEROS5) || ${OSVERSION} > 500105 ) && exists(${DESTDIR}/usr/lib/libkrb5.a) -KRB5CONF= ${DESTDIR}/usr/bin/krb5-config -. else +# Base heimdal in /usr will not link properly with postgresql, we must +# use the port. See +# http://lists.freebsd.org/pipermail/freebsd-stable/2005-October/018809.html LIB_DEPENDS+= krb5:${PORTSDIR}/security/heimdal KRB5CONF= ${LOCALBASE}/bin/krb5-config -. endif . endif . if defined(WITH_KRB5) CONFIGURE_ARGS+= --with-krb5 -LDFLAGS+= `${KRB5CONF} --libs krb5` -CONFIGURE_ENV+= LDFLAGS="${LDFLAGS}" +LIBS= `${KRB5CONF} --libs krb5` +CONFIGURE_ENV+= LIBS="${LIBS}" . endif . if defined(SERVER_ONLY) && defined(WITH_TESTS) @@ -196,19 +195,22 @@ MAN1= clusterdb.1 createdb.1 createlang.1 createuser.1 \ dropdb.1 droplang.1 dropuser.1 ecpg.1 initdb.1 \ ipcclean.1 pg_config.1 pg_controldata.1 pg_ctl.1 \ pg_dump.1 pg_dumpall.1 pg_resetxlog.1 pg_restore.1 \ - postgres.1 postmaster.1 psql.1 vacuumdb.1 + postgres.1 postmaster.1 psql.1 reindexdb.1 vacuumdb.1 MAN7= abort.7 alter_aggregate.7 alter_conversion.7 alter_database.7 \ alter_domain.7 alter_function.7 alter_group.7 \ alter_index.7 alter_language.7 alter_operator_class.7 \ + alter_role.7 \ alter_schema.7 alter_sequence.7 alter_table.7 \ alter_trigger.7 alter_user.7 analyze.7 begin.7 \ checkpoint.7 close.7 cluster.7 comment.7 commit.7 \ + commit_prepared.7 \ copy.7 create_aggregate.7 create_cast.7 \ create_constraint_trigger.7 create_conversion.7 \ create_database.7 create_domain.7 create_function.7 \ create_group.7 create_index.7 create_language.7 \ create_operator.7 create_operator_class.7 \ + create_role.7 \ create_rule.7 create_schema.7 create_sequence.7 \ create_table.7 create_table_as.7 create_trigger.7 \ create_type.7 create_user.7 create_view.7 deallocate.7 \ @@ -216,25 +218,17 @@ MAN7= abort.7 alter_aggregate.7 alter_conversion.7 alter_database.7 \ drop_aggregate.7 drop_cast.7 drop_conversion.7 \ drop_database.7 drop_domain.7 drop_function.7 \ drop_group.7 drop_index.7 drop_language.7 \ - drop_operator.7 drop_operator_class.7 drop_rule.7 \ + drop_operator.7 drop_operator_class.7 drop_role.7 \ + drop_rule.7 \ drop_schema.7 drop_sequence.7 drop_table.7 drop_trigger.7 \ drop_type.7 drop_user.7 drop_view.7 end.7 execute.7 \ explain.7 fetch.7 grant.7 insert.7 listen.7 load.7 \ - lock.7 move.7 notify.7 prepare.7 reindex.7 reset.7 \ - revoke.7 rollback.7 select.7 select_into.7 set.7 \ - set_constraints.7 set_transaction.7 show.7 \ + lock.7 move.7 notify.7 prepare.7 prepare_transaction.7 \ + reindex.7 reset.7 \ + revoke.7 rollback.7 rollback_prepared.7 select.7 \ + select_into.7 set.7 \ + set_constraints.7 set_role.7 set_transaction.7 show.7 \ set_session_authorization.7 start_transaction.7 \ - spi_connect.7 spi_copytuple.7 spi_cursor_close.7 \ - spi_cursor_fetch.7 spi_cursor_find.7 spi_cursor_move.7 \ - spi_cursor_open.7 spi_exec.7 spi_execp.7 spi_execute.7 \ - spi_execute_plan.7 \ - spi_finish.7 spi_fname.7 spi_fnumber.7 spi_freeplan.7 \ - spi_freetuple.7 spi_freetuptable.7 spi_getargcount.7 \ - spi_getargtypeid.7 spi_getbinval.7 spi_getrelname.7 \ - spi_gettype.7 spi_gettypeid.7 spi_getvalue.7 \ - spi_is_cursor_plan.7 spi_modifytuple.7 spi_palloc.7 \ - spi_pfree.7 spi_pop.7 spi_prepare.7 spi_push.7 \ - spi_repalloc.7 spi_returntuple.7 spi_saveplan.7 \ truncate.7 unlisten.7 update.7 vacuum.7 \ alter_operator.7 alter_tablespace.7 alter_type.7 \ create_tablespace.7 drop_tablespace.7 \ diff --git a/databases/postgresql91-server/distinfo b/databases/postgresql91-server/distinfo index 0a61ebc5441a..df22506b50e5 100644 --- a/databases/postgresql91-server/distinfo +++ b/databases/postgresql91-server/distinfo @@ -1,12 +1,15 @@ -MD5 (postgresql/postgresql-base-8.0.3.tar.bz2) = 35ff2b9a3bc5c65f55b4192a334b0e88 -SIZE (postgresql/postgresql-base-8.0.3.tar.bz2) = 7818251 -MD5 (postgresql/postgresql-docs-8.0.3.tar.bz2) = a9bb1e0dbc7ff862a30b6b9ca00b6470 -SIZE (postgresql/postgresql-docs-8.0.3.tar.bz2) = 2213693 -MD5 (postgresql/postgresql-opt-8.0.3.tar.bz2) = ea1ce6f570a4408e934af914de71da0e -SIZE (postgresql/postgresql-opt-8.0.3.tar.bz2) = 133623 -MD5 (postgresql/postgresql-test-8.0.3.tar.bz2) = 4dac47d2c87bb83ba6f2cd788ec794a6 -SIZE (postgresql/postgresql-test-8.0.3.tar.bz2) = 959642 -MD5 (postgresql/hier-Pg8.0.1-0.5.4.diff.gz) = 1d410cfb38253675fee36c8f9ee655e2 -SIZE (postgresql/hier-Pg8.0.1-0.5.4.diff.gz) = 30662 -MD5 (postgresql/pg-803-icu-2005-08-16.diff.gz) = 83cb174132c5dd7aeec622bc5c9a8b0d -SIZE (postgresql/pg-803-icu-2005-08-16.diff.gz) = 4190 +MD5 (postgresql/postgresql-base-8.1.0.tar.bz2) = 61ada6238aebbe6f3850895af25df37b +SHA256 (postgresql/postgresql-base-8.1.0.tar.bz2) = 604b6be364d88a2d0b0a4bae2165be0072bb8e79129c874f9a7fa1734dc8cb38 +SIZE (postgresql/postgresql-base-8.1.0.tar.bz2) = 8027880 +MD5 (postgresql/postgresql-docs-8.1.0.tar.bz2) = 544a41caa516cd9c6a07fa5d604a91bd +SHA256 (postgresql/postgresql-docs-8.1.0.tar.bz2) = 9ef412d3859646ec6d3478cd828c395e56610cc7a54daa18381da53153847d7b +SIZE (postgresql/postgresql-docs-8.1.0.tar.bz2) = 2443376 +MD5 (postgresql/postgresql-opt-8.1.0.tar.bz2) = 5fd9e43abc22e6af1ca819e43eb1fbd2 +SHA256 (postgresql/postgresql-opt-8.1.0.tar.bz2) = a9dbb375428f2250e7fcb5e66be2eaf3b87644f33f36b195b0d87ad91432bb40 +SIZE (postgresql/postgresql-opt-8.1.0.tar.bz2) = 141420 +MD5 (postgresql/postgresql-test-8.1.0.tar.bz2) = 594b045aa80aef1907bbd6b922a1e02b +SHA256 (postgresql/postgresql-test-8.1.0.tar.bz2) = 1fd3b5fb35d39b0fe703124b982cf4b10d6495f99eb3519cb2c59134a8bfcb2f +SIZE (postgresql/postgresql-test-8.1.0.tar.bz2) = 968672 +MD5 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = b1f6f40f6fcc887f35d57bb7aee2ed09 +SHA256 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 714d030be73d3df1fd5f47409e0b059ef1d04ad9cb56255b5d803f25b8c93f1a +SIZE (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 3956 diff --git a/databases/postgresql91-server/files/patch-src-makefiles-Makefile.freebsd b/databases/postgresql91-server/files/patch-src-makefiles-Makefile.freebsd index 89aaa9a2c0cc..81339e98e8db 100644 --- a/databases/postgresql91-server/files/patch-src-makefiles-Makefile.freebsd +++ b/databases/postgresql91-server/files/patch-src-makefiles-Makefile.freebsd @@ -1,14 +1,5 @@ --- src/makefiles/Makefile.freebsd.orig Fri Nov 19 01:41:39 2004 +++ src/makefiles/Makefile.freebsd Tue Dec 21 02:44:09 2004 -@@ -11,7 +11,7 @@ - ifeq ($(findstring sparc,$(host_cpu)), sparc) - CFLAGS_SL = -fPIC -DPIC - else --CFLAGS_SL = -fpic -DPIC -+CFLAGS_SL = -fPIC -DPIC - endif - - @@ -29,3 +29,5 @@ endif diff --git a/databases/postgresql91-server/files/patch-src:backend:utils:misc:postgresql.conf.sample b/databases/postgresql91-server/files/patch-src:backend:utils:misc:postgresql.conf.sample index 07363e882113..da57f46e3552 100644 --- a/databases/postgresql91-server/files/patch-src:backend:utils:misc:postgresql.conf.sample +++ b/databases/postgresql91-server/files/patch-src:backend:utils:misc:postgresql.conf.sample @@ -1,18 +1,18 @@ ---- src/backend/utils/misc/postgresql.conf.sample~ Fri Nov 5 20:16:16 2004 -+++ src/backend/utils/misc/postgresql.conf.sample Tue Dec 21 02:06:45 2004 -@@ -172,6 +172,7 @@ +--- src/backend/utils/misc/postgresql.conf.sample~ Tue Nov 8 00:45:49 2005 ++++ src/backend/utils/misc/postgresql.conf.sample Tue Nov 8 00:47:16 2005 +@@ -206,6 +206,7 @@ # - Where to Log - +log_destination = 'syslog' - #log_destination = 'stderr' # Valid values are combinations of stderr, - # syslog and eventlog, depending on - # platform. -@@ -219,6 +220,7 @@ - - #log_min_duration_statement = -1 # -1 is disabled, in milliseconds. + #log_destination = 'stderr' # Valid values are combinations of + # stderr, syslog and eventlog, + # depending on platform. +@@ -283,6 +284,7 @@ + #log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements + # and their durations, in milliseconds. -+silent_mode = true - #silent_mode = false # DO NOT USE without syslog or redirect_stderr ++silent_mode = on + #silent_mode = off # DO NOT USE without syslog or + # redirect_stderr - # - What to Log - diff --git a/databases/postgresql91-server/pkg-plist-client b/databases/postgresql91-server/pkg-plist-client index 5810e57ecead..cda05962118f 100644 --- a/databases/postgresql91-server/pkg-plist-client +++ b/databases/postgresql91-server/pkg-plist-client @@ -16,19 +16,21 @@ bin/pg_dumpall bin/pg_resetxlog bin/pg_restore bin/psql +bin/reindexdb bin/vacuumdb include/postgresql/server/access/attnum.h include/postgresql/server/access/clog.h include/postgresql/server/access/genam.h include/postgresql/server/access/gist.h +include/postgresql/server/access/gist_private.h include/postgresql/server/access/gistscan.h include/postgresql/server/access/hash.h include/postgresql/server/access/heapam.h include/postgresql/server/access/hio.h include/postgresql/server/access/htup.h -include/postgresql/server/access/ibit.h include/postgresql/server/access/iqual.h include/postgresql/server/access/itup.h +include/postgresql/server/access/multixact.h include/postgresql/server/access/nbtree.h include/postgresql/server/access/printtup.h include/postgresql/server/access/relscan.h @@ -43,6 +45,8 @@ include/postgresql/server/access/transam.h include/postgresql/server/access/tupdesc.h include/postgresql/server/access/tupmacs.h include/postgresql/server/access/tuptoaster.h +include/postgresql/server/access/twophase.h +include/postgresql/server/access/twophase_rmgr.h include/postgresql/server/access/valid.h include/postgresql/server/access/xact.h include/postgresql/server/access/xlog.h @@ -52,7 +56,6 @@ include/postgresql/server/access/xlogutils.h include/postgresql/server/bootstrap/bootstrap.h include/postgresql/server/c.h include/postgresql/server/catalog/catalog.h -include/postgresql/server/catalog/catname.h include/postgresql/server/catalog/catversion.h include/postgresql/server/catalog/dependency.h include/postgresql/server/catalog/heap.h @@ -65,6 +68,9 @@ include/postgresql/server/catalog/pg_amop.h include/postgresql/server/catalog/pg_amproc.h include/postgresql/server/catalog/pg_attrdef.h include/postgresql/server/catalog/pg_attribute.h +include/postgresql/server/catalog/pg_auth_members.h +include/postgresql/server/catalog/pg_authid.h +include/postgresql/server/catalog/pg_autovacuum.h include/postgresql/server/catalog/pg_cast.h include/postgresql/server/catalog/pg_class.h include/postgresql/server/catalog/pg_constraint.h @@ -73,7 +79,6 @@ include/postgresql/server/catalog/pg_conversion.h include/postgresql/server/catalog/pg_database.h include/postgresql/server/catalog/pg_depend.h include/postgresql/server/catalog/pg_description.h -include/postgresql/server/catalog/pg_group.h include/postgresql/server/catalog/pg_index.h include/postgresql/server/catalog/pg_inherits.h include/postgresql/server/catalog/pg_language.h @@ -82,14 +87,14 @@ include/postgresql/server/catalog/pg_listener.h include/postgresql/server/catalog/pg_namespace.h include/postgresql/server/catalog/pg_opclass.h include/postgresql/server/catalog/pg_operator.h +include/postgresql/server/catalog/pg_pltemplate.h include/postgresql/server/catalog/pg_proc.h include/postgresql/server/catalog/pg_rewrite.h -include/postgresql/server/catalog/pg_shadow.h +include/postgresql/server/catalog/pg_shdepend.h include/postgresql/server/catalog/pg_statistic.h include/postgresql/server/catalog/pg_tablespace.h include/postgresql/server/catalog/pg_trigger.h include/postgresql/server/catalog/pg_type.h -include/postgresql/server/catalog/pg_version.h include/postgresql/server/commands/alter.h include/postgresql/server/commands/async.h include/postgresql/server/commands/cluster.h @@ -124,6 +129,10 @@ include/postgresql/server/executor/hashjoin.h include/postgresql/server/executor/instrument.h include/postgresql/server/executor/nodeAgg.h include/postgresql/server/executor/nodeAppend.h +include/postgresql/server/executor/nodeBitmapAnd.h +include/postgresql/server/executor/nodeBitmapHeapscan.h +include/postgresql/server/executor/nodeBitmapIndexscan.h +include/postgresql/server/executor/nodeBitmapOr.h include/postgresql/server/executor/nodeFunctionscan.h include/postgresql/server/executor/nodeGroup.h include/postgresql/server/executor/nodeHash.h @@ -178,6 +187,7 @@ include/postgresql/server/nodes/primnodes.h include/postgresql/server/nodes/print.h include/postgresql/server/nodes/readfuncs.h include/postgresql/server/nodes/relation.h +include/postgresql/server/nodes/tidbitmap.h include/postgresql/server/nodes/value.h include/postgresql/server/optimizer/clauses.h include/postgresql/server/optimizer/cost.h @@ -196,6 +206,7 @@ include/postgresql/server/optimizer/paths.h include/postgresql/server/optimizer/plancat.h include/postgresql/server/optimizer/planmain.h include/postgresql/server/optimizer/planner.h +include/postgresql/server/optimizer/predtest.h include/postgresql/server/optimizer/prep.h include/postgresql/server/optimizer/restrictinfo.h include/postgresql/server/optimizer/subselect.h @@ -293,6 +304,7 @@ include/postgresql/server/storage/pg_shmem.h include/postgresql/server/storage/pmsignal.h include/postgresql/server/storage/pos.h include/postgresql/server/storage/proc.h +include/postgresql/server/storage/procarray.h include/postgresql/server/storage/relfilenode.h include/postgresql/server/storage/s_lock.h include/postgresql/server/storage/shmem.h @@ -320,6 +332,7 @@ include/postgresql/server/utils/dynahash.h include/postgresql/server/utils/dynamic_loader.h include/postgresql/server/utils/elog.h include/postgresql/server/utils/errcodes.h +include/postgresql/server/utils/flatfiles.h include/postgresql/server/utils/fmgroids.h include/postgresql/server/utils/fmgrtab.h include/postgresql/server/utils/formatting.h @@ -340,6 +353,7 @@ include/postgresql/server/utils/palloc.h include/postgresql/server/utils/pg_crc.h include/postgresql/server/utils/pg_locale.h include/postgresql/server/utils/pg_lzcompress.h +include/postgresql/server/utils/pg_rusage.h include/postgresql/server/utils/portal.h include/postgresql/server/utils/ps_status.h include/postgresql/server/utils/rel.h diff --git a/databases/postgresql91-server/pkg-plist-contrib b/databases/postgresql91-server/pkg-plist-contrib index fd3f553e5b25..aba5a7b1cc19 100644 --- a/databases/postgresql91-server/pkg-plist-contrib +++ b/databases/postgresql91-server/pkg-plist-contrib @@ -1,25 +1,17 @@ bin/DBMirror.pl bin/clean_pending.pl bin/dbf2pg -bin/findoidjoins bin/fti.pl -bin/ipc_check -bin/make_oidjoins_check -bin/my2pg.pl -bin/mysql2pgsql bin/oid2name -bin/pg_autovacuum -bin/pg_dumplo bin/pgbench -bin/reindexdb bin/vacuumlo lib/postgresql/_int.so lib/postgresql/autoinc.so lib/postgresql/btree_gist.so +lib/postgresql/pg_buffercache.so lib/postgresql/chkpass.so lib/postgresql/cube.so lib/postgresql/dblink.so -lib/postgresql/dbsize.so lib/postgresql/earthdistance.so lib/postgresql/fti.so lib/postgresql/fuzzystrmatch.so @@ -28,20 +20,15 @@ lib/postgresql/int_aggregate.so lib/postgresql/isbn_issn.so lib/postgresql/lo.so lib/postgresql/ltree.so -lib/postgresql/misc_utils.so lib/postgresql/moddatetime.so -lib/postgresql/noup.so lib/postgresql/pending.so lib/postgresql/pg_trgm.so lib/postgresql/pgcrypto.so lib/postgresql/pgstattuple.so lib/postgresql/refint.so -lib/postgresql/rtree_gist.so lib/postgresql/seg.so -lib/postgresql/string_io.so lib/postgresql/tablefunc.so lib/postgresql/timetravel.so -lib/postgresql/tsearch.so lib/postgresql/tsearch2.so lib/postgresql/user_locks.so %%DOCSDIR%%/README-contrib @@ -53,37 +40,26 @@ lib/postgresql/user_locks.so %%DOCSDIR%%/contrib/README.dbf2pg %%DOCSDIR%%/contrib/README.dblink %%DOCSDIR%%/contrib/README.dbmirror -%%DOCSDIR%%/contrib/README.dbsize %%DOCSDIR%%/contrib/README.earthdistance -%%DOCSDIR%%/contrib/README.findoidjoins %%DOCSDIR%%/contrib/README.fti %%DOCSDIR%%/contrib/README.fuzzystrmatch %%DOCSDIR%%/contrib/README.int_aggregate %%DOCSDIR%%/contrib/README.intarray -%%DOCSDIR%%/contrib/README.ipc_check %%DOCSDIR%%/contrib/README.isbn_issn %%DOCSDIR%%/contrib/README.lo %%DOCSDIR%%/contrib/README.ltree -%%DOCSDIR%%/contrib/README.misc_utils -%%DOCSDIR%%/contrib/README.mysql -%%DOCSDIR%%/contrib/README.noup %%DOCSDIR%%/contrib/README.oid2name -%%DOCSDIR%%/contrib/README.pg_autovacuum -%%DOCSDIR%%/contrib/README.pg_dumplo +%%DOCSDIR%%/contrib/README.pg_buffercache %%DOCSDIR%%/contrib/README.pg_trgm %%DOCSDIR%%/contrib/README.pgbench %%DOCSDIR%%/contrib/README.pgbench_jis %%DOCSDIR%%/contrib/README.pgcrypto %%DOCSDIR%%/contrib/README.pgstattuple %%DOCSDIR%%/contrib/README.pgstattuple.euc_jp -%%DOCSDIR%%/contrib/README.reindexdb -%%DOCSDIR%%/contrib/README.rtree_gist %%DOCSDIR%%/contrib/README.seg %%DOCSDIR%%/contrib/README.soundex %%DOCSDIR%%/contrib/README.spi -%%DOCSDIR%%/contrib/README.string_io %%DOCSDIR%%/contrib/README.tablefunc -%%DOCSDIR%%/contrib/README.tsearch %%DOCSDIR%%/contrib/README.tsearch2 %%DOCSDIR%%/contrib/README.user_locks %%DOCSDIR%%/contrib/README.vacuumlo @@ -100,7 +76,6 @@ share/postgresql/contrib/btree_gist.sql share/postgresql/contrib/chkpass.sql share/postgresql/contrib/cube.sql share/postgresql/contrib/dblink.sql -share/postgresql/contrib/dbsize.sql share/postgresql/contrib/earthdistance.sql share/postgresql/contrib/english.stop share/postgresql/contrib/fti.sql @@ -112,21 +87,17 @@ share/postgresql/contrib/lo.sql share/postgresql/contrib/lo_drop.sql share/postgresql/contrib/lo_test.sql share/postgresql/contrib/ltree.sql -share/postgresql/contrib/misc_utils.sql share/postgresql/contrib/moddatetime.sql -share/postgresql/contrib/noup.sql +share/postgresql/contrib/pg_buffercache.sql share/postgresql/contrib/pg_trgm.sql share/postgresql/contrib/pgcrypto.sql share/postgresql/contrib/pgstattuple.sql share/postgresql/contrib/refint.sql -share/postgresql/contrib/rtree_gist.sql share/postgresql/contrib/russian.stop share/postgresql/contrib/seg.sql share/postgresql/contrib/slaveDatabase.conf -share/postgresql/contrib/string_io.sql share/postgresql/contrib/tablefunc.sql share/postgresql/contrib/timetravel.sql -share/postgresql/contrib/tsearch.sql share/postgresql/contrib/tsearch2.sql share/postgresql/contrib/untsearch2.sql share/postgresql/contrib/user_locks.sql diff --git a/databases/postgresql91-server/pkg-plist-server b/databases/postgresql91-server/pkg-plist-server index 24cff6b753f0..9c00caef50c8 100644 --- a/databases/postgresql91-server/pkg-plist-server +++ b/databases/postgresql91-server/pkg-plist-server @@ -24,10 +24,11 @@ lib/postgresql/utf8_and_iso8859.so lib/postgresql/utf8_and_iso8859_1.so lib/postgresql/utf8_and_johab.so lib/postgresql/utf8_and_sjis.so -lib/postgresql/utf8_and_tcvn.so lib/postgresql/utf8_and_uhc.so lib/postgresql/utf8_and_win1250.so +lib/postgresql/utf8_and_win1252.so lib/postgresql/utf8_and_win1256.so +lib/postgresql/utf8_and_win1258.so lib/postgresql/utf8_and_win874.so lib/postgresql/plpgsql.so %%DOCSDIR%%/README-server @@ -246,6 +247,7 @@ share/postgresql/timezone/Asia/Ujung_Pandang share/postgresql/timezone/Asia/Tel_Aviv share/postgresql/timezone/Asia/Thimbu share/postgresql/timezone/Asia/Ulan_Bator +share/postgresql/timezone/Australia/Currie share/postgresql/timezone/Australia/Darwin share/postgresql/timezone/Australia/Perth share/postgresql/timezone/Australia/Brisbane @@ -365,6 +367,7 @@ share/postgresql/timezone/CET share/postgresql/timezone/MET share/postgresql/timezone/EET share/postgresql/timezone/America/Danmarkshavn +share/postgresql/timezone/America/Coral_Harbour share/postgresql/timezone/America/Scoresbysund share/postgresql/timezone/America/Godthab share/postgresql/timezone/America/Thule diff --git a/databases/postgresql92-server/Makefile b/databases/postgresql92-server/Makefile index ac0672bbd051..4398586e3e22 100644 --- a/databases/postgresql92-server/Makefile +++ b/databases/postgresql92-server/Makefile @@ -7,7 +7,7 @@ PORTNAME?= postgresql PKGNAMESUFFIX?= -server -PORTVERSION?= 8.0.3 +PORTVERSION?= 8.1.0 PORTREVISION?= 0 CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_PGSQL} @@ -21,8 +21,6 @@ COMMENT?= The most advanced open-source database available anywhere CONFLICTS?= ${PORTNAME}-client-7.[0-9]* \ ${PORTNAME}${PKGNAMESUFFIX}-7.[0-9]* -BROKEN= Work in progress, nothing to see, please move along... - WRKSRC= ${WRKDIR}/postgresql-${PORTVERSION} DIST_SUBDIR= postgresql @@ -97,24 +95,25 @@ OPTIONS+= DEBUG "Builds with debugging symbols" off OPTIONS+= ICU "Use ICU for unicode collation (server)" off # See http://gppl.moonbone.ru/ for more info -OPTIONS+= HIER "Builds with query hierarchy (server)" off +#OPTIONS+= HIER "Builds with query hierarchy (server)" off # See http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/76999 for more info # (requires dump/restore if modified.) OPTIONS+= INTDATE "Builds with 64-bit date/time type (server)" off . if defined(SERVER_ONLY) && defined(WITH_HIER) +BROKEN= no HIER patch for 8.1 series exists PATCH_SITES+= http://gppl.moonbone.ru/:hier801054 PATCHFILES+= hier-Pg8.0.1-0.5.4.diff.gz:hier801054 USE_BISON= yes . endif . if defined(SERVER_ONLY) && defined(WITH_ICU) -USE_AUTOCONF_VER=253 +USE_AUTOCONF_VER=259 CONFIGURE_ARGS+=--with-icu -LIB_DEPENDS= icudata.32:${PORTSDIR}/devel/icu +LIB_DEPENDS= icudata.34:${PORTSDIR}/devel/icu PATCH_SITES+= http://people.freebsd.org/~girgen/postgresql-icu/:icu -PATCHFILES+= pg-803-icu-2005-08-16.diff.gz:icu +PATCHFILES+= pg-810-icu-34-2005-11-09.diff.gz:icu . endif PATCH_DIST_STRIP=-p1 @@ -152,6 +151,9 @@ INSTALL_TARGET= install-strip . endif . if defined(WITH_MIT_KRB5) +. if exists(/usr/lib/libkrb5.so) +BROKEN= "You must remove heimdal's /usr/lib/libkrb5.so* to build successfully with MIT-KRB" +. endif WITH_KRB5= yes KRB5_HOME?= ${LOCALBASE} KRB5CONF= ${KRB5_HOME}/bin/krb5-config @@ -160,20 +162,17 @@ LIB_DEPENDS+= krb5.3:${PORTSDIR}/security/krb5 . if defined(WITH_HEIMDAL_KRB5) WITH_KRB5= yes -. if defined(HEIMDAL_HOME) && exists(${HEIMDAL_HOME}/lib/libgssapi.a) -KRB5CONF= ${HEIMDAL_HOME}/bin/krb5-config -. elif ( defined(MAKE_KERBEROS5) || ${OSVERSION} > 500105 ) && exists(${DESTDIR}/usr/lib/libkrb5.a) -KRB5CONF= ${DESTDIR}/usr/bin/krb5-config -. else +# Base heimdal in /usr will not link properly with postgresql, we must +# use the port. See +# http://lists.freebsd.org/pipermail/freebsd-stable/2005-October/018809.html LIB_DEPENDS+= krb5:${PORTSDIR}/security/heimdal KRB5CONF= ${LOCALBASE}/bin/krb5-config -. endif . endif . if defined(WITH_KRB5) CONFIGURE_ARGS+= --with-krb5 -LDFLAGS+= `${KRB5CONF} --libs krb5` -CONFIGURE_ENV+= LDFLAGS="${LDFLAGS}" +LIBS= `${KRB5CONF} --libs krb5` +CONFIGURE_ENV+= LIBS="${LIBS}" . endif . if defined(SERVER_ONLY) && defined(WITH_TESTS) @@ -196,19 +195,22 @@ MAN1= clusterdb.1 createdb.1 createlang.1 createuser.1 \ dropdb.1 droplang.1 dropuser.1 ecpg.1 initdb.1 \ ipcclean.1 pg_config.1 pg_controldata.1 pg_ctl.1 \ pg_dump.1 pg_dumpall.1 pg_resetxlog.1 pg_restore.1 \ - postgres.1 postmaster.1 psql.1 vacuumdb.1 + postgres.1 postmaster.1 psql.1 reindexdb.1 vacuumdb.1 MAN7= abort.7 alter_aggregate.7 alter_conversion.7 alter_database.7 \ alter_domain.7 alter_function.7 alter_group.7 \ alter_index.7 alter_language.7 alter_operator_class.7 \ + alter_role.7 \ alter_schema.7 alter_sequence.7 alter_table.7 \ alter_trigger.7 alter_user.7 analyze.7 begin.7 \ checkpoint.7 close.7 cluster.7 comment.7 commit.7 \ + commit_prepared.7 \ copy.7 create_aggregate.7 create_cast.7 \ create_constraint_trigger.7 create_conversion.7 \ create_database.7 create_domain.7 create_function.7 \ create_group.7 create_index.7 create_language.7 \ create_operator.7 create_operator_class.7 \ + create_role.7 \ create_rule.7 create_schema.7 create_sequence.7 \ create_table.7 create_table_as.7 create_trigger.7 \ create_type.7 create_user.7 create_view.7 deallocate.7 \ @@ -216,25 +218,17 @@ MAN7= abort.7 alter_aggregate.7 alter_conversion.7 alter_database.7 \ drop_aggregate.7 drop_cast.7 drop_conversion.7 \ drop_database.7 drop_domain.7 drop_function.7 \ drop_group.7 drop_index.7 drop_language.7 \ - drop_operator.7 drop_operator_class.7 drop_rule.7 \ + drop_operator.7 drop_operator_class.7 drop_role.7 \ + drop_rule.7 \ drop_schema.7 drop_sequence.7 drop_table.7 drop_trigger.7 \ drop_type.7 drop_user.7 drop_view.7 end.7 execute.7 \ explain.7 fetch.7 grant.7 insert.7 listen.7 load.7 \ - lock.7 move.7 notify.7 prepare.7 reindex.7 reset.7 \ - revoke.7 rollback.7 select.7 select_into.7 set.7 \ - set_constraints.7 set_transaction.7 show.7 \ + lock.7 move.7 notify.7 prepare.7 prepare_transaction.7 \ + reindex.7 reset.7 \ + revoke.7 rollback.7 rollback_prepared.7 select.7 \ + select_into.7 set.7 \ + set_constraints.7 set_role.7 set_transaction.7 show.7 \ set_session_authorization.7 start_transaction.7 \ - spi_connect.7 spi_copytuple.7 spi_cursor_close.7 \ - spi_cursor_fetch.7 spi_cursor_find.7 spi_cursor_move.7 \ - spi_cursor_open.7 spi_exec.7 spi_execp.7 spi_execute.7 \ - spi_execute_plan.7 \ - spi_finish.7 spi_fname.7 spi_fnumber.7 spi_freeplan.7 \ - spi_freetuple.7 spi_freetuptable.7 spi_getargcount.7 \ - spi_getargtypeid.7 spi_getbinval.7 spi_getrelname.7 \ - spi_gettype.7 spi_gettypeid.7 spi_getvalue.7 \ - spi_is_cursor_plan.7 spi_modifytuple.7 spi_palloc.7 \ - spi_pfree.7 spi_pop.7 spi_prepare.7 spi_push.7 \ - spi_repalloc.7 spi_returntuple.7 spi_saveplan.7 \ truncate.7 unlisten.7 update.7 vacuum.7 \ alter_operator.7 alter_tablespace.7 alter_type.7 \ create_tablespace.7 drop_tablespace.7 \ diff --git a/databases/postgresql92-server/distinfo b/databases/postgresql92-server/distinfo index 0a61ebc5441a..df22506b50e5 100644 --- a/databases/postgresql92-server/distinfo +++ b/databases/postgresql92-server/distinfo @@ -1,12 +1,15 @@ -MD5 (postgresql/postgresql-base-8.0.3.tar.bz2) = 35ff2b9a3bc5c65f55b4192a334b0e88 -SIZE (postgresql/postgresql-base-8.0.3.tar.bz2) = 7818251 -MD5 (postgresql/postgresql-docs-8.0.3.tar.bz2) = a9bb1e0dbc7ff862a30b6b9ca00b6470 -SIZE (postgresql/postgresql-docs-8.0.3.tar.bz2) = 2213693 -MD5 (postgresql/postgresql-opt-8.0.3.tar.bz2) = ea1ce6f570a4408e934af914de71da0e -SIZE (postgresql/postgresql-opt-8.0.3.tar.bz2) = 133623 -MD5 (postgresql/postgresql-test-8.0.3.tar.bz2) = 4dac47d2c87bb83ba6f2cd788ec794a6 -SIZE (postgresql/postgresql-test-8.0.3.tar.bz2) = 959642 -MD5 (postgresql/hier-Pg8.0.1-0.5.4.diff.gz) = 1d410cfb38253675fee36c8f9ee655e2 -SIZE (postgresql/hier-Pg8.0.1-0.5.4.diff.gz) = 30662 -MD5 (postgresql/pg-803-icu-2005-08-16.diff.gz) = 83cb174132c5dd7aeec622bc5c9a8b0d -SIZE (postgresql/pg-803-icu-2005-08-16.diff.gz) = 4190 +MD5 (postgresql/postgresql-base-8.1.0.tar.bz2) = 61ada6238aebbe6f3850895af25df37b +SHA256 (postgresql/postgresql-base-8.1.0.tar.bz2) = 604b6be364d88a2d0b0a4bae2165be0072bb8e79129c874f9a7fa1734dc8cb38 +SIZE (postgresql/postgresql-base-8.1.0.tar.bz2) = 8027880 +MD5 (postgresql/postgresql-docs-8.1.0.tar.bz2) = 544a41caa516cd9c6a07fa5d604a91bd +SHA256 (postgresql/postgresql-docs-8.1.0.tar.bz2) = 9ef412d3859646ec6d3478cd828c395e56610cc7a54daa18381da53153847d7b +SIZE (postgresql/postgresql-docs-8.1.0.tar.bz2) = 2443376 +MD5 (postgresql/postgresql-opt-8.1.0.tar.bz2) = 5fd9e43abc22e6af1ca819e43eb1fbd2 +SHA256 (postgresql/postgresql-opt-8.1.0.tar.bz2) = a9dbb375428f2250e7fcb5e66be2eaf3b87644f33f36b195b0d87ad91432bb40 +SIZE (postgresql/postgresql-opt-8.1.0.tar.bz2) = 141420 +MD5 (postgresql/postgresql-test-8.1.0.tar.bz2) = 594b045aa80aef1907bbd6b922a1e02b +SHA256 (postgresql/postgresql-test-8.1.0.tar.bz2) = 1fd3b5fb35d39b0fe703124b982cf4b10d6495f99eb3519cb2c59134a8bfcb2f +SIZE (postgresql/postgresql-test-8.1.0.tar.bz2) = 968672 +MD5 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = b1f6f40f6fcc887f35d57bb7aee2ed09 +SHA256 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 714d030be73d3df1fd5f47409e0b059ef1d04ad9cb56255b5d803f25b8c93f1a +SIZE (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 3956 diff --git a/databases/postgresql92-server/files/patch-src-makefiles-Makefile.freebsd b/databases/postgresql92-server/files/patch-src-makefiles-Makefile.freebsd index 89aaa9a2c0cc..81339e98e8db 100644 --- a/databases/postgresql92-server/files/patch-src-makefiles-Makefile.freebsd +++ b/databases/postgresql92-server/files/patch-src-makefiles-Makefile.freebsd @@ -1,14 +1,5 @@ --- src/makefiles/Makefile.freebsd.orig Fri Nov 19 01:41:39 2004 +++ src/makefiles/Makefile.freebsd Tue Dec 21 02:44:09 2004 -@@ -11,7 +11,7 @@ - ifeq ($(findstring sparc,$(host_cpu)), sparc) - CFLAGS_SL = -fPIC -DPIC - else --CFLAGS_SL = -fpic -DPIC -+CFLAGS_SL = -fPIC -DPIC - endif - - @@ -29,3 +29,5 @@ endif diff --git a/databases/postgresql92-server/files/patch-src:backend:utils:misc:postgresql.conf.sample b/databases/postgresql92-server/files/patch-src:backend:utils:misc:postgresql.conf.sample index 07363e882113..da57f46e3552 100644 --- a/databases/postgresql92-server/files/patch-src:backend:utils:misc:postgresql.conf.sample +++ b/databases/postgresql92-server/files/patch-src:backend:utils:misc:postgresql.conf.sample @@ -1,18 +1,18 @@ ---- src/backend/utils/misc/postgresql.conf.sample~ Fri Nov 5 20:16:16 2004 -+++ src/backend/utils/misc/postgresql.conf.sample Tue Dec 21 02:06:45 2004 -@@ -172,6 +172,7 @@ +--- src/backend/utils/misc/postgresql.conf.sample~ Tue Nov 8 00:45:49 2005 ++++ src/backend/utils/misc/postgresql.conf.sample Tue Nov 8 00:47:16 2005 +@@ -206,6 +206,7 @@ # - Where to Log - +log_destination = 'syslog' - #log_destination = 'stderr' # Valid values are combinations of stderr, - # syslog and eventlog, depending on - # platform. -@@ -219,6 +220,7 @@ - - #log_min_duration_statement = -1 # -1 is disabled, in milliseconds. + #log_destination = 'stderr' # Valid values are combinations of + # stderr, syslog and eventlog, + # depending on platform. +@@ -283,6 +284,7 @@ + #log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements + # and their durations, in milliseconds. -+silent_mode = true - #silent_mode = false # DO NOT USE without syslog or redirect_stderr ++silent_mode = on + #silent_mode = off # DO NOT USE without syslog or + # redirect_stderr - # - What to Log - diff --git a/databases/postgresql92-server/pkg-plist-client b/databases/postgresql92-server/pkg-plist-client index 5810e57ecead..cda05962118f 100644 --- a/databases/postgresql92-server/pkg-plist-client +++ b/databases/postgresql92-server/pkg-plist-client @@ -16,19 +16,21 @@ bin/pg_dumpall bin/pg_resetxlog bin/pg_restore bin/psql +bin/reindexdb bin/vacuumdb include/postgresql/server/access/attnum.h include/postgresql/server/access/clog.h include/postgresql/server/access/genam.h include/postgresql/server/access/gist.h +include/postgresql/server/access/gist_private.h include/postgresql/server/access/gistscan.h include/postgresql/server/access/hash.h include/postgresql/server/access/heapam.h include/postgresql/server/access/hio.h include/postgresql/server/access/htup.h -include/postgresql/server/access/ibit.h include/postgresql/server/access/iqual.h include/postgresql/server/access/itup.h +include/postgresql/server/access/multixact.h include/postgresql/server/access/nbtree.h include/postgresql/server/access/printtup.h include/postgresql/server/access/relscan.h @@ -43,6 +45,8 @@ include/postgresql/server/access/transam.h include/postgresql/server/access/tupdesc.h include/postgresql/server/access/tupmacs.h include/postgresql/server/access/tuptoaster.h +include/postgresql/server/access/twophase.h +include/postgresql/server/access/twophase_rmgr.h include/postgresql/server/access/valid.h include/postgresql/server/access/xact.h include/postgresql/server/access/xlog.h @@ -52,7 +56,6 @@ include/postgresql/server/access/xlogutils.h include/postgresql/server/bootstrap/bootstrap.h include/postgresql/server/c.h include/postgresql/server/catalog/catalog.h -include/postgresql/server/catalog/catname.h include/postgresql/server/catalog/catversion.h include/postgresql/server/catalog/dependency.h include/postgresql/server/catalog/heap.h @@ -65,6 +68,9 @@ include/postgresql/server/catalog/pg_amop.h include/postgresql/server/catalog/pg_amproc.h include/postgresql/server/catalog/pg_attrdef.h include/postgresql/server/catalog/pg_attribute.h +include/postgresql/server/catalog/pg_auth_members.h +include/postgresql/server/catalog/pg_authid.h +include/postgresql/server/catalog/pg_autovacuum.h include/postgresql/server/catalog/pg_cast.h include/postgresql/server/catalog/pg_class.h include/postgresql/server/catalog/pg_constraint.h @@ -73,7 +79,6 @@ include/postgresql/server/catalog/pg_conversion.h include/postgresql/server/catalog/pg_database.h include/postgresql/server/catalog/pg_depend.h include/postgresql/server/catalog/pg_description.h -include/postgresql/server/catalog/pg_group.h include/postgresql/server/catalog/pg_index.h include/postgresql/server/catalog/pg_inherits.h include/postgresql/server/catalog/pg_language.h @@ -82,14 +87,14 @@ include/postgresql/server/catalog/pg_listener.h include/postgresql/server/catalog/pg_namespace.h include/postgresql/server/catalog/pg_opclass.h include/postgresql/server/catalog/pg_operator.h +include/postgresql/server/catalog/pg_pltemplate.h include/postgresql/server/catalog/pg_proc.h include/postgresql/server/catalog/pg_rewrite.h -include/postgresql/server/catalog/pg_shadow.h +include/postgresql/server/catalog/pg_shdepend.h include/postgresql/server/catalog/pg_statistic.h include/postgresql/server/catalog/pg_tablespace.h include/postgresql/server/catalog/pg_trigger.h include/postgresql/server/catalog/pg_type.h -include/postgresql/server/catalog/pg_version.h include/postgresql/server/commands/alter.h include/postgresql/server/commands/async.h include/postgresql/server/commands/cluster.h @@ -124,6 +129,10 @@ include/postgresql/server/executor/hashjoin.h include/postgresql/server/executor/instrument.h include/postgresql/server/executor/nodeAgg.h include/postgresql/server/executor/nodeAppend.h +include/postgresql/server/executor/nodeBitmapAnd.h +include/postgresql/server/executor/nodeBitmapHeapscan.h +include/postgresql/server/executor/nodeBitmapIndexscan.h +include/postgresql/server/executor/nodeBitmapOr.h include/postgresql/server/executor/nodeFunctionscan.h include/postgresql/server/executor/nodeGroup.h include/postgresql/server/executor/nodeHash.h @@ -178,6 +187,7 @@ include/postgresql/server/nodes/primnodes.h include/postgresql/server/nodes/print.h include/postgresql/server/nodes/readfuncs.h include/postgresql/server/nodes/relation.h +include/postgresql/server/nodes/tidbitmap.h include/postgresql/server/nodes/value.h include/postgresql/server/optimizer/clauses.h include/postgresql/server/optimizer/cost.h @@ -196,6 +206,7 @@ include/postgresql/server/optimizer/paths.h include/postgresql/server/optimizer/plancat.h include/postgresql/server/optimizer/planmain.h include/postgresql/server/optimizer/planner.h +include/postgresql/server/optimizer/predtest.h include/postgresql/server/optimizer/prep.h include/postgresql/server/optimizer/restrictinfo.h include/postgresql/server/optimizer/subselect.h @@ -293,6 +304,7 @@ include/postgresql/server/storage/pg_shmem.h include/postgresql/server/storage/pmsignal.h include/postgresql/server/storage/pos.h include/postgresql/server/storage/proc.h +include/postgresql/server/storage/procarray.h include/postgresql/server/storage/relfilenode.h include/postgresql/server/storage/s_lock.h include/postgresql/server/storage/shmem.h @@ -320,6 +332,7 @@ include/postgresql/server/utils/dynahash.h include/postgresql/server/utils/dynamic_loader.h include/postgresql/server/utils/elog.h include/postgresql/server/utils/errcodes.h +include/postgresql/server/utils/flatfiles.h include/postgresql/server/utils/fmgroids.h include/postgresql/server/utils/fmgrtab.h include/postgresql/server/utils/formatting.h @@ -340,6 +353,7 @@ include/postgresql/server/utils/palloc.h include/postgresql/server/utils/pg_crc.h include/postgresql/server/utils/pg_locale.h include/postgresql/server/utils/pg_lzcompress.h +include/postgresql/server/utils/pg_rusage.h include/postgresql/server/utils/portal.h include/postgresql/server/utils/ps_status.h include/postgresql/server/utils/rel.h diff --git a/databases/postgresql92-server/pkg-plist-contrib b/databases/postgresql92-server/pkg-plist-contrib index fd3f553e5b25..aba5a7b1cc19 100644 --- a/databases/postgresql92-server/pkg-plist-contrib +++ b/databases/postgresql92-server/pkg-plist-contrib @@ -1,25 +1,17 @@ bin/DBMirror.pl bin/clean_pending.pl bin/dbf2pg -bin/findoidjoins bin/fti.pl -bin/ipc_check -bin/make_oidjoins_check -bin/my2pg.pl -bin/mysql2pgsql bin/oid2name -bin/pg_autovacuum -bin/pg_dumplo bin/pgbench -bin/reindexdb bin/vacuumlo lib/postgresql/_int.so lib/postgresql/autoinc.so lib/postgresql/btree_gist.so +lib/postgresql/pg_buffercache.so lib/postgresql/chkpass.so lib/postgresql/cube.so lib/postgresql/dblink.so -lib/postgresql/dbsize.so lib/postgresql/earthdistance.so lib/postgresql/fti.so lib/postgresql/fuzzystrmatch.so @@ -28,20 +20,15 @@ lib/postgresql/int_aggregate.so lib/postgresql/isbn_issn.so lib/postgresql/lo.so lib/postgresql/ltree.so -lib/postgresql/misc_utils.so lib/postgresql/moddatetime.so -lib/postgresql/noup.so lib/postgresql/pending.so lib/postgresql/pg_trgm.so lib/postgresql/pgcrypto.so lib/postgresql/pgstattuple.so lib/postgresql/refint.so -lib/postgresql/rtree_gist.so lib/postgresql/seg.so -lib/postgresql/string_io.so lib/postgresql/tablefunc.so lib/postgresql/timetravel.so -lib/postgresql/tsearch.so lib/postgresql/tsearch2.so lib/postgresql/user_locks.so %%DOCSDIR%%/README-contrib @@ -53,37 +40,26 @@ lib/postgresql/user_locks.so %%DOCSDIR%%/contrib/README.dbf2pg %%DOCSDIR%%/contrib/README.dblink %%DOCSDIR%%/contrib/README.dbmirror -%%DOCSDIR%%/contrib/README.dbsize %%DOCSDIR%%/contrib/README.earthdistance -%%DOCSDIR%%/contrib/README.findoidjoins %%DOCSDIR%%/contrib/README.fti %%DOCSDIR%%/contrib/README.fuzzystrmatch %%DOCSDIR%%/contrib/README.int_aggregate %%DOCSDIR%%/contrib/README.intarray -%%DOCSDIR%%/contrib/README.ipc_check %%DOCSDIR%%/contrib/README.isbn_issn %%DOCSDIR%%/contrib/README.lo %%DOCSDIR%%/contrib/README.ltree -%%DOCSDIR%%/contrib/README.misc_utils -%%DOCSDIR%%/contrib/README.mysql -%%DOCSDIR%%/contrib/README.noup %%DOCSDIR%%/contrib/README.oid2name -%%DOCSDIR%%/contrib/README.pg_autovacuum -%%DOCSDIR%%/contrib/README.pg_dumplo +%%DOCSDIR%%/contrib/README.pg_buffercache %%DOCSDIR%%/contrib/README.pg_trgm %%DOCSDIR%%/contrib/README.pgbench %%DOCSDIR%%/contrib/README.pgbench_jis %%DOCSDIR%%/contrib/README.pgcrypto %%DOCSDIR%%/contrib/README.pgstattuple %%DOCSDIR%%/contrib/README.pgstattuple.euc_jp -%%DOCSDIR%%/contrib/README.reindexdb -%%DOCSDIR%%/contrib/README.rtree_gist %%DOCSDIR%%/contrib/README.seg %%DOCSDIR%%/contrib/README.soundex %%DOCSDIR%%/contrib/README.spi -%%DOCSDIR%%/contrib/README.string_io %%DOCSDIR%%/contrib/README.tablefunc -%%DOCSDIR%%/contrib/README.tsearch %%DOCSDIR%%/contrib/README.tsearch2 %%DOCSDIR%%/contrib/README.user_locks %%DOCSDIR%%/contrib/README.vacuumlo @@ -100,7 +76,6 @@ share/postgresql/contrib/btree_gist.sql share/postgresql/contrib/chkpass.sql share/postgresql/contrib/cube.sql share/postgresql/contrib/dblink.sql -share/postgresql/contrib/dbsize.sql share/postgresql/contrib/earthdistance.sql share/postgresql/contrib/english.stop share/postgresql/contrib/fti.sql @@ -112,21 +87,17 @@ share/postgresql/contrib/lo.sql share/postgresql/contrib/lo_drop.sql share/postgresql/contrib/lo_test.sql share/postgresql/contrib/ltree.sql -share/postgresql/contrib/misc_utils.sql share/postgresql/contrib/moddatetime.sql -share/postgresql/contrib/noup.sql +share/postgresql/contrib/pg_buffercache.sql share/postgresql/contrib/pg_trgm.sql share/postgresql/contrib/pgcrypto.sql share/postgresql/contrib/pgstattuple.sql share/postgresql/contrib/refint.sql -share/postgresql/contrib/rtree_gist.sql share/postgresql/contrib/russian.stop share/postgresql/contrib/seg.sql share/postgresql/contrib/slaveDatabase.conf -share/postgresql/contrib/string_io.sql share/postgresql/contrib/tablefunc.sql share/postgresql/contrib/timetravel.sql -share/postgresql/contrib/tsearch.sql share/postgresql/contrib/tsearch2.sql share/postgresql/contrib/untsearch2.sql share/postgresql/contrib/user_locks.sql diff --git a/databases/postgresql92-server/pkg-plist-server b/databases/postgresql92-server/pkg-plist-server index 24cff6b753f0..9c00caef50c8 100644 --- a/databases/postgresql92-server/pkg-plist-server +++ b/databases/postgresql92-server/pkg-plist-server @@ -24,10 +24,11 @@ lib/postgresql/utf8_and_iso8859.so lib/postgresql/utf8_and_iso8859_1.so lib/postgresql/utf8_and_johab.so lib/postgresql/utf8_and_sjis.so -lib/postgresql/utf8_and_tcvn.so lib/postgresql/utf8_and_uhc.so lib/postgresql/utf8_and_win1250.so +lib/postgresql/utf8_and_win1252.so lib/postgresql/utf8_and_win1256.so +lib/postgresql/utf8_and_win1258.so lib/postgresql/utf8_and_win874.so lib/postgresql/plpgsql.so %%DOCSDIR%%/README-server @@ -246,6 +247,7 @@ share/postgresql/timezone/Asia/Ujung_Pandang share/postgresql/timezone/Asia/Tel_Aviv share/postgresql/timezone/Asia/Thimbu share/postgresql/timezone/Asia/Ulan_Bator +share/postgresql/timezone/Australia/Currie share/postgresql/timezone/Australia/Darwin share/postgresql/timezone/Australia/Perth share/postgresql/timezone/Australia/Brisbane @@ -365,6 +367,7 @@ share/postgresql/timezone/CET share/postgresql/timezone/MET share/postgresql/timezone/EET share/postgresql/timezone/America/Danmarkshavn +share/postgresql/timezone/America/Coral_Harbour share/postgresql/timezone/America/Scoresbysund share/postgresql/timezone/America/Godthab share/postgresql/timezone/America/Thule |