From owner-svn-ports-all@FreeBSD.ORG Mon Sep 9 15:45:44 2013 Return-Path: Delivered-To: svn-ports-all@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTP id ECB91CCC; Mon, 9 Sep 2013 15:45:44 +0000 (UTC) (envelope-from girgen@FreeBSD.org) Received: from svn.freebsd.org (svn.freebsd.org [IPv6:2001:1900:2254:2068::e6a:0]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mx1.freebsd.org (Postfix) with ESMTPS id D72552F7C; Mon, 9 Sep 2013 15:45:44 +0000 (UTC) Received: from svn.freebsd.org ([127.0.1.70]) by svn.freebsd.org (8.14.7/8.14.7) with ESMTP id r89Fji5Q027298; Mon, 9 Sep 2013 15:45:44 GMT (envelope-from girgen@svn.freebsd.org) Received: (from girgen@localhost) by svn.freebsd.org (8.14.7/8.14.5/Submit) id r89Fjics027294; Mon, 9 Sep 2013 15:45:44 GMT (envelope-from girgen@svn.freebsd.org) Message-Id: <201309091545.r89Fjics027294@svn.freebsd.org> From: Palle Girgensohn Date: Mon, 9 Sep 2013 15:45:44 +0000 (UTC) To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r326817 - in head/databases/postgresql93-server: . files X-SVN-Group: ports-head MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-BeenThere: svn-ports-all@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: SVN commit messages for the ports tree List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 09 Sep 2013 15:45:45 -0000 Author: girgen Date: Mon Sep 9 15:45:43 2013 New Revision: 326817 URL: http://svnweb.freebsd.org/changeset/ports/326817 Log: Update to postgreSQL 9.3.0 Major enhancements in PostgreSQL 9.3 include: - Add materialized views - Make simple views auto-updatable - Add many features for the JSON data type, including operators and functions to extract elements from JSON values - Implement SQL-standard LATERAL option for FROM-clause subqueries and function calls - Allow foreign data wrappers to support writes (inserts/updates/deletes) on foreign tables - Add a Postgres foreign data wrapper to allow access to other Postgres servers - Add support for event triggers - Add optional ability to checksum data pages and report corruption - Prevent non-key-field row updates from blocking foreign key checks - Greatly reduce System V shared memory requirements URL: http://www.postgresql.org/docs/9.3/static/release-9-3.html Modified: head/databases/postgresql93-server/Makefile head/databases/postgresql93-server/distinfo head/databases/postgresql93-server/files/pkg-message-server.in head/databases/postgresql93-server/pkg-plist-server Modified: head/databases/postgresql93-server/Makefile ============================================================================== --- head/databases/postgresql93-server/Makefile Mon Sep 9 15:14:39 2013 (r326816) +++ head/databases/postgresql93-server/Makefile Mon Sep 9 15:45:43 2013 (r326817) @@ -5,7 +5,7 @@ # $FreeBSD$ # -DISTVERSION?= 9.3beta2 +DISTVERSION?= 9.3.0 PORTREVISION?= 0 PKGNAMESUFFIX?= -server Modified: head/databases/postgresql93-server/distinfo ============================================================================== --- head/databases/postgresql93-server/distinfo Mon Sep 9 15:14:39 2013 (r326816) +++ head/databases/postgresql93-server/distinfo Mon Sep 9 15:45:43 2013 (r326817) @@ -1,4 +1,4 @@ -SHA256 (postgresql/postgresql-9.3beta2.tar.bz2) = 67b4f1e8be622ab2f32b2a7823b3185052c93eae11c961214d87be76978f35ae -SIZE (postgresql/postgresql-9.3beta2.tar.bz2) = 17006778 +SHA256 (postgresql/postgresql-9.3.0.tar.bz2) = 784e5db7d8fd69b08ddb125c4452211e04b089516359a5cf72d292cade7c728e +SIZE (postgresql/postgresql-9.3.0.tar.bz2) = 16871327 SHA256 (postgresql/pg-910-icu-2012-12-19.diff.gz) = 61ef9c9b55b63b63b0fb108dfef086f92e9c43b5bd934fab9639b31f91193611 SIZE (postgresql/pg-910-icu-2012-12-19.diff.gz) = 4386 Modified: head/databases/postgresql93-server/files/pkg-message-server.in ============================================================================== --- head/databases/postgresql93-server/files/pkg-message-server.in Mon Sep 9 15:14:39 2013 (r326816) +++ head/databases/postgresql93-server/files/pkg-message-server.in Mon Sep 9 15:45:43 2013 (r326817) @@ -13,19 +13,6 @@ databases nightly. Per default, it perfo script for instructions. For autovacuum settings, please review ~pgsql/data/postgresql.conf. -To allow many simultaneous connections to your PostgreSQL server, you -should raise the SystemV shared memory limits in your kernel. Here are -example values for allowing up to 180 clients (configurations in -postgresql.conf also needed, of course): - options SYSVSHM - options SYSVSEM - options SYSVMSG - options SHMMAXPGS=65536 - options SEMMNI=40 - options SEMMNS=240 - options SEMUME=40 - options SEMMNU=120 - If you plan to access your PostgreSQL server using ODBC, please consider running the SQL script %%PREFIX%%/share/postgresql/odbc.sql to get the functions required for ODBC compliance. Modified: head/databases/postgresql93-server/pkg-plist-server ============================================================================== --- head/databases/postgresql93-server/pkg-plist-server Mon Sep 9 15:14:39 2013 (r326816) +++ head/databases/postgresql93-server/pkg-plist-server Mon Sep 9 15:45:43 2013 (r326817) @@ -94,11 +94,6 @@ share/postgresql/extension/plpgsql.contr %%GETTEXT%%share/locale/ja/LC_MESSAGES/pg_resetxlog-9.3.mo %%GETTEXT%%share/locale/ja/LC_MESSAGES/plpgsql-9.3.mo %%GETTEXT%%share/locale/ja/LC_MESSAGES/postgres-9.3.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/initdb-9.3.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_controldata-9.3.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_ctl-9.3.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_resetxlog-9.3.mo -%%GETTEXT%%share/locale/ko/LC_MESSAGES/plpgsql-9.3.mo %%GETTEXT%%share/locale/pl/LC_MESSAGES/initdb-9.3.mo %%GETTEXT%%share/locale/pl/LC_MESSAGES/pg_basebackup-9.3.mo %%GETTEXT%%share/locale/pl/LC_MESSAGES/pg_controldata-9.3.mo @@ -113,9 +108,6 @@ share/postgresql/extension/plpgsql.contr %%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_resetxlog-9.3.mo %%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/plpgsql-9.3.mo %%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/postgres-9.3.mo -%%GETTEXT%%share/locale/ro/LC_MESSAGES/initdb-9.3.mo -%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_controldata-9.3.mo -%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_resetxlog-9.3.mo %%GETTEXT%%share/locale/ro/LC_MESSAGES/plpgsql-9.3.mo %%GETTEXT%%share/locale/ru/LC_MESSAGES/initdb-9.3.mo %%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_basebackup-9.3.mo @@ -124,30 +116,14 @@ share/postgresql/extension/plpgsql.contr %%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_resetxlog-9.3.mo %%GETTEXT%%share/locale/ru/LC_MESSAGES/plpgsql-9.3.mo %%GETTEXT%%share/locale/ru/LC_MESSAGES/postgres-9.3.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/initdb-9.3.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_controldata-9.3.mo %%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_ctl-9.3.mo -%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_resetxlog-9.3.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/initdb-9.3.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_controldata-9.3.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_ctl-9.3.mo -%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_resetxlog-9.3.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/initdb-9.3.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_controldata-9.3.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_ctl-9.3.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_resetxlog-9.3.mo -%%GETTEXT%%share/locale/tr/LC_MESSAGES/postgres-9.3.mo %%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/initdb-9.3.mo -%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_basebackup-9.3.mo %%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_controldata-9.3.mo %%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_ctl-9.3.mo %%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_resetxlog-9.3.mo %%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/plpgsql-9.3.mo %%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/postgres-9.3.mo -%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/initdb-9.3.mo -%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/pg_controldata-9.3.mo %%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/pg_ctl-9.3.mo -%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/pg_resetxlog-9.3.mo %%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/plpgsql-9.3.mo %%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/postgres-9.3.mo share/postgresql/postgres.shdescription