[Midnightbsd-cvs] mports: mports/databases: add postgres 8.3 for people who like that sort

laffer1 at midnightbsd.org laffer1 at midnightbsd.org
Sat Mar 14 11:03:08 EDT 2009


Log Message:
-----------
add postgres 8.3 for people who like that sort of thing :)

Modified Files:
--------------
    mports/databases:
        Makefile (r1.70 -> r1.71)

Added Files:
-----------
    mports/databases/postgresql83-client:
        Makefile (r1.1)
    mports/databases/postgresql83-server:
        Makefile (r1.1)
        distinfo (r1.1)
        pkg-descr (r1.1)
        pkg-install-server (r1.1)
        pkg-plist (r1.1)
        pkg-plist-client (r1.1)
        pkg-plist-contrib (r1.1)
        pkg-plist-plperl (r1.1)
        pkg-plist-plpython (r1.1)
        pkg-plist-pltcl (r1.1)
        pkg-plist-server (r1.1)
    mports/databases/postgresql83-server/files:
        502.pgsql (r1.1)
        dot.cshrc.in (r1.1)
        dot.profile.in (r1.1)
        patch-doc-Makefile (r1.1)
        patch-plpython-Makefile (r1.1)
        patch-src-makefiles-Makefile.freebsd (r1.1)
        patch-src:backend:utils:misc:postgresql.conf.sample (r1.1)
        pkg-message-client.in (r1.1)
        pkg-message-contrib.in (r1.1)
        pkg-message-plperl.in (r1.1)
        pkg-message-plpython.in (r1.1)
        pkg-message-pltcl.in (r1.1)
        pkg-message-server.in (r1.1)
        pkgIndex.tcl.in (r1.1)
        postgresql.in (r1.1)

-------------- next part --------------
Index: Makefile
===================================================================
RCS file: /home/cvs/mports/databases/Makefile,v
retrieving revision 1.70
retrieving revision 1.71
diff -L databases/Makefile -L databases/Makefile -u -r1.70 -r1.71
--- databases/Makefile
+++ databases/Makefile
@@ -84,6 +84,8 @@
     SUBDIR += postgresql-plruby
     SUBDIR += postgresql82-client
     SUBDIR += postgresql82-server
+    SUBDIR += postgresql83-client
+    SUBDIR += postgresql83-server
     SUBDIR += py-MySQLdb
     SUBDIR += py-gdbm
     SUBDIR += qdbm
--- /dev/null
+++ databases/postgresql83-client/Makefile
@@ -0,0 +1,17 @@
+# $MidnightBSD: mports/databases/postgresql83-client/Makefile,v 1.1 2009/03/14 15:03:05 laffer1 Exp $
+# To depend on postgresql-client, set USE_PGSQL=yes.
+
+PORTNAME=	postgresql
+PKGNAMESUFFIX=	-client
+
+COMMENT=	PostgreSQL database (client)
+
+MASTERDIR=	${.CURDIR}/../postgresql83-server
+
+BUILD_DIRS=	config src/include src/interfaces \
+		src/bin/pg_dump src/bin/psql src/bin/scripts src/bin/pg_config \
+		doc src/makefiles
+CLIENT_ONLY=	yes
+USE_LDCONFIG=	yes
+
+.include "${MASTERDIR}/Makefile"
--- /dev/null
+++ databases/postgresql83-server/pkg-plist-server
@@ -0,0 +1,771 @@
+bin/initdb
+bin/ipcclean
+bin/pg_controldata
+bin/pg_ctl
+bin/pg_resetxlog
+bin/postmaster
+bin/postgres
+etc/periodic/daily/502.pgsql
+lib/libpgport.a
+lib/postgresql/ascii_and_mic.so
+lib/postgresql/cyrillic_and_mic.so
+lib/postgresql/dict_snowball.so
+lib/postgresql/euc_cn_and_mic.so
+lib/postgresql/euc_jis_2004_and_shift_jis_2004.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/plpgsql.so
+lib/postgresql/utf8_and_ascii.so
+lib/postgresql/utf8_and_big5.so
+lib/postgresql/utf8_and_cyrillic.so
+lib/postgresql/utf8_and_euc_cn.so
+lib/postgresql/utf8_and_euc_jis_2004.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_shift_jis_2004.so
+lib/postgresql/utf8_and_sjis.so
+lib/postgresql/utf8_and_uhc.so
+lib/postgresql/utf8_and_win.so
+%%DOCSDIR%%/README-server
+ at dirrmtry %%DOCSDIR%%
+share/postgresql/conversion_create.sql
+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/postgresql.conf.sample
+share/postgresql/recovery.conf.sample
+share/postgresql/sql_features.txt
+share/postgresql/system_views.sql
+%%GETTEXT%%share/locale/af/LC_MESSAGES/postgres.mo
+%%GETTEXT%%share/locale/cs/LC_MESSAGES/initdb.mo
+%%GETTEXT%%share/locale/cs/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/cs/LC_MESSAGES/pg_ctl.mo
+%%GETTEXT%%share/locale/cs/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/cs/LC_MESSAGES/postgres.mo
+%%GETTEXT%%share/locale/de/LC_MESSAGES/initdb.mo
+%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_ctl.mo
+%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/de/LC_MESSAGES/postgres.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/initdb.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_ctl.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/postgres.mo
+%%GETTEXT%%share/locale/fa/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/fr/LC_MESSAGES/initdb.mo
+%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_ctl.mo
+%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/fr/LC_MESSAGES/postgres.mo
+%%GETTEXT%%share/locale/hr/LC_MESSAGES/postgres.mo
+%%GETTEXT%%share/locale/hu/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/hu/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/hu/LC_MESSAGES/postgres.mo
+%%GETTEXT%%share/locale/it/LC_MESSAGES/initdb.mo
+%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/it/LC_MESSAGES/postgres.mo
+%%GETTEXT%%share/locale/ko/LC_MESSAGES/initdb.mo
+%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_ctl.mo
+%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/ko/LC_MESSAGES/postgres.mo
+%%GETTEXT%%share/locale/nb/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/nb/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/nb/LC_MESSAGES/postgres.mo
+%%GETTEXT%%share/locale/nl/LC_MESSAGES/postgres.mo
+%%GETTEXT%%share/locale/pl/LC_MESSAGES/initdb.mo
+%%GETTEXT%%share/locale/pl/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/pl/LC_MESSAGES/postgres.mo
+%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/initdb.mo
+%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_ctl.mo
+%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/postgres.mo
+%%GETTEXT%%share/locale/ro/LC_MESSAGES/initdb.mo
+%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_ctl.mo
+%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/ro/LC_MESSAGES/postgres.mo
+%%GETTEXT%%share/locale/ru/LC_MESSAGES/initdb.mo
+%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_ctl.mo
+%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/ru/LC_MESSAGES/postgres.mo
+%%GETTEXT%%share/locale/sk/LC_MESSAGES/initdb.mo
+%%GETTEXT%%share/locale/sk/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/sk/LC_MESSAGES/pg_ctl.mo
+%%GETTEXT%%share/locale/sk/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/sk/LC_MESSAGES/postgres.mo
+%%GETTEXT%%share/locale/sl/LC_MESSAGES/initdb.mo
+%%GETTEXT%%share/locale/sl/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/sl/LC_MESSAGES/pg_ctl.mo
+%%GETTEXT%%share/locale/sl/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/sl/LC_MESSAGES/postgres.mo
+%%GETTEXT%%share/locale/sv/LC_MESSAGES/initdb.mo
+%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_ctl.mo
+%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/sv/LC_MESSAGES/postgres.mo
+%%GETTEXT%%share/locale/ta/LC_MESSAGES/initdb.mo
+%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_ctl.mo
+%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/tr/LC_MESSAGES/initdb.mo
+%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_ctl.mo
+%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/tr/LC_MESSAGES/postgres.mo
+%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/initdb.mo
+%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_ctl.mo
+%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/postgres.mo
+%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/initdb.mo
+%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/pg_ctl.mo
+%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/postgres.mo
+share/postgresql/postgres.shdescription
+share/postgresql/snowball_create.sql
+%%TZDATA%%share/postgresql/timezone/Africa/Abidjan
+%%TZDATA%%share/postgresql/timezone/Africa/Accra
+%%TZDATA%%share/postgresql/timezone/Africa/Addis_Ababa
+%%TZDATA%%share/postgresql/timezone/Africa/Algiers
+%%TZDATA%%share/postgresql/timezone/Africa/Asmara
+%%TZDATA%%share/postgresql/timezone/Africa/Asmera
+%%TZDATA%%share/postgresql/timezone/Africa/Bamako
+%%TZDATA%%share/postgresql/timezone/Africa/Bangui
+%%TZDATA%%share/postgresql/timezone/Africa/Banjul
+%%TZDATA%%share/postgresql/timezone/Africa/Bissau
+%%TZDATA%%share/postgresql/timezone/Africa/Blantyre
+%%TZDATA%%share/postgresql/timezone/Africa/Brazzaville
+%%TZDATA%%share/postgresql/timezone/Africa/Bujumbura
+%%TZDATA%%share/postgresql/timezone/Africa/Cairo
+%%TZDATA%%share/postgresql/timezone/Africa/Casablanca
+%%TZDATA%%share/postgresql/timezone/Africa/Ceuta
+%%TZDATA%%share/postgresql/timezone/Africa/Conakry
+%%TZDATA%%share/postgresql/timezone/Africa/Dakar
+%%TZDATA%%share/postgresql/timezone/Africa/Dar_es_Salaam
+%%TZDATA%%share/postgresql/timezone/Africa/Djibouti
+%%TZDATA%%share/postgresql/timezone/Africa/Douala
+%%TZDATA%%share/postgresql/timezone/Africa/El_Aaiun
+%%TZDATA%%share/postgresql/timezone/Africa/Freetown
+%%TZDATA%%share/postgresql/timezone/Africa/Gaborone
+%%TZDATA%%share/postgresql/timezone/Africa/Harare
+%%TZDATA%%share/postgresql/timezone/Africa/Johannesburg
+%%TZDATA%%share/postgresql/timezone/Africa/Kampala
+%%TZDATA%%share/postgresql/timezone/Africa/Khartoum
+%%TZDATA%%share/postgresql/timezone/Africa/Kigali
+%%TZDATA%%share/postgresql/timezone/Africa/Kinshasa
+%%TZDATA%%share/postgresql/timezone/Africa/Lagos
+%%TZDATA%%share/postgresql/timezone/Africa/Libreville
+%%TZDATA%%share/postgresql/timezone/Africa/Lome
+%%TZDATA%%share/postgresql/timezone/Africa/Luanda
+%%TZDATA%%share/postgresql/timezone/Africa/Lubumbashi
+%%TZDATA%%share/postgresql/timezone/Africa/Lusaka
+%%TZDATA%%share/postgresql/timezone/Africa/Malabo
+%%TZDATA%%share/postgresql/timezone/Africa/Maputo
+%%TZDATA%%share/postgresql/timezone/Africa/Maseru
+%%TZDATA%%share/postgresql/timezone/Africa/Mbabane
+%%TZDATA%%share/postgresql/timezone/Africa/Mogadishu
+%%TZDATA%%share/postgresql/timezone/Africa/Monrovia
+%%TZDATA%%share/postgresql/timezone/Africa/Nairobi
+%%TZDATA%%share/postgresql/timezone/Africa/Ndjamena
+%%TZDATA%%share/postgresql/timezone/Africa/Niamey
+%%TZDATA%%share/postgresql/timezone/Africa/Nouakchott
+%%TZDATA%%share/postgresql/timezone/Africa/Ouagadougou
+%%TZDATA%%share/postgresql/timezone/Africa/Porto-Novo
+%%TZDATA%%share/postgresql/timezone/Africa/Sao_Tome
+%%TZDATA%%share/postgresql/timezone/Africa/Timbuktu
+%%TZDATA%%share/postgresql/timezone/Africa/Tripoli
+%%TZDATA%%share/postgresql/timezone/Africa/Tunis
+%%TZDATA%%share/postgresql/timezone/Africa/Windhoek
+%%TZDATA%%share/postgresql/timezone/America/Adak
+%%TZDATA%%share/postgresql/timezone/America/Anchorage
+%%TZDATA%%share/postgresql/timezone/America/Anguilla
+%%TZDATA%%share/postgresql/timezone/America/Antigua
+%%TZDATA%%share/postgresql/timezone/America/Araguaina
+%%TZDATA%%share/postgresql/timezone/America/Argentina/Buenos_Aires
+%%TZDATA%%share/postgresql/timezone/America/Argentina/Catamarca
+%%TZDATA%%share/postgresql/timezone/America/Argentina/ComodRivadavia
+%%TZDATA%%share/postgresql/timezone/America/Argentina/Cordoba
+%%TZDATA%%share/postgresql/timezone/America/Argentina/Jujuy
+%%TZDATA%%share/postgresql/timezone/America/Argentina/La_Rioja
+%%TZDATA%%share/postgresql/timezone/America/Argentina/Mendoza
+%%TZDATA%%share/postgresql/timezone/America/Argentina/Rio_Gallegos
+%%TZDATA%%share/postgresql/timezone/America/Argentina/Salta
+%%TZDATA%%share/postgresql/timezone/America/Argentina/San_Juan
+%%TZDATA%%share/postgresql/timezone/America/Argentina/San_Luis
+%%TZDATA%%share/postgresql/timezone/America/Argentina/Tucuman
+%%TZDATA%%share/postgresql/timezone/America/Argentina/Ushuaia
+%%TZDATA%%share/postgresql/timezone/America/Aruba
+%%TZDATA%%share/postgresql/timezone/America/Asuncion
+%%TZDATA%%share/postgresql/timezone/America/Atikokan
+%%TZDATA%%share/postgresql/timezone/America/Atka
+%%TZDATA%%share/postgresql/timezone/America/Bahia
+%%TZDATA%%share/postgresql/timezone/America/Barbados
+%%TZDATA%%share/postgresql/timezone/America/Belem
+%%TZDATA%%share/postgresql/timezone/America/Belize
+%%TZDATA%%share/postgresql/timezone/America/Blanc-Sablon
+%%TZDATA%%share/postgresql/timezone/America/Boa_Vista
+%%TZDATA%%share/postgresql/timezone/America/Bogota
+%%TZDATA%%share/postgresql/timezone/America/Boise
+%%TZDATA%%share/postgresql/timezone/America/Buenos_Aires
+%%TZDATA%%share/postgresql/timezone/America/Cambridge_Bay
+%%TZDATA%%share/postgresql/timezone/America/Campo_Grande
+%%TZDATA%%share/postgresql/timezone/America/Cancun
+%%TZDATA%%share/postgresql/timezone/America/Caracas
+%%TZDATA%%share/postgresql/timezone/America/Catamarca
+%%TZDATA%%share/postgresql/timezone/America/Cayenne
+%%TZDATA%%share/postgresql/timezone/America/Cayman
+%%TZDATA%%share/postgresql/timezone/America/Chicago
+%%TZDATA%%share/postgresql/timezone/America/Chihuahua
+%%TZDATA%%share/postgresql/timezone/America/Coral_Harbour
+%%TZDATA%%share/postgresql/timezone/America/Cordoba
+%%TZDATA%%share/postgresql/timezone/America/Costa_Rica
+%%TZDATA%%share/postgresql/timezone/America/Cuiaba
+%%TZDATA%%share/postgresql/timezone/America/Curacao
+%%TZDATA%%share/postgresql/timezone/America/Danmarkshavn
+%%TZDATA%%share/postgresql/timezone/America/Dawson
+%%TZDATA%%share/postgresql/timezone/America/Dawson_Creek
+%%TZDATA%%share/postgresql/timezone/America/Denver
+%%TZDATA%%share/postgresql/timezone/America/Detroit
+%%TZDATA%%share/postgresql/timezone/America/Dominica
+%%TZDATA%%share/postgresql/timezone/America/Edmonton
+%%TZDATA%%share/postgresql/timezone/America/Eirunepe
+%%TZDATA%%share/postgresql/timezone/America/El_Salvador
+%%TZDATA%%share/postgresql/timezone/America/Ensenada
+%%TZDATA%%share/postgresql/timezone/America/Fort_Wayne
+%%TZDATA%%share/postgresql/timezone/America/Fortaleza
+%%TZDATA%%share/postgresql/timezone/America/Glace_Bay
+%%TZDATA%%share/postgresql/timezone/America/Godthab
+%%TZDATA%%share/postgresql/timezone/America/Goose_Bay
+%%TZDATA%%share/postgresql/timezone/America/Grand_Turk
+%%TZDATA%%share/postgresql/timezone/America/Grenada
+%%TZDATA%%share/postgresql/timezone/America/Guadeloupe
+%%TZDATA%%share/postgresql/timezone/America/Guatemala
+%%TZDATA%%share/postgresql/timezone/America/Guayaquil
+%%TZDATA%%share/postgresql/timezone/America/Guyana
+%%TZDATA%%share/postgresql/timezone/America/Halifax
+%%TZDATA%%share/postgresql/timezone/America/Havana
+%%TZDATA%%share/postgresql/timezone/America/Hermosillo
+%%TZDATA%%share/postgresql/timezone/America/Indiana/Indianapolis
+%%TZDATA%%share/postgresql/timezone/America/Indiana/Knox
+%%TZDATA%%share/postgresql/timezone/America/Indiana/Marengo
+%%TZDATA%%share/postgresql/timezone/America/Indiana/Petersburg
+%%TZDATA%%share/postgresql/timezone/America/Indiana/Tell_City
+%%TZDATA%%share/postgresql/timezone/America/Indiana/Vevay
+%%TZDATA%%share/postgresql/timezone/America/Indiana/Vincennes
+%%TZDATA%%share/postgresql/timezone/America/Indiana/Winamac
+%%TZDATA%%share/postgresql/timezone/America/Indianapolis
+%%TZDATA%%share/postgresql/timezone/America/Inuvik
+%%TZDATA%%share/postgresql/timezone/America/Iqaluit
+%%TZDATA%%share/postgresql/timezone/America/Jamaica
+%%TZDATA%%share/postgresql/timezone/America/Jujuy
+%%TZDATA%%share/postgresql/timezone/America/Juneau
+%%TZDATA%%share/postgresql/timezone/America/Kentucky/Louisville
+%%TZDATA%%share/postgresql/timezone/America/Kentucky/Monticello
+%%TZDATA%%share/postgresql/timezone/America/Knox_IN
+%%TZDATA%%share/postgresql/timezone/America/La_Paz
+%%TZDATA%%share/postgresql/timezone/America/Lima
+%%TZDATA%%share/postgresql/timezone/America/Los_Angeles
+%%TZDATA%%share/postgresql/timezone/America/Louisville
+%%TZDATA%%share/postgresql/timezone/America/Maceio
+%%TZDATA%%share/postgresql/timezone/America/Managua
+%%TZDATA%%share/postgresql/timezone/America/Manaus
+%%TZDATA%%share/postgresql/timezone/America/Marigot
+%%TZDATA%%share/postgresql/timezone/America/Martinique
+%%TZDATA%%share/postgresql/timezone/America/Mazatlan
+%%TZDATA%%share/postgresql/timezone/America/Mendoza
+%%TZDATA%%share/postgresql/timezone/America/Menominee
+%%TZDATA%%share/postgresql/timezone/America/Merida
+%%TZDATA%%share/postgresql/timezone/America/Mexico_City
+%%TZDATA%%share/postgresql/timezone/America/Miquelon
+%%TZDATA%%share/postgresql/timezone/America/Moncton
+%%TZDATA%%share/postgresql/timezone/America/Monterrey
+%%TZDATA%%share/postgresql/timezone/America/Montevideo
+%%TZDATA%%share/postgresql/timezone/America/Montreal
+%%TZDATA%%share/postgresql/timezone/America/Montserrat
+%%TZDATA%%share/postgresql/timezone/America/Nassau
+%%TZDATA%%share/postgresql/timezone/America/New_York
+%%TZDATA%%share/postgresql/timezone/America/Nipigon
+%%TZDATA%%share/postgresql/timezone/America/Nome
+%%TZDATA%%share/postgresql/timezone/America/Noronha
+%%TZDATA%%share/postgresql/timezone/America/North_Dakota/Center
+%%TZDATA%%share/postgresql/timezone/America/North_Dakota/New_Salem
+%%TZDATA%%share/postgresql/timezone/America/Panama
+%%TZDATA%%share/postgresql/timezone/America/Pangnirtung
+%%TZDATA%%share/postgresql/timezone/America/Paramaribo
+%%TZDATA%%share/postgresql/timezone/America/Phoenix
+%%TZDATA%%share/postgresql/timezone/America/Port-au-Prince
+%%TZDATA%%share/postgresql/timezone/America/Port_of_Spain
+%%TZDATA%%share/postgresql/timezone/America/Porto_Acre
+%%TZDATA%%share/postgresql/timezone/America/Porto_Velho
+%%TZDATA%%share/postgresql/timezone/America/Puerto_Rico
+%%TZDATA%%share/postgresql/timezone/America/Rainy_River
+%%TZDATA%%share/postgresql/timezone/America/Rankin_Inlet
+%%TZDATA%%share/postgresql/timezone/America/Recife
+%%TZDATA%%share/postgresql/timezone/America/Regina
+%%TZDATA%%share/postgresql/timezone/America/Resolute
+%%TZDATA%%share/postgresql/timezone/America/Rio_Branco
+%%TZDATA%%share/postgresql/timezone/America/Rosario
+%%TZDATA%%share/postgresql/timezone/America/Santarem
+%%TZDATA%%share/postgresql/timezone/America/Santiago
+%%TZDATA%%share/postgresql/timezone/America/Santo_Domingo
+%%TZDATA%%share/postgresql/timezone/America/Sao_Paulo
+%%TZDATA%%share/postgresql/timezone/America/Scoresbysund
+%%TZDATA%%share/postgresql/timezone/America/Shiprock
+%%TZDATA%%share/postgresql/timezone/America/St_Barthelemy
+%%TZDATA%%share/postgresql/timezone/America/St_Johns
+%%TZDATA%%share/postgresql/timezone/America/St_Kitts
+%%TZDATA%%share/postgresql/timezone/America/St_Lucia
+%%TZDATA%%share/postgresql/timezone/America/St_Thomas
+%%TZDATA%%share/postgresql/timezone/America/St_Vincent
+%%TZDATA%%share/postgresql/timezone/America/Swift_Current
+%%TZDATA%%share/postgresql/timezone/America/Tegucigalpa
+%%TZDATA%%share/postgresql/timezone/America/Thule
+%%TZDATA%%share/postgresql/timezone/America/Thunder_Bay
+%%TZDATA%%share/postgresql/timezone/America/Tijuana
+%%TZDATA%%share/postgresql/timezone/America/Toronto
+%%TZDATA%%share/postgresql/timezone/America/Tortola
+%%TZDATA%%share/postgresql/timezone/America/Vancouver
+%%TZDATA%%share/postgresql/timezone/America/Virgin
+%%TZDATA%%share/postgresql/timezone/America/Whitehorse
+%%TZDATA%%share/postgresql/timezone/America/Winnipeg
+%%TZDATA%%share/postgresql/timezone/America/Yakutat
+%%TZDATA%%share/postgresql/timezone/America/Yellowknife
+%%TZDATA%%share/postgresql/timezone/Antarctica/Casey
+%%TZDATA%%share/postgresql/timezone/Antarctica/Davis
+%%TZDATA%%share/postgresql/timezone/Antarctica/DumontDUrville
+%%TZDATA%%share/postgresql/timezone/Antarctica/Mawson
+%%TZDATA%%share/postgresql/timezone/Antarctica/McMurdo
+%%TZDATA%%share/postgresql/timezone/Antarctica/Palmer
+%%TZDATA%%share/postgresql/timezone/Antarctica/Rothera
+%%TZDATA%%share/postgresql/timezone/Antarctica/South_Pole
+%%TZDATA%%share/postgresql/timezone/Antarctica/Syowa
+%%TZDATA%%share/postgresql/timezone/Antarctica/Vostok
+%%TZDATA%%share/postgresql/timezone/Arctic/Longyearbyen
+%%TZDATA%%share/postgresql/timezone/Asia/Aden
+%%TZDATA%%share/postgresql/timezone/Asia/Almaty
+%%TZDATA%%share/postgresql/timezone/Asia/Amman
+%%TZDATA%%share/postgresql/timezone/Asia/Anadyr
+%%TZDATA%%share/postgresql/timezone/Asia/Aqtau
+%%TZDATA%%share/postgresql/timezone/Asia/Aqtobe
+%%TZDATA%%share/postgresql/timezone/Asia/Ashgabat
+%%TZDATA%%share/postgresql/timezone/Asia/Ashkhabad
+%%TZDATA%%share/postgresql/timezone/Asia/Baghdad
+%%TZDATA%%share/postgresql/timezone/Asia/Bahrain
+%%TZDATA%%share/postgresql/timezone/Asia/Baku
+%%TZDATA%%share/postgresql/timezone/Asia/Bangkok
+%%TZDATA%%share/postgresql/timezone/Asia/Beirut
+%%TZDATA%%share/postgresql/timezone/Asia/Bishkek
+%%TZDATA%%share/postgresql/timezone/Asia/Brunei
+%%TZDATA%%share/postgresql/timezone/Asia/Calcutta
+%%TZDATA%%share/postgresql/timezone/Asia/Choibalsan
+%%TZDATA%%share/postgresql/timezone/Asia/Chongqing
+%%TZDATA%%share/postgresql/timezone/Asia/Chungking
+%%TZDATA%%share/postgresql/timezone/Asia/Colombo
+%%TZDATA%%share/postgresql/timezone/Asia/Dacca
+%%TZDATA%%share/postgresql/timezone/Asia/Damascus
+%%TZDATA%%share/postgresql/timezone/Asia/Dhaka
+%%TZDATA%%share/postgresql/timezone/Asia/Dili
+%%TZDATA%%share/postgresql/timezone/Asia/Dubai
+%%TZDATA%%share/postgresql/timezone/Asia/Dushanbe
+%%TZDATA%%share/postgresql/timezone/Asia/Gaza
+%%TZDATA%%share/postgresql/timezone/Asia/Harbin
+%%TZDATA%%share/postgresql/timezone/Asia/Ho_Chi_Minh
+%%TZDATA%%share/postgresql/timezone/Asia/Hong_Kong
+%%TZDATA%%share/postgresql/timezone/Asia/Hovd
+%%TZDATA%%share/postgresql/timezone/Asia/Irkutsk
+%%TZDATA%%share/postgresql/timezone/Asia/Istanbul
+%%TZDATA%%share/postgresql/timezone/Asia/Jakarta
+%%TZDATA%%share/postgresql/timezone/Asia/Jayapura
+%%TZDATA%%share/postgresql/timezone/Asia/Jerusalem
+%%TZDATA%%share/postgresql/timezone/Asia/Kabul
+%%TZDATA%%share/postgresql/timezone/Asia/Kamchatka
+%%TZDATA%%share/postgresql/timezone/Asia/Karachi
+%%TZDATA%%share/postgresql/timezone/Asia/Kashgar
+%%TZDATA%%share/postgresql/timezone/Asia/Kathmandu
+%%TZDATA%%share/postgresql/timezone/Asia/Katmandu
+%%TZDATA%%share/postgresql/timezone/Asia/Kolkata
+%%TZDATA%%share/postgresql/timezone/Asia/Krasnoyarsk
+%%TZDATA%%share/postgresql/timezone/Asia/Kuala_Lumpur
+%%TZDATA%%share/postgresql/timezone/Asia/Kuching
+%%TZDATA%%share/postgresql/timezone/Asia/Kuwait
+%%TZDATA%%share/postgresql/timezone/Asia/Macao
+%%TZDATA%%share/postgresql/timezone/Asia/Macau
+%%TZDATA%%share/postgresql/timezone/Asia/Magadan
+%%TZDATA%%share/postgresql/timezone/Asia/Makassar
+%%TZDATA%%share/postgresql/timezone/Asia/Manila
+%%TZDATA%%share/postgresql/timezone/Asia/Muscat
+%%TZDATA%%share/postgresql/timezone/Asia/Nicosia
+%%TZDATA%%share/postgresql/timezone/Asia/Novosibirsk
+%%TZDATA%%share/postgresql/timezone/Asia/Omsk
+%%TZDATA%%share/postgresql/timezone/Asia/Oral
+%%TZDATA%%share/postgresql/timezone/Asia/Phnom_Penh
+%%TZDATA%%share/postgresql/timezone/Asia/Pontianak
+%%TZDATA%%share/postgresql/timezone/Asia/Pyongyang
+%%TZDATA%%share/postgresql/timezone/Asia/Qatar
+%%TZDATA%%share/postgresql/timezone/Asia/Qyzylorda
+%%TZDATA%%share/postgresql/timezone/Asia/Rangoon
+%%TZDATA%%share/postgresql/timezone/Asia/Riyadh
+%%TZDATA%%share/postgresql/timezone/Asia/Riyadh87
+%%TZDATA%%share/postgresql/timezone/Asia/Riyadh88
+%%TZDATA%%share/postgresql/timezone/Asia/Riyadh89
+%%TZDATA%%share/postgresql/timezone/Asia/Saigon
+%%TZDATA%%share/postgresql/timezone/Asia/Sakhalin
+%%TZDATA%%share/postgresql/timezone/Asia/Samarkand
+%%TZDATA%%share/postgresql/timezone/Asia/Seoul
+%%TZDATA%%share/postgresql/timezone/Asia/Shanghai
+%%TZDATA%%share/postgresql/timezone/Asia/Singapore
+%%TZDATA%%share/postgresql/timezone/Asia/Taipei
+%%TZDATA%%share/postgresql/timezone/Asia/Tashkent
+%%TZDATA%%share/postgresql/timezone/Asia/Tbilisi
+%%TZDATA%%share/postgresql/timezone/Asia/Tehran
+%%TZDATA%%share/postgresql/timezone/Asia/Tel_Aviv
+%%TZDATA%%share/postgresql/timezone/Asia/Thimbu
+%%TZDATA%%share/postgresql/timezone/Asia/Thimphu
+%%TZDATA%%share/postgresql/timezone/Asia/Tokyo
+%%TZDATA%%share/postgresql/timezone/Asia/Ujung_Pandang
+%%TZDATA%%share/postgresql/timezone/Asia/Ulaanbaatar
+%%TZDATA%%share/postgresql/timezone/Asia/Ulan_Bator
+%%TZDATA%%share/postgresql/timezone/Asia/Urumqi
+%%TZDATA%%share/postgresql/timezone/Asia/Vientiane
+%%TZDATA%%share/postgresql/timezone/Asia/Vladivostok
+%%TZDATA%%share/postgresql/timezone/Asia/Yakutsk
+%%TZDATA%%share/postgresql/timezone/Asia/Yekaterinburg
+%%TZDATA%%share/postgresql/timezone/Asia/Yerevan
+%%TZDATA%%share/postgresql/timezone/Atlantic/Azores
+%%TZDATA%%share/postgresql/timezone/Atlantic/Bermuda
+%%TZDATA%%share/postgresql/timezone/Atlantic/Canary
+%%TZDATA%%share/postgresql/timezone/Atlantic/Cape_Verde
+%%TZDATA%%share/postgresql/timezone/Atlantic/Faeroe
+%%TZDATA%%share/postgresql/timezone/Atlantic/Faroe
+%%TZDATA%%share/postgresql/timezone/Atlantic/Jan_Mayen
+%%TZDATA%%share/postgresql/timezone/Atlantic/Madeira
+%%TZDATA%%share/postgresql/timezone/Atlantic/Reykjavik
+%%TZDATA%%share/postgresql/timezone/Atlantic/South_Georgia
+%%TZDATA%%share/postgresql/timezone/Atlantic/St_Helena
+%%TZDATA%%share/postgresql/timezone/Atlantic/Stanley
+%%TZDATA%%share/postgresql/timezone/Australia/ACT
+%%TZDATA%%share/postgresql/timezone/Australia/Adelaide
+%%TZDATA%%share/postgresql/timezone/Australia/Brisbane
+%%TZDATA%%share/postgresql/timezone/Australia/Broken_Hill
+%%TZDATA%%share/postgresql/timezone/Australia/Canberra
+%%TZDATA%%share/postgresql/timezone/Australia/Currie
+%%TZDATA%%share/postgresql/timezone/Australia/Darwin
+%%TZDATA%%share/postgresql/timezone/Australia/Eucla
+%%TZDATA%%share/postgresql/timezone/Australia/Hobart
+%%TZDATA%%share/postgresql/timezone/Australia/LHI
+%%TZDATA%%share/postgresql/timezone/Australia/Lindeman
+%%TZDATA%%share/postgresql/timezone/Australia/Lord_Howe
+%%TZDATA%%share/postgresql/timezone/Australia/Melbourne
+%%TZDATA%%share/postgresql/timezone/Australia/NSW
+%%TZDATA%%share/postgresql/timezone/Australia/North
+%%TZDATA%%share/postgresql/timezone/Australia/Perth
+%%TZDATA%%share/postgresql/timezone/Australia/Queensland
+%%TZDATA%%share/postgresql/timezone/Australia/South
+%%TZDATA%%share/postgresql/timezone/Australia/Sydney
+%%TZDATA%%share/postgresql/timezone/Australia/Tasmania
+%%TZDATA%%share/postgresql/timezone/Australia/Victoria
+%%TZDATA%%share/postgresql/timezone/Australia/West
+%%TZDATA%%share/postgresql/timezone/Australia/Yancowinna
+%%TZDATA%%share/postgresql/timezone/Brazil/Acre
+%%TZDATA%%share/postgresql/timezone/Brazil/DeNoronha
+%%TZDATA%%share/postgresql/timezone/Brazil/East
+%%TZDATA%%share/postgresql/timezone/Brazil/West
+%%TZDATA%%share/postgresql/timezone/CET
+%%TZDATA%%share/postgresql/timezone/CST6CDT
+%%TZDATA%%share/postgresql/timezone/Canada/Atlantic
+%%TZDATA%%share/postgresql/timezone/Canada/Central
+%%TZDATA%%share/postgresql/timezone/Canada/East-Saskatchewan
+%%TZDATA%%share/postgresql/timezone/Canada/Eastern
+%%TZDATA%%share/postgresql/timezone/Canada/Mountain
+%%TZDATA%%share/postgresql/timezone/Canada/Newfoundland
+%%TZDATA%%share/postgresql/timezone/Canada/Pacific
+%%TZDATA%%share/postgresql/timezone/Canada/Saskatchewan
+%%TZDATA%%share/postgresql/timezone/Canada/Yukon
+%%TZDATA%%share/postgresql/timezone/Chile/Continental
+%%TZDATA%%share/postgresql/timezone/Chile/EasterIsland
+%%TZDATA%%share/postgresql/timezone/Cuba
+%%TZDATA%%share/postgresql/timezone/EET
+%%TZDATA%%share/postgresql/timezone/EST
+%%TZDATA%%share/postgresql/timezone/EST5EDT
+%%TZDATA%%share/postgresql/timezone/Egypt
+%%TZDATA%%share/postgresql/timezone/Eire
+%%TZDATA%%share/postgresql/timezone/Etc/GMT
+%%TZDATA%%share/postgresql/timezone/Etc/GMT+0
+%%TZDATA%%share/postgresql/timezone/Etc/GMT+1
+%%TZDATA%%share/postgresql/timezone/Etc/GMT+10
+%%TZDATA%%share/postgresql/timezone/Etc/GMT+11
+%%TZDATA%%share/postgresql/timezone/Etc/GMT+12
+%%TZDATA%%share/postgresql/timezone/Etc/GMT+2
+%%TZDATA%%share/postgresql/timezone/Etc/GMT+3
+%%TZDATA%%share/postgresql/timezone/Etc/GMT+4
+%%TZDATA%%share/postgresql/timezone/Etc/GMT+5
+%%TZDATA%%share/postgresql/timezone/Etc/GMT+6
+%%TZDATA%%share/postgresql/timezone/Etc/GMT+7
+%%TZDATA%%share/postgresql/timezone/Etc/GMT+8
+%%TZDATA%%share/postgresql/timezone/Etc/GMT+9
+%%TZDATA%%share/postgresql/timezone/Etc/GMT-0
+%%TZDATA%%share/postgresql/timezone/Etc/GMT-1
+%%TZDATA%%share/postgresql/timezone/Etc/GMT-10
+%%TZDATA%%share/postgresql/timezone/Etc/GMT-11
+%%TZDATA%%share/postgresql/timezone/Etc/GMT-12
+%%TZDATA%%share/postgresql/timezone/Etc/GMT-13
+%%TZDATA%%share/postgresql/timezone/Etc/GMT-14
+%%TZDATA%%share/postgresql/timezone/Etc/GMT-2
+%%TZDATA%%share/postgresql/timezone/Etc/GMT-3
+%%TZDATA%%share/postgresql/timezone/Etc/GMT-4
+%%TZDATA%%share/postgresql/timezone/Etc/GMT-5
+%%TZDATA%%share/postgresql/timezone/Etc/GMT-6
+%%TZDATA%%share/postgresql/timezone/Etc/GMT-7
+%%TZDATA%%share/postgresql/timezone/Etc/GMT-8
+%%TZDATA%%share/postgresql/timezone/Etc/GMT-9
+%%TZDATA%%share/postgresql/timezone/Etc/GMT0
+%%TZDATA%%share/postgresql/timezone/Etc/Greenwich
+%%TZDATA%%share/postgresql/timezone/Etc/UCT
+%%TZDATA%%share/postgresql/timezone/Etc/UTC
+%%TZDATA%%share/postgresql/timezone/Etc/Universal
+%%TZDATA%%share/postgresql/timezone/Etc/Zulu
+%%TZDATA%%share/postgresql/timezone/Europe/Amsterdam
+%%TZDATA%%share/postgresql/timezone/Europe/Andorra
+%%TZDATA%%share/postgresql/timezone/Europe/Athens
+%%TZDATA%%share/postgresql/timezone/Europe/Belfast
+%%TZDATA%%share/postgresql/timezone/Europe/Belgrade
+%%TZDATA%%share/postgresql/timezone/Europe/Berlin
+%%TZDATA%%share/postgresql/timezone/Europe/Bratislava
+%%TZDATA%%share/postgresql/timezone/Europe/Brussels
+%%TZDATA%%share/postgresql/timezone/Europe/Bucharest
+%%TZDATA%%share/postgresql/timezone/Europe/Budapest
+%%TZDATA%%share/postgresql/timezone/Europe/Chisinau
+%%TZDATA%%share/postgresql/timezone/Europe/Copenhagen
+%%TZDATA%%share/postgresql/timezone/Europe/Dublin
+%%TZDATA%%share/postgresql/timezone/Europe/Gibraltar
+%%TZDATA%%share/postgresql/timezone/Europe/Guernsey
+%%TZDATA%%share/postgresql/timezone/Europe/Helsinki
+%%TZDATA%%share/postgresql/timezone/Europe/Isle_of_Man
+%%TZDATA%%share/postgresql/timezone/Europe/Istanbul
+%%TZDATA%%share/postgresql/timezone/Europe/Jersey
+%%TZDATA%%share/postgresql/timezone/Europe/Kaliningrad
+%%TZDATA%%share/postgresql/timezone/Europe/Kiev
+%%TZDATA%%share/postgresql/timezone/Europe/Lisbon
+%%TZDATA%%share/postgresql/timezone/Europe/Ljubljana
+%%TZDATA%%share/postgresql/timezone/Europe/London
+%%TZDATA%%share/postgresql/timezone/Europe/Luxembourg
+%%TZDATA%%share/postgresql/timezone/Europe/Madrid
+%%TZDATA%%share/postgresql/timezone/Europe/Malta
+%%TZDATA%%share/postgresql/timezone/Europe/Mariehamn
+%%TZDATA%%share/postgresql/timezone/Europe/Minsk
+%%TZDATA%%share/postgresql/timezone/Europe/Monaco
+%%TZDATA%%share/postgresql/timezone/Europe/Moscow
+%%TZDATA%%share/postgresql/timezone/Europe/Nicosia
+%%TZDATA%%share/postgresql/timezone/Europe/Oslo
+%%TZDATA%%share/postgresql/timezone/Europe/Paris
+%%TZDATA%%share/postgresql/timezone/Europe/Podgorica
+%%TZDATA%%share/postgresql/timezone/Europe/Prague
+%%TZDATA%%share/postgresql/timezone/Europe/Riga
+%%TZDATA%%share/postgresql/timezone/Europe/Rome
+%%TZDATA%%share/postgresql/timezone/Europe/Samara
+%%TZDATA%%share/postgresql/timezone/Europe/San_Marino
+%%TZDATA%%share/postgresql/timezone/Europe/Sarajevo
+%%TZDATA%%share/postgresql/timezone/Europe/Simferopol
+%%TZDATA%%share/postgresql/timezone/Europe/Skopje
+%%TZDATA%%share/postgresql/timezone/Europe/Sofia
+%%TZDATA%%share/postgresql/timezone/Europe/Stockholm
+%%TZDATA%%share/postgresql/timezone/Europe/Tallinn
+%%TZDATA%%share/postgresql/timezone/Europe/Tirane
+%%TZDATA%%share/postgresql/timezone/Europe/Tiraspol
+%%TZDATA%%share/postgresql/timezone/Europe/Uzhgorod
+%%TZDATA%%share/postgresql/timezone/Europe/Vaduz
+%%TZDATA%%share/postgresql/timezone/Europe/Vatican
+%%TZDATA%%share/postgresql/timezone/Europe/Vienna
+%%TZDATA%%share/postgresql/timezone/Europe/Vilnius
+%%TZDATA%%share/postgresql/timezone/Europe/Volgograd
+%%TZDATA%%share/postgresql/timezone/Europe/Warsaw
+%%TZDATA%%share/postgresql/timezone/Europe/Zagreb
+%%TZDATA%%share/postgresql/timezone/Europe/Zaporozhye
+%%TZDATA%%share/postgresql/timezone/Europe/Zurich
+%%TZDATA%%share/postgresql/timezone/Factory
+%%TZDATA%%share/postgresql/timezone/GB
+%%TZDATA%%share/postgresql/timezone/GB-Eire
+%%TZDATA%%share/postgresql/timezone/GMT
+%%TZDATA%%share/postgresql/timezone/GMT+0
+%%TZDATA%%share/postgresql/timezone/GMT-0
+%%TZDATA%%share/postgresql/timezone/GMT0
+%%TZDATA%%share/postgresql/timezone/Greenwich
+%%TZDATA%%share/postgresql/timezone/HST
+%%TZDATA%%share/postgresql/timezone/Hongkong
+%%TZDATA%%share/postgresql/timezone/Iceland
+%%TZDATA%%share/postgresql/timezone/Indian/Antananarivo
+%%TZDATA%%share/postgresql/timezone/Indian/Chagos
+%%TZDATA%%share/postgresql/timezone/Indian/Christmas
+%%TZDATA%%share/postgresql/timezone/Indian/Cocos
+%%TZDATA%%share/postgresql/timezone/Indian/Comoro
+%%TZDATA%%share/postgresql/timezone/Indian/Kerguelen
+%%TZDATA%%share/postgresql/timezone/Indian/Mahe
+%%TZDATA%%share/postgresql/timezone/Indian/Maldives
+%%TZDATA%%share/postgresql/timezone/Indian/Mauritius
+%%TZDATA%%share/postgresql/timezone/Indian/Mayotte
+%%TZDATA%%share/postgresql/timezone/Indian/Reunion
+%%TZDATA%%share/postgresql/timezone/Iran
+%%TZDATA%%share/postgresql/timezone/Israel
+%%TZDATA%%share/postgresql/timezone/Jamaica
+%%TZDATA%%share/postgresql/timezone/Japan
+%%TZDATA%%share/postgresql/timezone/Kwajalein
+%%TZDATA%%share/postgresql/timezone/Libya
+%%TZDATA%%share/postgresql/timezone/MET
+%%TZDATA%%share/postgresql/timezone/MST
+%%TZDATA%%share/postgresql/timezone/MST7MDT
+%%TZDATA%%share/postgresql/timezone/Mexico/BajaNorte
+%%TZDATA%%share/postgresql/timezone/Mexico/BajaSur
+%%TZDATA%%share/postgresql/timezone/Mexico/General
+%%TZDATA%%share/postgresql/timezone/Mideast/Riyadh87
+%%TZDATA%%share/postgresql/timezone/Mideast/Riyadh88
+%%TZDATA%%share/postgresql/timezone/Mideast/Riyadh89
+%%TZDATA%%share/postgresql/timezone/NZ
+%%TZDATA%%share/postgresql/timezone/NZ-CHAT
+%%TZDATA%%share/postgresql/timezone/Navajo
+%%TZDATA%%share/postgresql/timezone/PRC
+%%TZDATA%%share/postgresql/timezone/PST8PDT
+%%TZDATA%%share/postgresql/timezone/Pacific/Apia
+%%TZDATA%%share/postgresql/timezone/Pacific/Auckland
+%%TZDATA%%share/postgresql/timezone/Pacific/Chatham
+%%TZDATA%%share/postgresql/timezone/Pacific/Easter
+%%TZDATA%%share/postgresql/timezone/Pacific/Efate
+%%TZDATA%%share/postgresql/timezone/Pacific/Enderbury
+%%TZDATA%%share/postgresql/timezone/Pacific/Fakaofo
+%%TZDATA%%share/postgresql/timezone/Pacific/Fiji
+%%TZDATA%%share/postgresql/timezone/Pacific/Funafuti
+%%TZDATA%%share/postgresql/timezone/Pacific/Galapagos
+%%TZDATA%%share/postgresql/timezone/Pacific/Gambier
+%%TZDATA%%share/postgresql/timezone/Pacific/Guadalcanal
+%%TZDATA%%share/postgresql/timezone/Pacific/Guam
+%%TZDATA%%share/postgresql/timezone/Pacific/Honolulu
+%%TZDATA%%share/postgresql/timezone/Pacific/Johnston
+%%TZDATA%%share/postgresql/timezone/Pacific/Kiritimati
+%%TZDATA%%share/postgresql/timezone/Pacific/Kosrae
+%%TZDATA%%share/postgresql/timezone/Pacific/Kwajalein
+%%TZDATA%%share/postgresql/timezone/Pacific/Majuro
+%%TZDATA%%share/postgresql/timezone/Pacific/Marquesas
+%%TZDATA%%share/postgresql/timezone/Pacific/Midway
+%%TZDATA%%share/postgresql/timezone/Pacific/Nauru
+%%TZDATA%%share/postgresql/timezone/Pacific/Niue
+%%TZDATA%%share/postgresql/timezone/Pacific/Norfolk
+%%TZDATA%%share/postgresql/timezone/Pacific/Noumea
+%%TZDATA%%share/postgresql/timezone/Pacific/Pago_Pago
+%%TZDATA%%share/postgresql/timezone/Pacific/Palau
+%%TZDATA%%share/postgresql/timezone/Pacific/Pitcairn
+%%TZDATA%%share/postgresql/timezone/Pacific/Ponape
+%%TZDATA%%share/postgresql/timezone/Pacific/Port_Moresby
+%%TZDATA%%share/postgresql/timezone/Pacific/Rarotonga
+%%TZDATA%%share/postgresql/timezone/Pacific/Saipan
+%%TZDATA%%share/postgresql/timezone/Pacific/Samoa
+%%TZDATA%%share/postgresql/timezone/Pacific/Tahiti
+%%TZDATA%%share/postgresql/timezone/Pacific/Tarawa
+%%TZDATA%%share/postgresql/timezone/Pacific/Tongatapu
+%%TZDATA%%share/postgresql/timezone/Pacific/Truk
+%%TZDATA%%share/postgresql/timezone/Pacific/Wake
+%%TZDATA%%share/postgresql/timezone/Pacific/Wallis
+%%TZDATA%%share/postgresql/timezone/Pacific/Yap
+%%TZDATA%%share/postgresql/timezone/Poland
+%%TZDATA%%share/postgresql/timezone/Portugal
+%%TZDATA%%share/postgresql/timezone/ROC
+%%TZDATA%%share/postgresql/timezone/ROK
+%%TZDATA%%share/postgresql/timezone/Singapore
+%%TZDATA%%share/postgresql/timezone/Turkey
+%%TZDATA%%share/postgresql/timezone/UCT
+%%TZDATA%%share/postgresql/timezone/US/Alaska
+%%TZDATA%%share/postgresql/timezone/US/Aleutian
+%%TZDATA%%share/postgresql/timezone/US/Arizona
+%%TZDATA%%share/postgresql/timezone/US/Central
+%%TZDATA%%share/postgresql/timezone/US/East-Indiana
+%%TZDATA%%share/postgresql/timezone/US/Eastern
+%%TZDATA%%share/postgresql/timezone/US/Hawaii
+%%TZDATA%%share/postgresql/timezone/US/Indiana-Starke
+%%TZDATA%%share/postgresql/timezone/US/Michigan
+%%TZDATA%%share/postgresql/timezone/US/Mountain
+%%TZDATA%%share/postgresql/timezone/US/Pacific
+%%TZDATA%%share/postgresql/timezone/US/Pacific-New
+%%TZDATA%%share/postgresql/timezone/US/Samoa
+%%TZDATA%%share/postgresql/timezone/UTC
+%%TZDATA%%share/postgresql/timezone/Universal
+%%TZDATA%%share/postgresql/timezone/W-SU
+%%TZDATA%%share/postgresql/timezone/WET
+%%TZDATA%%share/postgresql/timezone/Zulu
+%%TZDATA%%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
+%%TZDATA%%@dirrm share/postgresql/timezone/Africa
+%%TZDATA%%@dirrm share/postgresql/timezone/America/Argentina
+%%TZDATA%%@dirrm share/postgresql/timezone/America/Indiana
+%%TZDATA%%@dirrm share/postgresql/timezone/America/Kentucky
+%%TZDATA%%@dirrm share/postgresql/timezone/America/North_Dakota
+%%TZDATA%%@dirrm share/postgresql/timezone/America
+%%TZDATA%%@dirrm share/postgresql/timezone/Antarctica
+%%TZDATA%%@dirrm share/postgresql/timezone/Arctic
+%%TZDATA%%@dirrm share/postgresql/timezone/Asia
+%%TZDATA%%@dirrm share/postgresql/timezone/Atlantic
+%%TZDATA%%@dirrm share/postgresql/timezone/Australia
+%%TZDATA%%@dirrm share/postgresql/timezone/Brazil
+%%TZDATA%%@dirrm share/postgresql/timezone/Canada
+%%TZDATA%%@dirrm share/postgresql/timezone/Chile
+%%TZDATA%%@dirrm share/postgresql/timezone/Etc
+%%TZDATA%%@dirrm share/postgresql/timezone/Europe
+%%TZDATA%%@dirrm share/postgresql/timezone/Indian
+%%TZDATA%%@dirrm share/postgresql/timezone/Mexico
+%%TZDATA%%@dirrm share/postgresql/timezone/Mideast
+%%TZDATA%%@dirrm share/postgresql/timezone/Pacific
+%%TZDATA%%@dirrm share/postgresql/timezone/US
+%%TZDATA%%@dirrm share/postgresql/timezone
+ at dirrm share/postgresql/timezonesets
+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/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/turkish.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/synonym_sample.syn
+share/postgresql/tsearch_data/thesaurus_sample.ths
+ at dirrm share/postgresql/tsearch_data
+ at unexec echo "Warning: If you will *NOT* use this package anymore, please remove the pgsql user manually."
+ at dirrmtry share/postgresql
+ at dirrmtry etc/periodic/daily
+ at dirrmtry etc/periodic
+ at dirrmtry lib/postgresql
+ at dirrmtry pgsql
--- /dev/null
+++ databases/postgresql83-server/pkg-plist-client
@@ -0,0 +1,611 @@
+bin/clusterdb
+bin/createdb
+bin/createlang
+bin/createuser
+bin/dropdb
+bin/droplang
+bin/dropuser
+bin/ecpg
+bin/pg_config
+bin/pg_dump
+bin/pg_dumpall
+bin/pg_restore
+bin/psql
+bin/reindexdb
+bin/vacuumdb
+include/ecpg_config.h
+include/postgresql/server/access/attnum.h
+include/postgresql/server/access/clog.h
+include/postgresql/server/access/genam.h
+include/postgresql/server/access/gin.h
+include/postgresql/server/access/gist.h
+include/postgresql/server/access/gist_private.h
+include/postgresql/server/access/gistscan.h
+include/postgresql/server/access/hash.h
+include/postgresql/server/access/heapam.h
+include/postgresql/server/access/hio.h
+include/postgresql/server/access/htup.h
+include/postgresql/server/access/itup.h
+include/postgresql/server/access/multixact.h
+include/postgresql/server/access/nbtree.h
+include/postgresql/server/access/printtup.h
+include/postgresql/server/access/reloptions.h
+include/postgresql/server/access/relscan.h
+include/postgresql/server/access/rewriteheap.h
+include/postgresql/server/access/rmgr.h
+include/postgresql/server/access/sdir.h
+include/postgresql/server/access/skey.h
+include/postgresql/server/access/slru.h
+include/postgresql/server/access/subtrans.h
+include/postgresql/server/access/transam.h
+include/postgresql/server/access/tupdesc.h
+include/postgresql/server/access/tupmacs.h
+include/postgresql/server/access/tuptoaster.h
+include/postgresql/server/access/twophase.h
+include/postgresql/server/access/twophase_rmgr.h
+include/postgresql/server/access/valid.h
+include/postgresql/server/access/xact.h
+include/postgresql/server/access/xlog.h
+include/postgresql/server/access/xlog_internal.h
+include/postgresql/server/access/xlogdefs.h
+include/postgresql/server/access/xlogutils.h
+include/postgresql/server/bootstrap/bootstrap.h
+include/postgresql/server/c.h
+include/postgresql/server/catalog/catalog.h
+include/postgresql/server/catalog/catversion.h
+include/postgresql/server/catalog/dependency.h
+include/postgresql/server/catalog/heap.h
+include/postgresql/server/catalog/index.h
+include/postgresql/server/catalog/indexing.h
+include/postgresql/server/catalog/namespace.h
+include/postgresql/server/catalog/pg_aggregate.h
+include/postgresql/server/catalog/pg_am.h
+include/postgresql/server/catalog/pg_amop.h
+include/postgresql/server/catalog/pg_amproc.h
+include/postgresql/server/catalog/pg_attrdef.h
+include/postgresql/server/catalog/pg_attribute.h
+include/postgresql/server/catalog/pg_auth_members.h
+include/postgresql/server/catalog/pg_authid.h
+include/postgresql/server/catalog/pg_autovacuum.h
+include/postgresql/server/catalog/pg_cast.h
+include/postgresql/server/catalog/pg_class.h
+include/postgresql/server/catalog/pg_constraint.h
+include/postgresql/server/catalog/pg_control.h
+include/postgresql/server/catalog/pg_conversion.h
+include/postgresql/server/catalog/pg_database.h
+include/postgresql/server/catalog/pg_depend.h
+include/postgresql/server/catalog/pg_description.h
+include/postgresql/server/catalog/pg_enum.h
+include/postgresql/server/catalog/pg_index.h
+include/postgresql/server/catalog/pg_inherits.h
+include/postgresql/server/catalog/pg_language.h
+include/postgresql/server/catalog/pg_largeobject.h
+include/postgresql/server/catalog/pg_listener.h
+include/postgresql/server/catalog/pg_namespace.h
+include/postgresql/server/catalog/pg_opclass.h
+include/postgresql/server/catalog/pg_operator.h
+include/postgresql/server/catalog/pg_opfamily.h
+include/postgresql/server/catalog/pg_pltemplate.h
+include/postgresql/server/catalog/pg_proc.h
+include/postgresql/server/catalog/pg_rewrite.h
+include/postgresql/server/catalog/pg_shdepend.h
+include/postgresql/server/catalog/pg_shdescription.h
+include/postgresql/server/catalog/pg_statistic.h
+include/postgresql/server/catalog/pg_tablespace.h
+include/postgresql/server/catalog/pg_trigger.h
+include/postgresql/server/catalog/pg_ts_config.h
+include/postgresql/server/catalog/pg_ts_config_map.h
+include/postgresql/server/catalog/pg_ts_dict.h
+include/postgresql/server/catalog/pg_ts_parser.h
+include/postgresql/server/catalog/pg_ts_template.h
+include/postgresql/server/catalog/pg_type.h
+include/postgresql/server/catalog/toasting.h
+include/postgresql/server/commands/alter.h
+include/postgresql/server/commands/async.h
+include/postgresql/server/commands/cluster.h
+include/postgresql/server/commands/comment.h
+include/postgresql/server/commands/conversioncmds.h
+include/postgresql/server/commands/copy.h
+include/postgresql/server/commands/dbcommands.h
+include/postgresql/server/commands/defrem.h
+include/postgresql/server/commands/discard.h
+include/postgresql/server/commands/explain.h
+include/postgresql/server/commands/lockcmds.h
+include/postgresql/server/commands/portalcmds.h
+include/postgresql/server/commands/prepare.h
+include/postgresql/server/commands/proclang.h
+include/postgresql/server/commands/schemacmds.h
+include/postgresql/server/commands/sequence.h
+include/postgresql/server/commands/tablecmds.h
+include/postgresql/server/commands/tablespace.h
+include/postgresql/server/commands/trigger.h
+include/postgresql/server/commands/typecmds.h
+include/postgresql/server/commands/user.h
+include/postgresql/server/commands/vacuum.h
+include/postgresql/server/commands/variable.h
+include/postgresql/server/commands/version.h
+include/postgresql/server/commands/view.h
+include/postgresql/server/dynloader.h
+include/postgresql/server/executor/execdebug.h
+include/postgresql/server/executor/execdefs.h
+include/postgresql/server/executor/execdesc.h
+include/postgresql/server/executor/executor.h
+include/postgresql/server/executor/functions.h
+include/postgresql/server/executor/hashjoin.h
+include/postgresql/server/executor/instrument.h
+include/postgresql/server/executor/nodeAgg.h
+include/postgresql/server/executor/nodeAppend.h
+include/postgresql/server/executor/nodeBitmapAnd.h
+include/postgresql/server/executor/nodeBitmapHeapscan.h
+include/postgresql/server/executor/nodeBitmapIndexscan.h
+include/postgresql/server/executor/nodeBitmapOr.h
+include/postgresql/server/executor/nodeFunctionscan.h
+include/postgresql/server/executor/nodeGroup.h
+include/postgresql/server/executor/nodeHash.h
+include/postgresql/server/executor/nodeHashjoin.h
+include/postgresql/server/executor/nodeIndexscan.h
+include/postgresql/server/executor/nodeLimit.h
+include/postgresql/server/executor/nodeMaterial.h
+include/postgresql/server/executor/nodeMergejoin.h
+include/postgresql/server/executor/nodeNestloop.h
+include/postgresql/server/executor/nodeResult.h
+include/postgresql/server/executor/nodeSeqscan.h
+include/postgresql/server/executor/nodeSetOp.h
+include/postgresql/server/executor/nodeSort.h
+include/postgresql/server/executor/nodeSubplan.h
+include/postgresql/server/executor/nodeSubqueryscan.h
+include/postgresql/server/executor/nodeTidscan.h
+include/postgresql/server/executor/nodeUnique.h
+include/postgresql/server/executor/nodeValuesscan.h
+include/postgresql/server/executor/spi.h
+include/postgresql/server/executor/spi_priv.h
+include/postgresql/server/executor/tstoreReceiver.h
+include/postgresql/server/executor/tuptable.h
+include/postgresql/server/fmgr.h
+include/postgresql/server/funcapi.h
+include/postgresql/server/getaddrinfo.h
+include/postgresql/server/getopt_long.h
+include/postgresql/server/lib/dllist.h
+include/postgresql/server/lib/stringinfo.h
+include/postgresql/server/libpq/auth.h
+include/postgresql/server/libpq/be-fsstubs.h
+include/postgresql/server/libpq/crypt.h
+include/postgresql/server/libpq/hba.h
+include/postgresql/server/libpq/ip.h
+include/postgresql/server/libpq/libpq-be.h
+include/postgresql/server/libpq/libpq-fs.h
+include/postgresql/server/libpq/libpq.h
+include/postgresql/server/libpq/md5.h
+include/postgresql/server/libpq/pqcomm.h
+include/postgresql/server/libpq/pqformat.h
+include/postgresql/server/libpq/pqsignal.h
+include/postgresql/server/mb/pg_wchar.h
+include/postgresql/server/miscadmin.h
+include/postgresql/server/nodes/bitmapset.h
+include/postgresql/server/nodes/execnodes.h
+include/postgresql/server/nodes/makefuncs.h
+include/postgresql/server/nodes/memnodes.h
+include/postgresql/server/nodes/nodeFuncs.h
+include/postgresql/server/nodes/nodes.h
+include/postgresql/server/nodes/params.h
+include/postgresql/server/nodes/parsenodes.h
+include/postgresql/server/nodes/pg_list.h
+include/postgresql/server/nodes/plannodes.h
+include/postgresql/server/nodes/primnodes.h
+include/postgresql/server/nodes/print.h
+include/postgresql/server/nodes/readfuncs.h
+include/postgresql/server/nodes/relation.h
+include/postgresql/server/nodes/tidbitmap.h
+include/postgresql/server/nodes/value.h
+include/postgresql/server/optimizer/clauses.h
+include/postgresql/server/optimizer/cost.h
+include/postgresql/server/optimizer/geqo.h
+include/postgresql/server/optimizer/geqo_copy.h
+include/postgresql/server/optimizer/geqo_gene.h
+include/postgresql/server/optimizer/geqo_misc.h
+include/postgresql/server/optimizer/geqo_mutation.h
+include/postgresql/server/optimizer/geqo_pool.h
+include/postgresql/server/optimizer/geqo_random.h
+include/postgresql/server/optimizer/geqo_recombination.h
+include/postgresql/server/optimizer/geqo_selection.h
+include/postgresql/server/optimizer/joininfo.h
+include/postgresql/server/optimizer/pathnode.h
+include/postgresql/server/optimizer/paths.h
+include/postgresql/server/optimizer/plancat.h
+include/postgresql/server/optimizer/planmain.h
+include/postgresql/server/optimizer/planner.h
+include/postgresql/server/optimizer/predtest.h
+include/postgresql/server/optimizer/prep.h
+include/postgresql/server/optimizer/restrictinfo.h
+include/postgresql/server/optimizer/subselect.h
+include/postgresql/server/optimizer/tlist.h
+include/postgresql/server/optimizer/var.h
+include/postgresql/server/parser/analyze.h
+include/postgresql/server/parser/gramparse.h
+include/postgresql/server/parser/keywords.h
+include/postgresql/server/parser/parse.h
+include/postgresql/server/parser/parse_agg.h
+include/postgresql/server/parser/parse_clause.h
+include/postgresql/server/parser/parse_coerce.h
+include/postgresql/server/parser/parse_expr.h
+include/postgresql/server/parser/parse_func.h
+include/postgresql/server/parser/parse_node.h
+include/postgresql/server/parser/parse_oper.h
+include/postgresql/server/parser/parse_relation.h
+include/postgresql/server/parser/parse_target.h
+include/postgresql/server/parser/parse_type.h
+include/postgresql/server/parser/parse_utilcmd.h
+include/postgresql/server/parser/parser.h
+include/postgresql/server/parser/parsetree.h
+include/postgresql/server/parser/scansup.h
+include/postgresql/server/pg_config.h
+include/postgresql/server/pg_config_manual.h
+include/postgresql/server/pg_config_os.h
+include/postgresql/server/pg_trace.h
+include/postgresql/server/pgstat.h
+include/postgresql/server/pgtime.h
+include/postgresql/server/port.h
+include/postgresql/server/port/aix.h
+include/postgresql/server/port/bsdi.h
+include/postgresql/server/port/cygwin.h
+include/postgresql/server/port/darwin.h
+include/postgresql/server/port/dgux.h
+include/postgresql/server/port/freebsd.h
+include/postgresql/server/port/hpux.h
+include/postgresql/server/port/irix.h
+include/postgresql/server/port/linux.h
+include/postgresql/server/port/netbsd.h
+include/postgresql/server/port/nextstep.h
+include/postgresql/server/port/openbsd.h
+include/postgresql/server/port/osf.h
+include/postgresql/server/port/sco.h
+include/postgresql/server/port/solaris.h
+include/postgresql/server/port/sunos4.h
+include/postgresql/server/port/svr4.h
+include/postgresql/server/port/ultrix4.h
+include/postgresql/server/port/univel.h
+include/postgresql/server/port/unixware.h
+include/postgresql/server/port/win32.h
+include/postgresql/server/port/win32/arpa/inet.h
+include/postgresql/server/port/win32/dlfcn.h
+include/postgresql/server/port/win32/grp.h
+include/postgresql/server/port/win32/netdb.h
+include/postgresql/server/port/win32/netinet/in.h
+include/postgresql/server/port/win32/pwd.h
+include/postgresql/server/port/win32/sys/socket.h
+include/postgresql/server/port/win32/sys/wait.h
+include/postgresql/server/port/win32_msvc/dirent.h
+include/postgresql/server/port/win32_msvc/sys/file.h
+include/postgresql/server/port/win32_msvc/sys/param.h
+include/postgresql/server/port/win32_msvc/sys/time.h
+include/postgresql/server/port/win32_msvc/unistd.h
+include/postgresql/server/port/win32_msvc/utime.h
+include/postgresql/server/postgres.h
+include/postgresql/server/postgres_ext.h
+include/postgresql/server/postgres_fe.h
+include/postgresql/server/postmaster/autovacuum.h
+include/postgresql/server/postmaster/bgwriter.h
+include/postgresql/server/postmaster/fork_process.h
+include/postgresql/server/postmaster/pgarch.h
+include/postgresql/server/postmaster/postmaster.h
+include/postgresql/server/postmaster/syslogger.h
+include/postgresql/server/postmaster/walwriter.h
+include/postgresql/server/regex/regcustom.h
+include/postgresql/server/regex/regerrs.h
+include/postgresql/server/regex/regex.h
+include/postgresql/server/regex/regguts.h
+include/postgresql/server/rewrite/prs2lock.h
+include/postgresql/server/rewrite/rewriteDefine.h
+include/postgresql/server/rewrite/rewriteHandler.h
+include/postgresql/server/rewrite/rewriteManip.h
+include/postgresql/server/rewrite/rewriteRemove.h
+include/postgresql/server/rewrite/rewriteSupport.h
+include/postgresql/server/rusagestub.h
+include/postgresql/server/snowball/header.h
+include/postgresql/server/snowball/libstemmer/api.h
+include/postgresql/server/snowball/libstemmer/header.h
+include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_danish.h
+include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_dutch.h
+include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_english.h
+include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_finnish.h
+include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_french.h
+include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_german.h
+include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_hungarian.h
+include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_italian.h
+include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_norwegian.h
+include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_porter.h
+include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_portuguese.h
+include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_spanish.h
+include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_swedish.h
+include/postgresql/server/snowball/libstemmer/stem_ISO_8859_2_romanian.h
+include/postgresql/server/snowball/libstemmer/stem_KOI8_R_russian.h
+include/postgresql/server/snowball/libstemmer/stem_UTF_8_danish.h
+include/postgresql/server/snowball/libstemmer/stem_UTF_8_dutch.h
+include/postgresql/server/snowball/libstemmer/stem_UTF_8_english.h
+include/postgresql/server/snowball/libstemmer/stem_UTF_8_finnish.h
+include/postgresql/server/snowball/libstemmer/stem_UTF_8_french.h
+include/postgresql/server/snowball/libstemmer/stem_UTF_8_german.h
+include/postgresql/server/snowball/libstemmer/stem_UTF_8_hungarian.h
+include/postgresql/server/snowball/libstemmer/stem_UTF_8_italian.h
+include/postgresql/server/snowball/libstemmer/stem_UTF_8_norwegian.h
+include/postgresql/server/snowball/libstemmer/stem_UTF_8_porter.h
+include/postgresql/server/snowball/libstemmer/stem_UTF_8_portuguese.h
+include/postgresql/server/snowball/libstemmer/stem_UTF_8_romanian.h
+include/postgresql/server/snowball/libstemmer/stem_UTF_8_russian.h
+include/postgresql/server/snowball/libstemmer/stem_UTF_8_spanish.h
+include/postgresql/server/snowball/libstemmer/stem_UTF_8_swedish.h
+include/postgresql/server/snowball/libstemmer/stem_UTF_8_turkish.h
+include/postgresql/server/storage/backendid.h
+include/postgresql/server/storage/block.h
+include/postgresql/server/storage/buf.h
+include/postgresql/server/storage/buf_internals.h
+include/postgresql/server/storage/buffile.h
+include/postgresql/server/storage/bufmgr.h
+include/postgresql/server/storage/bufpage.h
+include/postgresql/server/storage/fd.h
+include/postgresql/server/storage/freespace.h
+include/postgresql/server/storage/ipc.h
+include/postgresql/server/storage/item.h
+include/postgresql/server/storage/itemid.h
+include/postgresql/server/storage/itempos.h
+include/postgresql/server/storage/itemptr.h
+include/postgresql/server/storage/large_object.h
+include/postgresql/server/storage/lmgr.h
+include/postgresql/server/storage/lock.h
+include/postgresql/server/storage/lwlock.h
+include/postgresql/server/storage/off.h
+include/postgresql/server/storage/pg_sema.h
+include/postgresql/server/storage/pg_shmem.h
+include/postgresql/server/storage/pmsignal.h
+include/postgresql/server/storage/pos.h
+include/postgresql/server/storage/proc.h
+include/postgresql/server/storage/procarray.h
+include/postgresql/server/storage/relfilenode.h
+include/postgresql/server/storage/s_lock.h
+include/postgresql/server/storage/shmem.h
+include/postgresql/server/storage/sinval.h
+include/postgresql/server/storage/sinvaladt.h
+include/postgresql/server/storage/smgr.h
+include/postgresql/server/storage/spin.h
+include/postgresql/server/tcop/dest.h
+include/postgresql/server/tcop/fastpath.h
+include/postgresql/server/tcop/pquery.h
+include/postgresql/server/tcop/tcopdebug.h
+include/postgresql/server/tcop/tcopprot.h
+include/postgresql/server/tcop/utility.h
+include/postgresql/server/tsearch/dicts/regis.h
+include/postgresql/server/tsearch/dicts/spell.h
+include/postgresql/server/tsearch/ts_cache.h
+include/postgresql/server/tsearch/ts_locale.h
+include/postgresql/server/tsearch/ts_public.h
+include/postgresql/server/tsearch/ts_type.h
+include/postgresql/server/tsearch/ts_utils.h
+include/postgresql/server/utils/acl.h
+include/postgresql/server/utils/array.h
+include/postgresql/server/utils/ascii.h
+include/postgresql/server/utils/builtins.h
+include/postgresql/server/utils/cash.h
+include/postgresql/server/utils/catcache.h
+include/postgresql/server/utils/combocid.h
+include/postgresql/server/utils/date.h
+include/postgresql/server/utils/datetime.h
+include/postgresql/server/utils/datum.h
+include/postgresql/server/utils/dynahash.h
+include/postgresql/server/utils/dynamic_loader.h
+include/postgresql/server/utils/elog.h
+include/postgresql/server/utils/errcodes.h
+include/postgresql/server/utils/flatfiles.h
+include/postgresql/server/utils/fmgroids.h
+include/postgresql/server/utils/fmgrtab.h
+include/postgresql/server/utils/formatting.h
+include/postgresql/server/utils/geo_decls.h
+include/postgresql/server/utils/guc.h
+include/postgresql/server/utils/guc_tables.h
+include/postgresql/server/utils/help_config.h
+include/postgresql/server/utils/hsearch.h
+include/postgresql/server/utils/inet.h
+include/postgresql/server/utils/int8.h
+include/postgresql/server/utils/inval.h
+include/postgresql/server/utils/logtape.h
+include/postgresql/server/utils/lsyscache.h
+include/postgresql/server/utils/memutils.h
+include/postgresql/server/utils/nabstime.h
+include/postgresql/server/utils/numeric.h
+include/postgresql/server/utils/palloc.h
+include/postgresql/server/utils/pg_crc.h
+include/postgresql/server/utils/pg_locale.h
+include/postgresql/server/utils/pg_lzcompress.h
+include/postgresql/server/utils/pg_rusage.h
+include/postgresql/server/utils/plancache.h
+include/postgresql/server/utils/portal.h
+include/postgresql/server/utils/ps_status.h
+include/postgresql/server/utils/rel.h
+include/postgresql/server/utils/relcache.h
+include/postgresql/server/utils/resowner.h
+include/postgresql/server/utils/selfuncs.h
+include/postgresql/server/utils/syscache.h
+include/postgresql/server/utils/timestamp.h
+include/postgresql/server/utils/tqual.h
+include/postgresql/server/utils/tuplesort.h
+include/postgresql/server/utils/tuplestore.h
+include/postgresql/server/utils/typcache.h
+include/postgresql/server/utils/tzparser.h
+include/postgresql/server/utils/uuid.h
+include/postgresql/server/utils/varbit.h
+include/postgresql/server/utils/xml.h
+ at dirrm include/postgresql/server/utils
+ at dirrm include/postgresql/server/tsearch/dicts
+ at dirrm include/postgresql/server/tsearch
+ at dirrm include/postgresql/server/tcop
+ at dirrm include/postgresql/server/storage
+ at dirrm include/postgresql/server/snowball/libstemmer
+ at dirrm include/postgresql/server/snowball
+ at dirrm include/postgresql/server/rewrite
+ at dirrm include/postgresql/server/regex
+ at dirrm include/postgresql/server/postmaster
+ at dirrm include/postgresql/server/port/win32_msvc/sys
+ at dirrm include/postgresql/server/port/win32_msvc
+ at dirrm include/postgresql/server/port/win32/sys
+ at dirrm include/postgresql/server/port/win32/netinet
+ at dirrm include/postgresql/server/port/win32/arpa
+ at dirrm include/postgresql/server/port/win32
+ at dirrm include/postgresql/server/port
+ at dirrm include/postgresql/server/parser
+ at dirrm include/postgresql/server/optimizer
+ at dirrm include/postgresql/server/nodes
+ at dirrm include/postgresql/server/mb
+ at dirrm include/postgresql/server/libpq
+ at dirrm include/postgresql/server/lib
+ at dirrm include/postgresql/server/executor
+ at dirrm include/postgresql/server/commands
+ at dirrm include/postgresql/server/catalog
+ at dirrm include/postgresql/server/bootstrap
+ at dirrm include/postgresql/server/access
+ at dirrm include/postgresql/server
+include/libpq/libpq-fs.h
+ at dirrm include/libpq
+include/postgresql/internal/libpq/pqcomm.h
+ at dirrm include/postgresql/internal/libpq
+include/postgresql/informix/esql/datetime.h
+include/postgresql/informix/esql/decimal.h
+include/postgresql/informix/esql/sqlda.h
+include/postgresql/informix/esql/sqltypes.h
+ at dirrm include/postgresql/informix/esql
+ at dirrm include/postgresql/informix
+include/postgresql/internal/c.h
+include/postgresql/internal/libpq-int.h
+include/postgresql/internal/postgres_fe.h
+include/postgresql/internal/port.h
+include/postgresql/internal/pqexpbuffer.h
+ at dirrm include/postgresql/internal
+ at dirrm include/postgresql
+include/ecpg_informix.h
+include/ecpgerrno.h
+include/ecpglib.h
+include/ecpgtype.h
+include/libpq-fe.h
+include/pg_config.h
+include/pg_config_manual.h
+include/pg_config_os.h
+include/pgtypes_date.h
+include/pgtypes_error.h
+include/pgtypes_interval.h
+include/pgtypes_numeric.h
+include/pgtypes_timestamp.h
+include/postgres_ext.h
+include/sql3types.h
+include/sqlca.h
+lib/libecpg.a
+lib/libecpg.so
+lib/libecpg.so.6
+lib/libecpg_compat.a
+lib/libecpg_compat.so
+lib/libecpg_compat.so.3
+lib/libpgtypes.so.3
+lib/libpq.a
+lib/libpq.so
+lib/libpq.so.5
+lib/libpgtypes.a
+lib/libpgtypes.so
+lib/postgresql/pgxs/config/install-sh
+lib/postgresql/pgxs/config/mkinstalldirs
+lib/postgresql/pgxs/src/makefiles/pgxs.mk
+lib/postgresql/pgxs/src/Makefile.global
+lib/postgresql/pgxs/src/Makefile.port
+lib/postgresql/pgxs/src/Makefile.shlib
+lib/postgresql/pgxs/src/nls-global.mk
+ at dirrm lib/postgresql/pgxs/src/makefiles
+ at dirrm lib/postgresql/pgxs/config
+ at dirrm lib/postgresql/pgxs/src
+ at dirrm lib/postgresql/pgxs
+ at dirrm lib/postgresql
+%%DOCSDIR%%/README-client
+ at dirrmtry %%DOCSDIR%%
+share/postgresql/pg_service.conf.sample
+share/postgresql/psqlrc.sample
+ at dirrmtry share/postgresql
+%%GETTEXT%%share/locale/af/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/cs/LC_MESSAGES/pg_config.mo
+%%GETTEXT%%share/locale/cs/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/cs/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/cs/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/de/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_config.mo
+%%GETTEXT%%share/locale/de/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/de/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/de/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_config.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/fa/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/fr/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_config.mo
+%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/fr/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/fr/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/hr/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/hu/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/it/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/it/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/it/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/ko/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_config.mo
+%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/ko/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/ko/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/nb/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/nb/LC_MESSAGES/pg_config.mo
+%%GETTEXT%%share/locale/nb/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/nb/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/pl/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/pl/LC_MESSAGES/pg_config.mo
+%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_config.mo
+%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_config.mo
+%%GETTEXT%%share/locale/ro/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/ro/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/ro/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/ru/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_config.mo
+%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/ru/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/ru/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/sk/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/sk/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/sk/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/sk/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/sl/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/sl/LC_MESSAGES/pg_config.mo
+%%GETTEXT%%share/locale/sl/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/sl/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/sl/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/sv/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_config.mo
+%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/sv/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/sv/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/ta/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/ta/LC_MESSAGES/pg_config.mo
+%%GETTEXT%%share/locale/ta/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/tr/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_config.mo
+%%GETTEXT%%share/locale/tr/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/tr/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/tr/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_config.mo
+%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/pg_config.mo
+%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/psql.mo
--- /dev/null
+++ databases/postgresql83-server/pkg-descr
@@ -0,0 +1,23 @@
+PostgreSQL is a sophisticated Object-Relational DBMS, supporting
+almost all SQL constructs, including subselects, transactions, and
+user-defined types and functions. It is the most advanced open-source
+database available anywhere. Commercial Support is also available.
+
+The original Postgres code was the effort of many graduate students, 
+undergraduate students, and staff programmers working under the direction of 
+Professor Michael Stonebraker at the University of California, Berkeley. In 
+1995, Andrew Yu and Jolly Chen took on the task of converting the DBMS query 
+language to SQL and created a new database system which came to known as 
+Postgres95. Many others contributed to the porting, testing, debugging and 
+enhancement of the Postgres95 code. As the code improved, and 1995 faded into 
+memory, PostgreSQL was born.
+
+PostgreSQL development is presently being performed by a team of Internet 
+developers who are now responsible for all current and future development. The 
+development team coordinator is Marc G. Fournier (scrappy at PostgreSQL.ORG). 
+Support is available from the PostgreSQL developer/user community through the 
+support mailing list (questions at PostgreSQL.ORG).
+
+PostgreSQL is free and the complete source is available.
+
+WWW: http://www.postgresql.org/
--- /dev/null
+++ databases/postgresql83-server/pkg-plist
@@ -0,0 +1 @@
+ at comment to make portlint happy
--- /dev/null
+++ databases/postgresql83-server/pkg-plist-plperl
@@ -0,0 +1,4 @@
+%%DOCSDIR%%/README-plperl
+lib/postgresql/plperl.so
+ at dirrmtry lib/postgresql
+ at dirrmtry %%DOCSDIR%%
--- /dev/null
+++ databases/postgresql83-server/distinfo
@@ -0,0 +1,6 @@
+MD5 (postgresql/postgresql-8.3.6.tar.bz2) = 4f8c67d802bd03b5b844e268bba7d44a
+SHA256 (postgresql/postgresql-8.3.6.tar.bz2) = fd0239849839227649e2f472a1ffeab87f9eedc75a1d11c803dde65b109d7479
+SIZE (postgresql/postgresql-8.3.5.tar.bz2) = 14081040
+MD5 (postgresql/pg-833-icu-xx-2008-08-28.diff.gz) = 94fb6634636cd36cb5fde449d76ece65
+SHA256 (postgresql/pg-833-icu-xx-2008-08-28.diff.gz) = c7d77dafe78afcf2e92567c7cdfda45dcfe41ea71efb2e326ef4f7eb66ec416b
+SIZE (postgresql/pg-833-icu-xx-2008-08-28.diff.gz) = 5302
--- /dev/null
+++ databases/postgresql83-server/pkg-plist-contrib
@@ -0,0 +1,109 @@
+bin/oid2name
+bin/pg_standby
+bin/pgbench
+bin/vacuumlo
+lib/postgresql/_int.so
+lib/postgresql/adminpack.so
+lib/postgresql/autoinc.so
+lib/postgresql/btree_gist.so
+lib/postgresql/chkpass.so
+lib/postgresql/cube.so
+lib/postgresql/dblink.so
+lib/postgresql/dict_int.so
+lib/postgresql/dict_xsyn.so
+lib/postgresql/earthdistance.so
+lib/postgresql/fuzzystrmatch.so
+lib/postgresql/hstore.so
+lib/postgresql/insert_username.so
+lib/postgresql/int_aggregate.so
+lib/postgresql/isn.so
+lib/postgresql/lo.so
+lib/postgresql/ltree.so
+lib/postgresql/moddatetime.so
+lib/postgresql/pageinspect.so
+lib/postgresql/pg_buffercache.so
+lib/postgresql/pg_freespacemap.so
+lib/postgresql/pg_trgm.so
+lib/postgresql/pgcrypto.so
+lib/postgresql/pgrowlocks.so
+lib/postgresql/pgstattuple.so
+lib/postgresql/refint.so
+lib/postgresql/seg.so
+lib/postgresql/sslinfo.so
+lib/postgresql/tablefunc.so
+lib/postgresql/test_parser.so
+lib/postgresql/timetravel.so
+lib/postgresql/tsearch2.so
+%%DOCSDIR%%/README-contrib
+%%DOCSDIR%%/contrib/README
+%%DOCSDIR%%/contrib/autoinc.example
+%%DOCSDIR%%/contrib/insert_username.example
+%%DOCSDIR%%/contrib/moddatetime.example
+%%DOCSDIR%%/contrib/refint.example
+%%DOCSDIR%%/contrib/timetravel.example
+share/postgresql/contrib/_int.sql
+share/postgresql/contrib/adminpack.sql
+share/postgresql/contrib/autoinc.sql
+share/postgresql/contrib/btree_gist.sql
+share/postgresql/contrib/chkpass.sql
+share/postgresql/contrib/cube.sql
+share/postgresql/contrib/dblink.sql
+share/postgresql/contrib/dict_int.sql
+share/postgresql/contrib/dict_xsyn.sql
+share/postgresql/contrib/earthdistance.sql
+share/postgresql/contrib/fuzzystrmatch.sql
+share/postgresql/contrib/hstore.sql
+share/postgresql/contrib/insert_username.sql
+share/postgresql/contrib/int_aggregate.sql
+share/postgresql/contrib/isn.sql
+share/postgresql/contrib/lo.sql
+share/postgresql/contrib/ltree.sql
+share/postgresql/contrib/moddatetime.sql
+share/postgresql/contrib/pageinspect.sql
+share/postgresql/contrib/pg_buffercache.sql
+share/postgresql/contrib/pg_freespacemap.sql
+share/postgresql/contrib/pg_trgm.sql
+share/postgresql/contrib/pgcrypto.sql
+share/postgresql/contrib/pgrowlocks.sql
+share/postgresql/contrib/pgstattuple.sql
+share/postgresql/contrib/refint.sql
+share/postgresql/contrib/seg.sql
+share/postgresql/contrib/sslinfo.sql
+share/postgresql/contrib/tablefunc.sql
+share/postgresql/contrib/test_parser.sql
+share/postgresql/contrib/timetravel.sql
+share/postgresql/contrib/tsearch2.sql
+share/postgresql/contrib/uninstall__int.sql
+share/postgresql/contrib/uninstall_adminpack.sql
+share/postgresql/contrib/uninstall_btree_gist.sql
+share/postgresql/contrib/uninstall_chkpass.sql
+share/postgresql/contrib/uninstall_cube.sql
+share/postgresql/contrib/uninstall_dblink.sql
+share/postgresql/contrib/uninstall_dict_int.sql
+share/postgresql/contrib/uninstall_dict_xsyn.sql
+share/postgresql/contrib/uninstall_earthdistance.sql
+share/postgresql/contrib/uninstall_fuzzystrmatch.sql
+share/postgresql/contrib/uninstall_hstore.sql
+share/postgresql/contrib/uninstall_int_aggregate.sql
+share/postgresql/contrib/uninstall_isn.sql
+share/postgresql/contrib/uninstall_lo.sql
+share/postgresql/contrib/uninstall_ltree.sql
+share/postgresql/contrib/uninstall_pageinspect.sql
+share/postgresql/contrib/uninstall_pg_buffercache.sql
+share/postgresql/contrib/uninstall_pg_freespacemap.sql
+share/postgresql/contrib/uninstall_pg_trgm.sql
+share/postgresql/contrib/uninstall_pgcrypto.sql
+share/postgresql/contrib/uninstall_pgrowlocks.sql
+share/postgresql/contrib/uninstall_pgstattuple.sql
+share/postgresql/contrib/uninstall_seg.sql
+share/postgresql/contrib/uninstall_sslinfo.sql
+share/postgresql/contrib/uninstall_tablefunc.sql
+share/postgresql/contrib/uninstall_test_parser.sql
+share/postgresql/contrib/uninstall_tsearch2.sql
+share/postgresql/tsearch_data/xsyn_sample.rules
+ at dirrmtry share/postgresql/tsearch_data >&2
+ at dirrmtry share/postgresql/contrib >&2
+ at dirrmtry share/postgresql >&2
+ at dirrmtry %%DOCSDIR%%/contrib >&2
+ at dirrmtry %%DOCSDIR%% >&2
+ at dirrmtry lib/postgresql >&2
--- /dev/null
+++ databases/postgresql83-server/pkg-plist-pltcl
@@ -0,0 +1,9 @@
+%%DOCSDIR%%/README-pltcl
+lib/postgresql/pltcl.so
+ at dirrmtry lib/postgresql
+bin/pltcl_loadmod
+bin/pltcl_delmod
+bin/pltcl_listmod
+share/postgresql/unknown.pltcl
+ at dirrmtry share/postgresql
+ at dirrmtry %%DOCSDIR%%
--- /dev/null
+++ databases/postgresql83-server/pkg-install-server
@@ -0,0 +1,63 @@
+#! /bin/sh
+
+# $FreeBSD: ports/databases/postgresql83-server/pkg-install-server,v 1.7 2008/02/18 12:55:02 girgen Exp $
+
+PATH=/bin:/usr/bin:/usr/sbin
+
+backupwarning() { echo "
+
+  =========== BACKUP YOUR DATA! =============
+  As always, backup your data before
+  upgrading. If the upgrade leads to a higher
+  minor revision (e.g. 7.3.x -> 7.4), a dump
+  and restore of all databases is
+  required. This is *NOT* done by the port!
+
+  Press ctrl-C *now* if you need to pg_dump.
+  ===========================================
+"
+	sleep 5
+}
+
+case $2 in
+PRE-INSTALL)
+	backupwarning
+	PGUSER=${PGUSER:-pgsql}
+	PGGROUP=${PGGROUP:-pgsql}
+	DB_DIR=${PKG_PREFIX}/${PGUSER}
+	UID=70
+	GID=70
+
+	if pw group show "${PGGROUP}" 2>/dev/null; then
+		echo "You already have a group \"${PGGROUP}\", so I will use it."
+	else
+		if pw groupadd ${PGGROUP} -g ${GID}; then
+			echo "Added group \"${PGGROUP}\"."
+		else
+			echo "Adding group \"${PGGROUP}\" failed..."
+			exit 1
+		fi
+	fi
+
+	if pw user show "${PGUSER}" 2>/dev/null; then
+		echo "You already have a user \"${PGUSER}\", so I will use it."
+	else
+		if pw useradd ${PGUSER} -u ${UID} -g ${PGGROUP} -h - \
+			-d ${DB_DIR} -c "PostgreSQL Daemon"
+		then
+			echo "Added user \"${PGUSER}\"."
+		else
+			echo "Adding user \"${PGUSER}\" failed..."
+			exit 1
+		fi
+	fi
+
+	if ! [ -x ~${PGUSER} ] ; then 
+		install -m 755 -o ${PGUSER} -g ${PGGROUP} -d ${DB_DIR}
+	fi
+	;;
+
+BACKUPWARNING)
+	backupwarning
+	;;
+esac
--- /dev/null
+++ databases/postgresql83-server/pkg-plist-plpython
@@ -0,0 +1,4 @@
+%%DOCSDIR%%/README-plpython
+lib/postgresql/plpython.so
+ at dirrmtry lib/postgresql
+ at dirrmtry %%DOCSDIR%%
--- /dev/null
+++ databases/postgresql83-server/Makefile
@@ -0,0 +1,322 @@
+# $MidnightBSD: mports/databases/postgresql83-server/Makefile,v 1.1 2009/03/14 15:03:05 laffer1 Exp $
+
+PORTNAME?=	postgresql
+DISTVERSION?=	8.3.6
+CATEGORIES?=	databases
+MASTER_SITES=	${MASTER_SITE_PGSQL}
+MASTER_SITE_SUBDIR=	source/v${DISTVERSION}
+PKGNAMESUFFIX?=	-server
+
+MAINTAINER?=	ports at MidnightBSD.org
+COMMENT?=	The most advanced open-source database available anywhere
+LICENSE=	mit
+
+CONFLICTS?=	${PORTNAME}-client-7.* \
+		${PORTNAME}${PKGNAMESUFFIX}-7.* \
+		${PORTNAME}-client-8.[0-24-9]* \
+		${PORTNAME}${PKGNAMESUFFIX}-8.[0-24-9]*
+
+WRKSRC=		${WRKDIR}/postgresql-${DISTVERSION}
+DIST_SUBDIR=	postgresql
+
+UNIQUENAME?=	${PORTNAME}83
+LATEST_LINK?=	${PKGNAMEPREFIX}${UNIQUENAME}${PKGNAMESUFFIX}
+
+SUB_FILES+=	dot.cshrc dot.profile
+
+PKGINSTALL?=	${PKGDIR}/pkg-install${PKGNAMESUFFIX}
+USE_BZIP2=	YES
+USE_GMAKE=	YES
+GNU_CONFIGURE=	YES
+.if defined(NO_BUILD)
+.undef USE_GMAKE
+.undef GNU_CONFIGURE
+.endif
+
+PGUSER=		pgsql
+PGGROUP=	pgsql
+
+CONFIGURE_ARGS+=--with-libraries=${LOCALBASE}/lib \
+		--with-includes=${LOCALBASE}/include \
+		--enable-thread-safety \
+		--with-docdir=${DOCSDIR}
+CONFIGURE_ENV+=	LDFLAGS="${LDFLAGS}" \
+		PTHREAD_CFLAGS="${PTHREAD_CFLAGS}" \
+		PTHREAD_LIBS="${PTHREAD_LIBS}"
+
+CFLAGS+=	${PTHREAD_CFLAGS}
+LDFLAGS+=	${PTHREAD_LIBS}
+
+PLIST=		${PKGDIR}/pkg-plist${PKGNAMESUFFIX}
+
+BUILD_DIRS?=	src/port src/timezone src/backend src/backend/utils/mb/conversion_procs \
+		src/backend/snowball src/bin/initdb src/bin/ipcclean src/bin/pg_ctl \
+		src/bin/pg_controldata src/bin/pg_resetxlog src/pl
+
+INSTALL_DIRS?=	${BUILD_DIRS}
+
+.if !defined(CLIENT_ONLY) && !defined(SLAVE_ONLY)
+SERVER_ONLY=	yes
+USE_RC_SUBR=	postgresql
+USE_PGSQL=	yes
+WANT_PGSQL_VER=	${PORTVERSION:C/([0-9][0-9]*)\.([0-9][0-9]*).*/\1\2/g}
+.endif
+
+.if !defined(SLAVE_ONLY)
+OPTIONS=	NLS "Use internationalized messages" on
+.endif
+
+.if !defined(CLIENT_ONLY)
+MAKE_ENV=	PATH=${PREFIX}/bin:${PATH}
+CONFIGURE_ENV+=	PATH=${PREFIX}/bin:${PATH}
+.endif
+
+# Cannot check this with standard OPTION due to a catch-22.
+# USE_OPENSSL must precede bsd.port.pre.mk, but then we don't know
+# what OPTIONS are set.
+#
+# If you *don't* want SSL, set WITHOUT_SSL=YES when making
+.if !defined(WITHOUT_SSL)
+USE_OPENSSL=	yes
+CONFIGURE_ARGS+=--with-openssl
+.endif
+
+.include <bsd.port.pre.mk>
+
+.if !defined(SLAVE_ONLY)
+OPTIONS+=	PAM "Build with PAM support (server only)" off
+OPTIONS+=	LDAP "Build with LDAP authentication support" off
+OPTIONS+=	MIT_KRB5 "Build with MIT's kerberos support" off
+OPTIONS+=	HEIMDAL_KRB5 "Builds with Heimdal kerberos support" off
+OPTIONS+=	OPTIMIZED_CFLAGS "Builds with compiler optimizations (-O3)" off
+OPTIONS+=	XML "Build with XML data type (server)" on
+OPTIONS+=	TZDATA "Use internal timezone database (server)" on
+OPTIONS+=	DEBUG "Builds with debugging symbols" off
+
+# See http://people.freebsd.org/~girgen/postgresql-icu/README.html for more info
+OPTIONS+=	ICU   "Use ICU for unicode collation (server)" off
+
+# See http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/76999 for more info
+# (requires dump/restore if modified.)
+OPTIONS+=	INTDATE "Builds with 64-bit date/time type (server)" off
+
+.  if (defined(SERVER_ONLY) && defined(WITH_ICU)) || make(makesum)
+USE_AUTOTOOLS=	autoconf:262
+CONFIGURE_ARGS+=--with-icu
+LIB_DEPENDS=	icudata:${PORTSDIR}/devel/icu
+PATCH_SITES+=	http://people.freebsd.org/~girgen/postgresql-icu/:icu
+PATCHFILES+=	pg-833-icu-xx-2008-08-28.diff.gz:icu
+.  endif
+
+PATCH_DIST_STRIP=-p1
+
+.  if defined(SERVER_ONLY) && defined(WITH_PAM)
+CONFIGURE_ARGS+=--with-pam
+.  endif
+
+.  if defined(SERVER_ONLY) && defined(WITH_LDAP)
+CONFIGURE_ARGS+=--with-ldap
+USE_OPENLDAP=	YES
+.  endif
+
+.  if defined(SERVER_ONLY) && defined(WITH_XML)
+CONFIGURE_ARGS+=--with-libxml
+LIB_DEPENDS+=	xml2.5:${PORTSDIR}/textproc/libxml2
+.  endif
+
+.  if defined(SERVER_ONLY) && defined(WITH_TZDATA)
+PLIST_SUB+=	TZDATA=""
+.  else
+CONFIGURE_ARGS+=--with-system-tzdata=/usr/share/zoneinfo
+PLIST_SUB+=	TZDATA="@comment "
+.  endif
+
+.  if defined(WITH_INTDATE)
+CONFIGURE_ARGS+=--enable-integer-datetimes
+.  endif
+
+.  if !(defined(WITHOUT_GETTEXT) || defined(WITHOUT_NLS))
+CONFIGURE_ARGS+=--enable-nls
+PLIST_SUB+=	GETTEXT=""
+USE_GETTEXT=	YES
+.  else
+CONFIGURE_ARGS+=--disable-nls
+PLIST_SUB+=	GETTEXT="@comment "
+.  endif
+
+.  if defined(WITH_OPTIMIZED_CFLAGS)
+CFLAGS+=	-O3 -funroll-loops
+.  endif
+
+.  if defined(WITH_DEBUG)
+CONFIGURE_ARGS+=--enable-debug
+INSTALL_TARGET=	install
+.  else
+INSTALL_TARGET=	install-strip
+.  endif
+
+.  if defined(WITH_MIT_KRB5)
+.    if exists(/usr/lib/libkrb5.so) || exists(/usr/bin/krb5-config)
+BROKEN=		"You must remove heimdal's /usr/bin/krb5-config and /usr/lib/libkrb5.so*, and set NO_KERBEROS=true in /etc/make.conf to build successfully with MIT-KRB"
+.    endif
+# Allow defining a home built MIT Kerberos by setting KRB5_HOME
+.    if defined(KRB5_HOME) && exists(${KRB5_HOME}/lib/libgssapi_krb5.a) && exists(${KRB5_HOME}/bin/krb5-config)
+CONFIGURE_ARGS+=--with-krb5
+.    else
+LIB_DEPENDS+=	krb5.3:${PORTSDIR}/security/krb5
+CONFIGURE_ARGS+=--with-krb5
+.    endif
+.  endif
+
+.  if defined(WITH_HEIMDAL_KRB5)
+# Allow defining a home built Heimdal Kerberos by setting HEIMDAL_HOME
+.    if defined(HEIMDAL_HOME) && exists(${HEIMDAL_HOME}/lib/libgssapi.a) && exists(${HEIMDAL_HOME}/bin/krb5-config)
+CONFIGURE_ARGS+=--with-krb5
+.    else
+# Postgresql apps will not link properly when libpq is linked with base heimdal in /usr,
+# so we always use the heimdal port. See
+# http://lists.freebsd.org/pipermail/freebsd-stable/2005-October/018809.html
+LIB_DEPENDS+=	krb5.23:${PORTSDIR}/security/heimdal
+CONFIGURE_ARGS+=--with-krb5
+.    endif
+.  endif
+
+.endif # !SLAVE_ONLY
+
+.if defined(CLIENT_ONLY)
+MAN1=		clusterdb.1 createdb.1 createlang.1 createuser.1   \
+		dropdb.1 droplang.1 dropuser.1 ecpg.1 initdb.1	   \
+		ipcclean.1 pg_config.1 pg_controldata.1 pg_ctl.1   \
+		pg_dump.1 pg_dumpall.1 pg_resetxlog.1 pg_restore.1 \
+		postgres.1 postmaster.1 psql.1 reindexdb.1 vacuumdb.1
+
+MAN7=		abort.7 alter_aggregate.7 alter_conversion.7 alter_database.7 \
+		alter_domain.7 alter_function.7 alter_group.7		      \
+		alter_index.7 alter_language.7 alter_operator_class.7	      \
+		alter_operator_family.7 				      \
+		alter_role.7						      \
+		alter_schema.7 alter_sequence.7 alter_table.7		      \
+		alter_text_search_configuration.7			      \
+		alter_text_search_dictionary.7				      \
+		alter_text_search_parser.7				      \
+		alter_text_search_template.7				      \
+		alter_trigger.7 alter_user.7 alter_view.7 analyze.7 begin.7   \
+		checkpoint.7 close.7 cluster.7 comment.7 commit.7	      \
+		commit_prepared.7					      \
+		copy.7 create_aggregate.7 create_cast.7			      \
+		create_constraint_trigger.7 create_conversion.7		      \
+		create_database.7 create_domain.7 create_function.7	      \
+		create_group.7 create_index.7 create_language.7		      \
+		create_operator.7 create_operator_class.7		      \
+		create_operator_family.7 create_role.7			      \
+		create_rule.7 create_schema.7 create_sequence.7		      \
+		create_table.7 create_table_as.7			      \
+		create_text_search_configuration.7			      \
+		create_text_search_dictionary.7				      \
+		create_text_search_parser.7				      \
+		create_text_search_template.7 create_trigger.7		      \
+		create_type.7 create_user.7 create_view.7 deallocate.7	      \
+		declare.7 delete.7 discard.7				      \
+		drop_aggregate.7 drop_cast.7 drop_conversion.7		      \
+		drop_database.7 drop_domain.7 drop_function.7		      \
+		drop_group.7 drop_index.7 drop_language.7		      \
+		drop_operator.7 drop_operator_class.7 drop_operator_family.7  \
+		drop_owned.7 drop_role.7 drop_rule.7			      \
+		drop_schema.7 drop_sequence.7 drop_table.7		      \
+		drop_text_search_configuration.7			      \
+		drop_text_search_dictionary.7				      \
+		drop_text_search_parser.7				      \
+		drop_text_search_template.7 drop_trigger.7		      \
+		drop_type.7 drop_user.7 drop_view.7 end.7 execute.7	      \
+		explain.7 fetch.7 grant.7 insert.7 listen.7 load.7	      \
+		lock.7 move.7 notify.7 prepare.7 prepare_transaction.7	      \
+		reassign_owned.7 reindex.7 reset.7			      \
+		revoke.7 rollback.7 rollback_prepared.7 select.7	      \
+		select_into.7 set.7					      \
+		set_constraints.7 set_role.7 set_transaction.7 show.7	      \
+		set_session_authorization.7 start_transaction.7		      \
+		truncate.7 unlisten.7 update.7 vacuum.7			      \
+		alter_operator.7 alter_tablespace.7 alter_type.7	      \
+		create_tablespace.7 drop_tablespace.7			      \
+		release_savepoint.7 rollback_to_savepoint.7		      \
+		savepoint.7 values.7
+.endif
+
+.if defined(SERVER_ONLY)
+pre-everything::
+	@${SH} ${PKGINSTALL} ${PORTNAME} BACKUPWARNING
+.endif
+
+.if !defined(NO_BUILD)
+
+pre-configure:
+.  if defined(WITH_MIT_KRB5) && defined(WITH_HEIMDAL_KRB5)
+	@${ECHO} "MIT's and Heimdal Kerberos are mutually exclusive."
+	@${ECHO} "Please choose one or the other."
+	@exit 1
+.  endif
+
+do-build:
+	@ cd ${WRKSRC}/src/backend ;\
+	${GMAKE} ${FAKE_MAKEARGS} ../../src/include/parser/parse.h ../../src/include/utils/fmgroids.h
+	@ for dir in ${BUILD_DIRS}; do \
+		cd ${WRKSRC}/$${dir} && ${SETENV} ${MAKE_ENV} ${GMAKE} ${FAKE_MAKEARGS}; \
+	done
+
+.  if exists(${FILESDIR}/pkg-message${PKGNAMESUFFIX}.in)
+SUB_FILES+=	pkg-message${PKGNAMESUFFIX}
+PKGMESSAGE=	${WRKSRC}/pkg-message${PKGNAMESUFFIX}
+.  endif
+.endif
+
+.if defined(SERVER_ONLY)
+pre-install:
+	@ ${SETENV} PKG_PREFIX=${FAKE_DESTDIR}${PREFIX} PGUSER=${PGUSER} PGGROUP=${PGGROUP} \
+		${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL
+.endif
+
+.if !defined(NO_BUILD)
+do-install:
+	@for dir in ${INSTALL_DIRS}; do \
+	    cd ${WRKSRC}/$${dir} && \
+		${SETENV} ${MAKE_ENV} ${GMAKE} ${FAKE_MAKEARGS} ${INSTALL_TARGET}; \
+	done
+.if defined(SERVER_ONLY)
+	@ ${MKDIR} ${PREFIX}/share/postgresql
+	@ ${MKDIR} ${PREFIX}/pgsql
+.for i in profile cshrc
+	${INSTALL_DATA} ${WRKDIR}/dot.$i ${PREFIX}/share/postgresql/dot.$i.dist; \
+	${INSTALL_DATA} -o pgsql -g pgsql ${WRKDIR}/dot.$i ${PREFIX}/pgsql/dot.$i.dist ; \
+	if [ ! -f ${PREFIX}/pgsql/.$i ]; then \
+		${CP} -p ${PREFIX}/pgsql/dot.$i.dist ${PREFIX}/pgsql/.$i; \
+	fi
+.endfor
+	@ ${CHOWN} -R pgsql:pgsql ${PREFIX}/pgsql/. ;\
+	${MKDIR} ${PREFIX}/etc/periodic/daily ;\
+	${INSTALL_SCRIPT} ${FILESDIR}/502.pgsql \
+			${PREFIX}/etc/periodic/daily
+.  endif # SERVER_ONLY
+.  if defined(CLIENT_ONLY)
+	@ cd ${WRKSRC}/src && ${SETENV} ${MAKE_ENV} ${GMAKE} ${FAKE_MAKEARGS} install-local
+.  endif
+	@ if [ -r ${PKGMESSAGE} ]; then \
+		${MKDIR} ${DOCSDIR} ;\
+		${INSTALL_DATA} ${PKGMESSAGE} ${DOCSDIR}/README${PKGNAMESUFFIX} ;\
+		${ECHO} "======================================================================" ;\
+		${CAT} ${PKGMESSAGE} ;\
+		${ECHO} "======================================================================" ;\
+	fi
+.endif # !NO_BUILD
+
+.if defined(SERVER_ONLY)
+check:
+	@if [ `id -u` != 0 ] ; then \
+	  ${ECHO} "Running postgresql regressions tests" ;\
+	  cd ${WRKSRC}; ${GMAKE} ${FAKE_MAKEARGS} check ;\
+	 else \
+	  ${ECHO} "You cannot run regression tests when postgresql is built as user root." ; \
+	  ${ECHO} "Clean and rebuild the port as a regular user to run the tests." ;\
+	 fi
+.endif
+
+.include <bsd.port.post.mk>
--- /dev/null
+++ databases/postgresql83-server/files/pkg-message-pltcl.in
@@ -0,0 +1,3 @@
+PL/Tcl has been  installed. Check the createlang(l) manpage for more
+info. You can install pltcl as trusted or untrusted, by using either
+"createlang pltcl" or "createlang pltclu".
--- /dev/null
+++ databases/postgresql83-server/files/patch-plpython-Makefile
@@ -0,0 +1,11 @@
+--- src/pl/plpython/Makefile.orig	Fri Nov 19 20:23:01 2004
++++ src/pl/plpython/Makefile	Tue Dec 28 23:32:16 2004
+@@ -9,7 +9,7 @@
+ # shared library.  Since there is no official way to determine this
+ # (at least not in pre-2.3 Python), we see if there is a file that is
+ # named like a shared library.
+-ifneq (,$(wildcard $(python_libdir)/libpython*$(DLSUFFIX)*))
++ifneq (,$(wildcard $(python_libdir)/../../libpython*$(DLSUFFIX)*))
+ shared_libpython = yes
+ endif
+ 
--- /dev/null
+++ databases/postgresql83-server/files/pkgIndex.tcl.in
@@ -0,0 +1,4 @@
+# Package-index file for Pgtcl-package. Enables you to load PostgreSQL
+# interface functions right into you TCL-interpreter as simply as
+#	package require Pgtcl
+package ifneeded Pgtcl 1.3 "load %%PREFIX%%/lib/libpgtcl.so"
--- /dev/null
+++ databases/postgresql83-server/files/dot.profile.in
@@ -0,0 +1,22 @@
+PGLIB=%%PREFIX%%/lib
+
+# note: PGDATA can be overridden by the -D startup option
+PGDATA=${HOME}/data
+
+export PATH PGLIB PGDATA
+
+# if you use the periodic script from share/postgresql/502.pgsql, you
+# can set these
+#PGDUMP_ARGS="-b -F c"
+#PGBACKUPDIR=${HOME}/backups
+#PGBACKUP_SAVE_DAYS=7
+#export PGBACKUPDIR PGDUMP_ARGS PGBACKUP_SAVE_DAYS
+
+#You might want to set some locale stuff here
+#PGDATESTYLE=ISO
+#LC_ALL=sv_SE.ISO_8859-1
+#export PGDATESTYLE LC_ALL
+
+# if you want to make regression tests use this TZ
+#TZ=PST8PDT
+#export TZ
--- /dev/null
+++ databases/postgresql83-server/files/pkg-message-server.in
@@ -0,0 +1,70 @@
+For procedural languages and postgresql functions, please note that
+you might have to update them when updating the server.
+
+If you have many tables and many clients running, consider raising
+kern.maxfiles using sysctl(8), or reconfigure your kernel
+appropriately.
+
+The port is set up to use autovacuum for new databases, but you might
+also want to vacuum and perhaps backup your database regularly. There
+is a periodic script, %%PREFIX%%/etc/periodic/daily/502.pgsql, that
+you may find useful. You can use it to backup and perfom vacuum on all
+databases nightly. Per default, it perfoms `vacuum analyze'. See the
+script for instructions. For autovacuum settings, please review
+~pgsql/data/postgresql.conf.
+
+To allow many simultaneous connections to your PostgreSQL server, you
+should raise the SystemV shared memory limits in your kernel. Here are
+example values for allowing up to 180 clients (configurations in
+postgresql.conf also needed, of course):
+  options         SYSVSHM
+  options         SYSVSEM
+  options         SYSVMSG
+  options         SHMMAXPGS=65536
+  options         SEMMNI=40
+  options         SEMMNS=240
+  options         SEMUME=40
+  options         SEMMNU=120
+
+If you plan to access your PostgreSQL server using ODBC, please
+consider running the SQL script %%PREFIX%%/share/postgresql/odbc.sql
+to get the functions required for ODBC compliance.
+
+Please note that if you use the rc script,
+%%PREFIX%%/etc/rc.d/postgresql, to initialize the database, unicode
+(UTF-8) will be used to store character data by default.  Set
+postgresql_initdb_flags or use login.conf settings described below to
+alter this behaviour. See the start rc script for more info.
+
+To set limits, environment stuff like locale and collation and other
+things, you can set up a class in /etc/login.conf before initializing
+the database. Add something similar to this to /etc/login.conf:
+---
+postgres:\
+	:lang=en_US.UTF-8:\
+	:setenv=LC_COLLATE=C:\
+	:tc=default:
+---
+and run `cap_mkdb /etc/login.conf'.
+Then add 'postgresql_class="postgres"' to /etc/rc.conf.
+
+======================================================================
+
+To initialize the database, run
+
+  %%PREFIX%%/etc/rc.d/postgresql initdb
+
+You can then start PostgreSQL by running:
+
+  %%PREFIX%%/etc/rc.d/postgresql start
+
+For postmaster settings, see ~pgsql/data/postgresql.conf
+
+NB. FreeBSD's PostgreSQL port logs to syslog by default
+    See ~pgsql/data/postgresql.conf for more info
+
+======================================================================
+
+To run PostgreSQL at startup, add
+'postgresql_enable="YES"' to /etc/rc.conf
+
--- /dev/null
+++ databases/postgresql83-server/files/postgresql.in
@@ -0,0 +1,64 @@
+#!/bin/sh
+
+# $FreeBSD: ports/databases/postgresql83-server/files/postgresql.in,v 1.2 2007/01/09 16:29:35 girgen Exp $
+#
+# PROVIDE: postgresql
+# REQUIRE: LOGIN
+# KEYWORD: shutdown
+#
+# Add the following line to /etc/rc.conf to enable PostgreSQL:
+#
+#  postgresql_enable="YES"
+#  # optional
+#  postgresql_data="%%PREFIX%%/pgsql/data"
+#  postgresql_flags="-w -s -m fast"
+#  postgresql_initdb_flags="--encoding=utf-8 --lc-collate=C"
+#  postgresql_class="default"
+#
+# See %%PREFIX%%/share/doc/postgresql/README-server for more info
+#
+# This scripts takes one of the following commands:
+#
+#   start stop restart reload status initdb
+#
+# For postmaster startup options, edit ${postgresql_data}/postgresql.conf
+
+prefix=%%PREFIX%%
+command=${prefix}/bin/pg_ctl
+
+. %%RC_SUBR%%
+
+load_rc_config postgresql
+
+# set defaults
+postgresql_enable=${postgresql_enable:-"NO"}
+postgresql_flags=${postgresql_flags:-"-w -s -m fast"}
+postgresql_user=pgsql
+eval postgresql_data=${postgresql_data:-"~${postgresql_user}/data"}
+postgresql_class=${postgresql_class:-"default"}
+postgresql_initdb_flags=${postgresql_initdb_flags:-"--encoding=utf-8 --lc-collate=C"}
+
+name=postgresql
+rcvar=`set_rcvar`
+command_args="-D ${postgresql_data} ${postgresql_flags}"
+extra_commands="reload initdb"
+
+start_cmd="postgresql_command start"
+stop_cmd="postgresql_command stop"
+restart_cmd="postgresql_command restart"
+reload_cmd="postgresql_command reload"
+status_cmd="postgresql_command status"
+
+initdb_cmd="postgresql_initdb"
+
+postgresql_command()
+{
+    su -l ${postgresql_user} -c "exec ${command} ${command_args} ${rc_arg}"
+}
+    
+postgresql_initdb()
+{
+    su -l -c ${postgresql_class} ${postgresql_user} -c "exec ${prefix}/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data}"
+}
+
+run_rc_command "$1"
--- /dev/null
+++ databases/postgresql83-server/files/pkg-message-plperl.in
@@ -0,0 +1,3 @@
+PL/Perl has been installed. Check the createlang(l) manpage for more
+info. You can install PL/Perl as trusted or untrusted, by using either
+"createlang plperl" or "createlang plperlu".
--- /dev/null
+++ databases/postgresql83-server/files/pkg-message-contrib.in
@@ -0,0 +1,3 @@
+The PostgreSQL contrib utilities have been installed. Please see
+%%PREFIX%%/share/doc/postgresql/contrib/README
+for more information.
--- /dev/null
+++ databases/postgresql83-server/files/patch-src:backend:utils:misc:postgresql.conf.sample
@@ -0,0 +1,27 @@
+--- src/backend/utils/misc/postgresql.conf.sample.orig	2008-01-30 19:35:55.000000000 +0100
++++ src/backend/utils/misc/postgresql.conf.sample	2008-02-18 13:49:42.000000000 +0100
+@@ -231,6 +231,7 @@
+ 
+ # - Where to Log -
+ 
++log_destination = 'syslog'
+ #log_destination = 'stderr'		# Valid values are combinations of
+ 					# stderr, csvlog, syslog and eventlog,
+ 					# depending on platform.  csvlog
+@@ -313,6 +314,7 @@
+ 					# and their durations, > 0 logs only
+ 					# statements running at least this time.
+ 
++silent_mode = on
+ #silent_mode = off			# DO NOT USE without syslog or
+ 					# logging_collector
+ 					# (change requires restart)
+@@ -365,6 +367,8 @@
+ #track_counts = on
+ #update_process_title = on
+ 
++# On FreeBSD, this is a performance hog, so keep it off if you need speed
++update_process_title = off
+ 
+ # - Statistics Monitoring -
+ 
--- /dev/null
+++ databases/postgresql83-server/files/patch-doc-Makefile
@@ -0,0 +1,20 @@
+--- doc/Makefile.orig	2007-02-09 16:55:57.000000000 +0100
++++ doc/Makefile	2008-01-02 11:38:43.000000000 +0100
+@@ -25,11 +25,12 @@
+ 
+ .NOTPARALLEL:
+ 
+-ifneq ($(wildcard $(srcdir)/postgres.tar.gz),)
+-ifneq (,$(docdir))
+-found_html = yes
+-endif
+-endif
++# FreeBSD has a separate port for installing the documentation
++#ifneq ($(wildcard $(srcdir)/postgres.tar.gz),)
++#ifneq (,$(docdir))
++#found_html = yes
++#endif
++#endif
+ 
+ ifneq ($(wildcard $(srcdir)/man.tar.gz),)
+ # SCO OpenServer's man system is sufficiently different to not bother.
--- /dev/null
+++ databases/postgresql83-server/files/pkg-message-plpython.in
@@ -0,0 +1,3 @@
+PL/Python has been installed. Check the createlang(l) manpage for more
+info. You can install PL/Python by using "createlang plpythonu" (it
+exists as an untrusted language only).
--- /dev/null
+++ databases/postgresql83-server/files/dot.cshrc.in
@@ -0,0 +1,11 @@
+setenv PGLIB %%PREFIX%%/lib
+
+# note: PGDATA can be overridden by the -D startup option
+setenv PGDATA $HOME/data
+
+#You might want to set some locale stuff here
+#setenv PGDATESTYLE ISO
+#setenv LC_ALL sv_SE.ISO_8859-1
+
+# if you want to make regression tests use this TZ
+#setenv TZ PST8PDT
--- /dev/null
+++ databases/postgresql83-server/files/502.pgsql
@@ -0,0 +1,94 @@
+#!/bin/sh
+#
+# $FreeBSD: ports/databases/postgresql83-server/files/502.pgsql,v 1.10 2008/11/07 09:49:49 girgen Exp $
+#
+# Maintenance shell script to vacuum and backup database
+# Put this in /usr/local/etc/periodic/daily, and it will be run 
+# every night
+#
+# Written by Palle Girgensohn <girgen at pingpong.net>
+#
+# In public domain, do what you like with it,
+# and use it at your own risk... :)
+#
+
+# Define these variables in either /etc/periodic.conf or
+# /etc/periodic.conf.local to override the default values.
+#
+# daily_pgsql_backup_enable="YES" # do backup
+# daily_pgsql_vacuum_enable="YES" # do vacuum
+
+daily_pgsql_vacuum_args="-z"
+daily_pgsql_pgdump_args="-b -F c"
+# backupdir is relative to ~pgsql home directory unless it begins with a slash:
+daily_pgsql_backupdir="~pgsql/backups"
+daily_pgsql_savedays="7"
+
+# If there is a global system configuration file, suck it in.
+#
+if [ -r /etc/defaults/periodic.conf ]
+then
+    . /etc/defaults/periodic.conf
+    source_periodic_confs
+fi
+
+# allow '~´ in dir name
+eval backupdir=${daily_pgsql_backupdir}
+
+rc=0
+
+case "$daily_pgsql_backup_enable" in
+    [Yy][Ee][Ss])
+
+	# daily_pgsql_backupdir must be writeable by user pgsql
+	# ~pgsql is just that under normal circumstances,
+	# but this might not be where you want the backups...
+	if [ ! -d ${backupdir} ] ; then 
+	    echo Creating ${backupdir}
+	    mkdir -m 700 ${backupdir}; chown pgsql ${backupdir}
+	fi
+
+	echo
+	echo "PostgreSQL backups"
+
+	# Protect the data
+	umask 077
+	dbnames=`su -l pgsql -c "umask 077; psql -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"`
+	rc=$?
+	now=`date "+%Y-%m-%dT%H:%M:%S"`
+	file=${daily_pgsql_backupdir}/pgglobals_${now}
+	su -l pgsql -c "umask 077; pg_dumpall -g | gzip -9 > ${file}.gz"
+	for db in ${dbnames}; do
+	    echo -n " $db"
+	    file=${backupdir}/pgdump_${db}_${now}
+	    su -l pgsql -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}"
+	    [ $? -gt 0 ] && rc=3
+	done
+
+	if [ $rc -gt 0 ]; then
+	    echo
+	    echo "Errors were reported during backup."
+	fi
+
+	# cleaning up old data
+	find ${backupdir} \( -name 'pgdump_*' -o -name 'pgglobals_*' \) \
+	    -a -mtime +${daily_pgsql_savedays} -delete
+	;;
+esac
+
+case "$daily_pgsql_vacuum_enable" in
+    [Yy][Ee][Ss])
+
+	echo
+	echo "PostgreSQL vacuum"
+	su -l pgsql -c "vacuumdb -a -q ${daily_pgsql_vacuum_args}"
+	if [ $? -gt 0 ]
+	then
+	    echo
+	    echo "Errors were reported during vacuum."
+	    rc=3
+	fi
+	;;
+esac
+
+exit $rc
--- /dev/null
+++ databases/postgresql83-server/files/pkg-message-client.in
@@ -0,0 +1,32 @@
+The PostgreSQL port has a collection of "side orders":
+
+postgresql-doc
+  For all of the html documentation
+
+p5-Pg
+  A perl5 API for client access to PostgreSQL databases.
+
+postgresql-tcltk 
+  If you want tcl/tk client support.
+
+postgresql-jdbc
+  For Java JDBC support.
+
+postgresql-odbc
+  For client access from unix applications using ODBC as access
+  method. Not needed to access unix PostgreSQL servers from Win32
+  using ODBC. See below.
+
+ruby-postgres, py-PyGreSQL
+  For client access to PostgreSQL databases using the ruby & python
+  languages.
+
+p5-postgresql-plperl, postgresql-pltcl & postgresql-plruby
+  For using perl5, tcl & ruby as procedural languages.
+
+postgresql-contrib
+  Lots of contributed utilities, postgresql functions and
+  datatypes. There you find autovacuum, pgcrypto and many other cool
+  things.
+
+etc...
--- /dev/null
+++ databases/postgresql83-server/files/patch-src-makefiles-Makefile.freebsd
@@ -0,0 +1,8 @@
+--- src/makefiles/Makefile.freebsd.orig	Fri Nov 19 01:41:39 2004
++++ src/makefiles/Makefile.freebsd	Tue Dec 21 02:44:09 2004
+@@ -29,3 +29,5 @@
+ endif
+ 
+ sqlmansect = 7
++
++allow_nonpic_in_shlib = yes


More information about the Midnightbsd-cvs mailing list