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