In order to address a potential security hole recently identified with

the "LOAD" option, the PostgreSQL Global Development Group is
announcing the release of new versions of PostgreSQL.

Update to 7.3.9, 7.4.7 & 8.0.1.

Take the opportunity to reset PORTREVISION of slave ports.

Back out name change of startup script. The new script uses rc.subr(8),
and as such also uses rcorder(8). But, rcorder does not exist in FreeBSD
4.x. Hence rename the script it back to the top of the directory
list. [1]

The periodic script should of course be executable. [2]

[1] Noted by Niels Chr. Bank-Pedersen <ncbp at bank-pedersen dot dk>
[2] Noted by Fritz Heinrichmeyer <fritz.heinrichmeyer at fernuni-hagen dot de>

4 files changed, 17 insertions, 16 deletions

diff --git a/databases/postgresql84-server/Makefile b/databases/postgresql84-server/Makefile
index 7bdc96d9506e..48744e34198a 100644
--- a/databases/postgresql84-server/Makefile
+++ b/databases/postgresql84-server/Makefile
@@ -7,7 +7,7 @@
 
 PORTNAME?=	postgresql
 PKGNAMESUFFIX?=	-server
-PORTVERSION?=	8.0.0
+PORTVERSION?=	8.0.1
 PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
@@ -47,7 +47,7 @@ PKGMESSAGE=	${WRKDIR}/.pkg-message${PKGNAMESUFFIX}
 .if !defined(CLIENT_ONLY) && !defined(SLAVE_ONLY)
 SERVER_ONLY=	yes
 USE_RC_SUBR=	yes
-RCSCRIPT=	${PREFIX}/etc/rc.d/postgresql.sh
+RCSCRIPT=	${PREFIX}/etc/rc.d/010.pgsql.sh
 USE_PGSQL=	yes
 WANT_PGSQL_VER=	${PORTVERSION:C/([0-9][0-9]*)\.([0-9][0-9]*).*/\1\2/g}
 .endif
@@ -92,11 +92,11 @@ OPTIONS+=	TESTS "Allows the use of a \"check\" target" off
 OPTIONS+=	DEBUG "Builds with debugging symbols" off
 
 .if defined(SERVER_ONLY) && defined(WITH_RENDEZVOUS)
-CONFIGURE_ARGS+=	--with-rendezvous
+CONFIGURE_ARGS+=--with-rendezvous
 .endif
 
 .  if defined(SERVER_ONLY) && defined(WITH_PAM)
-CONFIGURE_ARGS+=	--with-pam
+CONFIGURE_ARGS+=--with-pam
 .  endif
 
 . if !defined(WITHOUT_GNUGETOPT) || exists(${LOCALBASE}/include/getopt.h)
@@ -117,7 +117,7 @@ CFLAGS+=	-O3 -funroll-loops
 .  endif
 
 .  if defined(WITH_DEBUG)
-CONFIGURE_ARGS+=	--enable-debug
+CONFIGURE_ARGS+=--enable-debug
 INSTALL_TARGET=	install
 .  else
 INSTALL_TARGET=	install-strip
@@ -150,7 +150,7 @@ CONFIGURE_ENV+=	LDFLAGS="${LDFLAGS}"
 
 .  if defined(SERVER_ONLY) && defined(WITH_TESTS)
 DISTFILES+=	postgresql-test-${PORTVERSION}${EXTRACT_SUFX}
-EXTRA_PATCHES=	${FILESDIR}/regresspatch-src-text-regress-pgregress-sh
+EXTRA_PATCHES=	${FILESDIR}/regresspatch-src-test-regress-pgregress-sh
 .  endif
 
 .  if defined(SERVER_ONLY) && defined(WITH_LIBC_R)
@@ -266,7 +266,7 @@ do-install:
 	${CHOWN} root:pgsql ${RCSCRIPT} ;\
 	${CHOWN} -R pgsql:pgsql ~pgsql/. ;\
 	${MKDIR} ${PREFIX}/etc/periodic/daily ;\
-	${INSTALL_DATA} ${FILESDIR}/502.pgsql \
+	${INSTALL_SCRIPT} ${FILESDIR}/502.pgsql \
 			${PREFIX}/etc/periodic/daily
 .  endif # SERVER_ONLY
 	@ if [ -r ${PKGMESSAGE} ]; then \
diff --git a/databases/postgresql84-server/distinfo b/databases/postgresql84-server/distinfo
index da3a86f4a5a1..8c1ca90907ab 100644
--- a/databases/postgresql84-server/distinfo
+++ b/databases/postgresql84-server/distinfo
@@ -1,8 +1,8 @@
-MD5 (postgresql/postgresql-base-8.0.0.tar.bz2) = 57984b8b016501ee920e95af6edc7145
-SIZE (postgresql/postgresql-base-8.0.0.tar.bz2) = 7795453
-MD5 (postgresql/postgresql-docs-8.0.0.tar.bz2) = 9deb6ac959e367cabe882d77287a6b31
-SIZE (postgresql/postgresql-docs-8.0.0.tar.bz2) = 2195941
-MD5 (postgresql/postgresql-opt-8.0.0.tar.bz2) = 11f91f2bf1697d7c8f340151208e0c3e
-SIZE (postgresql/postgresql-opt-8.0.0.tar.bz2) = 133317
-MD5 (postgresql/postgresql-test-8.0.0.tar.bz2) = 0281020c9a1a3c342edaf2d9586ec07e
-SIZE (postgresql/postgresql-test-8.0.0.tar.bz2) = 961649
+MD5 (postgresql/postgresql-base-8.0.1.tar.bz2) = b8f8edce5b29bcf785251693c6225885
+SIZE (postgresql/postgresql-base-8.0.1.tar.bz2) = 7798118
+MD5 (postgresql/postgresql-docs-8.0.1.tar.bz2) = f51624e70b9fca4ebd6bb56ba8587b97
+SIZE (postgresql/postgresql-docs-8.0.1.tar.bz2) = 2198650
+MD5 (postgresql/postgresql-opt-8.0.1.tar.bz2) = 130474770b88fd059c2dff457fb06b0a
+SIZE (postgresql/postgresql-opt-8.0.1.tar.bz2) = 133466
+MD5 (postgresql/postgresql-test-8.0.1.tar.bz2) = ad7baaaf9cf417b9ddd1512f1dd7fb10
+SIZE (postgresql/postgresql-test-8.0.1.tar.bz2) = 961001
diff --git a/databases/postgresql84-server/pkg-plist-client b/databases/postgresql84-server/pkg-plist-client
index 78dcecc51293..cde44ae6df19 100644
--- a/databases/postgresql84-server/pkg-plist-client
+++ b/databases/postgresql84-server/pkg-plist-client
@@ -480,6 +480,7 @@ share/postgresql/psqlrc.sample
 %%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_config.mo
 %%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_controldata.mo
 %%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_ctl.mo
+%%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_dump.mo
 %%GETTEXT%%share/locale/ko/LC_MESSAGES/pg_resetxlog.mo
 %%GETTEXT%%share/locale/ko/LC_MESSAGES/pgscripts.mo
 %%GETTEXT%%share/locale/ko/LC_MESSAGES/psql.mo
diff --git a/databases/postgresql84-server/pkg-plist-server b/databases/postgresql84-server/pkg-plist-server
index b9892473307e..44b57f274dbc 100644
--- a/databases/postgresql84-server/pkg-plist-server
+++ b/databases/postgresql84-server/pkg-plist-server
@@ -1,7 +1,7 @@
 bin/postmaster
 bin/postgres
 etc/periodic/daily/502.pgsql
-etc/rc.d/postgresql.sh
+etc/rc.d/010.pgsql.sh
 lib/postgresql/ascii_and_mic.so
 lib/postgresql/cyrillic_and_mic.so
 lib/postgresql/euc_cn_and_mic.so