PostgreSQL 9.0 is here! The PostgreSQL Global Development Group

announces the availability of our most eagerly awaited release.
PostgreSQL 9.0 includes built-in, binary replication, and over a dozen
other major features which will appeal to everyone from web developers
to database hackers.

9.0 includes more major features than any release before it, including:
* Hot standby
* Streaming replication
* In-place upgrades
* 64-bit Windows builds
* Easy mass permissions management
* Anonymous blocks and named parameter calls for stored procedures
* New windowing functions and ordered aggregates

... and many more.  For details on the over 200 additions and
improvements in this version, developed by over a hundred contributors,
please see the release notes.

"These kinds of feature additions continue to make a strong case for why
mission-critical technology tasks can continue to depend on the power,
flexibility and robustness of PostgreSQL,” said Afilias CTO Ram Mohan.

More information on PostgreSQL 9.0:
* Release notes
  http://www.postgresql.org/docs/9.0/static/release-9-0
* Presskit
  http://www.postgresql.org/about/press/presskit90
* Guide to 9.0:
  http://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.0

---
PR: 150430, Add dtrace

1 files changed, 96 insertions, 73 deletions

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