diff options
30 files changed, 1040 insertions, 757 deletions
diff --git a/Mk/bsd.database.mk b/Mk/bsd.database.mk index 26ba8d34e0a8..e28e9f677d9d 100644 --- a/Mk/bsd.database.mk +++ b/Mk/bsd.database.mk @@ -174,6 +174,7 @@ PGSQL81_LIBVER= 4 PGSQL82_LIBVER= 5 PGSQL83_LIBVER= 5 PGSQL84_LIBVER= 5 +PGSQL90_LIBVER= 5 # Setting/finding PostgreSQL version we want. .if exists(${LOCALBASE}/bin/pg_config) diff --git a/Mk/bsd.sites.mk b/Mk/bsd.sites.mk index 227f6dfa4b3c..41a8afd04bf7 100644 --- a/Mk/bsd.sites.mk +++ b/Mk/bsd.sites.mk @@ -966,6 +966,7 @@ MASTER_SITE_PERL_CPAN+= \ # .if !defined(IGNORE_MASTER_SITE_PGSQL) MASTER_SITE_PGSQL+= \ + ftp://ftp.se.postgresql.org/pub/databases/relational/postgresql/%SUBDIR%/ \ ftp://ftp9.us.postgresql.org/pub/mirrors/postgresql/%SUBDIR%/ \ ftp://ftp10.us.postgresql.org/pub/postgresql/%SUBDIR%/ \ ${MASTER_SITE_RINGSERVER:S,%SUBDIR%,misc/db/postgresql/&,} \ @@ -995,7 +996,6 @@ MASTER_SITE_PGSQL+= \ ftp://ftp2.ru.postgresql.org/pub/databases/postgresql/%SUBDIR%/ \ ftp://ftp3.ru.postgresql.org/pub/mirror/postgresql/pub/%SUBDIR%/ \ ftp://ftp5.es.postgresql.org/mirror/postgresql/%SUBDIR%/ \ - ftp://ftp.se.postgresql.org/pub/databases/relational/postgresql/%SUBDIR%/ \ ftp://ftp3.tw.postgresql.org/pub/postgresql/%SUBDIR%/ \ ftp://ftp.postgresql.org/pub/%SUBDIR%/ .endif diff --git a/databases/postgresql-docs/Makefile b/databases/postgresql-docs/Makefile index 38d0fc305c39..290fe4f13f4f 100644 --- a/databases/postgresql-docs/Makefile +++ b/databases/postgresql-docs/Makefile @@ -30,6 +30,10 @@ PGSQL_VER!= ${LOCALBASE}/bin/pg_config --version | ${SED} -n 's/PostgreSQL[^0-9] PGSQL_VER= ${DEFAULT_PGSQL_VER} .endif +.if (${PGSQL_VER} == 90) +BROKEN= "not implemented yet" +.endif + NO_BUILD= YES SLAVE_ONLY= YES PATCHDIR= mustnotexist diff --git a/databases/postgresql90-client/Makefile b/databases/postgresql90-client/Makefile new file mode 100644 index 000000000000..95ad5e070194 --- /dev/null +++ b/databases/postgresql90-client/Makefile @@ -0,0 +1,23 @@ +# New ports collection makefile for: PostgreSQL-client +# Date created: 2009-07-08 +# 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 + +COMMENT= PostgreSQL database (client) + +MASTERDIR= ${.CURDIR}/../postgresql90-server + +BUILD_DIRS= config src/include src/interfaces \ + src/bin/pg_dump src/bin/psql src/bin/scripts src/bin/pg_config \ + doc src/makefiles +CLIENT_ONLY= yes +USE_LDCONFIG= yes + +.include "${MASTERDIR}/Makefile" diff --git a/databases/postgresql90-contrib/Makefile b/databases/postgresql90-contrib/Makefile new file mode 100644 index 000000000000..d3a7e68dfe50 --- /dev/null +++ b/databases/postgresql90-contrib/Makefile @@ -0,0 +1,31 @@ +# New ports collection makefile for: postgresql-contrib +# Date created: June 10, 2003 +# Whom: Palle Girgensohn <girgen@pingpong.net> +# +# $FreeBSD$ +# + +PORTNAME= postgresql +PKGNAMESUFFIX= -contrib +CATEGORIES= databases + +MAINTAINER= girgen@FreeBSD.org +COMMENT= The contrib utilities from the PostgreSQL distribution + +USE_PGSQL= yes +DEFAULT_PGSQL_VER=90 +MASTERDIR= ${.CURDIR}/../postgresql${DEFAULT_PGSQL_VER}-server + +USE_BISON= build + +BUILD_DIRS= src/port contrib +INSTALL_DIRS= contrib + +SLAVE_ONLY= yes +CONFIGURE_ARGS+=--with-libxslt --with-libxml +LIB_DEPENDS= xslt.2:${PORTSDIR}/textproc/libxslt xml2.5:${PORTSDIR}/textproc/libxml2 + +post-install: + @- ${INSTALL_DATA} ${WRKSRC}/contrib/README ${DOCSDIR}/contrib/README + +.include "${MASTERDIR}/Makefile" diff --git a/databases/postgresql90-contrib/pkg-descr b/databases/postgresql90-contrib/pkg-descr new file mode 100644 index 000000000000..f7a01fd35e15 --- /dev/null +++ b/databases/postgresql90-contrib/pkg-descr @@ -0,0 +1,23 @@ +This is the port for all stuff that comes in the contrib subtree of +the postgresql distribution. This subtree contains porting tools, +analysis utilities, and plug-in features that are not part of the core +PostgreSQL system, mainly because they address a limited audience or +are too experimental to be part of the main source tree. This does +not preclude their usefulness. + +Each subdirectory contains a README file with information about the +module. Some directories supply new user-defined functions, operators, +or types. After you have installed the files you need to register the +new entities in the database system by running the commands in the +supplied .sql file. For example, + + $ psql -d dbname -f module.sql + +The .sql files are installed into /usr/local/share/postgresql/contrib + +For more information, please see +/usr/local/share/doc/postgresql/contrib/README* + +This software is part of the standard PostgreSQL distribution. + +WWW: http://www.postgresql.org/ diff --git a/databases/postgresql90-server/Makefile b/databases/postgresql90-server/Makefile index 7ce9dab829cd..80d9c75a968c 100644 --- a/databases/postgresql90-server/Makefile +++ b/databases/postgresql90-server/Makefile @@ -6,8 +6,7 @@ # PORTNAME?= postgresql -DISTVERSION?= 8.4.3 -PORTREVISION?= 2 +DISTVERSION?= 9.0.0 CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_PGSQL} MASTER_SITE_SUBDIR= source/v${DISTVERSION} @@ -16,15 +15,13 @@ PKGNAMESUFFIX?= -server MAINTAINER?= girgen@FreeBSD.org COMMENT?= The most advanced open-source database available anywhere -CONFLICTS?= ${PORTNAME}-client-7.* \ - ${PORTNAME}${PKGNAMESUFFIX}-7.* \ - ${PORTNAME}-client-8.[0-35-9]* \ - ${PORTNAME}${PKGNAMESUFFIX}-8.[0-35-9]* +CONFLICTS?= ${PORTNAME}-client-[78]* \ + ${PORTNAME}${PKGNAMESUFFIX}-[78]* WRKSRC= ${WRKDIR}/postgresql-${DISTVERSION} DIST_SUBDIR= postgresql -UNIQUENAME?= ${PORTNAME}84 +UNIQUENAME?= ${PORTNAME}90 LATEST_LINK?= ${PKGNAMEPREFIX}${UNIQUENAME}${PKGNAMESUFFIX} PKGINSTALL?= ${PKGDIR}/pkg-install${PKGNAMESUFFIX} @@ -83,6 +80,7 @@ CONFIGURE_ARGS+=--with-openssl .include <bsd.port.pre.mk> .if !defined(SLAVE_ONLY) +OPTIONS+= DTRACE "Build with DTrace probes (server only)" off OPTIONS+= PAM "Build with PAM support (server only)" off OPTIONS+= LDAP "Build with LDAP authentication support" off OPTIONS+= MIT_KRB5 "Build with MIT's kerberos support" off @@ -108,10 +106,9 @@ IGNORE= options WITH_ICU and WITH_ICU4 are mutually exclusive USE_AUTOTOOLS= autoconf:267 CONFIGURE_ARGS+=--with-icu PATCH_SITES+= http://people.freebsd.org/~girgen/postgresql-icu/:icu -PATCHFILES+= pg-840-icu-2009-09-15.diff.gz:icu +PATCHFILES+= pg-900-icu-2010-09-19.diff.gz:icu . if defined(WITH_ICU4) -LIB_DEPENDS+= icudata.43:${PORTSDIR}/devel/icu4 -EXTRA_PATCHES+= ${FILESDIR}/extra-patch-icu4 +LIB_DEPENDS+= icudata.44:${PORTSDIR}/devel/icu4 . else LIB_DEPENDS+= icudata.38:${PORTSDIR}/devel/icu . endif @@ -119,6 +116,11 @@ LIB_DEPENDS+= icudata.38:${PORTSDIR}/devel/icu PATCH_DIST_STRIP=-p1 +. if defined(SERVER_ONLY) && defined(WITH_DTRACE) +CONFIGURE_ARGS+=--enable-dtrace +LDFLAGS+=-lelf +. endif + . if defined(SERVER_ONLY) && defined(WITH_PAM) CONFIGURE_ARGS+=--with-pam . endif @@ -199,57 +201,81 @@ MAN1= clusterdb.1 createdb.1 createlang.1 createuser.1 \ pg_dump.1 pg_dumpall.1 pg_resetxlog.1 pg_restore.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_foreign_data_wrapper.7 alter_function.7 alter_group.7 alter_server.7 \ - alter_user_mapping.7 alter_index.7 alter_language.7 alter_operator_class.7 \ - alter_operator_family.7 \ - alter_role.7 \ - alter_schema.7 alter_sequence.7 alter_table.7 \ - alter_text_search_configuration.7 \ - alter_text_search_dictionary.7 \ - alter_text_search_parser.7 \ - alter_text_search_template.7 \ - alter_trigger.7 alter_user.7 alter_view.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_foreign_data_wrapper.7 \ - create_function.7 \ - create_group.7 create_index.7 create_language.7 \ - create_operator.7 create_operator_class.7 \ - create_operator_family.7 create_role.7 \ - create_rule.7 create_schema.7 create_sequence.7 \ - create_server.7 create_table.7 create_table_as.7 \ - create_text_search_configuration.7 \ - create_text_search_dictionary.7 \ - create_text_search_parser.7 \ - create_text_search_template.7 create_trigger.7 \ - create_type.7 create_user.7 create_user_mapping.7 create_view.7 deallocate.7 \ - declare.7 delete.7 discard.7 \ - drop_aggregate.7 drop_cast.7 drop_conversion.7 \ - drop_database.7 drop_domain.7 drop_foreign_data_wrapper.7 drop_function.7 \ - drop_group.7 drop_index.7 drop_language.7 \ - drop_operator.7 drop_operator_class.7 drop_operator_family.7 \ - drop_owned.7 drop_role.7 drop_rule.7 \ - drop_schema.7 drop_sequence.7 drop_server.7 drop_table.7 \ - drop_text_search_configuration.7 \ - drop_text_search_dictionary.7 \ - drop_text_search_parser.7 \ - drop_text_search_template.7 drop_trigger.7 \ - drop_type.7 drop_user.7 drop_user_mapping.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 prepare_transaction.7 \ - reassign_owned.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 \ - table.7 truncate.7 unlisten.7 update.7 vacuum.7 \ - alter_operator.7 alter_tablespace.7 alter_type.7 \ - create_tablespace.7 drop_tablespace.7 \ - release_savepoint.7 rollback_to_savepoint.7 \ - savepoint.7 values.7 with.7 +MAN3= SPI_connect.3 SPI_copytuple.3 SPI_cursor_close.3 SPI_cursor_fetch.3 \ + SPI_cursor_find.3 SPI_cursor_move.3 SPI_cursor_open.3 \ + SPI_cursor_open_with_args.3 SPI_cursor_open_with_paramlist.3 \ + SPI_exec.3 SPI_execp.3 SPI_execute.3 SPI_execute_plan.3 \ + SPI_execute_plan_with_paramlist.3 SPI_execute_with_args.3 \ + SPI_finish.3 SPI_fname.3 SPI_fnumber.3 SPI_freeplan.3 \ + SPI_freetuple.3 SPI_freetuptable.3 SPI_getargcount.3 \ + SPI_getargtypeid.3 SPI_getbinval.3 SPI_getnspname.3 \ + SPI_getrelname.3 SPI_gettype.3 SPI_gettypeid.3 \ + SPI_getvalue.3 SPI_is_cursor_plan.3 SPI_modifytuple.3 \ + SPI_palloc.3 SPI_pfree.3 SPI_pop.3 SPI_prepare.3 \ + SPI_prepare_cursor.3 SPI_prepare_params.3 SPI_push.3 \ + SPI_repalloc.3 SPI_returntuple.3 SPI_saveplan.3 \ + SPI_scroll_cursor_fetch.3 SPI_scroll_cursor_move.3 \ + dblink.3 dblink_build_sql_delete.3 dblink_build_sql_insert.3 \ + dblink_build_sql_update.3 dblink_cancel_query.3 \ + dblink_close.3 dblink_connect.3 dblink_connect_u.3 \ + dblink_disconnect.3 dblink_error_message.3 dblink_exec.3 \ + dblink_fetch.3 dblink_get_connections.3 dblink_get_notify.3 \ + dblink_get_pkey.3 dblink_get_result.3 dblink_is_busy.3 \ + dblink_open.3 dblink_send_query.3 + +MAN7= ABORT.7 ALTER_AGGREGATE.7 ALTER_CONVERSION.7 ALTER_DATABASE.7 \ + ALTER_DEFAULT_PRIVILEGES.7 \ + ALTER_DOMAIN.7 ALTER_FOREIGN_DATA_WRAPPER.7 ALTER_FUNCTION.7 ALTER_GROUP.7 \ + ALTER_LARGE_OBJECT.7 ALTER_SERVER.7 \ + ALTER_USER_MAPPING.7 ALTER_INDEX.7 ALTER_LANGUAGE.7 ALTER_OPERATOR_CLASS.7 \ + ALTER_OPERATOR_FAMILY.7 \ + ALTER_ROLE.7 \ + ALTER_SCHEMA.7 ALTER_SEQUENCE.7 ALTER_TABLE.7 \ + ALTER_TEXT_SEARCH_CONFIGURATION.7 \ + ALTER_TEXT_SEARCH_DICTIONARY.7 \ + ALTER_TEXT_SEARCH_PARSER.7 \ + ALTER_TEXT_SEARCH_TEMPLATE.7 \ + ALTER_TRIGGER.7 ALTER_USER.7 ALTER_VIEW.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_FOREIGN_DATA_WRAPPER.7 \ + CREATE_FUNCTION.7 \ + CREATE_GROUP.7 CREATE_INDEX.7 CREATE_LANGUAGE.7 \ + CREATE_OPERATOR.7 CREATE_OPERATOR_CLASS.7 \ + CREATE_OPERATOR_FAMILY.7 CREATE_ROLE.7 \ + CREATE_RULE.7 CREATE_SCHEMA.7 CREATE_SEQUENCE.7 \ + CREATE_SERVER.7 CREATE_TABLE.7 CREATE_TABLE_AS.7 \ + CREATE_TEXT_SEARCH_CONFIGURATION.7 \ + CREATE_TEXT_SEARCH_DICTIONARY.7 \ + CREATE_TEXT_SEARCH_PARSER.7 \ + CREATE_TEXT_SEARCH_TEMPLATE.7 CREATE_TRIGGER.7 \ + CREATE_TYPE.7 CREATE_USER.7 CREATE_USER_MAPPING.7 CREATE_VIEW.7 DEALLOCATE.7 \ + DECLARE.7 DELETE.7 DISCARD.7 \ + DO.7 DROP_AGGREGATE.7 DROP_CAST.7 DROP_CONVERSION.7 \ + DROP_DATABASE.7 DROP_DOMAIN.7 DROP_FOREIGN_DATA_WRAPPER.7 DROP_FUNCTION.7 \ + DROP_GROUP.7 DROP_INDEX.7 DROP_LANGUAGE.7 \ + DROP_OPERATOR.7 DROP_OPERATOR_CLASS.7 DROP_OPERATOR_FAMILY.7 \ + DROP_OWNED.7 DROP_ROLE.7 DROP_RULE.7 \ + DROP_SCHEMA.7 DROP_SEQUENCE.7 DROP_SERVER.7 DROP_TABLE.7 \ + DROP_TEXT_SEARCH_CONFIGURATION.7 \ + DROP_TEXT_SEARCH_DICTIONARY.7 \ + DROP_TEXT_SEARCH_PARSER.7 \ + DROP_TEXT_SEARCH_TEMPLATE.7 DROP_TRIGGER.7 \ + DROP_TYPE.7 DROP_USER.7 DROP_USER_MAPPING.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 PREPARE_TRANSACTION.7 \ + REASSIGN_OWNED.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 \ + TABLE.7 TRUNCATE.7 UNLISTEN.7 UPDATE.7 VACUUM.7 \ + ALTER_OPERATOR.7 ALTER_TABLESPACE.7 ALTER_TYPE.7 \ + CREATE_TABLESPACE.7 DROP_TABLESPACE.7 \ + RELEASE_SAVEPOINT.7 ROLLBACK_TO_SAVEPOINT.7 \ + SAVEPOINT.7 VALUES.7 WITH.7 .endif .if defined(SERVER_ONLY) diff --git a/databases/postgresql90-server/distinfo b/databases/postgresql90-server/distinfo index 81d413a0628a..d6eca70c281d 100644 --- a/databases/postgresql90-server/distinfo +++ b/databases/postgresql90-server/distinfo @@ -1,6 +1,6 @@ -MD5 (postgresql/postgresql-8.4.3.tar.bz2) = 7f70e7b140fb190f268837255582b07e -SHA256 (postgresql/postgresql-8.4.3.tar.bz2) = 050c3e8324b453715e819456638fc1561351b33c8011b7cb63db98bbc2061564 -SIZE (postgresql/postgresql-8.4.3.tar.bz2) = 13645257 -SHA256 (postgresql/pg-840-icu-2009-09-15.diff.gz) = c09d3b59340a3bb6ea754e985739d4fbb47f730d1e48a357c5585825034fc72e -MD5 (postgresql/pg-840-icu-2009-09-15.diff.gz) = 2b81134b462e01623bc9387fe4de7136 -SIZE (postgresql/pg-840-icu-2009-09-15.diff.gz) = 4321 +MD5 (postgresql/postgresql-9.0.0.tar.bz2) = 14c2122cc322e69ab2ab702ed7714bbe +SHA256 (postgresql/postgresql-9.0.0.tar.bz2) = 7dcc381603c02595adc96a8fc5c9d067d3b39aaa44987e7a524a7504a10ff676 +SIZE (postgresql/postgresql-9.0.0.tar.bz2) = 13753207 +SHA256 (postgresql/pg-900-icu-2010-09-19.diff.gz) = 27cea46241ec814965c278330cd96f67ee03422b7758a210713a63b4b5bb77e9 +MD5 (postgresql/pg-900-icu-2010-09-19.diff.gz) = 150268fbcce8c0bbe68c176dcb5464ad +SIZE (postgresql/pg-900-icu-2010-09-19.diff.gz) = 4349 diff --git a/databases/postgresql90-server/files/502.pgsql b/databases/postgresql90-server/files/502.pgsql index d2235e414cd2..281189a59c46 100644 --- a/databases/postgresql90-server/files/502.pgsql +++ b/databases/postgresql90-server/files/502.pgsql @@ -15,7 +15,8 @@ # Define these variables in either /etc/periodic.conf or # /etc/periodic.conf.local to override the default values. # -# daily_pgsql_backup_enable="YES" # do backup +# daily_pgsql_backup_enable="YES" # do backup of all databases +# daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases # daily_pgsql_vacuum_enable="YES" # do vacuum daily_pgsql_vacuum_args="-z" @@ -37,9 +38,7 @@ eval backupdir=${daily_pgsql_backupdir} rc=0 -case "$daily_pgsql_backup_enable" in - [Yy][Ee][Ss]) - +pgsql_backup() { # daily_pgsql_backupdir must be writeable by user pgsql # ~pgsql is just that under normal circumstances, # but this might not be where you want the backups... @@ -53,16 +52,18 @@ case "$daily_pgsql_backup_enable" in # Protect the data umask 077 - dbnames=`su -l pgsql -c "umask 077; psql -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` rc=$? now=`date "+%Y-%m-%dT%H:%M:%S"` file=${daily_pgsql_backupdir}/pgglobals_${now} su -l pgsql -c "umask 077; pg_dumpall -g | gzip -9 > ${file}.gz" - for db in ${dbnames}; do + + db=$1 + while shift; do echo -n " $db" file=${backupdir}/pgdump_${db}_${now} su -l pgsql -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}" [ $? -gt 0 ] && rc=3 + db=$1 done if [ $rc -gt 0 ]; then @@ -73,6 +74,23 @@ case "$daily_pgsql_backup_enable" in # cleaning up old data find ${backupdir} \( -name 'pgdump_*' -o -name 'pgglobals_*' \) \ -a -mtime +${daily_pgsql_savedays} -delete + echo +} + +case "$daily_pgsql_backup_enable" in + [Yy][Ee][Ss]) + dbnames=`su -l pgsql -c "umask 077; psql -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` + pgsql_backup $dbnames + ;; + + [Nn][Oo]) + ;; + + "") + ;; + + *) + pgsql_backup $daily_pgsql_backup_enable ;; esac diff --git a/databases/postgresql90-server/files/extra-patch-icu4 b/databases/postgresql90-server/files/extra-patch-icu4 deleted file mode 100644 index 28c8a8cfff33..000000000000 --- a/databases/postgresql90-server/files/extra-patch-icu4 +++ /dev/null @@ -1,30 +0,0 @@ ---- configure.in.orig 2010-03-25 22:25:10.655197193 +0100 -+++ configure.in 2010-03-25 22:25:13.611658318 +0100 -@@ -945,15 +945,19 @@ - fi - - if test "$with_icu" = yes ; then -- AC_CHECK_LIB(icui18n, ucol_open_3_8, [], [ -- AC_CHECK_LIB(icui18n, ucol_open_3_6, [], [ -- AC_CHECK_LIB(icui18n, ucol_open_3_4, [], [AC_MSG_ERROR([library 'icui18n' is required for ICU])]) -- ]) -+ AC_CHECK_LIB(icui18n, ucol_open_43, [], [ -+ AC_CHECK_LIB(icui18n, ucol_open_3_8, [], [ -+ AC_CHECK_LIB(icui18n, ucol_open_3_6, [], [ -+ AC_CHECK_LIB(icui18n, ucol_open_3_4, [], [AC_MSG_ERROR([library 'icui18n' is required for ICU])]) -+ ]) -+ ]) - ]) -- AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_8, [], [ -- AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_6, [], [ -- AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_4, [], [AC_MSG_ERROR([library 'icuuc' is required for ICU])]) -- ]) -+ AC_CHECK_LIB(icuuc, ucnv_fromUChars_43, [], [ -+ AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_8, [], [ -+ AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_6, [], [ -+ AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_4, [], [AC_MSG_ERROR([library 'icuuc' is required for ICU])]) -+ ]) -+ ]) - ]) - fi - diff --git a/databases/postgresql90-server/files/patch-doc-Makefile b/databases/postgresql90-server/files/patch-doc-Makefile index 8e08132e175b..a366d4ca2620 100644 --- a/databases/postgresql90-server/files/patch-doc-Makefile +++ b/databases/postgresql90-server/files/patch-doc-Makefile @@ -1,16 +1,28 @@ ---- doc/Makefile.orig 2009-05-15 15:58:05.000000000 +0200 -+++ doc/Makefile 2009-05-15 15:58:18.000000000 +0200 -@@ -25,9 +25,10 @@ - - .NOTPARALLEL: - --ifneq ($(wildcard $(srcdir)/postgres.tar.gz),) --found_html = yes --endif -+# FreeBSD has a separate port for installing the documentation -+#ifneq ($(wildcard $(srcdir)/postgres.tar.gz),) -+#found_html = yes -+#endif - - ifneq ($(wildcard $(srcdir)/man.tar.gz),) - # SCO OpenServer's man system is sufficiently different to not bother. +--- doc/src/sgml/Makefile.orig 2010-06-12 23:40:31.000000000 +0200 ++++ doc/src/sgml/Makefile 2010-09-19 22:07:11.210759927 +0200 +@@ -15,14 +15,14 @@ + + # Make "html" the default target, since that is what most people tend + # to want to use. +-html: ++man: + + subdir = doc/src/sgml + top_builddir = ../../.. + include $(top_builddir)/src/Makefile.global + + +-all: html man ++all: man + + distprep: html distprep-man + +@@ -285,7 +285,7 @@ + ## Install + ## + +-install: install-html ++##install: install-html + + ifneq ($(PORTNAME), sco) + install: install-man diff --git a/databases/postgresql90-server/pkg-plist-client b/databases/postgresql90-server/pkg-plist-client index 31a1fd4b22f4..cb6713877cee 100644 --- a/databases/postgresql90-server/pkg-plist-client +++ b/databases/postgresql90-server/pkg-plist-client @@ -40,6 +40,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 @@ -77,6 +78,8 @@ include/postgresql/server/catalog/pg_control.h 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 @@ -87,7 +90,7 @@ include/postgresql/server/catalog/pg_inherits.h 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 @@ -134,7 +137,6 @@ include/postgresql/server/commands/typecmds.h 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/execdebug.h @@ -157,8 +159,10 @@ include/postgresql/server/executor/nodeHash.h 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 @@ -177,8 +181,8 @@ include/postgresql/server/executor/spi_priv.h include/postgresql/server/executor/tstoreReceiver.h include/postgresql/server/executor/tuptable.h include/postgresql/server/fmgr.h -include/postgresql/server/funcapi.h include/postgresql/server/foreign/foreign.h +include/postgresql/server/funcapi.h include/postgresql/server/getaddrinfo.h include/postgresql/server/getopt_long.h include/postgresql/server/lib/dllist.h @@ -250,12 +254,14 @@ include/postgresql/server/parser/parse_expr.h 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 @@ -314,6 +320,9 @@ include/postgresql/server/regex/regcustom.h include/postgresql/server/regex/regerrs.h include/postgresql/server/regex/regex.h include/postgresql/server/regex/regguts.h +include/postgresql/server/replication/walprotocol.h +include/postgresql/server/replication/walreceiver.h +include/postgresql/server/replication/walsender.h include/postgresql/server/rewrite/prs2lock.h include/postgresql/server/rewrite/rewriteDefine.h include/postgresql/server/rewrite/rewriteHandler.h @@ -381,6 +390,7 @@ 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/procsignal.h include/postgresql/server/storage/relfilenode.h include/postgresql/server/storage/s_lock.h include/postgresql/server/storage/shmem.h @@ -388,6 +398,7 @@ include/postgresql/server/storage/sinval.h 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/dest.h include/postgresql/server/tcop/fastpath.h include/postgresql/server/tcop/pquery.h @@ -404,7 +415,9 @@ include/postgresql/server/tsearch/ts_utils.h 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 @@ -415,7 +428,6 @@ 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 @@ -441,12 +453,15 @@ include/postgresql/server/utils/plancache.h 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 @@ -458,6 +473,9 @@ include/postgresql/server/utils/uuid.h include/postgresql/server/utils/varbit.h include/postgresql/server/utils/xml.h include/postgresql/server/windowapi.h +include/sqlda-compat.h +include/sqlda-native.h +include/sqlda.h @dirrm include/postgresql/server/utils @dirrm include/postgresql/server/tsearch/dicts @dirrm include/postgresql/server/tsearch @@ -466,6 +484,7 @@ include/postgresql/server/windowapi.h @dirrm include/postgresql/server/snowball/libstemmer @dirrm include/postgresql/server/snowball @dirrm include/postgresql/server/rewrite +@dirrm include/postgresql/server/replication @dirrm include/postgresql/server/regex @dirrm include/postgresql/server/postmaster @dirrm include/postgresql/server/portability @@ -495,7 +514,6 @@ include/postgresql/internal/libpq/pqcomm.h @dirrm include/postgresql/internal/libpq include/postgresql/informix/esql/datetime.h include/postgresql/informix/esql/decimal.h -include/postgresql/informix/esql/sqlda.h include/postgresql/informix/esql/sqltypes.h @dirrm include/postgresql/informix/esql @dirrm include/postgresql/informix @@ -535,7 +553,6 @@ lib/libpq.so.5 lib/libpgtypes.a lib/libpgtypes.so lib/postgresql/pgxs/config/install-sh -lib/postgresql/pgxs/config/mkinstalldirs lib/postgresql/pgxs/src/makefiles/pgxs.mk lib/postgresql/pgxs/src/Makefile.global lib/postgresql/pgxs/src/Makefile.port @@ -551,70 +568,76 @@ lib/postgresql/pgxs/src/nls-global.mk share/postgresql/pg_service.conf.sample share/postgresql/psqlrc.sample @dirrmtry share/postgresql -%%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/cs/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/cs/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/ecpglib6-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/ecpg-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_dump-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/ecpglib6-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/ecpg-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_dump-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/ecpglib6-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/ecpg-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_dump-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/ecpg-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/ecpglib6-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/ecpglib6-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/ecpg-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_dump-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/nb/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/ecpglib6-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/ecpg-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_dump-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/ro/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/ru/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_dump-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/ecpglib6-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/ecpg-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_dump-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_config-8.4.mo +%%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/cs/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/cs/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/ko/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/ko/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/nb/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/ro/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/ru/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/ta/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/ta/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pgscripts-9.0.mo diff --git a/databases/postgresql90-server/pkg-plist-contrib b/databases/postgresql90-server/pkg-plist-contrib index 7fd4f432829d..b3a1c61e6d8e 100644 --- a/databases/postgresql90-server/pkg-plist-contrib +++ b/databases/postgresql90-server/pkg-plist-contrib @@ -1,6 +1,7 @@ bin/oid2name +bin/pg_archivecleanup bin/pg_standby -bin/pgbench +bin/pg_upgrade bin/vacuumlo lib/postgresql/_int.so lib/postgresql/adminpack.so @@ -23,10 +24,12 @@ lib/postgresql/lo.so lib/postgresql/ltree.so lib/postgresql/moddatetime.so lib/postgresql/pageinspect.so +lib/postgresql/passwordcheck.so lib/postgresql/pg_buffercache.so lib/postgresql/pg_freespacemap.so lib/postgresql/pg_stat_statements.so lib/postgresql/pg_trgm.so +lib/postgresql/pg_upgrade_support.so lib/postgresql/pgcrypto.so lib/postgresql/pgrowlocks.so lib/postgresql/pgstattuple.so @@ -38,6 +41,7 @@ lib/postgresql/tablefunc.so lib/postgresql/test_parser.so lib/postgresql/timetravel.so lib/postgresql/tsearch2.so +lib/postgresql/unaccent.so %%DOCSDIR%%/README-contrib %%DOCSDIR%%/contrib/README %%DOCSDIR%%/contrib/autoinc.example @@ -81,6 +85,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 @@ -112,6 +117,8 @@ share/postgresql/contrib/uninstall_sslinfo.sql 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/tsearch_data/unaccent.rules share/postgresql/tsearch_data/xsyn_sample.rules @dirrmtry share/postgresql/tsearch_data >&2 @dirrmtry share/postgresql/contrib >&2 diff --git a/databases/postgresql90-server/pkg-plist-server b/databases/postgresql90-server/pkg-plist-server index 7a5170bad6fd..68224f4750ef 100644 --- a/databases/postgresql90-server/pkg-plist-server +++ b/databases/postgresql90-server/pkg-plist-server @@ -10,7 +10,7 @@ lib/postgresql/ascii_and_mic.so lib/postgresql/cyrillic_and_mic.so lib/postgresql/dict_snowball.so lib/postgresql/euc_cn_and_mic.so -lib/postgresql/euc_jis_2004_and_shift_jis_2004.so +lib/postgresql/euc2004_sjis2004.so lib/postgresql/euc_jp_and_sjis.so lib/postgresql/euc_kr_and_mic.so lib/postgresql/euc_tw_and_big5.so @@ -21,17 +21,17 @@ lib/postgresql/utf8_and_ascii.so lib/postgresql/utf8_and_big5.so lib/postgresql/utf8_and_cyrillic.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 +lib/postgresql/utf8_and_euc2004.so lib/postgresql/utf8_and_gb18030.so 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 %%DOCSDIR%%/README-server @@ -46,62 +46,69 @@ share/postgresql/postgresql.conf.sample share/postgresql/recovery.conf.sample share/postgresql/sql_features.txt share/postgresql/system_views.sql -%%GETTEXT%%share/locale/cs/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/postgres-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/plpgsql-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/postgres-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/plpgsql-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/postgres-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/plpgsql-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/plpgsql-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/postgres-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/plpgsql-8.4.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/postgres-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/ro/LC_MESSAGES/plpgsql-8.4.mo -%%GETTEXT%%share/locale/ru/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/postgres-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_resetxlog-8.4.mo +%%GETTEXT%%share/locale/cs/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/postgres-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/postgres-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/postgres-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/postgres-9.0.mo +%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/postgres-9.0.mo +%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/ro/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/ru/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/ta/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/postgres-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_resetxlog-9.0.mo share/postgresql/postgres.shdescription share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Africa/Abidjan @@ -180,6 +187,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/America/Atikokan %%TZDATA%%share/postgresql/timezone/America/Atka %%TZDATA%%share/postgresql/timezone/America/Bahia +%%TZDATA%%share/postgresql/timezone/America/Bahia_Banderas %%TZDATA%%share/postgresql/timezone/America/Barbados %%TZDATA%%share/postgresql/timezone/America/Belem %%TZDATA%%share/postgresql/timezone/America/Belize @@ -317,6 +325,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Antarctica/Casey %%TZDATA%%share/postgresql/timezone/Antarctica/Davis %%TZDATA%%share/postgresql/timezone/Antarctica/DumontDUrville +%%TZDATA%%share/postgresql/timezone/Antarctica/Macquarie %%TZDATA%%share/postgresql/timezone/Antarctica/Mawson %%TZDATA%%share/postgresql/timezone/Antarctica/McMurdo %%TZDATA%%share/postgresql/timezone/Antarctica/Palmer @@ -612,6 +621,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Pacific/Apia %%TZDATA%%share/postgresql/timezone/Pacific/Auckland %%TZDATA%%share/postgresql/timezone/Pacific/Chatham +%%TZDATA%%share/postgresql/timezone/Pacific/Chuuk %%TZDATA%%share/postgresql/timezone/Pacific/Easter %%TZDATA%%share/postgresql/timezone/Pacific/Efate %%TZDATA%%share/postgresql/timezone/Pacific/Enderbury @@ -637,6 +647,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Pacific/Pago_Pago %%TZDATA%%share/postgresql/timezone/Pacific/Palau %%TZDATA%%share/postgresql/timezone/Pacific/Pitcairn +%%TZDATA%%share/postgresql/timezone/Pacific/Pohnpei %%TZDATA%%share/postgresql/timezone/Pacific/Ponape %%TZDATA%%share/postgresql/timezone/Pacific/Port_Moresby %%TZDATA%%share/postgresql/timezone/Pacific/Rarotonga diff --git a/databases/postgresql91-server/Makefile b/databases/postgresql91-server/Makefile index 7ce9dab829cd..80d9c75a968c 100644 --- a/databases/postgresql91-server/Makefile +++ b/databases/postgresql91-server/Makefile @@ -6,8 +6,7 @@ # PORTNAME?= postgresql -DISTVERSION?= 8.4.3 -PORTREVISION?= 2 +DISTVERSION?= 9.0.0 CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_PGSQL} MASTER_SITE_SUBDIR= source/v${DISTVERSION} @@ -16,15 +15,13 @@ PKGNAMESUFFIX?= -server MAINTAINER?= girgen@FreeBSD.org COMMENT?= The most advanced open-source database available anywhere -CONFLICTS?= ${PORTNAME}-client-7.* \ - ${PORTNAME}${PKGNAMESUFFIX}-7.* \ - ${PORTNAME}-client-8.[0-35-9]* \ - ${PORTNAME}${PKGNAMESUFFIX}-8.[0-35-9]* +CONFLICTS?= ${PORTNAME}-client-[78]* \ + ${PORTNAME}${PKGNAMESUFFIX}-[78]* WRKSRC= ${WRKDIR}/postgresql-${DISTVERSION} DIST_SUBDIR= postgresql -UNIQUENAME?= ${PORTNAME}84 +UNIQUENAME?= ${PORTNAME}90 LATEST_LINK?= ${PKGNAMEPREFIX}${UNIQUENAME}${PKGNAMESUFFIX} PKGINSTALL?= ${PKGDIR}/pkg-install${PKGNAMESUFFIX} @@ -83,6 +80,7 @@ CONFIGURE_ARGS+=--with-openssl .include <bsd.port.pre.mk> .if !defined(SLAVE_ONLY) +OPTIONS+= DTRACE "Build with DTrace probes (server only)" off OPTIONS+= PAM "Build with PAM support (server only)" off OPTIONS+= LDAP "Build with LDAP authentication support" off OPTIONS+= MIT_KRB5 "Build with MIT's kerberos support" off @@ -108,10 +106,9 @@ IGNORE= options WITH_ICU and WITH_ICU4 are mutually exclusive USE_AUTOTOOLS= autoconf:267 CONFIGURE_ARGS+=--with-icu PATCH_SITES+= http://people.freebsd.org/~girgen/postgresql-icu/:icu -PATCHFILES+= pg-840-icu-2009-09-15.diff.gz:icu +PATCHFILES+= pg-900-icu-2010-09-19.diff.gz:icu . if defined(WITH_ICU4) -LIB_DEPENDS+= icudata.43:${PORTSDIR}/devel/icu4 -EXTRA_PATCHES+= ${FILESDIR}/extra-patch-icu4 +LIB_DEPENDS+= icudata.44:${PORTSDIR}/devel/icu4 . else LIB_DEPENDS+= icudata.38:${PORTSDIR}/devel/icu . endif @@ -119,6 +116,11 @@ LIB_DEPENDS+= icudata.38:${PORTSDIR}/devel/icu PATCH_DIST_STRIP=-p1 +. if defined(SERVER_ONLY) && defined(WITH_DTRACE) +CONFIGURE_ARGS+=--enable-dtrace +LDFLAGS+=-lelf +. endif + . if defined(SERVER_ONLY) && defined(WITH_PAM) CONFIGURE_ARGS+=--with-pam . endif @@ -199,57 +201,81 @@ MAN1= clusterdb.1 createdb.1 createlang.1 createuser.1 \ pg_dump.1 pg_dumpall.1 pg_resetxlog.1 pg_restore.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_foreign_data_wrapper.7 alter_function.7 alter_group.7 alter_server.7 \ - alter_user_mapping.7 alter_index.7 alter_language.7 alter_operator_class.7 \ - alter_operator_family.7 \ - alter_role.7 \ - alter_schema.7 alter_sequence.7 alter_table.7 \ - alter_text_search_configuration.7 \ - alter_text_search_dictionary.7 \ - alter_text_search_parser.7 \ - alter_text_search_template.7 \ - alter_trigger.7 alter_user.7 alter_view.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_foreign_data_wrapper.7 \ - create_function.7 \ - create_group.7 create_index.7 create_language.7 \ - create_operator.7 create_operator_class.7 \ - create_operator_family.7 create_role.7 \ - create_rule.7 create_schema.7 create_sequence.7 \ - create_server.7 create_table.7 create_table_as.7 \ - create_text_search_configuration.7 \ - create_text_search_dictionary.7 \ - create_text_search_parser.7 \ - create_text_search_template.7 create_trigger.7 \ - create_type.7 create_user.7 create_user_mapping.7 create_view.7 deallocate.7 \ - declare.7 delete.7 discard.7 \ - drop_aggregate.7 drop_cast.7 drop_conversion.7 \ - drop_database.7 drop_domain.7 drop_foreign_data_wrapper.7 drop_function.7 \ - drop_group.7 drop_index.7 drop_language.7 \ - drop_operator.7 drop_operator_class.7 drop_operator_family.7 \ - drop_owned.7 drop_role.7 drop_rule.7 \ - drop_schema.7 drop_sequence.7 drop_server.7 drop_table.7 \ - drop_text_search_configuration.7 \ - drop_text_search_dictionary.7 \ - drop_text_search_parser.7 \ - drop_text_search_template.7 drop_trigger.7 \ - drop_type.7 drop_user.7 drop_user_mapping.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 prepare_transaction.7 \ - reassign_owned.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 \ - table.7 truncate.7 unlisten.7 update.7 vacuum.7 \ - alter_operator.7 alter_tablespace.7 alter_type.7 \ - create_tablespace.7 drop_tablespace.7 \ - release_savepoint.7 rollback_to_savepoint.7 \ - savepoint.7 values.7 with.7 +MAN3= SPI_connect.3 SPI_copytuple.3 SPI_cursor_close.3 SPI_cursor_fetch.3 \ + SPI_cursor_find.3 SPI_cursor_move.3 SPI_cursor_open.3 \ + SPI_cursor_open_with_args.3 SPI_cursor_open_with_paramlist.3 \ + SPI_exec.3 SPI_execp.3 SPI_execute.3 SPI_execute_plan.3 \ + SPI_execute_plan_with_paramlist.3 SPI_execute_with_args.3 \ + SPI_finish.3 SPI_fname.3 SPI_fnumber.3 SPI_freeplan.3 \ + SPI_freetuple.3 SPI_freetuptable.3 SPI_getargcount.3 \ + SPI_getargtypeid.3 SPI_getbinval.3 SPI_getnspname.3 \ + SPI_getrelname.3 SPI_gettype.3 SPI_gettypeid.3 \ + SPI_getvalue.3 SPI_is_cursor_plan.3 SPI_modifytuple.3 \ + SPI_palloc.3 SPI_pfree.3 SPI_pop.3 SPI_prepare.3 \ + SPI_prepare_cursor.3 SPI_prepare_params.3 SPI_push.3 \ + SPI_repalloc.3 SPI_returntuple.3 SPI_saveplan.3 \ + SPI_scroll_cursor_fetch.3 SPI_scroll_cursor_move.3 \ + dblink.3 dblink_build_sql_delete.3 dblink_build_sql_insert.3 \ + dblink_build_sql_update.3 dblink_cancel_query.3 \ + dblink_close.3 dblink_connect.3 dblink_connect_u.3 \ + dblink_disconnect.3 dblink_error_message.3 dblink_exec.3 \ + dblink_fetch.3 dblink_get_connections.3 dblink_get_notify.3 \ + dblink_get_pkey.3 dblink_get_result.3 dblink_is_busy.3 \ + dblink_open.3 dblink_send_query.3 + +MAN7= ABORT.7 ALTER_AGGREGATE.7 ALTER_CONVERSION.7 ALTER_DATABASE.7 \ + ALTER_DEFAULT_PRIVILEGES.7 \ + ALTER_DOMAIN.7 ALTER_FOREIGN_DATA_WRAPPER.7 ALTER_FUNCTION.7 ALTER_GROUP.7 \ + ALTER_LARGE_OBJECT.7 ALTER_SERVER.7 \ + ALTER_USER_MAPPING.7 ALTER_INDEX.7 ALTER_LANGUAGE.7 ALTER_OPERATOR_CLASS.7 \ + ALTER_OPERATOR_FAMILY.7 \ + ALTER_ROLE.7 \ + ALTER_SCHEMA.7 ALTER_SEQUENCE.7 ALTER_TABLE.7 \ + ALTER_TEXT_SEARCH_CONFIGURATION.7 \ + ALTER_TEXT_SEARCH_DICTIONARY.7 \ + ALTER_TEXT_SEARCH_PARSER.7 \ + ALTER_TEXT_SEARCH_TEMPLATE.7 \ + ALTER_TRIGGER.7 ALTER_USER.7 ALTER_VIEW.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_FOREIGN_DATA_WRAPPER.7 \ + CREATE_FUNCTION.7 \ + CREATE_GROUP.7 CREATE_INDEX.7 CREATE_LANGUAGE.7 \ + CREATE_OPERATOR.7 CREATE_OPERATOR_CLASS.7 \ + CREATE_OPERATOR_FAMILY.7 CREATE_ROLE.7 \ + CREATE_RULE.7 CREATE_SCHEMA.7 CREATE_SEQUENCE.7 \ + CREATE_SERVER.7 CREATE_TABLE.7 CREATE_TABLE_AS.7 \ + CREATE_TEXT_SEARCH_CONFIGURATION.7 \ + CREATE_TEXT_SEARCH_DICTIONARY.7 \ + CREATE_TEXT_SEARCH_PARSER.7 \ + CREATE_TEXT_SEARCH_TEMPLATE.7 CREATE_TRIGGER.7 \ + CREATE_TYPE.7 CREATE_USER.7 CREATE_USER_MAPPING.7 CREATE_VIEW.7 DEALLOCATE.7 \ + DECLARE.7 DELETE.7 DISCARD.7 \ + DO.7 DROP_AGGREGATE.7 DROP_CAST.7 DROP_CONVERSION.7 \ + DROP_DATABASE.7 DROP_DOMAIN.7 DROP_FOREIGN_DATA_WRAPPER.7 DROP_FUNCTION.7 \ + DROP_GROUP.7 DROP_INDEX.7 DROP_LANGUAGE.7 \ + DROP_OPERATOR.7 DROP_OPERATOR_CLASS.7 DROP_OPERATOR_FAMILY.7 \ + DROP_OWNED.7 DROP_ROLE.7 DROP_RULE.7 \ + DROP_SCHEMA.7 DROP_SEQUENCE.7 DROP_SERVER.7 DROP_TABLE.7 \ + DROP_TEXT_SEARCH_CONFIGURATION.7 \ + DROP_TEXT_SEARCH_DICTIONARY.7 \ + DROP_TEXT_SEARCH_PARSER.7 \ + DROP_TEXT_SEARCH_TEMPLATE.7 DROP_TRIGGER.7 \ + DROP_TYPE.7 DROP_USER.7 DROP_USER_MAPPING.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 PREPARE_TRANSACTION.7 \ + REASSIGN_OWNED.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 \ + TABLE.7 TRUNCATE.7 UNLISTEN.7 UPDATE.7 VACUUM.7 \ + ALTER_OPERATOR.7 ALTER_TABLESPACE.7 ALTER_TYPE.7 \ + CREATE_TABLESPACE.7 DROP_TABLESPACE.7 \ + RELEASE_SAVEPOINT.7 ROLLBACK_TO_SAVEPOINT.7 \ + SAVEPOINT.7 VALUES.7 WITH.7 .endif .if defined(SERVER_ONLY) diff --git a/databases/postgresql91-server/distinfo b/databases/postgresql91-server/distinfo index 81d413a0628a..d6eca70c281d 100644 --- a/databases/postgresql91-server/distinfo +++ b/databases/postgresql91-server/distinfo @@ -1,6 +1,6 @@ -MD5 (postgresql/postgresql-8.4.3.tar.bz2) = 7f70e7b140fb190f268837255582b07e -SHA256 (postgresql/postgresql-8.4.3.tar.bz2) = 050c3e8324b453715e819456638fc1561351b33c8011b7cb63db98bbc2061564 -SIZE (postgresql/postgresql-8.4.3.tar.bz2) = 13645257 -SHA256 (postgresql/pg-840-icu-2009-09-15.diff.gz) = c09d3b59340a3bb6ea754e985739d4fbb47f730d1e48a357c5585825034fc72e -MD5 (postgresql/pg-840-icu-2009-09-15.diff.gz) = 2b81134b462e01623bc9387fe4de7136 -SIZE (postgresql/pg-840-icu-2009-09-15.diff.gz) = 4321 +MD5 (postgresql/postgresql-9.0.0.tar.bz2) = 14c2122cc322e69ab2ab702ed7714bbe +SHA256 (postgresql/postgresql-9.0.0.tar.bz2) = 7dcc381603c02595adc96a8fc5c9d067d3b39aaa44987e7a524a7504a10ff676 +SIZE (postgresql/postgresql-9.0.0.tar.bz2) = 13753207 +SHA256 (postgresql/pg-900-icu-2010-09-19.diff.gz) = 27cea46241ec814965c278330cd96f67ee03422b7758a210713a63b4b5bb77e9 +MD5 (postgresql/pg-900-icu-2010-09-19.diff.gz) = 150268fbcce8c0bbe68c176dcb5464ad +SIZE (postgresql/pg-900-icu-2010-09-19.diff.gz) = 4349 diff --git a/databases/postgresql91-server/files/502.pgsql b/databases/postgresql91-server/files/502.pgsql index d2235e414cd2..281189a59c46 100644 --- a/databases/postgresql91-server/files/502.pgsql +++ b/databases/postgresql91-server/files/502.pgsql @@ -15,7 +15,8 @@ # Define these variables in either /etc/periodic.conf or # /etc/periodic.conf.local to override the default values. # -# daily_pgsql_backup_enable="YES" # do backup +# daily_pgsql_backup_enable="YES" # do backup of all databases +# daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases # daily_pgsql_vacuum_enable="YES" # do vacuum daily_pgsql_vacuum_args="-z" @@ -37,9 +38,7 @@ eval backupdir=${daily_pgsql_backupdir} rc=0 -case "$daily_pgsql_backup_enable" in - [Yy][Ee][Ss]) - +pgsql_backup() { # daily_pgsql_backupdir must be writeable by user pgsql # ~pgsql is just that under normal circumstances, # but this might not be where you want the backups... @@ -53,16 +52,18 @@ case "$daily_pgsql_backup_enable" in # Protect the data umask 077 - dbnames=`su -l pgsql -c "umask 077; psql -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` rc=$? now=`date "+%Y-%m-%dT%H:%M:%S"` file=${daily_pgsql_backupdir}/pgglobals_${now} su -l pgsql -c "umask 077; pg_dumpall -g | gzip -9 > ${file}.gz" - for db in ${dbnames}; do + + db=$1 + while shift; do echo -n " $db" file=${backupdir}/pgdump_${db}_${now} su -l pgsql -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}" [ $? -gt 0 ] && rc=3 + db=$1 done if [ $rc -gt 0 ]; then @@ -73,6 +74,23 @@ case "$daily_pgsql_backup_enable" in # cleaning up old data find ${backupdir} \( -name 'pgdump_*' -o -name 'pgglobals_*' \) \ -a -mtime +${daily_pgsql_savedays} -delete + echo +} + +case "$daily_pgsql_backup_enable" in + [Yy][Ee][Ss]) + dbnames=`su -l pgsql -c "umask 077; psql -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` + pgsql_backup $dbnames + ;; + + [Nn][Oo]) + ;; + + "") + ;; + + *) + pgsql_backup $daily_pgsql_backup_enable ;; esac diff --git a/databases/postgresql91-server/files/extra-patch-icu4 b/databases/postgresql91-server/files/extra-patch-icu4 deleted file mode 100644 index 28c8a8cfff33..000000000000 --- a/databases/postgresql91-server/files/extra-patch-icu4 +++ /dev/null @@ -1,30 +0,0 @@ ---- configure.in.orig 2010-03-25 22:25:10.655197193 +0100 -+++ configure.in 2010-03-25 22:25:13.611658318 +0100 -@@ -945,15 +945,19 @@ - fi - - if test "$with_icu" = yes ; then -- AC_CHECK_LIB(icui18n, ucol_open_3_8, [], [ -- AC_CHECK_LIB(icui18n, ucol_open_3_6, [], [ -- AC_CHECK_LIB(icui18n, ucol_open_3_4, [], [AC_MSG_ERROR([library 'icui18n' is required for ICU])]) -- ]) -+ AC_CHECK_LIB(icui18n, ucol_open_43, [], [ -+ AC_CHECK_LIB(icui18n, ucol_open_3_8, [], [ -+ AC_CHECK_LIB(icui18n, ucol_open_3_6, [], [ -+ AC_CHECK_LIB(icui18n, ucol_open_3_4, [], [AC_MSG_ERROR([library 'icui18n' is required for ICU])]) -+ ]) -+ ]) - ]) -- AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_8, [], [ -- AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_6, [], [ -- AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_4, [], [AC_MSG_ERROR([library 'icuuc' is required for ICU])]) -- ]) -+ AC_CHECK_LIB(icuuc, ucnv_fromUChars_43, [], [ -+ AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_8, [], [ -+ AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_6, [], [ -+ AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_4, [], [AC_MSG_ERROR([library 'icuuc' is required for ICU])]) -+ ]) -+ ]) - ]) - fi - diff --git a/databases/postgresql91-server/files/patch-doc-Makefile b/databases/postgresql91-server/files/patch-doc-Makefile index 8e08132e175b..a366d4ca2620 100644 --- a/databases/postgresql91-server/files/patch-doc-Makefile +++ b/databases/postgresql91-server/files/patch-doc-Makefile @@ -1,16 +1,28 @@ ---- doc/Makefile.orig 2009-05-15 15:58:05.000000000 +0200 -+++ doc/Makefile 2009-05-15 15:58:18.000000000 +0200 -@@ -25,9 +25,10 @@ - - .NOTPARALLEL: - --ifneq ($(wildcard $(srcdir)/postgres.tar.gz),) --found_html = yes --endif -+# FreeBSD has a separate port for installing the documentation -+#ifneq ($(wildcard $(srcdir)/postgres.tar.gz),) -+#found_html = yes -+#endif - - ifneq ($(wildcard $(srcdir)/man.tar.gz),) - # SCO OpenServer's man system is sufficiently different to not bother. +--- doc/src/sgml/Makefile.orig 2010-06-12 23:40:31.000000000 +0200 ++++ doc/src/sgml/Makefile 2010-09-19 22:07:11.210759927 +0200 +@@ -15,14 +15,14 @@ + + # Make "html" the default target, since that is what most people tend + # to want to use. +-html: ++man: + + subdir = doc/src/sgml + top_builddir = ../../.. + include $(top_builddir)/src/Makefile.global + + +-all: html man ++all: man + + distprep: html distprep-man + +@@ -285,7 +285,7 @@ + ## Install + ## + +-install: install-html ++##install: install-html + + ifneq ($(PORTNAME), sco) + install: install-man diff --git a/databases/postgresql91-server/pkg-plist-client b/databases/postgresql91-server/pkg-plist-client index 31a1fd4b22f4..cb6713877cee 100644 --- a/databases/postgresql91-server/pkg-plist-client +++ b/databases/postgresql91-server/pkg-plist-client @@ -40,6 +40,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 @@ -77,6 +78,8 @@ include/postgresql/server/catalog/pg_control.h 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 @@ -87,7 +90,7 @@ include/postgresql/server/catalog/pg_inherits.h 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 @@ -134,7 +137,6 @@ include/postgresql/server/commands/typecmds.h 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/execdebug.h @@ -157,8 +159,10 @@ include/postgresql/server/executor/nodeHash.h 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 @@ -177,8 +181,8 @@ include/postgresql/server/executor/spi_priv.h include/postgresql/server/executor/tstoreReceiver.h include/postgresql/server/executor/tuptable.h include/postgresql/server/fmgr.h -include/postgresql/server/funcapi.h include/postgresql/server/foreign/foreign.h +include/postgresql/server/funcapi.h include/postgresql/server/getaddrinfo.h include/postgresql/server/getopt_long.h include/postgresql/server/lib/dllist.h @@ -250,12 +254,14 @@ include/postgresql/server/parser/parse_expr.h 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 @@ -314,6 +320,9 @@ include/postgresql/server/regex/regcustom.h include/postgresql/server/regex/regerrs.h include/postgresql/server/regex/regex.h include/postgresql/server/regex/regguts.h +include/postgresql/server/replication/walprotocol.h +include/postgresql/server/replication/walreceiver.h +include/postgresql/server/replication/walsender.h include/postgresql/server/rewrite/prs2lock.h include/postgresql/server/rewrite/rewriteDefine.h include/postgresql/server/rewrite/rewriteHandler.h @@ -381,6 +390,7 @@ 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/procsignal.h include/postgresql/server/storage/relfilenode.h include/postgresql/server/storage/s_lock.h include/postgresql/server/storage/shmem.h @@ -388,6 +398,7 @@ include/postgresql/server/storage/sinval.h 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/dest.h include/postgresql/server/tcop/fastpath.h include/postgresql/server/tcop/pquery.h @@ -404,7 +415,9 @@ include/postgresql/server/tsearch/ts_utils.h 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 @@ -415,7 +428,6 @@ 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 @@ -441,12 +453,15 @@ include/postgresql/server/utils/plancache.h 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 @@ -458,6 +473,9 @@ include/postgresql/server/utils/uuid.h include/postgresql/server/utils/varbit.h include/postgresql/server/utils/xml.h include/postgresql/server/windowapi.h +include/sqlda-compat.h +include/sqlda-native.h +include/sqlda.h @dirrm include/postgresql/server/utils @dirrm include/postgresql/server/tsearch/dicts @dirrm include/postgresql/server/tsearch @@ -466,6 +484,7 @@ include/postgresql/server/windowapi.h @dirrm include/postgresql/server/snowball/libstemmer @dirrm include/postgresql/server/snowball @dirrm include/postgresql/server/rewrite +@dirrm include/postgresql/server/replication @dirrm include/postgresql/server/regex @dirrm include/postgresql/server/postmaster @dirrm include/postgresql/server/portability @@ -495,7 +514,6 @@ include/postgresql/internal/libpq/pqcomm.h @dirrm include/postgresql/internal/libpq include/postgresql/informix/esql/datetime.h include/postgresql/informix/esql/decimal.h -include/postgresql/informix/esql/sqlda.h include/postgresql/informix/esql/sqltypes.h @dirrm include/postgresql/informix/esql @dirrm include/postgresql/informix @@ -535,7 +553,6 @@ lib/libpq.so.5 lib/libpgtypes.a lib/libpgtypes.so lib/postgresql/pgxs/config/install-sh -lib/postgresql/pgxs/config/mkinstalldirs lib/postgresql/pgxs/src/makefiles/pgxs.mk lib/postgresql/pgxs/src/Makefile.global lib/postgresql/pgxs/src/Makefile.port @@ -551,70 +568,76 @@ lib/postgresql/pgxs/src/nls-global.mk share/postgresql/pg_service.conf.sample share/postgresql/psqlrc.sample @dirrmtry share/postgresql -%%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/cs/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/cs/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/ecpglib6-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/ecpg-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_dump-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/ecpglib6-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/ecpg-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_dump-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/ecpglib6-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/ecpg-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_dump-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/ecpg-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/ecpglib6-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/ecpglib6-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/ecpg-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_dump-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/nb/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/ecpglib6-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/ecpg-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_dump-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/ro/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/ru/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_dump-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/ecpglib6-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/ecpg-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_dump-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_config-8.4.mo +%%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/cs/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/cs/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/ko/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/ko/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/nb/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/ro/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/ru/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/ta/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/ta/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pgscripts-9.0.mo diff --git a/databases/postgresql91-server/pkg-plist-contrib b/databases/postgresql91-server/pkg-plist-contrib index 7fd4f432829d..b3a1c61e6d8e 100644 --- a/databases/postgresql91-server/pkg-plist-contrib +++ b/databases/postgresql91-server/pkg-plist-contrib @@ -1,6 +1,7 @@ bin/oid2name +bin/pg_archivecleanup bin/pg_standby -bin/pgbench +bin/pg_upgrade bin/vacuumlo lib/postgresql/_int.so lib/postgresql/adminpack.so @@ -23,10 +24,12 @@ lib/postgresql/lo.so lib/postgresql/ltree.so lib/postgresql/moddatetime.so lib/postgresql/pageinspect.so +lib/postgresql/passwordcheck.so lib/postgresql/pg_buffercache.so lib/postgresql/pg_freespacemap.so lib/postgresql/pg_stat_statements.so lib/postgresql/pg_trgm.so +lib/postgresql/pg_upgrade_support.so lib/postgresql/pgcrypto.so lib/postgresql/pgrowlocks.so lib/postgresql/pgstattuple.so @@ -38,6 +41,7 @@ lib/postgresql/tablefunc.so lib/postgresql/test_parser.so lib/postgresql/timetravel.so lib/postgresql/tsearch2.so +lib/postgresql/unaccent.so %%DOCSDIR%%/README-contrib %%DOCSDIR%%/contrib/README %%DOCSDIR%%/contrib/autoinc.example @@ -81,6 +85,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 @@ -112,6 +117,8 @@ share/postgresql/contrib/uninstall_sslinfo.sql 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/tsearch_data/unaccent.rules share/postgresql/tsearch_data/xsyn_sample.rules @dirrmtry share/postgresql/tsearch_data >&2 @dirrmtry share/postgresql/contrib >&2 diff --git a/databases/postgresql91-server/pkg-plist-server b/databases/postgresql91-server/pkg-plist-server index 7a5170bad6fd..68224f4750ef 100644 --- a/databases/postgresql91-server/pkg-plist-server +++ b/databases/postgresql91-server/pkg-plist-server @@ -10,7 +10,7 @@ lib/postgresql/ascii_and_mic.so lib/postgresql/cyrillic_and_mic.so lib/postgresql/dict_snowball.so lib/postgresql/euc_cn_and_mic.so -lib/postgresql/euc_jis_2004_and_shift_jis_2004.so +lib/postgresql/euc2004_sjis2004.so lib/postgresql/euc_jp_and_sjis.so lib/postgresql/euc_kr_and_mic.so lib/postgresql/euc_tw_and_big5.so @@ -21,17 +21,17 @@ lib/postgresql/utf8_and_ascii.so lib/postgresql/utf8_and_big5.so lib/postgresql/utf8_and_cyrillic.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 +lib/postgresql/utf8_and_euc2004.so lib/postgresql/utf8_and_gb18030.so 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 %%DOCSDIR%%/README-server @@ -46,62 +46,69 @@ share/postgresql/postgresql.conf.sample share/postgresql/recovery.conf.sample share/postgresql/sql_features.txt share/postgresql/system_views.sql -%%GETTEXT%%share/locale/cs/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/postgres-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/plpgsql-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/postgres-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/plpgsql-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/postgres-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/plpgsql-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/plpgsql-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/postgres-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/plpgsql-8.4.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/postgres-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/ro/LC_MESSAGES/plpgsql-8.4.mo -%%GETTEXT%%share/locale/ru/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/postgres-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_resetxlog-8.4.mo +%%GETTEXT%%share/locale/cs/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/postgres-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/postgres-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/postgres-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/postgres-9.0.mo +%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/postgres-9.0.mo +%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/ro/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/ru/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/ta/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/postgres-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_resetxlog-9.0.mo share/postgresql/postgres.shdescription share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Africa/Abidjan @@ -180,6 +187,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/America/Atikokan %%TZDATA%%share/postgresql/timezone/America/Atka %%TZDATA%%share/postgresql/timezone/America/Bahia +%%TZDATA%%share/postgresql/timezone/America/Bahia_Banderas %%TZDATA%%share/postgresql/timezone/America/Barbados %%TZDATA%%share/postgresql/timezone/America/Belem %%TZDATA%%share/postgresql/timezone/America/Belize @@ -317,6 +325,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Antarctica/Casey %%TZDATA%%share/postgresql/timezone/Antarctica/Davis %%TZDATA%%share/postgresql/timezone/Antarctica/DumontDUrville +%%TZDATA%%share/postgresql/timezone/Antarctica/Macquarie %%TZDATA%%share/postgresql/timezone/Antarctica/Mawson %%TZDATA%%share/postgresql/timezone/Antarctica/McMurdo %%TZDATA%%share/postgresql/timezone/Antarctica/Palmer @@ -612,6 +621,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Pacific/Apia %%TZDATA%%share/postgresql/timezone/Pacific/Auckland %%TZDATA%%share/postgresql/timezone/Pacific/Chatham +%%TZDATA%%share/postgresql/timezone/Pacific/Chuuk %%TZDATA%%share/postgresql/timezone/Pacific/Easter %%TZDATA%%share/postgresql/timezone/Pacific/Efate %%TZDATA%%share/postgresql/timezone/Pacific/Enderbury @@ -637,6 +647,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Pacific/Pago_Pago %%TZDATA%%share/postgresql/timezone/Pacific/Palau %%TZDATA%%share/postgresql/timezone/Pacific/Pitcairn +%%TZDATA%%share/postgresql/timezone/Pacific/Pohnpei %%TZDATA%%share/postgresql/timezone/Pacific/Ponape %%TZDATA%%share/postgresql/timezone/Pacific/Port_Moresby %%TZDATA%%share/postgresql/timezone/Pacific/Rarotonga diff --git a/databases/postgresql92-server/Makefile b/databases/postgresql92-server/Makefile index 7ce9dab829cd..80d9c75a968c 100644 --- a/databases/postgresql92-server/Makefile +++ b/databases/postgresql92-server/Makefile @@ -6,8 +6,7 @@ # PORTNAME?= postgresql -DISTVERSION?= 8.4.3 -PORTREVISION?= 2 +DISTVERSION?= 9.0.0 CATEGORIES?= databases MASTER_SITES= ${MASTER_SITE_PGSQL} MASTER_SITE_SUBDIR= source/v${DISTVERSION} @@ -16,15 +15,13 @@ PKGNAMESUFFIX?= -server MAINTAINER?= girgen@FreeBSD.org COMMENT?= The most advanced open-source database available anywhere -CONFLICTS?= ${PORTNAME}-client-7.* \ - ${PORTNAME}${PKGNAMESUFFIX}-7.* \ - ${PORTNAME}-client-8.[0-35-9]* \ - ${PORTNAME}${PKGNAMESUFFIX}-8.[0-35-9]* +CONFLICTS?= ${PORTNAME}-client-[78]* \ + ${PORTNAME}${PKGNAMESUFFIX}-[78]* WRKSRC= ${WRKDIR}/postgresql-${DISTVERSION} DIST_SUBDIR= postgresql -UNIQUENAME?= ${PORTNAME}84 +UNIQUENAME?= ${PORTNAME}90 LATEST_LINK?= ${PKGNAMEPREFIX}${UNIQUENAME}${PKGNAMESUFFIX} PKGINSTALL?= ${PKGDIR}/pkg-install${PKGNAMESUFFIX} @@ -83,6 +80,7 @@ CONFIGURE_ARGS+=--with-openssl .include <bsd.port.pre.mk> .if !defined(SLAVE_ONLY) +OPTIONS+= DTRACE "Build with DTrace probes (server only)" off OPTIONS+= PAM "Build with PAM support (server only)" off OPTIONS+= LDAP "Build with LDAP authentication support" off OPTIONS+= MIT_KRB5 "Build with MIT's kerberos support" off @@ -108,10 +106,9 @@ IGNORE= options WITH_ICU and WITH_ICU4 are mutually exclusive USE_AUTOTOOLS= autoconf:267 CONFIGURE_ARGS+=--with-icu PATCH_SITES+= http://people.freebsd.org/~girgen/postgresql-icu/:icu -PATCHFILES+= pg-840-icu-2009-09-15.diff.gz:icu +PATCHFILES+= pg-900-icu-2010-09-19.diff.gz:icu . if defined(WITH_ICU4) -LIB_DEPENDS+= icudata.43:${PORTSDIR}/devel/icu4 -EXTRA_PATCHES+= ${FILESDIR}/extra-patch-icu4 +LIB_DEPENDS+= icudata.44:${PORTSDIR}/devel/icu4 . else LIB_DEPENDS+= icudata.38:${PORTSDIR}/devel/icu . endif @@ -119,6 +116,11 @@ LIB_DEPENDS+= icudata.38:${PORTSDIR}/devel/icu PATCH_DIST_STRIP=-p1 +. if defined(SERVER_ONLY) && defined(WITH_DTRACE) +CONFIGURE_ARGS+=--enable-dtrace +LDFLAGS+=-lelf +. endif + . if defined(SERVER_ONLY) && defined(WITH_PAM) CONFIGURE_ARGS+=--with-pam . endif @@ -199,57 +201,81 @@ MAN1= clusterdb.1 createdb.1 createlang.1 createuser.1 \ pg_dump.1 pg_dumpall.1 pg_resetxlog.1 pg_restore.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_foreign_data_wrapper.7 alter_function.7 alter_group.7 alter_server.7 \ - alter_user_mapping.7 alter_index.7 alter_language.7 alter_operator_class.7 \ - alter_operator_family.7 \ - alter_role.7 \ - alter_schema.7 alter_sequence.7 alter_table.7 \ - alter_text_search_configuration.7 \ - alter_text_search_dictionary.7 \ - alter_text_search_parser.7 \ - alter_text_search_template.7 \ - alter_trigger.7 alter_user.7 alter_view.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_foreign_data_wrapper.7 \ - create_function.7 \ - create_group.7 create_index.7 create_language.7 \ - create_operator.7 create_operator_class.7 \ - create_operator_family.7 create_role.7 \ - create_rule.7 create_schema.7 create_sequence.7 \ - create_server.7 create_table.7 create_table_as.7 \ - create_text_search_configuration.7 \ - create_text_search_dictionary.7 \ - create_text_search_parser.7 \ - create_text_search_template.7 create_trigger.7 \ - create_type.7 create_user.7 create_user_mapping.7 create_view.7 deallocate.7 \ - declare.7 delete.7 discard.7 \ - drop_aggregate.7 drop_cast.7 drop_conversion.7 \ - drop_database.7 drop_domain.7 drop_foreign_data_wrapper.7 drop_function.7 \ - drop_group.7 drop_index.7 drop_language.7 \ - drop_operator.7 drop_operator_class.7 drop_operator_family.7 \ - drop_owned.7 drop_role.7 drop_rule.7 \ - drop_schema.7 drop_sequence.7 drop_server.7 drop_table.7 \ - drop_text_search_configuration.7 \ - drop_text_search_dictionary.7 \ - drop_text_search_parser.7 \ - drop_text_search_template.7 drop_trigger.7 \ - drop_type.7 drop_user.7 drop_user_mapping.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 prepare_transaction.7 \ - reassign_owned.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 \ - table.7 truncate.7 unlisten.7 update.7 vacuum.7 \ - alter_operator.7 alter_tablespace.7 alter_type.7 \ - create_tablespace.7 drop_tablespace.7 \ - release_savepoint.7 rollback_to_savepoint.7 \ - savepoint.7 values.7 with.7 +MAN3= SPI_connect.3 SPI_copytuple.3 SPI_cursor_close.3 SPI_cursor_fetch.3 \ + SPI_cursor_find.3 SPI_cursor_move.3 SPI_cursor_open.3 \ + SPI_cursor_open_with_args.3 SPI_cursor_open_with_paramlist.3 \ + SPI_exec.3 SPI_execp.3 SPI_execute.3 SPI_execute_plan.3 \ + SPI_execute_plan_with_paramlist.3 SPI_execute_with_args.3 \ + SPI_finish.3 SPI_fname.3 SPI_fnumber.3 SPI_freeplan.3 \ + SPI_freetuple.3 SPI_freetuptable.3 SPI_getargcount.3 \ + SPI_getargtypeid.3 SPI_getbinval.3 SPI_getnspname.3 \ + SPI_getrelname.3 SPI_gettype.3 SPI_gettypeid.3 \ + SPI_getvalue.3 SPI_is_cursor_plan.3 SPI_modifytuple.3 \ + SPI_palloc.3 SPI_pfree.3 SPI_pop.3 SPI_prepare.3 \ + SPI_prepare_cursor.3 SPI_prepare_params.3 SPI_push.3 \ + SPI_repalloc.3 SPI_returntuple.3 SPI_saveplan.3 \ + SPI_scroll_cursor_fetch.3 SPI_scroll_cursor_move.3 \ + dblink.3 dblink_build_sql_delete.3 dblink_build_sql_insert.3 \ + dblink_build_sql_update.3 dblink_cancel_query.3 \ + dblink_close.3 dblink_connect.3 dblink_connect_u.3 \ + dblink_disconnect.3 dblink_error_message.3 dblink_exec.3 \ + dblink_fetch.3 dblink_get_connections.3 dblink_get_notify.3 \ + dblink_get_pkey.3 dblink_get_result.3 dblink_is_busy.3 \ + dblink_open.3 dblink_send_query.3 + +MAN7= ABORT.7 ALTER_AGGREGATE.7 ALTER_CONVERSION.7 ALTER_DATABASE.7 \ + ALTER_DEFAULT_PRIVILEGES.7 \ + ALTER_DOMAIN.7 ALTER_FOREIGN_DATA_WRAPPER.7 ALTER_FUNCTION.7 ALTER_GROUP.7 \ + ALTER_LARGE_OBJECT.7 ALTER_SERVER.7 \ + ALTER_USER_MAPPING.7 ALTER_INDEX.7 ALTER_LANGUAGE.7 ALTER_OPERATOR_CLASS.7 \ + ALTER_OPERATOR_FAMILY.7 \ + ALTER_ROLE.7 \ + ALTER_SCHEMA.7 ALTER_SEQUENCE.7 ALTER_TABLE.7 \ + ALTER_TEXT_SEARCH_CONFIGURATION.7 \ + ALTER_TEXT_SEARCH_DICTIONARY.7 \ + ALTER_TEXT_SEARCH_PARSER.7 \ + ALTER_TEXT_SEARCH_TEMPLATE.7 \ + ALTER_TRIGGER.7 ALTER_USER.7 ALTER_VIEW.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_FOREIGN_DATA_WRAPPER.7 \ + CREATE_FUNCTION.7 \ + CREATE_GROUP.7 CREATE_INDEX.7 CREATE_LANGUAGE.7 \ + CREATE_OPERATOR.7 CREATE_OPERATOR_CLASS.7 \ + CREATE_OPERATOR_FAMILY.7 CREATE_ROLE.7 \ + CREATE_RULE.7 CREATE_SCHEMA.7 CREATE_SEQUENCE.7 \ + CREATE_SERVER.7 CREATE_TABLE.7 CREATE_TABLE_AS.7 \ + CREATE_TEXT_SEARCH_CONFIGURATION.7 \ + CREATE_TEXT_SEARCH_DICTIONARY.7 \ + CREATE_TEXT_SEARCH_PARSER.7 \ + CREATE_TEXT_SEARCH_TEMPLATE.7 CREATE_TRIGGER.7 \ + CREATE_TYPE.7 CREATE_USER.7 CREATE_USER_MAPPING.7 CREATE_VIEW.7 DEALLOCATE.7 \ + DECLARE.7 DELETE.7 DISCARD.7 \ + DO.7 DROP_AGGREGATE.7 DROP_CAST.7 DROP_CONVERSION.7 \ + DROP_DATABASE.7 DROP_DOMAIN.7 DROP_FOREIGN_DATA_WRAPPER.7 DROP_FUNCTION.7 \ + DROP_GROUP.7 DROP_INDEX.7 DROP_LANGUAGE.7 \ + DROP_OPERATOR.7 DROP_OPERATOR_CLASS.7 DROP_OPERATOR_FAMILY.7 \ + DROP_OWNED.7 DROP_ROLE.7 DROP_RULE.7 \ + DROP_SCHEMA.7 DROP_SEQUENCE.7 DROP_SERVER.7 DROP_TABLE.7 \ + DROP_TEXT_SEARCH_CONFIGURATION.7 \ + DROP_TEXT_SEARCH_DICTIONARY.7 \ + DROP_TEXT_SEARCH_PARSER.7 \ + DROP_TEXT_SEARCH_TEMPLATE.7 DROP_TRIGGER.7 \ + DROP_TYPE.7 DROP_USER.7 DROP_USER_MAPPING.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 PREPARE_TRANSACTION.7 \ + REASSIGN_OWNED.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 \ + TABLE.7 TRUNCATE.7 UNLISTEN.7 UPDATE.7 VACUUM.7 \ + ALTER_OPERATOR.7 ALTER_TABLESPACE.7 ALTER_TYPE.7 \ + CREATE_TABLESPACE.7 DROP_TABLESPACE.7 \ + RELEASE_SAVEPOINT.7 ROLLBACK_TO_SAVEPOINT.7 \ + SAVEPOINT.7 VALUES.7 WITH.7 .endif .if defined(SERVER_ONLY) diff --git a/databases/postgresql92-server/distinfo b/databases/postgresql92-server/distinfo index 81d413a0628a..d6eca70c281d 100644 --- a/databases/postgresql92-server/distinfo +++ b/databases/postgresql92-server/distinfo @@ -1,6 +1,6 @@ -MD5 (postgresql/postgresql-8.4.3.tar.bz2) = 7f70e7b140fb190f268837255582b07e -SHA256 (postgresql/postgresql-8.4.3.tar.bz2) = 050c3e8324b453715e819456638fc1561351b33c8011b7cb63db98bbc2061564 -SIZE (postgresql/postgresql-8.4.3.tar.bz2) = 13645257 -SHA256 (postgresql/pg-840-icu-2009-09-15.diff.gz) = c09d3b59340a3bb6ea754e985739d4fbb47f730d1e48a357c5585825034fc72e -MD5 (postgresql/pg-840-icu-2009-09-15.diff.gz) = 2b81134b462e01623bc9387fe4de7136 -SIZE (postgresql/pg-840-icu-2009-09-15.diff.gz) = 4321 +MD5 (postgresql/postgresql-9.0.0.tar.bz2) = 14c2122cc322e69ab2ab702ed7714bbe +SHA256 (postgresql/postgresql-9.0.0.tar.bz2) = 7dcc381603c02595adc96a8fc5c9d067d3b39aaa44987e7a524a7504a10ff676 +SIZE (postgresql/postgresql-9.0.0.tar.bz2) = 13753207 +SHA256 (postgresql/pg-900-icu-2010-09-19.diff.gz) = 27cea46241ec814965c278330cd96f67ee03422b7758a210713a63b4b5bb77e9 +MD5 (postgresql/pg-900-icu-2010-09-19.diff.gz) = 150268fbcce8c0bbe68c176dcb5464ad +SIZE (postgresql/pg-900-icu-2010-09-19.diff.gz) = 4349 diff --git a/databases/postgresql92-server/files/502.pgsql b/databases/postgresql92-server/files/502.pgsql index d2235e414cd2..281189a59c46 100644 --- a/databases/postgresql92-server/files/502.pgsql +++ b/databases/postgresql92-server/files/502.pgsql @@ -15,7 +15,8 @@ # Define these variables in either /etc/periodic.conf or # /etc/periodic.conf.local to override the default values. # -# daily_pgsql_backup_enable="YES" # do backup +# daily_pgsql_backup_enable="YES" # do backup of all databases +# daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases # daily_pgsql_vacuum_enable="YES" # do vacuum daily_pgsql_vacuum_args="-z" @@ -37,9 +38,7 @@ eval backupdir=${daily_pgsql_backupdir} rc=0 -case "$daily_pgsql_backup_enable" in - [Yy][Ee][Ss]) - +pgsql_backup() { # daily_pgsql_backupdir must be writeable by user pgsql # ~pgsql is just that under normal circumstances, # but this might not be where you want the backups... @@ -53,16 +52,18 @@ case "$daily_pgsql_backup_enable" in # Protect the data umask 077 - dbnames=`su -l pgsql -c "umask 077; psql -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` rc=$? now=`date "+%Y-%m-%dT%H:%M:%S"` file=${daily_pgsql_backupdir}/pgglobals_${now} su -l pgsql -c "umask 077; pg_dumpall -g | gzip -9 > ${file}.gz" - for db in ${dbnames}; do + + db=$1 + while shift; do echo -n " $db" file=${backupdir}/pgdump_${db}_${now} su -l pgsql -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}" [ $? -gt 0 ] && rc=3 + db=$1 done if [ $rc -gt 0 ]; then @@ -73,6 +74,23 @@ case "$daily_pgsql_backup_enable" in # cleaning up old data find ${backupdir} \( -name 'pgdump_*' -o -name 'pgglobals_*' \) \ -a -mtime +${daily_pgsql_savedays} -delete + echo +} + +case "$daily_pgsql_backup_enable" in + [Yy][Ee][Ss]) + dbnames=`su -l pgsql -c "umask 077; psql -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` + pgsql_backup $dbnames + ;; + + [Nn][Oo]) + ;; + + "") + ;; + + *) + pgsql_backup $daily_pgsql_backup_enable ;; esac diff --git a/databases/postgresql92-server/files/extra-patch-icu4 b/databases/postgresql92-server/files/extra-patch-icu4 deleted file mode 100644 index 28c8a8cfff33..000000000000 --- a/databases/postgresql92-server/files/extra-patch-icu4 +++ /dev/null @@ -1,30 +0,0 @@ ---- configure.in.orig 2010-03-25 22:25:10.655197193 +0100 -+++ configure.in 2010-03-25 22:25:13.611658318 +0100 -@@ -945,15 +945,19 @@ - fi - - if test "$with_icu" = yes ; then -- AC_CHECK_LIB(icui18n, ucol_open_3_8, [], [ -- AC_CHECK_LIB(icui18n, ucol_open_3_6, [], [ -- AC_CHECK_LIB(icui18n, ucol_open_3_4, [], [AC_MSG_ERROR([library 'icui18n' is required for ICU])]) -- ]) -+ AC_CHECK_LIB(icui18n, ucol_open_43, [], [ -+ AC_CHECK_LIB(icui18n, ucol_open_3_8, [], [ -+ AC_CHECK_LIB(icui18n, ucol_open_3_6, [], [ -+ AC_CHECK_LIB(icui18n, ucol_open_3_4, [], [AC_MSG_ERROR([library 'icui18n' is required for ICU])]) -+ ]) -+ ]) - ]) -- AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_8, [], [ -- AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_6, [], [ -- AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_4, [], [AC_MSG_ERROR([library 'icuuc' is required for ICU])]) -- ]) -+ AC_CHECK_LIB(icuuc, ucnv_fromUChars_43, [], [ -+ AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_8, [], [ -+ AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_6, [], [ -+ AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_4, [], [AC_MSG_ERROR([library 'icuuc' is required for ICU])]) -+ ]) -+ ]) - ]) - fi - diff --git a/databases/postgresql92-server/files/patch-doc-Makefile b/databases/postgresql92-server/files/patch-doc-Makefile index 8e08132e175b..a366d4ca2620 100644 --- a/databases/postgresql92-server/files/patch-doc-Makefile +++ b/databases/postgresql92-server/files/patch-doc-Makefile @@ -1,16 +1,28 @@ ---- doc/Makefile.orig 2009-05-15 15:58:05.000000000 +0200 -+++ doc/Makefile 2009-05-15 15:58:18.000000000 +0200 -@@ -25,9 +25,10 @@ - - .NOTPARALLEL: - --ifneq ($(wildcard $(srcdir)/postgres.tar.gz),) --found_html = yes --endif -+# FreeBSD has a separate port for installing the documentation -+#ifneq ($(wildcard $(srcdir)/postgres.tar.gz),) -+#found_html = yes -+#endif - - ifneq ($(wildcard $(srcdir)/man.tar.gz),) - # SCO OpenServer's man system is sufficiently different to not bother. +--- doc/src/sgml/Makefile.orig 2010-06-12 23:40:31.000000000 +0200 ++++ doc/src/sgml/Makefile 2010-09-19 22:07:11.210759927 +0200 +@@ -15,14 +15,14 @@ + + # Make "html" the default target, since that is what most people tend + # to want to use. +-html: ++man: + + subdir = doc/src/sgml + top_builddir = ../../.. + include $(top_builddir)/src/Makefile.global + + +-all: html man ++all: man + + distprep: html distprep-man + +@@ -285,7 +285,7 @@ + ## Install + ## + +-install: install-html ++##install: install-html + + ifneq ($(PORTNAME), sco) + install: install-man diff --git a/databases/postgresql92-server/pkg-plist-client b/databases/postgresql92-server/pkg-plist-client index 31a1fd4b22f4..cb6713877cee 100644 --- a/databases/postgresql92-server/pkg-plist-client +++ b/databases/postgresql92-server/pkg-plist-client @@ -40,6 +40,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 @@ -77,6 +78,8 @@ include/postgresql/server/catalog/pg_control.h 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 @@ -87,7 +90,7 @@ include/postgresql/server/catalog/pg_inherits.h 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 @@ -134,7 +137,6 @@ include/postgresql/server/commands/typecmds.h 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/execdebug.h @@ -157,8 +159,10 @@ include/postgresql/server/executor/nodeHash.h 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 @@ -177,8 +181,8 @@ include/postgresql/server/executor/spi_priv.h include/postgresql/server/executor/tstoreReceiver.h include/postgresql/server/executor/tuptable.h include/postgresql/server/fmgr.h -include/postgresql/server/funcapi.h include/postgresql/server/foreign/foreign.h +include/postgresql/server/funcapi.h include/postgresql/server/getaddrinfo.h include/postgresql/server/getopt_long.h include/postgresql/server/lib/dllist.h @@ -250,12 +254,14 @@ include/postgresql/server/parser/parse_expr.h 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 @@ -314,6 +320,9 @@ include/postgresql/server/regex/regcustom.h include/postgresql/server/regex/regerrs.h include/postgresql/server/regex/regex.h include/postgresql/server/regex/regguts.h +include/postgresql/server/replication/walprotocol.h +include/postgresql/server/replication/walreceiver.h +include/postgresql/server/replication/walsender.h include/postgresql/server/rewrite/prs2lock.h include/postgresql/server/rewrite/rewriteDefine.h include/postgresql/server/rewrite/rewriteHandler.h @@ -381,6 +390,7 @@ 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/procsignal.h include/postgresql/server/storage/relfilenode.h include/postgresql/server/storage/s_lock.h include/postgresql/server/storage/shmem.h @@ -388,6 +398,7 @@ include/postgresql/server/storage/sinval.h 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/dest.h include/postgresql/server/tcop/fastpath.h include/postgresql/server/tcop/pquery.h @@ -404,7 +415,9 @@ include/postgresql/server/tsearch/ts_utils.h 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 @@ -415,7 +428,6 @@ 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 @@ -441,12 +453,15 @@ include/postgresql/server/utils/plancache.h 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 @@ -458,6 +473,9 @@ include/postgresql/server/utils/uuid.h include/postgresql/server/utils/varbit.h include/postgresql/server/utils/xml.h include/postgresql/server/windowapi.h +include/sqlda-compat.h +include/sqlda-native.h +include/sqlda.h @dirrm include/postgresql/server/utils @dirrm include/postgresql/server/tsearch/dicts @dirrm include/postgresql/server/tsearch @@ -466,6 +484,7 @@ include/postgresql/server/windowapi.h @dirrm include/postgresql/server/snowball/libstemmer @dirrm include/postgresql/server/snowball @dirrm include/postgresql/server/rewrite +@dirrm include/postgresql/server/replication @dirrm include/postgresql/server/regex @dirrm include/postgresql/server/postmaster @dirrm include/postgresql/server/portability @@ -495,7 +514,6 @@ include/postgresql/internal/libpq/pqcomm.h @dirrm include/postgresql/internal/libpq include/postgresql/informix/esql/datetime.h include/postgresql/informix/esql/decimal.h -include/postgresql/informix/esql/sqlda.h include/postgresql/informix/esql/sqltypes.h @dirrm include/postgresql/informix/esql @dirrm include/postgresql/informix @@ -535,7 +553,6 @@ lib/libpq.so.5 lib/libpgtypes.a lib/libpgtypes.so lib/postgresql/pgxs/config/install-sh -lib/postgresql/pgxs/config/mkinstalldirs lib/postgresql/pgxs/src/makefiles/pgxs.mk lib/postgresql/pgxs/src/Makefile.global lib/postgresql/pgxs/src/Makefile.port @@ -551,70 +568,76 @@ lib/postgresql/pgxs/src/nls-global.mk share/postgresql/pg_service.conf.sample share/postgresql/psqlrc.sample @dirrmtry share/postgresql -%%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/cs/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/cs/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/ecpglib6-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/ecpg-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_dump-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/ecpglib6-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/ecpg-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_dump-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/ecpglib6-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/ecpg-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_dump-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/ecpg-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/ecpglib6-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/ecpglib6-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/ecpg-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_dump-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/nb/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/ecpglib6-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/ecpg-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_dump-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/ro/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/ru/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_dump-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_config-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/libpq5-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/ecpglib6-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/ecpg-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_dump-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/psql-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/pgscripts-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_config-8.4.mo +%%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/cs/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/cs/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/ko/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/ko/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/nb/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/ro/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/ru/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/ta/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/ta/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/pgscripts-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/psql-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/ecpg-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/ecpglib6-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/libpq5-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_config-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_dump-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pgscripts-9.0.mo diff --git a/databases/postgresql92-server/pkg-plist-contrib b/databases/postgresql92-server/pkg-plist-contrib index 7fd4f432829d..b3a1c61e6d8e 100644 --- a/databases/postgresql92-server/pkg-plist-contrib +++ b/databases/postgresql92-server/pkg-plist-contrib @@ -1,6 +1,7 @@ bin/oid2name +bin/pg_archivecleanup bin/pg_standby -bin/pgbench +bin/pg_upgrade bin/vacuumlo lib/postgresql/_int.so lib/postgresql/adminpack.so @@ -23,10 +24,12 @@ lib/postgresql/lo.so lib/postgresql/ltree.so lib/postgresql/moddatetime.so lib/postgresql/pageinspect.so +lib/postgresql/passwordcheck.so lib/postgresql/pg_buffercache.so lib/postgresql/pg_freespacemap.so lib/postgresql/pg_stat_statements.so lib/postgresql/pg_trgm.so +lib/postgresql/pg_upgrade_support.so lib/postgresql/pgcrypto.so lib/postgresql/pgrowlocks.so lib/postgresql/pgstattuple.so @@ -38,6 +41,7 @@ lib/postgresql/tablefunc.so lib/postgresql/test_parser.so lib/postgresql/timetravel.so lib/postgresql/tsearch2.so +lib/postgresql/unaccent.so %%DOCSDIR%%/README-contrib %%DOCSDIR%%/contrib/README %%DOCSDIR%%/contrib/autoinc.example @@ -81,6 +85,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 @@ -112,6 +117,8 @@ share/postgresql/contrib/uninstall_sslinfo.sql 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/tsearch_data/unaccent.rules share/postgresql/tsearch_data/xsyn_sample.rules @dirrmtry share/postgresql/tsearch_data >&2 @dirrmtry share/postgresql/contrib >&2 diff --git a/databases/postgresql92-server/pkg-plist-server b/databases/postgresql92-server/pkg-plist-server index 7a5170bad6fd..68224f4750ef 100644 --- a/databases/postgresql92-server/pkg-plist-server +++ b/databases/postgresql92-server/pkg-plist-server @@ -10,7 +10,7 @@ lib/postgresql/ascii_and_mic.so lib/postgresql/cyrillic_and_mic.so lib/postgresql/dict_snowball.so lib/postgresql/euc_cn_and_mic.so -lib/postgresql/euc_jis_2004_and_shift_jis_2004.so +lib/postgresql/euc2004_sjis2004.so lib/postgresql/euc_jp_and_sjis.so lib/postgresql/euc_kr_and_mic.so lib/postgresql/euc_tw_and_big5.so @@ -21,17 +21,17 @@ lib/postgresql/utf8_and_ascii.so lib/postgresql/utf8_and_big5.so lib/postgresql/utf8_and_cyrillic.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 +lib/postgresql/utf8_and_euc2004.so lib/postgresql/utf8_and_gb18030.so 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 %%DOCSDIR%%/README-server @@ -46,62 +46,69 @@ share/postgresql/postgresql.conf.sample share/postgresql/recovery.conf.sample share/postgresql/sql_features.txt share/postgresql/system_views.sql -%%GETTEXT%%share/locale/cs/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/postgres-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/de/LC_MESSAGES/plpgsql-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/postgres-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/es/LC_MESSAGES/plpgsql-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/postgres-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/fr/LC_MESSAGES/plpgsql-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/it/LC_MESSAGES/plpgsql-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/postgres-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/ja/LC_MESSAGES/plpgsql-8.4.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/postgres-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/ro/LC_MESSAGES/plpgsql-8.4.mo -%%GETTEXT%%share/locale/ru/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_resetxlog-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/postgres-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/initdb-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_ctl-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_controldata-8.4.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_resetxlog-8.4.mo +%%GETTEXT%%share/locale/cs/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/de/LC_MESSAGES/postgres-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/es/LC_MESSAGES/postgres-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/fr/LC_MESSAGES/postgres-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/it/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/ja/LC_MESSAGES/postgres-9.0.mo +%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/postgres-9.0.mo +%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/ro/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/ru/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/ta/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_resetxlog-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/plpgsql-9.0.mo +%%GETTEXT%%share/locale/tr/LC_MESSAGES/postgres-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/initdb-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_controldata-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_ctl-9.0.mo +%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_resetxlog-9.0.mo share/postgresql/postgres.shdescription share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Africa/Abidjan @@ -180,6 +187,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/America/Atikokan %%TZDATA%%share/postgresql/timezone/America/Atka %%TZDATA%%share/postgresql/timezone/America/Bahia +%%TZDATA%%share/postgresql/timezone/America/Bahia_Banderas %%TZDATA%%share/postgresql/timezone/America/Barbados %%TZDATA%%share/postgresql/timezone/America/Belem %%TZDATA%%share/postgresql/timezone/America/Belize @@ -317,6 +325,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Antarctica/Casey %%TZDATA%%share/postgresql/timezone/Antarctica/Davis %%TZDATA%%share/postgresql/timezone/Antarctica/DumontDUrville +%%TZDATA%%share/postgresql/timezone/Antarctica/Macquarie %%TZDATA%%share/postgresql/timezone/Antarctica/Mawson %%TZDATA%%share/postgresql/timezone/Antarctica/McMurdo %%TZDATA%%share/postgresql/timezone/Antarctica/Palmer @@ -612,6 +621,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Pacific/Apia %%TZDATA%%share/postgresql/timezone/Pacific/Auckland %%TZDATA%%share/postgresql/timezone/Pacific/Chatham +%%TZDATA%%share/postgresql/timezone/Pacific/Chuuk %%TZDATA%%share/postgresql/timezone/Pacific/Easter %%TZDATA%%share/postgresql/timezone/Pacific/Efate %%TZDATA%%share/postgresql/timezone/Pacific/Enderbury @@ -637,6 +647,7 @@ share/postgresql/snowball_create.sql %%TZDATA%%share/postgresql/timezone/Pacific/Pago_Pago %%TZDATA%%share/postgresql/timezone/Pacific/Palau %%TZDATA%%share/postgresql/timezone/Pacific/Pitcairn +%%TZDATA%%share/postgresql/timezone/Pacific/Pohnpei %%TZDATA%%share/postgresql/timezone/Pacific/Ponape %%TZDATA%%share/postgresql/timezone/Pacific/Port_Moresby %%TZDATA%%share/postgresql/timezone/Pacific/Rarotonga |