Date: Thu, 3 Oct 2019 13:52:44 +0000 (UTC) From: Palle Girgensohn <girgen@FreeBSD.org> To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r513665 - head/databases/postgresql12-server Message-ID: <201910031352.x93DqiE3022030@repo.freebsd.org>
next in thread | raw e-mail | index | archive | help
Author: girgen Date: Thu Oct 3 13:52:44 2019 New Revision: 513665 URL: https://svnweb.freebsd.org/changeset/ports/513665 Log: Upgrade to postgresql-12.0 PostgreSQL 12 enhancements include notable improvements to query performance, particularly over larger data sets, and overall space utilization. This release provides application developers with new capabilities such as SQL/JSON path expression support, optimizations for how common table expression ("WITH") queries are executed, and generated columns. The PostgreSQL community continues to support the extensibility and robustness of PostgreSQL, with further additions to internationalization, authentication, and providing easier ways to administrate PostgreSQL. This release also introduces the pluggable table storage interface, which allows developers to create their own methods for storing data. "The development community behind PostgreSQL contributed features for PostgreSQL 12 that offer performance and space management gains that our users can achieve with minimal effort, as well as improvements in enterprise authentication, administration functionality, and SQL/JSON support." said Dave Page, a core team member of the PostgreSQL Global Development Group. "This release continues the trend of making it easier to manage database workloads large and small while building on PostgreSQL's reputation of flexibility, reliability and stability in production environments." Release notes: https://www.postgresql.org/about/news/1976/ Modified: head/databases/postgresql12-server/Makefile head/databases/postgresql12-server/distinfo head/databases/postgresql12-server/pkg-plist-client head/databases/postgresql12-server/pkg-plist-server Modified: head/databases/postgresql12-server/Makefile ============================================================================== --- head/databases/postgresql12-server/Makefile Thu Oct 3 13:46:23 2019 (r513664) +++ head/databases/postgresql12-server/Makefile Thu Oct 3 13:52:44 2019 (r513665) @@ -2,7 +2,7 @@ # $FreeBSD$ PORTNAME?= postgresql -DISTVERSION?= 12rc1 +DISTVERSION?= 12.0 # PORTREVISION must be ?= otherwise, all slave ports get this PORTREVISION and # not their own. Probably best to keep it at ?=0 when reset here too. PORTREVISION?= 0 Modified: head/databases/postgresql12-server/distinfo ============================================================================== --- head/databases/postgresql12-server/distinfo Thu Oct 3 13:46:23 2019 (r513664) +++ head/databases/postgresql12-server/distinfo Thu Oct 3 13:52:44 2019 (r513665) @@ -1,3 +1,3 @@ -TIMESTAMP = 1569402272 -SHA256 (postgresql/postgresql-12rc1.tar.bz2) = 40facd3280d8565f37139d2c5df2b94fe68a064c5d2784f74fceae24820543f3 -SIZE (postgresql/postgresql-12rc1.tar.bz2) = 20718193 +TIMESTAMP = 1569942321 +SHA256 (postgresql/postgresql-12.0.tar.bz2) = cda2397215f758b793f741c86be05468257b0e6bcb1a6113882ab5d0df0855c6 +SIZE (postgresql/postgresql-12.0.tar.bz2) = 20177458 Modified: head/databases/postgresql12-server/pkg-plist-client ============================================================================== --- head/databases/postgresql12-server/pkg-plist-client Thu Oct 3 13:46:23 2019 (r513664) +++ head/databases/postgresql12-server/pkg-plist-client Thu Oct 3 13:52:44 2019 (r513665) @@ -16,6 +16,7 @@ bin/vacuumdb include/ecpg_config.h include/ecpg_informix.h include/ecpgerrno.h +include/ecpglib.h include/ecpgtype.h include/libpq-events.h include/libpq-fe.h @@ -451,6 +452,7 @@ include/postgresql/server/optimizer/geqo_gene.h include/postgresql/server/optimizer/geqo_misc.h include/postgresql/server/optimizer/geqo_mutation.h include/postgresql/server/optimizer/geqo_pool.h +include/postgresql/server/optimizer/geqo_random.h include/postgresql/server/optimizer/inherit.h include/postgresql/server/optimizer/optimizer.h include/postgresql/server/partitioning/partdesc.h @@ -804,6 +806,7 @@ include/sqlca.h include/sqlda-compat.h include/sqlda-native.h include/sqlda.h +lib/libecpg.so.6 lib/libecpg.a lib/libecpg.so lib/libecpg_compat.a @@ -1115,103 +1118,94 @@ man/man7/VACUUM.7.gz man/man7/VALUES.7.gz man/man7/WITH.7.gz %%PORTDOCS%%%%DOCSDIR%%/README-client -%%NLS%%include/postgresql/server/optimizer/geqo_random.h %%NLS%%share/locale/cs/LC_MESSAGES/ecpg-12.mo +%%NLS%%share/locale/cs/LC_MESSAGES/ecpglib6-12.mo %%NLS%%share/locale/cs/LC_MESSAGES/libpq5-12.mo %%NLS%%share/locale/cs/LC_MESSAGES/pg_config-12.mo %%NLS%%share/locale/cs/LC_MESSAGES/pg_dump-12.mo %%NLS%%share/locale/cs/LC_MESSAGES/pgscripts-12.mo %%NLS%%share/locale/cs/LC_MESSAGES/psql-12.mo %%NLS%%share/locale/de/LC_MESSAGES/ecpg-12.mo +%%NLS%%share/locale/de/LC_MESSAGES/ecpglib6-12.mo %%NLS%%share/locale/de/LC_MESSAGES/libpq5-12.mo %%NLS%%share/locale/de/LC_MESSAGES/pg_config-12.mo %%NLS%%share/locale/de/LC_MESSAGES/pg_dump-12.mo %%NLS%%share/locale/de/LC_MESSAGES/pgscripts-12.mo %%NLS%%share/locale/de/LC_MESSAGES/psql-12.mo %%NLS%%share/locale/es/LC_MESSAGES/ecpg-12.mo +%%NLS%%share/locale/es/LC_MESSAGES/ecpglib6-12.mo %%NLS%%share/locale/es/LC_MESSAGES/libpq5-12.mo %%NLS%%share/locale/es/LC_MESSAGES/pg_config-12.mo %%NLS%%share/locale/es/LC_MESSAGES/pg_dump-12.mo %%NLS%%share/locale/es/LC_MESSAGES/pgscripts-12.mo %%NLS%%share/locale/es/LC_MESSAGES/psql-12.mo %%NLS%%share/locale/fr/LC_MESSAGES/ecpg-12.mo +%%NLS%%share/locale/fr/LC_MESSAGES/ecpglib6-12.mo %%NLS%%share/locale/fr/LC_MESSAGES/libpq5-12.mo %%NLS%%share/locale/fr/LC_MESSAGES/pg_config-12.mo -%%NLS%%share/locale/fr/LC_MESSAGES/pg_dump-12.mo -%%NLS%%share/locale/fr/LC_MESSAGES/pgscripts-12.mo %%NLS%%share/locale/fr/LC_MESSAGES/psql-12.mo %%NLS%%share/locale/he/LC_MESSAGES/libpq5-12.mo %%NLS%%share/locale/he/LC_MESSAGES/pg_config-12.mo -%%NLS%%share/locale/he/LC_MESSAGES/pg_dump-12.mo -%%NLS%%share/locale/he/LC_MESSAGES/pgscripts-12.mo -%%NLS%%share/locale/he/LC_MESSAGES/psql-12.mo %%NLS%%share/locale/it/LC_MESSAGES/ecpg-12.mo +%%NLS%%share/locale/it/LC_MESSAGES/ecpglib6-12.mo %%NLS%%share/locale/it/LC_MESSAGES/libpq5-12.mo %%NLS%%share/locale/it/LC_MESSAGES/pg_config-12.mo -%%NLS%%share/locale/it/LC_MESSAGES/pg_dump-12.mo -%%NLS%%share/locale/it/LC_MESSAGES/pgscripts-12.mo %%NLS%%share/locale/it/LC_MESSAGES/psql-12.mo %%NLS%%share/locale/ja/LC_MESSAGES/ecpg-12.mo +%%NLS%%share/locale/ja/LC_MESSAGES/ecpglib6-12.mo %%NLS%%share/locale/ja/LC_MESSAGES/libpq5-12.mo %%NLS%%share/locale/ja/LC_MESSAGES/pg_config-12.mo %%NLS%%share/locale/ja/LC_MESSAGES/pg_dump-12.mo %%NLS%%share/locale/ja/LC_MESSAGES/pgscripts-12.mo %%NLS%%share/locale/ja/LC_MESSAGES/psql-12.mo %%NLS%%share/locale/ko/LC_MESSAGES/ecpg-12.mo +%%NLS%%share/locale/ko/LC_MESSAGES/ecpglib6-12.mo %%NLS%%share/locale/ko/LC_MESSAGES/libpq5-12.mo %%NLS%%share/locale/ko/LC_MESSAGES/pg_config-12.mo -%%NLS%%share/locale/ko/LC_MESSAGES/pg_dump-12.mo -%%NLS%%share/locale/ko/LC_MESSAGES/pgscripts-12.mo -%%NLS%%share/locale/ko/LC_MESSAGES/psql-12.mo -%%NLS%%share/locale/nb/LC_MESSAGES/pg_config-12.mo %%NLS%%share/locale/pl/LC_MESSAGES/ecpg-12.mo -%%NLS%%share/locale/pl/LC_MESSAGES/libpq5-12.mo +%%NLS%%share/locale/pl/LC_MESSAGES/ecpglib6-12.mo %%NLS%%share/locale/pl/LC_MESSAGES/pg_config-12.mo -%%NLS%%share/locale/pl/LC_MESSAGES/pg_dump-12.mo -%%NLS%%share/locale/pl/LC_MESSAGES/pgscripts-12.mo -%%NLS%%share/locale/pl/LC_MESSAGES/psql-12.mo %%NLS%%share/locale/pt_BR/LC_MESSAGES/ecpg-12.mo -%%NLS%%share/locale/pt_BR/LC_MESSAGES/libpq5-12.mo +%%NLS%%share/locale/pt_BR/LC_MESSAGES/ecpglib6-12.mo %%NLS%%share/locale/pt_BR/LC_MESSAGES/pg_config-12.mo -%%NLS%%share/locale/pt_BR/LC_MESSAGES/pg_dump-12.mo -%%NLS%%share/locale/pt_BR/LC_MESSAGES/pgscripts-12.mo -%%NLS%%share/locale/pt_BR/LC_MESSAGES/psql-12.mo %%NLS%%share/locale/ro/LC_MESSAGES/pg_config-12.mo %%NLS%%share/locale/ru/LC_MESSAGES/ecpg-12.mo +%%NLS%%share/locale/ru/LC_MESSAGES/ecpglib6-12.mo %%NLS%%share/locale/ru/LC_MESSAGES/libpq5-12.mo %%NLS%%share/locale/ru/LC_MESSAGES/pg_config-12.mo %%NLS%%share/locale/ru/LC_MESSAGES/pg_dump-12.mo %%NLS%%share/locale/ru/LC_MESSAGES/pgscripts-12.mo %%NLS%%share/locale/ru/LC_MESSAGES/psql-12.mo %%NLS%%share/locale/sv/LC_MESSAGES/ecpg-12.mo +%%NLS%%share/locale/sv/LC_MESSAGES/ecpglib6-12.mo %%NLS%%share/locale/sv/LC_MESSAGES/libpq5-12.mo %%NLS%%share/locale/sv/LC_MESSAGES/pg_config-12.mo %%NLS%%share/locale/sv/LC_MESSAGES/pg_dump-12.mo %%NLS%%share/locale/sv/LC_MESSAGES/pgscripts-12.mo %%NLS%%share/locale/sv/LC_MESSAGES/psql-12.mo -%%NLS%%share/locale/ta/LC_MESSAGES/pg_config-12.mo %%NLS%%share/locale/tr/LC_MESSAGES/ecpg-12.mo +%%NLS%%share/locale/tr/LC_MESSAGES/ecpglib6-12.mo %%NLS%%share/locale/tr/LC_MESSAGES/libpq5-12.mo %%NLS%%share/locale/tr/LC_MESSAGES/pg_config-12.mo %%NLS%%share/locale/tr/LC_MESSAGES/pg_dump-12.mo %%NLS%%share/locale/tr/LC_MESSAGES/pgscripts-12.mo %%NLS%%share/locale/tr/LC_MESSAGES/psql-12.mo %%NLS%%share/locale/uk/LC_MESSAGES/ecpg-12.mo +%%NLS%%share/locale/uk/LC_MESSAGES/ecpglib6-12.mo %%NLS%%share/locale/uk/LC_MESSAGES/libpq5-12.mo %%NLS%%share/locale/uk/LC_MESSAGES/pg_config-12.mo %%NLS%%share/locale/uk/LC_MESSAGES/psql-12.mo %%NLS%%share/locale/vi/LC_MESSAGES/ecpg-12.mo +%%NLS%%share/locale/vi/LC_MESSAGES/ecpglib6-12.mo %%NLS%%share/locale/vi/LC_MESSAGES/pg_config-12.mo %%NLS%%share/locale/zh_CN/LC_MESSAGES/ecpg-12.mo +%%NLS%%share/locale/zh_CN/LC_MESSAGES/ecpglib6-12.mo %%NLS%%share/locale/zh_CN/LC_MESSAGES/libpq5-12.mo %%NLS%%share/locale/zh_CN/LC_MESSAGES/pg_config-12.mo %%NLS%%share/locale/zh_CN/LC_MESSAGES/pg_dump-12.mo %%NLS%%share/locale/zh_CN/LC_MESSAGES/pgscripts-12.mo %%NLS%%share/locale/zh_CN/LC_MESSAGES/psql-12.mo %%NLS%%share/locale/zh_TW/LC_MESSAGES/ecpg-12.mo -%%NLS%%share/locale/zh_TW/LC_MESSAGES/libpq5-12.mo %%NLS%%share/locale/zh_TW/LC_MESSAGES/pg_config-12.mo -%%NLS%%share/locale/zh_TW/LC_MESSAGES/psql-12.mo %%DATADIR%%/pg_service.conf.sample %%DATADIR%%/psqlrc.sample - Modified: head/databases/postgresql12-server/pkg-plist-server ============================================================================== --- head/databases/postgresql12-server/pkg-plist-server Thu Oct 3 13:46:23 2019 (r513664) +++ head/databases/postgresql12-server/pkg-plist-server Thu Oct 3 13:52:44 2019 (r513665) @@ -735,12 +735,17 @@ lib/libpgcommon.a %%DATADIR%%/extension/plpgsql.control %%DATADIR%%/postgres.shdescription %%NLS%%share/locale/cs/LC_MESSAGES/initdb-12.mo +%%NLS%%share/locale/cs/LC_MESSAGES/pg_archivecleanup-12.mo +%%NLS%%share/locale/cs/LC_MESSAGES/pg_basebackup-12.mo +%%NLS%%share/locale/cs/LC_MESSAGES/pg_checksums-12.mo %%NLS%%share/locale/cs/LC_MESSAGES/pg_controldata-12.mo %%NLS%%share/locale/cs/LC_MESSAGES/pg_ctl-12.mo %%NLS%%share/locale/cs/LC_MESSAGES/pg_resetwal-12.mo +%%NLS%%share/locale/cs/LC_MESSAGES/pg_rewind-12.mo %%NLS%%share/locale/cs/LC_MESSAGES/pg_test_fsync-12.mo %%NLS%%share/locale/cs/LC_MESSAGES/pg_test_timing-12.mo %%NLS%%share/locale/cs/LC_MESSAGES/pg_upgrade-12.mo +%%NLS%%share/locale/cs/LC_MESSAGES/pg_waldump-12.mo %%NLS%%share/locale/cs/LC_MESSAGES/plpgsql-12.mo %%NLS%%share/locale/de/LC_MESSAGES/initdb-12.mo %%NLS%%share/locale/de/LC_MESSAGES/pg_archivecleanup-12.mo @@ -772,27 +777,17 @@ lib/libpgcommon.a %%NLS%%share/locale/es/LC_MESSAGES/postgres-12.mo %%NLS%%share/locale/fr/LC_MESSAGES/initdb-12.mo %%NLS%%share/locale/fr/LC_MESSAGES/pg_archivecleanup-12.mo -%%NLS%%share/locale/fr/LC_MESSAGES/pg_basebackup-12.mo %%NLS%%share/locale/fr/LC_MESSAGES/pg_controldata-12.mo %%NLS%%share/locale/fr/LC_MESSAGES/pg_ctl-12.mo -%%NLS%%share/locale/fr/LC_MESSAGES/pg_resetwal-12.mo -%%NLS%%share/locale/fr/LC_MESSAGES/pg_rewind-12.mo %%NLS%%share/locale/fr/LC_MESSAGES/pg_test_fsync-12.mo %%NLS%%share/locale/fr/LC_MESSAGES/pg_test_timing-12.mo %%NLS%%share/locale/fr/LC_MESSAGES/pg_upgrade-12.mo %%NLS%%share/locale/fr/LC_MESSAGES/pg_waldump-12.mo %%NLS%%share/locale/fr/LC_MESSAGES/plpgsql-12.mo %%NLS%%share/locale/fr/LC_MESSAGES/postgres-12.mo -%%NLS%%share/locale/he/LC_MESSAGES/initdb-12.mo -%%NLS%%share/locale/he/LC_MESSAGES/pg_basebackup-12.mo %%NLS%%share/locale/he/LC_MESSAGES/pg_ctl-12.mo -%%NLS%%share/locale/id/LC_MESSAGES/%%PG_USER%%-12.mo -%%NLS%%share/locale/it/LC_MESSAGES/initdb-12.mo -%%NLS%%share/locale/it/LC_MESSAGES/pg_basebackup-12.mo %%NLS%%share/locale/it/LC_MESSAGES/pg_controldata-12.mo %%NLS%%share/locale/it/LC_MESSAGES/pg_ctl-12.mo -%%NLS%%share/locale/it/LC_MESSAGES/pg_resetwal-12.mo -%%NLS%%share/locale/it/LC_MESSAGES/pg_rewind-12.mo %%NLS%%share/locale/it/LC_MESSAGES/plpgsql-12.mo %%NLS%%share/locale/it/LC_MESSAGES/postgres-12.mo %%NLS%%share/locale/ja/LC_MESSAGES/initdb-12.mo @@ -809,42 +804,24 @@ lib/libpgcommon.a %%NLS%%share/locale/ja/LC_MESSAGES/pg_waldump-12.mo %%NLS%%share/locale/ja/LC_MESSAGES/plpgsql-12.mo %%NLS%%share/locale/ja/LC_MESSAGES/postgres-12.mo -%%NLS%%share/locale/ko/LC_MESSAGES/initdb-12.mo -%%NLS%%share/locale/ko/LC_MESSAGES/pg_archivecleanup-12.mo -%%NLS%%share/locale/ko/LC_MESSAGES/pg_basebackup-12.mo %%NLS%%share/locale/ko/LC_MESSAGES/pg_controldata-12.mo %%NLS%%share/locale/ko/LC_MESSAGES/pg_ctl-12.mo -%%NLS%%share/locale/ko/LC_MESSAGES/pg_resetwal-12.mo -%%NLS%%share/locale/ko/LC_MESSAGES/pg_rewind-12.mo %%NLS%%share/locale/ko/LC_MESSAGES/pg_test_fsync-12.mo %%NLS%%share/locale/ko/LC_MESSAGES/pg_test_timing-12.mo %%NLS%%share/locale/ko/LC_MESSAGES/pg_upgrade-12.mo -%%NLS%%share/locale/ko/LC_MESSAGES/pg_waldump-12.mo %%NLS%%share/locale/ko/LC_MESSAGES/plpgsql-12.mo %%NLS%%share/locale/ko/LC_MESSAGES/postgres-12.mo -%%NLS%%share/locale/pl/LC_MESSAGES/initdb-12.mo -%%NLS%%share/locale/pl/LC_MESSAGES/pg_archivecleanup-12.mo -%%NLS%%share/locale/pl/LC_MESSAGES/pg_basebackup-12.mo %%NLS%%share/locale/pl/LC_MESSAGES/pg_controldata-12.mo %%NLS%%share/locale/pl/LC_MESSAGES/pg_ctl-12.mo -%%NLS%%share/locale/pl/LC_MESSAGES/pg_resetwal-12.mo -%%NLS%%share/locale/pl/LC_MESSAGES/pg_rewind-12.mo %%NLS%%share/locale/pl/LC_MESSAGES/pg_test_fsync-12.mo %%NLS%%share/locale/pl/LC_MESSAGES/pg_test_timing-12.mo %%NLS%%share/locale/pl/LC_MESSAGES/plpgsql-12.mo %%NLS%%share/locale/pl/LC_MESSAGES/postgres-12.mo -%%NLS%%share/locale/pt_BR/LC_MESSAGES/%%PG_USER%%-12.mo -%%NLS%%share/locale/pt_BR/LC_MESSAGES/initdb-12.mo -%%NLS%%share/locale/pt_BR/LC_MESSAGES/pg_basebackup-12.mo -%%NLS%%share/locale/pt_BR/LC_MESSAGES/pg_controldata-12.mo -%%NLS%%share/locale/pt_BR/LC_MESSAGES/pg_ctl-12.mo -%%NLS%%share/locale/pt_BR/LC_MESSAGES/pg_resetwal-12.mo -%%NLS%%share/locale/pt_BR/LC_MESSAGES/pg_rewind-12.mo %%NLS%%share/locale/pt_BR/LC_MESSAGES/plpgsql-12.mo -%%NLS%%share/locale/ro/LC_MESSAGES/plpgsql-12.mo %%NLS%%share/locale/ru/LC_MESSAGES/initdb-12.mo %%NLS%%share/locale/ru/LC_MESSAGES/pg_archivecleanup-12.mo %%NLS%%share/locale/ru/LC_MESSAGES/pg_basebackup-12.mo +%%NLS%%share/locale/ru/LC_MESSAGES/pg_checksums-12.mo %%NLS%%share/locale/ru/LC_MESSAGES/pg_controldata-12.mo %%NLS%%share/locale/ru/LC_MESSAGES/pg_ctl-12.mo %%NLS%%share/locale/ru/LC_MESSAGES/pg_resetwal-12.mo @@ -888,13 +865,9 @@ lib/libpgcommon.a %%NLS%%share/locale/uk/LC_MESSAGES/pg_test_fsync-12.mo %%NLS%%share/locale/uk/LC_MESSAGES/pg_test_timing-12.mo %%NLS%%share/locale/uk/LC_MESSAGES/plpgsql-12.mo -%%NLS%%share/locale/vi/LC_MESSAGES/initdb-12.mo -%%NLS%%share/locale/vi/LC_MESSAGES/pg_archivecleanup-12.mo -%%NLS%%share/locale/vi/LC_MESSAGES/pg_basebackup-12.mo %%NLS%%share/locale/vi/LC_MESSAGES/pg_controldata-12.mo %%NLS%%share/locale/vi/LC_MESSAGES/pg_test_fsync-12.mo %%NLS%%share/locale/vi/LC_MESSAGES/pg_test_timing-12.mo -%%NLS%%share/locale/vi/LC_MESSAGES/pg_waldump-12.mo %%NLS%%share/locale/vi/LC_MESSAGES/plpgsql-12.mo %%NLS%%share/locale/zh_CN/LC_MESSAGES/initdb-12.mo %%NLS%%share/locale/zh_CN/LC_MESSAGES/pg_archivecleanup-12.mo @@ -909,7 +882,6 @@ lib/libpgcommon.a %%NLS%%share/locale/zh_CN/LC_MESSAGES/pg_waldump-12.mo %%NLS%%share/locale/zh_CN/LC_MESSAGES/plpgsql-12.mo %%NLS%%share/locale/zh_CN/LC_MESSAGES/postgres-12.mo -%%NLS%%share/locale/zh_TW/LC_MESSAGES/plpgsql-12.mo %%DATADIR%%/snowball_create.sql %%TZDATA%%%%DATADIR%%/timezone/Africa/Abidjan %%TZDATA%%%%DATADIR%%/timezone/Africa/Accra
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201910031352.x93DqiE3022030>