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

6 files changed, 943 insertions, 0 deletions

diff --git a/databases/postgresql93-server/DEINSTALL b/databases/postgresql93-server/DEINSTALL
new file mode 100644
index 00000000000..948bfd6b57c
--- /dev/null
+++ b/databases/postgresql93-server/DEINSTALL
@@ -0,0 +1,20 @@
+# $NetBSD: DEINSTALL,v 1.1 2013/09/10 15:32:33 adam Exp $
+
+case ${STAGE} in
+DEINSTALL)
+	${CAT} << EOF
+===========================================================================
+
+If you intend to upgrade your PostgreSQL installation, you may need to
+perform a dump-and-restore to move your current databases into the newer
+PostgreSQL installation.  Please dump your databases *prior* to installing
+the new PostgreSQL.
+
+Please see the Backup and Restore section of the PostgreSQL Administrator's
+Guide (databases/postgresql-docs) for complete information on how to
+perform the databases dump.
+
+===========================================================================
+EOF
+	;;
+esac
diff --git a/databases/postgresql93-server/DESCR b/databases/postgresql93-server/DESCR
new file mode 100644
index 00000000000..68bb2b05748
--- /dev/null
+++ b/databases/postgresql93-server/DESCR
@@ -0,0 +1,9 @@
+PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS),
+derived from the Berkeley Postgres database management system.  While
+PostgreSQL retains the powerful object-relational data model, rich data types
+and easy extensibility of Postgres, it replaces the PostQuel query language
+with an extended subset of SQL.
+
+PostgreSQL is free and the complete source is available.
+
+This package contains the database server programs.
diff --git a/databases/postgresql93-server/MESSAGE b/databases/postgresql93-server/MESSAGE
new file mode 100644
index 00000000000..2dc73955ebf
--- /dev/null
+++ b/databases/postgresql93-server/MESSAGE
@@ -0,0 +1,18 @@
+===========================================================================
+$NetBSD: MESSAGE,v 1.1 2013/09/10 15:32:33 adam Exp $
+
+To enable this package, put the following into your /etc/rc.conf:
+
+	pgsql=YES
+	pgsql_flags="-l"     # enables SSL connections (TCP/IP and
+			     # ~pgsql/data/server.crt required)
+
+and ensure that
+
+	${RCD_SCRIPTS_DIR}/pgsql start
+
+is run at the appropriate time.
+
+Note: PostgreSQL accepts TCP/IP connections on localhost address by default.
+
+===========================================================================
diff --git a/databases/postgresql93-server/Makefile b/databases/postgresql93-server/Makefile
new file mode 100644
index 00000000000..8b863afc3e7
--- /dev/null
+++ b/databases/postgresql93-server/Makefile
@@ -0,0 +1,77 @@
+# $NetBSD: Makefile,v 1.1 2013/09/10 15:32:33 adam Exp $
+
+PKGNAME=	${DISTNAME:C/-/93-server-/}
+COMMENT=	PostgreSQL database server programs
+
+# mips has no TAS implementation
+NOT_FOR_PLATFORM=	*-*-mips
+
+.include "../../databases/postgresql93/Makefile.common"
+
+CONFIGURE_ARGS+=	--with-openssl
+
+INSTALL_DIRS=	src/backend
+INSTALL_DIRS+=	src/backend/replication/libpqwalreceiver
+INSTALL_DIRS+=	src/backend/utils/mb/conversion_procs
+INSTALL_DIRS+=	src/backend/snowball
+INSTALL_DIRS+=	src/timezone
+INSTALL_DIRS+=	src/pl
+BUILD_DIRS=	src/port
+BUILD_DIRS+=	${INSTALL_DIRS}
+
+LIBS.SunOS+=	-lintl
+
+# PostgreSQL has loadable server-side language modules.
+#
+# Explicitly set DLOPEN_REQUIRE_PTHREADS to "no" on NetBSD as NetBSD-2.x
+# had problems with mixing dlopen() and pthreads, which blows up in
+# PostgreSQL's backend (pkg/28729).  This works on older and newer
+# versions of NetBSD as well since they don't have the bad interaction
+# between dlopen() and pthreads.
+.if ${OPSYS} == "NetBSD"
+DLOPEN_REQUIRE_PTHREADS=	no
+.endif
+.include "../../mk/dlopen.buildlink3.mk"
+
+# If we're using libltdl to provide "dlopen" functionality, then add the
+# dependency and make sure that we link against -lltdl.
+.if !empty(USE_LIBLTDL:M[yY][eE][sS])
+DL_LIBS+=	-lltdl
+.  include "../../devel/libltdl/buildlink3.mk"
+.endif
+
+# PGUSER	username of the database administrator
+# PGGROUP	group of the database administrator
+# PGHOME	home directory of the database administrator and location of
+#		the databases
+PGUSER?=		pgsql
+PGGROUP?=		pgsql
+PGHOME?=		${PREFIX}/${PGUSER}
+FILES_SUBST+=		PGUSER=${PGUSER}
+FILES_SUBST+=		PGGROUP=${PGGROUP}
+FILES_SUBST+=		PGHOME=${PGHOME}
+BUILD_DEFS+=		PGHOME
+
+ALL_ENV+=		INSTALLED_LIBPQ=yes
+
+PKG_GROUPS_VARS+=	PGGROUP
+PKG_USERS_VARS+=	PGUSER
+
+PKG_GROUPS=		${PGGROUP}
+PKG_USERS=		${PGUSER}:${PGGROUP}
+PKG_GECOS.${PGUSER}=	PostgreSQL database administrator
+PKG_HOME.${PGUSER}=	${PGHOME}
+
+RCD_SCRIPTS=		pgsql
+
+.include "../../databases/postgresql93-client/buildlink3.mk"
+.include "../../security/openssl/buildlink3.mk"
+
+# Avoid conflict between "${SSLBASE}/include/openssl/des.h" and
+# "/usr/include/crypt.h" -- we want the definitions in the former.
+post-wrapper:
+.if ${OPSYS} == "SunOS"
+	touch ${BUILDLINK_DIR}/include/crypt.h
+.endif
+
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql93-server/PLIST b/databases/postgresql93-server/PLIST
new file mode 100644
index 00000000000..22e98382ac5
--- /dev/null
+++ b/databases/postgresql93-server/PLIST
@@ -0,0 +1,689 @@
+@comment $NetBSD: PLIST,v 1.1 2013/09/10 15:32:33 adam Exp $
+bin/postgres
+bin/postmaster
+include/postgresql/server/plpgsql.h
+lib/postgresql/ascii_and_mic.so
+lib/postgresql/cyrillic_and_mic.so
+lib/postgresql/dict_snowball.so
+lib/postgresql/euc2004_sjis2004.so
+lib/postgresql/euc_cn_and_mic.so
+lib/postgresql/euc_jp_and_sjis.so
+lib/postgresql/euc_kr_and_mic.so
+lib/postgresql/euc_tw_and_big5.so
+lib/postgresql/latin2_and_win1250.so
+lib/postgresql/latin_and_mic.so
+lib/postgresql/libpqwalreceiver.so
+lib/postgresql/plpgsql.so
+lib/postgresql/utf8_and_ascii.so
+lib/postgresql/utf8_and_big5.so
+lib/postgresql/utf8_and_cyrillic.so
+lib/postgresql/utf8_and_euc2004.so
+lib/postgresql/utf8_and_euc_cn.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_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_sjis.so
+lib/postgresql/utf8_and_sjis2004.so
+lib/postgresql/utf8_and_uhc.so
+lib/postgresql/utf8_and_win.so
+share/examples/rc.d/pgsql
+share/locale/cs/LC_MESSAGES/plpgsql-9.3.mo
+share/locale/de/LC_MESSAGES/plpgsql-9.3.mo
+share/locale/de/LC_MESSAGES/postgres-9.3.mo
+share/locale/es/LC_MESSAGES/plpgsql-9.3.mo
+share/locale/es/LC_MESSAGES/postgres-9.3.mo
+share/locale/fr/LC_MESSAGES/plpgsql-9.3.mo
+share/locale/fr/LC_MESSAGES/postgres-9.3.mo
+share/locale/it/LC_MESSAGES/plpgsql-9.3.mo
+share/locale/it/LC_MESSAGES/postgres-9.3.mo
+share/locale/ja/LC_MESSAGES/plpgsql-9.3.mo
+share/locale/ja/LC_MESSAGES/postgres-9.3.mo
+share/locale/pl/LC_MESSAGES/plpgsql-9.3.mo
+share/locale/pl/LC_MESSAGES/postgres-9.3.mo
+share/locale/pt_BR/LC_MESSAGES/plpgsql-9.3.mo
+share/locale/pt_BR/LC_MESSAGES/postgres-9.3.mo
+share/locale/ro/LC_MESSAGES/plpgsql-9.3.mo
+share/locale/ru/LC_MESSAGES/plpgsql-9.3.mo
+share/locale/ru/LC_MESSAGES/postgres-9.3.mo
+share/locale/zh_CN/LC_MESSAGES/plpgsql-9.3.mo
+share/locale/zh_CN/LC_MESSAGES/postgres-9.3.mo
+share/locale/zh_TW/LC_MESSAGES/plpgsql-9.3.mo
+share/locale/zh_TW/LC_MESSAGES/postgres-9.3.mo
+share/postgresql/conversion_create.sql
+share/postgresql/extension/plpgsql--1.0.sql
+share/postgresql/extension/plpgsql--unpackaged--1.0.sql
+share/postgresql/extension/plpgsql.control
+share/postgresql/information_schema.sql
+share/postgresql/pg_hba.conf.sample
+share/postgresql/pg_ident.conf.sample
+share/postgresql/postgres.bki
+share/postgresql/postgres.description
+share/postgresql/postgres.shdescription
+share/postgresql/postgresql.conf.sample
+share/postgresql/recovery.conf.sample
+share/postgresql/snowball_create.sql
+share/postgresql/sql_features.txt
+share/postgresql/system_views.sql
+share/postgresql/timezone/Africa/Abidjan
+share/postgresql/timezone/Africa/Accra
+share/postgresql/timezone/Africa/Addis_Ababa
+share/postgresql/timezone/Africa/Algiers
+share/postgresql/timezone/Africa/Asmara
+share/postgresql/timezone/Africa/Asmera
+share/postgresql/timezone/Africa/Bamako
+share/postgresql/timezone/Africa/Bangui
+share/postgresql/timezone/Africa/Banjul
+share/postgresql/timezone/Africa/Bissau
+share/postgresql/timezone/Africa/Blantyre
+share/postgresql/timezone/Africa/Brazzaville
+share/postgresql/timezone/Africa/Bujumbura
+share/postgresql/timezone/Africa/Cairo
+share/postgresql/timezone/Africa/Casablanca
+share/postgresql/timezone/Africa/Ceuta
+share/postgresql/timezone/Africa/Conakry
+share/postgresql/timezone/Africa/Dakar
+share/postgresql/timezone/Africa/Dar_es_Salaam
+share/postgresql/timezone/Africa/Djibouti
+share/postgresql/timezone/Africa/Douala
+share/postgresql/timezone/Africa/El_Aaiun
+share/postgresql/timezone/Africa/Freetown
+share/postgresql/timezone/Africa/Gaborone
+share/postgresql/timezone/Africa/Harare
+share/postgresql/timezone/Africa/Johannesburg
+share/postgresql/timezone/Africa/Juba
+share/postgresql/timezone/Africa/Kampala
+share/postgresql/timezone/Africa/Khartoum
+share/postgresql/timezone/Africa/Kigali
+share/postgresql/timezone/Africa/Kinshasa
+share/postgresql/timezone/Africa/Lagos
+share/postgresql/timezone/Africa/Libreville
+share/postgresql/timezone/Africa/Lome
+share/postgresql/timezone/Africa/Luanda
+share/postgresql/timezone/Africa/Lubumbashi
+share/postgresql/timezone/Africa/Lusaka
+share/postgresql/timezone/Africa/Malabo
+share/postgresql/timezone/Africa/Maputo
+share/postgresql/timezone/Africa/Maseru
+share/postgresql/timezone/Africa/Mbabane
+share/postgresql/timezone/Africa/Mogadishu
+share/postgresql/timezone/Africa/Monrovia
+share/postgresql/timezone/Africa/Nairobi
+share/postgresql/timezone/Africa/Ndjamena
+share/postgresql/timezone/Africa/Niamey
+share/postgresql/timezone/Africa/Nouakchott
+share/postgresql/timezone/Africa/Ouagadougou
+share/postgresql/timezone/Africa/Porto-Novo
+share/postgresql/timezone/Africa/Sao_Tome
+share/postgresql/timezone/Africa/Timbuktu
+share/postgresql/timezone/Africa/Tripoli
+share/postgresql/timezone/Africa/Tunis
+share/postgresql/timezone/Africa/Windhoek
+share/postgresql/timezone/America/Adak
+share/postgresql/timezone/America/Anchorage
+share/postgresql/timezone/America/Anguilla
+share/postgresql/timezone/America/Antigua
+share/postgresql/timezone/America/Araguaina
+share/postgresql/timezone/America/Argentina/Buenos_Aires
+share/postgresql/timezone/America/Argentina/Catamarca
+share/postgresql/timezone/America/Argentina/ComodRivadavia
+share/postgresql/timezone/America/Argentina/Cordoba
+share/postgresql/timezone/America/Argentina/Jujuy
+share/postgresql/timezone/America/Argentina/La_Rioja
+share/postgresql/timezone/America/Argentina/Mendoza
+share/postgresql/timezone/America/Argentina/Rio_Gallegos
+share/postgresql/timezone/America/Argentina/Salta
+share/postgresql/timezone/America/Argentina/San_Juan
+share/postgresql/timezone/America/Argentina/San_Luis
+share/postgresql/timezone/America/Argentina/Tucuman
+share/postgresql/timezone/America/Argentina/Ushuaia
+share/postgresql/timezone/America/Aruba
+share/postgresql/timezone/America/Asuncion
+share/postgresql/timezone/America/Atikokan
+share/postgresql/timezone/America/Atka
+share/postgresql/timezone/America/Bahia
+share/postgresql/timezone/America/Bahia_Banderas
+share/postgresql/timezone/America/Barbados
+share/postgresql/timezone/America/Belem
+share/postgresql/timezone/America/Belize
+share/postgresql/timezone/America/Blanc-Sablon
+share/postgresql/timezone/America/Boa_Vista
+share/postgresql/timezone/America/Bogota
+share/postgresql/timezone/America/Boise
+share/postgresql/timezone/America/Buenos_Aires
+share/postgresql/timezone/America/Cambridge_Bay
+share/postgresql/timezone/America/Campo_Grande
+share/postgresql/timezone/America/Cancun
+share/postgresql/timezone/America/Caracas
+share/postgresql/timezone/America/Catamarca
+share/postgresql/timezone/America/Cayenne
+share/postgresql/timezone/America/Cayman
+share/postgresql/timezone/America/Chicago
+share/postgresql/timezone/America/Chihuahua
+share/postgresql/timezone/America/Coral_Harbour
+share/postgresql/timezone/America/Cordoba
+share/postgresql/timezone/America/Costa_Rica
+share/postgresql/timezone/America/Creston
+share/postgresql/timezone/America/Cuiaba
+share/postgresql/timezone/America/Curacao
+share/postgresql/timezone/America/Danmarkshavn
+share/postgresql/timezone/America/Dawson
+share/postgresql/timezone/America/Dawson_Creek
+share/postgresql/timezone/America/Denver
+share/postgresql/timezone/America/Detroit
+share/postgresql/timezone/America/Dominica
+share/postgresql/timezone/America/Edmonton
+share/postgresql/timezone/America/Eirunepe
+share/postgresql/timezone/America/El_Salvador
+share/postgresql/timezone/America/Ensenada
+share/postgresql/timezone/America/Fort_Wayne
+share/postgresql/timezone/America/Fortaleza
+share/postgresql/timezone/America/Glace_Bay
+share/postgresql/timezone/America/Godthab
+share/postgresql/timezone/America/Goose_Bay
+share/postgresql/timezone/America/Grand_Turk
+share/postgresql/timezone/America/Grenada
+share/postgresql/timezone/America/Guadeloupe
+share/postgresql/timezone/America/Guatemala
+share/postgresql/timezone/America/Guayaquil
+share/postgresql/timezone/America/Guyana
+share/postgresql/timezone/America/Halifax
+share/postgresql/timezone/America/Havana
+share/postgresql/timezone/America/Hermosillo
+share/postgresql/timezone/America/Indiana/Indianapolis
+share/postgresql/timezone/America/Indiana/Knox
+share/postgresql/timezone/America/Indiana/Marengo
+share/postgresql/timezone/America/Indiana/Petersburg
+share/postgresql/timezone/America/Indiana/Tell_City
+share/postgresql/timezone/America/Indiana/Vevay
+share/postgresql/timezone/America/Indiana/Vincennes
+share/postgresql/timezone/America/Indiana/Winamac
+share/postgresql/timezone/America/Indianapolis
+share/postgresql/timezone/America/Inuvik
+share/postgresql/timezone/America/Iqaluit
+share/postgresql/timezone/America/Jamaica
+share/postgresql/timezone/America/Jujuy
+share/postgresql/timezone/America/Juneau
+share/postgresql/timezone/America/Kentucky/Louisville
+share/postgresql/timezone/America/Kentucky/Monticello
+share/postgresql/timezone/America/Knox_IN
+share/postgresql/timezone/America/Kralendijk
+share/postgresql/timezone/America/La_Paz
+share/postgresql/timezone/America/Lima
+share/postgresql/timezone/America/Los_Angeles
+share/postgresql/timezone/America/Louisville
+share/postgresql/timezone/America/Lower_Princes
+share/postgresql/timezone/America/Maceio
+share/postgresql/timezone/America/Managua
+share/postgresql/timezone/America/Manaus
+share/postgresql/timezone/America/Marigot
+share/postgresql/timezone/America/Martinique
+share/postgresql/timezone/America/Matamoros
+share/postgresql/timezone/America/Mazatlan
+share/postgresql/timezone/America/Mendoza
+share/postgresql/timezone/America/Menominee
+share/postgresql/timezone/America/Merida
+share/postgresql/timezone/America/Metlakatla
+share/postgresql/timezone/America/Mexico_City
+share/postgresql/timezone/America/Miquelon
+share/postgresql/timezone/America/Moncton
+share/postgresql/timezone/America/Monterrey
+share/postgresql/timezone/America/Montevideo
+share/postgresql/timezone/America/Montreal
+share/postgresql/timezone/America/Montserrat
+share/postgresql/timezone/America/Nassau
+share/postgresql/timezone/America/New_York
+share/postgresql/timezone/America/Nipigon
+share/postgresql/timezone/America/Nome
+share/postgresql/timezone/America/Noronha
+share/postgresql/timezone/America/North_Dakota/Beulah
+share/postgresql/timezone/America/North_Dakota/Center
+share/postgresql/timezone/America/North_Dakota/New_Salem
+share/postgresql/timezone/America/Ojinaga
+share/postgresql/timezone/America/Panama
+share/postgresql/timezone/America/Pangnirtung
+share/postgresql/timezone/America/Paramaribo
+share/postgresql/timezone/America/Phoenix
+share/postgresql/timezone/America/Port-au-Prince
+share/postgresql/timezone/America/Port_of_Spain
+share/postgresql/timezone/America/Porto_Acre
+share/postgresql/timezone/America/Porto_Velho
+share/postgresql/timezone/America/Puerto_Rico
+share/postgresql/timezone/America/Rainy_River
+share/postgresql/timezone/America/Rankin_Inlet
+share/postgresql/timezone/America/Recife
+share/postgresql/timezone/America/Regina
+share/postgresql/timezone/America/Resolute
+share/postgresql/timezone/America/Rio_Branco
+share/postgresql/timezone/America/Rosario
+share/postgresql/timezone/America/Santa_Isabel
+share/postgresql/timezone/America/Santarem
+share/postgresql/timezone/America/Santiago
+share/postgresql/timezone/America/Santo_Domingo
+share/postgresql/timezone/America/Sao_Paulo
+share/postgresql/timezone/America/Scoresbysund
+share/postgresql/timezone/America/Shiprock
+share/postgresql/timezone/America/Sitka
+share/postgresql/timezone/America/St_Barthelemy
+share/postgresql/timezone/America/St_Johns
+share/postgresql/timezone/America/St_Kitts
+share/postgresql/timezone/America/St_Lucia
+share/postgresql/timezone/America/St_Thomas
+share/postgresql/timezone/America/St_Vincent
+share/postgresql/timezone/America/Swift_Current
+share/postgresql/timezone/America/Tegucigalpa
+share/postgresql/timezone/America/Thule
+share/postgresql/timezone/America/Thunder_Bay
+share/postgresql/timezone/America/Tijuana
+share/postgresql/timezone/America/Toronto
+share/postgresql/timezone/America/Tortola
+share/postgresql/timezone/America/Vancouver
+share/postgresql/timezone/America/Virgin
+share/postgresql/timezone/America/Whitehorse
+share/postgresql/timezone/America/Winnipeg
+share/postgresql/timezone/America/Yakutat
+share/postgresql/timezone/America/Yellowknife
+share/postgresql/timezone/Antarctica/Casey
+share/postgresql/timezone/Antarctica/Davis
+share/postgresql/timezone/Antarctica/DumontDUrville
+share/postgresql/timezone/Antarctica/Macquarie
+share/postgresql/timezone/Antarctica/Mawson
+share/postgresql/timezone/Antarctica/McMurdo
+share/postgresql/timezone/Antarctica/Palmer
+share/postgresql/timezone/Antarctica/Rothera
+share/postgresql/timezone/Antarctica/South_Pole
+share/postgresql/timezone/Antarctica/Syowa
+share/postgresql/timezone/Antarctica/Vostok
+share/postgresql/timezone/Arctic/Longyearbyen
+share/postgresql/timezone/Asia/Aden
+share/postgresql/timezone/Asia/Almaty
+share/postgresql/timezone/Asia/Amman
+share/postgresql/timezone/Asia/Anadyr
+share/postgresql/timezone/Asia/Aqtau
+share/postgresql/timezone/Asia/Aqtobe
+share/postgresql/timezone/Asia/Ashgabat
+share/postgresql/timezone/Asia/Ashkhabad
+share/postgresql/timezone/Asia/Baghdad
+share/postgresql/timezone/Asia/Bahrain
+share/postgresql/timezone/Asia/Baku
+share/postgresql/timezone/Asia/Bangkok
+share/postgresql/timezone/Asia/Beirut
+share/postgresql/timezone/Asia/Bishkek
+share/postgresql/timezone/Asia/Brunei
+share/postgresql/timezone/Asia/Calcutta
+share/postgresql/timezone/Asia/Choibalsan
+share/postgresql/timezone/Asia/Chongqing
+share/postgresql/timezone/Asia/Chungking
+share/postgresql/timezone/Asia/Colombo
+share/postgresql/timezone/Asia/Dacca
+share/postgresql/timezone/Asia/Damascus
+share/postgresql/timezone/Asia/Dhaka
+share/postgresql/timezone/Asia/Dili
+share/postgresql/timezone/Asia/Dubai
+share/postgresql/timezone/Asia/Dushanbe
+share/postgresql/timezone/Asia/Gaza
+share/postgresql/timezone/Asia/Harbin
+share/postgresql/timezone/Asia/Hebron
+share/postgresql/timezone/Asia/Ho_Chi_Minh
+share/postgresql/timezone/Asia/Hong_Kong
+share/postgresql/timezone/Asia/Hovd
+share/postgresql/timezone/Asia/Irkutsk
+share/postgresql/timezone/Asia/Istanbul
+share/postgresql/timezone/Asia/Jakarta
+share/postgresql/timezone/Asia/Jayapura
+share/postgresql/timezone/Asia/Jerusalem
+share/postgresql/timezone/Asia/Kabul
+share/postgresql/timezone/Asia/Kamchatka
+share/postgresql/timezone/Asia/Karachi
+share/postgresql/timezone/Asia/Kashgar
+share/postgresql/timezone/Asia/Kathmandu
+share/postgresql/timezone/Asia/Katmandu
+share/postgresql/timezone/Asia/Khandyga
+share/postgresql/timezone/Asia/Kolkata
+share/postgresql/timezone/Asia/Krasnoyarsk
+share/postgresql/timezone/Asia/Kuala_Lumpur
+share/postgresql/timezone/Asia/Kuching
+share/postgresql/timezone/Asia/Kuwait
+share/postgresql/timezone/Asia/Macao
+share/postgresql/timezone/Asia/Macau
+share/postgresql/timezone/Asia/Magadan
+share/postgresql/timezone/Asia/Makassar
+share/postgresql/timezone/Asia/Manila
+share/postgresql/timezone/Asia/Muscat
+share/postgresql/timezone/Asia/Nicosia
+share/postgresql/timezone/Asia/Novokuznetsk
+share/postgresql/timezone/Asia/Novosibirsk
+share/postgresql/timezone/Asia/Omsk
+share/postgresql/timezone/Asia/Oral
+share/postgresql/timezone/Asia/Phnom_Penh
+share/postgresql/timezone/Asia/Pontianak
+share/postgresql/timezone/Asia/Pyongyang
+share/postgresql/timezone/Asia/Qatar
+share/postgresql/timezone/Asia/Qyzylorda
+share/postgresql/timezone/Asia/Rangoon
+share/postgresql/timezone/Asia/Riyadh
+share/postgresql/timezone/Asia/Riyadh87
+share/postgresql/timezone/Asia/Riyadh88
+share/postgresql/timezone/Asia/Riyadh89
+share/postgresql/timezone/Asia/Saigon
+share/postgresql/timezone/Asia/Sakhalin
+share/postgresql/timezone/Asia/Samarkand
+share/postgresql/timezone/Asia/Seoul
+share/postgresql/timezone/Asia/Shanghai
+share/postgresql/timezone/Asia/Singapore
+share/postgresql/timezone/Asia/Taipei
+share/postgresql/timezone/Asia/Tashkent
+share/postgresql/timezone/Asia/Tbilisi
+share/postgresql/timezone/Asia/Tehran
+share/postgresql/timezone/Asia/Tel_Aviv
+share/postgresql/timezone/Asia/Thimbu
+share/postgresql/timezone/Asia/Thimphu
+share/postgresql/timezone/Asia/Tokyo
+share/postgresql/timezone/Asia/Ujung_Pandang
+share/postgresql/timezone/Asia/Ulaanbaatar
+share/postgresql/timezone/Asia/Ulan_Bator
+share/postgresql/timezone/Asia/Urumqi
+share/postgresql/timezone/Asia/Ust-Nera
+share/postgresql/timezone/Asia/Vientiane
+share/postgresql/timezone/Asia/Vladivostok
+share/postgresql/timezone/Asia/Yakutsk
+share/postgresql/timezone/Asia/Yekaterinburg
+share/postgresql/timezone/Asia/Yerevan
+share/postgresql/timezone/Atlantic/Azores
+share/postgresql/timezone/Atlantic/Bermuda
+share/postgresql/timezone/Atlantic/Canary
+share/postgresql/timezone/Atlantic/Cape_Verde
+share/postgresql/timezone/Atlantic/Faeroe
+share/postgresql/timezone/Atlantic/Faroe
+share/postgresql/timezone/Atlantic/Jan_Mayen
+share/postgresql/timezone/Atlantic/Madeira
+share/postgresql/timezone/Atlantic/Reykjavik
+share/postgresql/timezone/Atlantic/South_Georgia
+share/postgresql/timezone/Atlantic/St_Helena
+share/postgresql/timezone/Atlantic/Stanley
+share/postgresql/timezone/Australia/ACT
+share/postgresql/timezone/Australia/Adelaide
+share/postgresql/timezone/Australia/Brisbane
+share/postgresql/timezone/Australia/Broken_Hill
+share/postgresql/timezone/Australia/Canberra
+share/postgresql/timezone/Australia/Currie
+share/postgresql/timezone/Australia/Darwin
+share/postgresql/timezone/Australia/Eucla
+share/postgresql/timezone/Australia/Hobart
+share/postgresql/timezone/Australia/LHI
+share/postgresql/timezone/Australia/Lindeman
+share/postgresql/timezone/Australia/Lord_Howe
+share/postgresql/timezone/Australia/Melbourne
+share/postgresql/timezone/Australia/NSW
+share/postgresql/timezone/Australia/North
+share/postgresql/timezone/Australia/Perth
+share/postgresql/timezone/Australia/Queensland
+share/postgresql/timezone/Australia/South
+share/postgresql/timezone/Australia/Sydney
+share/postgresql/timezone/Australia/Tasmania
+share/postgresql/timezone/Australia/Victoria
+share/postgresql/timezone/Australia/West
+share/postgresql/timezone/Australia/Yancowinna
+share/postgresql/timezone/Brazil/Acre
+share/postgresql/timezone/Brazil/DeNoronha
+share/postgresql/timezone/Brazil/East
+share/postgresql/timezone/Brazil/West
+share/postgresql/timezone/CET
+share/postgresql/timezone/CST6CDT
+share/postgresql/timezone/Canada/Atlantic
+share/postgresql/timezone/Canada/Central
+share/postgresql/timezone/Canada/East-Saskatchewan
+share/postgresql/timezone/Canada/Eastern
+share/postgresql/timezone/Canada/Mountain
+share/postgresql/timezone/Canada/Newfoundland
+share/postgresql/timezone/Canada/Pacific
+share/postgresql/timezone/Canada/Saskatchewan
+share/postgresql/timezone/Canada/Yukon
+share/postgresql/timezone/Chile/Continental
+share/postgresql/timezone/Chile/EasterIsland
+share/postgresql/timezone/Cuba
+share/postgresql/timezone/EET
+share/postgresql/timezone/EST
+share/postgresql/timezone/EST5EDT
+share/postgresql/timezone/Egypt
+share/postgresql/timezone/Eire
+share/postgresql/timezone/Etc/GMT
+share/postgresql/timezone/Etc/GMT+0
+share/postgresql/timezone/Etc/GMT+1
+share/postgresql/timezone/Etc/GMT+10
+share/postgresql/timezone/Etc/GMT+11
+share/postgresql/timezone/Etc/GMT+12
+share/postgresql/timezone/Etc/GMT+2
+share/postgresql/timezone/Etc/GMT+3
+share/postgresql/timezone/Etc/GMT+4
+share/postgresql/timezone/Etc/GMT+5
+share/postgresql/timezone/Etc/GMT+6
+share/postgresql/timezone/Etc/GMT+7
+share/postgresql/timezone/Etc/GMT+8
+share/postgresql/timezone/Etc/GMT+9
+share/postgresql/timezone/Etc/GMT-0
+share/postgresql/timezone/Etc/GMT-1
+share/postgresql/timezone/Etc/GMT-10
+share/postgresql/timezone/Etc/GMT-11
+share/postgresql/timezone/Etc/GMT-12
+share/postgresql/timezone/Etc/GMT-13
+share/postgresql/timezone/Etc/GMT-14
+share/postgresql/timezone/Etc/GMT-2
+share/postgresql/timezone/Etc/GMT-3
+share/postgresql/timezone/Etc/GMT-4
+share/postgresql/timezone/Etc/GMT-5
+share/postgresql/timezone/Etc/GMT-6
+share/postgresql/timezone/Etc/GMT-7
+share/postgresql/timezone/Etc/GMT-8
+share/postgresql/timezone/Etc/GMT-9
+share/postgresql/timezone/Etc/GMT0
+share/postgresql/timezone/Etc/Greenwich
+share/postgresql/timezone/Etc/UCT
+share/postgresql/timezone/Etc/UTC
+share/postgresql/timezone/Etc/Universal
+share/postgresql/timezone/Etc/Zulu
+share/postgresql/timezone/Europe/Amsterdam
+share/postgresql/timezone/Europe/Andorra
+share/postgresql/timezone/Europe/Athens
+share/postgresql/timezone/Europe/Belfast
+share/postgresql/timezone/Europe/Belgrade
+share/postgresql/timezone/Europe/Berlin
+share/postgresql/timezone/Europe/Bratislava
+share/postgresql/timezone/Europe/Brussels
+share/postgresql/timezone/Europe/Bucharest
+share/postgresql/timezone/Europe/Budapest
+share/postgresql/timezone/Europe/Busingen
+share/postgresql/timezone/Europe/Chisinau
+share/postgresql/timezone/Europe/Copenhagen
+share/postgresql/timezone/Europe/Dublin
+share/postgresql/timezone/Europe/Gibraltar
+share/postgresql/timezone/Europe/Guernsey
+share/postgresql/timezone/Europe/Helsinki
+share/postgresql/timezone/Europe/Isle_of_Man
+share/postgresql/timezone/Europe/Istanbul
+share/postgresql/timezone/Europe/Jersey
+share/postgresql/timezone/Europe/Kaliningrad
+share/postgresql/timezone/Europe/Kiev
+share/postgresql/timezone/Europe/Lisbon
+share/postgresql/timezone/Europe/Ljubljana
+share/postgresql/timezone/Europe/London
+share/postgresql/timezone/Europe/Luxembourg
+share/postgresql/timezone/Europe/Madrid
+share/postgresql/timezone/Europe/Malta
+share/postgresql/timezone/Europe/Mariehamn
+share/postgresql/timezone/Europe/Minsk
+share/postgresql/timezone/Europe/Monaco
+share/postgresql/timezone/Europe/Moscow
+share/postgresql/timezone/Europe/Nicosia
+share/postgresql/timezone/Europe/Oslo
+share/postgresql/timezone/Europe/Paris
+share/postgresql/timezone/Europe/Podgorica
+share/postgresql/timezone/Europe/Prague
+share/postgresql/timezone/Europe/Riga
+share/postgresql/timezone/Europe/Rome
+share/postgresql/timezone/Europe/Samara
+share/postgresql/timezone/Europe/San_Marino
+share/postgresql/timezone/Europe/Sarajevo
+share/postgresql/timezone/Europe/Simferopol
+share/postgresql/timezone/Europe/Skopje
+share/postgresql/timezone/Europe/Sofia
+share/postgresql/timezone/Europe/Stockholm
+share/postgresql/timezone/Europe/Tallinn
+share/postgresql/timezone/Europe/Tirane
+share/postgresql/timezone/Europe/Tiraspol
+share/postgresql/timezone/Europe/Uzhgorod
+share/postgresql/timezone/Europe/Vaduz
+share/postgresql/timezone/Europe/Vatican
+share/postgresql/timezone/Europe/Vienna
+share/postgresql/timezone/Europe/Vilnius
+share/postgresql/timezone/Europe/Volgograd
+share/postgresql/timezone/Europe/Warsaw
+share/postgresql/timezone/Europe/Zagreb
+share/postgresql/timezone/Europe/Zaporozhye
+share/postgresql/timezone/Europe/Zurich
+share/postgresql/timezone/Factory
+share/postgresql/timezone/GB
+share/postgresql/timezone/GB-Eire
+share/postgresql/timezone/GMT
+share/postgresql/timezone/GMT+0
+share/postgresql/timezone/GMT-0
+share/postgresql/timezone/GMT0
+share/postgresql/timezone/Greenwich
+share/postgresql/timezone/HST
+share/postgresql/timezone/Hongkong
+share/postgresql/timezone/Iceland
+share/postgresql/timezone/Indian/Antananarivo
+share/postgresql/timezone/Indian/Chagos
+share/postgresql/timezone/Indian/Christmas
+share/postgresql/timezone/Indian/Cocos
+share/postgresql/timezone/Indian/Comoro
+share/postgresql/timezone/Indian/Kerguelen
+share/postgresql/timezone/Indian/Mahe
+share/postgresql/timezone/Indian/Maldives
+share/postgresql/timezone/Indian/Mauritius
+share/postgresql/timezone/Indian/Mayotte
+share/postgresql/timezone/Indian/Reunion
+share/postgresql/timezone/Iran
+share/postgresql/timezone/Israel
+share/postgresql/timezone/Jamaica
+share/postgresql/timezone/Japan
+share/postgresql/timezone/Kwajalein
+share/postgresql/timezone/Libya
+share/postgresql/timezone/MET
+share/postgresql/timezone/MST
+share/postgresql/timezone/MST7MDT
+share/postgresql/timezone/Mexico/BajaNorte
+share/postgresql/timezone/Mexico/BajaSur
+share/postgresql/timezone/Mexico/General
+share/postgresql/timezone/Mideast/Riyadh87
+share/postgresql/timezone/Mideast/Riyadh88
+share/postgresql/timezone/Mideast/Riyadh89
+share/postgresql/timezone/NZ
+share/postgresql/timezone/NZ-CHAT
+share/postgresql/timezone/Navajo
+share/postgresql/timezone/PRC
+share/postgresql/timezone/PST8PDT
+share/postgresql/timezone/Pacific/Apia
+share/postgresql/timezone/Pacific/Auckland
+share/postgresql/timezone/Pacific/Chatham
+share/postgresql/timezone/Pacific/Chuuk
+share/postgresql/timezone/Pacific/Easter
+share/postgresql/timezone/Pacific/Efate
+share/postgresql/timezone/Pacific/Enderbury
+share/postgresql/timezone/Pacific/Fakaofo
+share/postgresql/timezone/Pacific/Fiji
+share/postgresql/timezone/Pacific/Funafuti
+share/postgresql/timezone/Pacific/Galapagos
+share/postgresql/timezone/Pacific/Gambier
+share/postgresql/timezone/Pacific/Guadalcanal
+share/postgresql/timezone/Pacific/Guam
+share/postgresql/timezone/Pacific/Honolulu
+share/postgresql/timezone/Pacific/Johnston
+share/postgresql/timezone/Pacific/Kiritimati
+share/postgresql/timezone/Pacific/Kosrae
+share/postgresql/timezone/Pacific/Kwajalein
+share/postgresql/timezone/Pacific/Majuro
+share/postgresql/timezone/Pacific/Marquesas
+share/postgresql/timezone/Pacific/Midway
+share/postgresql/timezone/Pacific/Nauru
+share/postgresql/timezone/Pacific/Niue
+share/postgresql/timezone/Pacific/Norfolk
+share/postgresql/timezone/Pacific/Noumea
+share/postgresql/timezone/Pacific/Pago_Pago
+share/postgresql/timezone/Pacific/Palau
+share/postgresql/timezone/Pacific/Pitcairn
+share/postgresql/timezone/Pacific/Pohnpei
+share/postgresql/timezone/Pacific/Ponape
+share/postgresql/timezone/Pacific/Port_Moresby
+share/postgresql/timezone/Pacific/Rarotonga
+share/postgresql/timezone/Pacific/Saipan
+share/postgresql/timezone/Pacific/Samoa
+share/postgresql/timezone/Pacific/Tahiti
+share/postgresql/timezone/Pacific/Tarawa
+share/postgresql/timezone/Pacific/Tongatapu
+share/postgresql/timezone/Pacific/Truk
+share/postgresql/timezone/Pacific/Wake
+share/postgresql/timezone/Pacific/Wallis
+share/postgresql/timezone/Pacific/Yap
+share/postgresql/timezone/Poland
+share/postgresql/timezone/Portugal
+share/postgresql/timezone/ROC
+share/postgresql/timezone/ROK
+share/postgresql/timezone/Singapore
+share/postgresql/timezone/Turkey
+share/postgresql/timezone/UCT
+share/postgresql/timezone/US/Alaska
+share/postgresql/timezone/US/Aleutian
+share/postgresql/timezone/US/Arizona
+share/postgresql/timezone/US/Central
+share/postgresql/timezone/US/East-Indiana
+share/postgresql/timezone/US/Eastern
+share/postgresql/timezone/US/Hawaii
+share/postgresql/timezone/US/Indiana-Starke
+share/postgresql/timezone/US/Michigan
+share/postgresql/timezone/US/Mountain
+share/postgresql/timezone/US/Pacific
+share/postgresql/timezone/US/Pacific-New
+share/postgresql/timezone/US/Samoa
+share/postgresql/timezone/UTC
+share/postgresql/timezone/Universal
+share/postgresql/timezone/W-SU
+share/postgresql/timezone/WET
+share/postgresql/timezone/Zulu
+share/postgresql/timezone/posixrules
+share/postgresql/timezonesets/Africa.txt
+share/postgresql/timezonesets/America.txt
+share/postgresql/timezonesets/Antarctica.txt
+share/postgresql/timezonesets/Asia.txt
+share/postgresql/timezonesets/Atlantic.txt
+share/postgresql/timezonesets/Australia
+share/postgresql/timezonesets/Australia.txt
+share/postgresql/timezonesets/Default
+share/postgresql/timezonesets/Etc.txt
+share/postgresql/timezonesets/Europe.txt
+share/postgresql/timezonesets/India
+share/postgresql/timezonesets/Indian.txt
+share/postgresql/timezonesets/Pacific.txt
+share/postgresql/tsearch_data/danish.stop
+share/postgresql/tsearch_data/dutch.stop
+share/postgresql/tsearch_data/english.stop
+share/postgresql/tsearch_data/finnish.stop
+share/postgresql/tsearch_data/french.stop
+share/postgresql/tsearch_data/german.stop
+share/postgresql/tsearch_data/hungarian.stop
+share/postgresql/tsearch_data/hunspell_sample.affix
+share/postgresql/tsearch_data/ispell_sample.affix
+share/postgresql/tsearch_data/ispell_sample.dict
+share/postgresql/tsearch_data/italian.stop
+share/postgresql/tsearch_data/norwegian.stop
+share/postgresql/tsearch_data/portuguese.stop
+share/postgresql/tsearch_data/russian.stop
+share/postgresql/tsearch_data/spanish.stop
+share/postgresql/tsearch_data/swedish.stop
+share/postgresql/tsearch_data/synonym_sample.syn
+share/postgresql/tsearch_data/thesaurus_sample.ths
+share/postgresql/tsearch_data/turkish.stop
diff --git a/databases/postgresql93-server/files/pgsql.sh b/databases/postgresql93-server/files/pgsql.sh
new file mode 100644
index 00000000000..c502401e8f0
--- /dev/null
+++ b/databases/postgresql93-server/files/pgsql.sh
@@ -0,0 +1,130 @@
+#!@RCD_SCRIPTS_SHELL@
+#
+# $NetBSD: pgsql.sh,v 1.1 2013/09/10 15:32:33 adam Exp $
+#
+# PostgreSQL database rc.d control script
+#
+# PROVIDE: pgsql
+# REQUIRE: DAEMON
+# KEYWORD: shutdown
+#
+# You will need to set some variables in /etc/rc.conf to start PostgreSQL:
+#
+# pgsql=YES
+#
+# Optionally, "pgsql_flags" contains options for the PostgreSQL postmaster, e.g.
+#	pgsql_flags="-i"		# allows TCP/IP connections
+#	pgsql_flags="-i -l"		# enables SSL connections
+#	pgsql_home="/path/to/home"	# path to pgsql database directory
+# See postmaster(1) for possible options.
+
+if [ -f /etc/rc.subr ]; then
+	. /etc/rc.subr
+fi
+
+name="pgsql"
+rcvar=${name}
+command="@PREFIX@/bin/pg_ctl"
+procname="@PREFIX@/bin/postgres"
+: ${pgsql_user:=@PGUSER@}
+: ${pgsql_group:=@PGGROUP@}
+: ${pgsql_home:=@PGHOME@}
+
+extra_commands="initdb reload"
+initdb_cmd="pgsql_initdb"
+start_precmd="pgsql_precmd"
+start_cmd="pgsql_start"
+restart_precmd="pgsql_precmd"
+restart_cmd="pgsql_restart"
+stop_cmd="pgsql_stop"
+reload_cmd="pgsql_reload"
+
+if [ -f /etc/rc.subr -a -d /etc/rc.d -a -f /etc/rc.d/DAEMON ]; then
+	load_rc_config $name
+elif [ -f /etc/rc.conf ]; then
+	. /etc/rc.conf
+fi
+
+command_args="-w -s -D ${pgsql_home}/data -m fast -l ${pgsql_home}/errlog"
+if [ -n "${pgsql_flags}" ]; then
+	command_args="${command_args} -o \\\"${pgsql_flags}\\\""
+fi
+
+pgsql_precmd()
+{
+	ulimit -n 4096
+	if [ ! -d ${pgsql_home}/data/base ]; then
+		pgsql_initdb
+	fi
+}
+
+pgsql_initdb()
+{
+	if [ -d ${pgsql_home}/data/base ]; then
+		@ECHO@ "The PostgreSQL template databases have already been initialized."
+		@ECHO@ "Skipping database initialization."
+	else
+		@ECHO@ "Initializing PostgreSQL databases."
+		@MKDIR@ -p ${pgsql_home}
+		@CHOWN@ ${pgsql_user} ${pgsql_home}
+		@CHGRP@ ${pgsql_group} ${pgsql_home}
+		@CHMOD@ 0700 ${pgsql_home}
+		doit="@SU@ -m ${pgsql_user} -c '${command} init ${command_args}'"
+		eval $doit
+	fi
+}
+
+pgsql_start()
+{
+	@ECHO@ "Starting ${name}."
+	doit="@SU@ -m ${pgsql_user} -c '${command} start ${command_args}'"
+	eval $doit
+}
+
+pgsql_restart()
+{
+	@ECHO@ "Restarting ${name}."
+	doit="@SU@ -m ${pgsql_user} -c '${command} restart ${command_args}'"
+	eval $doit
+}
+
+pgsql_stop()
+{
+	@ECHO@ "Stopping ${name}."
+	doit="@SU@ -m ${pgsql_user} -c '${command} stop ${command_args}'"
+	eval $doit
+}
+
+pgsql_reload()
+{
+	@ECHO@ "Reloading ${name}."
+	doit="@SU@ -m ${pgsql_user} -c '${command} reload ${command_args}'"
+	eval $doit
+}
+
+if [ -f /etc/rc.subr -a -d /etc/rc.d -a -f /etc/rc.d/DAEMON ]; then
+	run_rc_command "$1"
+else
+	pidfile="${pgsql_home}/data/postmaster.pid"
+	case "$1" in
+	initdb)
+		eval ${initdb_cmd}
+		;;
+	restart)
+		eval ${restart_precmd}
+		eval ${restart_cmd}
+		;;
+	stop)
+		if [ -r "${pidfile}" ]; then
+			eval ${stop_cmd}
+		fi
+		;;
+	reload)
+		eval ${reload_cmd}
+		;;
+	*)
+		eval ${start_precmd}
+		eval ${start_cmd}
+		;;
+	esac
+fi