Changes 9.0:

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.

6 files changed, 948 insertions, 0 deletions

diff --git a/databases/postgresql90-server/DEINSTALL b/databases/postgresql90-server/DEINSTALL
new file mode 100644
index 00000000000..ce81b43b694
--- /dev/null
+++ b/databases/postgresql90-server/DEINSTALL
@@ -0,0 +1,20 @@
+# $NetBSD: DEINSTALL,v 1.1.1.1 2010/09/21 07:52:56 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/postgresql90-server/DESCR b/databases/postgresql90-server/DESCR
new file mode 100644
index 00000000000..68bb2b05748
--- /dev/null
+++ b/databases/postgresql90-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/postgresql90-server/MESSAGE b/databases/postgresql90-server/MESSAGE
new file mode 100644
index 00000000000..a827b1ce33d
--- /dev/null
+++ b/databases/postgresql90-server/MESSAGE
@@ -0,0 +1,18 @@
+===========================================================================
+$NetBSD: MESSAGE,v 1.1.1.1 2010/09/21 07:52:56 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/postgresql90-server/Makefile b/databases/postgresql90-server/Makefile
new file mode 100644
index 00000000000..ce2c3f28ed6
--- /dev/null
+++ b/databases/postgresql90-server/Makefile
@@ -0,0 +1,88 @@
+# $NetBSD: Makefile,v 1.1.1.1 2010/09/21 07:52:56 adam Exp $
+
+PKGNAME=	postgresql90-server-${BASE_VERS}
+COMMENT=	PostgreSQL database server programs
+
+PKG_DESTDIR_SUPPORT=	user-destdir
+
+# mips has no TAS implementation
+NOT_FOR_PLATFORM=	*-*-mips
+
+.include "../../databases/postgresql90/Makefile.common"
+
+# Use shlibtool (invoked as "$(LIBTOOL)") to build modules.
+USE_LIBTOOL=		yes
+PKG_LIBTOOL=		${PKG_SHLIBTOOL}
+
+MESSAGE_SRC=		${.CURDIR}/MESSAGE
+
+CONFIGURE_ARGS+=	--with-openssl
+
+BUILD_DIRS=		src/backend
+BUILD_DIRS+=		src/backend/utils/mb/conversion_procs
+BUILD_DIRS+=		src/backend/snowball
+BUILD_DIRS+=		src/timezone
+BUILD_DIRS+=		src/pl
+
+# 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
+
+PKG_OPTIONS_VAR=	PKG_OPTIONS.postgresql90-server
+PKG_SUPPORTED_OPTIONS=	gssapi krb5 ldap pam
+.include "../../databases/postgresql90/options.mk"
+
+# 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
+
+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}
+PKG_SHELL.${PGUSER}=	${SH}
+
+RCD_SCRIPTS=		pgsql
+
+.include "../../databases/postgresql90-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
+
+pre-build:
+	${RUN}${_ULIMIT_CMD}						\
+	cd ${WRKSRC}/src/port &&					\
+	env ${MAKE_ENV} ${MAKE_PROGRAM} ${BUILD_MAKE_FLAGS}
+
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql90-server/PLIST b/databases/postgresql90-server/PLIST
new file mode 100644
index 00000000000..73258848ab3
--- /dev/null
+++ b/databases/postgresql90-server/PLIST
@@ -0,0 +1,665 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2010/09/21 07:52:57 adam Exp $
+${PG_SUBPREFIX}bin/postgres
+${PG_SUBPREFIX}bin/postmaster
+${PG_SUBPREFIX}lib/postgresql/ascii_and_mic.la
+${PG_SUBPREFIX}lib/postgresql/cyrillic_and_mic.la
+${PG_SUBPREFIX}lib/postgresql/dict_snowball.la
+${PG_SUBPREFIX}lib/postgresql/euc2004_sjis2004.la
+${PG_SUBPREFIX}lib/postgresql/euc_cn_and_mic.la
+${PG_SUBPREFIX}lib/postgresql/euc_jp_and_sjis.la
+${PG_SUBPREFIX}lib/postgresql/euc_kr_and_mic.la
+${PG_SUBPREFIX}lib/postgresql/euc_tw_and_big5.la
+${PG_SUBPREFIX}lib/postgresql/latin2_and_win1250.la
+${PG_SUBPREFIX}lib/postgresql/latin_and_mic.la
+${PG_SUBPREFIX}lib/postgresql/plpgsql.la
+${PG_SUBPREFIX}lib/postgresql/utf8_and_ascii.la
+${PG_SUBPREFIX}lib/postgresql/utf8_and_big5.la
+${PG_SUBPREFIX}lib/postgresql/utf8_and_cyrillic.la
+${PG_SUBPREFIX}lib/postgresql/utf8_and_euc2004.la
+${PG_SUBPREFIX}lib/postgresql/utf8_and_euc_cn.la
+${PG_SUBPREFIX}lib/postgresql/utf8_and_euc_jp.la
+${PG_SUBPREFIX}lib/postgresql/utf8_and_euc_kr.la
+${PG_SUBPREFIX}lib/postgresql/utf8_and_euc_tw.la
+${PG_SUBPREFIX}lib/postgresql/utf8_and_gb18030.la
+${PG_SUBPREFIX}lib/postgresql/utf8_and_gbk.la
+${PG_SUBPREFIX}lib/postgresql/utf8_and_iso8859.la
+${PG_SUBPREFIX}lib/postgresql/utf8_and_iso8859_1.la
+${PG_SUBPREFIX}lib/postgresql/utf8_and_johab.la
+${PG_SUBPREFIX}lib/postgresql/utf8_and_sjis.la
+${PG_SUBPREFIX}lib/postgresql/utf8_and_sjis2004.la
+${PG_SUBPREFIX}lib/postgresql/utf8_and_uhc.la
+${PG_SUBPREFIX}lib/postgresql/utf8_and_win.la
+${PG_SUBPREFIX}share/examples/rc.d/pgsql
+${PG_SUBPREFIX}share/locale/de/LC_MESSAGES/plpgsql0-9.0.mo
+${PG_SUBPREFIX}share/locale/de/LC_MESSAGES/postgres-9.0.mo
+${PG_SUBPREFIX}share/locale/es/LC_MESSAGES/plpgsql0-9.0.mo
+${PG_SUBPREFIX}share/locale/es/LC_MESSAGES/postgres-9.0.mo
+${PG_SUBPREFIX}share/locale/fr/LC_MESSAGES/plpgsql0-9.0.mo
+${PG_SUBPREFIX}share/locale/fr/LC_MESSAGES/postgres-9.0.mo
+${PG_SUBPREFIX}share/locale/it/LC_MESSAGES/plpgsql0-9.0.mo
+${PG_SUBPREFIX}share/locale/ja/LC_MESSAGES/plpgsql0-9.0.mo
+${PG_SUBPREFIX}share/locale/ja/LC_MESSAGES/postgres-9.0.mo
+${PG_SUBPREFIX}share/locale/pt_BR/LC_MESSAGES/plpgsql0-9.0.mo
+${PG_SUBPREFIX}share/locale/pt_BR/LC_MESSAGES/postgres-9.0.mo
+${PG_SUBPREFIX}share/locale/ro/LC_MESSAGES/plpgsql0-9.0.mo
+${PG_SUBPREFIX}share/locale/tr/LC_MESSAGES/plpgsql0-9.0.mo
+${PG_SUBPREFIX}share/locale/tr/LC_MESSAGES/postgres-9.0.mo
+${PG_SUBPREFIX}share/postgresql/conversion_create.sql
+${PG_SUBPREFIX}share/postgresql/information_schema.sql
+${PG_SUBPREFIX}share/postgresql/pg_hba.conf.sample
+${PG_SUBPREFIX}share/postgresql/pg_ident.conf.sample
+${PG_SUBPREFIX}share/postgresql/postgres.bki
+${PG_SUBPREFIX}share/postgresql/postgres.description
+${PG_SUBPREFIX}share/postgresql/postgres.shdescription
+${PG_SUBPREFIX}share/postgresql/postgresql.conf.sample
+${PG_SUBPREFIX}share/postgresql/recovery.conf.sample
+${PG_SUBPREFIX}share/postgresql/snowball_create.sql
+${PG_SUBPREFIX}share/postgresql/sql_features.txt
+${PG_SUBPREFIX}share/postgresql/system_views.sql
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Abidjan
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Accra
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Addis_Ababa
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Algiers
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Asmara
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Asmera
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Bamako
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Bangui
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Banjul
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Bissau
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Blantyre
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Brazzaville
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Bujumbura
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Cairo
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Casablanca
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Ceuta
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Conakry
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Dakar
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Dar_es_Salaam
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Djibouti
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Douala
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/El_Aaiun
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Freetown
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Gaborone
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Harare
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Johannesburg
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Kampala
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Khartoum
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Kigali
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Kinshasa
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Lagos
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Libreville
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Lome
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Luanda
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Lubumbashi
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Lusaka
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Malabo
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Maputo
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Maseru
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Mbabane
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Mogadishu
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Monrovia
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Nairobi
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Ndjamena
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Niamey
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Nouakchott
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Ouagadougou
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Porto-Novo
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Sao_Tome
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Timbuktu
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Tripoli
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Tunis
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Windhoek
+${PG_SUBPREFIX}share/postgresql/timezone/America/Adak
+${PG_SUBPREFIX}share/postgresql/timezone/America/Anchorage
+${PG_SUBPREFIX}share/postgresql/timezone/America/Anguilla
+${PG_SUBPREFIX}share/postgresql/timezone/America/Antigua
+${PG_SUBPREFIX}share/postgresql/timezone/America/Araguaina
+${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Buenos_Aires
+${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Catamarca
+${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/ComodRivadavia
+${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Cordoba
+${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Jujuy
+${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/La_Rioja
+${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Mendoza
+${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Rio_Gallegos
+${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Salta
+${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/San_Juan
+${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/San_Luis
+${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Tucuman
+${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Ushuaia
+${PG_SUBPREFIX}share/postgresql/timezone/America/Aruba
+${PG_SUBPREFIX}share/postgresql/timezone/America/Asuncion
+${PG_SUBPREFIX}share/postgresql/timezone/America/Atikokan
+${PG_SUBPREFIX}share/postgresql/timezone/America/Atka
+${PG_SUBPREFIX}share/postgresql/timezone/America/Bahia
+${PG_SUBPREFIX}share/postgresql/timezone/America/Bahia_Banderas
+${PG_SUBPREFIX}share/postgresql/timezone/America/Barbados
+${PG_SUBPREFIX}share/postgresql/timezone/America/Belem
+${PG_SUBPREFIX}share/postgresql/timezone/America/Belize
+${PG_SUBPREFIX}share/postgresql/timezone/America/Blanc-Sablon
+${PG_SUBPREFIX}share/postgresql/timezone/America/Boa_Vista
+${PG_SUBPREFIX}share/postgresql/timezone/America/Bogota
+${PG_SUBPREFIX}share/postgresql/timezone/America/Boise
+${PG_SUBPREFIX}share/postgresql/timezone/America/Buenos_Aires
+${PG_SUBPREFIX}share/postgresql/timezone/America/Cambridge_Bay
+${PG_SUBPREFIX}share/postgresql/timezone/America/Campo_Grande
+${PG_SUBPREFIX}share/postgresql/timezone/America/Cancun
+${PG_SUBPREFIX}share/postgresql/timezone/America/Caracas
+${PG_SUBPREFIX}share/postgresql/timezone/America/Catamarca
+${PG_SUBPREFIX}share/postgresql/timezone/America/Cayenne
+${PG_SUBPREFIX}share/postgresql/timezone/America/Cayman
+${PG_SUBPREFIX}share/postgresql/timezone/America/Chicago
+${PG_SUBPREFIX}share/postgresql/timezone/America/Chihuahua
+${PG_SUBPREFIX}share/postgresql/timezone/America/Coral_Harbour
+${PG_SUBPREFIX}share/postgresql/timezone/America/Cordoba
+${PG_SUBPREFIX}share/postgresql/timezone/America/Costa_Rica
+${PG_SUBPREFIX}share/postgresql/timezone/America/Cuiaba
+${PG_SUBPREFIX}share/postgresql/timezone/America/Curacao
+${PG_SUBPREFIX}share/postgresql/timezone/America/Danmarkshavn
+${PG_SUBPREFIX}share/postgresql/timezone/America/Dawson
+${PG_SUBPREFIX}share/postgresql/timezone/America/Dawson_Creek
+${PG_SUBPREFIX}share/postgresql/timezone/America/Denver
+${PG_SUBPREFIX}share/postgresql/timezone/America/Detroit
+${PG_SUBPREFIX}share/postgresql/timezone/America/Dominica
+${PG_SUBPREFIX}share/postgresql/timezone/America/Edmonton
+${PG_SUBPREFIX}share/postgresql/timezone/America/Eirunepe
+${PG_SUBPREFIX}share/postgresql/timezone/America/El_Salvador
+${PG_SUBPREFIX}share/postgresql/timezone/America/Ensenada
+${PG_SUBPREFIX}share/postgresql/timezone/America/Fort_Wayne
+${PG_SUBPREFIX}share/postgresql/timezone/America/Fortaleza
+${PG_SUBPREFIX}share/postgresql/timezone/America/Glace_Bay
+${PG_SUBPREFIX}share/postgresql/timezone/America/Godthab
+${PG_SUBPREFIX}share/postgresql/timezone/America/Goose_Bay
+${PG_SUBPREFIX}share/postgresql/timezone/America/Grand_Turk
+${PG_SUBPREFIX}share/postgresql/timezone/America/Grenada
+${PG_SUBPREFIX}share/postgresql/timezone/America/Guadeloupe
+${PG_SUBPREFIX}share/postgresql/timezone/America/Guatemala
+${PG_SUBPREFIX}share/postgresql/timezone/America/Guayaquil
+${PG_SUBPREFIX}share/postgresql/timezone/America/Guyana
+${PG_SUBPREFIX}share/postgresql/timezone/America/Halifax
+${PG_SUBPREFIX}share/postgresql/timezone/America/Havana
+${PG_SUBPREFIX}share/postgresql/timezone/America/Hermosillo
+${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Indianapolis
+${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Knox
+${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Marengo
+${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Petersburg
+${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Tell_City
+${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Vevay
+${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Vincennes
+${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Winamac
+${PG_SUBPREFIX}share/postgresql/timezone/America/Indianapolis
+${PG_SUBPREFIX}share/postgresql/timezone/America/Inuvik
+${PG_SUBPREFIX}share/postgresql/timezone/America/Iqaluit
+${PG_SUBPREFIX}share/postgresql/timezone/America/Jamaica
+${PG_SUBPREFIX}share/postgresql/timezone/America/Jujuy
+${PG_SUBPREFIX}share/postgresql/timezone/America/Juneau
+${PG_SUBPREFIX}share/postgresql/timezone/America/Kentucky/Louisville
+${PG_SUBPREFIX}share/postgresql/timezone/America/Kentucky/Monticello
+${PG_SUBPREFIX}share/postgresql/timezone/America/Knox_IN
+${PG_SUBPREFIX}share/postgresql/timezone/America/La_Paz
+${PG_SUBPREFIX}share/postgresql/timezone/America/Lima
+${PG_SUBPREFIX}share/postgresql/timezone/America/Los_Angeles
+${PG_SUBPREFIX}share/postgresql/timezone/America/Louisville
+${PG_SUBPREFIX}share/postgresql/timezone/America/Maceio
+${PG_SUBPREFIX}share/postgresql/timezone/America/Managua
+${PG_SUBPREFIX}share/postgresql/timezone/America/Manaus
+${PG_SUBPREFIX}share/postgresql/timezone/America/Marigot
+${PG_SUBPREFIX}share/postgresql/timezone/America/Martinique
+${PG_SUBPREFIX}share/postgresql/timezone/America/Matamoros
+${PG_SUBPREFIX}share/postgresql/timezone/America/Mazatlan
+${PG_SUBPREFIX}share/postgresql/timezone/America/Mendoza
+${PG_SUBPREFIX}share/postgresql/timezone/America/Menominee
+${PG_SUBPREFIX}share/postgresql/timezone/America/Merida
+${PG_SUBPREFIX}share/postgresql/timezone/America/Mexico_City
+${PG_SUBPREFIX}share/postgresql/timezone/America/Miquelon
+${PG_SUBPREFIX}share/postgresql/timezone/America/Moncton
+${PG_SUBPREFIX}share/postgresql/timezone/America/Monterrey
+${PG_SUBPREFIX}share/postgresql/timezone/America/Montevideo
+${PG_SUBPREFIX}share/postgresql/timezone/America/Montreal
+${PG_SUBPREFIX}share/postgresql/timezone/America/Montserrat
+${PG_SUBPREFIX}share/postgresql/timezone/America/Nassau
+${PG_SUBPREFIX}share/postgresql/timezone/America/New_York
+${PG_SUBPREFIX}share/postgresql/timezone/America/Nipigon
+${PG_SUBPREFIX}share/postgresql/timezone/America/Nome
+${PG_SUBPREFIX}share/postgresql/timezone/America/Noronha
+${PG_SUBPREFIX}share/postgresql/timezone/America/North_Dakota/Center
+${PG_SUBPREFIX}share/postgresql/timezone/America/North_Dakota/New_Salem
+${PG_SUBPREFIX}share/postgresql/timezone/America/Ojinaga
+${PG_SUBPREFIX}share/postgresql/timezone/America/Panama
+${PG_SUBPREFIX}share/postgresql/timezone/America/Pangnirtung
+${PG_SUBPREFIX}share/postgresql/timezone/America/Paramaribo
+${PG_SUBPREFIX}share/postgresql/timezone/America/Phoenix
+${PG_SUBPREFIX}share/postgresql/timezone/America/Port-au-Prince
+${PG_SUBPREFIX}share/postgresql/timezone/America/Port_of_Spain
+${PG_SUBPREFIX}share/postgresql/timezone/America/Porto_Acre
+${PG_SUBPREFIX}share/postgresql/timezone/America/Porto_Velho
+${PG_SUBPREFIX}share/postgresql/timezone/America/Puerto_Rico
+${PG_SUBPREFIX}share/postgresql/timezone/America/Rainy_River
+${PG_SUBPREFIX}share/postgresql/timezone/America/Rankin_Inlet
+${PG_SUBPREFIX}share/postgresql/timezone/America/Recife
+${PG_SUBPREFIX}share/postgresql/timezone/America/Regina
+${PG_SUBPREFIX}share/postgresql/timezone/America/Resolute
+${PG_SUBPREFIX}share/postgresql/timezone/America/Rio_Branco
+${PG_SUBPREFIX}share/postgresql/timezone/America/Rosario
+${PG_SUBPREFIX}share/postgresql/timezone/America/Santa_Isabel
+${PG_SUBPREFIX}share/postgresql/timezone/America/Santarem
+${PG_SUBPREFIX}share/postgresql/timezone/America/Santiago
+${PG_SUBPREFIX}share/postgresql/timezone/America/Santo_Domingo
+${PG_SUBPREFIX}share/postgresql/timezone/America/Sao_Paulo
+${PG_SUBPREFIX}share/postgresql/timezone/America/Scoresbysund
+${PG_SUBPREFIX}share/postgresql/timezone/America/Shiprock
+${PG_SUBPREFIX}share/postgresql/timezone/America/St_Barthelemy
+${PG_SUBPREFIX}share/postgresql/timezone/America/St_Johns
+${PG_SUBPREFIX}share/postgresql/timezone/America/St_Kitts
+${PG_SUBPREFIX}share/postgresql/timezone/America/St_Lucia
+${PG_SUBPREFIX}share/postgresql/timezone/America/St_Thomas
+${PG_SUBPREFIX}share/postgresql/timezone/America/St_Vincent
+${PG_SUBPREFIX}share/postgresql/timezone/America/Swift_Current
+${PG_SUBPREFIX}share/postgresql/timezone/America/Tegucigalpa
+${PG_SUBPREFIX}share/postgresql/timezone/America/Thule
+${PG_SUBPREFIX}share/postgresql/timezone/America/Thunder_Bay
+${PG_SUBPREFIX}share/postgresql/timezone/America/Tijuana
+${PG_SUBPREFIX}share/postgresql/timezone/America/Toronto
+${PG_SUBPREFIX}share/postgresql/timezone/America/Tortola
+${PG_SUBPREFIX}share/postgresql/timezone/America/Vancouver
+${PG_SUBPREFIX}share/postgresql/timezone/America/Virgin
+${PG_SUBPREFIX}share/postgresql/timezone/America/Whitehorse
+${PG_SUBPREFIX}share/postgresql/timezone/America/Winnipeg
+${PG_SUBPREFIX}share/postgresql/timezone/America/Yakutat
+${PG_SUBPREFIX}share/postgresql/timezone/America/Yellowknife
+${PG_SUBPREFIX}share/postgresql/timezone/Antarctica/Casey
+${PG_SUBPREFIX}share/postgresql/timezone/Antarctica/Davis
+${PG_SUBPREFIX}share/postgresql/timezone/Antarctica/DumontDUrville
+${PG_SUBPREFIX}share/postgresql/timezone/Antarctica/Macquarie
+${PG_SUBPREFIX}share/postgresql/timezone/Antarctica/Mawson
+${PG_SUBPREFIX}share/postgresql/timezone/Antarctica/McMurdo
+${PG_SUBPREFIX}share/postgresql/timezone/Antarctica/Palmer
+${PG_SUBPREFIX}share/postgresql/timezone/Antarctica/Rothera
+${PG_SUBPREFIX}share/postgresql/timezone/Antarctica/South_Pole
+${PG_SUBPREFIX}share/postgresql/timezone/Antarctica/Syowa
+${PG_SUBPREFIX}share/postgresql/timezone/Antarctica/Vostok
+${PG_SUBPREFIX}share/postgresql/timezone/Arctic/Longyearbyen
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Aden
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Almaty
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Amman
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Anadyr
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Aqtau
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Aqtobe
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Ashgabat
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Ashkhabad
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Baghdad
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Bahrain
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Baku
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Bangkok
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Beirut
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Bishkek
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Brunei
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Calcutta
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Choibalsan
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Chongqing
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Chungking
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Colombo
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Dacca
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Damascus
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Dhaka
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Dili
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Dubai
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Dushanbe
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Gaza
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Harbin
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Ho_Chi_Minh
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Hong_Kong
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Hovd
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Irkutsk
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Istanbul
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Jakarta
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Jayapura
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Jerusalem
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Kabul
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Kamchatka
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Karachi
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Kashgar
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Kathmandu
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Katmandu
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Kolkata
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Krasnoyarsk
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Kuala_Lumpur
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Kuching
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Kuwait
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Macao
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Macau
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Magadan
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Makassar
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Manila
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Muscat
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Nicosia
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Novokuznetsk
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Novosibirsk
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Omsk
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Oral
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Phnom_Penh
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Pontianak
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Pyongyang
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Qatar
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Qyzylorda
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Rangoon
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Riyadh
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Riyadh87
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Riyadh88
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Riyadh89
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Saigon
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Sakhalin
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Samarkand
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Seoul
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Shanghai
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Singapore
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Taipei
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Tashkent
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Tbilisi
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Tehran
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Tel_Aviv
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Thimbu
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Thimphu
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Tokyo
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Ujung_Pandang
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Ulaanbaatar
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Ulan_Bator
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Urumqi
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Vientiane
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Vladivostok
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Yakutsk
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Yekaterinburg
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Yerevan
+${PG_SUBPREFIX}share/postgresql/timezone/Atlantic/Azores
+${PG_SUBPREFIX}share/postgresql/timezone/Atlantic/Bermuda
+${PG_SUBPREFIX}share/postgresql/timezone/Atlantic/Canary
+${PG_SUBPREFIX}share/postgresql/timezone/Atlantic/Cape_Verde
+${PG_SUBPREFIX}share/postgresql/timezone/Atlantic/Faeroe
+${PG_SUBPREFIX}share/postgresql/timezone/Atlantic/Faroe
+${PG_SUBPREFIX}share/postgresql/timezone/Atlantic/Jan_Mayen
+${PG_SUBPREFIX}share/postgresql/timezone/Atlantic/Madeira
+${PG_SUBPREFIX}share/postgresql/timezone/Atlantic/Reykjavik
+${PG_SUBPREFIX}share/postgresql/timezone/Atlantic/South_Georgia
+${PG_SUBPREFIX}share/postgresql/timezone/Atlantic/St_Helena
+${PG_SUBPREFIX}share/postgresql/timezone/Atlantic/Stanley
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/ACT
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/Adelaide
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/Brisbane
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/Broken_Hill
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/Canberra
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/Currie
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/Darwin
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/Eucla
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/Hobart
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/LHI
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/Lindeman
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/Lord_Howe
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/Melbourne
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/NSW
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/North
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/Perth
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/Queensland
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/South
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/Sydney
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/Tasmania
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/Victoria
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/West
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/Yancowinna
+${PG_SUBPREFIX}share/postgresql/timezone/Brazil/Acre
+${PG_SUBPREFIX}share/postgresql/timezone/Brazil/DeNoronha
+${PG_SUBPREFIX}share/postgresql/timezone/Brazil/East
+${PG_SUBPREFIX}share/postgresql/timezone/Brazil/West
+${PG_SUBPREFIX}share/postgresql/timezone/CET
+${PG_SUBPREFIX}share/postgresql/timezone/CST6CDT
+${PG_SUBPREFIX}share/postgresql/timezone/Canada/Atlantic
+${PG_SUBPREFIX}share/postgresql/timezone/Canada/Central
+${PG_SUBPREFIX}share/postgresql/timezone/Canada/East-Saskatchewan
+${PG_SUBPREFIX}share/postgresql/timezone/Canada/Eastern
+${PG_SUBPREFIX}share/postgresql/timezone/Canada/Mountain
+${PG_SUBPREFIX}share/postgresql/timezone/Canada/Newfoundland
+${PG_SUBPREFIX}share/postgresql/timezone/Canada/Pacific
+${PG_SUBPREFIX}share/postgresql/timezone/Canada/Saskatchewan
+${PG_SUBPREFIX}share/postgresql/timezone/Canada/Yukon
+${PG_SUBPREFIX}share/postgresql/timezone/Chile/Continental
+${PG_SUBPREFIX}share/postgresql/timezone/Chile/EasterIsland
+${PG_SUBPREFIX}share/postgresql/timezone/Cuba
+${PG_SUBPREFIX}share/postgresql/timezone/EET
+${PG_SUBPREFIX}share/postgresql/timezone/EST
+${PG_SUBPREFIX}share/postgresql/timezone/EST5EDT
+${PG_SUBPREFIX}share/postgresql/timezone/Egypt
+${PG_SUBPREFIX}share/postgresql/timezone/Eire
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT+0
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT+1
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT+10
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT+11
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT+12
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT+2
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT+3
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT+4
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT+5
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT+6
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT+7
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT+8
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT+9
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT-0
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT-1
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT-10
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT-11
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT-12
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT-13
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT-14
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT-2
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT-3
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT-4
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT-5
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT-6
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT-7
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT-8
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT-9
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/GMT0
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/Greenwich
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/UCT
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/UTC
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/Universal
+${PG_SUBPREFIX}share/postgresql/timezone/Etc/Zulu
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Amsterdam
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Andorra
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Athens
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Belfast
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Belgrade
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Berlin
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Bratislava
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Brussels
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Bucharest
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Budapest
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Chisinau
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Copenhagen
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Dublin
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Gibraltar
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Guernsey
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Helsinki
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Isle_of_Man
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Istanbul
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Jersey
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Kaliningrad
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Kiev
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Lisbon
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Ljubljana
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/London
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Luxembourg
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Madrid
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Malta
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Mariehamn
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Minsk
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Monaco
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Moscow
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Nicosia
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Oslo
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Paris
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Podgorica
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Prague
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Riga
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Rome
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Samara
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/San_Marino
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Sarajevo
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Simferopol
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Skopje
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Sofia
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Stockholm
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Tallinn
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Tirane
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Tiraspol
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Uzhgorod
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Vaduz
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Vatican
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Vienna
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Vilnius
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Volgograd
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Warsaw
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Zagreb
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Zaporozhye
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Zurich
+${PG_SUBPREFIX}share/postgresql/timezone/Factory
+${PG_SUBPREFIX}share/postgresql/timezone/GB
+${PG_SUBPREFIX}share/postgresql/timezone/GB-Eire
+${PG_SUBPREFIX}share/postgresql/timezone/GMT
+${PG_SUBPREFIX}share/postgresql/timezone/GMT+0
+${PG_SUBPREFIX}share/postgresql/timezone/GMT-0
+${PG_SUBPREFIX}share/postgresql/timezone/GMT0
+${PG_SUBPREFIX}share/postgresql/timezone/Greenwich
+${PG_SUBPREFIX}share/postgresql/timezone/HST
+${PG_SUBPREFIX}share/postgresql/timezone/Hongkong
+${PG_SUBPREFIX}share/postgresql/timezone/Iceland
+${PG_SUBPREFIX}share/postgresql/timezone/Indian/Antananarivo
+${PG_SUBPREFIX}share/postgresql/timezone/Indian/Chagos
+${PG_SUBPREFIX}share/postgresql/timezone/Indian/Christmas
+${PG_SUBPREFIX}share/postgresql/timezone/Indian/Cocos
+${PG_SUBPREFIX}share/postgresql/timezone/Indian/Comoro
+${PG_SUBPREFIX}share/postgresql/timezone/Indian/Kerguelen
+${PG_SUBPREFIX}share/postgresql/timezone/Indian/Mahe
+${PG_SUBPREFIX}share/postgresql/timezone/Indian/Maldives
+${PG_SUBPREFIX}share/postgresql/timezone/Indian/Mauritius
+${PG_SUBPREFIX}share/postgresql/timezone/Indian/Mayotte
+${PG_SUBPREFIX}share/postgresql/timezone/Indian/Reunion
+${PG_SUBPREFIX}share/postgresql/timezone/Iran
+${PG_SUBPREFIX}share/postgresql/timezone/Israel
+${PG_SUBPREFIX}share/postgresql/timezone/Jamaica
+${PG_SUBPREFIX}share/postgresql/timezone/Japan
+${PG_SUBPREFIX}share/postgresql/timezone/Kwajalein
+${PG_SUBPREFIX}share/postgresql/timezone/Libya
+${PG_SUBPREFIX}share/postgresql/timezone/MET
+${PG_SUBPREFIX}share/postgresql/timezone/MST
+${PG_SUBPREFIX}share/postgresql/timezone/MST7MDT
+${PG_SUBPREFIX}share/postgresql/timezone/Mexico/BajaNorte
+${PG_SUBPREFIX}share/postgresql/timezone/Mexico/BajaSur
+${PG_SUBPREFIX}share/postgresql/timezone/Mexico/General
+${PG_SUBPREFIX}share/postgresql/timezone/Mideast/Riyadh87
+${PG_SUBPREFIX}share/postgresql/timezone/Mideast/Riyadh88
+${PG_SUBPREFIX}share/postgresql/timezone/Mideast/Riyadh89
+${PG_SUBPREFIX}share/postgresql/timezone/NZ
+${PG_SUBPREFIX}share/postgresql/timezone/NZ-CHAT
+${PG_SUBPREFIX}share/postgresql/timezone/Navajo
+${PG_SUBPREFIX}share/postgresql/timezone/PRC
+${PG_SUBPREFIX}share/postgresql/timezone/PST8PDT
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Apia
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Auckland
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Chatham
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Chuuk
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Easter
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Efate
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Enderbury
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Fakaofo
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Fiji
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Funafuti
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Galapagos
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Gambier
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Guadalcanal
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Guam
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Honolulu
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Johnston
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Kiritimati
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Kosrae
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Kwajalein
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Majuro
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Marquesas
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Midway
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Nauru
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Niue
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Norfolk
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Noumea
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Pago_Pago
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Palau
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Pitcairn
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Pohnpei
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Ponape
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Port_Moresby
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Rarotonga
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Saipan
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Samoa
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Tahiti
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Tarawa
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Tongatapu
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Truk
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Wake
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Wallis
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Yap
+${PG_SUBPREFIX}share/postgresql/timezone/Poland
+${PG_SUBPREFIX}share/postgresql/timezone/Portugal
+${PG_SUBPREFIX}share/postgresql/timezone/ROC
+${PG_SUBPREFIX}share/postgresql/timezone/ROK
+${PG_SUBPREFIX}share/postgresql/timezone/Singapore
+${PG_SUBPREFIX}share/postgresql/timezone/Turkey
+${PG_SUBPREFIX}share/postgresql/timezone/UCT
+${PG_SUBPREFIX}share/postgresql/timezone/US/Alaska
+${PG_SUBPREFIX}share/postgresql/timezone/US/Aleutian
+${PG_SUBPREFIX}share/postgresql/timezone/US/Arizona
+${PG_SUBPREFIX}share/postgresql/timezone/US/Central
+${PG_SUBPREFIX}share/postgresql/timezone/US/East-Indiana
+${PG_SUBPREFIX}share/postgresql/timezone/US/Eastern
+${PG_SUBPREFIX}share/postgresql/timezone/US/Hawaii
+${PG_SUBPREFIX}share/postgresql/timezone/US/Indiana-Starke
+${PG_SUBPREFIX}share/postgresql/timezone/US/Michigan
+${PG_SUBPREFIX}share/postgresql/timezone/US/Mountain
+${PG_SUBPREFIX}share/postgresql/timezone/US/Pacific
+${PG_SUBPREFIX}share/postgresql/timezone/US/Pacific-New
+${PG_SUBPREFIX}share/postgresql/timezone/US/Samoa
+${PG_SUBPREFIX}share/postgresql/timezone/UTC
+${PG_SUBPREFIX}share/postgresql/timezone/Universal
+${PG_SUBPREFIX}share/postgresql/timezone/W-SU
+${PG_SUBPREFIX}share/postgresql/timezone/WET
+${PG_SUBPREFIX}share/postgresql/timezone/Zulu
+${PG_SUBPREFIX}share/postgresql/timezone/posixrules
+${PG_SUBPREFIX}share/postgresql/timezonesets/Africa.txt
+${PG_SUBPREFIX}share/postgresql/timezonesets/America.txt
+${PG_SUBPREFIX}share/postgresql/timezonesets/Antarctica.txt
+${PG_SUBPREFIX}share/postgresql/timezonesets/Asia.txt
+${PG_SUBPREFIX}share/postgresql/timezonesets/Atlantic.txt
+${PG_SUBPREFIX}share/postgresql/timezonesets/Australia
+${PG_SUBPREFIX}share/postgresql/timezonesets/Australia.txt
+${PG_SUBPREFIX}share/postgresql/timezonesets/Default
+${PG_SUBPREFIX}share/postgresql/timezonesets/Etc.txt
+${PG_SUBPREFIX}share/postgresql/timezonesets/Europe.txt
+${PG_SUBPREFIX}share/postgresql/timezonesets/India
+${PG_SUBPREFIX}share/postgresql/timezonesets/Indian.txt
+${PG_SUBPREFIX}share/postgresql/timezonesets/Pacific.txt
+${PG_SUBPREFIX}share/postgresql/tsearch_data/danish.stop
+${PG_SUBPREFIX}share/postgresql/tsearch_data/dutch.stop
+${PG_SUBPREFIX}share/postgresql/tsearch_data/english.stop
+${PG_SUBPREFIX}share/postgresql/tsearch_data/finnish.stop
+${PG_SUBPREFIX}share/postgresql/tsearch_data/french.stop
+${PG_SUBPREFIX}share/postgresql/tsearch_data/german.stop
+${PG_SUBPREFIX}share/postgresql/tsearch_data/hungarian.stop
+${PG_SUBPREFIX}share/postgresql/tsearch_data/hunspell_sample.affix
+${PG_SUBPREFIX}share/postgresql/tsearch_data/ispell_sample.affix
+${PG_SUBPREFIX}share/postgresql/tsearch_data/ispell_sample.dict
+${PG_SUBPREFIX}share/postgresql/tsearch_data/italian.stop
+${PG_SUBPREFIX}share/postgresql/tsearch_data/norwegian.stop
+${PG_SUBPREFIX}share/postgresql/tsearch_data/portuguese.stop
+${PG_SUBPREFIX}share/postgresql/tsearch_data/russian.stop
+${PG_SUBPREFIX}share/postgresql/tsearch_data/spanish.stop
+${PG_SUBPREFIX}share/postgresql/tsearch_data/swedish.stop
+${PG_SUBPREFIX}share/postgresql/tsearch_data/synonym_sample.syn
+${PG_SUBPREFIX}share/postgresql/tsearch_data/thesaurus_sample.ths
+${PG_SUBPREFIX}share/postgresql/tsearch_data/turkish.stop
diff --git a/databases/postgresql90-server/files/pgsql.sh b/databases/postgresql90-server/files/pgsql.sh
new file mode 100644
index 00000000000..812b24e5228
--- /dev/null
+++ b/databases/postgresql90-server/files/pgsql.sh
@@ -0,0 +1,148 @@
+#!@RCD_SCRIPTS_SHELL@
+#
+# $NetBSD: pgsql.sh,v 1.1.1.1 2010/09/21 07:52:57 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
+#
+# The following variables are optional:
+#
+#	pgsql_flags="-i"		# allows TCP/IP connections
+#	pgsql_flags="-i -l"		# enables SSL connections
+#	pgsql_home="/path/to/home"	# path to pgsql database directory
+#
+# "pgsql_flags" contains options for the PostgreSQL postmaster.  See
+# postmaster(1) for possible options.
+
+if [ -f /etc/rc.subr ]; then
+	. /etc/rc.subr
+fi
+
+name="pgsql"
+rcvar=$name
+pgsql_user="@PGUSER@"
+pgsql_group="@PGGROUP@"
+eval pgsql_home="~$pgsql_user"
+
+command="@PG_PREFIX@/bin/postmaster"
+ctl_command="@PG_PREFIX@/bin/pg_ctl"
+extra_commands="initdb"
+
+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
+
+pidfile="${pgsql_home}/data/postmaster.pid"
+common_args="-D ${pgsql_home}/data -m fast"
+start_command_args="-w -s -l ${pgsql_home}/errlog"
+stop_command_args="-s"
+
+initdb_cmd="pgsql_initdb"
+start_precmd="pgsql_precmd"
+start_cmd="pgsql_doit start"
+restart_cmd="pgsql_doit restart"
+stop_cmd="pgsql_doit stop"
+
+ulimit -n 4096
+
+pgsql_precmd()
+{
+	if [ ! -d ${pgsql_home}/data/base ]; then
+		pgsql_initdb
+	fi
+}
+
+pgsql_initdb()
+{
+	initdb="@PG_PREFIX@/bin/initdb"
+
+	cd /
+
+	if [ ! -x ${initdb} ]; then
+		return 1
+	fi
+	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@ 0750 ${pgsql_home}
+		common_args_without_m=$(echo "${common_args}" |\
+		    sed -e 's/-m [a-z]*//')
+		eval doit_command=\"${initdb} ${common_args_without_m} ${flags}\"
+		doit="@SU@ -m ${pgsql_user} -c '${doit_command}'"
+		eval $doit
+	fi
+}
+
+pgsql_doit()
+{
+	action=$1
+
+	cd /
+
+	case ${action} in
+	start|restart)
+		if [ -n "${pgsql_flags}" ]; then
+			start_command_args="${start_command_args} -o \\\"${pgsql_flags}\\\""
+		fi
+		command_args="${common_args} ${start_command_args} ${command_args}"
+		;;
+	stop)
+		command_args="${common_args} ${stop_command_args} ${command_args}"
+		;;
+	*)
+		command_args="${common_args} ${command_args}"
+		;;
+	esac
+
+	if [ ! -x ${ctl_command} ]; then
+		return
+	fi
+
+	case ${action} in
+	start)		@ECHO@ "Starting ${name}." ;;
+	stop)		@ECHO@ "Stopping ${name}." ;;
+	restart)	@ECHO@ "Restarting ${name}." ;;
+	esac
+
+	eval doit_command=\"${ctl_command} ${action} ${command_args}\"
+	doit="@SU@ -m ${pgsql_user} -c '${doit_command}'"
+	eval $doit
+}
+
+if [ -f /etc/rc.subr -a -d /etc/rc.d -a -f /etc/rc.d/DAEMON ]; then
+	load_rc_config $name
+	run_rc_command "$1"
+else
+	if [ -f /etc/rc.conf ]; then
+		. /etc/rc.conf
+	fi
+	case "$1" in
+	initdb)
+		eval ${initdb_cmd}
+		;;
+	restart)
+		eval ${restart_cmd}
+		;;
+	stop)
+		eval ${stop_cmd}
+		;;
+	*)
+		eval ${start_precmd}
+		eval ${start_cmd}
+		;;
+	esac
+fi