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/postgresql83-server/Makefile b/databases/postgresql83-server/Makefile
index 6a3dca1ccb8a..43812a8120a0 100644
--- a/databases/postgresql83-server/Makefile
+++ b/databases/postgresql83-server/Makefile
@@ -5,8 +5,8 @@
 # $FreeBSD$
 #
 
-DISTVERSION?=	8.3.18
-PORTREVISION?=	1
+DISTVERSION?=	8.3.19
+PORTREVISION?=	0
 PKGNAMESUFFIX?=	-server
 
 MAINTAINER?=	pgsql@FreeBSD.org
diff --git a/databases/postgresql83-server/distinfo b/databases/postgresql83-server/distinfo
index f82e5a987cd3..beae06179ecc 100644
--- a/databases/postgresql83-server/distinfo
+++ b/databases/postgresql83-server/distinfo
@@ -1,4 +1,4 @@
-SHA256 (postgresql/postgresql-8.3.18.tar.bz2) = 5db4904a8959f09274e1e0ee7f21c354128d5dbb4e946b78391f6bc4723c3746
-SIZE (postgresql/postgresql-8.3.18.tar.bz2) = 14563583
+SHA256 (postgresql/postgresql-8.3.19.tar.bz2) = 986f0d4b7edc633be1d210f27dfd1e47d416b642659e568895218466e50b58d5
+SIZE (postgresql/postgresql-8.3.19.tar.bz2) = 14570746
 SHA256 (postgresql/pg-8311-icu-xx-2010-05-14.diff.gz) = 44146bdb29a5a7d51c70911096ed6d265bdf09f74f0084ee7ad1883bea2f852a
 SIZE (postgresql/pg-8311-icu-xx-2010-05-14.diff.gz) = 5064
diff --git a/databases/postgresql83-server/files/patch-crypt-des.c b/databases/postgresql83-server/files/patch-crypt-des.c
deleted file mode 100644
index ce61aaa5b2b7..000000000000
--- a/databases/postgresql83-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/postgresql83-server/pkg-plist-server b/databases/postgresql83-server/pkg-plist-server
index 11ee47d75b74..0d8f54d4c7d1 100644
--- a/databases/postgresql83-server/pkg-plist-server
+++ b/databases/postgresql83-server/pkg-plist-server
@@ -238,6 +238,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