Changes 8.3.9:

* Protect against indirect security threats caused by index functions
  changing session-local state
* Reject SSL certificates containing an embedded null byte in the
  common name (CN) field
* Fix possible crash during backend-startup-time cache initialization
* Avoid crash on empty thesaurus dictionary
* Prevent signals from interrupting VACUUM at unsafe times
* Fix possible crash due to integer overflow in hash table size
  calculation
* Fix very rare crash in inet/cidr comparisons
* Ensure that shared tuple-level locks held by prepared transactions
  are not ignored
* Fix premature drop of temporary files used for a cursor that is
  accessed within a subtransaction
* Fix memory leak in syslogger process when rotating to a new CSV
  logfile
* Fix Windows permission-downgrade logic
* Fix incorrect logic for GiST index page splits, when the split
  depends on a non-first column of the index
* Don't error out if recycling or removing an old WAL file fails at
  the end of checkpoint
* Ensure WAL files aren't repeatedly archived on Windows
* Fix PAM password processing to be more robust
* Raise the maximum authentication token (Kerberos ticket) size in
  GSSAPI and SSPI authentication methods
* More...

6 files changed, 48 insertions, 16 deletions

diff --git a/databases/postgresql83-client/Makefile b/databases/postgresql83-client/Makefile
index c58c8ce7c70..2427e033215 100644
--- a/databases/postgresql83-client/Makefile
+++ b/databases/postgresql83-client/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.9 2009/10/31 14:00:44 tnn Exp $
+# $NetBSD: Makefile,v 1.10 2009/12/16 14:23:13 adam Exp $
 
 PKGNAME=	postgresql83-client-${BASE_VERS}
 COMMENT=	PostgreSQL database client programs
@@ -7,7 +7,6 @@ PKG_DESTDIR_SUPPORT=	user-destdir
 
 .include "../../databases/postgresql83/Makefile.common"
 
-MAKE_JOBS_SAFE=		no
 USE_TOOLS+=		gzip tar
 USE_LIBTOOL=		yes
 CONFIGURE_ARGS+=	--with-openssl
@@ -59,9 +58,27 @@ USE_GNU_READLINE=	yes
 .include "../../devel/zlib/buildlink3.mk"
 .include "../../security/openssl/buildlink3.mk"
 
+SUBST_CLASSES+=		pgxs
+SUBST_STAGE.pgxs=	post-build
+SUBST_MESSAGE.pgxs=	Fixing workdir tools references in pgxs Makefile
+SUBST_FILES.pgxs=	src/Makefile.global
+SUBST_SED.pgxs=		-e 's,${WRKDIR}/.tools,${PREFIX},'
+SUBST_SED.pgxs+=	-e 's,${WRKDIR}/.wrapper,${PREFIX},'
+SUBST_SED.pgxs+=	-e 's,${WRKSRC},/dev/null,'
+
+INSTALLATION_DIRS+=	${PG_SUBPREFIX}lib/postgresql/pgxs
+INSTALLATION_DIRS+=	${PG_SUBPREFIX}lib/postgresql/pgxs/config
+INSTALLATION_DIRS+=	${PG_SUBPREFIX}lib/postgresql/pgxs/src
+INSTALLATION_DIRS+=	${PG_SUBPREFIX}lib/postgresql/pgxs/src/makefiles
+
+DEST_PG_PGXS=	${DESTDIR}${PG_PREFIX}/lib/postgresql/pgxs
+PG_PGXS_FILES=	config/install-sh config/mkinstalldirs
+PG_PGXS_FILES+=	src/makefiles/pgxs.mk src/Makefile.global
+PG_PGXS_FILES+=	src/Makefile.port src/Makefile.shlib
+PG_PGXS_FILES+=	src/nls-global.mk
+
 # On Solaris, avoid conflicts between "${SSLBASE}/include/openssl/des.h"
 # and "/usr/include/crypt.h" -- we want the definitions in the former.
-#
 .if ${OPSYS} == "SunOS"
 post-wrapper:
 	touch ${BUILDLINK_DIR}/include/crypt.h
@@ -80,7 +97,10 @@ post-install:
 		bug.template;						\
 	do								\
 		${INSTALL_DATA} $$file ${DESTDIR}${PG_DOC_DIR}/$$file;	\
-        done
+	done
+	for file in ${PG_PGXS_FILES}; do				\
+		${INSTALL_DATA} ${WRKSRC}/$$file ${DEST_PG_PGXS}/$$file;\
+	done
 	cp -R ${WRKSRC}/doc/TODO.detail ${DESTDIR}${PG_DOC_DIR}
 	chown -R ${DOCOWN}:${DOCGRP} ${DESTDIR}${PG_DOC_DIR}/TODO.detail
 
diff --git a/databases/postgresql83-client/PLIST b/databases/postgresql83-client/PLIST
index 09a86abc059..cad2f8d0f25 100644
--- a/databases/postgresql83-client/PLIST
+++ b/databases/postgresql83-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.10 2009/09/10 10:07:17 adam Exp $
+@comment $NetBSD: PLIST,v 1.11 2009/12/16 14:23:13 adam Exp $
 ${PG_SUBPREFIX}bin/clusterdb
 ${PG_SUBPREFIX}bin/createdb
 ${PG_SUBPREFIX}bin/createlang
@@ -472,6 +472,13 @@ ${PG_SUBPREFIX}lib/libecpg_compat.la
 ${PG_SUBPREFIX}lib/libpgport.a
 ${PG_SUBPREFIX}lib/libpgtypes.la
 ${PG_SUBPREFIX}lib/libpq.la
+${PG_SUBPREFIX}lib/postgresql/pgxs/config/install-sh
+${PG_SUBPREFIX}lib/postgresql/pgxs/config/mkinstalldirs
+${PG_SUBPREFIX}lib/postgresql/pgxs/src/Makefile.global
+${PG_SUBPREFIX}lib/postgresql/pgxs/src/Makefile.port
+${PG_SUBPREFIX}lib/postgresql/pgxs/src/Makefile.shlib
+${PG_SUBPREFIX}lib/postgresql/pgxs/src/makefiles/pgxs.mk
+${PG_SUBPREFIX}lib/postgresql/pgxs/src/nls-global.mk
 ${PG_SUBPREFIX}man/man1/clusterdb.1
 ${PG_SUBPREFIX}man/man1/createdb.1
 ${PG_SUBPREFIX}man/man1/createlang.1
@@ -1196,6 +1203,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-16.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-17.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-18.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-19.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-20.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-21.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-22.html
@@ -1203,7 +1211,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-23.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-24.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-25.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-26.html
-${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-2.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-27.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-4.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-5.html
@@ -1223,10 +1231,11 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-16.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-17.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-18.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-19.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-20.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-21.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-22.html
-${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-2.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-23.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-4.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-5.html
@@ -1245,6 +1254,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-15.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-16.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-17.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-18.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-19.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-4.html
@@ -1260,6 +1270,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-11.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-12.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-13.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-14.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-15.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-4.html
@@ -1277,6 +1288,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-5.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-6.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-7.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-8.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-9.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/resources.html
diff --git a/databases/postgresql83-server/Makefile b/databases/postgresql83-server/Makefile
index 7bd073e5e8d..9db98373396 100644
--- a/databases/postgresql83-server/Makefile
+++ b/databases/postgresql83-server/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2009/12/15 21:33:48 joerg Exp $
+# $NetBSD: Makefile,v 1.6 2009/12/16 14:23:13 adam Exp $
 
 PKGNAME=	postgresql83-server-${BASE_VERS}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database server programs
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql83-server/PLIST b/databases/postgresql83-server/PLIST
index 4eb8af8eb64..46dd0250dab 100644
--- a/databases/postgresql83-server/PLIST
+++ b/databases/postgresql83-server/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.7 2009/06/14 17:43:22 joerg Exp $
+@comment $NetBSD: PLIST,v 1.8 2009/12/16 14:23:13 adam Exp $
 ${PG_SUBPREFIX}bin/postgres
 ${PG_SUBPREFIX}bin/postmaster
 ${PG_SUBPREFIX}lib/postgresql/ascii_and_mic.la
@@ -335,6 +335,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/Asia/Makassar
 ${PG_SUBPREFIX}share/postgresql/timezone/Asia/Manila
 ${PG_SUBPREFIX}share/postgresql/timezone/Asia/Muscat
 ${PG_SUBPREFIX}share/postgresql/timezone/Asia/Nicosia
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Novokuznetsk
 ${PG_SUBPREFIX}share/postgresql/timezone/Asia/Novosibirsk
 ${PG_SUBPREFIX}share/postgresql/timezone/Asia/Omsk
 ${PG_SUBPREFIX}share/postgresql/timezone/Asia/Oral
diff --git a/databases/postgresql83/Makefile.common b/databases/postgresql83/Makefile.common
index 0400651c9a5..84b0d681c17 100644
--- a/databases/postgresql83/Makefile.common
+++ b/databases/postgresql83/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.8 2009/09/10 10:07:17 adam Exp $
+# $NetBSD: Makefile.common,v 1.9 2009/12/16 14:23:13 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -38,7 +38,7 @@ PATCHDIR?=		${.CURDIR}/../postgresql83/patches
 #
 # Note: Do not forget jdbc-postgresql83 when updating version
 #
-DIST_VERS?=		8.3.8
+DIST_VERS?=		8.3.9
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql83-client+=	postgresql83-client>=${BASE_VERS}
diff --git a/databases/postgresql83/distinfo b/databases/postgresql83/distinfo
index 28e2c8a3320..94ad5ccd70a 100644
--- a/databases/postgresql83/distinfo
+++ b/databases/postgresql83/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.8 2009/09/10 10:07:17 adam Exp $
+$NetBSD: distinfo,v 1.9 2009/12/16 14:23:13 adam Exp $
 
-SHA1 (postgresql-8.3.8.tar.bz2) = 9af0351cfdac73381bb4b06fb429345fd14930cd
-RMD160 (postgresql-8.3.8.tar.bz2) = 333cbc0b0d9f3f756b08b7e980691dc5671877e5
-Size (postgresql-8.3.8.tar.bz2) = 14147538 bytes
+SHA1 (postgresql-8.3.9.tar.bz2) = 5403f13bb14fe568e2b46a3350d6e28808d93a2c
+RMD160 (postgresql-8.3.9.tar.bz2) = 0069606033d9572d7848a5914a274cabaed24007
+Size (postgresql-8.3.9.tar.bz2) = 14170569 bytes
 SHA1 (patch-aa) = aeeeaafb38e75d8e8f6639280e997ba4c905b45f
 SHA1 (patch-ab) = 7bf5635b0b93c3c0d33acd4e122e102c92ce7b76
 SHA1 (patch-ac) = 8e3a7021fdd01810d4ebcbd20002b28164b22279