diff options
author | adam <adam@pkgsrc.org> | 2010-09-21 07:50:46 +0000 |
---|---|---|
committer | adam <adam@pkgsrc.org> | 2010-09-21 07:50:46 +0000 |
commit | d46e5d2c7b793bbf28dedca4777dbd74627f6b25 (patch) | |
tree | 2a323a1ea4c22dc1a1f0edc90da03a9c7e5794d3 /databases/postgresql90-server | |
parent | 211243911f23bb6156d277d4ae47e2d39b5994e7 (diff) | |
download | pkgsrc-d46e5d2c7b793bbf28dedca4777dbd74627f6b25.tar.gz |
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.
Diffstat (limited to 'databases/postgresql90-server')
-rw-r--r-- | databases/postgresql90-server/DEINSTALL | 20 | ||||
-rw-r--r-- | databases/postgresql90-server/DESCR | 9 | ||||
-rw-r--r-- | databases/postgresql90-server/MESSAGE | 18 | ||||
-rw-r--r-- | databases/postgresql90-server/Makefile | 88 | ||||
-rw-r--r-- | databases/postgresql90-server/PLIST | 665 | ||||
-rw-r--r-- | databases/postgresql90-server/files/pgsql.sh | 148 |
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 |