Hi, I start a new thread for this future upgrade. This firt shot is for the beta1. One of the main feature for this release is Hot Standby ( http://developer.postgresql.org/pgdocs/postgres/hot-standby.html ) Release note here: http://developer.postgresql.org/pgdocs/postgres/release-9-0.html
As usual you must dump/restore your data if you want to try this update. Tested on @amd64 and @sparc64. Comments welcome. Regards, -- Pierre-Emmanuel André <pea at raveland.org> GPG key: 0x7AE329DC
Index: Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql/Makefile,v retrieving revision 1.126 diff -u -p -r1.126 Makefile --- Makefile 23 Mar 2010 10:24:45 -0000 1.126 +++ Makefile 3 May 2010 10:18:29 -0000 @@ -5,7 +5,7 @@ COMMENT-server= PostgreSQL RDBMS (server COMMENT-docs= PostgreSQL RDBMS documentation COMMENT-contrib=PostgreSQL RDBMS contributions -VERSION= 8.4.3 +VERSION= 9.0beta1 DISTNAME= postgresql-${VERSION} PKGNAME-main= postgresql-client-${VERSION} PKGNAME-server= postgresql-server-${VERSION} @@ -13,10 +13,10 @@ PKGNAME-docs= postgresql-docs-${VERSION} PKGNAME-contrib=postgresql-contrib-${VERSION} CATEGORIES= databases -SHARED_LIBS= ecpg 7.1 \ - ecpg_compat 4.1 \ +SHARED_LIBS= ecpg 7.2 \ + ecpg_compat 4.2 \ pgtypes 4.1 \ - pq 5.2 + pq 5.3 HOMEPAGE= http://www.postgresql.org/ @@ -29,7 +29,7 @@ PERMIT_DISTFILES_CDROM= Yes PERMIT_DISTFILES_FTP= Yes WANTLIB= c com_err crypto m readline ssl termcap z -MASTER_SITES= ftp://ftp2.uk.postgresql.org/sites/ftp.postgresql.org/source/v${VERSION}/ \ +MASTER_SITES= ftp://ftp2.uk.postgresql.org/sites/ftp.postgresql.org/source/${VERSION}/ \ ftp://ftp5.us.postgresql.org/pub/PostgreSQL/source/v${VERSION}/ \ ftp://ftp5.es.postgresql.org/mirror/postgresql/source/v${VERSION}/ \ ftp://ftp.postgresql.org/pub/source/v${VERSION}/ @@ -62,7 +62,8 @@ CONFIGURE_ARGS= --disable-rpath --with-o --with-libraries="${LOCALBASE}/lib" \ --with-openssl \ --with-ossp-uuid \ - --with-libxml + --with-libxml \ + --disable-thread-safety .if ${KERBEROS5} == "yes" CONFIGURE_ARGS+=--with-krb5 @@ -79,7 +80,7 @@ CONFIGURE_ARGS+=--disable-spinlocks MODGNU_CONFIG_GUESS_DIRS= ${WRKSRC}/config -INSTALL_TARGET= install +INSTALL_TARGET= install-world LIB_DEPENDS-main= xml2::textproc/libxml Index: distinfo =================================================================== RCS file: /cvs/ports/databases/postgresql/distinfo,v retrieving revision 1.32 diff -u -p -r1.32 distinfo --- distinfo 23 Mar 2010 10:24:45 -0000 1.32 +++ distinfo 3 May 2010 10:18:29 -0000 @@ -1,5 +1,5 @@ -MD5 (postgresql-8.4.3.tar.gz) = cSpdj3iBTS3iBxz0PtMjrA== -RMD160 (postgresql-8.4.3.tar.gz) = 66w4xbMPtg+eiMyQW4UmfSU4EV8= -SHA1 (postgresql-8.4.3.tar.gz) = nGZvqF4Hgvw+VVdmhWvxwrazWqA= -SHA256 (postgresql-8.4.3.tar.gz) = CcPu0ylyNNiKjRsS6/WwFRPX4EKOvI/wKzQXSen7b1Y= -SIZE (postgresql-8.4.3.tar.gz) = 16853436 +MD5 (postgresql-9.0beta1.tar.gz) = rKoIUrlwUkuR6pov0PphyA== +RMD160 (postgresql-9.0beta1.tar.gz) = SWARl2Cftva9twRErEH5Wgz78/E= +SHA1 (postgresql-9.0beta1.tar.gz) = SHdiHkaJs2iNM5tZPgEhUFTsOsM= +SHA256 (postgresql-9.0beta1.tar.gz) = +OBoaVYFoIW1sKHVEtj1vcJKbb4+0TH+pPy64lSgFRw= +SIZE (postgresql-9.0beta1.tar.gz) = 17585554 Index: patches/patch-src_interfaces_ecpg_compatlib_Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql/patches/patch-src_interfaces_ecpg_compatlib_Makefile,v retrieving revision 1.4 diff -u -p -r1.4 patch-src_interfaces_ecpg_compatlib_Makefile --- patches/patch-src_interfaces_ecpg_compatlib_Makefile 21 Jul 2009 19:43:45 -0000 1.4 +++ patches/patch-src_interfaces_ecpg_compatlib_Makefile 3 May 2010 10:18:29 -0000 @@ -1,12 +1,12 @@ $OpenBSD: patch-src_interfaces_ecpg_compatlib_Makefile,v 1.4 2009/07/21 19:43:45 pea Exp $ ---- src/interfaces/ecpg/compatlib/Makefile.orig Thu Jan 1 18:24:02 2009 -+++ src/interfaces/ecpg/compatlib/Makefile Sun May 31 11:59:15 2009 +--- src/interfaces/ecpg/compatlib/Makefile.orig Fri Aug 14 15:28:22 2009 ++++ src/interfaces/ecpg/compatlib/Makefile Mon Dec 28 11:10:32 2009 @@ -14,8 +14,8 @@ top_builddir = ../../../.. include $(top_builddir)/src/Makefile.global NAME= ecpg_compat -SO_MAJOR_VERSION= 3 --SO_MINOR_VERSION= 1 +-SO_MINOR_VERSION= 2 +SO_MAJOR_VERSION= ${LIBecpg_compat_MAJOR} +SO_MINOR_VERSION= ${LIBecpg_compat_MINOR} Index: patches/patch-src_interfaces_ecpg_ecpglib_Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql/patches/patch-src_interfaces_ecpg_ecpglib_Makefile,v retrieving revision 1.4 diff -u -p -r1.4 patch-src_interfaces_ecpg_ecpglib_Makefile --- patches/patch-src_interfaces_ecpg_ecpglib_Makefile 21 Jul 2009 19:43:45 -0000 1.4 +++ patches/patch-src_interfaces_ecpg_ecpglib_Makefile 3 May 2010 10:18:29 -0000 @@ -1,12 +1,12 @@ $OpenBSD: patch-src_interfaces_ecpg_ecpglib_Makefile,v 1.4 2009/07/21 19:43:45 pea Exp $ ---- src/interfaces/ecpg/ecpglib/Makefile.orig Sat Feb 7 18:17:34 2009 -+++ src/interfaces/ecpg/ecpglib/Makefile Sun May 31 11:59:50 2009 +--- src/interfaces/ecpg/ecpglib/Makefile.orig Mon Jul 13 03:37:05 2009 ++++ src/interfaces/ecpg/ecpglib/Makefile Mon Dec 28 11:11:04 2009 @@ -14,8 +14,8 @@ top_builddir = ../../../.. include $(top_builddir)/src/Makefile.global NAME= ecpg -SO_MAJOR_VERSION= 6 --SO_MINOR_VERSION= 1 +-SO_MINOR_VERSION= 2 +SO_MAJOR_VERSION= ${LIBecpg_MAJOR} +SO_MINOR_VERSION= ${LIBecpg_MINOR} Index: patches/patch-src_interfaces_libpq_Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql/patches/patch-src_interfaces_libpq_Makefile,v retrieving revision 1.6 diff -u -p -r1.6 patch-src_interfaces_libpq_Makefile --- patches/patch-src_interfaces_libpq_Makefile 21 Jul 2009 19:43:45 -0000 1.6 +++ patches/patch-src_interfaces_libpq_Makefile 3 May 2010 10:18:29 -0000 @@ -1,12 +1,12 @@ $OpenBSD: patch-src_interfaces_libpq_Makefile,v 1.6 2009/07/21 19:43:45 pea Exp $ ---- src/interfaces/libpq/Makefile.orig Mon Jan 5 10:27:19 2009 -+++ src/interfaces/libpq/Makefile Sun May 31 12:00:52 2009 +--- src/interfaces/libpq/Makefile.orig Fri Aug 28 22:26:19 2009 ++++ src/interfaces/libpq/Makefile Mon Dec 28 11:11:34 2009 @@ -16,8 +16,8 @@ include $(top_builddir)/src/Makefile.global # shared library parameters NAME= pq -SO_MAJOR_VERSION= 5 --SO_MINOR_VERSION= 2 +-SO_MINOR_VERSION= 3 +SO_MAJOR_VERSION= ${LIBpq_MAJOR} +SO_MINOR_VERSION= ${LIBpq_MINOR} Index: pkg/PLIST-contrib =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-contrib,v retrieving revision 1.6 diff -u -p -r1.6 PLIST-contrib --- pkg/PLIST-contrib 23 Mar 2010 10:24:45 -0000 1.6 +++ pkg/PLIST-contrib 3 May 2010 10:18:29 -0000 @@ -76,6 +76,7 @@ share/postgresql/contrib/tablefunc.sql share/postgresql/contrib/test_parser.sql share/postgresql/contrib/timetravel.sql share/postgresql/contrib/tsearch2.sql +share/postgresql/contrib/unaccent.sql share/postgresql/contrib/uninstall__int.sql share/postgresql/contrib/uninstall_adminpack.sql share/postgresql/contrib/uninstall_btree_gin.sql @@ -107,5 +108,6 @@ share/postgresql/contrib/uninstall_sslin share/postgresql/contrib/uninstall_tablefunc.sql share/postgresql/contrib/uninstall_test_parser.sql share/postgresql/contrib/uninstall_tsearch2.sql +share/postgresql/contrib/uninstall_unaccent.sql share/postgresql/contrib/uninstall_uuid-ossp.sql share/postgresql/contrib/uuid-ossp.sql Index: pkg/PLIST-docs =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v retrieving revision 1.44 diff -u -p -r1.44 PLIST-docs --- pkg/PLIST-docs 23 Mar 2010 10:24:45 -0000 1.44 +++ pkg/PLIST-docs 3 May 2010 10:18:29 -0000 @@ -41,6 +41,7 @@ share/doc/postgresql/html/app-reindexdb. share/doc/postgresql/html/app-vacuumdb.html share/doc/postgresql/html/appendixes.html share/doc/postgresql/html/applevel-consistency.html +share/doc/postgresql/html/archive-recovery-settings.html share/doc/postgresql/html/arrays.html share/doc/postgresql/html/auth-methods.html share/doc/postgresql/html/auth-pg-hba-conf.html @@ -48,6 +49,7 @@ share/doc/postgresql/html/auth-username- share/doc/postgresql/html/auto-explain.html share/doc/postgresql/html/backup-dump.html share/doc/postgresql/html/backup-file.html +share/doc/postgresql/html/backup-incremental-updated.html share/doc/postgresql/html/backup.html share/doc/postgresql/html/biblio.html share/doc/postgresql/html/bki-commands.html @@ -72,6 +74,8 @@ share/doc/postgresql/html/catalog-pg-cla share/doc/postgresql/html/catalog-pg-constraint.html share/doc/postgresql/html/catalog-pg-conversion.html share/doc/postgresql/html/catalog-pg-database.html +share/doc/postgresql/html/catalog-pg-db-role-setting.html +share/doc/postgresql/html/catalog-pg-default-acl.html share/doc/postgresql/html/catalog-pg-depend.html share/doc/postgresql/html/catalog-pg-description.html share/doc/postgresql/html/catalog-pg-enum.html @@ -80,8 +84,8 @@ share/doc/postgresql/html/catalog-pg-for share/doc/postgresql/html/catalog-pg-index.html share/doc/postgresql/html/catalog-pg-inherits.html share/doc/postgresql/html/catalog-pg-language.html +share/doc/postgresql/html/catalog-pg-largeobject-metadata.html share/doc/postgresql/html/catalog-pg-largeobject.html -share/doc/postgresql/html/catalog-pg-listener.html share/doc/postgresql/html/catalog-pg-namespace.html share/doc/postgresql/html/catalog-pg-opclass.html share/doc/postgresql/html/catalog-pg-operator.html @@ -124,6 +128,7 @@ share/doc/postgresql/html/contrib-dblink share/doc/postgresql/html/contrib-dblink-exec.html share/doc/postgresql/html/contrib-dblink-fetch.html share/doc/postgresql/html/contrib-dblink-get-connections.html +share/doc/postgresql/html/contrib-dblink-get-notify.html share/doc/postgresql/html/contrib-dblink-get-pkey.html share/doc/postgresql/html/contrib-dblink-get-result.html share/doc/postgresql/html/contrib-dblink-is-busy.html @@ -172,6 +177,7 @@ share/doc/postgresql/html/ddl-system-col share/doc/postgresql/html/ddl.html share/doc/postgresql/html/dict-int.html share/doc/postgresql/html/dict-xsyn.html +share/doc/postgresql/html/different-replication-solutions.html share/doc/postgresql/html/disk-full.html share/doc/postgresql/html/disk-usage.html share/doc/postgresql/html/diskusage.html @@ -267,6 +273,7 @@ share/doc/postgresql/html/gist.html share/doc/postgresql/html/git.html share/doc/postgresql/html/high-availability.html share/doc/postgresql/html/history.html +share/doc/postgresql/html/hot-standby.html share/doc/postgresql/html/hstore.html share/doc/postgresql/html/index-catalog.html share/doc/postgresql/html/index-cost-estimation.html @@ -333,6 +340,7 @@ share/doc/postgresql/html/infoschema-sql share/doc/postgresql/html/infoschema-table-constraints.html share/doc/postgresql/html/infoschema-table-privileges.html share/doc/postgresql/html/infoschema-tables.html +share/doc/postgresql/html/infoschema-triggered-update-columns.html share/doc/postgresql/html/infoschema-triggers.html share/doc/postgresql/html/infoschema-usage-privileges.html share/doc/postgresql/html/infoschema-user-mapping-options.html @@ -388,6 +396,7 @@ share/doc/postgresql/html/lo-intro.html share/doc/postgresql/html/lo.html share/doc/postgresql/html/locale.html share/doc/postgresql/html/locking-indexes.html +share/doc/postgresql/html/log-shipping-alternative.html share/doc/postgresql/html/logfile-maintenance.html share/doc/postgresql/html/ltree.html share/doc/postgresql/html/maintenance.html @@ -414,6 +423,7 @@ share/doc/postgresql/html/oid2name.html share/doc/postgresql/html/overview.html share/doc/postgresql/html/pageinspect.html share/doc/postgresql/html/parser-stage.html +share/doc/postgresql/html/passwordcheck.html share/doc/postgresql/html/performance-tips.html share/doc/postgresql/html/perm-functions.html share/doc/postgresql/html/pgbench.html @@ -429,13 +439,13 @@ share/doc/postgresql/html/planner-optimi share/doc/postgresql/html/planner-stats-details.html share/doc/postgresql/html/planner-stats.html share/doc/postgresql/html/plhandler.html +share/doc/postgresql/html/plperl-builtins.html share/doc/postgresql/html/plperl-data.html -share/doc/postgresql/html/plperl-database.html share/doc/postgresql/html/plperl-funcs.html share/doc/postgresql/html/plperl-global.html -share/doc/postgresql/html/plperl-missing.html share/doc/postgresql/html/plperl-triggers.html share/doc/postgresql/html/plperl-trusted.html +share/doc/postgresql/html/plperl-under-the-hood.html share/doc/postgresql/html/plperl.html share/doc/postgresql/html/plpgsql-control-structures.html share/doc/postgresql/html/plpgsql-cursors.html @@ -450,9 +460,14 @@ share/doc/postgresql/html/plpgsql-statem share/doc/postgresql/html/plpgsql-structure.html share/doc/postgresql/html/plpgsql-trigger.html share/doc/postgresql/html/plpgsql.html +share/doc/postgresql/html/plpython-data.html share/doc/postgresql/html/plpython-database.html +share/doc/postgresql/html/plpython-do.html share/doc/postgresql/html/plpython-funcs.html +share/doc/postgresql/html/plpython-python23.html +share/doc/postgresql/html/plpython-sharing.html share/doc/postgresql/html/plpython-trigger.html +share/doc/postgresql/html/plpython-util.html share/doc/postgresql/html/plpython.html share/doc/postgresql/html/pltcl-data.html share/doc/postgresql/html/pltcl-dbaccess.html @@ -474,6 +489,7 @@ share/doc/postgresql/html/protocol-flow. share/doc/postgresql/html/protocol-message-formats.html share/doc/postgresql/html/protocol-message-types.html share/doc/postgresql/html/protocol-overview.html +share/doc/postgresql/html/protocol-replication.html share/doc/postgresql/html/protocol.html share/doc/postgresql/html/queries-limit.html share/doc/postgresql/html/queries-order.html @@ -486,6 +502,8 @@ share/doc/postgresql/html/queries-with.h share/doc/postgresql/html/queries.html share/doc/postgresql/html/query-path.html share/doc/postgresql/html/querytree.html +share/doc/postgresql/html/recovery-config.html +share/doc/postgresql/html/recovery-target-settings.html share/doc/postgresql/html/reference-client.html share/doc/postgresql/html/reference-server.html share/doc/postgresql/html/reference.html @@ -662,6 +680,7 @@ share/doc/postgresql/html/release-8-4-1. share/doc/postgresql/html/release-8-4-2.html share/doc/postgresql/html/release-8-4-3.html share/doc/postgresql/html/release-8-4.html +share/doc/postgresql/html/release-9-0.html share/doc/postgresql/html/release.html share/doc/postgresql/html/resources.html share/doc/postgresql/html/role-attributes.html @@ -713,9 +732,11 @@ share/doc/postgresql/html/spi-spi-cursor share/doc/postgresql/html/spi-spi-cursor-find.html share/doc/postgresql/html/spi-spi-cursor-move.html share/doc/postgresql/html/spi-spi-cursor-open-with-args.html +share/doc/postgresql/html/spi-spi-cursor-open-with-paramlist.html share/doc/postgresql/html/spi-spi-cursor-open.html share/doc/postgresql/html/spi-spi-exec.html share/doc/postgresql/html/spi-spi-execp.html +share/doc/postgresql/html/spi-spi-execute-plan-with-paramlist.html share/doc/postgresql/html/spi-spi-execute-plan.html share/doc/postgresql/html/spi-spi-execute-with-args.html share/doc/postgresql/html/spi-spi-execute.html @@ -739,6 +760,7 @@ share/doc/postgresql/html/spi-spi-palloc share/doc/postgresql/html/spi-spi-pfree.html share/doc/postgresql/html/spi-spi-pop.html share/doc/postgresql/html/spi-spi-prepare-cursor.html +share/doc/postgresql/html/spi-spi-prepare-params.html share/doc/postgresql/html/spi-spi-prepare.html share/doc/postgresql/html/spi-spi-push.html share/doc/postgresql/html/spi-spi-returntuple.html @@ -751,12 +773,14 @@ share/doc/postgresql/html/sql-abort.html share/doc/postgresql/html/sql-alteraggregate.html share/doc/postgresql/html/sql-alterconversion.html share/doc/postgresql/html/sql-alterdatabase.html +share/doc/postgresql/html/sql-alterdefaultprivileges.html share/doc/postgresql/html/sql-alterdomain.html share/doc/postgresql/html/sql-alterforeigndatawrapper.html share/doc/postgresql/html/sql-alterfunction.html share/doc/postgresql/html/sql-altergroup.html share/doc/postgresql/html/sql-alterindex.html share/doc/postgresql/html/sql-alterlanguage.html +share/doc/postgresql/html/sql-alterlargeobject.html share/doc/postgresql/html/sql-alteropclass.html share/doc/postgresql/html/sql-alteroperator.html share/doc/postgresql/html/sql-alteropfamily.html @@ -820,6 +844,7 @@ share/doc/postgresql/html/sql-deallocate share/doc/postgresql/html/sql-declare.html share/doc/postgresql/html/sql-delete.html share/doc/postgresql/html/sql-discard.html +share/doc/postgresql/html/sql-do.html share/doc/postgresql/html/sql-drop-owned.html share/doc/postgresql/html/sql-dropaggregate.html share/doc/postgresql/html/sql-dropcast.html @@ -883,6 +908,7 @@ share/doc/postgresql/html/sql-set-transa share/doc/postgresql/html/sql-set.html share/doc/postgresql/html/sql-show.html share/doc/postgresql/html/sql-start-transaction.html +share/doc/postgresql/html/sql-syntax-calling-funcs.html share/doc/postgresql/html/sql-syntax-lexical.html share/doc/postgresql/html/sql-syntax.html share/doc/postgresql/html/sql-truncate.html @@ -894,6 +920,7 @@ share/doc/postgresql/html/sql.html share/doc/postgresql/html/ssh-tunnels.html share/doc/postgresql/html/ssl-tcp.html share/doc/postgresql/html/sslinfo.html +share/doc/postgresql/html/standby-settings.html share/doc/postgresql/html/storage-file-layout.html share/doc/postgresql/html/storage-fsm.html share/doc/postgresql/html/storage-page-layout.html @@ -954,6 +981,7 @@ share/doc/postgresql/html/typeconv-overv share/doc/postgresql/html/typeconv-query.html share/doc/postgresql/html/typeconv-union-case.html share/doc/postgresql/html/typeconv.html +share/doc/postgresql/html/unaccent.html share/doc/postgresql/html/unsupported-features-sql-standard.html share/doc/postgresql/html/user-manag.html share/doc/postgresql/html/using-explain.html @@ -983,6 +1011,7 @@ share/doc/postgresql/html/wal-internals. share/doc/postgresql/html/wal-intro.html share/doc/postgresql/html/wal-reliability.html share/doc/postgresql/html/wal.html +share/doc/postgresql/html/warm-standby-failover.html share/doc/postgresql/html/warm-standby.html share/doc/postgresql/html/xaggr.html share/doc/postgresql/html/xfunc-c.html Index: pkg/PLIST-main =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-main,v retrieving revision 1.16 diff -u -p -r1.16 PLIST-main --- pkg/PLIST-main 23 Mar 2010 10:24:45 -0000 1.16 +++ pkg/PLIST-main 3 May 2010 10:18:29 -0000 @@ -28,7 +28,6 @@ include/postgresql/informix/ include/postgresql/informix/esql/ include/postgresql/informix/esql/datetime.h include/postgresql/informix/esql/decimal.h -include/postgresql/informix/esql/sqlda.h include/postgresql/informix/esql/sqltypes.h include/postgresql/internal/ include/postgresql/internal/c.h @@ -53,6 +52,9 @@ include/postgresql/pgtypes_timestamp.h include/postgresql/postgres_ext.h include/postgresql/sql3types.h include/postgresql/sqlca.h +include/postgresql/sqlda-compat.h +include/postgresql/sqlda-native.h +include/postgresql/sqlda.h lib/libecpg.a @comment lib/libecpg.so @comment lib/libecpg.so.7 @@ -74,7 +76,6 @@ lib/postgresql/ lib/postgresql/pgxs/ lib/postgresql/pgxs/config/ lib/postgresql/pgxs/config/install-sh -lib/postgresql/pgxs/config/mkinstalldirs lib/postgresql/pgxs/src/ lib/postgresql/pgxs/src/Makefile.global lib/postgresql/pgxs/src/Makefile.port @@ -100,146 +101,211 @@ lib/postgresql/pgxs/src/test/regress/ @man man/man1/psql.1 @man man/man1/reindexdb.1 @man man/man1/vacuumdb.1 -...@man man/man7/abort.7 -...@man man/man7/alter_aggregate.7 -...@man man/man7/alter_conversion.7 -...@man man/man7/alter_database.7 -...@man man/man7/alter_domain.7 -...@man man/man7/alter_foreign_data_wrapper.7 -...@man man/man7/alter_function.7 -...@man man/man7/alter_group.7 -...@man man/man7/alter_index.7 -...@man man/man7/alter_language.7 -...@man man/man7/alter_operator.7 -...@man man/man7/alter_operator_class.7 -...@man man/man7/alter_operator_family.7 -...@man man/man7/alter_role.7 -...@man man/man7/alter_schema.7 -...@man man/man7/alter_sequence.7 -...@man man/man7/alter_server.7 -...@man man/man7/alter_table.7 -...@man man/man7/alter_tablespace.7 -...@man man/man7/alter_text_search_configuration.7 -...@man man/man7/alter_text_search_dictionary.7 -...@man man/man7/alter_text_search_parser.7 -...@man man/man7/alter_text_search_template.7 -...@man man/man7/alter_trigger.7 -...@man man/man7/alter_type.7 -...@man man/man7/alter_user.7 -...@man man/man7/alter_user_mapping.7 -...@man man/man7/alter_view.7 -...@man man/man7/analyze.7 -...@man man/man7/begin.7 -...@man man/man7/checkpoint.7 -...@man man/man7/close.7 -...@man man/man7/cluster.7 -...@man man/man7/comment.7 -...@man man/man7/commit.7 -...@man man/man7/commit_prepared.7 -...@man man/man7/copy.7 -...@man man/man7/create_aggregate.7 -...@man man/man7/create_cast.7 -...@man man/man7/create_constraint_trigger.7 -...@man man/man7/create_conversion.7 -...@man man/man7/create_database.7 -...@man man/man7/create_domain.7 -...@man man/man7/create_foreign_data_wrapper.7 -...@man man/man7/create_function.7 -...@man man/man7/create_group.7 -...@man man/man7/create_index.7 -...@man man/man7/create_language.7 -...@man man/man7/create_operator.7 -...@man man/man7/create_operator_class.7 -...@man man/man7/create_operator_family.7 -...@man man/man7/create_role.7 -...@man man/man7/create_rule.7 -...@man man/man7/create_schema.7 -...@man man/man7/create_sequence.7 -...@man man/man7/create_server.7 -...@man man/man7/create_table.7 -...@man man/man7/create_table_as.7 -...@man man/man7/create_tablespace.7 -...@man man/man7/create_text_search_configuration.7 -...@man man/man7/create_text_search_dictionary.7 -...@man man/man7/create_text_search_parser.7 -...@man man/man7/create_text_search_template.7 -...@man man/man7/create_trigger.7 -...@man man/man7/create_type.7 -...@man man/man7/create_user.7 -...@man man/man7/create_user_mapping.7 -...@man man/man7/create_view.7 -...@man man/man7/deallocate.7 -...@man man/man7/declare.7 -...@man man/man7/delete.7 -...@man man/man7/discard.7 -...@man man/man7/drop_aggregate.7 -...@man man/man7/drop_cast.7 -...@man man/man7/drop_conversion.7 -...@man man/man7/drop_database.7 -...@man man/man7/drop_domain.7 -...@man man/man7/drop_foreign_data_wrapper.7 -...@man man/man7/drop_function.7 -...@man man/man7/drop_group.7 -...@man man/man7/drop_index.7 -...@man man/man7/drop_language.7 -...@man man/man7/drop_operator.7 -...@man man/man7/drop_operator_class.7 -...@man man/man7/drop_operator_family.7 -...@man man/man7/drop_owned.7 -...@man man/man7/drop_role.7 -...@man man/man7/drop_rule.7 -...@man man/man7/drop_schema.7 -...@man man/man7/drop_sequence.7 -...@man man/man7/drop_server.7 -...@man man/man7/drop_table.7 -...@man man/man7/drop_tablespace.7 -...@man man/man7/drop_text_search_configuration.7 -...@man man/man7/drop_text_search_dictionary.7 -...@man man/man7/drop_text_search_parser.7 -...@man man/man7/drop_text_search_template.7 -...@man man/man7/drop_trigger.7 -...@man man/man7/drop_type.7 -...@man man/man7/drop_user.7 -...@man man/man7/drop_user_mapping.7 -...@man man/man7/drop_view.7 -...@man man/man7/end.7 -...@man man/man7/execute.7 -...@man man/man7/explain.7 -...@man man/man7/fetch.7 -...@man man/man7/grant.7 -...@man man/man7/insert.7 -...@man man/man7/listen.7 -...@man man/man7/load.7 -...@man man/man7/lock.7 -...@man man/man7/move.7 -...@man man/man7/notify.7 -...@man man/man7/prepare.7 -...@man man/man7/prepare_transaction.7 -...@man man/man7/reassign_owned.7 -...@man man/man7/reindex.7 -...@man man/man7/release_savepoint.7 -...@man man/man7/reset.7 -...@man man/man7/revoke.7 -...@man man/man7/rollback.7 -...@man man/man7/rollback_prepared.7 -...@man man/man7/rollback_to_savepoint.7 -...@man man/man7/savepoint.7 -...@man man/man7/select.7 -...@man man/man7/select_into.7 -...@man man/man7/set.7 -...@man man/man7/set_constraints.7 -...@man man/man7/set_role.7 -...@man man/man7/set_session_authorization.7 -...@man man/man7/set_transaction.7 -...@man man/man7/show.7 -...@man man/man7/start_transaction.7 -...@man man/man7/table.7 -...@man man/man7/truncate.7 -...@man man/man7/unlisten.7 -...@man man/man7/update.7 -...@man man/man7/vacuum.7 -...@man man/man7/values.7 -...@man man/man7/with.7 +...@man man/man3/SPI_connect.3 +...@man man/man3/SPI_copytuple.3 +...@man man/man3/SPI_cursor_close.3 +...@man man/man3/SPI_cursor_fetch.3 +...@man man/man3/SPI_cursor_find.3 +...@man man/man3/SPI_cursor_move.3 +...@man man/man3/SPI_cursor_open.3 +...@man man/man3/SPI_cursor_open_with_args.3 +...@man man/man3/SPI_cursor_open_with_paramlist.3 +...@man man/man3/SPI_exec.3 +...@man man/man3/SPI_execp.3 +...@man man/man3/SPI_execute.3 +...@man man/man3/SPI_execute_plan.3 +...@man man/man3/SPI_execute_plan_with_paramlist.3 +...@man man/man3/SPI_execute_with_args.3 +...@man man/man3/SPI_finish.3 +...@man man/man3/SPI_fname.3 +...@man man/man3/SPI_fnumber.3 +...@man man/man3/SPI_freeplan.3 +...@man man/man3/SPI_freetuple.3 +...@man man/man3/SPI_freetuptable.3 +...@man man/man3/SPI_getargcount.3 +...@man man/man3/SPI_getargtypeid.3 +...@man man/man3/SPI_getbinval.3 +...@man man/man3/SPI_getnspname.3 +...@man man/man3/SPI_getrelname.3 +...@man man/man3/SPI_gettype.3 +...@man man/man3/SPI_gettypeid.3 +...@man man/man3/SPI_getvalue.3 +...@man man/man3/SPI_is_cursor_plan.3 +...@man man/man3/SPI_modifytuple.3 +...@man man/man3/SPI_palloc.3 +...@man man/man3/SPI_pfree.3 +...@man man/man3/SPI_pop.3 +...@man man/man3/SPI_prepare.3 +...@man man/man3/SPI_prepare_cursor.3 +...@man man/man3/SPI_prepare_params.3 +...@man man/man3/SPI_push.3 +...@man man/man3/SPI_repalloc.3 +...@man man/man3/SPI_returntuple.3 +...@man man/man3/SPI_saveplan.3 +...@man man/man3/SPI_scroll_cursor_fetch.3 +...@man man/man3/SPI_scroll_cursor_move.3 +...@man man/man3/dblink.3 +...@man man/man3/dblink_build_sql_delete.3 +...@man man/man3/dblink_build_sql_insert.3 +...@man man/man3/dblink_build_sql_update.3 +...@man man/man3/dblink_cancel_query.3 +...@man man/man3/dblink_close.3 +...@man man/man3/dblink_connect.3 +...@man man/man3/dblink_connect_u.3 +...@man man/man3/dblink_disconnect.3 +...@man man/man3/dblink_error_message.3 +...@man man/man3/dblink_exec.3 +...@man man/man3/dblink_fetch.3 +...@man man/man3/dblink_get_connections.3 +...@man man/man3/dblink_get_notify.3 +...@man man/man3/dblink_get_pkey.3 +...@man man/man3/dblink_get_result.3 +...@man man/man3/dblink_is_busy.3 +...@man man/man3/dblink_open.3 +...@man man/man3/dblink_send_query.3 +...@man man/man7/ABORT.7 +...@man man/man7/ALTER_AGGREGATE.7 +...@man man/man7/ALTER_CONVERSION.7 +...@man man/man7/ALTER_DATABASE.7 +...@man man/man7/ALTER_DEFAULT_PRIVILEGES.7 +...@man man/man7/ALTER_DOMAIN.7 +...@man man/man7/ALTER_FOREIGN_DATA_WRAPPER.7 +...@man man/man7/ALTER_FUNCTION.7 +...@man man/man7/ALTER_GROUP.7 +...@man man/man7/ALTER_INDEX.7 +...@man man/man7/ALTER_LANGUAGE.7 +...@man man/man7/ALTER_LARGE_OBJECT.7 +...@man man/man7/ALTER_OPERATOR.7 +...@man man/man7/ALTER_OPERATOR_CLASS.7 +...@man man/man7/ALTER_OPERATOR_FAMILY.7 +...@man man/man7/ALTER_ROLE.7 +...@man man/man7/ALTER_SCHEMA.7 +...@man man/man7/ALTER_SEQUENCE.7 +...@man man/man7/ALTER_SERVER.7 +...@man man/man7/ALTER_TABLE.7 +...@man man/man7/ALTER_TABLESPACE.7 +...@man man/man7/ALTER_TEXT_SEARCH_CONFIGURATION.7 +...@man man/man7/ALTER_TEXT_SEARCH_DICTIONARY.7 +...@man man/man7/ALTER_TEXT_SEARCH_PARSER.7 +...@man man/man7/ALTER_TEXT_SEARCH_TEMPLATE.7 +...@man man/man7/ALTER_TRIGGER.7 +...@man man/man7/ALTER_TYPE.7 +...@man man/man7/ALTER_USER.7 +...@man man/man7/ALTER_USER_MAPPING.7 +...@man man/man7/ALTER_VIEW.7 +...@man man/man7/ANALYZE.7 +...@man man/man7/BEGIN.7 +...@man man/man7/CHECKPOINT.7 +...@man man/man7/CLOSE.7 +...@man man/man7/CLUSTER.7 +...@man man/man7/COMMENT.7 +...@man man/man7/COMMIT.7 +...@man man/man7/COMMIT_PREPARED.7 +...@man man/man7/COPY.7 +...@man man/man7/CREATE_AGGREGATE.7 +...@man man/man7/CREATE_CAST.7 +...@man man/man7/CREATE_CONSTRAINT_TRIGGER.7 +...@man man/man7/CREATE_CONVERSION.7 +...@man man/man7/CREATE_DATABASE.7 +...@man man/man7/CREATE_DOMAIN.7 +...@man man/man7/CREATE_FOREIGN_DATA_WRAPPER.7 +...@man man/man7/CREATE_FUNCTION.7 +...@man man/man7/CREATE_GROUP.7 +...@man man/man7/CREATE_INDEX.7 +...@man man/man7/CREATE_LANGUAGE.7 +...@man man/man7/CREATE_OPERATOR.7 +...@man man/man7/CREATE_OPERATOR_CLASS.7 +...@man man/man7/CREATE_OPERATOR_FAMILY.7 +...@man man/man7/CREATE_ROLE.7 +...@man man/man7/CREATE_RULE.7 +...@man man/man7/CREATE_SCHEMA.7 +...@man man/man7/CREATE_SEQUENCE.7 +...@man man/man7/CREATE_SERVER.7 +...@man man/man7/CREATE_TABLE.7 +...@man man/man7/CREATE_TABLESPACE.7 +...@man man/man7/CREATE_TABLE_AS.7 +...@man man/man7/CREATE_TEXT_SEARCH_CONFIGURATION.7 +...@man man/man7/CREATE_TEXT_SEARCH_DICTIONARY.7 +...@man man/man7/CREATE_TEXT_SEARCH_PARSER.7 +...@man man/man7/CREATE_TEXT_SEARCH_TEMPLATE.7 +...@man man/man7/CREATE_TRIGGER.7 +...@man man/man7/CREATE_TYPE.7 +...@man man/man7/CREATE_USER.7 +...@man man/man7/CREATE_USER_MAPPING.7 +...@man man/man7/CREATE_VIEW.7 +...@man man/man7/DEALLOCATE.7 +...@man man/man7/DECLARE.7 +...@man man/man7/DELETE.7 +...@man man/man7/DISCARD.7 +...@man man/man7/DO.7 +...@man man/man7/DROP_AGGREGATE.7 +...@man man/man7/DROP_CAST.7 +...@man man/man7/DROP_CONVERSION.7 +...@man man/man7/DROP_DATABASE.7 +...@man man/man7/DROP_DOMAIN.7 +...@man man/man7/DROP_FOREIGN_DATA_WRAPPER.7 +...@man man/man7/DROP_FUNCTION.7 +...@man man/man7/DROP_GROUP.7 +...@man man/man7/DROP_INDEX.7 +...@man man/man7/DROP_LANGUAGE.7 +...@man man/man7/DROP_OPERATOR.7 +...@man man/man7/DROP_OPERATOR_CLASS.7 +...@man man/man7/DROP_OPERATOR_FAMILY.7 +...@man man/man7/DROP_OWNED.7 +...@man man/man7/DROP_ROLE.7 +...@man man/man7/DROP_RULE.7 +...@man man/man7/DROP_SCHEMA.7 +...@man man/man7/DROP_SEQUENCE.7 +...@man man/man7/DROP_SERVER.7 +...@man man/man7/DROP_TABLE.7 +...@man man/man7/DROP_TABLESPACE.7 +...@man man/man7/DROP_TEXT_SEARCH_CONFIGURATION.7 +...@man man/man7/DROP_TEXT_SEARCH_DICTIONARY.7 +...@man man/man7/DROP_TEXT_SEARCH_PARSER.7 +...@man man/man7/DROP_TEXT_SEARCH_TEMPLATE.7 +...@man man/man7/DROP_TRIGGER.7 +...@man man/man7/DROP_TYPE.7 +...@man man/man7/DROP_USER.7 +...@man man/man7/DROP_USER_MAPPING.7 +...@man man/man7/DROP_VIEW.7 +...@man man/man7/END.7 +...@man man/man7/EXECUTE.7 +...@man man/man7/EXPLAIN.7 +...@man man/man7/FETCH.7 +...@man man/man7/GRANT.7 +...@man man/man7/INSERT.7 +...@man man/man7/LISTEN.7 +...@man man/man7/LOAD.7 +...@man man/man7/LOCK.7 +...@man man/man7/MOVE.7 +...@man man/man7/NOTIFY.7 +...@man man/man7/PREPARE.7 +...@man man/man7/PREPARE_TRANSACTION.7 +...@man man/man7/REASSIGN_OWNED.7 +...@man man/man7/REINDEX.7 +...@man man/man7/RELEASE_SAVEPOINT.7 +...@man man/man7/RESET.7 +...@man man/man7/REVOKE.7 +...@man man/man7/ROLLBACK.7 +...@man man/man7/ROLLBACK_PREPARED.7 +...@man man/man7/ROLLBACK_TO_SAVEPOINT.7 +...@man man/man7/SAVEPOINT.7 +...@man man/man7/SELECT.7 +...@man man/man7/SELECT_INTO.7 +...@man man/man7/SET.7 +...@man man/man7/SET_CONSTRAINTS.7 +...@man man/man7/SET_ROLE.7 +...@man man/man7/SET_SESSION_AUTHORIZATION.7 +...@man man/man7/SET_TRANSACTION.7 +...@man man/man7/SHOW.7 +...@man man/man7/START_TRANSACTION.7 +...@man man/man7/TABLE.7 +...@man man/man7/TRUNCATE.7 +...@man man/man7/UNLISTEN.7 +...@man man/man7/UPDATE.7 +...@man man/man7/VACUUM.7 +...@man man/man7/VALUES.7 +...@man man/man7/WITH.7 share/postgresql/ share/postgresql/conversion_create.sql share/postgresql/information_schema.sql Index: pkg/PLIST-server =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-server,v retrieving revision 1.18 diff -u -p -r1.18 PLIST-server --- pkg/PLIST-server 23 Mar 2010 10:24:45 -0000 1.18 +++ pkg/PLIST-server 3 May 2010 10:18:29 -0000 @@ -39,6 +39,7 @@ include/postgresql/server/access/slru.h include/postgresql/server/access/subtrans.h include/postgresql/server/access/sysattr.h include/postgresql/server/access/transam.h +include/postgresql/server/access/tupconvert.h include/postgresql/server/access/tupdesc.h include/postgresql/server/access/tupmacs.h include/postgresql/server/access/tuptoaster.h @@ -78,6 +79,8 @@ include/postgresql/server/catalog/pg_con include/postgresql/server/catalog/pg_conversion.h include/postgresql/server/catalog/pg_conversion_fn.h include/postgresql/server/catalog/pg_database.h +include/postgresql/server/catalog/pg_db_role_setting.h +include/postgresql/server/catalog/pg_default_acl.h include/postgresql/server/catalog/pg_depend.h include/postgresql/server/catalog/pg_description.h include/postgresql/server/catalog/pg_enum.h @@ -88,7 +91,7 @@ include/postgresql/server/catalog/pg_inh include/postgresql/server/catalog/pg_inherits_fn.h include/postgresql/server/catalog/pg_language.h include/postgresql/server/catalog/pg_largeobject.h -include/postgresql/server/catalog/pg_listener.h +include/postgresql/server/catalog/pg_largeobject_metadata.h include/postgresql/server/catalog/pg_namespace.h include/postgresql/server/catalog/pg_opclass.h include/postgresql/server/catalog/pg_operator.h @@ -110,6 +113,7 @@ include/postgresql/server/catalog/pg_ts_ include/postgresql/server/catalog/pg_type.h include/postgresql/server/catalog/pg_type_fn.h include/postgresql/server/catalog/pg_user_mapping.h +include/postgresql/server/catalog/schemapg.h include/postgresql/server/catalog/storage.h include/postgresql/server/catalog/toasting.h include/postgresql/server/commands/ @@ -136,7 +140,6 @@ include/postgresql/server/commands/typec include/postgresql/server/commands/user.h include/postgresql/server/commands/vacuum.h include/postgresql/server/commands/variable.h -include/postgresql/server/commands/version.h include/postgresql/server/commands/view.h include/postgresql/server/dynloader.h include/postgresql/server/executor/ @@ -160,8 +163,10 @@ include/postgresql/server/executor/nodeH include/postgresql/server/executor/nodeHashjoin.h include/postgresql/server/executor/nodeIndexscan.h include/postgresql/server/executor/nodeLimit.h +include/postgresql/server/executor/nodeLockRows.h include/postgresql/server/executor/nodeMaterial.h include/postgresql/server/executor/nodeMergejoin.h +include/postgresql/server/executor/nodeModifyTable.h include/postgresql/server/executor/nodeNestloop.h include/postgresql/server/executor/nodeRecursiveunion.h include/postgresql/server/executor/nodeResult.h @@ -260,12 +265,14 @@ include/postgresql/server/parser/parse_e include/postgresql/server/parser/parse_func.h include/postgresql/server/parser/parse_node.h include/postgresql/server/parser/parse_oper.h +include/postgresql/server/parser/parse_param.h include/postgresql/server/parser/parse_relation.h include/postgresql/server/parser/parse_target.h include/postgresql/server/parser/parse_type.h include/postgresql/server/parser/parse_utilcmd.h include/postgresql/server/parser/parser.h include/postgresql/server/parser/parsetree.h +include/postgresql/server/parser/scanner.h include/postgresql/server/parser/scansup.h include/postgresql/server/pg_config.h include/postgresql/server/pg_config_manual.h @@ -334,6 +341,9 @@ include/postgresql/server/regex/regcusto include/postgresql/server/regex/regerrs.h include/postgresql/server/regex/regex.h include/postgresql/server/regex/regguts.h +include/postgresql/server/replication/ +include/postgresql/server/replication/walreceiver.h +include/postgresql/server/replication/walsender.h include/postgresql/server/rewrite/ include/postgresql/server/rewrite/prs2lock.h include/postgresql/server/rewrite/rewriteDefine.h @@ -405,6 +415,7 @@ include/postgresql/server/storage/pmsign include/postgresql/server/storage/pos.h include/postgresql/server/storage/proc.h include/postgresql/server/storage/procarray.h +include/postgresql/server/storage/procsignal.h include/postgresql/server/storage/relfilenode.h include/postgresql/server/storage/s_lock.h include/postgresql/server/storage/shmem.h @@ -412,6 +423,7 @@ include/postgresql/server/storage/sinval include/postgresql/server/storage/sinvaladt.h include/postgresql/server/storage/smgr.h include/postgresql/server/storage/spin.h +include/postgresql/server/storage/standby.h include/postgresql/server/tcop/ include/postgresql/server/tcop/dest.h include/postgresql/server/tcop/fastpath.h @@ -432,7 +444,9 @@ include/postgresql/server/utils/ include/postgresql/server/utils/acl.h include/postgresql/server/utils/array.h include/postgresql/server/utils/ascii.h +include/postgresql/server/utils/attoptcache.h include/postgresql/server/utils/builtins.h +include/postgresql/server/utils/bytea.h include/postgresql/server/utils/cash.h include/postgresql/server/utils/catcache.h include/postgresql/server/utils/combocid.h @@ -443,7 +457,6 @@ include/postgresql/server/utils/dynahash 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 @@ -469,12 +482,15 @@ include/postgresql/server/utils/plancach include/postgresql/server/utils/portal.h include/postgresql/server/utils/probes.h include/postgresql/server/utils/ps_status.h +include/postgresql/server/utils/rbtree.h include/postgresql/server/utils/rel.h include/postgresql/server/utils/relcache.h +include/postgresql/server/utils/relmapper.h include/postgresql/server/utils/resowner.h include/postgresql/server/utils/selfuncs.h include/postgresql/server/utils/snapmgr.h include/postgresql/server/utils/snapshot.h +include/postgresql/server/utils/spccache.h include/postgresql/server/utils/syscache.h include/postgresql/server/utils/timestamp.h include/postgresql/server/utils/tqual.h @@ -491,22 +507,25 @@ lib/postgresql/cyrillic_and_mic.so lib/postgresql/dict_int.so lib/postgresql/dict_snowball.so lib/postgresql/dict_xsyn.so +lib/postgresql/euc2004_sjis2004.so lib/postgresql/euc_cn_and_mic.so -lib/postgresql/euc_jis_2004_and_shift_jis_2004.so lib/postgresql/euc_jp_and_sjis.so lib/postgresql/euc_kr_and_mic.so lib/postgresql/euc_tw_and_big5.so lib/postgresql/latin2_and_win1250.so lib/postgresql/latin_and_mic.so +lib/postgresql/libpqwalreceiver.so lib/postgresql/pageinspect.so +lib/postgresql/passwordcheck.so lib/postgresql/plperl.so lib/postgresql/plpgsql.so lib/postgresql/test_parser.so +lib/postgresql/unaccent.so lib/postgresql/utf8_and_ascii.so lib/postgresql/utf8_and_big5.so lib/postgresql/utf8_and_cyrillic.so +lib/postgresql/utf8_and_euc2004.so lib/postgresql/utf8_and_euc_cn.so -lib/postgresql/utf8_and_euc_jis_2004.so lib/postgresql/utf8_and_euc_jp.so lib/postgresql/utf8_and_euc_kr.so lib/postgresql/utf8_and_euc_tw.so @@ -515,8 +534,8 @@ lib/postgresql/utf8_and_gbk.so lib/postgresql/utf8_and_iso8859.so lib/postgresql/utf8_and_iso8859_1.so lib/postgresql/utf8_and_johab.so -lib/postgresql/utf8_and_shift_jis_2004.so lib/postgresql/utf8_and_sjis.so +lib/postgresql/utf8_and_sjis2004.so lib/postgresql/utf8_and_uhc.so lib/postgresql/utf8_and_win.so @man man/man1/initdb.1 @@ -553,6 +572,7 @@ share/postgresql/tsearch_data/swedish.st share/postgresql/tsearch_data/synonym_sample.syn share/postgresql/tsearch_data/thesaurus_sample.ths share/postgresql/tsearch_data/turkish.stop +share/postgresql/tsearch_data/unaccent.rules share/postgresql/tsearch_data/xsyn_sample.rules @mode 755 @owner _postgresql