Update to 7.3.3.

1. Optionally link with libc_r to get plpython working. [1]
2. Fix kerberos build. [2]
3. There was a duplication of some declarations. [3]

PR:		ports/52851
PR:		ports/51080 [2]
Submitted by:	Mike Meyer <mwm@mired.org> [1]
Submitted by:	Gerweck <andy@tacnode.com> [2]
Pointed out by:	Mike Harding <mvh@ix.netcom.com> [3]
Submitted by:	Palle Girgensohn <girgen@pingpong.net> (maintainer)

40 files changed, 234 insertions, 547 deletions

diff --git a/databases/postgresql-devel-server/Makefile b/databases/postgresql-devel-server/Makefile
index c204fbcacebe..3465ae6d39fd 100644
--- a/databases/postgresql-devel-server/Makefile
+++ b/databases/postgresql-devel-server/Makefile
@@ -6,8 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.3.2
-PORTREVISION=	1
+PORTVERSION?=	7.3.3
 CATEGORIES?=	databases
 MASTER_SITES=	ftp://ftp3.us.postgresql.org/pub/postgresql/%SUBDIR%/ \
 		ftp://ftp5.us.postgresql.org/pub/PostgreSQL/%SUBDIR%/ \
@@ -47,6 +46,7 @@ INSTALLS_SHLIB=	YES
 
 CONFIGURE_ARGS=	--with-libraries=${LOCALBASE}/lib \
 		--with-includes=${LOCALBASE}/include
+CONFIGURE_ENV=	LDFLAGS="${LDFLAGS}"
 
 .if !defined(WITHOUT_GNUGETOPT)
 LIB_DEPENDS=	gnugetopt:${PORTSDIR}/devel/libgnugetopt
@@ -98,19 +98,22 @@ LIB_DEPENDS+=	krb5.3:${PORTSDIR}/security/krb5
 WITH_KRB5=	yes
 .endif
 
+.include <bsd.port.pre.mk>
 .if defined(WITH_KRB5)
 CONFIGURE_ARGS+=	--with-krb5="`${KRB5CONF} --prefix krb5`"
 LDFLAGS+=	`${KRB5CONF} --libs krb5`
-.endif
-
-.if defined(WITH_OPTIMIZED_CFLAGS)
-CFLAGS+= -O3 -funroll-loops
+CONFIGURE_ENV=  LDFLAGS="${LDFLAGS}"
 .endif
 
 .if defined(WITH_TESTS)
 DISTFILES+=	postgresql-test-${PORTVERSION}${EXTRACT_SUFX}
 .endif
 
+.if defined(WITH_LIBC_R)
+CFLAGS+=	${PTHREAD_CFLAGS}
+LDFLAGS+=	${PTHREAD_LIBS}
+.endif
+
 MAN1=		clusterdb.1 createdb.1 createlang.1 createuser.1 dropdb.1 \
 		droplang.1 dropuser.1 ecpg.1 initdb.1 initlocation.1 ipcclean.1 \
 		pg_config.1 pg_controldata.1 pg_ctl.1 pg_dump.1 pg_dumpall.1 \
@@ -140,7 +143,7 @@ MAN7=		abort.7 alter_database.7 alter_group.7 alter_table.7 \
 		truncate.7 unlisten.7 update.7 vacuum.7
 
 pre-everything::
-	@${SH} ${PKGDIR}/pkg-install ${PORTNAME} BACKUPWARNING
+	@${SH} ${PKGINSTALL} ${PORTNAME} BACKUPWARNING
 	@${ECHO} ""
 	@${ECHO} "${PORTNAME} has several tunables that can be used to configure PostgreSQL:"
 	@${ECHO} ""
@@ -157,6 +160,8 @@ pre-everything::
 	@${ECHO} "	WITH_DEBUG		Builds with debugging symbols"
 	@${ECHO} "	WITH_TESTS		Allows the use of a \"check\" target"
 	@${ECHO} "				building the module"
+	@${ECHO} "	WITH_LIBC_R		Link the binaries with libc_r."
+	@${ECHO} "				Needed to run plpython"
 	@${ECHO} ""
 .if defined(WITH_MIT_KRB5) && defined(WITH_HEIMDAL_KRB5)
 	@${ECHO} "WITH_MIT_KRB5 and WITH_HEIMDAL_KRB5 are mutually exclusive."
@@ -185,7 +190,7 @@ do-install:
 .else
 pre-install:
 	@ ${SETENV} PKG_PREFIX=${PREFIX} \
-		${SH} ${PKGDIR}/pkg-install ${PORTNAME} PRE-INSTALL
+		${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL
 .endif
 
 post-install:
@@ -225,5 +230,5 @@ check:
 	 fi
 .endif
 
-.include <bsd.port.mk>
+.include <bsd.port.post.mk>
 .endif
diff --git a/databases/postgresql-devel-server/distinfo b/databases/postgresql-devel-server/distinfo
index 934a97ecd98a..d95d2a295743 100644
--- a/databases/postgresql-devel-server/distinfo
+++ b/databases/postgresql-devel-server/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.3.2.tar.gz) = 2cd99c2d455c653fdfe74f5dd658d15c
-MD5 (postgresql/postgresql-opt-7.3.2.tar.gz) = c54a5b0be96b60259bd37f6a5b60abb9
-MD5 (postgresql/postgresql-test-7.3.2.tar.gz) = 9818eb4c50a2fe9057c7df5ae270972c
-MD5 (postgresql/postgresql-docs-7.3.2.tar.gz) = e91131aeed6919a00ab231db2298bd0b
+MD5 (postgresql/postgresql-base-7.3.3.tar.gz) = 4f5830d3effa8b00b22cc13597030b2f
+MD5 (postgresql/postgresql-opt-7.3.3.tar.gz) = b0b7f07c6bba1813b18e9901e481599d
+MD5 (postgresql/postgresql-docs-7.3.3.tar.gz) = 5009a3233f3ecf80369a5613298fbb8c
+MD5 (postgresql/postgresql-test-7.3.3.tar.gz) = d029272601b4d8bfac3b6be843f0064b
diff --git a/databases/postgresql-devel-server/files/patch-src::backend::utils::adt::numutils.c b/databases/postgresql-devel-server/files/patch-src::backend::utils::adt::numutils.c
deleted file mode 100644
index 3a9c84d71961..000000000000
--- a/databases/postgresql-devel-server/files/patch-src::backend::utils::adt::numutils.c
+++ /dev/null
@@ -1,29 +0,0 @@
-Index: src/backend/utils/adt/numutils.c
-===================================================================
-RCS file: /cvsroot/pgsql-server/src/backend/utils/adt/numutils.c,v
-retrieving revision 1.54
-diff -c -c -r1.54 numutils.c
-*** src/backend/utils/adt/numutils.c	4 Sep 2002 20:31:28 -0000	1.54
---- src/backend/utils/adt/numutils.c	19 Dec 2002 17:10:56 -0000
-***************
-*** 70,76 ****
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 		elog(ERROR, "pg_atoi: zero-length string");
-  	else
-  		l = strtol(s, &badp, 10);
-  
---- 70,80 ----
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 	{
-! 		/* 7.3.X workaround for broken apps, bjm  2002-12-19 */
-! 		elog(WARNING, "pg_atoi: zero-length string");
-! 		l = (long) 0;
-! 	}
-  	else
-  		l = strtol(s, &badp, 10);
-  
-
diff --git a/databases/postgresql-jdbc/Makefile b/databases/postgresql-jdbc/Makefile
index 27d5e3b72d51..737fa72d6be4 100644
--- a/databases/postgresql-jdbc/Makefile
+++ b/databases/postgresql-jdbc/Makefile
@@ -7,7 +7,6 @@
 
 PORTNAME=	postgresql-jdbc
 CATEGORIES=	databases java
-PORTREVISION=	1
 
 MAINTAINER=	girgen@pingpong.net
 COMMENT=	The Java JDBC implementation for PostgreSQL
diff --git a/databases/postgresql7/Makefile b/databases/postgresql7/Makefile
index c204fbcacebe..3465ae6d39fd 100644
--- a/databases/postgresql7/Makefile
+++ b/databases/postgresql7/Makefile
@@ -6,8 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.3.2
-PORTREVISION=	1
+PORTVERSION?=	7.3.3
 CATEGORIES?=	databases
 MASTER_SITES=	ftp://ftp3.us.postgresql.org/pub/postgresql/%SUBDIR%/ \
 		ftp://ftp5.us.postgresql.org/pub/PostgreSQL/%SUBDIR%/ \
@@ -47,6 +46,7 @@ INSTALLS_SHLIB=	YES
 
 CONFIGURE_ARGS=	--with-libraries=${LOCALBASE}/lib \
 		--with-includes=${LOCALBASE}/include
+CONFIGURE_ENV=	LDFLAGS="${LDFLAGS}"
 
 .if !defined(WITHOUT_GNUGETOPT)
 LIB_DEPENDS=	gnugetopt:${PORTSDIR}/devel/libgnugetopt
@@ -98,19 +98,22 @@ LIB_DEPENDS+=	krb5.3:${PORTSDIR}/security/krb5
 WITH_KRB5=	yes
 .endif
 
+.include <bsd.port.pre.mk>
 .if defined(WITH_KRB5)
 CONFIGURE_ARGS+=	--with-krb5="`${KRB5CONF} --prefix krb5`"
 LDFLAGS+=	`${KRB5CONF} --libs krb5`
-.endif
-
-.if defined(WITH_OPTIMIZED_CFLAGS)
-CFLAGS+= -O3 -funroll-loops
+CONFIGURE_ENV=  LDFLAGS="${LDFLAGS}"
 .endif
 
 .if defined(WITH_TESTS)
 DISTFILES+=	postgresql-test-${PORTVERSION}${EXTRACT_SUFX}
 .endif
 
+.if defined(WITH_LIBC_R)
+CFLAGS+=	${PTHREAD_CFLAGS}
+LDFLAGS+=	${PTHREAD_LIBS}
+.endif
+
 MAN1=		clusterdb.1 createdb.1 createlang.1 createuser.1 dropdb.1 \
 		droplang.1 dropuser.1 ecpg.1 initdb.1 initlocation.1 ipcclean.1 \
 		pg_config.1 pg_controldata.1 pg_ctl.1 pg_dump.1 pg_dumpall.1 \
@@ -140,7 +143,7 @@ MAN7=		abort.7 alter_database.7 alter_group.7 alter_table.7 \
 		truncate.7 unlisten.7 update.7 vacuum.7
 
 pre-everything::
-	@${SH} ${PKGDIR}/pkg-install ${PORTNAME} BACKUPWARNING
+	@${SH} ${PKGINSTALL} ${PORTNAME} BACKUPWARNING
 	@${ECHO} ""
 	@${ECHO} "${PORTNAME} has several tunables that can be used to configure PostgreSQL:"
 	@${ECHO} ""
@@ -157,6 +160,8 @@ pre-everything::
 	@${ECHO} "	WITH_DEBUG		Builds with debugging symbols"
 	@${ECHO} "	WITH_TESTS		Allows the use of a \"check\" target"
 	@${ECHO} "				building the module"
+	@${ECHO} "	WITH_LIBC_R		Link the binaries with libc_r."
+	@${ECHO} "				Needed to run plpython"
 	@${ECHO} ""
 .if defined(WITH_MIT_KRB5) && defined(WITH_HEIMDAL_KRB5)
 	@${ECHO} "WITH_MIT_KRB5 and WITH_HEIMDAL_KRB5 are mutually exclusive."
@@ -185,7 +190,7 @@ do-install:
 .else
 pre-install:
 	@ ${SETENV} PKG_PREFIX=${PREFIX} \
-		${SH} ${PKGDIR}/pkg-install ${PORTNAME} PRE-INSTALL
+		${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL
 .endif
 
 post-install:
@@ -225,5 +230,5 @@ check:
 	 fi
 .endif
 
-.include <bsd.port.mk>
+.include <bsd.port.post.mk>
 .endif
diff --git a/databases/postgresql7/distinfo b/databases/postgresql7/distinfo
index 934a97ecd98a..d95d2a295743 100644
--- a/databases/postgresql7/distinfo
+++ b/databases/postgresql7/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.3.2.tar.gz) = 2cd99c2d455c653fdfe74f5dd658d15c
-MD5 (postgresql/postgresql-opt-7.3.2.tar.gz) = c54a5b0be96b60259bd37f6a5b60abb9
-MD5 (postgresql/postgresql-test-7.3.2.tar.gz) = 9818eb4c50a2fe9057c7df5ae270972c
-MD5 (postgresql/postgresql-docs-7.3.2.tar.gz) = e91131aeed6919a00ab231db2298bd0b
+MD5 (postgresql/postgresql-base-7.3.3.tar.gz) = 4f5830d3effa8b00b22cc13597030b2f
+MD5 (postgresql/postgresql-opt-7.3.3.tar.gz) = b0b7f07c6bba1813b18e9901e481599d
+MD5 (postgresql/postgresql-docs-7.3.3.tar.gz) = 5009a3233f3ecf80369a5613298fbb8c
+MD5 (postgresql/postgresql-test-7.3.3.tar.gz) = d029272601b4d8bfac3b6be843f0064b
diff --git a/databases/postgresql7/files/patch-src::backend::utils::adt::numutils.c b/databases/postgresql7/files/patch-src::backend::utils::adt::numutils.c
deleted file mode 100644
index 3a9c84d71961..000000000000
--- a/databases/postgresql7/files/patch-src::backend::utils::adt::numutils.c
+++ /dev/null
@@ -1,29 +0,0 @@
-Index: src/backend/utils/adt/numutils.c
-===================================================================
-RCS file: /cvsroot/pgsql-server/src/backend/utils/adt/numutils.c,v
-retrieving revision 1.54
-diff -c -c -r1.54 numutils.c
-*** src/backend/utils/adt/numutils.c	4 Sep 2002 20:31:28 -0000	1.54
---- src/backend/utils/adt/numutils.c	19 Dec 2002 17:10:56 -0000
-***************
-*** 70,76 ****
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 		elog(ERROR, "pg_atoi: zero-length string");
-  	else
-  		l = strtol(s, &badp, 10);
-  
---- 70,80 ----
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 	{
-! 		/* 7.3.X workaround for broken apps, bjm  2002-12-19 */
-! 		elog(WARNING, "pg_atoi: zero-length string");
-! 		l = (long) 0;
-! 	}
-  	else
-  		l = strtol(s, &badp, 10);
-  
-
diff --git a/databases/postgresql73-server/Makefile b/databases/postgresql73-server/Makefile
index c204fbcacebe..3465ae6d39fd 100644
--- a/databases/postgresql73-server/Makefile
+++ b/databases/postgresql73-server/Makefile
@@ -6,8 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.3.2
-PORTREVISION=	1
+PORTVERSION?=	7.3.3
 CATEGORIES?=	databases
 MASTER_SITES=	ftp://ftp3.us.postgresql.org/pub/postgresql/%SUBDIR%/ \
 		ftp://ftp5.us.postgresql.org/pub/PostgreSQL/%SUBDIR%/ \
@@ -47,6 +46,7 @@ INSTALLS_SHLIB=	YES
 
 CONFIGURE_ARGS=	--with-libraries=${LOCALBASE}/lib \
 		--with-includes=${LOCALBASE}/include
+CONFIGURE_ENV=	LDFLAGS="${LDFLAGS}"
 
 .if !defined(WITHOUT_GNUGETOPT)
 LIB_DEPENDS=	gnugetopt:${PORTSDIR}/devel/libgnugetopt
@@ -98,19 +98,22 @@ LIB_DEPENDS+=	krb5.3:${PORTSDIR}/security/krb5
 WITH_KRB5=	yes
 .endif
 
+.include <bsd.port.pre.mk>
 .if defined(WITH_KRB5)
 CONFIGURE_ARGS+=	--with-krb5="`${KRB5CONF} --prefix krb5`"
 LDFLAGS+=	`${KRB5CONF} --libs krb5`
-.endif
-
-.if defined(WITH_OPTIMIZED_CFLAGS)
-CFLAGS+= -O3 -funroll-loops
+CONFIGURE_ENV=  LDFLAGS="${LDFLAGS}"
 .endif
 
 .if defined(WITH_TESTS)
 DISTFILES+=	postgresql-test-${PORTVERSION}${EXTRACT_SUFX}
 .endif
 
+.if defined(WITH_LIBC_R)
+CFLAGS+=	${PTHREAD_CFLAGS}
+LDFLAGS+=	${PTHREAD_LIBS}
+.endif
+
 MAN1=		clusterdb.1 createdb.1 createlang.1 createuser.1 dropdb.1 \
 		droplang.1 dropuser.1 ecpg.1 initdb.1 initlocation.1 ipcclean.1 \
 		pg_config.1 pg_controldata.1 pg_ctl.1 pg_dump.1 pg_dumpall.1 \
@@ -140,7 +143,7 @@ MAN7=		abort.7 alter_database.7 alter_group.7 alter_table.7 \
 		truncate.7 unlisten.7 update.7 vacuum.7
 
 pre-everything::
-	@${SH} ${PKGDIR}/pkg-install ${PORTNAME} BACKUPWARNING
+	@${SH} ${PKGINSTALL} ${PORTNAME} BACKUPWARNING
 	@${ECHO} ""
 	@${ECHO} "${PORTNAME} has several tunables that can be used to configure PostgreSQL:"
 	@${ECHO} ""
@@ -157,6 +160,8 @@ pre-everything::
 	@${ECHO} "	WITH_DEBUG		Builds with debugging symbols"
 	@${ECHO} "	WITH_TESTS		Allows the use of a \"check\" target"
 	@${ECHO} "				building the module"
+	@${ECHO} "	WITH_LIBC_R		Link the binaries with libc_r."
+	@${ECHO} "				Needed to run plpython"
 	@${ECHO} ""
 .if defined(WITH_MIT_KRB5) && defined(WITH_HEIMDAL_KRB5)
 	@${ECHO} "WITH_MIT_KRB5 and WITH_HEIMDAL_KRB5 are mutually exclusive."
@@ -185,7 +190,7 @@ do-install:
 .else
 pre-install:
 	@ ${SETENV} PKG_PREFIX=${PREFIX} \
-		${SH} ${PKGDIR}/pkg-install ${PORTNAME} PRE-INSTALL
+		${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL
 .endif
 
 post-install:
@@ -225,5 +230,5 @@ check:
 	 fi
 .endif
 
-.include <bsd.port.mk>
+.include <bsd.port.post.mk>
 .endif
diff --git a/databases/postgresql73-server/distinfo b/databases/postgresql73-server/distinfo
index 934a97ecd98a..d95d2a295743 100644
--- a/databases/postgresql73-server/distinfo
+++ b/databases/postgresql73-server/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.3.2.tar.gz) = 2cd99c2d455c653fdfe74f5dd658d15c
-MD5 (postgresql/postgresql-opt-7.3.2.tar.gz) = c54a5b0be96b60259bd37f6a5b60abb9
-MD5 (postgresql/postgresql-test-7.3.2.tar.gz) = 9818eb4c50a2fe9057c7df5ae270972c
-MD5 (postgresql/postgresql-docs-7.3.2.tar.gz) = e91131aeed6919a00ab231db2298bd0b
+MD5 (postgresql/postgresql-base-7.3.3.tar.gz) = 4f5830d3effa8b00b22cc13597030b2f
+MD5 (postgresql/postgresql-opt-7.3.3.tar.gz) = b0b7f07c6bba1813b18e9901e481599d
+MD5 (postgresql/postgresql-docs-7.3.3.tar.gz) = 5009a3233f3ecf80369a5613298fbb8c
+MD5 (postgresql/postgresql-test-7.3.3.tar.gz) = d029272601b4d8bfac3b6be843f0064b
diff --git a/databases/postgresql73-server/files/patch-src::backend::utils::adt::numutils.c b/databases/postgresql73-server/files/patch-src::backend::utils::adt::numutils.c
deleted file mode 100644
index 3a9c84d71961..000000000000
--- a/databases/postgresql73-server/files/patch-src::backend::utils::adt::numutils.c
+++ /dev/null
@@ -1,29 +0,0 @@
-Index: src/backend/utils/adt/numutils.c
-===================================================================
-RCS file: /cvsroot/pgsql-server/src/backend/utils/adt/numutils.c,v
-retrieving revision 1.54
-diff -c -c -r1.54 numutils.c
-*** src/backend/utils/adt/numutils.c	4 Sep 2002 20:31:28 -0000	1.54
---- src/backend/utils/adt/numutils.c	19 Dec 2002 17:10:56 -0000
-***************
-*** 70,76 ****
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 		elog(ERROR, "pg_atoi: zero-length string");
-  	else
-  		l = strtol(s, &badp, 10);
-  
---- 70,80 ----
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 	{
-! 		/* 7.3.X workaround for broken apps, bjm  2002-12-19 */
-! 		elog(WARNING, "pg_atoi: zero-length string");
-! 		l = (long) 0;
-! 	}
-  	else
-  		l = strtol(s, &badp, 10);
-  
-
diff --git a/databases/postgresql73/Makefile b/databases/postgresql73/Makefile
index c204fbcacebe..3465ae6d39fd 100644
--- a/databases/postgresql73/Makefile
+++ b/databases/postgresql73/Makefile
@@ -6,8 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.3.2
-PORTREVISION=	1
+PORTVERSION?=	7.3.3
 CATEGORIES?=	databases
 MASTER_SITES=	ftp://ftp3.us.postgresql.org/pub/postgresql/%SUBDIR%/ \
 		ftp://ftp5.us.postgresql.org/pub/PostgreSQL/%SUBDIR%/ \
@@ -47,6 +46,7 @@ INSTALLS_SHLIB=	YES
 
 CONFIGURE_ARGS=	--with-libraries=${LOCALBASE}/lib \
 		--with-includes=${LOCALBASE}/include
+CONFIGURE_ENV=	LDFLAGS="${LDFLAGS}"
 
 .if !defined(WITHOUT_GNUGETOPT)
 LIB_DEPENDS=	gnugetopt:${PORTSDIR}/devel/libgnugetopt
@@ -98,19 +98,22 @@ LIB_DEPENDS+=	krb5.3:${PORTSDIR}/security/krb5
 WITH_KRB5=	yes
 .endif
 
+.include <bsd.port.pre.mk>
 .if defined(WITH_KRB5)
 CONFIGURE_ARGS+=	--with-krb5="`${KRB5CONF} --prefix krb5`"
 LDFLAGS+=	`${KRB5CONF} --libs krb5`
-.endif
-
-.if defined(WITH_OPTIMIZED_CFLAGS)
-CFLAGS+= -O3 -funroll-loops
+CONFIGURE_ENV=  LDFLAGS="${LDFLAGS}"
 .endif
 
 .if defined(WITH_TESTS)
 DISTFILES+=	postgresql-test-${PORTVERSION}${EXTRACT_SUFX}
 .endif
 
+.if defined(WITH_LIBC_R)
+CFLAGS+=	${PTHREAD_CFLAGS}
+LDFLAGS+=	${PTHREAD_LIBS}
+.endif
+
 MAN1=		clusterdb.1 createdb.1 createlang.1 createuser.1 dropdb.1 \
 		droplang.1 dropuser.1 ecpg.1 initdb.1 initlocation.1 ipcclean.1 \
 		pg_config.1 pg_controldata.1 pg_ctl.1 pg_dump.1 pg_dumpall.1 \
@@ -140,7 +143,7 @@ MAN7=		abort.7 alter_database.7 alter_group.7 alter_table.7 \
 		truncate.7 unlisten.7 update.7 vacuum.7
 
 pre-everything::
-	@${SH} ${PKGDIR}/pkg-install ${PORTNAME} BACKUPWARNING
+	@${SH} ${PKGINSTALL} ${PORTNAME} BACKUPWARNING
 	@${ECHO} ""
 	@${ECHO} "${PORTNAME} has several tunables that can be used to configure PostgreSQL:"
 	@${ECHO} ""
@@ -157,6 +160,8 @@ pre-everything::
 	@${ECHO} "	WITH_DEBUG		Builds with debugging symbols"
 	@${ECHO} "	WITH_TESTS		Allows the use of a \"check\" target"
 	@${ECHO} "				building the module"
+	@${ECHO} "	WITH_LIBC_R		Link the binaries with libc_r."
+	@${ECHO} "				Needed to run plpython"
 	@${ECHO} ""
 .if defined(WITH_MIT_KRB5) && defined(WITH_HEIMDAL_KRB5)
 	@${ECHO} "WITH_MIT_KRB5 and WITH_HEIMDAL_KRB5 are mutually exclusive."
@@ -185,7 +190,7 @@ do-install:
 .else
 pre-install:
 	@ ${SETENV} PKG_PREFIX=${PREFIX} \
-		${SH} ${PKGDIR}/pkg-install ${PORTNAME} PRE-INSTALL
+		${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL
 .endif
 
 post-install:
@@ -225,5 +230,5 @@ check:
 	 fi
 .endif
 
-.include <bsd.port.mk>
+.include <bsd.port.post.mk>
 .endif
diff --git a/databases/postgresql73/distinfo b/databases/postgresql73/distinfo
index 934a97ecd98a..d95d2a295743 100644
--- a/databases/postgresql73/distinfo
+++ b/databases/postgresql73/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.3.2.tar.gz) = 2cd99c2d455c653fdfe74f5dd658d15c
-MD5 (postgresql/postgresql-opt-7.3.2.tar.gz) = c54a5b0be96b60259bd37f6a5b60abb9
-MD5 (postgresql/postgresql-test-7.3.2.tar.gz) = 9818eb4c50a2fe9057c7df5ae270972c
-MD5 (postgresql/postgresql-docs-7.3.2.tar.gz) = e91131aeed6919a00ab231db2298bd0b
+MD5 (postgresql/postgresql-base-7.3.3.tar.gz) = 4f5830d3effa8b00b22cc13597030b2f
+MD5 (postgresql/postgresql-opt-7.3.3.tar.gz) = b0b7f07c6bba1813b18e9901e481599d
+MD5 (postgresql/postgresql-docs-7.3.3.tar.gz) = 5009a3233f3ecf80369a5613298fbb8c
+MD5 (postgresql/postgresql-test-7.3.3.tar.gz) = d029272601b4d8bfac3b6be843f0064b
diff --git a/databases/postgresql73/files/patch-src::backend::utils::adt::numutils.c b/databases/postgresql73/files/patch-src::backend::utils::adt::numutils.c
deleted file mode 100644
index 3a9c84d71961..000000000000
--- a/databases/postgresql73/files/patch-src::backend::utils::adt::numutils.c
+++ /dev/null
@@ -1,29 +0,0 @@
-Index: src/backend/utils/adt/numutils.c
-===================================================================
-RCS file: /cvsroot/pgsql-server/src/backend/utils/adt/numutils.c,v
-retrieving revision 1.54
-diff -c -c -r1.54 numutils.c
-*** src/backend/utils/adt/numutils.c	4 Sep 2002 20:31:28 -0000	1.54
---- src/backend/utils/adt/numutils.c	19 Dec 2002 17:10:56 -0000
-***************
-*** 70,76 ****
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 		elog(ERROR, "pg_atoi: zero-length string");
-  	else
-  		l = strtol(s, &badp, 10);
-  
---- 70,80 ----
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 	{
-! 		/* 7.3.X workaround for broken apps, bjm  2002-12-19 */
-! 		elog(WARNING, "pg_atoi: zero-length string");
-! 		l = (long) 0;
-! 	}
-  	else
-  		l = strtol(s, &badp, 10);
-  
-
diff --git a/databases/postgresql74-server/Makefile b/databases/postgresql74-server/Makefile
index c204fbcacebe..3465ae6d39fd 100644
--- a/databases/postgresql74-server/Makefile
+++ b/databases/postgresql74-server/Makefile
@@ -6,8 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.3.2
-PORTREVISION=	1
+PORTVERSION?=	7.3.3
 CATEGORIES?=	databases
 MASTER_SITES=	ftp://ftp3.us.postgresql.org/pub/postgresql/%SUBDIR%/ \
 		ftp://ftp5.us.postgresql.org/pub/PostgreSQL/%SUBDIR%/ \
@@ -47,6 +46,7 @@ INSTALLS_SHLIB=	YES
 
 CONFIGURE_ARGS=	--with-libraries=${LOCALBASE}/lib \
 		--with-includes=${LOCALBASE}/include
+CONFIGURE_ENV=	LDFLAGS="${LDFLAGS}"
 
 .if !defined(WITHOUT_GNUGETOPT)
 LIB_DEPENDS=	gnugetopt:${PORTSDIR}/devel/libgnugetopt
@@ -98,19 +98,22 @@ LIB_DEPENDS+=	krb5.3:${PORTSDIR}/security/krb5
 WITH_KRB5=	yes
 .endif
 
+.include <bsd.port.pre.mk>
 .if defined(WITH_KRB5)
 CONFIGURE_ARGS+=	--with-krb5="`${KRB5CONF} --prefix krb5`"
 LDFLAGS+=	`${KRB5CONF} --libs krb5`
-.endif
-
-.if defined(WITH_OPTIMIZED_CFLAGS)
-CFLAGS+= -O3 -funroll-loops
+CONFIGURE_ENV=  LDFLAGS="${LDFLAGS}"
 .endif
 
 .if defined(WITH_TESTS)
 DISTFILES+=	postgresql-test-${PORTVERSION}${EXTRACT_SUFX}
 .endif
 
+.if defined(WITH_LIBC_R)
+CFLAGS+=	${PTHREAD_CFLAGS}
+LDFLAGS+=	${PTHREAD_LIBS}
+.endif
+
 MAN1=		clusterdb.1 createdb.1 createlang.1 createuser.1 dropdb.1 \
 		droplang.1 dropuser.1 ecpg.1 initdb.1 initlocation.1 ipcclean.1 \
 		pg_config.1 pg_controldata.1 pg_ctl.1 pg_dump.1 pg_dumpall.1 \
@@ -140,7 +143,7 @@ MAN7=		abort.7 alter_database.7 alter_group.7 alter_table.7 \
 		truncate.7 unlisten.7 update.7 vacuum.7
 
 pre-everything::
-	@${SH} ${PKGDIR}/pkg-install ${PORTNAME} BACKUPWARNING
+	@${SH} ${PKGINSTALL} ${PORTNAME} BACKUPWARNING
 	@${ECHO} ""
 	@${ECHO} "${PORTNAME} has several tunables that can be used to configure PostgreSQL:"
 	@${ECHO} ""
@@ -157,6 +160,8 @@ pre-everything::
 	@${ECHO} "	WITH_DEBUG		Builds with debugging symbols"
 	@${ECHO} "	WITH_TESTS		Allows the use of a \"check\" target"
 	@${ECHO} "				building the module"
+	@${ECHO} "	WITH_LIBC_R		Link the binaries with libc_r."
+	@${ECHO} "				Needed to run plpython"
 	@${ECHO} ""
 .if defined(WITH_MIT_KRB5) && defined(WITH_HEIMDAL_KRB5)
 	@${ECHO} "WITH_MIT_KRB5 and WITH_HEIMDAL_KRB5 are mutually exclusive."
@@ -185,7 +190,7 @@ do-install:
 .else
 pre-install:
 	@ ${SETENV} PKG_PREFIX=${PREFIX} \
-		${SH} ${PKGDIR}/pkg-install ${PORTNAME} PRE-INSTALL
+		${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL
 .endif
 
 post-install:
@@ -225,5 +230,5 @@ check:
 	 fi
 .endif
 
-.include <bsd.port.mk>
+.include <bsd.port.post.mk>
 .endif
diff --git a/databases/postgresql74-server/distinfo b/databases/postgresql74-server/distinfo
index 934a97ecd98a..d95d2a295743 100644
--- a/databases/postgresql74-server/distinfo
+++ b/databases/postgresql74-server/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.3.2.tar.gz) = 2cd99c2d455c653fdfe74f5dd658d15c
-MD5 (postgresql/postgresql-opt-7.3.2.tar.gz) = c54a5b0be96b60259bd37f6a5b60abb9
-MD5 (postgresql/postgresql-test-7.3.2.tar.gz) = 9818eb4c50a2fe9057c7df5ae270972c
-MD5 (postgresql/postgresql-docs-7.3.2.tar.gz) = e91131aeed6919a00ab231db2298bd0b
+MD5 (postgresql/postgresql-base-7.3.3.tar.gz) = 4f5830d3effa8b00b22cc13597030b2f
+MD5 (postgresql/postgresql-opt-7.3.3.tar.gz) = b0b7f07c6bba1813b18e9901e481599d
+MD5 (postgresql/postgresql-docs-7.3.3.tar.gz) = 5009a3233f3ecf80369a5613298fbb8c
+MD5 (postgresql/postgresql-test-7.3.3.tar.gz) = d029272601b4d8bfac3b6be843f0064b
diff --git a/databases/postgresql74-server/files/patch-src::backend::utils::adt::numutils.c b/databases/postgresql74-server/files/patch-src::backend::utils::adt::numutils.c
deleted file mode 100644
index 3a9c84d71961..000000000000
--- a/databases/postgresql74-server/files/patch-src::backend::utils::adt::numutils.c
+++ /dev/null
@@ -1,29 +0,0 @@
-Index: src/backend/utils/adt/numutils.c
-===================================================================
-RCS file: /cvsroot/pgsql-server/src/backend/utils/adt/numutils.c,v
-retrieving revision 1.54
-diff -c -c -r1.54 numutils.c
-*** src/backend/utils/adt/numutils.c	4 Sep 2002 20:31:28 -0000	1.54
---- src/backend/utils/adt/numutils.c	19 Dec 2002 17:10:56 -0000
-***************
-*** 70,76 ****
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 		elog(ERROR, "pg_atoi: zero-length string");
-  	else
-  		l = strtol(s, &badp, 10);
-  
---- 70,80 ----
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 	{
-! 		/* 7.3.X workaround for broken apps, bjm  2002-12-19 */
-! 		elog(WARNING, "pg_atoi: zero-length string");
-! 		l = (long) 0;
-! 	}
-  	else
-  		l = strtol(s, &badp, 10);
-  
-
diff --git a/databases/postgresql80-server/Makefile b/databases/postgresql80-server/Makefile
index c204fbcacebe..3465ae6d39fd 100644
--- a/databases/postgresql80-server/Makefile
+++ b/databases/postgresql80-server/Makefile
@@ -6,8 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.3.2
-PORTREVISION=	1
+PORTVERSION?=	7.3.3
 CATEGORIES?=	databases
 MASTER_SITES=	ftp://ftp3.us.postgresql.org/pub/postgresql/%SUBDIR%/ \
 		ftp://ftp5.us.postgresql.org/pub/PostgreSQL/%SUBDIR%/ \
@@ -47,6 +46,7 @@ INSTALLS_SHLIB=	YES
 
 CONFIGURE_ARGS=	--with-libraries=${LOCALBASE}/lib \
 		--with-includes=${LOCALBASE}/include
+CONFIGURE_ENV=	LDFLAGS="${LDFLAGS}"
 
 .if !defined(WITHOUT_GNUGETOPT)
 LIB_DEPENDS=	gnugetopt:${PORTSDIR}/devel/libgnugetopt
@@ -98,19 +98,22 @@ LIB_DEPENDS+=	krb5.3:${PORTSDIR}/security/krb5
 WITH_KRB5=	yes
 .endif
 
+.include <bsd.port.pre.mk>
 .if defined(WITH_KRB5)
 CONFIGURE_ARGS+=	--with-krb5="`${KRB5CONF} --prefix krb5`"
 LDFLAGS+=	`${KRB5CONF} --libs krb5`
-.endif
-
-.if defined(WITH_OPTIMIZED_CFLAGS)
-CFLAGS+= -O3 -funroll-loops
+CONFIGURE_ENV=  LDFLAGS="${LDFLAGS}"
 .endif
 
 .if defined(WITH_TESTS)
 DISTFILES+=	postgresql-test-${PORTVERSION}${EXTRACT_SUFX}
 .endif
 
+.if defined(WITH_LIBC_R)
+CFLAGS+=	${PTHREAD_CFLAGS}
+LDFLAGS+=	${PTHREAD_LIBS}
+.endif
+
 MAN1=		clusterdb.1 createdb.1 createlang.1 createuser.1 dropdb.1 \
 		droplang.1 dropuser.1 ecpg.1 initdb.1 initlocation.1 ipcclean.1 \
 		pg_config.1 pg_controldata.1 pg_ctl.1 pg_dump.1 pg_dumpall.1 \
@@ -140,7 +143,7 @@ MAN7=		abort.7 alter_database.7 alter_group.7 alter_table.7 \
 		truncate.7 unlisten.7 update.7 vacuum.7
 
 pre-everything::
-	@${SH} ${PKGDIR}/pkg-install ${PORTNAME} BACKUPWARNING
+	@${SH} ${PKGINSTALL} ${PORTNAME} BACKUPWARNING
 	@${ECHO} ""
 	@${ECHO} "${PORTNAME} has several tunables that can be used to configure PostgreSQL:"
 	@${ECHO} ""
@@ -157,6 +160,8 @@ pre-everything::
 	@${ECHO} "	WITH_DEBUG		Builds with debugging symbols"
 	@${ECHO} "	WITH_TESTS		Allows the use of a \"check\" target"
 	@${ECHO} "				building the module"
+	@${ECHO} "	WITH_LIBC_R		Link the binaries with libc_r."
+	@${ECHO} "				Needed to run plpython"
 	@${ECHO} ""
 .if defined(WITH_MIT_KRB5) && defined(WITH_HEIMDAL_KRB5)
 	@${ECHO} "WITH_MIT_KRB5 and WITH_HEIMDAL_KRB5 are mutually exclusive."
@@ -185,7 +190,7 @@ do-install:
 .else
 pre-install:
 	@ ${SETENV} PKG_PREFIX=${PREFIX} \
-		${SH} ${PKGDIR}/pkg-install ${PORTNAME} PRE-INSTALL
+		${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL
 .endif
 
 post-install:
@@ -225,5 +230,5 @@ check:
 	 fi
 .endif
 
-.include <bsd.port.mk>
+.include <bsd.port.post.mk>
 .endif
diff --git a/databases/postgresql80-server/distinfo b/databases/postgresql80-server/distinfo
index 934a97ecd98a..d95d2a295743 100644
--- a/databases/postgresql80-server/distinfo
+++ b/databases/postgresql80-server/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.3.2.tar.gz) = 2cd99c2d455c653fdfe74f5dd658d15c
-MD5 (postgresql/postgresql-opt-7.3.2.tar.gz) = c54a5b0be96b60259bd37f6a5b60abb9
-MD5 (postgresql/postgresql-test-7.3.2.tar.gz) = 9818eb4c50a2fe9057c7df5ae270972c
-MD5 (postgresql/postgresql-docs-7.3.2.tar.gz) = e91131aeed6919a00ab231db2298bd0b
+MD5 (postgresql/postgresql-base-7.3.3.tar.gz) = 4f5830d3effa8b00b22cc13597030b2f
+MD5 (postgresql/postgresql-opt-7.3.3.tar.gz) = b0b7f07c6bba1813b18e9901e481599d
+MD5 (postgresql/postgresql-docs-7.3.3.tar.gz) = 5009a3233f3ecf80369a5613298fbb8c
+MD5 (postgresql/postgresql-test-7.3.3.tar.gz) = d029272601b4d8bfac3b6be843f0064b
diff --git a/databases/postgresql80-server/files/patch-src::backend::utils::adt::numutils.c b/databases/postgresql80-server/files/patch-src::backend::utils::adt::numutils.c
deleted file mode 100644
index 3a9c84d71961..000000000000
--- a/databases/postgresql80-server/files/patch-src::backend::utils::adt::numutils.c
+++ /dev/null
@@ -1,29 +0,0 @@
-Index: src/backend/utils/adt/numutils.c
-===================================================================
-RCS file: /cvsroot/pgsql-server/src/backend/utils/adt/numutils.c,v
-retrieving revision 1.54
-diff -c -c -r1.54 numutils.c
-*** src/backend/utils/adt/numutils.c	4 Sep 2002 20:31:28 -0000	1.54
---- src/backend/utils/adt/numutils.c	19 Dec 2002 17:10:56 -0000
-***************
-*** 70,76 ****
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 		elog(ERROR, "pg_atoi: zero-length string");
-  	else
-  		l = strtol(s, &badp, 10);
-  
---- 70,80 ----
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 	{
-! 		/* 7.3.X workaround for broken apps, bjm  2002-12-19 */
-! 		elog(WARNING, "pg_atoi: zero-length string");
-! 		l = (long) 0;
-! 	}
-  	else
-  		l = strtol(s, &badp, 10);
-  
-
diff --git a/databases/postgresql81-server/Makefile b/databases/postgresql81-server/Makefile
index c204fbcacebe..3465ae6d39fd 100644
--- a/databases/postgresql81-server/Makefile
+++ b/databases/postgresql81-server/Makefile
@@ -6,8 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.3.2
-PORTREVISION=	1
+PORTVERSION?=	7.3.3
 CATEGORIES?=	databases
 MASTER_SITES=	ftp://ftp3.us.postgresql.org/pub/postgresql/%SUBDIR%/ \
 		ftp://ftp5.us.postgresql.org/pub/PostgreSQL/%SUBDIR%/ \
@@ -47,6 +46,7 @@ INSTALLS_SHLIB=	YES
 
 CONFIGURE_ARGS=	--with-libraries=${LOCALBASE}/lib \
 		--with-includes=${LOCALBASE}/include
+CONFIGURE_ENV=	LDFLAGS="${LDFLAGS}"
 
 .if !defined(WITHOUT_GNUGETOPT)
 LIB_DEPENDS=	gnugetopt:${PORTSDIR}/devel/libgnugetopt
@@ -98,19 +98,22 @@ LIB_DEPENDS+=	krb5.3:${PORTSDIR}/security/krb5
 WITH_KRB5=	yes
 .endif
 
+.include <bsd.port.pre.mk>
 .if defined(WITH_KRB5)
 CONFIGURE_ARGS+=	--with-krb5="`${KRB5CONF} --prefix krb5`"
 LDFLAGS+=	`${KRB5CONF} --libs krb5`
-.endif
-
-.if defined(WITH_OPTIMIZED_CFLAGS)
-CFLAGS+= -O3 -funroll-loops
+CONFIGURE_ENV=  LDFLAGS="${LDFLAGS}"
 .endif
 
 .if defined(WITH_TESTS)
 DISTFILES+=	postgresql-test-${PORTVERSION}${EXTRACT_SUFX}
 .endif
 
+.if defined(WITH_LIBC_R)
+CFLAGS+=	${PTHREAD_CFLAGS}
+LDFLAGS+=	${PTHREAD_LIBS}
+.endif
+
 MAN1=		clusterdb.1 createdb.1 createlang.1 createuser.1 dropdb.1 \
 		droplang.1 dropuser.1 ecpg.1 initdb.1 initlocation.1 ipcclean.1 \
 		pg_config.1 pg_controldata.1 pg_ctl.1 pg_dump.1 pg_dumpall.1 \
@@ -140,7 +143,7 @@ MAN7=		abort.7 alter_database.7 alter_group.7 alter_table.7 \
 		truncate.7 unlisten.7 update.7 vacuum.7
 
 pre-everything::
-	@${SH} ${PKGDIR}/pkg-install ${PORTNAME} BACKUPWARNING
+	@${SH} ${PKGINSTALL} ${PORTNAME} BACKUPWARNING
 	@${ECHO} ""
 	@${ECHO} "${PORTNAME} has several tunables that can be used to configure PostgreSQL:"
 	@${ECHO} ""
@@ -157,6 +160,8 @@ pre-everything::
 	@${ECHO} "	WITH_DEBUG		Builds with debugging symbols"
 	@${ECHO} "	WITH_TESTS		Allows the use of a \"check\" target"
 	@${ECHO} "				building the module"
+	@${ECHO} "	WITH_LIBC_R		Link the binaries with libc_r."
+	@${ECHO} "				Needed to run plpython"
 	@${ECHO} ""
 .if defined(WITH_MIT_KRB5) && defined(WITH_HEIMDAL_KRB5)
 	@${ECHO} "WITH_MIT_KRB5 and WITH_HEIMDAL_KRB5 are mutually exclusive."
@@ -185,7 +190,7 @@ do-install:
 .else
 pre-install:
 	@ ${SETENV} PKG_PREFIX=${PREFIX} \
-		${SH} ${PKGDIR}/pkg-install ${PORTNAME} PRE-INSTALL
+		${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL
 .endif
 
 post-install:
@@ -225,5 +230,5 @@ check:
 	 fi
 .endif
 
-.include <bsd.port.mk>
+.include <bsd.port.post.mk>
 .endif
diff --git a/databases/postgresql81-server/distinfo b/databases/postgresql81-server/distinfo
index 934a97ecd98a..d95d2a295743 100644
--- a/databases/postgresql81-server/distinfo
+++ b/databases/postgresql81-server/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.3.2.tar.gz) = 2cd99c2d455c653fdfe74f5dd658d15c
-MD5 (postgresql/postgresql-opt-7.3.2.tar.gz) = c54a5b0be96b60259bd37f6a5b60abb9
-MD5 (postgresql/postgresql-test-7.3.2.tar.gz) = 9818eb4c50a2fe9057c7df5ae270972c
-MD5 (postgresql/postgresql-docs-7.3.2.tar.gz) = e91131aeed6919a00ab231db2298bd0b
+MD5 (postgresql/postgresql-base-7.3.3.tar.gz) = 4f5830d3effa8b00b22cc13597030b2f
+MD5 (postgresql/postgresql-opt-7.3.3.tar.gz) = b0b7f07c6bba1813b18e9901e481599d
+MD5 (postgresql/postgresql-docs-7.3.3.tar.gz) = 5009a3233f3ecf80369a5613298fbb8c
+MD5 (postgresql/postgresql-test-7.3.3.tar.gz) = d029272601b4d8bfac3b6be843f0064b
diff --git a/databases/postgresql81-server/files/patch-src::backend::utils::adt::numutils.c b/databases/postgresql81-server/files/patch-src::backend::utils::adt::numutils.c
deleted file mode 100644
index 3a9c84d71961..000000000000
--- a/databases/postgresql81-server/files/patch-src::backend::utils::adt::numutils.c
+++ /dev/null
@@ -1,29 +0,0 @@
-Index: src/backend/utils/adt/numutils.c
-===================================================================
-RCS file: /cvsroot/pgsql-server/src/backend/utils/adt/numutils.c,v
-retrieving revision 1.54
-diff -c -c -r1.54 numutils.c
-*** src/backend/utils/adt/numutils.c	4 Sep 2002 20:31:28 -0000	1.54
---- src/backend/utils/adt/numutils.c	19 Dec 2002 17:10:56 -0000
-***************
-*** 70,76 ****
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 		elog(ERROR, "pg_atoi: zero-length string");
-  	else
-  		l = strtol(s, &badp, 10);
-  
---- 70,80 ----
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 	{
-! 		/* 7.3.X workaround for broken apps, bjm  2002-12-19 */
-! 		elog(WARNING, "pg_atoi: zero-length string");
-! 		l = (long) 0;
-! 	}
-  	else
-  		l = strtol(s, &badp, 10);
-  
-
diff --git a/databases/postgresql82-server/Makefile b/databases/postgresql82-server/Makefile
index c204fbcacebe..3465ae6d39fd 100644
--- a/databases/postgresql82-server/Makefile
+++ b/databases/postgresql82-server/Makefile
@@ -6,8 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.3.2
-PORTREVISION=	1
+PORTVERSION?=	7.3.3
 CATEGORIES?=	databases
 MASTER_SITES=	ftp://ftp3.us.postgresql.org/pub/postgresql/%SUBDIR%/ \
 		ftp://ftp5.us.postgresql.org/pub/PostgreSQL/%SUBDIR%/ \
@@ -47,6 +46,7 @@ INSTALLS_SHLIB=	YES
 
 CONFIGURE_ARGS=	--with-libraries=${LOCALBASE}/lib \
 		--with-includes=${LOCALBASE}/include
+CONFIGURE_ENV=	LDFLAGS="${LDFLAGS}"
 
 .if !defined(WITHOUT_GNUGETOPT)
 LIB_DEPENDS=	gnugetopt:${PORTSDIR}/devel/libgnugetopt
@@ -98,19 +98,22 @@ LIB_DEPENDS+=	krb5.3:${PORTSDIR}/security/krb5
 WITH_KRB5=	yes
 .endif
 
+.include <bsd.port.pre.mk>
 .if defined(WITH_KRB5)
 CONFIGURE_ARGS+=	--with-krb5="`${KRB5CONF} --prefix krb5`"
 LDFLAGS+=	`${KRB5CONF} --libs krb5`
-.endif
-
-.if defined(WITH_OPTIMIZED_CFLAGS)
-CFLAGS+= -O3 -funroll-loops
+CONFIGURE_ENV=  LDFLAGS="${LDFLAGS}"
 .endif
 
 .if defined(WITH_TESTS)
 DISTFILES+=	postgresql-test-${PORTVERSION}${EXTRACT_SUFX}
 .endif
 
+.if defined(WITH_LIBC_R)
+CFLAGS+=	${PTHREAD_CFLAGS}
+LDFLAGS+=	${PTHREAD_LIBS}
+.endif
+
 MAN1=		clusterdb.1 createdb.1 createlang.1 createuser.1 dropdb.1 \
 		droplang.1 dropuser.1 ecpg.1 initdb.1 initlocation.1 ipcclean.1 \
 		pg_config.1 pg_controldata.1 pg_ctl.1 pg_dump.1 pg_dumpall.1 \
@@ -140,7 +143,7 @@ MAN7=		abort.7 alter_database.7 alter_group.7 alter_table.7 \
 		truncate.7 unlisten.7 update.7 vacuum.7
 
 pre-everything::
-	@${SH} ${PKGDIR}/pkg-install ${PORTNAME} BACKUPWARNING
+	@${SH} ${PKGINSTALL} ${PORTNAME} BACKUPWARNING
 	@${ECHO} ""
 	@${ECHO} "${PORTNAME} has several tunables that can be used to configure PostgreSQL:"
 	@${ECHO} ""
@@ -157,6 +160,8 @@ pre-everything::
 	@${ECHO} "	WITH_DEBUG		Builds with debugging symbols"
 	@${ECHO} "	WITH_TESTS		Allows the use of a \"check\" target"
 	@${ECHO} "				building the module"
+	@${ECHO} "	WITH_LIBC_R		Link the binaries with libc_r."
+	@${ECHO} "				Needed to run plpython"
 	@${ECHO} ""
 .if defined(WITH_MIT_KRB5) && defined(WITH_HEIMDAL_KRB5)
 	@${ECHO} "WITH_MIT_KRB5 and WITH_HEIMDAL_KRB5 are mutually exclusive."
@@ -185,7 +190,7 @@ do-install:
 .else
 pre-install:
 	@ ${SETENV} PKG_PREFIX=${PREFIX} \
-		${SH} ${PKGDIR}/pkg-install ${PORTNAME} PRE-INSTALL
+		${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL
 .endif
 
 post-install:
@@ -225,5 +230,5 @@ check:
 	 fi
 .endif
 
-.include <bsd.port.mk>
+.include <bsd.port.post.mk>
 .endif
diff --git a/databases/postgresql82-server/distinfo b/databases/postgresql82-server/distinfo
index 934a97ecd98a..d95d2a295743 100644
--- a/databases/postgresql82-server/distinfo
+++ b/databases/postgresql82-server/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.3.2.tar.gz) = 2cd99c2d455c653fdfe74f5dd658d15c
-MD5 (postgresql/postgresql-opt-7.3.2.tar.gz) = c54a5b0be96b60259bd37f6a5b60abb9
-MD5 (postgresql/postgresql-test-7.3.2.tar.gz) = 9818eb4c50a2fe9057c7df5ae270972c
-MD5 (postgresql/postgresql-docs-7.3.2.tar.gz) = e91131aeed6919a00ab231db2298bd0b
+MD5 (postgresql/postgresql-base-7.3.3.tar.gz) = 4f5830d3effa8b00b22cc13597030b2f
+MD5 (postgresql/postgresql-opt-7.3.3.tar.gz) = b0b7f07c6bba1813b18e9901e481599d
+MD5 (postgresql/postgresql-docs-7.3.3.tar.gz) = 5009a3233f3ecf80369a5613298fbb8c
+MD5 (postgresql/postgresql-test-7.3.3.tar.gz) = d029272601b4d8bfac3b6be843f0064b
diff --git a/databases/postgresql82-server/files/patch-src::backend::utils::adt::numutils.c b/databases/postgresql82-server/files/patch-src::backend::utils::adt::numutils.c
deleted file mode 100644
index 3a9c84d71961..000000000000
--- a/databases/postgresql82-server/files/patch-src::backend::utils::adt::numutils.c
+++ /dev/null
@@ -1,29 +0,0 @@
-Index: src/backend/utils/adt/numutils.c
-===================================================================
-RCS file: /cvsroot/pgsql-server/src/backend/utils/adt/numutils.c,v
-retrieving revision 1.54
-diff -c -c -r1.54 numutils.c
-*** src/backend/utils/adt/numutils.c	4 Sep 2002 20:31:28 -0000	1.54
---- src/backend/utils/adt/numutils.c	19 Dec 2002 17:10:56 -0000
-***************
-*** 70,76 ****
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 		elog(ERROR, "pg_atoi: zero-length string");
-  	else
-  		l = strtol(s, &badp, 10);
-  
---- 70,80 ----
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 	{
-! 		/* 7.3.X workaround for broken apps, bjm  2002-12-19 */
-! 		elog(WARNING, "pg_atoi: zero-length string");
-! 		l = (long) 0;
-! 	}
-  	else
-  		l = strtol(s, &badp, 10);
-  
-
diff --git a/databases/postgresql83-server/Makefile b/databases/postgresql83-server/Makefile
index c204fbcacebe..3465ae6d39fd 100644
--- a/databases/postgresql83-server/Makefile
+++ b/databases/postgresql83-server/Makefile
@@ -6,8 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.3.2
-PORTREVISION=	1
+PORTVERSION?=	7.3.3
 CATEGORIES?=	databases
 MASTER_SITES=	ftp://ftp3.us.postgresql.org/pub/postgresql/%SUBDIR%/ \
 		ftp://ftp5.us.postgresql.org/pub/PostgreSQL/%SUBDIR%/ \
@@ -47,6 +46,7 @@ INSTALLS_SHLIB=	YES
 
 CONFIGURE_ARGS=	--with-libraries=${LOCALBASE}/lib \
 		--with-includes=${LOCALBASE}/include
+CONFIGURE_ENV=	LDFLAGS="${LDFLAGS}"
 
 .if !defined(WITHOUT_GNUGETOPT)
 LIB_DEPENDS=	gnugetopt:${PORTSDIR}/devel/libgnugetopt
@@ -98,19 +98,22 @@ LIB_DEPENDS+=	krb5.3:${PORTSDIR}/security/krb5
 WITH_KRB5=	yes
 .endif
 
+.include <bsd.port.pre.mk>
 .if defined(WITH_KRB5)
 CONFIGURE_ARGS+=	--with-krb5="`${KRB5CONF} --prefix krb5`"
 LDFLAGS+=	`${KRB5CONF} --libs krb5`
-.endif
-
-.if defined(WITH_OPTIMIZED_CFLAGS)
-CFLAGS+= -O3 -funroll-loops
+CONFIGURE_ENV=  LDFLAGS="${LDFLAGS}"
 .endif
 
 .if defined(WITH_TESTS)
 DISTFILES+=	postgresql-test-${PORTVERSION}${EXTRACT_SUFX}
 .endif
 
+.if defined(WITH_LIBC_R)
+CFLAGS+=	${PTHREAD_CFLAGS}
+LDFLAGS+=	${PTHREAD_LIBS}
+.endif
+
 MAN1=		clusterdb.1 createdb.1 createlang.1 createuser.1 dropdb.1 \
 		droplang.1 dropuser.1 ecpg.1 initdb.1 initlocation.1 ipcclean.1 \
 		pg_config.1 pg_controldata.1 pg_ctl.1 pg_dump.1 pg_dumpall.1 \
@@ -140,7 +143,7 @@ MAN7=		abort.7 alter_database.7 alter_group.7 alter_table.7 \
 		truncate.7 unlisten.7 update.7 vacuum.7
 
 pre-everything::
-	@${SH} ${PKGDIR}/pkg-install ${PORTNAME} BACKUPWARNING
+	@${SH} ${PKGINSTALL} ${PORTNAME} BACKUPWARNING
 	@${ECHO} ""
 	@${ECHO} "${PORTNAME} has several tunables that can be used to configure PostgreSQL:"
 	@${ECHO} ""
@@ -157,6 +160,8 @@ pre-everything::
 	@${ECHO} "	WITH_DEBUG		Builds with debugging symbols"
 	@${ECHO} "	WITH_TESTS		Allows the use of a \"check\" target"
 	@${ECHO} "				building the module"
+	@${ECHO} "	WITH_LIBC_R		Link the binaries with libc_r."
+	@${ECHO} "				Needed to run plpython"
 	@${ECHO} ""
 .if defined(WITH_MIT_KRB5) && defined(WITH_HEIMDAL_KRB5)
 	@${ECHO} "WITH_MIT_KRB5 and WITH_HEIMDAL_KRB5 are mutually exclusive."
@@ -185,7 +190,7 @@ do-install:
 .else
 pre-install:
 	@ ${SETENV} PKG_PREFIX=${PREFIX} \
-		${SH} ${PKGDIR}/pkg-install ${PORTNAME} PRE-INSTALL
+		${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL
 .endif
 
 post-install:
@@ -225,5 +230,5 @@ check:
 	 fi
 .endif
 
-.include <bsd.port.mk>
+.include <bsd.port.post.mk>
 .endif
diff --git a/databases/postgresql83-server/distinfo b/databases/postgresql83-server/distinfo
index 934a97ecd98a..d95d2a295743 100644
--- a/databases/postgresql83-server/distinfo
+++ b/databases/postgresql83-server/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.3.2.tar.gz) = 2cd99c2d455c653fdfe74f5dd658d15c
-MD5 (postgresql/postgresql-opt-7.3.2.tar.gz) = c54a5b0be96b60259bd37f6a5b60abb9
-MD5 (postgresql/postgresql-test-7.3.2.tar.gz) = 9818eb4c50a2fe9057c7df5ae270972c
-MD5 (postgresql/postgresql-docs-7.3.2.tar.gz) = e91131aeed6919a00ab231db2298bd0b
+MD5 (postgresql/postgresql-base-7.3.3.tar.gz) = 4f5830d3effa8b00b22cc13597030b2f
+MD5 (postgresql/postgresql-opt-7.3.3.tar.gz) = b0b7f07c6bba1813b18e9901e481599d
+MD5 (postgresql/postgresql-docs-7.3.3.tar.gz) = 5009a3233f3ecf80369a5613298fbb8c
+MD5 (postgresql/postgresql-test-7.3.3.tar.gz) = d029272601b4d8bfac3b6be843f0064b
diff --git a/databases/postgresql83-server/files/patch-src::backend::utils::adt::numutils.c b/databases/postgresql83-server/files/patch-src::backend::utils::adt::numutils.c
deleted file mode 100644
index 3a9c84d71961..000000000000
--- a/databases/postgresql83-server/files/patch-src::backend::utils::adt::numutils.c
+++ /dev/null
@@ -1,29 +0,0 @@
-Index: src/backend/utils/adt/numutils.c
-===================================================================
-RCS file: /cvsroot/pgsql-server/src/backend/utils/adt/numutils.c,v
-retrieving revision 1.54
-diff -c -c -r1.54 numutils.c
-*** src/backend/utils/adt/numutils.c	4 Sep 2002 20:31:28 -0000	1.54
---- src/backend/utils/adt/numutils.c	19 Dec 2002 17:10:56 -0000
-***************
-*** 70,76 ****
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 		elog(ERROR, "pg_atoi: zero-length string");
-  	else
-  		l = strtol(s, &badp, 10);
-  
---- 70,80 ----
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 	{
-! 		/* 7.3.X workaround for broken apps, bjm  2002-12-19 */
-! 		elog(WARNING, "pg_atoi: zero-length string");
-! 		l = (long) 0;
-! 	}
-  	else
-  		l = strtol(s, &badp, 10);
-  
-
diff --git a/databases/postgresql84-server/Makefile b/databases/postgresql84-server/Makefile
index c204fbcacebe..3465ae6d39fd 100644
--- a/databases/postgresql84-server/Makefile
+++ b/databases/postgresql84-server/Makefile
@@ -6,8 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.3.2
-PORTREVISION=	1
+PORTVERSION?=	7.3.3
 CATEGORIES?=	databases
 MASTER_SITES=	ftp://ftp3.us.postgresql.org/pub/postgresql/%SUBDIR%/ \
 		ftp://ftp5.us.postgresql.org/pub/PostgreSQL/%SUBDIR%/ \
@@ -47,6 +46,7 @@ INSTALLS_SHLIB=	YES
 
 CONFIGURE_ARGS=	--with-libraries=${LOCALBASE}/lib \
 		--with-includes=${LOCALBASE}/include
+CONFIGURE_ENV=	LDFLAGS="${LDFLAGS}"
 
 .if !defined(WITHOUT_GNUGETOPT)
 LIB_DEPENDS=	gnugetopt:${PORTSDIR}/devel/libgnugetopt
@@ -98,19 +98,22 @@ LIB_DEPENDS+=	krb5.3:${PORTSDIR}/security/krb5
 WITH_KRB5=	yes
 .endif
 
+.include <bsd.port.pre.mk>
 .if defined(WITH_KRB5)
 CONFIGURE_ARGS+=	--with-krb5="`${KRB5CONF} --prefix krb5`"
 LDFLAGS+=	`${KRB5CONF} --libs krb5`
-.endif
-
-.if defined(WITH_OPTIMIZED_CFLAGS)
-CFLAGS+= -O3 -funroll-loops
+CONFIGURE_ENV=  LDFLAGS="${LDFLAGS}"
 .endif
 
 .if defined(WITH_TESTS)
 DISTFILES+=	postgresql-test-${PORTVERSION}${EXTRACT_SUFX}
 .endif
 
+.if defined(WITH_LIBC_R)
+CFLAGS+=	${PTHREAD_CFLAGS}
+LDFLAGS+=	${PTHREAD_LIBS}
+.endif
+
 MAN1=		clusterdb.1 createdb.1 createlang.1 createuser.1 dropdb.1 \
 		droplang.1 dropuser.1 ecpg.1 initdb.1 initlocation.1 ipcclean.1 \
 		pg_config.1 pg_controldata.1 pg_ctl.1 pg_dump.1 pg_dumpall.1 \
@@ -140,7 +143,7 @@ MAN7=		abort.7 alter_database.7 alter_group.7 alter_table.7 \
 		truncate.7 unlisten.7 update.7 vacuum.7
 
 pre-everything::
-	@${SH} ${PKGDIR}/pkg-install ${PORTNAME} BACKUPWARNING
+	@${SH} ${PKGINSTALL} ${PORTNAME} BACKUPWARNING
 	@${ECHO} ""
 	@${ECHO} "${PORTNAME} has several tunables that can be used to configure PostgreSQL:"
 	@${ECHO} ""
@@ -157,6 +160,8 @@ pre-everything::
 	@${ECHO} "	WITH_DEBUG		Builds with debugging symbols"
 	@${ECHO} "	WITH_TESTS		Allows the use of a \"check\" target"
 	@${ECHO} "				building the module"
+	@${ECHO} "	WITH_LIBC_R		Link the binaries with libc_r."
+	@${ECHO} "				Needed to run plpython"
 	@${ECHO} ""
 .if defined(WITH_MIT_KRB5) && defined(WITH_HEIMDAL_KRB5)
 	@${ECHO} "WITH_MIT_KRB5 and WITH_HEIMDAL_KRB5 are mutually exclusive."
@@ -185,7 +190,7 @@ do-install:
 .else
 pre-install:
 	@ ${SETENV} PKG_PREFIX=${PREFIX} \
-		${SH} ${PKGDIR}/pkg-install ${PORTNAME} PRE-INSTALL
+		${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL
 .endif
 
 post-install:
@@ -225,5 +230,5 @@ check:
 	 fi
 .endif
 
-.include <bsd.port.mk>
+.include <bsd.port.post.mk>
 .endif
diff --git a/databases/postgresql84-server/distinfo b/databases/postgresql84-server/distinfo
index 934a97ecd98a..d95d2a295743 100644
--- a/databases/postgresql84-server/distinfo
+++ b/databases/postgresql84-server/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.3.2.tar.gz) = 2cd99c2d455c653fdfe74f5dd658d15c
-MD5 (postgresql/postgresql-opt-7.3.2.tar.gz) = c54a5b0be96b60259bd37f6a5b60abb9
-MD5 (postgresql/postgresql-test-7.3.2.tar.gz) = 9818eb4c50a2fe9057c7df5ae270972c
-MD5 (postgresql/postgresql-docs-7.3.2.tar.gz) = e91131aeed6919a00ab231db2298bd0b
+MD5 (postgresql/postgresql-base-7.3.3.tar.gz) = 4f5830d3effa8b00b22cc13597030b2f
+MD5 (postgresql/postgresql-opt-7.3.3.tar.gz) = b0b7f07c6bba1813b18e9901e481599d
+MD5 (postgresql/postgresql-docs-7.3.3.tar.gz) = 5009a3233f3ecf80369a5613298fbb8c
+MD5 (postgresql/postgresql-test-7.3.3.tar.gz) = d029272601b4d8bfac3b6be843f0064b
diff --git a/databases/postgresql84-server/files/patch-src::backend::utils::adt::numutils.c b/databases/postgresql84-server/files/patch-src::backend::utils::adt::numutils.c
deleted file mode 100644
index 3a9c84d71961..000000000000
--- a/databases/postgresql84-server/files/patch-src::backend::utils::adt::numutils.c
+++ /dev/null
@@ -1,29 +0,0 @@
-Index: src/backend/utils/adt/numutils.c
-===================================================================
-RCS file: /cvsroot/pgsql-server/src/backend/utils/adt/numutils.c,v
-retrieving revision 1.54
-diff -c -c -r1.54 numutils.c
-*** src/backend/utils/adt/numutils.c	4 Sep 2002 20:31:28 -0000	1.54
---- src/backend/utils/adt/numutils.c	19 Dec 2002 17:10:56 -0000
-***************
-*** 70,76 ****
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 		elog(ERROR, "pg_atoi: zero-length string");
-  	else
-  		l = strtol(s, &badp, 10);
-  
---- 70,80 ----
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 	{
-! 		/* 7.3.X workaround for broken apps, bjm  2002-12-19 */
-! 		elog(WARNING, "pg_atoi: zero-length string");
-! 		l = (long) 0;
-! 	}
-  	else
-  		l = strtol(s, &badp, 10);
-  
-
diff --git a/databases/postgresql90-server/Makefile b/databases/postgresql90-server/Makefile
index c204fbcacebe..3465ae6d39fd 100644
--- a/databases/postgresql90-server/Makefile
+++ b/databases/postgresql90-server/Makefile
@@ -6,8 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.3.2
-PORTREVISION=	1
+PORTVERSION?=	7.3.3
 CATEGORIES?=	databases
 MASTER_SITES=	ftp://ftp3.us.postgresql.org/pub/postgresql/%SUBDIR%/ \
 		ftp://ftp5.us.postgresql.org/pub/PostgreSQL/%SUBDIR%/ \
@@ -47,6 +46,7 @@ INSTALLS_SHLIB=	YES
 
 CONFIGURE_ARGS=	--with-libraries=${LOCALBASE}/lib \
 		--with-includes=${LOCALBASE}/include
+CONFIGURE_ENV=	LDFLAGS="${LDFLAGS}"
 
 .if !defined(WITHOUT_GNUGETOPT)
 LIB_DEPENDS=	gnugetopt:${PORTSDIR}/devel/libgnugetopt
@@ -98,19 +98,22 @@ LIB_DEPENDS+=	krb5.3:${PORTSDIR}/security/krb5
 WITH_KRB5=	yes
 .endif
 
+.include <bsd.port.pre.mk>
 .if defined(WITH_KRB5)
 CONFIGURE_ARGS+=	--with-krb5="`${KRB5CONF} --prefix krb5`"
 LDFLAGS+=	`${KRB5CONF} --libs krb5`
-.endif
-
-.if defined(WITH_OPTIMIZED_CFLAGS)
-CFLAGS+= -O3 -funroll-loops
+CONFIGURE_ENV=  LDFLAGS="${LDFLAGS}"
 .endif
 
 .if defined(WITH_TESTS)
 DISTFILES+=	postgresql-test-${PORTVERSION}${EXTRACT_SUFX}
 .endif
 
+.if defined(WITH_LIBC_R)
+CFLAGS+=	${PTHREAD_CFLAGS}
+LDFLAGS+=	${PTHREAD_LIBS}
+.endif
+
 MAN1=		clusterdb.1 createdb.1 createlang.1 createuser.1 dropdb.1 \
 		droplang.1 dropuser.1 ecpg.1 initdb.1 initlocation.1 ipcclean.1 \
 		pg_config.1 pg_controldata.1 pg_ctl.1 pg_dump.1 pg_dumpall.1 \
@@ -140,7 +143,7 @@ MAN7=		abort.7 alter_database.7 alter_group.7 alter_table.7 \
 		truncate.7 unlisten.7 update.7 vacuum.7
 
 pre-everything::
-	@${SH} ${PKGDIR}/pkg-install ${PORTNAME} BACKUPWARNING
+	@${SH} ${PKGINSTALL} ${PORTNAME} BACKUPWARNING
 	@${ECHO} ""
 	@${ECHO} "${PORTNAME} has several tunables that can be used to configure PostgreSQL:"
 	@${ECHO} ""
@@ -157,6 +160,8 @@ pre-everything::
 	@${ECHO} "	WITH_DEBUG		Builds with debugging symbols"
 	@${ECHO} "	WITH_TESTS		Allows the use of a \"check\" target"
 	@${ECHO} "				building the module"
+	@${ECHO} "	WITH_LIBC_R		Link the binaries with libc_r."
+	@${ECHO} "				Needed to run plpython"
 	@${ECHO} ""
 .if defined(WITH_MIT_KRB5) && defined(WITH_HEIMDAL_KRB5)
 	@${ECHO} "WITH_MIT_KRB5 and WITH_HEIMDAL_KRB5 are mutually exclusive."
@@ -185,7 +190,7 @@ do-install:
 .else
 pre-install:
 	@ ${SETENV} PKG_PREFIX=${PREFIX} \
-		${SH} ${PKGDIR}/pkg-install ${PORTNAME} PRE-INSTALL
+		${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL
 .endif
 
 post-install:
@@ -225,5 +230,5 @@ check:
 	 fi
 .endif
 
-.include <bsd.port.mk>
+.include <bsd.port.post.mk>
 .endif
diff --git a/databases/postgresql90-server/distinfo b/databases/postgresql90-server/distinfo
index 934a97ecd98a..d95d2a295743 100644
--- a/databases/postgresql90-server/distinfo
+++ b/databases/postgresql90-server/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.3.2.tar.gz) = 2cd99c2d455c653fdfe74f5dd658d15c
-MD5 (postgresql/postgresql-opt-7.3.2.tar.gz) = c54a5b0be96b60259bd37f6a5b60abb9
-MD5 (postgresql/postgresql-test-7.3.2.tar.gz) = 9818eb4c50a2fe9057c7df5ae270972c
-MD5 (postgresql/postgresql-docs-7.3.2.tar.gz) = e91131aeed6919a00ab231db2298bd0b
+MD5 (postgresql/postgresql-base-7.3.3.tar.gz) = 4f5830d3effa8b00b22cc13597030b2f
+MD5 (postgresql/postgresql-opt-7.3.3.tar.gz) = b0b7f07c6bba1813b18e9901e481599d
+MD5 (postgresql/postgresql-docs-7.3.3.tar.gz) = 5009a3233f3ecf80369a5613298fbb8c
+MD5 (postgresql/postgresql-test-7.3.3.tar.gz) = d029272601b4d8bfac3b6be843f0064b
diff --git a/databases/postgresql90-server/files/patch-src::backend::utils::adt::numutils.c b/databases/postgresql90-server/files/patch-src::backend::utils::adt::numutils.c
deleted file mode 100644
index 3a9c84d71961..000000000000
--- a/databases/postgresql90-server/files/patch-src::backend::utils::adt::numutils.c
+++ /dev/null
@@ -1,29 +0,0 @@
-Index: src/backend/utils/adt/numutils.c
-===================================================================
-RCS file: /cvsroot/pgsql-server/src/backend/utils/adt/numutils.c,v
-retrieving revision 1.54
-diff -c -c -r1.54 numutils.c
-*** src/backend/utils/adt/numutils.c	4 Sep 2002 20:31:28 -0000	1.54
---- src/backend/utils/adt/numutils.c	19 Dec 2002 17:10:56 -0000
-***************
-*** 70,76 ****
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 		elog(ERROR, "pg_atoi: zero-length string");
-  	else
-  		l = strtol(s, &badp, 10);
-  
---- 70,80 ----
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 	{
-! 		/* 7.3.X workaround for broken apps, bjm  2002-12-19 */
-! 		elog(WARNING, "pg_atoi: zero-length string");
-! 		l = (long) 0;
-! 	}
-  	else
-  		l = strtol(s, &badp, 10);
-  
-
diff --git a/databases/postgresql91-server/Makefile b/databases/postgresql91-server/Makefile
index c204fbcacebe..3465ae6d39fd 100644
--- a/databases/postgresql91-server/Makefile
+++ b/databases/postgresql91-server/Makefile
@@ -6,8 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.3.2
-PORTREVISION=	1
+PORTVERSION?=	7.3.3
 CATEGORIES?=	databases
 MASTER_SITES=	ftp://ftp3.us.postgresql.org/pub/postgresql/%SUBDIR%/ \
 		ftp://ftp5.us.postgresql.org/pub/PostgreSQL/%SUBDIR%/ \
@@ -47,6 +46,7 @@ INSTALLS_SHLIB=	YES
 
 CONFIGURE_ARGS=	--with-libraries=${LOCALBASE}/lib \
 		--with-includes=${LOCALBASE}/include
+CONFIGURE_ENV=	LDFLAGS="${LDFLAGS}"
 
 .if !defined(WITHOUT_GNUGETOPT)
 LIB_DEPENDS=	gnugetopt:${PORTSDIR}/devel/libgnugetopt
@@ -98,19 +98,22 @@ LIB_DEPENDS+=	krb5.3:${PORTSDIR}/security/krb5
 WITH_KRB5=	yes
 .endif
 
+.include <bsd.port.pre.mk>
 .if defined(WITH_KRB5)
 CONFIGURE_ARGS+=	--with-krb5="`${KRB5CONF} --prefix krb5`"
 LDFLAGS+=	`${KRB5CONF} --libs krb5`
-.endif
-
-.if defined(WITH_OPTIMIZED_CFLAGS)
-CFLAGS+= -O3 -funroll-loops
+CONFIGURE_ENV=  LDFLAGS="${LDFLAGS}"
 .endif
 
 .if defined(WITH_TESTS)
 DISTFILES+=	postgresql-test-${PORTVERSION}${EXTRACT_SUFX}
 .endif
 
+.if defined(WITH_LIBC_R)
+CFLAGS+=	${PTHREAD_CFLAGS}
+LDFLAGS+=	${PTHREAD_LIBS}
+.endif
+
 MAN1=		clusterdb.1 createdb.1 createlang.1 createuser.1 dropdb.1 \
 		droplang.1 dropuser.1 ecpg.1 initdb.1 initlocation.1 ipcclean.1 \
 		pg_config.1 pg_controldata.1 pg_ctl.1 pg_dump.1 pg_dumpall.1 \
@@ -140,7 +143,7 @@ MAN7=		abort.7 alter_database.7 alter_group.7 alter_table.7 \
 		truncate.7 unlisten.7 update.7 vacuum.7
 
 pre-everything::
-	@${SH} ${PKGDIR}/pkg-install ${PORTNAME} BACKUPWARNING
+	@${SH} ${PKGINSTALL} ${PORTNAME} BACKUPWARNING
 	@${ECHO} ""
 	@${ECHO} "${PORTNAME} has several tunables that can be used to configure PostgreSQL:"
 	@${ECHO} ""
@@ -157,6 +160,8 @@ pre-everything::
 	@${ECHO} "	WITH_DEBUG		Builds with debugging symbols"
 	@${ECHO} "	WITH_TESTS		Allows the use of a \"check\" target"
 	@${ECHO} "				building the module"
+	@${ECHO} "	WITH_LIBC_R		Link the binaries with libc_r."
+	@${ECHO} "				Needed to run plpython"
 	@${ECHO} ""
 .if defined(WITH_MIT_KRB5) && defined(WITH_HEIMDAL_KRB5)
 	@${ECHO} "WITH_MIT_KRB5 and WITH_HEIMDAL_KRB5 are mutually exclusive."
@@ -185,7 +190,7 @@ do-install:
 .else
 pre-install:
 	@ ${SETENV} PKG_PREFIX=${PREFIX} \
-		${SH} ${PKGDIR}/pkg-install ${PORTNAME} PRE-INSTALL
+		${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL
 .endif
 
 post-install:
@@ -225,5 +230,5 @@ check:
 	 fi
 .endif
 
-.include <bsd.port.mk>
+.include <bsd.port.post.mk>
 .endif
diff --git a/databases/postgresql91-server/distinfo b/databases/postgresql91-server/distinfo
index 934a97ecd98a..d95d2a295743 100644
--- a/databases/postgresql91-server/distinfo
+++ b/databases/postgresql91-server/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.3.2.tar.gz) = 2cd99c2d455c653fdfe74f5dd658d15c
-MD5 (postgresql/postgresql-opt-7.3.2.tar.gz) = c54a5b0be96b60259bd37f6a5b60abb9
-MD5 (postgresql/postgresql-test-7.3.2.tar.gz) = 9818eb4c50a2fe9057c7df5ae270972c
-MD5 (postgresql/postgresql-docs-7.3.2.tar.gz) = e91131aeed6919a00ab231db2298bd0b
+MD5 (postgresql/postgresql-base-7.3.3.tar.gz) = 4f5830d3effa8b00b22cc13597030b2f
+MD5 (postgresql/postgresql-opt-7.3.3.tar.gz) = b0b7f07c6bba1813b18e9901e481599d
+MD5 (postgresql/postgresql-docs-7.3.3.tar.gz) = 5009a3233f3ecf80369a5613298fbb8c
+MD5 (postgresql/postgresql-test-7.3.3.tar.gz) = d029272601b4d8bfac3b6be843f0064b
diff --git a/databases/postgresql91-server/files/patch-src::backend::utils::adt::numutils.c b/databases/postgresql91-server/files/patch-src::backend::utils::adt::numutils.c
deleted file mode 100644
index 3a9c84d71961..000000000000
--- a/databases/postgresql91-server/files/patch-src::backend::utils::adt::numutils.c
+++ /dev/null
@@ -1,29 +0,0 @@
-Index: src/backend/utils/adt/numutils.c
-===================================================================
-RCS file: /cvsroot/pgsql-server/src/backend/utils/adt/numutils.c,v
-retrieving revision 1.54
-diff -c -c -r1.54 numutils.c
-*** src/backend/utils/adt/numutils.c	4 Sep 2002 20:31:28 -0000	1.54
---- src/backend/utils/adt/numutils.c	19 Dec 2002 17:10:56 -0000
-***************
-*** 70,76 ****
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 		elog(ERROR, "pg_atoi: zero-length string");
-  	else
-  		l = strtol(s, &badp, 10);
-  
---- 70,80 ----
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 	{
-! 		/* 7.3.X workaround for broken apps, bjm  2002-12-19 */
-! 		elog(WARNING, "pg_atoi: zero-length string");
-! 		l = (long) 0;
-! 	}
-  	else
-  		l = strtol(s, &badp, 10);
-  
-
diff --git a/databases/postgresql92-server/Makefile b/databases/postgresql92-server/Makefile
index c204fbcacebe..3465ae6d39fd 100644
--- a/databases/postgresql92-server/Makefile
+++ b/databases/postgresql92-server/Makefile
@@ -6,8 +6,7 @@
 #
 
 PORTNAME?=	postgresql
-PORTVERSION?=	7.3.2
-PORTREVISION=	1
+PORTVERSION?=	7.3.3
 CATEGORIES?=	databases
 MASTER_SITES=	ftp://ftp3.us.postgresql.org/pub/postgresql/%SUBDIR%/ \
 		ftp://ftp5.us.postgresql.org/pub/PostgreSQL/%SUBDIR%/ \
@@ -47,6 +46,7 @@ INSTALLS_SHLIB=	YES
 
 CONFIGURE_ARGS=	--with-libraries=${LOCALBASE}/lib \
 		--with-includes=${LOCALBASE}/include
+CONFIGURE_ENV=	LDFLAGS="${LDFLAGS}"
 
 .if !defined(WITHOUT_GNUGETOPT)
 LIB_DEPENDS=	gnugetopt:${PORTSDIR}/devel/libgnugetopt
@@ -98,19 +98,22 @@ LIB_DEPENDS+=	krb5.3:${PORTSDIR}/security/krb5
 WITH_KRB5=	yes
 .endif
 
+.include <bsd.port.pre.mk>
 .if defined(WITH_KRB5)
 CONFIGURE_ARGS+=	--with-krb5="`${KRB5CONF} --prefix krb5`"
 LDFLAGS+=	`${KRB5CONF} --libs krb5`
-.endif
-
-.if defined(WITH_OPTIMIZED_CFLAGS)
-CFLAGS+= -O3 -funroll-loops
+CONFIGURE_ENV=  LDFLAGS="${LDFLAGS}"
 .endif
 
 .if defined(WITH_TESTS)
 DISTFILES+=	postgresql-test-${PORTVERSION}${EXTRACT_SUFX}
 .endif
 
+.if defined(WITH_LIBC_R)
+CFLAGS+=	${PTHREAD_CFLAGS}
+LDFLAGS+=	${PTHREAD_LIBS}
+.endif
+
 MAN1=		clusterdb.1 createdb.1 createlang.1 createuser.1 dropdb.1 \
 		droplang.1 dropuser.1 ecpg.1 initdb.1 initlocation.1 ipcclean.1 \
 		pg_config.1 pg_controldata.1 pg_ctl.1 pg_dump.1 pg_dumpall.1 \
@@ -140,7 +143,7 @@ MAN7=		abort.7 alter_database.7 alter_group.7 alter_table.7 \
 		truncate.7 unlisten.7 update.7 vacuum.7
 
 pre-everything::
-	@${SH} ${PKGDIR}/pkg-install ${PORTNAME} BACKUPWARNING
+	@${SH} ${PKGINSTALL} ${PORTNAME} BACKUPWARNING
 	@${ECHO} ""
 	@${ECHO} "${PORTNAME} has several tunables that can be used to configure PostgreSQL:"
 	@${ECHO} ""
@@ -157,6 +160,8 @@ pre-everything::
 	@${ECHO} "	WITH_DEBUG		Builds with debugging symbols"
 	@${ECHO} "	WITH_TESTS		Allows the use of a \"check\" target"
 	@${ECHO} "				building the module"
+	@${ECHO} "	WITH_LIBC_R		Link the binaries with libc_r."
+	@${ECHO} "				Needed to run plpython"
 	@${ECHO} ""
 .if defined(WITH_MIT_KRB5) && defined(WITH_HEIMDAL_KRB5)
 	@${ECHO} "WITH_MIT_KRB5 and WITH_HEIMDAL_KRB5 are mutually exclusive."
@@ -185,7 +190,7 @@ do-install:
 .else
 pre-install:
 	@ ${SETENV} PKG_PREFIX=${PREFIX} \
-		${SH} ${PKGDIR}/pkg-install ${PORTNAME} PRE-INSTALL
+		${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL
 .endif
 
 post-install:
@@ -225,5 +230,5 @@ check:
 	 fi
 .endif
 
-.include <bsd.port.mk>
+.include <bsd.port.post.mk>
 .endif
diff --git a/databases/postgresql92-server/distinfo b/databases/postgresql92-server/distinfo
index 934a97ecd98a..d95d2a295743 100644
--- a/databases/postgresql92-server/distinfo
+++ b/databases/postgresql92-server/distinfo
@@ -1,4 +1,4 @@
-MD5 (postgresql/postgresql-base-7.3.2.tar.gz) = 2cd99c2d455c653fdfe74f5dd658d15c
-MD5 (postgresql/postgresql-opt-7.3.2.tar.gz) = c54a5b0be96b60259bd37f6a5b60abb9
-MD5 (postgresql/postgresql-test-7.3.2.tar.gz) = 9818eb4c50a2fe9057c7df5ae270972c
-MD5 (postgresql/postgresql-docs-7.3.2.tar.gz) = e91131aeed6919a00ab231db2298bd0b
+MD5 (postgresql/postgresql-base-7.3.3.tar.gz) = 4f5830d3effa8b00b22cc13597030b2f
+MD5 (postgresql/postgresql-opt-7.3.3.tar.gz) = b0b7f07c6bba1813b18e9901e481599d
+MD5 (postgresql/postgresql-docs-7.3.3.tar.gz) = 5009a3233f3ecf80369a5613298fbb8c
+MD5 (postgresql/postgresql-test-7.3.3.tar.gz) = d029272601b4d8bfac3b6be843f0064b
diff --git a/databases/postgresql92-server/files/patch-src::backend::utils::adt::numutils.c b/databases/postgresql92-server/files/patch-src::backend::utils::adt::numutils.c
deleted file mode 100644
index 3a9c84d71961..000000000000
--- a/databases/postgresql92-server/files/patch-src::backend::utils::adt::numutils.c
+++ /dev/null
@@ -1,29 +0,0 @@
-Index: src/backend/utils/adt/numutils.c
-===================================================================
-RCS file: /cvsroot/pgsql-server/src/backend/utils/adt/numutils.c,v
-retrieving revision 1.54
-diff -c -c -r1.54 numutils.c
-*** src/backend/utils/adt/numutils.c	4 Sep 2002 20:31:28 -0000	1.54
---- src/backend/utils/adt/numutils.c	19 Dec 2002 17:10:56 -0000
-***************
-*** 70,76 ****
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 		elog(ERROR, "pg_atoi: zero-length string");
-  	else
-  		l = strtol(s, &badp, 10);
-  
---- 70,80 ----
-  	if (s == (char *) NULL)
-  		elog(ERROR, "pg_atoi: NULL pointer");
-  	else if (*s == 0)
-! 	{
-! 		/* 7.3.X workaround for broken apps, bjm  2002-12-19 */
-! 		elog(WARNING, "pg_atoi: zero-length string");
-! 		l = (long) 0;
-! 	}
-  	else
-  		l = strtol(s, &badp, 10);
-  
-