aboutsummaryrefslogtreecommitdiff
path: root/databases/postgresql83-server
diff options
context:
space:
mode:
authorPalle Girgensohn <girgen@FreeBSD.org>2006-12-06 16:50:34 +0000
committerPalle Girgensohn <girgen@FreeBSD.org>2006-12-06 16:50:34 +0000
commit5b1dcdfc6fde3d24f31e5afec5e3d67d11a4e639 (patch)
tree749e476703326e12f11da8801bcad38fd8919838 /databases/postgresql83-server
parentae0d8f440c88d406aeda37b4d63cd43054514b37 (diff)
downloadports-5b1dcdfc6fde3d24f31e5afec5e3d67d11a4e639.tar.gz
ports-5b1dcdfc6fde3d24f31e5afec5e3d67d11a4e639.zip
Notes
Diffstat (limited to 'databases/postgresql83-server')
-rw-r--r--databases/postgresql83-server/Makefile92
-rw-r--r--databases/postgresql83-server/distinfo24
-rw-r--r--databases/postgresql83-server/files/patch-src:backend:utils:misc:postgresql.conf.sample13
-rw-r--r--databases/postgresql83-server/files/pkg-message-client.in (renamed from databases/postgresql83-server/pkg-message-client)0
-rw-r--r--databases/postgresql83-server/files/pkg-message-contrib.in (renamed from databases/postgresql83-server/pkg-message-contrib)2
-rw-r--r--databases/postgresql83-server/files/pkg-message-plperl.in (renamed from databases/postgresql83-server/pkg-message-plperl)0
-rw-r--r--databases/postgresql83-server/files/pkg-message-plpython.in (renamed from databases/postgresql83-server/pkg-message-plpython)0
-rw-r--r--databases/postgresql83-server/files/pkg-message-pltcl.in (renamed from databases/postgresql83-server/pkg-message-pltcl)0
-rw-r--r--databases/postgresql83-server/files/pkg-message-server.in70
-rw-r--r--databases/postgresql83-server/files/postgresql.in (renamed from databases/postgresql83-server/files/pgsql.sh.tmpl)5
-rw-r--r--databases/postgresql83-server/pkg-message-server49
-rw-r--r--databases/postgresql83-server/pkg-plist-client18
-rw-r--r--databases/postgresql83-server/pkg-plist-contrib69
-rw-r--r--databases/postgresql83-server/pkg-plist-server939
14 files changed, 671 insertions, 610 deletions
diff --git a/databases/postgresql83-server/Makefile b/databases/postgresql83-server/Makefile
index e99deb6677b8..ec3722ca98c1 100644
--- a/databases/postgresql83-server/Makefile
+++ b/databases/postgresql83-server/Makefile
@@ -6,28 +6,27 @@
#
PORTNAME?= postgresql
-PKGNAMESUFFIX?= -server
-PORTVERSION?= 8.1.4
-PORTREVISION?= 1
+PORTVERSION?= 8.2.0
+PORTREVISION?= 0
CATEGORIES?= databases
MASTER_SITES= ${MASTER_SITE_PGSQL}
MASTER_SITE_SUBDIR= source/v${PORTVERSION}
+PKGNAMESUFFIX?= -server
DISTFILES?= postgresql-base-${PORTVERSION}${EXTRACT_SUFX} \
postgresql-opt-${PORTVERSION}${EXTRACT_SUFX}
MAINTAINER?= girgen@FreeBSD.org
COMMENT?= The most advanced open-source database available anywhere
-CONFLICTS?= ${PORTNAME}-client-7.[0-9]* \
- ${PORTNAME}${PKGNAMESUFFIX}-7.[0-9]* \
- ${PORTNAME}-client-8.0.* \
- ${PORTNAME}${PKGNAMESUFFIX}-8.0.*
-BROKEN= work in progress
+CONFLICTS?= ${PORTNAME}-client-7.* \
+ ${PORTNAME}${PKGNAMESUFFIX}-7.* \
+ ${PORTNAME}-client-8.[0-13-9]* \
+ ${PORTNAME}${PKGNAMESUFFIX}-8.[0-13-9]*
WRKSRC= ${WRKDIR}/postgresql-${PORTVERSION}
DIST_SUBDIR= postgresql
-UNIQUENAME?= ${PORTNAME}81
+UNIQUENAME?= ${PORTNAME}82
LATEST_LINK?= ${PKGNAMEPREFIX}${UNIQUENAME}${PKGNAMESUFFIX}
PKGINSTALL?= ${PKGDIR}/pkg-install${PKGNAMESUFFIX}
@@ -47,14 +46,14 @@ CONFIGURE_ENV+= LDFLAGS="${LDFLAGS}"
PLIST= ${PKGDIR}/pkg-plist${PKGNAMESUFFIX}
BUILD_DIRS?= src/port src/timezone src/backend src/backend/utils/mb/conversion_procs \
- src/pl src/utils
+ src/pl config
+
INSTALL_DIRS?= ${BUILD_DIRS}
-PKGMESSAGE= ${WRKDIR}/.pkg-message${PKGNAMESUFFIX}
.if !defined(CLIENT_ONLY) && !defined(SLAVE_ONLY)
SERVER_ONLY= yes
-USE_RC_SUBR= yes
-RCSCRIPT= ${PREFIX}/etc/rc.d/010.pgsql.sh
+USE_RC_SUBR= postgresql
+SUB_FILES+= dot.cshrc dot.profile
USE_PGSQL= yes
WANT_PGSQL_VER= ${PORTVERSION:C/([0-9][0-9]*)\.([0-9][0-9]*).*/\1\2/g}
.endif
@@ -76,7 +75,7 @@ CONFIGURE_ARGS+=--with-openssl
.include <bsd.port.pre.mk>
.if ${ARCH} == "alpha" && ${OSVERSION} < 500000
-BROKEN= "Coredump during build on alpha 4.x"
+BROKEN= Coredump during build on alpha 4.x
.endif
.if !defined(SLAVE_ONLY)
@@ -95,7 +94,7 @@ OPTIONS+= TESTS "Allows the use of a \"check\" target (server)" off
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
+#OPTIONS+= ICU "Use ICU for unicode collation (server)" off
# See http://gppl.moonbone.ru/ for more info
#OPTIONS+= HIER "Builds with query hierarchy (server)" off
@@ -104,22 +103,26 @@ OPTIONS+= ICU "Use ICU for unicode collation (server)" off
# (requires dump/restore if modified.)
OPTIONS+= INTDATE "Builds with 64-bit date/time type (server)" off
-. if defined(SERVER_ONLY) && defined(WITH_HIER)
-#PATCH_SITES+= http://gppl.moonbone.ru/:hier801054
-#PATCHFILES+= hier-Pg8.0.1-0.5.4.diff.gz:hier801054
-#USE_BISON= yes
-. endif
+# . if (defined(SERVER_ONLY) && defined(WITH_HIER)) || make(makesum)
+# PATCH_SITES+= http://gppl.moonbone.ru/:hier812055
+# PATCHFILES+= hier-Pg8.1.2-0.5.5.diff.gz:hier812055
+# USE_BISON= yes
+# . endif
-. if defined(SERVER_ONLY) && defined(WITH_ICU)
-USE_AUTOTOOLS= autoconf:259
-CONFIGURE_ARGS+=--with-icu
-LIB_DEPENDS= icudata:${PORTSDIR}/devel/icu
-PATCH_SITES+= http://people.freebsd.org/~girgen/postgresql-icu/:icu
-PATCHFILES+= pg-814-icu-xx-2006-09-25.diff.gz:icu
-. endif
+# . if (defined(SERVER_ONLY) && defined(WITH_ICU)) || make(makesum)
+# USE_AUTOTOOLS= autoconf:259
+# CONFIGURE_ARGS+=--with-icu
+# LIB_DEPENDS= icudata:${PORTSDIR}/devel/icu
+# PATCH_SITES+= http://people.freebsd.org/~girgen/postgresql-icu/:icu
+# PATCHFILES+= pg-814-icu-xx-2006-09-25.diff.gz:icu
+# . endif
PATCH_DIST_STRIP=-p1
+. ifmake makesum
+DISTFILES+= postgresql-docs-${PORTVERSION}${EXTRACT_SUFX}
+. endif
+
. if defined(SERVER_ONLY) && defined(WITH_PAM)
CONFIGURE_ARGS+=--with-pam
. endif
@@ -173,12 +176,12 @@ CONFIGURE_ARGS+=--with-krb5
# 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.20:${PORTSDIR}/security/heimdal
+LIB_DEPENDS+= krb5.21:${PORTSDIR}/security/heimdal
CONFIGURE_ARGS+=--with-krb5
. endif
. endif
-. if defined(SERVER_ONLY) && defined(WITH_TESTS)
+. if (defined(SERVER_ONLY) && defined(WITH_TESTS)) || make(makesum)
DISTFILES+= postgresql-test-${PORTVERSION}${EXTRACT_SUFX}
EXTRA_PATCHES= ${FILESDIR}/regresspatch-src-test-regress-pgregress-sh
. endif
@@ -221,13 +224,13 @@ MAN7= abort.7 alter_aggregate.7 alter_conversion.7 alter_database.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_role.7 \
- drop_rule.7 \
+ drop_operator.7 drop_operator_class.7 drop_owned.7 \
+ drop_role.7 drop_rule.7 \
drop_schema.7 drop_sequence.7 drop_table.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 \
- reindex.7 reset.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 \
@@ -236,7 +239,7 @@ MAN7= abort.7 alter_aggregate.7 alter_conversion.7 alter_database.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
+ savepoint.7 values.7
.endif
.if defined(SERVER_ONLY)
@@ -260,11 +263,9 @@ do-build:
cd ${WRKSRC}/$${dir} && ${SETENV} ${MAKE_ENV} ${GMAKE}; \
done
-. if exists(${MASTERDIR}/pkg-message${PKGNAMESUFFIX})
-post-build:
- @ ${SED} "s|/usr/local|${PREFIX}|g" \
- < ${MASTERDIR}/pkg-message${PKGNAMESUFFIX} \
- > ${PKGMESSAGE}
+. if exists(${FILESDIR}/pkg-message${PKGNAMESUFFIX}.in)
+SUB_FILES+= pkg-message${PKGNAMESUFFIX}
+PKGMESSAGE= ${WRKSRC}/pkg-message${PKGNAMESUFFIX}
. endif
.endif
@@ -283,20 +284,13 @@ do-install:
. if defined(SERVER_ONLY)
@ ${MKDIR} ${PREFIX}/share/postgresql
. for i in profile cshrc
- @ ${SED} "s|%%PREFIX%%|${PREFIX}|g" \
- < ${FILESDIR}/dot.$i.in \
- > ${PREFIX}/share/postgresql/dot.$i.dist; \
- ${CP} ${PREFIX}/share/postgresql/dot.$i.dist ~pgsql/; \
+ ${INSTALL_DATA} ${WRKDIR}/dot.$i ${PREFIX}/share/postgresql/dot.$i.dist; \
+ ${INSTALL_DATA} -o pgsql -g pgsql ${WRKDIR}/dot.$i ~pgsql/dot.$i.dist ; \
if [ ! -f ~pgsql/.$i ]; then \
- ${CP} ${PREFIX}/share/postgresql/dot.$i.dist ~pgsql/.$i; \
+ ${CP} -p ~pgsql/dot.$i.dist ~pgsql/.$i; \
fi
. endfor
- @ ${SED} -e "s|%%PREFIX%%|${PREFIX}|g; s|%%RC_SUBR%%|${RC_SUBR}|g" \
- < ${FILESDIR}/pgsql.sh.tmpl \
- > ${RCSCRIPT} ;\
- ${CHMOD} 555 ${RCSCRIPT} ;\
- ${CHOWN} root:pgsql ${RCSCRIPT} ;\
- ${CHOWN} -R pgsql:pgsql ~pgsql/. ;\
+ @ ${CHOWN} -R pgsql:pgsql ~pgsql/. ;\
${MKDIR} ${PREFIX}/etc/periodic/daily ;\
${INSTALL_SCRIPT} ${FILESDIR}/502.pgsql \
${PREFIX}/etc/periodic/daily
diff --git a/databases/postgresql83-server/distinfo b/databases/postgresql83-server/distinfo
index 47f2c0c9e4d3..b74b1dd6b22d 100644
--- a/databases/postgresql83-server/distinfo
+++ b/databases/postgresql83-server/distinfo
@@ -1,15 +1,15 @@
-MD5 (postgresql/postgresql-base-8.1.4.tar.bz2) = 7ba24eaa31237eb8713782508de4dec7
-SHA256 (postgresql/postgresql-base-8.1.4.tar.bz2) = 3d5e6cf4aa1593730c61676ffc4e3acbed73c0e13fb246035e54e4cf83fa60e1
-SIZE (postgresql/postgresql-base-8.1.4.tar.bz2) = 8040435
-MD5 (postgresql/postgresql-docs-8.1.4.tar.bz2) = 5edc420b949a22d9960fc72609a24af3
-SHA256 (postgresql/postgresql-docs-8.1.4.tar.bz2) = 1578423df71962e22fe94b1123db680983d4e2f82e5bbb4913d96d9f6265de7f
-SIZE (postgresql/postgresql-docs-8.1.4.tar.bz2) = 2485052
-MD5 (postgresql/postgresql-opt-8.1.4.tar.bz2) = 6aad690bd918086cc3fbf673b74e65e6
-SHA256 (postgresql/postgresql-opt-8.1.4.tar.bz2) = 5a6d27e303ad9b073f91e51658b13cfeb153e3d886af5e5c1093ea315e15738c
-SIZE (postgresql/postgresql-opt-8.1.4.tar.bz2) = 144696
-MD5 (postgresql/postgresql-test-8.1.4.tar.bz2) = a4918ec95fd589f8b1eeb0e3d704045c
-SHA256 (postgresql/postgresql-test-8.1.4.tar.bz2) = b7449222f9f4c3340d6d065914d10df1d4a8b13d63c967c9e65190812325b8d9
-SIZE (postgresql/postgresql-test-8.1.4.tar.bz2) = 946868
+MD5 (postgresql/postgresql-base-8.2.0.tar.bz2) = c827602068e8d3ba20d575c87d102932
+SHA256 (postgresql/postgresql-base-8.2.0.tar.bz2) = 26544b843761b5acc4c3452ac3403e67cbe5d4a486583242bb6f4c77810b4284
+SIZE (postgresql/postgresql-base-8.2.0.tar.bz2) = 8483588
+MD5 (postgresql/postgresql-opt-8.2.0.tar.bz2) = d0bf0284ae3ae6ea56f6b08427f7ab9a
+SHA256 (postgresql/postgresql-opt-8.2.0.tar.bz2) = 06a016bf72a33061c4f297f15d32b8aadd742bfe54256573e59bb7916ec3df29
+SIZE (postgresql/postgresql-opt-8.2.0.tar.bz2) = 167666
+MD5 (postgresql/postgresql-docs-8.2.0.tar.bz2) = 4221311dc619659344b8e03ddbaa249b
+SHA256 (postgresql/postgresql-docs-8.2.0.tar.bz2) = 30096acf2d6c0bf5937571625de2d477586f0e5989ee8d56c58868bc738d4f2e
+SIZE (postgresql/postgresql-docs-8.2.0.tar.bz2) = 2744490
+MD5 (postgresql/postgresql-test-8.2.0.tar.bz2) = 0269ab5b70f9b677a97a856c3e46a5f5
+SHA256 (postgresql/postgresql-test-8.2.0.tar.bz2) = 695c82bb987fb0fcc09c059b7da914164fd1577d5ab8873d7371ec398e47dff5
+SIZE (postgresql/postgresql-test-8.2.0.tar.bz2) = 985281
MD5 (postgresql/pg-814-icu-xx-2006-09-25.diff.gz) = 2eb31538f3ee367767aeacd95b11d623
SHA256 (postgresql/pg-814-icu-xx-2006-09-25.diff.gz) = 8dea05bdbc2b78426b159f628b693f69da17b930fe4882e166d5e8a3e698b7d9
SIZE (postgresql/pg-814-icu-xx-2006-09-25.diff.gz) = 3987
diff --git a/databases/postgresql83-server/files/patch-src:backend:utils:misc:postgresql.conf.sample b/databases/postgresql83-server/files/patch-src:backend:utils:misc:postgresql.conf.sample
index da57f46e3552..7c2831c41be0 100644
--- a/databases/postgresql83-server/files/patch-src:backend:utils:misc:postgresql.conf.sample
+++ b/databases/postgresql83-server/files/patch-src:backend:utils:misc:postgresql.conf.sample
@@ -1,5 +1,5 @@
---- src/backend/utils/misc/postgresql.conf.sample~ Tue Nov 8 00:45:49 2005
-+++ src/backend/utils/misc/postgresql.conf.sample Tue Nov 8 00:47:16 2005
+--- src/backend/utils/misc/postgresql.conf.sample.orig Sun May 21 22:11:02 2006
++++ src/backend/utils/misc/postgresql.conf.sample Tue Nov 7 17:23:50 2006
@@ -206,6 +206,7 @@
# - Where to Log -
@@ -16,3 +16,12 @@
#silent_mode = off # DO NOT USE without syslog or
# redirect_stderr
+@@ -339,6 +341,8 @@
+ #---------------------------------------------------------------------------
+ # AUTOVACUUM PARAMETERS
+ #---------------------------------------------------------------------------
++
++autovacuum = on
+
+ #autovacuum = off # enable autovacuum subprocess?
+ #autovacuum_naptime = 60 # time between autovacuum runs, in secs
diff --git a/databases/postgresql83-server/pkg-message-client b/databases/postgresql83-server/files/pkg-message-client.in
index 722d50cb4244..722d50cb4244 100644
--- a/databases/postgresql83-server/pkg-message-client
+++ b/databases/postgresql83-server/files/pkg-message-client.in
diff --git a/databases/postgresql83-server/pkg-message-contrib b/databases/postgresql83-server/files/pkg-message-contrib.in
index 8120f2d8d89c..2b29ffd33041 100644
--- a/databases/postgresql83-server/pkg-message-contrib
+++ b/databases/postgresql83-server/files/pkg-message-contrib.in
@@ -1,3 +1,3 @@
The PostgreSQL contrib utilities have been installed. Please see
-/usr/local/share/doc/postgresql/contrib/README
+%%PREFIX%%/share/doc/postgresql/contrib/README
for more information.
diff --git a/databases/postgresql83-server/pkg-message-plperl b/databases/postgresql83-server/files/pkg-message-plperl.in
index 5d0c83920563..5d0c83920563 100644
--- a/databases/postgresql83-server/pkg-message-plperl
+++ b/databases/postgresql83-server/files/pkg-message-plperl.in
diff --git a/databases/postgresql83-server/pkg-message-plpython b/databases/postgresql83-server/files/pkg-message-plpython.in
index c413582b6295..c413582b6295 100644
--- a/databases/postgresql83-server/pkg-message-plpython
+++ b/databases/postgresql83-server/files/pkg-message-plpython.in
diff --git a/databases/postgresql83-server/pkg-message-pltcl b/databases/postgresql83-server/files/pkg-message-pltcl.in
index 0902b858de0b..0902b858de0b 100644
--- a/databases/postgresql83-server/pkg-message-pltcl
+++ b/databases/postgresql83-server/files/pkg-message-pltcl.in
diff --git a/databases/postgresql83-server/files/pkg-message-server.in b/databases/postgresql83-server/files/pkg-message-server.in
new file mode 100644
index 000000000000..cd6c42ed2090
--- /dev/null
+++ b/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.conf/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
+
diff --git a/databases/postgresql83-server/files/pgsql.sh.tmpl b/databases/postgresql83-server/files/postgresql.in
index 3456ed3d7282..a44c713d6b25 100644
--- a/databases/postgresql83-server/files/pgsql.sh.tmpl
+++ b/databases/postgresql83-server/files/postgresql.in
@@ -12,6 +12,10 @@
# # 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:
#
@@ -32,6 +36,7 @@ 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`
diff --git a/databases/postgresql83-server/pkg-message-server b/databases/postgresql83-server/pkg-message-server
deleted file mode 100644
index ad1e6d1e82b9..000000000000
--- a/databases/postgresql83-server/pkg-message-server
+++ /dev/null
@@ -1,49 +0,0 @@
-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.
-
-You should vacuum and backup your database regularly. There is a
-periodic script, ${LOCALBASE}/etc/periodic/daily/502.pgsql, that you
-may find useful. Per default, it perfoms vacuum on all databases
-nightly. See the script for instructions.
-
-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 /usr/local/share/postgresql/odbc.sql
-to get the functions required for ODBC compliance.
-
-======================================================================
-
-To initialize the database, run
-
- /usr/local/etc/rc.d/010.pgsql.sh initdb
-
-You can then start PostgreSQL by running:
-
- /usr/local/etc/rc.d/010.pgsql.sh start
-
-For postmaster settings, see ~pgsql/data/postgresql.conf
-
-NB. FreeBSD's PostgreSQL port now by default logs to syslog
- See ~pgsql/data/postgresql.conf for more info
-
-======================================================================
-
-To run PostgreSQL at startup, add
-'postgresql_enable="YES"' to /etc/rc.conf
-
diff --git a/databases/postgresql83-server/pkg-plist-client b/databases/postgresql83-server/pkg-plist-client
index c39bd07b8b0e..a88eb5761102 100644
--- a/databases/postgresql83-server/pkg-plist-client
+++ b/databases/postgresql83-server/pkg-plist-client
@@ -18,9 +18,11 @@ 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
@@ -28,15 +30,13 @@ 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/iqual.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/rmgr.h
-include/postgresql/server/access/rtree.h
-include/postgresql/server/access/rtscan.h
include/postgresql/server/access/sdir.h
include/postgresql/server/access/skey.h
include/postgresql/server/access/slru.h
@@ -91,10 +91,12 @@ 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_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
@@ -150,6 +152,7 @@ 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
@@ -168,6 +171,7 @@ 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
@@ -232,11 +236,11 @@ 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/beos.h
include/postgresql/server/port/bsdi.h
include/postgresql/server/port/cygwin.h
include/postgresql/server/port/darwin.h
@@ -249,7 +253,6 @@ 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/qnx4.h
include/postgresql/server/port/sco.h
include/postgresql/server/port/solaris.h
include/postgresql/server/port/sunos4.h
@@ -312,7 +315,6 @@ 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/strdup.h
include/postgresql/server/tcop/dest.h
include/postgresql/server/tcop/fastpath.h
include/postgresql/server/tcop/pquery.h
@@ -366,6 +368,7 @@ 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/varbit.h
@dirrm include/postgresql/server/utils
@dirrm include/postgresql/server/tcop
@@ -430,7 +433,7 @@ lib/libecpg_compat.so
lib/libecpg_compat.so.2
lib/libpq.a
lib/libpq.so
-lib/libpq.so.4
+lib/libpq.so.5
lib/libpgtypes.a
lib/libpgtypes.so
lib/libpgtypes.so.2
@@ -511,6 +514,7 @@ share/postgresql/psqlrc.sample
%%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_controldata.mo
%%GETTEXT%%share/locale/nb/LC_MESSAGES/pg_dump.mo
%%GETTEXT%%share/locale/nb/LC_MESSAGES/pg_resetxlog.mo
diff --git a/databases/postgresql83-server/pkg-plist-contrib b/databases/postgresql83-server/pkg-plist-contrib
index 6152ee5852dc..6aac8614c6bd 100644
--- a/databases/postgresql83-server/pkg-plist-contrib
+++ b/databases/postgresql83-server/pkg-plist-contrib
@@ -1,76 +1,74 @@
-bin/DBMirror.pl
-bin/clean_pending.pl
-bin/dbf2pg
-bin/fti.pl
bin/oid2name
bin/pgbench
bin/vacuumlo
lib/postgresql/_int.so
+lib/postgresql/adminpack.so
lib/postgresql/autoinc.so
lib/postgresql/btree_gist.so
-lib/postgresql/pg_buffercache.so
lib/postgresql/chkpass.so
lib/postgresql/cube.so
lib/postgresql/dblink.so
lib/postgresql/earthdistance.so
-lib/postgresql/fti.so
lib/postgresql/fuzzystrmatch.so
+lib/postgresql/hstore.so
lib/postgresql/insert_username.so
lib/postgresql/int_aggregate.so
-lib/postgresql/isbn_issn.so
+lib/postgresql/isn.so
lib/postgresql/lo.so
lib/postgresql/ltree.so
lib/postgresql/moddatetime.so
-lib/postgresql/pending.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/timetravel.so
lib/postgresql/tsearch2.so
-lib/postgresql/user_locks.so
%%DOCSDIR%%/README-contrib
%%DOCSDIR%%/contrib/README
-%%DOCSDIR%%/contrib/README.apachelog
+%%DOCSDIR%%/contrib/README.adminpack
%%DOCSDIR%%/contrib/README.btree_gist
%%DOCSDIR%%/contrib/README.chkpass
%%DOCSDIR%%/contrib/README.cube
-%%DOCSDIR%%/contrib/README.dbf2pg
%%DOCSDIR%%/contrib/README.dblink
-%%DOCSDIR%%/contrib/README.dbmirror
%%DOCSDIR%%/contrib/README.earthdistance
-%%DOCSDIR%%/contrib/README.fti
%%DOCSDIR%%/contrib/README.fuzzystrmatch
+%%DOCSDIR%%/contrib/README.hstore
%%DOCSDIR%%/contrib/README.int_aggregate
%%DOCSDIR%%/contrib/README.intarray
-%%DOCSDIR%%/contrib/README.isbn_issn
+%%DOCSDIR%%/contrib/README.isn
%%DOCSDIR%%/contrib/README.lo
%%DOCSDIR%%/contrib/README.ltree
%%DOCSDIR%%/contrib/README.oid2name
%%DOCSDIR%%/contrib/README.pg_buffercache
+%%DOCSDIR%%/contrib/README.pg_freespacemap
%%DOCSDIR%%/contrib/README.pg_trgm
%%DOCSDIR%%/contrib/README.pgbench
%%DOCSDIR%%/contrib/README.pgbench_jis
%%DOCSDIR%%/contrib/README.pgcrypto
+%%DOCSDIR%%/contrib/README.pgrowlocks
+%%DOCSDIR%%/contrib/README.pgrowlocks.euc_jp
%%DOCSDIR%%/contrib/README.pgstattuple
%%DOCSDIR%%/contrib/README.pgstattuple.euc_jp
%%DOCSDIR%%/contrib/README.seg
%%DOCSDIR%%/contrib/README.soundex
%%DOCSDIR%%/contrib/README.spi
+%%DOCSDIR%%/contrib/README.sslinfo
%%DOCSDIR%%/contrib/README.tablefunc
%%DOCSDIR%%/contrib/README.tsearch2
-%%DOCSDIR%%/contrib/README.user_locks
%%DOCSDIR%%/contrib/README.vacuumlo
%%DOCSDIR%%/contrib/autoinc.example
%%DOCSDIR%%/contrib/insert_username.example
%%DOCSDIR%%/contrib/moddatetime.example
%%DOCSDIR%%/contrib/refint.example
%%DOCSDIR%%/contrib/timetravel.example
-share/postgresql/contrib/AddTrigger.sql
-share/postgresql/contrib/MirrorSetup.sql
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
@@ -78,29 +76,52 @@ share/postgresql/contrib/cube.sql
share/postgresql/contrib/dblink.sql
share/postgresql/contrib/earthdistance.sql
share/postgresql/contrib/english.stop
-share/postgresql/contrib/fti.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/isbn_issn.sql
+share/postgresql/contrib/isn.sql
share/postgresql/contrib/lo.sql
-share/postgresql/contrib/lo_drop.sql
-share/postgresql/contrib/lo_test.sql
share/postgresql/contrib/ltree.sql
share/postgresql/contrib/moddatetime.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/russian.stop
+share/postgresql/contrib/russian.stop.utf8
share/postgresql/contrib/seg.sql
-share/postgresql/contrib/slaveDatabase.conf
+share/postgresql/contrib/sslinfo.sql
share/postgresql/contrib/tablefunc.sql
+share/postgresql/contrib/thesaurus
share/postgresql/contrib/timetravel.sql
share/postgresql/contrib/tsearch2.sql
-share/postgresql/contrib/untsearch2.sql
-share/postgresql/contrib/user_locks.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_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_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_tsearch2.sql
@dirrmtry share/postgresql/contrib >&2
@dirrmtry share/postgresql >&2
@dirrmtry %%DOCSDIR%%/contrib >&2
diff --git a/databases/postgresql83-server/pkg-plist-server b/databases/postgresql83-server/pkg-plist-server
index 9e2451b51f86..bea3bfc7c0ec 100644
--- a/databases/postgresql83-server/pkg-plist-server
+++ b/databases/postgresql83-server/pkg-plist-server
@@ -1,7 +1,6 @@
bin/postmaster
bin/postgres
etc/periodic/daily/502.pgsql
-etc/rc.d/010.pgsql.sh
lib/libpgport.a
lib/postgresql/ascii_and_mic.so
lib/postgresql/cyrillic_and_mic.so
@@ -25,11 +24,7 @@ lib/postgresql/utf8_and_iso8859_1.so
lib/postgresql/utf8_and_johab.so
lib/postgresql/utf8_and_sjis.so
lib/postgresql/utf8_and_uhc.so
-lib/postgresql/utf8_and_win1250.so
-lib/postgresql/utf8_and_win1252.so
-lib/postgresql/utf8_and_win1256.so
-lib/postgresql/utf8_and_win1258.so
-lib/postgresql/utf8_and_win874.so
+lib/postgresql/utf8_and_win.so
lib/postgresql/plpgsql.so
%%DOCSDIR%%/README-server
@dirrmtry %%DOCSDIR%%
@@ -76,498 +71,342 @@ share/postgresql/system_views.sql
%%GETTEXT%%@dirrmtry share/locale/zh_CN
%%GETTEXT%%@dirrmtry share/locale/zh_TW/LC_MESSAGES
%%GETTEXT%%@dirrmtry share/locale/zh_TW
-share/postgresql/timezone/Africa/Algiers
-share/postgresql/timezone/Africa/Luanda
-share/postgresql/timezone/Africa/Porto-Novo
-share/postgresql/timezone/Africa/Gaborone
-share/postgresql/timezone/Africa/Ouagadougou
-share/postgresql/timezone/Africa/Bujumbura
-share/postgresql/timezone/Africa/Douala
-share/postgresql/timezone/Africa/Bangui
-share/postgresql/timezone/Africa/Ndjamena
-share/postgresql/timezone/Africa/Kinshasa
-share/postgresql/timezone/Africa/Lubumbashi
-share/postgresql/timezone/Africa/Brazzaville
+share/postgresql/postgres.shdescription
share/postgresql/timezone/Africa/Abidjan
-share/postgresql/timezone/Africa/Djibouti
-share/postgresql/timezone/Africa/Cairo
-share/postgresql/timezone/Africa/Malabo
-share/postgresql/timezone/Africa/Asmera
+share/postgresql/timezone/Africa/Accra
share/postgresql/timezone/Africa/Addis_Ababa
-share/postgresql/timezone/Africa/Libreville
+share/postgresql/timezone/Africa/Algiers
+share/postgresql/timezone/Africa/Asmera
+share/postgresql/timezone/Africa/Bamako
+share/postgresql/timezone/Africa/Bangui
share/postgresql/timezone/Africa/Banjul
-share/postgresql/timezone/Africa/Accra
-share/postgresql/timezone/Africa/Conakry
share/postgresql/timezone/Africa/Bissau
-share/postgresql/timezone/Africa/Nairobi
-share/postgresql/timezone/Africa/Maseru
-share/postgresql/timezone/Africa/Monrovia
-share/postgresql/timezone/Africa/Tripoli
share/postgresql/timezone/Africa/Blantyre
-share/postgresql/timezone/Africa/Bamako
-share/postgresql/timezone/Africa/Timbuktu
-share/postgresql/timezone/Africa/Nouakchott
+share/postgresql/timezone/Africa/Brazzaville
+share/postgresql/timezone/Africa/Bujumbura
+share/postgresql/timezone/Africa/Cairo
share/postgresql/timezone/Africa/Casablanca
-share/postgresql/timezone/Africa/El_Aaiun
-share/postgresql/timezone/Africa/Maputo
-share/postgresql/timezone/Africa/Windhoek
-share/postgresql/timezone/Africa/Niamey
-share/postgresql/timezone/Africa/Lagos
-share/postgresql/timezone/Africa/Kigali
-share/postgresql/timezone/Africa/Sao_Tome
+share/postgresql/timezone/Africa/Ceuta
+share/postgresql/timezone/Africa/Conakry
share/postgresql/timezone/Africa/Dakar
+share/postgresql/timezone/Africa/Dar_es_Salaam
+share/postgresql/timezone/Africa/Djibouti
+share/postgresql/timezone/Africa/Douala
+share/postgresql/timezone/Africa/El_Aaiun
share/postgresql/timezone/Africa/Freetown
-share/postgresql/timezone/Africa/Mogadishu
+share/postgresql/timezone/Africa/Gaborone
+share/postgresql/timezone/Africa/Harare
share/postgresql/timezone/Africa/Johannesburg
+share/postgresql/timezone/Africa/Kampala
share/postgresql/timezone/Africa/Khartoum
-share/postgresql/timezone/Africa/Mbabane
-share/postgresql/timezone/Africa/Dar_es_Salaam
+share/postgresql/timezone/Africa/Kigali
+share/postgresql/timezone/Africa/Kinshasa
+share/postgresql/timezone/Africa/Lagos
+share/postgresql/timezone/Africa/Libreville
share/postgresql/timezone/Africa/Lome
-share/postgresql/timezone/Africa/Tunis
-share/postgresql/timezone/Africa/Kampala
+share/postgresql/timezone/Africa/Luanda
+share/postgresql/timezone/Africa/Lubumbashi
share/postgresql/timezone/Africa/Lusaka
-share/postgresql/timezone/Africa/Harare
-share/postgresql/timezone/Africa/Ceuta
-share/postgresql/timezone/Atlantic/Cape_Verde
-share/postgresql/timezone/Atlantic/St_Helena
-share/postgresql/timezone/Atlantic/Faeroe
-share/postgresql/timezone/Atlantic/Reykjavik
-share/postgresql/timezone/Atlantic/Azores
-share/postgresql/timezone/Atlantic/Madeira
-share/postgresql/timezone/Atlantic/Canary
-share/postgresql/timezone/Atlantic/Bermuda
-share/postgresql/timezone/Atlantic/Stanley
-share/postgresql/timezone/Atlantic/South_Georgia
-share/postgresql/timezone/Atlantic/Jan_Mayen
-share/postgresql/timezone/Indian/Comoro
-share/postgresql/timezone/Indian/Antananarivo
-share/postgresql/timezone/Indian/Mauritius
-share/postgresql/timezone/Indian/Mayotte
-share/postgresql/timezone/Indian/Reunion
-share/postgresql/timezone/Indian/Mahe
-share/postgresql/timezone/Indian/Kerguelen
-share/postgresql/timezone/Indian/Chagos
-share/postgresql/timezone/Indian/Maldives
-share/postgresql/timezone/Indian/Christmas
-share/postgresql/timezone/Indian/Cocos
+share/postgresql/timezone/Africa/Malabo
+share/postgresql/timezone/Africa/Maputo
+share/postgresql/timezone/Africa/Maseru
+share/postgresql/timezone/Africa/Mbabane
+share/postgresql/timezone/Africa/Mogadishu
+share/postgresql/timezone/Africa/Monrovia
+share/postgresql/timezone/Africa/Nairobi
+share/postgresql/timezone/Africa/Ndjamena
+share/postgresql/timezone/Africa/Niamey
+share/postgresql/timezone/Africa/Nouakchott
+share/postgresql/timezone/Africa/Ouagadougou
+share/postgresql/timezone/Africa/Porto-Novo
+share/postgresql/timezone/Africa/Sao_Tome
+share/postgresql/timezone/Africa/Timbuktu
+share/postgresql/timezone/Africa/Tripoli
+share/postgresql/timezone/Africa/Tunis
+share/postgresql/timezone/Africa/Windhoek
+share/postgresql/timezone/America/Adak
+share/postgresql/timezone/America/Anchorage
+share/postgresql/timezone/America/Anguilla
+share/postgresql/timezone/America/Antigua
+share/postgresql/timezone/America/Araguaina
+share/postgresql/timezone/America/Argentina/Buenos_Aires
+share/postgresql/timezone/America/Argentina/Catamarca
+share/postgresql/timezone/America/Argentina/ComodRivadavia
+share/postgresql/timezone/America/Argentina/Cordoba
+share/postgresql/timezone/America/Argentina/Jujuy
+share/postgresql/timezone/America/Argentina/La_Rioja
+share/postgresql/timezone/America/Argentina/Mendoza
+share/postgresql/timezone/America/Argentina/Rio_Gallegos
+share/postgresql/timezone/America/Argentina/San_Juan
+share/postgresql/timezone/America/Argentina/Tucuman
+share/postgresql/timezone/America/Argentina/Ushuaia
+share/postgresql/timezone/America/Aruba
+share/postgresql/timezone/America/Asuncion
+share/postgresql/timezone/America/Atikokan
+share/postgresql/timezone/America/Atka
+share/postgresql/timezone/America/Bahia
+share/postgresql/timezone/America/Barbados
+share/postgresql/timezone/America/Belem
+share/postgresql/timezone/America/Belize
+share/postgresql/timezone/America/Blanc-Sablon
+share/postgresql/timezone/America/Boa_Vista
+share/postgresql/timezone/America/Bogota
+share/postgresql/timezone/America/Boise
+share/postgresql/timezone/America/Buenos_Aires
+share/postgresql/timezone/America/Cambridge_Bay
+share/postgresql/timezone/America/Campo_Grande
+share/postgresql/timezone/America/Cancun
+share/postgresql/timezone/America/Caracas
+share/postgresql/timezone/America/Catamarca
+share/postgresql/timezone/America/Cayenne
+share/postgresql/timezone/America/Cayman
+share/postgresql/timezone/America/Chicago
+share/postgresql/timezone/America/Chihuahua
+share/postgresql/timezone/America/Coral_Harbour
+share/postgresql/timezone/America/Cordoba
+share/postgresql/timezone/America/Costa_Rica
+share/postgresql/timezone/America/Cuiaba
+share/postgresql/timezone/America/Curacao
+share/postgresql/timezone/America/Danmarkshavn
+share/postgresql/timezone/America/Dawson
+share/postgresql/timezone/America/Dawson_Creek
+share/postgresql/timezone/America/Denver
+share/postgresql/timezone/America/Detroit
+share/postgresql/timezone/America/Dominica
+share/postgresql/timezone/America/Edmonton
+share/postgresql/timezone/America/Eirunepe
+share/postgresql/timezone/America/El_Salvador
+share/postgresql/timezone/America/Ensenada
+share/postgresql/timezone/America/Fort_Wayne
+share/postgresql/timezone/America/Fortaleza
+share/postgresql/timezone/America/Glace_Bay
+share/postgresql/timezone/America/Godthab
+share/postgresql/timezone/America/Goose_Bay
+share/postgresql/timezone/America/Grand_Turk
+share/postgresql/timezone/America/Grenada
+share/postgresql/timezone/America/Guadeloupe
+share/postgresql/timezone/America/Guatemala
+share/postgresql/timezone/America/Guayaquil
+share/postgresql/timezone/America/Guyana
+share/postgresql/timezone/America/Halifax
+share/postgresql/timezone/America/Havana
+share/postgresql/timezone/America/Hermosillo
+share/postgresql/timezone/America/Indiana/Indianapolis
+share/postgresql/timezone/America/Indiana/Knox
+share/postgresql/timezone/America/Indiana/Marengo
+share/postgresql/timezone/America/Indiana/Petersburg
+share/postgresql/timezone/America/Indiana/Vevay
+share/postgresql/timezone/America/Indiana/Vincennes
+share/postgresql/timezone/America/Indianapolis
+share/postgresql/timezone/America/Inuvik
+share/postgresql/timezone/America/Iqaluit
+share/postgresql/timezone/America/Jamaica
+share/postgresql/timezone/America/Jujuy
+share/postgresql/timezone/America/Juneau
+share/postgresql/timezone/America/Kentucky/Louisville
+share/postgresql/timezone/America/Kentucky/Monticello
+share/postgresql/timezone/America/Knox_IN
+share/postgresql/timezone/America/La_Paz
+share/postgresql/timezone/America/Lima
+share/postgresql/timezone/America/Los_Angeles
+share/postgresql/timezone/America/Louisville
+share/postgresql/timezone/America/Maceio
+share/postgresql/timezone/America/Managua
+share/postgresql/timezone/America/Manaus
+share/postgresql/timezone/America/Martinique
+share/postgresql/timezone/America/Mazatlan
+share/postgresql/timezone/America/Mendoza
+share/postgresql/timezone/America/Menominee
+share/postgresql/timezone/America/Merida
+share/postgresql/timezone/America/Mexico_City
+share/postgresql/timezone/America/Miquelon
+share/postgresql/timezone/America/Moncton
+share/postgresql/timezone/America/Monterrey
+share/postgresql/timezone/America/Montevideo
+share/postgresql/timezone/America/Montreal
+share/postgresql/timezone/America/Montserrat
+share/postgresql/timezone/America/Nassau
+share/postgresql/timezone/America/New_York
+share/postgresql/timezone/America/Nipigon
+share/postgresql/timezone/America/Nome
+share/postgresql/timezone/America/Noronha
+share/postgresql/timezone/America/North_Dakota/Center
+share/postgresql/timezone/America/North_Dakota/New_Salem
+share/postgresql/timezone/America/Panama
+share/postgresql/timezone/America/Pangnirtung
+share/postgresql/timezone/America/Paramaribo
+share/postgresql/timezone/America/Phoenix
+share/postgresql/timezone/America/Port-au-Prince
+share/postgresql/timezone/America/Port_of_Spain
+share/postgresql/timezone/America/Porto_Acre
+share/postgresql/timezone/America/Porto_Velho
+share/postgresql/timezone/America/Puerto_Rico
+share/postgresql/timezone/America/Rainy_River
+share/postgresql/timezone/America/Rankin_Inlet
+share/postgresql/timezone/America/Recife
+share/postgresql/timezone/America/Regina
+share/postgresql/timezone/America/Rio_Branco
+share/postgresql/timezone/America/Rosario
+share/postgresql/timezone/America/Santiago
+share/postgresql/timezone/America/Santo_Domingo
+share/postgresql/timezone/America/Sao_Paulo
+share/postgresql/timezone/America/Scoresbysund
+share/postgresql/timezone/America/Shiprock
+share/postgresql/timezone/America/St_Johns
+share/postgresql/timezone/America/St_Kitts
+share/postgresql/timezone/America/St_Lucia
+share/postgresql/timezone/America/St_Thomas
+share/postgresql/timezone/America/St_Vincent
+share/postgresql/timezone/America/Swift_Current
+share/postgresql/timezone/America/Tegucigalpa
+share/postgresql/timezone/America/Thule
+share/postgresql/timezone/America/Thunder_Bay
+share/postgresql/timezone/America/Tijuana
+share/postgresql/timezone/America/Toronto
+share/postgresql/timezone/America/Tortola
+share/postgresql/timezone/America/Vancouver
+share/postgresql/timezone/America/Virgin
+share/postgresql/timezone/America/Whitehorse
+share/postgresql/timezone/America/Winnipeg
+share/postgresql/timezone/America/Yakutat
+share/postgresql/timezone/America/Yellowknife
share/postgresql/timezone/Antarctica/Casey
share/postgresql/timezone/Antarctica/Davis
-share/postgresql/timezone/Antarctica/Mawson
share/postgresql/timezone/Antarctica/DumontDUrville
-share/postgresql/timezone/Antarctica/Syowa
-share/postgresql/timezone/Antarctica/Vostok
-share/postgresql/timezone/Antarctica/Rothera
-share/postgresql/timezone/Antarctica/Palmer
+share/postgresql/timezone/Antarctica/Mawson
share/postgresql/timezone/Antarctica/McMurdo
+share/postgresql/timezone/Antarctica/Palmer
+share/postgresql/timezone/Antarctica/Rothera
share/postgresql/timezone/Antarctica/South_Pole
-share/postgresql/timezone/Asia/Kabul
-share/postgresql/timezone/Asia/Yerevan
-share/postgresql/timezone/Asia/Baku
+share/postgresql/timezone/Antarctica/Syowa
+share/postgresql/timezone/Antarctica/Vostok
+share/postgresql/timezone/Arctic/Longyearbyen
+share/postgresql/timezone/Asia/Aden
+share/postgresql/timezone/Asia/Almaty
+share/postgresql/timezone/Asia/Amman
+share/postgresql/timezone/Asia/Anadyr
+share/postgresql/timezone/Asia/Aqtau
+share/postgresql/timezone/Asia/Aqtobe
+share/postgresql/timezone/Asia/Ashgabat
+share/postgresql/timezone/Asia/Ashkhabad
+share/postgresql/timezone/Asia/Baghdad
share/postgresql/timezone/Asia/Bahrain
-share/postgresql/timezone/Asia/Dhaka
-share/postgresql/timezone/Asia/Thimphu
+share/postgresql/timezone/Asia/Baku
+share/postgresql/timezone/Asia/Bangkok
+share/postgresql/timezone/Asia/Beirut
+share/postgresql/timezone/Asia/Bishkek
share/postgresql/timezone/Asia/Brunei
-share/postgresql/timezone/Asia/Rangoon
-share/postgresql/timezone/Asia/Phnom_Penh
-share/postgresql/timezone/Asia/Harbin
-share/postgresql/timezone/Asia/Shanghai
+share/postgresql/timezone/Asia/Calcutta
+share/postgresql/timezone/Asia/Choibalsan
share/postgresql/timezone/Asia/Chongqing
-share/postgresql/timezone/Asia/Urumqi
-share/postgresql/timezone/Asia/Kashgar
-share/postgresql/timezone/Asia/Hong_Kong
-share/postgresql/timezone/Asia/Taipei
-share/postgresql/timezone/Asia/Macau
-share/postgresql/timezone/Asia/Nicosia
-share/postgresql/timezone/Asia/Tbilisi
+share/postgresql/timezone/Asia/Chungking
+share/postgresql/timezone/Asia/Colombo
+share/postgresql/timezone/Asia/Dacca
+share/postgresql/timezone/Asia/Damascus
+share/postgresql/timezone/Asia/Dhaka
share/postgresql/timezone/Asia/Dili
-share/postgresql/timezone/Asia/Calcutta
+share/postgresql/timezone/Asia/Dubai
+share/postgresql/timezone/Asia/Dushanbe
+share/postgresql/timezone/Asia/Gaza
+share/postgresql/timezone/Asia/Harbin
+share/postgresql/timezone/Asia/Hong_Kong
+share/postgresql/timezone/Asia/Hovd
+share/postgresql/timezone/Asia/Irkutsk
+share/postgresql/timezone/Asia/Istanbul
share/postgresql/timezone/Asia/Jakarta
-share/postgresql/timezone/Asia/Pontianak
-share/postgresql/timezone/Asia/Makassar
share/postgresql/timezone/Asia/Jayapura
-share/postgresql/timezone/Asia/Tehran
-share/postgresql/timezone/Asia/Baghdad
share/postgresql/timezone/Asia/Jerusalem
-share/postgresql/timezone/Asia/Tokyo
-share/postgresql/timezone/Asia/Amman
-share/postgresql/timezone/Asia/Almaty
-share/postgresql/timezone/Asia/Qyzylorda
-share/postgresql/timezone/Asia/Aqtobe
-share/postgresql/timezone/Asia/Aqtau
-share/postgresql/timezone/Asia/Oral
-share/postgresql/timezone/Asia/Bishkek
-share/postgresql/timezone/Asia/Seoul
-share/postgresql/timezone/Asia/Pyongyang
-share/postgresql/timezone/Asia/Kuwait
-share/postgresql/timezone/Asia/Vientiane
-share/postgresql/timezone/Asia/Beirut
+share/postgresql/timezone/Asia/Kabul
+share/postgresql/timezone/Asia/Kamchatka
+share/postgresql/timezone/Asia/Karachi
+share/postgresql/timezone/Asia/Kashgar
+share/postgresql/timezone/Asia/Katmandu
+share/postgresql/timezone/Asia/Krasnoyarsk
share/postgresql/timezone/Asia/Kuala_Lumpur
share/postgresql/timezone/Asia/Kuching
-share/postgresql/timezone/Asia/Hovd
-share/postgresql/timezone/Asia/Ulaanbaatar
-share/postgresql/timezone/Asia/Choibalsan
-share/postgresql/timezone/Asia/Katmandu
-share/postgresql/timezone/Asia/Muscat
-share/postgresql/timezone/Asia/Karachi
-share/postgresql/timezone/Asia/Gaza
+share/postgresql/timezone/Asia/Kuwait
+share/postgresql/timezone/Asia/Macao
+share/postgresql/timezone/Asia/Macau
+share/postgresql/timezone/Asia/Magadan
+share/postgresql/timezone/Asia/Makassar
share/postgresql/timezone/Asia/Manila
+share/postgresql/timezone/Asia/Muscat
+share/postgresql/timezone/Asia/Nicosia
+share/postgresql/timezone/Asia/Novosibirsk
+share/postgresql/timezone/Asia/Omsk
+share/postgresql/timezone/Asia/Oral
+share/postgresql/timezone/Asia/Phnom_Penh
+share/postgresql/timezone/Asia/Pontianak
+share/postgresql/timezone/Asia/Pyongyang
share/postgresql/timezone/Asia/Qatar
+share/postgresql/timezone/Asia/Qyzylorda
+share/postgresql/timezone/Asia/Rangoon
share/postgresql/timezone/Asia/Riyadh
-share/postgresql/timezone/Asia/Singapore
-share/postgresql/timezone/Asia/Colombo
-share/postgresql/timezone/Asia/Damascus
-share/postgresql/timezone/Asia/Dushanbe
-share/postgresql/timezone/Asia/Bangkok
-share/postgresql/timezone/Asia/Ashgabat
-share/postgresql/timezone/Asia/Dubai
-share/postgresql/timezone/Asia/Samarkand
-share/postgresql/timezone/Asia/Tashkent
-share/postgresql/timezone/Asia/Saigon
-share/postgresql/timezone/Asia/Aden
-share/postgresql/timezone/Asia/Yekaterinburg
-share/postgresql/timezone/Asia/Omsk
-share/postgresql/timezone/Asia/Novosibirsk
-share/postgresql/timezone/Asia/Krasnoyarsk
-share/postgresql/timezone/Asia/Irkutsk
-share/postgresql/timezone/Asia/Yakutsk
-share/postgresql/timezone/Asia/Vladivostok
-share/postgresql/timezone/Asia/Sakhalin
-share/postgresql/timezone/Asia/Magadan
-share/postgresql/timezone/Asia/Kamchatka
-share/postgresql/timezone/Asia/Anadyr
share/postgresql/timezone/Asia/Riyadh87
share/postgresql/timezone/Asia/Riyadh88
share/postgresql/timezone/Asia/Riyadh89
-share/postgresql/timezone/Asia/Istanbul
-share/postgresql/timezone/Asia/Ashkhabad
-share/postgresql/timezone/Asia/Chungking
-share/postgresql/timezone/Asia/Dacca
-share/postgresql/timezone/Asia/Macao
-share/postgresql/timezone/Asia/Ujung_Pandang
+share/postgresql/timezone/Asia/Saigon
+share/postgresql/timezone/Asia/Sakhalin
+share/postgresql/timezone/Asia/Samarkand
+share/postgresql/timezone/Asia/Seoul
+share/postgresql/timezone/Asia/Shanghai
+share/postgresql/timezone/Asia/Singapore
+share/postgresql/timezone/Asia/Taipei
+share/postgresql/timezone/Asia/Tashkent
+share/postgresql/timezone/Asia/Tbilisi
+share/postgresql/timezone/Asia/Tehran
share/postgresql/timezone/Asia/Tel_Aviv
share/postgresql/timezone/Asia/Thimbu
+share/postgresql/timezone/Asia/Thimphu
+share/postgresql/timezone/Asia/Tokyo
+share/postgresql/timezone/Asia/Ujung_Pandang
+share/postgresql/timezone/Asia/Ulaanbaatar
share/postgresql/timezone/Asia/Ulan_Bator
-share/postgresql/timezone/Australia/Currie
-share/postgresql/timezone/Australia/Darwin
-share/postgresql/timezone/Australia/Perth
-share/postgresql/timezone/Australia/Brisbane
-share/postgresql/timezone/Australia/Lindeman
+share/postgresql/timezone/Asia/Urumqi
+share/postgresql/timezone/Asia/Vientiane
+share/postgresql/timezone/Asia/Vladivostok
+share/postgresql/timezone/Asia/Yakutsk
+share/postgresql/timezone/Asia/Yekaterinburg
+share/postgresql/timezone/Asia/Yerevan
+share/postgresql/timezone/Atlantic/Azores
+share/postgresql/timezone/Atlantic/Bermuda
+share/postgresql/timezone/Atlantic/Canary
+share/postgresql/timezone/Atlantic/Cape_Verde
+share/postgresql/timezone/Atlantic/Faeroe
+share/postgresql/timezone/Atlantic/Jan_Mayen
+share/postgresql/timezone/Atlantic/Madeira
+share/postgresql/timezone/Atlantic/Reykjavik
+share/postgresql/timezone/Atlantic/South_Georgia
+share/postgresql/timezone/Atlantic/St_Helena
+share/postgresql/timezone/Atlantic/Stanley
+share/postgresql/timezone/Australia/ACT
share/postgresql/timezone/Australia/Adelaide
-share/postgresql/timezone/Australia/Hobart
-share/postgresql/timezone/Australia/Melbourne
-share/postgresql/timezone/Australia/Sydney
+share/postgresql/timezone/Australia/Brisbane
share/postgresql/timezone/Australia/Broken_Hill
-share/postgresql/timezone/Australia/Lord_Howe
-share/postgresql/timezone/Australia/ACT
share/postgresql/timezone/Australia/Canberra
+share/postgresql/timezone/Australia/Currie
+share/postgresql/timezone/Australia/Darwin
+share/postgresql/timezone/Australia/Hobart
share/postgresql/timezone/Australia/LHI
+share/postgresql/timezone/Australia/Lindeman
+share/postgresql/timezone/Australia/Lord_Howe
+share/postgresql/timezone/Australia/Melbourne
share/postgresql/timezone/Australia/NSW
share/postgresql/timezone/Australia/North
+share/postgresql/timezone/Australia/Perth
share/postgresql/timezone/Australia/Queensland
share/postgresql/timezone/Australia/South
+share/postgresql/timezone/Australia/Sydney
share/postgresql/timezone/Australia/Tasmania
share/postgresql/timezone/Australia/Victoria
share/postgresql/timezone/Australia/West
share/postgresql/timezone/Australia/Yancowinna
-share/postgresql/timezone/Pacific/Rarotonga
-share/postgresql/timezone/Pacific/Fiji
-share/postgresql/timezone/Pacific/Gambier
-share/postgresql/timezone/Pacific/Marquesas
-share/postgresql/timezone/Pacific/Tahiti
-share/postgresql/timezone/Pacific/Guam
-share/postgresql/timezone/Pacific/Tarawa
-share/postgresql/timezone/Pacific/Enderbury
-share/postgresql/timezone/Pacific/Kiritimati
-share/postgresql/timezone/Pacific/Saipan
-share/postgresql/timezone/Pacific/Majuro
-share/postgresql/timezone/Pacific/Kwajalein
-share/postgresql/timezone/Pacific/Yap
-share/postgresql/timezone/Pacific/Truk
-share/postgresql/timezone/Pacific/Ponape
-share/postgresql/timezone/Pacific/Kosrae
-share/postgresql/timezone/Pacific/Nauru
-share/postgresql/timezone/Pacific/Noumea
-share/postgresql/timezone/Pacific/Auckland
-share/postgresql/timezone/Pacific/Chatham
-share/postgresql/timezone/Pacific/Niue
-share/postgresql/timezone/Pacific/Norfolk
-share/postgresql/timezone/Pacific/Palau
-share/postgresql/timezone/Pacific/Port_Moresby
-share/postgresql/timezone/Pacific/Pitcairn
-share/postgresql/timezone/Pacific/Pago_Pago
-share/postgresql/timezone/Pacific/Apia
-share/postgresql/timezone/Pacific/Guadalcanal
-share/postgresql/timezone/Pacific/Fakaofo
-share/postgresql/timezone/Pacific/Tongatapu
-share/postgresql/timezone/Pacific/Funafuti
-share/postgresql/timezone/Pacific/Johnston
-share/postgresql/timezone/Pacific/Midway
-share/postgresql/timezone/Pacific/Wake
-share/postgresql/timezone/Pacific/Efate
-share/postgresql/timezone/Pacific/Wallis
-share/postgresql/timezone/Pacific/Honolulu
-share/postgresql/timezone/Pacific/Easter
-share/postgresql/timezone/Pacific/Galapagos
-share/postgresql/timezone/Pacific/Samoa
-share/postgresql/timezone/Europe/London
-share/postgresql/timezone/Europe/Belfast
-share/postgresql/timezone/Europe/Dublin
-share/postgresql/timezone/Europe/Tirane
-share/postgresql/timezone/Europe/Andorra
-share/postgresql/timezone/Europe/Vienna
-share/postgresql/timezone/Europe/Minsk
-share/postgresql/timezone/Europe/Brussels
-share/postgresql/timezone/Europe/Sofia
-share/postgresql/timezone/Europe/Prague
-share/postgresql/timezone/Europe/Copenhagen
-share/postgresql/timezone/Europe/Tallinn
-share/postgresql/timezone/Europe/Helsinki
-share/postgresql/timezone/Europe/Paris
-share/postgresql/timezone/Europe/Berlin
-share/postgresql/timezone/Europe/Gibraltar
-share/postgresql/timezone/Europe/Athens
-share/postgresql/timezone/Europe/Budapest
-share/postgresql/timezone/Europe/Rome
-share/postgresql/timezone/Europe/Riga
-share/postgresql/timezone/Europe/Vaduz
-share/postgresql/timezone/Europe/Vilnius
-share/postgresql/timezone/Europe/Luxembourg
-share/postgresql/timezone/Europe/Malta
-share/postgresql/timezone/Europe/Chisinau
-share/postgresql/timezone/Europe/Monaco
-share/postgresql/timezone/Europe/Amsterdam
-share/postgresql/timezone/Europe/Oslo
-share/postgresql/timezone/Europe/Warsaw
-share/postgresql/timezone/Europe/Lisbon
-share/postgresql/timezone/Europe/Bucharest
-share/postgresql/timezone/Europe/Kaliningrad
-share/postgresql/timezone/Europe/Moscow
-share/postgresql/timezone/Europe/Samara
-share/postgresql/timezone/Europe/Belgrade
-share/postgresql/timezone/Europe/Madrid
-share/postgresql/timezone/Europe/Stockholm
-share/postgresql/timezone/Europe/Zurich
-share/postgresql/timezone/Europe/Istanbul
-share/postgresql/timezone/Europe/Kiev
-share/postgresql/timezone/Europe/Uzhgorod
-share/postgresql/timezone/Europe/Zaporozhye
-share/postgresql/timezone/Europe/Simferopol
-share/postgresql/timezone/Europe/Nicosia
-share/postgresql/timezone/Europe/Mariehamn
-share/postgresql/timezone/Europe/Vatican
-share/postgresql/timezone/Europe/San_Marino
-share/postgresql/timezone/Europe/Ljubljana
-share/postgresql/timezone/Europe/Sarajevo
-share/postgresql/timezone/Europe/Skopje
-share/postgresql/timezone/Europe/Zagreb
-share/postgresql/timezone/Europe/Bratislava
-share/postgresql/timezone/Europe/Tiraspol
-share/postgresql/timezone/WET
-share/postgresql/timezone/CET
-share/postgresql/timezone/MET
-share/postgresql/timezone/EET
-share/postgresql/timezone/America/Danmarkshavn
-share/postgresql/timezone/America/Coral_Harbour
-share/postgresql/timezone/America/Scoresbysund
-share/postgresql/timezone/America/Godthab
-share/postgresql/timezone/America/Thule
-share/postgresql/timezone/America/New_York
-share/postgresql/timezone/America/Chicago
-share/postgresql/timezone/America/North_Dakota/Center
-share/postgresql/timezone/America/Denver
-share/postgresql/timezone/America/Los_Angeles
-share/postgresql/timezone/America/Juneau
-share/postgresql/timezone/America/Yakutat
-share/postgresql/timezone/America/Anchorage
-share/postgresql/timezone/America/Nome
-share/postgresql/timezone/America/Adak
-share/postgresql/timezone/America/Phoenix
-share/postgresql/timezone/America/Boise
-share/postgresql/timezone/America/Indianapolis
-share/postgresql/timezone/America/Indiana/Marengo
-share/postgresql/timezone/America/Indiana/Knox
-share/postgresql/timezone/America/Indiana/Vevay
-share/postgresql/timezone/America/Indiana/Indianapolis
-share/postgresql/timezone/America/Louisville
-share/postgresql/timezone/America/Kentucky/Monticello
-share/postgresql/timezone/America/Kentucky/Louisville
-share/postgresql/timezone/America/Detroit
-share/postgresql/timezone/America/Menominee
-share/postgresql/timezone/America/St_Johns
-share/postgresql/timezone/America/Goose_Bay
-share/postgresql/timezone/America/Halifax
-share/postgresql/timezone/America/Glace_Bay
-share/postgresql/timezone/America/Montreal
-share/postgresql/timezone/America/Toronto
-share/postgresql/timezone/America/Thunder_Bay
-share/postgresql/timezone/America/Nipigon
-share/postgresql/timezone/America/Rainy_River
-share/postgresql/timezone/America/Winnipeg
-share/postgresql/timezone/America/Regina
-share/postgresql/timezone/America/Swift_Current
-share/postgresql/timezone/America/Edmonton
-share/postgresql/timezone/America/Vancouver
-share/postgresql/timezone/America/Dawson_Creek
-share/postgresql/timezone/America/Pangnirtung
-share/postgresql/timezone/America/Iqaluit
-share/postgresql/timezone/America/Rankin_Inlet
-share/postgresql/timezone/America/Cambridge_Bay
-share/postgresql/timezone/America/Yellowknife
-share/postgresql/timezone/America/Inuvik
-share/postgresql/timezone/America/Whitehorse
-share/postgresql/timezone/America/Dawson
-share/postgresql/timezone/America/Cancun
-share/postgresql/timezone/America/Merida
-share/postgresql/timezone/America/Monterrey
-share/postgresql/timezone/America/Mexico_City
-share/postgresql/timezone/America/Chihuahua
-share/postgresql/timezone/America/Hermosillo
-share/postgresql/timezone/America/Mazatlan
-share/postgresql/timezone/America/Tijuana
-share/postgresql/timezone/America/Anguilla
-share/postgresql/timezone/America/Antigua
-share/postgresql/timezone/America/Nassau
-share/postgresql/timezone/America/Barbados
-share/postgresql/timezone/America/Belize
-share/postgresql/timezone/America/Cayman
-share/postgresql/timezone/America/Costa_Rica
-share/postgresql/timezone/America/Havana
-share/postgresql/timezone/America/Dominica
-share/postgresql/timezone/America/Santo_Domingo
-share/postgresql/timezone/America/El_Salvador
-share/postgresql/timezone/America/Grenada
-share/postgresql/timezone/America/Guadeloupe
-share/postgresql/timezone/America/Guatemala
-share/postgresql/timezone/America/Port-au-Prince
-share/postgresql/timezone/America/Tegucigalpa
-share/postgresql/timezone/America/Jamaica
-share/postgresql/timezone/America/Martinique
-share/postgresql/timezone/America/Montserrat
-share/postgresql/timezone/America/Managua
-share/postgresql/timezone/America/Panama
-share/postgresql/timezone/America/Puerto_Rico
-share/postgresql/timezone/America/St_Kitts
-share/postgresql/timezone/America/St_Lucia
-share/postgresql/timezone/America/Miquelon
-share/postgresql/timezone/America/St_Vincent
-share/postgresql/timezone/America/Grand_Turk
-share/postgresql/timezone/America/Tortola
-share/postgresql/timezone/America/St_Thomas
-share/postgresql/timezone/America/Argentina/Buenos_Aires
-share/postgresql/timezone/America/Argentina/Cordoba
-share/postgresql/timezone/America/Argentina/Tucuman
-share/postgresql/timezone/America/Argentina/La_Rioja
-share/postgresql/timezone/America/Argentina/San_Juan
-share/postgresql/timezone/America/Argentina/Jujuy
-share/postgresql/timezone/America/Argentina/Catamarca
-share/postgresql/timezone/America/Argentina/Mendoza
-share/postgresql/timezone/America/Argentina/ComodRivadavia
-share/postgresql/timezone/America/Argentina/Rio_Gallegos
-share/postgresql/timezone/America/Argentina/Ushuaia
-share/postgresql/timezone/America/Aruba
-share/postgresql/timezone/America/La_Paz
-share/postgresql/timezone/America/Noronha
-share/postgresql/timezone/America/Belem
-share/postgresql/timezone/America/Fortaleza
-share/postgresql/timezone/America/Recife
-share/postgresql/timezone/America/Araguaina
-share/postgresql/timezone/America/Maceio
-share/postgresql/timezone/America/Bahia
-share/postgresql/timezone/America/Sao_Paulo
-share/postgresql/timezone/America/Campo_Grande
-share/postgresql/timezone/America/Cuiaba
-share/postgresql/timezone/America/Porto_Velho
-share/postgresql/timezone/America/Boa_Vista
-share/postgresql/timezone/America/Manaus
-share/postgresql/timezone/America/Eirunepe
-share/postgresql/timezone/America/Rio_Branco
-share/postgresql/timezone/America/Santiago
-share/postgresql/timezone/America/Bogota
-share/postgresql/timezone/America/Curacao
-share/postgresql/timezone/America/Guayaquil
-share/postgresql/timezone/America/Cayenne
-share/postgresql/timezone/America/Guyana
-share/postgresql/timezone/America/Asuncion
-share/postgresql/timezone/America/Lima
-share/postgresql/timezone/America/Paramaribo
-share/postgresql/timezone/America/Port_of_Spain
-share/postgresql/timezone/America/Montevideo
-share/postgresql/timezone/America/Caracas
-share/postgresql/timezone/America/Shiprock
-share/postgresql/timezone/America/Atka
-share/postgresql/timezone/America/Buenos_Aires
-share/postgresql/timezone/America/Catamarca
-share/postgresql/timezone/America/Cordoba
-share/postgresql/timezone/America/Ensenada
-share/postgresql/timezone/America/Fort_Wayne
-share/postgresql/timezone/America/Jujuy
-share/postgresql/timezone/America/Knox_IN
-share/postgresql/timezone/America/Mendoza
-share/postgresql/timezone/America/Porto_Acre
-share/postgresql/timezone/America/Rosario
-share/postgresql/timezone/America/Virgin
-share/postgresql/timezone/Etc/GMT
-share/postgresql/timezone/Etc/UTC
-share/postgresql/timezone/Etc/UCT
-share/postgresql/timezone/Etc/GMT-14
-share/postgresql/timezone/Etc/GMT-13
-share/postgresql/timezone/Etc/GMT-12
-share/postgresql/timezone/Etc/GMT-11
-share/postgresql/timezone/Etc/GMT-10
-share/postgresql/timezone/Etc/GMT-9
-share/postgresql/timezone/Etc/GMT-8
-share/postgresql/timezone/Etc/GMT-7
-share/postgresql/timezone/Etc/GMT-6
-share/postgresql/timezone/Etc/GMT-5
-share/postgresql/timezone/Etc/GMT-4
-share/postgresql/timezone/Etc/GMT-3
-share/postgresql/timezone/Etc/GMT-2
-share/postgresql/timezone/Etc/GMT-1
-share/postgresql/timezone/Etc/GMT+1
-share/postgresql/timezone/Etc/GMT+2
-share/postgresql/timezone/Etc/GMT+3
-share/postgresql/timezone/Etc/GMT+4
-share/postgresql/timezone/Etc/GMT+5
-share/postgresql/timezone/Etc/GMT+6
-share/postgresql/timezone/Etc/GMT+7
-share/postgresql/timezone/Etc/GMT+8
-share/postgresql/timezone/Etc/GMT+9
-share/postgresql/timezone/Etc/GMT+10
-share/postgresql/timezone/Etc/GMT+11
-share/postgresql/timezone/Etc/GMT+12
-share/postgresql/timezone/Etc/Universal
-share/postgresql/timezone/Etc/Zulu
-share/postgresql/timezone/Etc/Greenwich
-share/postgresql/timezone/Etc/GMT-0
-share/postgresql/timezone/Etc/GMT+0
-share/postgresql/timezone/Etc/GMT0
-share/postgresql/timezone/Factory
-share/postgresql/timezone/Arctic/Longyearbyen
-share/postgresql/timezone/EST5EDT
-share/postgresql/timezone/CST6CDT
-share/postgresql/timezone/MST7MDT
-share/postgresql/timezone/PST8PDT
-share/postgresql/timezone/EST
-share/postgresql/timezone/MST
-share/postgresql/timezone/HST
-share/postgresql/timezone/US/Pacific-New
-share/postgresql/timezone/US/Alaska
-share/postgresql/timezone/US/Aleutian
-share/postgresql/timezone/US/Arizona
-share/postgresql/timezone/US/Central
-share/postgresql/timezone/US/East-Indiana
-share/postgresql/timezone/US/Eastern
-share/postgresql/timezone/US/Hawaii
-share/postgresql/timezone/US/Indiana-Starke
-share/postgresql/timezone/US/Michigan
-share/postgresql/timezone/US/Mountain
-share/postgresql/timezone/US/Pacific
-share/postgresql/timezone/US/Samoa
-share/postgresql/timezone/GMT
share/postgresql/timezone/Brazil/Acre
share/postgresql/timezone/Brazil/DeNoronha
share/postgresql/timezone/Brazil/East
share/postgresql/timezone/Brazil/West
+share/postgresql/timezone/CET
+share/postgresql/timezone/CST6CDT
share/postgresql/timezone/Canada/Atlantic
share/postgresql/timezone/Canada/Central
share/postgresql/timezone/Canada/East-Saskatchewan
@@ -580,56 +419,224 @@ share/postgresql/timezone/Canada/Yukon
share/postgresql/timezone/Chile/Continental
share/postgresql/timezone/Chile/EasterIsland
share/postgresql/timezone/Cuba
+share/postgresql/timezone/EET
+share/postgresql/timezone/EST
+share/postgresql/timezone/EST5EDT
share/postgresql/timezone/Egypt
share/postgresql/timezone/Eire
+share/postgresql/timezone/Etc/GMT
+share/postgresql/timezone/Etc/GMT+0
+share/postgresql/timezone/Etc/GMT+1
+share/postgresql/timezone/Etc/GMT+10
+share/postgresql/timezone/Etc/GMT+11
+share/postgresql/timezone/Etc/GMT+12
+share/postgresql/timezone/Etc/GMT+2
+share/postgresql/timezone/Etc/GMT+3
+share/postgresql/timezone/Etc/GMT+4
+share/postgresql/timezone/Etc/GMT+5
+share/postgresql/timezone/Etc/GMT+6
+share/postgresql/timezone/Etc/GMT+7
+share/postgresql/timezone/Etc/GMT+8
+share/postgresql/timezone/Etc/GMT+9
+share/postgresql/timezone/Etc/GMT-0
+share/postgresql/timezone/Etc/GMT-1
+share/postgresql/timezone/Etc/GMT-10
+share/postgresql/timezone/Etc/GMT-11
+share/postgresql/timezone/Etc/GMT-12
+share/postgresql/timezone/Etc/GMT-13
+share/postgresql/timezone/Etc/GMT-14
+share/postgresql/timezone/Etc/GMT-2
+share/postgresql/timezone/Etc/GMT-3
+share/postgresql/timezone/Etc/GMT-4
+share/postgresql/timezone/Etc/GMT-5
+share/postgresql/timezone/Etc/GMT-6
+share/postgresql/timezone/Etc/GMT-7
+share/postgresql/timezone/Etc/GMT-8
+share/postgresql/timezone/Etc/GMT-9
+share/postgresql/timezone/Etc/GMT0
+share/postgresql/timezone/Etc/Greenwich
+share/postgresql/timezone/Etc/UCT
+share/postgresql/timezone/Etc/UTC
+share/postgresql/timezone/Etc/Universal
+share/postgresql/timezone/Etc/Zulu
+share/postgresql/timezone/Europe/Amsterdam
+share/postgresql/timezone/Europe/Andorra
+share/postgresql/timezone/Europe/Athens
+share/postgresql/timezone/Europe/Belfast
+share/postgresql/timezone/Europe/Belgrade
+share/postgresql/timezone/Europe/Berlin
+share/postgresql/timezone/Europe/Bratislava
+share/postgresql/timezone/Europe/Brussels
+share/postgresql/timezone/Europe/Bucharest
+share/postgresql/timezone/Europe/Budapest
+share/postgresql/timezone/Europe/Chisinau
+share/postgresql/timezone/Europe/Copenhagen
+share/postgresql/timezone/Europe/Dublin
+share/postgresql/timezone/Europe/Gibraltar
+share/postgresql/timezone/Europe/Guernsey
+share/postgresql/timezone/Europe/Helsinki
+share/postgresql/timezone/Europe/Isle_of_Man
+share/postgresql/timezone/Europe/Istanbul
+share/postgresql/timezone/Europe/Jersey
+share/postgresql/timezone/Europe/Kaliningrad
+share/postgresql/timezone/Europe/Kiev
+share/postgresql/timezone/Europe/Lisbon
+share/postgresql/timezone/Europe/Ljubljana
+share/postgresql/timezone/Europe/London
+share/postgresql/timezone/Europe/Luxembourg
+share/postgresql/timezone/Europe/Madrid
+share/postgresql/timezone/Europe/Malta
+share/postgresql/timezone/Europe/Mariehamn
+share/postgresql/timezone/Europe/Minsk
+share/postgresql/timezone/Europe/Monaco
+share/postgresql/timezone/Europe/Moscow
+share/postgresql/timezone/Europe/Nicosia
+share/postgresql/timezone/Europe/Oslo
+share/postgresql/timezone/Europe/Paris
+share/postgresql/timezone/Europe/Podgorica
+share/postgresql/timezone/Europe/Prague
+share/postgresql/timezone/Europe/Riga
+share/postgresql/timezone/Europe/Rome
+share/postgresql/timezone/Europe/Samara
+share/postgresql/timezone/Europe/San_Marino
+share/postgresql/timezone/Europe/Sarajevo
+share/postgresql/timezone/Europe/Simferopol
+share/postgresql/timezone/Europe/Skopje
+share/postgresql/timezone/Europe/Sofia
+share/postgresql/timezone/Europe/Stockholm
+share/postgresql/timezone/Europe/Tallinn
+share/postgresql/timezone/Europe/Tirane
+share/postgresql/timezone/Europe/Tiraspol
+share/postgresql/timezone/Europe/Uzhgorod
+share/postgresql/timezone/Europe/Vaduz
+share/postgresql/timezone/Europe/Vatican
+share/postgresql/timezone/Europe/Vienna
+share/postgresql/timezone/Europe/Vilnius
+share/postgresql/timezone/Europe/Volgograd
+share/postgresql/timezone/Europe/Warsaw
+share/postgresql/timezone/Europe/Zagreb
+share/postgresql/timezone/Europe/Zaporozhye
+share/postgresql/timezone/Europe/Zurich
+share/postgresql/timezone/Factory
share/postgresql/timezone/GB
share/postgresql/timezone/GB-Eire
+share/postgresql/timezone/GMT
share/postgresql/timezone/GMT+0
share/postgresql/timezone/GMT-0
share/postgresql/timezone/GMT0
share/postgresql/timezone/Greenwich
+share/postgresql/timezone/HST
share/postgresql/timezone/Hongkong
share/postgresql/timezone/Iceland
+share/postgresql/timezone/Indian/Antananarivo
+share/postgresql/timezone/Indian/Chagos
+share/postgresql/timezone/Indian/Christmas
+share/postgresql/timezone/Indian/Cocos
+share/postgresql/timezone/Indian/Comoro
+share/postgresql/timezone/Indian/Kerguelen
+share/postgresql/timezone/Indian/Mahe
+share/postgresql/timezone/Indian/Maldives
+share/postgresql/timezone/Indian/Mauritius
+share/postgresql/timezone/Indian/Mayotte
+share/postgresql/timezone/Indian/Reunion
share/postgresql/timezone/Iran
share/postgresql/timezone/Israel
share/postgresql/timezone/Jamaica
share/postgresql/timezone/Japan
share/postgresql/timezone/Kwajalein
share/postgresql/timezone/Libya
+share/postgresql/timezone/MET
+share/postgresql/timezone/MST
+share/postgresql/timezone/MST7MDT
share/postgresql/timezone/Mexico/BajaNorte
share/postgresql/timezone/Mexico/BajaSur
share/postgresql/timezone/Mexico/General
-share/postgresql/timezone/Navajo
+share/postgresql/timezone/Mideast/Riyadh87
+share/postgresql/timezone/Mideast/Riyadh88
+share/postgresql/timezone/Mideast/Riyadh89
share/postgresql/timezone/NZ
share/postgresql/timezone/NZ-CHAT
+share/postgresql/timezone/Navajo
+share/postgresql/timezone/PRC
+share/postgresql/timezone/PST8PDT
+share/postgresql/timezone/Pacific/Apia
+share/postgresql/timezone/Pacific/Auckland
+share/postgresql/timezone/Pacific/Chatham
+share/postgresql/timezone/Pacific/Easter
+share/postgresql/timezone/Pacific/Efate
+share/postgresql/timezone/Pacific/Enderbury
+share/postgresql/timezone/Pacific/Fakaofo
+share/postgresql/timezone/Pacific/Fiji
+share/postgresql/timezone/Pacific/Funafuti
+share/postgresql/timezone/Pacific/Galapagos
+share/postgresql/timezone/Pacific/Gambier
+share/postgresql/timezone/Pacific/Guadalcanal
+share/postgresql/timezone/Pacific/Guam
+share/postgresql/timezone/Pacific/Honolulu
+share/postgresql/timezone/Pacific/Johnston
+share/postgresql/timezone/Pacific/Kiritimati
+share/postgresql/timezone/Pacific/Kosrae
+share/postgresql/timezone/Pacific/Kwajalein
+share/postgresql/timezone/Pacific/Majuro
+share/postgresql/timezone/Pacific/Marquesas
+share/postgresql/timezone/Pacific/Midway
+share/postgresql/timezone/Pacific/Nauru
+share/postgresql/timezone/Pacific/Niue
+share/postgresql/timezone/Pacific/Norfolk
+share/postgresql/timezone/Pacific/Noumea
+share/postgresql/timezone/Pacific/Pago_Pago
+share/postgresql/timezone/Pacific/Palau
+share/postgresql/timezone/Pacific/Pitcairn
+share/postgresql/timezone/Pacific/Ponape
+share/postgresql/timezone/Pacific/Port_Moresby
+share/postgresql/timezone/Pacific/Rarotonga
+share/postgresql/timezone/Pacific/Saipan
+share/postgresql/timezone/Pacific/Samoa
+share/postgresql/timezone/Pacific/Tahiti
+share/postgresql/timezone/Pacific/Tarawa
+share/postgresql/timezone/Pacific/Tongatapu
+share/postgresql/timezone/Pacific/Truk
+share/postgresql/timezone/Pacific/Wake
+share/postgresql/timezone/Pacific/Wallis
+share/postgresql/timezone/Pacific/Yap
share/postgresql/timezone/Poland
share/postgresql/timezone/Portugal
-share/postgresql/timezone/PRC
share/postgresql/timezone/ROC
share/postgresql/timezone/ROK
share/postgresql/timezone/Singapore
share/postgresql/timezone/Turkey
share/postgresql/timezone/UCT
+share/postgresql/timezone/US/Alaska
+share/postgresql/timezone/US/Aleutian
+share/postgresql/timezone/US/Arizona
+share/postgresql/timezone/US/Central
+share/postgresql/timezone/US/East-Indiana
+share/postgresql/timezone/US/Eastern
+share/postgresql/timezone/US/Hawaii
+share/postgresql/timezone/US/Indiana-Starke
+share/postgresql/timezone/US/Michigan
+share/postgresql/timezone/US/Mountain
+share/postgresql/timezone/US/Pacific
+share/postgresql/timezone/US/Pacific-New
+share/postgresql/timezone/US/Samoa
share/postgresql/timezone/UTC
share/postgresql/timezone/Universal
share/postgresql/timezone/W-SU
+share/postgresql/timezone/WET
share/postgresql/timezone/Zulu
-share/postgresql/timezone/SystemV/AST4ADT
-share/postgresql/timezone/SystemV/EST5EDT
-share/postgresql/timezone/SystemV/CST6CDT
-share/postgresql/timezone/SystemV/MST7MDT
-share/postgresql/timezone/SystemV/PST8PDT
-share/postgresql/timezone/SystemV/YST9YDT
-share/postgresql/timezone/SystemV/AST4
-share/postgresql/timezone/SystemV/EST5
-share/postgresql/timezone/SystemV/CST6
-share/postgresql/timezone/SystemV/MST7
-share/postgresql/timezone/SystemV/PST8
-share/postgresql/timezone/SystemV/YST9
-share/postgresql/timezone/SystemV/HST10
-share/postgresql/timezone/Mideast/Riyadh87
-share/postgresql/timezone/Mideast/Riyadh88
-share/postgresql/timezone/Mideast/Riyadh89
+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
@dirrm share/postgresql/timezone/Africa
@dirrm share/postgresql/timezone/America/Argentina
@dirrm share/postgresql/timezone/America/Indiana
@@ -650,9 +657,9 @@ share/postgresql/timezone/Mideast/Riyadh89
@dirrm share/postgresql/timezone/Mexico
@dirrm share/postgresql/timezone/Mideast
@dirrm share/postgresql/timezone/Pacific
-@dirrm share/postgresql/timezone/SystemV
@dirrm share/postgresql/timezone/US
@dirrm share/postgresql/timezone
+@dirrm share/postgresql/timezonesets
@unexec if cmp -s ~pgsql/.profile %D/share/postgresql/dot.profile.dist; then rm -f ~pgsql/.profile; fi
@unexec if cmp -s ~pgsql/.cshrc %D/share/postgresql/dot.cshrc.dist; then rm -f ~pgsql/.cshrc; fi
@unexec [ -f ~pgsql/dot.profile.dist ] && rm ~pgsql/dot.profile.dist