The PostgreSQL Global Development Group today released security updates for all

active branches of the PostgreSQL database system, including versions 9.1.4,
9.0.8, 8.4.12 and 8.3.19.

Users of the crypt(text, text) function with DES encryption in the optional
pg_crypto module should upgrade their installations immediately, if you have'nt
already updated since the port was patched on May 30.  All other database
administrators are urged to upgrade your version of PostgreSQL at the
next scheduled downtime.

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

Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-2143
          Fix incorrect password transformation in contrib/pgcrypto’s DES crypt() function
	  This was fixed in a patch release for the FreeBSD ports on May 30.

Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-2655
          Ignore SECURITY DEFINER and SET attributes for a procedural language’s call handle

4 files changed, 5 insertions, 16 deletions

diff --git a/databases/postgresql90-server/Makefile b/databases/postgresql90-server/Makefile
index 1987b2981c66..0dd6904d9a12 100644
--- a/databases/postgresql90-server/Makefile
+++ b/databases/postgresql90-server/Makefile
@@ -5,8 +5,8 @@
 # $FreeBSD$
 #
 
-DISTVERSION?=	9.0.7
-PORTREVISION=	2
+DISTVERSION?=	9.0.8
+PORTREVISION=	0
 PKGNAMESUFFIX?=	-server
 
 MAINTAINER?=	pgsql@FreeBSD.org
diff --git a/databases/postgresql90-server/distinfo b/databases/postgresql90-server/distinfo
index 28329abf4e2c..9766fc2ac865 100644
--- a/databases/postgresql90-server/distinfo
+++ b/databases/postgresql90-server/distinfo
@@ -1,4 +1,4 @@
-SHA256 (postgresql/postgresql-9.0.7.tar.bz2) = dabe26d71d8b595f9514da1363dc20c3f4b90b6908026dd06984cac448a6d833
-SIZE (postgresql/postgresql-9.0.7.tar.bz2) = 14977437
+SHA256 (postgresql/postgresql-9.0.8.tar.bz2) = a2981ba8a64b396e2111fee5a9216275e49a2e79e839152a5e4367afd44c0bc2
+SIZE (postgresql/postgresql-9.0.8.tar.bz2) = 14998065
 SHA256 (postgresql/pg-900-icu-2010-09-19.diff.gz) = 27cea46241ec814965c278330cd96f67ee03422b7758a210713a63b4b5bb77e9
 SIZE (postgresql/pg-900-icu-2010-09-19.diff.gz) = 4349
diff --git a/databases/postgresql90-server/files/patch-crypt-des.c b/databases/postgresql90-server/files/patch-crypt-des.c
deleted file mode 100644
index ce61aaa5b2b7..000000000000
--- a/databases/postgresql90-server/files/patch-crypt-des.c
+++ /dev/null
@@ -1,12 +0,0 @@
---- ./contrib/pgcrypto/crypt-des.c
-+++ ./contrib/pgcrypto/crypt-des.c
-@@ -670,7 +670,8 @@ px_crypt_des(const char *key, const char *setting)
- 	q = (uint8 *) keybuf;
- 	while (q - (uint8 *) keybuf - 8)
- 	{
--		if ((*q++ = *key << 1))
-+		*q++ = *key << 1;
-+		if (*key != '\0')
- 			key++;
- 	}
- 	if (des_setkey((char *) keybuf))
diff --git a/databases/postgresql90-server/pkg-plist-server b/databases/postgresql90-server/pkg-plist-server
index 3a52069a3a71..35b6b4aa1c15 100644
--- a/databases/postgresql90-server/pkg-plist-server
+++ b/databases/postgresql90-server/pkg-plist-server
@@ -234,6 +234,7 @@ share/postgresql/snowball_create.sql
 %%TZDATA%%share/postgresql/timezone/America/Coral_Harbour
 %%TZDATA%%share/postgresql/timezone/America/Cordoba
 %%TZDATA%%share/postgresql/timezone/America/Costa_Rica
+%%TZDATA%%share/postgresql/timezone/America/Creston
 %%TZDATA%%share/postgresql/timezone/America/Cuiaba
 %%TZDATA%%share/postgresql/timezone/America/Curacao
 %%TZDATA%%share/postgresql/timezone/America/Danmarkshavn