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

4 files changed, 3 insertions, 40 deletions

diff --git a/databases/postgresql93-server/Makefile b/databases/postgresql93-server/Makefile
index b3f5d44c4871..6937f079550b 100644
--- a/databases/postgresql93-server/Makefile
+++ b/databases/postgresql93-server/Makefile
@@ -5,7 +5,7 @@
 # $FreeBSD$
 #
 
-DISTVERSION?=	9.3beta2
+DISTVERSION?=	9.3.0
 PORTREVISION?=	0
 PKGNAMESUFFIX?=	-server
 
diff --git a/databases/postgresql93-server/distinfo b/databases/postgresql93-server/distinfo
index 2fdfaa3462ea..b3859a87d39a 100644
--- a/databases/postgresql93-server/distinfo
+++ b/databases/postgresql93-server/distinfo
@@ -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
diff --git a/databases/postgresql93-server/files/pkg-message-server.in b/databases/postgresql93-server/files/pkg-message-server.in
index 54f397448198..82a4cffc01cd 100644
--- a/databases/postgresql93-server/files/pkg-message-server.in
+++ b/databases/postgresql93-server/files/pkg-message-server.in
@@ -13,19 +13,6 @@ databases nightly. Per default, it perfoms `vacuum analyze'. See the
 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.
diff --git a/databases/postgresql93-server/pkg-plist-server b/databases/postgresql93-server/pkg-plist-server
index 4b735bbef06a..996dfb6084a0 100644
--- a/databases/postgresql93-server/pkg-plist-server
+++ b/databases/postgresql93-server/pkg-plist-server
@@ -94,11 +94,6 @@ share/postgresql/extension/plpgsql.control
 %%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.control
 %%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.control
 %%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