Update PostgreSQL to latest versions.

URL: http://www.postgresql.org/about/news.1055

The PostgreSQL Project today released
updates to all active branches of the
PostgreSQL object-relational database
system, including versions 8.3.6,
8.2.12, 8.1.16, 8.0.20 and 7.4.24. These
updates include two serious fixes, for
autovacuum crashes in version 8.1 and
GiST indexing data loss in 8.3, and
those two versions should be updated as
soon as possible.

These update releases also include
patches for several low-risk security
holes, as well as up to 17 other minor
fixes, depending on your major version
of PostgreSQL. Included as well are
Daylight Savings Time changes for Nepal,
Switzerland and Cuba. See the release
notes for full details.

The first serious issue affects users
who are using version 8.1 with
Autovacuum, which will fail when XID
rollover is required. The second serious
issue can cause data loss when CLUSTER
is used with GiST indexes (such as full
text indexes) on version 8.3. Both
issues are fixed in these releases.

26 files changed, 46 insertions, 38 deletions

diff --git a/databases/postgresql74-server/Makefile b/databases/postgresql74-server/Makefile
index fc7e6e0aebf4..5e2072e75a5d 100644
--- a/databases/postgresql74-server/Makefile
+++ b/databases/postgresql74-server/Makefile
@@ -6,7 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.4.23
+PORTVERSION?=	7.4.24
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${PORTVERSION}
@@ -89,7 +89,7 @@ OPTIONS+=	DEBUG "Builds with debugging symbols" off
 OPTIONS+=	HIER  "Builds with query hierarchy (server)" off
 
 .  if (defined(SERVER_ONLY) && defined(WITH_HIER)) || make(makesum)
-PATCH_SITES+=	http://gppl.moonbone.ru/:hier74053
+PATCH_SITES+=	http://people.freebsd.org/~girgen/postgresql-hier/:hier74053
 PATCHFILES+=	hier-Pg7.4-0.5.3.tar.gz:hier74053
 USE_BISON=	build
 .  endif
diff --git a/databases/postgresql74-server/distinfo b/databases/postgresql74-server/distinfo
index 98e6b601e93f..879f4b526c7b 100644
--- a/databases/postgresql74-server/distinfo
+++ b/databases/postgresql74-server/distinfo
@@ -1,6 +1,6 @@
-MD5 (postgresql/postgresql-7.4.23.tar.bz2) = 28cc0f6721eb04cd2323bc75452709d9
-SHA256 (postgresql/postgresql-7.4.23.tar.bz2) = c96707c06d988718bbb31b7d1676e4cd698ba8b847420aae86b67f2381a53edf
-SIZE (postgresql/postgresql-7.4.23.tar.bz2) = 10291308
+MD5 (postgresql/postgresql-7.4.24.tar.bz2) = 8287efcb6d4d0f2a631fd35149e8b8d2
+SHA256 (postgresql/postgresql-7.4.24.tar.bz2) = 8ab16a57581b9186868374b56e45fd602413481594f3d26b9ca783d08cbe55f9
+SIZE (postgresql/postgresql-7.4.24.tar.bz2) = 10293454
 MD5 (postgresql/hier-Pg7.4-0.5.3.tar.gz) = 16d037213b879963724da7809a0a1589
 SHA256 (postgresql/hier-Pg7.4-0.5.3.tar.gz) = 1e56f76560c86227b08faabf78e3a53de4188c6a8f9d1f38b1481427e8fdf74c
 SIZE (postgresql/hier-Pg7.4-0.5.3.tar.gz) = 34662
diff --git a/databases/postgresql80-server/Makefile b/databases/postgresql80-server/Makefile
index 922080ea6d3a..d41f32cddfd8 100644
--- a/databases/postgresql80-server/Makefile
+++ b/databases/postgresql80-server/Makefile
@@ -6,7 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	8.0.19
+PORTVERSION?=	8.0.20
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${PORTVERSION}
@@ -98,7 +98,7 @@ OPTIONS+=	HIER  "Builds with query hierarchy (server)" off
 OPTIONS+=	INTDATE "Builds with 64-bit date/time type (server)" off
 
 .  if (defined(SERVER_ONLY) && defined(WITH_HIER)) || make(makesum)
-PATCH_SITES+=	http://gppl.moonbone.ru/:hier801055
+PATCH_SITES+=	http://people.freebsd.org/~girgen/postgresql-hier/:hier801055
 PATCHFILES+=	hier-Pg8.0.3-0.5.5.diff.gz:hier801055
 USE_BISON=	build
 .  endif
diff --git a/databases/postgresql80-server/distinfo b/databases/postgresql80-server/distinfo
index 0ab098d27235..fccd296f90d0 100644
--- a/databases/postgresql80-server/distinfo
+++ b/databases/postgresql80-server/distinfo
@@ -1,6 +1,6 @@
-MD5 (postgresql/postgresql-8.0.19.tar.bz2) = 32e1f472b43b0bdf617ca112f7dcfcf3
-SHA256 (postgresql/postgresql-8.0.19.tar.bz2) = 8377daddca68532d5348d3232897afe84206998686d39c11b8799360098ed4f8
-SIZE (postgresql/postgresql-8.0.19.tar.bz2) = 11238188
+MD5 (postgresql/postgresql-8.0.20.tar.bz2) = b6ce489b363b925fb01ff81f8825c03c
+SHA256 (postgresql/postgresql-8.0.20.tar.bz2) = 2769db906b655ead9d79dd611b78a4fe93a824d14f2445be7462bbece02da033
+SIZE (postgresql/postgresql-8.0.20.tar.bz2) = 11239311
 MD5 (postgresql/hier-Pg8.0.3-0.5.5.diff.gz) = 9fa75cd7b3f1cb913d2e6d310582a4bc
 SHA256 (postgresql/hier-Pg8.0.3-0.5.5.diff.gz) = f3a1849f2d527759ef721502cb445a435e072cc9be820c2e489c9e4a71c7adbe
 SIZE (postgresql/hier-Pg8.0.3-0.5.5.diff.gz) = 30555
diff --git a/databases/postgresql80-server/pkg-plist-server b/databases/postgresql80-server/pkg-plist-server
index 78a686554e73..a1671d2e0ad4 100644
--- a/databases/postgresql80-server/pkg-plist-server
+++ b/databases/postgresql80-server/pkg-plist-server
@@ -389,6 +389,7 @@ share/postgresql/timezone/Asia/Kabul
 share/postgresql/timezone/Asia/Kamchatka
 share/postgresql/timezone/Asia/Karachi
 share/postgresql/timezone/Asia/Kashgar
+share/postgresql/timezone/Asia/Kathmandu
 share/postgresql/timezone/Asia/Katmandu
 share/postgresql/timezone/Asia/Kolkata
 share/postgresql/timezone/Asia/Krasnoyarsk
diff --git a/databases/postgresql81-server/Makefile b/databases/postgresql81-server/Makefile
index e27ec8e145c5..49fa3209b119 100644
--- a/databases/postgresql81-server/Makefile
+++ b/databases/postgresql81-server/Makefile
@@ -6,7 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	8.1.15
+PORTVERSION?=	8.1.16
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${PORTVERSION}
diff --git a/databases/postgresql81-server/distinfo b/databases/postgresql81-server/distinfo
index 9d399491a4a2..0b1e927c4a0b 100644
--- a/databases/postgresql81-server/distinfo
+++ b/databases/postgresql81-server/distinfo
@@ -1,6 +1,6 @@
-MD5 (postgresql/postgresql-8.1.15.tar.bz2) = fc7cb58efbc74b9a0b7dbc3921fb304c
-SHA256 (postgresql/postgresql-8.1.15.tar.bz2) = f6550626b5c7236ad5fe5586a2f6d79e598374f809cf86b0acd33cf7247ab352
-SIZE (postgresql/postgresql-8.1.15.tar.bz2) = 11775183
+MD5 (postgresql/postgresql-8.1.16.tar.bz2) = 0ea222b92d68cc690ca9ee8275660c4b
+SHA256 (postgresql/postgresql-8.1.16.tar.bz2) = 6bfd599b623a77602bae44751a3129b7c66089b087df77094244577151779321
+SIZE (postgresql/postgresql-8.1.16.tar.bz2) = 11772484
 MD5 (postgresql/hier-Pg8.1.2-0.5.5.diff.gz) = 15916bf13b99702599ce70b6475f7d86
 SHA256 (postgresql/hier-Pg8.1.2-0.5.5.diff.gz) = 14ecc3809ce69f47c3460efee3fc7fce78f68802936650fc4e1132adffd41d1e
 SIZE (postgresql/hier-Pg8.1.2-0.5.5.diff.gz) = 31203
diff --git a/databases/postgresql81-server/pkg-plist-server b/databases/postgresql81-server/pkg-plist-server
index 4a1a745b33fd..397609794c28 100644
--- a/databases/postgresql81-server/pkg-plist-server
+++ b/databases/postgresql81-server/pkg-plist-server
@@ -390,6 +390,7 @@ share/postgresql/timezone/Asia/Kabul
 share/postgresql/timezone/Asia/Kamchatka
 share/postgresql/timezone/Asia/Karachi
 share/postgresql/timezone/Asia/Kashgar
+share/postgresql/timezone/Asia/Kathmandu
 share/postgresql/timezone/Asia/Katmandu
 share/postgresql/timezone/Asia/Kolkata
 share/postgresql/timezone/Asia/Krasnoyarsk
diff --git a/databases/postgresql82-server/Makefile b/databases/postgresql82-server/Makefile
index 0e1cc34a9dd8..d0a3fc886799 100644
--- a/databases/postgresql82-server/Makefile
+++ b/databases/postgresql82-server/Makefile
@@ -6,7 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	8.2.11
+PORTVERSION?=	8.2.12
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${PORTVERSION}
diff --git a/databases/postgresql82-server/distinfo b/databases/postgresql82-server/distinfo
index 69b196c3644b..92b1cddcc70a 100644
--- a/databases/postgresql82-server/distinfo
+++ b/databases/postgresql82-server/distinfo
@@ -1,3 +1,3 @@
-MD5 (postgresql/postgresql-8.2.11.tar.bz2) = 84e1fedd5f676e978a3afa744bc71b0a
-SHA256 (postgresql/postgresql-8.2.11.tar.bz2) = 64ef6f38556d88356b7aea5496c9394ddf6e1afabda17db7ee15ddc6af82356b
-SIZE (postgresql/postgresql-8.2.11.tar.bz2) = 12564132
+MD5 (postgresql/postgresql-8.2.12.tar.bz2) = a5dc4a14100c318d5ad3107c4ec840ec
+SHA256 (postgresql/postgresql-8.2.12.tar.bz2) = 7ca1feea2654ced016521805791de815c85d47abd6ebff3b8f365785650beaf2
+SIZE (postgresql/postgresql-8.2.12.tar.bz2) = 12569185
diff --git a/databases/postgresql82-server/pkg-plist-server b/databases/postgresql82-server/pkg-plist-server
index c8586f1b19f9..dd6afcfea2cd 100644
--- a/databases/postgresql82-server/pkg-plist-server
+++ b/databases/postgresql82-server/pkg-plist-server
@@ -387,6 +387,7 @@ share/postgresql/timezone/Asia/Kabul
 share/postgresql/timezone/Asia/Kamchatka
 share/postgresql/timezone/Asia/Karachi
 share/postgresql/timezone/Asia/Kashgar
+share/postgresql/timezone/Asia/Kathmandu
 share/postgresql/timezone/Asia/Katmandu
 share/postgresql/timezone/Asia/Kolkata
 share/postgresql/timezone/Asia/Krasnoyarsk
diff --git a/databases/postgresql83-server/Makefile b/databases/postgresql83-server/Makefile
index ebfa6998f38f..097118f2c580 100644
--- a/databases/postgresql83-server/Makefile
+++ b/databases/postgresql83-server/Makefile
@@ -6,7 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-DISTVERSION?=	8.3.5
+DISTVERSION?=	8.3.6
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${DISTVERSION}
diff --git a/databases/postgresql83-server/distinfo b/databases/postgresql83-server/distinfo
index 461b5d2e1187..c3126d0d31a4 100644
--- a/databases/postgresql83-server/distinfo
+++ b/databases/postgresql83-server/distinfo
@@ -1,6 +1,6 @@
-MD5 (postgresql/postgresql-8.3.5.tar.bz2) = 3bc028774d7a79e926be0c6a9c7ca209
-SHA256 (postgresql/postgresql-8.3.5.tar.bz2) = e03f0c472b0ab8c4374ba13a1534d2c940c6235c9f74f2c95f97855eff185448
-SIZE (postgresql/postgresql-8.3.5.tar.bz2) = 14052114
+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
diff --git a/databases/postgresql83-server/pkg-plist-server b/databases/postgresql83-server/pkg-plist-server
index 3fe987bb3d39..acd1ed72f94d 100644
--- a/databases/postgresql83-server/pkg-plist-server
+++ b/databases/postgresql83-server/pkg-plist-server
@@ -398,6 +398,7 @@ share/postgresql/snowball_create.sql
 %%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
diff --git a/databases/postgresql84-server/Makefile b/databases/postgresql84-server/Makefile
index ebfa6998f38f..097118f2c580 100644
--- a/databases/postgresql84-server/Makefile
+++ b/databases/postgresql84-server/Makefile
@@ -6,7 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-DISTVERSION?=	8.3.5
+DISTVERSION?=	8.3.6
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${DISTVERSION}
diff --git a/databases/postgresql84-server/distinfo b/databases/postgresql84-server/distinfo
index 461b5d2e1187..c3126d0d31a4 100644
--- a/databases/postgresql84-server/distinfo
+++ b/databases/postgresql84-server/distinfo
@@ -1,6 +1,6 @@
-MD5 (postgresql/postgresql-8.3.5.tar.bz2) = 3bc028774d7a79e926be0c6a9c7ca209
-SHA256 (postgresql/postgresql-8.3.5.tar.bz2) = e03f0c472b0ab8c4374ba13a1534d2c940c6235c9f74f2c95f97855eff185448
-SIZE (postgresql/postgresql-8.3.5.tar.bz2) = 14052114
+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
diff --git a/databases/postgresql84-server/pkg-plist-server b/databases/postgresql84-server/pkg-plist-server
index 3fe987bb3d39..acd1ed72f94d 100644
--- a/databases/postgresql84-server/pkg-plist-server
+++ b/databases/postgresql84-server/pkg-plist-server
@@ -398,6 +398,7 @@ share/postgresql/snowball_create.sql
 %%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
diff --git a/databases/postgresql90-server/Makefile b/databases/postgresql90-server/Makefile
index ebfa6998f38f..097118f2c580 100644
--- a/databases/postgresql90-server/Makefile
+++ b/databases/postgresql90-server/Makefile
@@ -6,7 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-DISTVERSION?=	8.3.5
+DISTVERSION?=	8.3.6
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${DISTVERSION}
diff --git a/databases/postgresql90-server/distinfo b/databases/postgresql90-server/distinfo
index 461b5d2e1187..c3126d0d31a4 100644
--- a/databases/postgresql90-server/distinfo
+++ b/databases/postgresql90-server/distinfo
@@ -1,6 +1,6 @@
-MD5 (postgresql/postgresql-8.3.5.tar.bz2) = 3bc028774d7a79e926be0c6a9c7ca209
-SHA256 (postgresql/postgresql-8.3.5.tar.bz2) = e03f0c472b0ab8c4374ba13a1534d2c940c6235c9f74f2c95f97855eff185448
-SIZE (postgresql/postgresql-8.3.5.tar.bz2) = 14052114
+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
diff --git a/databases/postgresql90-server/pkg-plist-server b/databases/postgresql90-server/pkg-plist-server
index 3fe987bb3d39..acd1ed72f94d 100644
--- a/databases/postgresql90-server/pkg-plist-server
+++ b/databases/postgresql90-server/pkg-plist-server
@@ -398,6 +398,7 @@ share/postgresql/snowball_create.sql
 %%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
diff --git a/databases/postgresql91-server/Makefile b/databases/postgresql91-server/Makefile
index ebfa6998f38f..097118f2c580 100644
--- a/databases/postgresql91-server/Makefile
+++ b/databases/postgresql91-server/Makefile
@@ -6,7 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-DISTVERSION?=	8.3.5
+DISTVERSION?=	8.3.6
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${DISTVERSION}
diff --git a/databases/postgresql91-server/distinfo b/databases/postgresql91-server/distinfo
index 461b5d2e1187..c3126d0d31a4 100644
--- a/databases/postgresql91-server/distinfo
+++ b/databases/postgresql91-server/distinfo
@@ -1,6 +1,6 @@
-MD5 (postgresql/postgresql-8.3.5.tar.bz2) = 3bc028774d7a79e926be0c6a9c7ca209
-SHA256 (postgresql/postgresql-8.3.5.tar.bz2) = e03f0c472b0ab8c4374ba13a1534d2c940c6235c9f74f2c95f97855eff185448
-SIZE (postgresql/postgresql-8.3.5.tar.bz2) = 14052114
+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
diff --git a/databases/postgresql91-server/pkg-plist-server b/databases/postgresql91-server/pkg-plist-server
index 3fe987bb3d39..acd1ed72f94d 100644
--- a/databases/postgresql91-server/pkg-plist-server
+++ b/databases/postgresql91-server/pkg-plist-server
@@ -398,6 +398,7 @@ share/postgresql/snowball_create.sql
 %%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
diff --git a/databases/postgresql92-server/Makefile b/databases/postgresql92-server/Makefile
index ebfa6998f38f..097118f2c580 100644
--- a/databases/postgresql92-server/Makefile
+++ b/databases/postgresql92-server/Makefile
@@ -6,7 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-DISTVERSION?=	8.3.5
+DISTVERSION?=	8.3.6
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${DISTVERSION}
diff --git a/databases/postgresql92-server/distinfo b/databases/postgresql92-server/distinfo
index 461b5d2e1187..c3126d0d31a4 100644
--- a/databases/postgresql92-server/distinfo
+++ b/databases/postgresql92-server/distinfo
@@ -1,6 +1,6 @@
-MD5 (postgresql/postgresql-8.3.5.tar.bz2) = 3bc028774d7a79e926be0c6a9c7ca209
-SHA256 (postgresql/postgresql-8.3.5.tar.bz2) = e03f0c472b0ab8c4374ba13a1534d2c940c6235c9f74f2c95f97855eff185448
-SIZE (postgresql/postgresql-8.3.5.tar.bz2) = 14052114
+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
diff --git a/databases/postgresql92-server/pkg-plist-server b/databases/postgresql92-server/pkg-plist-server
index 3fe987bb3d39..acd1ed72f94d 100644
--- a/databases/postgresql92-server/pkg-plist-server
+++ b/databases/postgresql92-server/pkg-plist-server
@@ -398,6 +398,7 @@ share/postgresql/snowball_create.sql
 %%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