24 files changed, 190 insertions, 175 deletions

diff --git a/UPDATING b/UPDATING
index 9d317b288b58..353821331edd 100644
--- a/UPDATING
+++ b/UPDATING
@@ -6,6 +6,18 @@ You should get into the habit of checking this file for changes each
 time you update your ports collection, before attempting any port
 upgrades.
 
+20060109:
+  AFFECTS: users of databases/postgresql??-server
+  AUTHOR: girgen@FreeBSD.org
+
+  All postgresql versions have been updated. These patch releases fix
+  a problem with character string comparisons for locales that
+  consider different character combinations as equal, such as
+  Hungarian. This might require "REINDEX" to fix existing indexes on
+  textual columns. Also, if plperl is used, a "REINDEX" might be
+  required under certain conditions. Check the HISTORY file in the
+  source for details.
+
 20060108:
   AFFECTS: users of x11/kdelibs3, x11/kdebase3, deskutils/superkaramba,
 	            x11-themes/kde-windeco-smoothblend, irc/kvirc
diff --git a/databases/postgresql73-server/Makefile b/databases/postgresql73-server/Makefile
index 32063d95bf32..20ef9f83cbb8 100644
--- a/databases/postgresql73-server/Makefile
+++ b/databases/postgresql73-server/Makefile
@@ -7,8 +7,8 @@
 
 PORTNAME?=	postgresql
 PKGNAMESUFFIX?=	-server
-PORTVERSION?=	7.3.12
-PORTREVISION?=	1
+PORTVERSION?=	7.3.13
+PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${PORTVERSION}
diff --git a/databases/postgresql73-server/distinfo b/databases/postgresql73-server/distinfo
index c41645df922c..5bf4b7ce5ce3 100644
--- a/databases/postgresql73-server/distinfo
+++ b/databases/postgresql73-server/distinfo
@@ -1,12 +1,12 @@
-MD5 (postgresql/postgresql-base-7.3.12.tar.bz2) = 1f2764d83309e6fbb150a635a4d7b193
-SHA256 (postgresql/postgresql-base-7.3.12.tar.bz2) = 3f0f60e56d43acd3c9641e964efa6dfb1f7ec5fefe1356141b90441c2f3279e9
-SIZE (postgresql/postgresql-base-7.3.12.tar.bz2) = 5666468
-MD5 (postgresql/postgresql-docs-7.3.12.tar.bz2) = 0d43b3c47cf4efbb88e0d3b6c9a44bb3
-SHA256 (postgresql/postgresql-docs-7.3.12.tar.bz2) = 15387a837f0baea312a9a34aef4d008c760a87dcc2c5df6009eaa557fe2a3e39
-SIZE (postgresql/postgresql-docs-7.3.12.tar.bz2) = 2349826
-MD5 (postgresql/postgresql-opt-7.3.12.tar.bz2) = 404e60bd3f0a7f03826769cc66f60078
-SHA256 (postgresql/postgresql-opt-7.3.12.tar.bz2) = f56de7e8accc96e798e656456e61ea73d3c2620d6bd13769f5624a801e0e6d1a
-SIZE (postgresql/postgresql-opt-7.3.12.tar.bz2) = 340942
-MD5 (postgresql/postgresql-test-7.3.12.tar.bz2) = 8a3509d76e238b75bc5ec3119167a18e
-SHA256 (postgresql/postgresql-test-7.3.12.tar.bz2) = f93e1b78c91448ffe02bab1ca842e30cbaaf7c77d925937da0a8586cabe08f71
-SIZE (postgresql/postgresql-test-7.3.12.tar.bz2) = 908711
+MD5 (postgresql/postgresql-base-7.3.13.tar.bz2) = 458852cd6ebc5eb87ea71c73041fa4e9
+SHA256 (postgresql/postgresql-base-7.3.13.tar.bz2) = d2dc69e976ebb4b5a20a495735d8d6151eedb44943585fb565d81cf7ed8e95dc
+SIZE (postgresql/postgresql-base-7.3.13.tar.bz2 = 5668650
+MD5 (postgresql/postgresql-docs-7.3.13.tar.bz2) = 250ad8f52cd95ac0edc6017e4797a927
+SHA256 (postgresql/postgresql-docs-7.3.13.tar.bz2) = 4d371d2e7c2b86f0f02d72bffb224e0afce1347aed906bb2b0709555da56b251
+SIZE (postgresql/postgresql-docs-7.3.13.tar.bz2 = 2352275
+MD5 (postgresql/postgresql-opt-7.3.13.tar.bz2) = 756c647118ac629048811f4e97c9ce6b
+SHA256 (postgresql/postgresql-opt-7.3.13.tar.bz2) = cbbfb168d0ce3f9b21635e84f1a84ee012908cb5a9b92868541f1cf61d801cad
+SIZE (postgresql/postgresql-opt-7.3.13.tar.bz2 = 340592
+MD5 (postgresql/postgresql-test-7.3.13.tar.bz2) = c418fc6ce23692503f9957c307090fb0
+SHA256 (postgresql/postgresql-test-7.3.13.tar.bz2) = cb5aaaf12c4de90a24cdf6955c0b78f9caee050af53d8ec980e98e9bb59c813b
+SIZE (postgresql/postgresql-test-7.3.13.tar.bz2 = 908661
diff --git a/databases/postgresql74-server/Makefile b/databases/postgresql74-server/Makefile
index e4a45be025ba..beb3bde05875 100644
--- a/databases/postgresql74-server/Makefile
+++ b/databases/postgresql74-server/Makefile
@@ -7,8 +7,8 @@
 
 PORTNAME?=	postgresql
 PKGNAMESUFFIX?=	-server
-PORTVERSION?=	7.4.10
-PORTREVISION?=	1
+PORTVERSION?=	7.4.11
+PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${PORTVERSION}
diff --git a/databases/postgresql74-server/distinfo b/databases/postgresql74-server/distinfo
index 38f49048775b..100e6dd65975 100644
--- a/databases/postgresql74-server/distinfo
+++ b/databases/postgresql74-server/distinfo
@@ -1,12 +1,12 @@
-MD5 (postgresql/postgresql-base-7.4.10.tar.bz2) = 0febdd68d8b6b42d0b1b28f44b61a3c0
-SHA256 (postgresql/postgresql-base-7.4.10.tar.bz2) = 1261aad33d929e4ac56efb79f767b2f3f5349bd6a84df558c1512ddf1c44fffa
-SIZE (postgresql/postgresql-base-7.4.10.tar.bz2) = 6600686
-MD5 (postgresql/postgresql-docs-7.4.10.tar.bz2) = 73a9bd7cb4b28f7d9a046d5caa008427
-SHA256 (postgresql/postgresql-docs-7.4.10.tar.bz2) = 2c64b2e8557ea039a444c05c237f4e25a7b8d4b7f1af05edb679aff41b16bdee
-SIZE (postgresql/postgresql-docs-7.4.10.tar.bz2) = 2428051
-MD5 (postgresql/postgresql-opt-7.4.10.tar.bz2) = f7232f719e3a44c32339bf1f7b2f152c
-SHA256 (postgresql/postgresql-opt-7.4.10.tar.bz2) = d022548c217ab22b9e0a4fac29b2003e4a3188ab6ffdd4bb792e1afd110a2489
-SIZE (postgresql/postgresql-opt-7.4.10.tar.bz2) = 332230
-MD5 (postgresql/postgresql-test-7.4.10.tar.bz2) = 0f40672f0193e63d72c24d1facd0107b
-SHA256 (postgresql/postgresql-test-7.4.10.tar.bz2) = 711a5c9470be4cbd9104da67d7c95c7a09cb10da0f389737e30b178cc2db0d7f
-SIZE (postgresql/postgresql-test-7.4.10.tar.bz2) = 946195
+MD5 (postgresql/postgresql-base-7.4.11.tar.bz2) = eba9721a4223c1c2fad003666c678395
+SHA256 (postgresql/postgresql-base-7.4.11.tar.bz2) = da1847096b2902320c2f55c062854a098d76ea7985fdfbcab9eee9cba02f08d2
+SIZE (postgresql/postgresql-base-7.4.11.tar.bz2 = 6601862
+MD5 (postgresql/postgresql-docs-7.4.11.tar.bz2) = a765c102b296e8c91e2f67982ceeb2a0
+SHA256 (postgresql/postgresql-docs-7.4.11.tar.bz2) = 9d57c580ffbfb1aa124d7ef7cb29875292b6377a0a0858b9aa1aa74a53816338
+SIZE (postgresql/postgresql-docs-7.4.11.tar.bz2 = 2430013
+MD5 (postgresql/postgresql-opt-7.4.11.tar.bz2) = 820a0e99ee3c7d76430b3368571ea660
+SHA256 (postgresql/postgresql-opt-7.4.11.tar.bz2) = 4a665978ab5de952c4e9f0857d94f237029f6443f4be40a5eb5f61df73060849
+SIZE (postgresql/postgresql-opt-7.4.11.tar.bz2 = 332416
+MD5 (postgresql/postgresql-test-7.4.11.tar.bz2) = 4dd74f6b040e71f44a88ab1f953cbd2f
+SHA256 (postgresql/postgresql-test-7.4.11.tar.bz2) = 53a7a1642ea8aacff9ec8b9958d9ea6fea5c285f4152942a8481f1fd89d92699
+SIZE (postgresql/postgresql-test-7.4.11.tar.bz2 = 944208
diff --git a/databases/postgresql80-client/Makefile b/databases/postgresql80-client/Makefile
index 455541953e21..9b3ce9abf9d7 100644
--- a/databases/postgresql80-client/Makefile
+++ b/databases/postgresql80-client/Makefile
@@ -15,7 +15,7 @@ COMMENT=	PostgreSQL database (client)
 
 MASTERDIR=	${.CURDIR}/../postgresql80-server
 
-BUILD_DIRS=	src/include src/interfaces src/bin doc src/makefiles
+BUILD_DIRS=	config src/include src/interfaces src/bin doc src/makefiles
 CLIENT_ONLY=	yes
 INSTALLS_SHLIB=	yes
 
diff --git a/databases/postgresql80-server/Makefile b/databases/postgresql80-server/Makefile
index bb8c0681dd69..737455191e62 100644
--- a/databases/postgresql80-server/Makefile
+++ b/databases/postgresql80-server/Makefile
@@ -7,8 +7,8 @@
 
 PORTNAME?=	postgresql
 PKGNAMESUFFIX?=	-server
-PORTVERSION?=	8.0.5
-PORTREVISION?=	1
+PORTVERSION?=	8.0.6
+PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${PORTVERSION}
@@ -112,7 +112,7 @@ USE_AUTOTOOLS=	autoconf:253
 CONFIGURE_ARGS+=--with-icu
 LIB_DEPENDS=	icudata.34:${PORTSDIR}/devel/icu
 PATCH_SITES+=	http://people.freebsd.org/~girgen/postgresql-icu/:icu
-PATCHFILES+=	pg-803-icu-34-2005-10-27.diff.gz:icu
+PATCHFILES+=	pg-806-icu-34-2006-01-09.diff.gz:icu
 .  endif
 
 PATCH_DIST_STRIP=-p1
diff --git a/databases/postgresql80-server/distinfo b/databases/postgresql80-server/distinfo
index 3b8b51a2ef2e..a61340569dd0 100644
--- a/databases/postgresql80-server/distinfo
+++ b/databases/postgresql80-server/distinfo
@@ -1,18 +1,18 @@
-MD5 (postgresql/postgresql-base-8.0.5.tar.bz2) = bac4dfcd3b33124ba63f1c7a3ae49586
-SHA256 (postgresql/postgresql-base-8.0.5.tar.bz2) = f844241e7066de5e9d21b0f498b1f93d3e2c470afe390b27907783d6656f6a87
-SIZE (postgresql/postgresql-base-8.0.5.tar.bz2) = 7826109
-MD5 (postgresql/postgresql-docs-8.0.5.tar.bz2) = 1b6b3013f6098d2fddbeced56f38305a
-SHA256 (postgresql/postgresql-docs-8.0.5.tar.bz2) = b0e890797a4f9e127b9ba0d417722dac19137fcc113600ff93304fe521cfc2a6
-SIZE (postgresql/postgresql-docs-8.0.5.tar.bz2) = 2247707
-MD5 (postgresql/postgresql-opt-8.0.5.tar.bz2) = 77bb201d264ab5d34e6812bd0a615679
-SHA256 (postgresql/postgresql-opt-8.0.5.tar.bz2) = 2990b3e382233c66ef3f8138f2826f38007c15269454c51ce0be9a8da8295840
-SIZE (postgresql/postgresql-opt-8.0.5.tar.bz2) = 133847
-MD5 (postgresql/postgresql-test-8.0.5.tar.bz2) = 0cb4ccdc6fea7b4d34456f0dca541d42
-SHA256 (postgresql/postgresql-test-8.0.5.tar.bz2) = a6234dfe58b88ad1994b7c2548150bab7c7a8a9033a0a0d934e2b5e16cd401e6
-SIZE (postgresql/postgresql-test-8.0.5.tar.bz2) = 959676
+MD5 (postgresql/postgresql-base-8.0.6.tar.bz2) = 106faa96ca820ca7fb55936db394996b
+SHA256 (postgresql/postgresql-base-8.0.6.tar.bz2) = 3916a87c20f2f947bf4a546059d7b3fee714f8dbaf3630bd1265032ba29012d3
+SIZE (postgresql/postgresql-base-8.0.6.tar.bz2 = 7825582
+MD5 (postgresql/postgresql-docs-8.0.6.tar.bz2) = 3d289f9aad770a22293caf293bc9da9e
+SHA256 (postgresql/postgresql-docs-8.0.6.tar.bz2) = 8d337bf5d1616dc615469e49a6763a5d4e3e06565e6c02e00533e2a663d119a7
+SIZE (postgresql/postgresql-docs-8.0.6.tar.bz2 = 2251094
+MD5 (postgresql/postgresql-opt-8.0.6.tar.bz2) = 4ce9485061082e9d837735071f7b03d6
+SHA256 (postgresql/postgresql-opt-8.0.6.tar.bz2) = dddfd91f46611961428541682b55225f8204a4d00246b6d672bf36228e58959c
+SIZE (postgresql/postgresql-opt-8.0.6.tar.bz2 = 133985
+MD5 (postgresql/postgresql-test-8.0.6.tar.bz2) = 3aa1d7885aa5d83c2d31ae0b90c411c2
+SHA256 (postgresql/postgresql-test-8.0.6.tar.bz2) = 2a528bb2112792db6152fd1ecccdcd81ec789f1ca776b18c1cd525b9df66548d
+SIZE (postgresql/postgresql-test-8.0.6.tar.bz2 = 958354
 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
-MD5 (postgresql/pg-803-icu-34-2005-10-27.diff.gz) = 277f3fb5e6f69c17cf4da9fa13b67d43
-SHA256 (postgresql/pg-803-icu-34-2005-10-27.diff.gz) = 08f35cf47d2c58d0ade31b8b36a1de740047b0c8aa22e66c8caef0bd1d8277a0
-SIZE (postgresql/pg-803-icu-34-2005-10-27.diff.gz) = 4191
+MD5 (postgresql/pg-806-icu-34-2006-01-09.diff.gz) = b5d127a071c7165395ed042512d09159
+SHA256 (postgresql/pg-806-icu-34-2006-01-09.diff.gz) = 7faabd28b0c82ba78daa089092618c51d86157ea1eb4b7ca7bc6c002c8c0733a
+SIZE (postgresql/pg-806-icu-34-2006-01-09.diff.gz) = 4372
diff --git a/databases/postgresql80-server/pkg-plist-client b/databases/postgresql80-server/pkg-plist-client
index 5810e57ecead..3d4497fcdbd7 100644
--- a/databases/postgresql80-server/pkg-plist-client
+++ b/databases/postgresql80-server/pkg-plist-client
@@ -420,12 +420,15 @@ lib/libpq.so.4
 lib/libpgtypes.a
 lib/libpgtypes.so
 lib/libpgtypes.so.2
+lib/postgresql/pgxs/config/install-sh
+lib/postgresql/pgxs/config/mkinstalldirs
 lib/postgresql/pgxs/src/makefiles/pgxs.mk
-@dirrm lib/postgresql/pgxs/src/makefiles
 lib/postgresql/pgxs/src/Makefile.global
 lib/postgresql/pgxs/src/Makefile.port
 lib/postgresql/pgxs/src/Makefile.shlib
 lib/postgresql/pgxs/src/nls-global.mk
+@dirrm lib/postgresql/pgxs/src/makefiles
+@dirrm lib/postgresql/pgxs/config
 @dirrm lib/postgresql/pgxs/src
 @dirrm lib/postgresql/pgxs
 @dirrm lib/postgresql
diff --git a/databases/postgresql81-client/Makefile b/databases/postgresql81-client/Makefile
index 72c9b9793ea0..9299683e5a89 100644
--- a/databases/postgresql81-client/Makefile
+++ b/databases/postgresql81-client/Makefile
@@ -9,7 +9,7 @@
 
 PORTNAME=	postgresql
 PKGNAMESUFFIX=	-client
-PORTREVISION=	1
+PORTREVISION=	0
 
 COMMENT=	PostgreSQL database (client)
 
diff --git a/databases/postgresql81-server/Makefile b/databases/postgresql81-server/Makefile
index 6a99def196cf..cce1f22e4950 100644
--- a/databases/postgresql81-server/Makefile
+++ b/databases/postgresql81-server/Makefile
@@ -7,8 +7,8 @@
 
 PORTNAME?=	postgresql
 PKGNAMESUFFIX?=	-server
-PORTVERSION?=	8.1.1
-PORTREVISION?=	1
+PORTVERSION?=	8.1.2
+PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${PORTVERSION}
@@ -112,7 +112,7 @@ USE_AUTOTOOLS=	autoconf:259
 CONFIGURE_ARGS+=--with-icu
 LIB_DEPENDS=	icudata.34:${PORTSDIR}/devel/icu
 PATCH_SITES+=	http://people.freebsd.org/~girgen/postgresql-icu/:icu
-PATCHFILES+=	pg-810-icu-34-2005-11-09.diff.gz:icu
+PATCHFILES+=	pg-812-icu-34-2006-01-09.diff.gz:icu
 .  endif
 
 PATCH_DIST_STRIP=-p1
diff --git a/databases/postgresql81-server/distinfo b/databases/postgresql81-server/distinfo
index cfd41bf40fa2..396d7dbaa117 100644
--- a/databases/postgresql81-server/distinfo
+++ b/databases/postgresql81-server/distinfo
@@ -1,15 +1,15 @@
-MD5 (postgresql/postgresql-base-8.1.1.tar.bz2) = 24326d48b90c5081af000a70268d821c
-SHA256 (postgresql/postgresql-base-8.1.1.tar.bz2) = feca7776e9fccd46913263f1e52faece0338329db7d6acfe2c22b6cef7d7056a
-SIZE (postgresql/postgresql-base-8.1.1.tar.bz2) = 8046645
-MD5 (postgresql/postgresql-docs-8.1.1.tar.bz2) = 1289ffb5fbb507804ffa9f988bb238f3
-SHA256 (postgresql/postgresql-docs-8.1.1.tar.bz2) = 79f4597d80f5b657d134c0455e2efe4109c7594eaf7861abd00a16997000563c
-SIZE (postgresql/postgresql-docs-8.1.1.tar.bz2) = 2453417
-MD5 (postgresql/postgresql-opt-8.1.1.tar.bz2) = 743993bd0d19a781358c99a9abfaed6a
-SHA256 (postgresql/postgresql-opt-8.1.1.tar.bz2) = 68a75fd221a15abb0d28a69a947cb706961dc32134594162184d97902934030f
-SIZE (postgresql/postgresql-opt-8.1.1.tar.bz2) =  143567
-MD5 (postgresql/postgresql-test-8.1.1.tar.bz2) = b7d7bb5847f5bcbee908f2e3ec4d4ce6
-SHA256 (postgresql/postgresql-test-8.1.1.tar.bz2) = 8a1990021d01c97d3e9d9c1c570ef253123803501f503003a628ed0cd1829d4e
-SIZE (postgresql/postgresql-test-8.1.1.tar.bz2) =  969495
-MD5 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = b1f6f40f6fcc887f35d57bb7aee2ed09
-SHA256 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 714d030be73d3df1fd5f47409e0b059ef1d04ad9cb56255b5d803f25b8c93f1a
-SIZE (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 3956
+MD5 (postgresql/postgresql-base-8.1.2.tar.bz2) = 20fa7e49ea3a7f8f4948c6132bbebd9c
+SHA256 (postgresql/postgresql-base-8.1.2.tar.bz2) = f21ae59a5aa4fe19379a669bafac3604e00d107e6c2ce71e05ff9f8780dfd8f1
+SIZE (postgresql/postgresql-base-8.1.2.tar.bz2 = 8042367
+MD5 (postgresql/postgresql-docs-8.1.2.tar.bz2) = ed4048c4b740d2d5f590aef12b9b5a0c
+SHA256 (postgresql/postgresql-docs-8.1.2.tar.bz2) = cd792cb42ff6e5c7271c3e1a263bb74f7097b1faebf39a9d7fde6a4cc69de1c7
+SIZE (postgresql/postgresql-docs-8.1.2.tar.bz2 = 2460342
+MD5 (postgresql/postgresql-opt-8.1.2.tar.bz2) = 50108c8e6c0327f00414913faaadae3c
+SHA256 (postgresql/postgresql-opt-8.1.2.tar.bz2) = e2494279a0ae40b55eb55c87b7f4313084ddbb27b09f305941b035e32926f0f3
+SIZE (postgresql/postgresql-opt-8.1.2.tar.bz2 = 143541
+MD5 (postgresql/postgresql-test-8.1.2.tar.bz2) = 726c521d60b61e1f43f8cd1bf15deed5
+SHA256 (postgresql/postgresql-test-8.1.2.tar.bz2) = 8c4e49ef8d544bff43ada08c5dcf2f749a335ec6042ac348f6dd91e9e91dbd16
+SIZE (postgresql/postgresql-test-8.1.2.tar.bz2 = 969615
+MD5 (postgresql/pg-812-icu-34-2006-01-09.diff.gz) = 2f93587700b3a3d2606076c014d82012
+SHA256 (postgresql/pg-812-icu-34-2006-01-09.diff.gz) = 6270681788e3191aa043e4bda164927c3fdd3a817a5f81aa0f9e8be528ddd349
+SIZE (postgresql/pg-812-icu-34-2006-01-09.diff.gz) = 4003
diff --git a/databases/postgresql82-server/Makefile b/databases/postgresql82-server/Makefile
index 6a99def196cf..cce1f22e4950 100644
--- a/databases/postgresql82-server/Makefile
+++ b/databases/postgresql82-server/Makefile
@@ -7,8 +7,8 @@
 
 PORTNAME?=	postgresql
 PKGNAMESUFFIX?=	-server
-PORTVERSION?=	8.1.1
-PORTREVISION?=	1
+PORTVERSION?=	8.1.2
+PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${PORTVERSION}
@@ -112,7 +112,7 @@ USE_AUTOTOOLS=	autoconf:259
 CONFIGURE_ARGS+=--with-icu
 LIB_DEPENDS=	icudata.34:${PORTSDIR}/devel/icu
 PATCH_SITES+=	http://people.freebsd.org/~girgen/postgresql-icu/:icu
-PATCHFILES+=	pg-810-icu-34-2005-11-09.diff.gz:icu
+PATCHFILES+=	pg-812-icu-34-2006-01-09.diff.gz:icu
 .  endif
 
 PATCH_DIST_STRIP=-p1
diff --git a/databases/postgresql82-server/distinfo b/databases/postgresql82-server/distinfo
index cfd41bf40fa2..396d7dbaa117 100644
--- a/databases/postgresql82-server/distinfo
+++ b/databases/postgresql82-server/distinfo
@@ -1,15 +1,15 @@
-MD5 (postgresql/postgresql-base-8.1.1.tar.bz2) = 24326d48b90c5081af000a70268d821c
-SHA256 (postgresql/postgresql-base-8.1.1.tar.bz2) = feca7776e9fccd46913263f1e52faece0338329db7d6acfe2c22b6cef7d7056a
-SIZE (postgresql/postgresql-base-8.1.1.tar.bz2) = 8046645
-MD5 (postgresql/postgresql-docs-8.1.1.tar.bz2) = 1289ffb5fbb507804ffa9f988bb238f3
-SHA256 (postgresql/postgresql-docs-8.1.1.tar.bz2) = 79f4597d80f5b657d134c0455e2efe4109c7594eaf7861abd00a16997000563c
-SIZE (postgresql/postgresql-docs-8.1.1.tar.bz2) = 2453417
-MD5 (postgresql/postgresql-opt-8.1.1.tar.bz2) = 743993bd0d19a781358c99a9abfaed6a
-SHA256 (postgresql/postgresql-opt-8.1.1.tar.bz2) = 68a75fd221a15abb0d28a69a947cb706961dc32134594162184d97902934030f
-SIZE (postgresql/postgresql-opt-8.1.1.tar.bz2) =  143567
-MD5 (postgresql/postgresql-test-8.1.1.tar.bz2) = b7d7bb5847f5bcbee908f2e3ec4d4ce6
-SHA256 (postgresql/postgresql-test-8.1.1.tar.bz2) = 8a1990021d01c97d3e9d9c1c570ef253123803501f503003a628ed0cd1829d4e
-SIZE (postgresql/postgresql-test-8.1.1.tar.bz2) =  969495
-MD5 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = b1f6f40f6fcc887f35d57bb7aee2ed09
-SHA256 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 714d030be73d3df1fd5f47409e0b059ef1d04ad9cb56255b5d803f25b8c93f1a
-SIZE (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 3956
+MD5 (postgresql/postgresql-base-8.1.2.tar.bz2) = 20fa7e49ea3a7f8f4948c6132bbebd9c
+SHA256 (postgresql/postgresql-base-8.1.2.tar.bz2) = f21ae59a5aa4fe19379a669bafac3604e00d107e6c2ce71e05ff9f8780dfd8f1
+SIZE (postgresql/postgresql-base-8.1.2.tar.bz2 = 8042367
+MD5 (postgresql/postgresql-docs-8.1.2.tar.bz2) = ed4048c4b740d2d5f590aef12b9b5a0c
+SHA256 (postgresql/postgresql-docs-8.1.2.tar.bz2) = cd792cb42ff6e5c7271c3e1a263bb74f7097b1faebf39a9d7fde6a4cc69de1c7
+SIZE (postgresql/postgresql-docs-8.1.2.tar.bz2 = 2460342
+MD5 (postgresql/postgresql-opt-8.1.2.tar.bz2) = 50108c8e6c0327f00414913faaadae3c
+SHA256 (postgresql/postgresql-opt-8.1.2.tar.bz2) = e2494279a0ae40b55eb55c87b7f4313084ddbb27b09f305941b035e32926f0f3
+SIZE (postgresql/postgresql-opt-8.1.2.tar.bz2 = 143541
+MD5 (postgresql/postgresql-test-8.1.2.tar.bz2) = 726c521d60b61e1f43f8cd1bf15deed5
+SHA256 (postgresql/postgresql-test-8.1.2.tar.bz2) = 8c4e49ef8d544bff43ada08c5dcf2f749a335ec6042ac348f6dd91e9e91dbd16
+SIZE (postgresql/postgresql-test-8.1.2.tar.bz2 = 969615
+MD5 (postgresql/pg-812-icu-34-2006-01-09.diff.gz) = 2f93587700b3a3d2606076c014d82012
+SHA256 (postgresql/pg-812-icu-34-2006-01-09.diff.gz) = 6270681788e3191aa043e4bda164927c3fdd3a817a5f81aa0f9e8be528ddd349
+SIZE (postgresql/pg-812-icu-34-2006-01-09.diff.gz) = 4003
diff --git a/databases/postgresql83-server/Makefile b/databases/postgresql83-server/Makefile
index 6a99def196cf..cce1f22e4950 100644
--- a/databases/postgresql83-server/Makefile
+++ b/databases/postgresql83-server/Makefile
@@ -7,8 +7,8 @@
 
 PORTNAME?=	postgresql
 PKGNAMESUFFIX?=	-server
-PORTVERSION?=	8.1.1
-PORTREVISION?=	1
+PORTVERSION?=	8.1.2
+PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${PORTVERSION}
@@ -112,7 +112,7 @@ USE_AUTOTOOLS=	autoconf:259
 CONFIGURE_ARGS+=--with-icu
 LIB_DEPENDS=	icudata.34:${PORTSDIR}/devel/icu
 PATCH_SITES+=	http://people.freebsd.org/~girgen/postgresql-icu/:icu
-PATCHFILES+=	pg-810-icu-34-2005-11-09.diff.gz:icu
+PATCHFILES+=	pg-812-icu-34-2006-01-09.diff.gz:icu
 .  endif
 
 PATCH_DIST_STRIP=-p1
diff --git a/databases/postgresql83-server/distinfo b/databases/postgresql83-server/distinfo
index cfd41bf40fa2..396d7dbaa117 100644
--- a/databases/postgresql83-server/distinfo
+++ b/databases/postgresql83-server/distinfo
@@ -1,15 +1,15 @@
-MD5 (postgresql/postgresql-base-8.1.1.tar.bz2) = 24326d48b90c5081af000a70268d821c
-SHA256 (postgresql/postgresql-base-8.1.1.tar.bz2) = feca7776e9fccd46913263f1e52faece0338329db7d6acfe2c22b6cef7d7056a
-SIZE (postgresql/postgresql-base-8.1.1.tar.bz2) = 8046645
-MD5 (postgresql/postgresql-docs-8.1.1.tar.bz2) = 1289ffb5fbb507804ffa9f988bb238f3
-SHA256 (postgresql/postgresql-docs-8.1.1.tar.bz2) = 79f4597d80f5b657d134c0455e2efe4109c7594eaf7861abd00a16997000563c
-SIZE (postgresql/postgresql-docs-8.1.1.tar.bz2) = 2453417
-MD5 (postgresql/postgresql-opt-8.1.1.tar.bz2) = 743993bd0d19a781358c99a9abfaed6a
-SHA256 (postgresql/postgresql-opt-8.1.1.tar.bz2) = 68a75fd221a15abb0d28a69a947cb706961dc32134594162184d97902934030f
-SIZE (postgresql/postgresql-opt-8.1.1.tar.bz2) =  143567
-MD5 (postgresql/postgresql-test-8.1.1.tar.bz2) = b7d7bb5847f5bcbee908f2e3ec4d4ce6
-SHA256 (postgresql/postgresql-test-8.1.1.tar.bz2) = 8a1990021d01c97d3e9d9c1c570ef253123803501f503003a628ed0cd1829d4e
-SIZE (postgresql/postgresql-test-8.1.1.tar.bz2) =  969495
-MD5 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = b1f6f40f6fcc887f35d57bb7aee2ed09
-SHA256 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 714d030be73d3df1fd5f47409e0b059ef1d04ad9cb56255b5d803f25b8c93f1a
-SIZE (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 3956
+MD5 (postgresql/postgresql-base-8.1.2.tar.bz2) = 20fa7e49ea3a7f8f4948c6132bbebd9c
+SHA256 (postgresql/postgresql-base-8.1.2.tar.bz2) = f21ae59a5aa4fe19379a669bafac3604e00d107e6c2ce71e05ff9f8780dfd8f1
+SIZE (postgresql/postgresql-base-8.1.2.tar.bz2 = 8042367
+MD5 (postgresql/postgresql-docs-8.1.2.tar.bz2) = ed4048c4b740d2d5f590aef12b9b5a0c
+SHA256 (postgresql/postgresql-docs-8.1.2.tar.bz2) = cd792cb42ff6e5c7271c3e1a263bb74f7097b1faebf39a9d7fde6a4cc69de1c7
+SIZE (postgresql/postgresql-docs-8.1.2.tar.bz2 = 2460342
+MD5 (postgresql/postgresql-opt-8.1.2.tar.bz2) = 50108c8e6c0327f00414913faaadae3c
+SHA256 (postgresql/postgresql-opt-8.1.2.tar.bz2) = e2494279a0ae40b55eb55c87b7f4313084ddbb27b09f305941b035e32926f0f3
+SIZE (postgresql/postgresql-opt-8.1.2.tar.bz2 = 143541
+MD5 (postgresql/postgresql-test-8.1.2.tar.bz2) = 726c521d60b61e1f43f8cd1bf15deed5
+SHA256 (postgresql/postgresql-test-8.1.2.tar.bz2) = 8c4e49ef8d544bff43ada08c5dcf2f749a335ec6042ac348f6dd91e9e91dbd16
+SIZE (postgresql/postgresql-test-8.1.2.tar.bz2 = 969615
+MD5 (postgresql/pg-812-icu-34-2006-01-09.diff.gz) = 2f93587700b3a3d2606076c014d82012
+SHA256 (postgresql/pg-812-icu-34-2006-01-09.diff.gz) = 6270681788e3191aa043e4bda164927c3fdd3a817a5f81aa0f9e8be528ddd349
+SIZE (postgresql/pg-812-icu-34-2006-01-09.diff.gz) = 4003
diff --git a/databases/postgresql84-server/Makefile b/databases/postgresql84-server/Makefile
index 6a99def196cf..cce1f22e4950 100644
--- a/databases/postgresql84-server/Makefile
+++ b/databases/postgresql84-server/Makefile
@@ -7,8 +7,8 @@
 
 PORTNAME?=	postgresql
 PKGNAMESUFFIX?=	-server
-PORTVERSION?=	8.1.1
-PORTREVISION?=	1
+PORTVERSION?=	8.1.2
+PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${PORTVERSION}
@@ -112,7 +112,7 @@ USE_AUTOTOOLS=	autoconf:259
 CONFIGURE_ARGS+=--with-icu
 LIB_DEPENDS=	icudata.34:${PORTSDIR}/devel/icu
 PATCH_SITES+=	http://people.freebsd.org/~girgen/postgresql-icu/:icu
-PATCHFILES+=	pg-810-icu-34-2005-11-09.diff.gz:icu
+PATCHFILES+=	pg-812-icu-34-2006-01-09.diff.gz:icu
 .  endif
 
 PATCH_DIST_STRIP=-p1
diff --git a/databases/postgresql84-server/distinfo b/databases/postgresql84-server/distinfo
index cfd41bf40fa2..396d7dbaa117 100644
--- a/databases/postgresql84-server/distinfo
+++ b/databases/postgresql84-server/distinfo
@@ -1,15 +1,15 @@
-MD5 (postgresql/postgresql-base-8.1.1.tar.bz2) = 24326d48b90c5081af000a70268d821c
-SHA256 (postgresql/postgresql-base-8.1.1.tar.bz2) = feca7776e9fccd46913263f1e52faece0338329db7d6acfe2c22b6cef7d7056a
-SIZE (postgresql/postgresql-base-8.1.1.tar.bz2) = 8046645
-MD5 (postgresql/postgresql-docs-8.1.1.tar.bz2) = 1289ffb5fbb507804ffa9f988bb238f3
-SHA256 (postgresql/postgresql-docs-8.1.1.tar.bz2) = 79f4597d80f5b657d134c0455e2efe4109c7594eaf7861abd00a16997000563c
-SIZE (postgresql/postgresql-docs-8.1.1.tar.bz2) = 2453417
-MD5 (postgresql/postgresql-opt-8.1.1.tar.bz2) = 743993bd0d19a781358c99a9abfaed6a
-SHA256 (postgresql/postgresql-opt-8.1.1.tar.bz2) = 68a75fd221a15abb0d28a69a947cb706961dc32134594162184d97902934030f
-SIZE (postgresql/postgresql-opt-8.1.1.tar.bz2) =  143567
-MD5 (postgresql/postgresql-test-8.1.1.tar.bz2) = b7d7bb5847f5bcbee908f2e3ec4d4ce6
-SHA256 (postgresql/postgresql-test-8.1.1.tar.bz2) = 8a1990021d01c97d3e9d9c1c570ef253123803501f503003a628ed0cd1829d4e
-SIZE (postgresql/postgresql-test-8.1.1.tar.bz2) =  969495
-MD5 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = b1f6f40f6fcc887f35d57bb7aee2ed09
-SHA256 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 714d030be73d3df1fd5f47409e0b059ef1d04ad9cb56255b5d803f25b8c93f1a
-SIZE (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 3956
+MD5 (postgresql/postgresql-base-8.1.2.tar.bz2) = 20fa7e49ea3a7f8f4948c6132bbebd9c
+SHA256 (postgresql/postgresql-base-8.1.2.tar.bz2) = f21ae59a5aa4fe19379a669bafac3604e00d107e6c2ce71e05ff9f8780dfd8f1
+SIZE (postgresql/postgresql-base-8.1.2.tar.bz2 = 8042367
+MD5 (postgresql/postgresql-docs-8.1.2.tar.bz2) = ed4048c4b740d2d5f590aef12b9b5a0c
+SHA256 (postgresql/postgresql-docs-8.1.2.tar.bz2) = cd792cb42ff6e5c7271c3e1a263bb74f7097b1faebf39a9d7fde6a4cc69de1c7
+SIZE (postgresql/postgresql-docs-8.1.2.tar.bz2 = 2460342
+MD5 (postgresql/postgresql-opt-8.1.2.tar.bz2) = 50108c8e6c0327f00414913faaadae3c
+SHA256 (postgresql/postgresql-opt-8.1.2.tar.bz2) = e2494279a0ae40b55eb55c87b7f4313084ddbb27b09f305941b035e32926f0f3
+SIZE (postgresql/postgresql-opt-8.1.2.tar.bz2 = 143541
+MD5 (postgresql/postgresql-test-8.1.2.tar.bz2) = 726c521d60b61e1f43f8cd1bf15deed5
+SHA256 (postgresql/postgresql-test-8.1.2.tar.bz2) = 8c4e49ef8d544bff43ada08c5dcf2f749a335ec6042ac348f6dd91e9e91dbd16
+SIZE (postgresql/postgresql-test-8.1.2.tar.bz2 = 969615
+MD5 (postgresql/pg-812-icu-34-2006-01-09.diff.gz) = 2f93587700b3a3d2606076c014d82012
+SHA256 (postgresql/pg-812-icu-34-2006-01-09.diff.gz) = 6270681788e3191aa043e4bda164927c3fdd3a817a5f81aa0f9e8be528ddd349
+SIZE (postgresql/pg-812-icu-34-2006-01-09.diff.gz) = 4003
diff --git a/databases/postgresql90-server/Makefile b/databases/postgresql90-server/Makefile
index 6a99def196cf..cce1f22e4950 100644
--- a/databases/postgresql90-server/Makefile
+++ b/databases/postgresql90-server/Makefile
@@ -7,8 +7,8 @@
 
 PORTNAME?=	postgresql
 PKGNAMESUFFIX?=	-server
-PORTVERSION?=	8.1.1
-PORTREVISION?=	1
+PORTVERSION?=	8.1.2
+PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${PORTVERSION}
@@ -112,7 +112,7 @@ USE_AUTOTOOLS=	autoconf:259
 CONFIGURE_ARGS+=--with-icu
 LIB_DEPENDS=	icudata.34:${PORTSDIR}/devel/icu
 PATCH_SITES+=	http://people.freebsd.org/~girgen/postgresql-icu/:icu
-PATCHFILES+=	pg-810-icu-34-2005-11-09.diff.gz:icu
+PATCHFILES+=	pg-812-icu-34-2006-01-09.diff.gz:icu
 .  endif
 
 PATCH_DIST_STRIP=-p1
diff --git a/databases/postgresql90-server/distinfo b/databases/postgresql90-server/distinfo
index cfd41bf40fa2..396d7dbaa117 100644
--- a/databases/postgresql90-server/distinfo
+++ b/databases/postgresql90-server/distinfo
@@ -1,15 +1,15 @@
-MD5 (postgresql/postgresql-base-8.1.1.tar.bz2) = 24326d48b90c5081af000a70268d821c
-SHA256 (postgresql/postgresql-base-8.1.1.tar.bz2) = feca7776e9fccd46913263f1e52faece0338329db7d6acfe2c22b6cef7d7056a
-SIZE (postgresql/postgresql-base-8.1.1.tar.bz2) = 8046645
-MD5 (postgresql/postgresql-docs-8.1.1.tar.bz2) = 1289ffb5fbb507804ffa9f988bb238f3
-SHA256 (postgresql/postgresql-docs-8.1.1.tar.bz2) = 79f4597d80f5b657d134c0455e2efe4109c7594eaf7861abd00a16997000563c
-SIZE (postgresql/postgresql-docs-8.1.1.tar.bz2) = 2453417
-MD5 (postgresql/postgresql-opt-8.1.1.tar.bz2) = 743993bd0d19a781358c99a9abfaed6a
-SHA256 (postgresql/postgresql-opt-8.1.1.tar.bz2) = 68a75fd221a15abb0d28a69a947cb706961dc32134594162184d97902934030f
-SIZE (postgresql/postgresql-opt-8.1.1.tar.bz2) =  143567
-MD5 (postgresql/postgresql-test-8.1.1.tar.bz2) = b7d7bb5847f5bcbee908f2e3ec4d4ce6
-SHA256 (postgresql/postgresql-test-8.1.1.tar.bz2) = 8a1990021d01c97d3e9d9c1c570ef253123803501f503003a628ed0cd1829d4e
-SIZE (postgresql/postgresql-test-8.1.1.tar.bz2) =  969495
-MD5 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = b1f6f40f6fcc887f35d57bb7aee2ed09
-SHA256 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 714d030be73d3df1fd5f47409e0b059ef1d04ad9cb56255b5d803f25b8c93f1a
-SIZE (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 3956
+MD5 (postgresql/postgresql-base-8.1.2.tar.bz2) = 20fa7e49ea3a7f8f4948c6132bbebd9c
+SHA256 (postgresql/postgresql-base-8.1.2.tar.bz2) = f21ae59a5aa4fe19379a669bafac3604e00d107e6c2ce71e05ff9f8780dfd8f1
+SIZE (postgresql/postgresql-base-8.1.2.tar.bz2 = 8042367
+MD5 (postgresql/postgresql-docs-8.1.2.tar.bz2) = ed4048c4b740d2d5f590aef12b9b5a0c
+SHA256 (postgresql/postgresql-docs-8.1.2.tar.bz2) = cd792cb42ff6e5c7271c3e1a263bb74f7097b1faebf39a9d7fde6a4cc69de1c7
+SIZE (postgresql/postgresql-docs-8.1.2.tar.bz2 = 2460342
+MD5 (postgresql/postgresql-opt-8.1.2.tar.bz2) = 50108c8e6c0327f00414913faaadae3c
+SHA256 (postgresql/postgresql-opt-8.1.2.tar.bz2) = e2494279a0ae40b55eb55c87b7f4313084ddbb27b09f305941b035e32926f0f3
+SIZE (postgresql/postgresql-opt-8.1.2.tar.bz2 = 143541
+MD5 (postgresql/postgresql-test-8.1.2.tar.bz2) = 726c521d60b61e1f43f8cd1bf15deed5
+SHA256 (postgresql/postgresql-test-8.1.2.tar.bz2) = 8c4e49ef8d544bff43ada08c5dcf2f749a335ec6042ac348f6dd91e9e91dbd16
+SIZE (postgresql/postgresql-test-8.1.2.tar.bz2 = 969615
+MD5 (postgresql/pg-812-icu-34-2006-01-09.diff.gz) = 2f93587700b3a3d2606076c014d82012
+SHA256 (postgresql/pg-812-icu-34-2006-01-09.diff.gz) = 6270681788e3191aa043e4bda164927c3fdd3a817a5f81aa0f9e8be528ddd349
+SIZE (postgresql/pg-812-icu-34-2006-01-09.diff.gz) = 4003
diff --git a/databases/postgresql91-server/Makefile b/databases/postgresql91-server/Makefile
index 6a99def196cf..cce1f22e4950 100644
--- a/databases/postgresql91-server/Makefile
+++ b/databases/postgresql91-server/Makefile
@@ -7,8 +7,8 @@
 
 PORTNAME?=	postgresql
 PKGNAMESUFFIX?=	-server
-PORTVERSION?=	8.1.1
-PORTREVISION?=	1
+PORTVERSION?=	8.1.2
+PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${PORTVERSION}
@@ -112,7 +112,7 @@ USE_AUTOTOOLS=	autoconf:259
 CONFIGURE_ARGS+=--with-icu
 LIB_DEPENDS=	icudata.34:${PORTSDIR}/devel/icu
 PATCH_SITES+=	http://people.freebsd.org/~girgen/postgresql-icu/:icu
-PATCHFILES+=	pg-810-icu-34-2005-11-09.diff.gz:icu
+PATCHFILES+=	pg-812-icu-34-2006-01-09.diff.gz:icu
 .  endif
 
 PATCH_DIST_STRIP=-p1
diff --git a/databases/postgresql91-server/distinfo b/databases/postgresql91-server/distinfo
index cfd41bf40fa2..396d7dbaa117 100644
--- a/databases/postgresql91-server/distinfo
+++ b/databases/postgresql91-server/distinfo
@@ -1,15 +1,15 @@
-MD5 (postgresql/postgresql-base-8.1.1.tar.bz2) = 24326d48b90c5081af000a70268d821c
-SHA256 (postgresql/postgresql-base-8.1.1.tar.bz2) = feca7776e9fccd46913263f1e52faece0338329db7d6acfe2c22b6cef7d7056a
-SIZE (postgresql/postgresql-base-8.1.1.tar.bz2) = 8046645
-MD5 (postgresql/postgresql-docs-8.1.1.tar.bz2) = 1289ffb5fbb507804ffa9f988bb238f3
-SHA256 (postgresql/postgresql-docs-8.1.1.tar.bz2) = 79f4597d80f5b657d134c0455e2efe4109c7594eaf7861abd00a16997000563c
-SIZE (postgresql/postgresql-docs-8.1.1.tar.bz2) = 2453417
-MD5 (postgresql/postgresql-opt-8.1.1.tar.bz2) = 743993bd0d19a781358c99a9abfaed6a
-SHA256 (postgresql/postgresql-opt-8.1.1.tar.bz2) = 68a75fd221a15abb0d28a69a947cb706961dc32134594162184d97902934030f
-SIZE (postgresql/postgresql-opt-8.1.1.tar.bz2) =  143567
-MD5 (postgresql/postgresql-test-8.1.1.tar.bz2) = b7d7bb5847f5bcbee908f2e3ec4d4ce6
-SHA256 (postgresql/postgresql-test-8.1.1.tar.bz2) = 8a1990021d01c97d3e9d9c1c570ef253123803501f503003a628ed0cd1829d4e
-SIZE (postgresql/postgresql-test-8.1.1.tar.bz2) =  969495
-MD5 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = b1f6f40f6fcc887f35d57bb7aee2ed09
-SHA256 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 714d030be73d3df1fd5f47409e0b059ef1d04ad9cb56255b5d803f25b8c93f1a
-SIZE (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 3956
+MD5 (postgresql/postgresql-base-8.1.2.tar.bz2) = 20fa7e49ea3a7f8f4948c6132bbebd9c
+SHA256 (postgresql/postgresql-base-8.1.2.tar.bz2) = f21ae59a5aa4fe19379a669bafac3604e00d107e6c2ce71e05ff9f8780dfd8f1
+SIZE (postgresql/postgresql-base-8.1.2.tar.bz2 = 8042367
+MD5 (postgresql/postgresql-docs-8.1.2.tar.bz2) = ed4048c4b740d2d5f590aef12b9b5a0c
+SHA256 (postgresql/postgresql-docs-8.1.2.tar.bz2) = cd792cb42ff6e5c7271c3e1a263bb74f7097b1faebf39a9d7fde6a4cc69de1c7
+SIZE (postgresql/postgresql-docs-8.1.2.tar.bz2 = 2460342
+MD5 (postgresql/postgresql-opt-8.1.2.tar.bz2) = 50108c8e6c0327f00414913faaadae3c
+SHA256 (postgresql/postgresql-opt-8.1.2.tar.bz2) = e2494279a0ae40b55eb55c87b7f4313084ddbb27b09f305941b035e32926f0f3
+SIZE (postgresql/postgresql-opt-8.1.2.tar.bz2 = 143541
+MD5 (postgresql/postgresql-test-8.1.2.tar.bz2) = 726c521d60b61e1f43f8cd1bf15deed5
+SHA256 (postgresql/postgresql-test-8.1.2.tar.bz2) = 8c4e49ef8d544bff43ada08c5dcf2f749a335ec6042ac348f6dd91e9e91dbd16
+SIZE (postgresql/postgresql-test-8.1.2.tar.bz2 = 969615
+MD5 (postgresql/pg-812-icu-34-2006-01-09.diff.gz) = 2f93587700b3a3d2606076c014d82012
+SHA256 (postgresql/pg-812-icu-34-2006-01-09.diff.gz) = 6270681788e3191aa043e4bda164927c3fdd3a817a5f81aa0f9e8be528ddd349
+SIZE (postgresql/pg-812-icu-34-2006-01-09.diff.gz) = 4003
diff --git a/databases/postgresql92-server/Makefile b/databases/postgresql92-server/Makefile
index 6a99def196cf..cce1f22e4950 100644
--- a/databases/postgresql92-server/Makefile
+++ b/databases/postgresql92-server/Makefile
@@ -7,8 +7,8 @@
 
 PORTNAME?=	postgresql
 PKGNAMESUFFIX?=	-server
-PORTVERSION?=	8.1.1
-PORTREVISION?=	1
+PORTVERSION?=	8.1.2
+PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${PORTVERSION}
@@ -112,7 +112,7 @@ USE_AUTOTOOLS=	autoconf:259
 CONFIGURE_ARGS+=--with-icu
 LIB_DEPENDS=	icudata.34:${PORTSDIR}/devel/icu
 PATCH_SITES+=	http://people.freebsd.org/~girgen/postgresql-icu/:icu
-PATCHFILES+=	pg-810-icu-34-2005-11-09.diff.gz:icu
+PATCHFILES+=	pg-812-icu-34-2006-01-09.diff.gz:icu
 .  endif
 
 PATCH_DIST_STRIP=-p1
diff --git a/databases/postgresql92-server/distinfo b/databases/postgresql92-server/distinfo
index cfd41bf40fa2..396d7dbaa117 100644
--- a/databases/postgresql92-server/distinfo
+++ b/databases/postgresql92-server/distinfo
@@ -1,15 +1,15 @@
-MD5 (postgresql/postgresql-base-8.1.1.tar.bz2) = 24326d48b90c5081af000a70268d821c
-SHA256 (postgresql/postgresql-base-8.1.1.tar.bz2) = feca7776e9fccd46913263f1e52faece0338329db7d6acfe2c22b6cef7d7056a
-SIZE (postgresql/postgresql-base-8.1.1.tar.bz2) = 8046645
-MD5 (postgresql/postgresql-docs-8.1.1.tar.bz2) = 1289ffb5fbb507804ffa9f988bb238f3
-SHA256 (postgresql/postgresql-docs-8.1.1.tar.bz2) = 79f4597d80f5b657d134c0455e2efe4109c7594eaf7861abd00a16997000563c
-SIZE (postgresql/postgresql-docs-8.1.1.tar.bz2) = 2453417
-MD5 (postgresql/postgresql-opt-8.1.1.tar.bz2) = 743993bd0d19a781358c99a9abfaed6a
-SHA256 (postgresql/postgresql-opt-8.1.1.tar.bz2) = 68a75fd221a15abb0d28a69a947cb706961dc32134594162184d97902934030f
-SIZE (postgresql/postgresql-opt-8.1.1.tar.bz2) =  143567
-MD5 (postgresql/postgresql-test-8.1.1.tar.bz2) = b7d7bb5847f5bcbee908f2e3ec4d4ce6
-SHA256 (postgresql/postgresql-test-8.1.1.tar.bz2) = 8a1990021d01c97d3e9d9c1c570ef253123803501f503003a628ed0cd1829d4e
-SIZE (postgresql/postgresql-test-8.1.1.tar.bz2) =  969495
-MD5 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = b1f6f40f6fcc887f35d57bb7aee2ed09
-SHA256 (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 714d030be73d3df1fd5f47409e0b059ef1d04ad9cb56255b5d803f25b8c93f1a
-SIZE (postgresql/pg-810-icu-34-2005-11-09.diff.gz) = 3956
+MD5 (postgresql/postgresql-base-8.1.2.tar.bz2) = 20fa7e49ea3a7f8f4948c6132bbebd9c
+SHA256 (postgresql/postgresql-base-8.1.2.tar.bz2) = f21ae59a5aa4fe19379a669bafac3604e00d107e6c2ce71e05ff9f8780dfd8f1
+SIZE (postgresql/postgresql-base-8.1.2.tar.bz2 = 8042367
+MD5 (postgresql/postgresql-docs-8.1.2.tar.bz2) = ed4048c4b740d2d5f590aef12b9b5a0c
+SHA256 (postgresql/postgresql-docs-8.1.2.tar.bz2) = cd792cb42ff6e5c7271c3e1a263bb74f7097b1faebf39a9d7fde6a4cc69de1c7
+SIZE (postgresql/postgresql-docs-8.1.2.tar.bz2 = 2460342
+MD5 (postgresql/postgresql-opt-8.1.2.tar.bz2) = 50108c8e6c0327f00414913faaadae3c
+SHA256 (postgresql/postgresql-opt-8.1.2.tar.bz2) = e2494279a0ae40b55eb55c87b7f4313084ddbb27b09f305941b035e32926f0f3
+SIZE (postgresql/postgresql-opt-8.1.2.tar.bz2 = 143541
+MD5 (postgresql/postgresql-test-8.1.2.tar.bz2) = 726c521d60b61e1f43f8cd1bf15deed5
+SHA256 (postgresql/postgresql-test-8.1.2.tar.bz2) = 8c4e49ef8d544bff43ada08c5dcf2f749a335ec6042ac348f6dd91e9e91dbd16
+SIZE (postgresql/postgresql-test-8.1.2.tar.bz2 = 969615
+MD5 (postgresql/pg-812-icu-34-2006-01-09.diff.gz) = 2f93587700b3a3d2606076c014d82012
+SHA256 (postgresql/pg-812-icu-34-2006-01-09.diff.gz) = 6270681788e3191aa043e4bda164927c3fdd3a817a5f81aa0f9e8be528ddd349
+SIZE (postgresql/pg-812-icu-34-2006-01-09.diff.gz) = 4003