Upgrade from version 6.1.1 to 6.2

Please note: when performing a migration to 6.2 and you have an existing db,
then you have to use the *new* pg_dumpall script that comes with this new
postgresql release. The INSTALL file points this out explicitely !!!

Changes:
- startup script resides in FILESDIR
- renamed it to be in sync with INSTALL file from sources
- always install this startup script over an existing, because
  of the nature of the rc.d directory I can't install it
  to pgsql.sh-dist, if a pgsql.sh is already presend ...
- portlint detected trailing whitespace, usage of perl with absolute
  path, usage of echo instead of ECHO and plenty things of this kind
- post installation notes updated, mentioned the mailing list
- copies the html pages as well to the share/doc directory (new manual dir)
- had to update PLIST
- shortened DESCR file, to match the 24 lines
- added post build target, that reminds the admin how to proceed when
  already having a database -> INSTALL file describes migration
- updated manpages

1 files changed, 42 insertions, 31 deletions

diff --git a/databases/postgresql92-server/Makefile b/databases/postgresql92-server/Makefile
index f11b16deb174..be9e1d8230ac 100644
--- a/databases/postgresql92-server/Makefile
+++ b/databases/postgresql92-server/Makefile
@@ -1,17 +1,16 @@
 # New ports collection makefile for:	PostgreSQL
-# Version required:	6.1 
+# Version required:	6.1
 # Date created:		April 2, 1997
 # Whom:			Marc G. Fournier <scrappy@FreeBSD.ORG>
 #
-# $Id: Makefile,v 1.13 1997/07/17 15:12:40 max Exp $
+# $Id: Makefile,v 1.14 1997/09/27 21:43:48 andreas Exp $
 
-DISTNAME=	postgresql-v6.1.1
-PKGNAME=	postgresql-6.1.1
+DISTNAME=	postgresql-6.2
 CATEGORIES=	databases
 MASTER_SITES=	ftp://ftp.PostgreSQL.org/pub/ \
 		ftp://ftp.luga.or.at/pub/postgres95/ \
-		ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ 
-		
+		ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/
+
 MAINTAINER=	andreas@FreeBSD.ORG
 
 NO_PACKAGE=	"Requires pgsql uid"
@@ -20,59 +19,71 @@ USE_GMAKE=	YES
 HAS_CONFIGURE=	YES
 CONFIGURE_ARGS+=--prefix=${PREFIX}/pgsql \
 		--enable-locale \
-		--with-template=`uname -s | tr '[A-Z]' '[a-z]'`
+		--with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'`
 MAKEFILE=	GNUmakefile
 
 MAN1=		cleardbdir.1 createdb.1 createuser.1 destroydb.1 \
 		destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \
-		pg_dumpall.1 postgres.1 postmaster.1 psql.1 unix.1
-MAN3=		built-in.3 catalogs.3 large_objects.3 libpq.3 oracle_compat.3
-MAN5=		bki.5 page.5 pg_hba.conf.5 
+		pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \
+		postmaster.1 psql.1
+MAN3=		catalogs.3 large_objects.3 libpq.3 oracle_compat.3 pgbuiltin.3
+MAN5=		bki.5 page.5 pg_hba.conf.5
 MANL=		abort.l alter_table.l begin.l close.l cluster.l \
 		commit.l copy.l create_aggregate.l create_database.l \
 		create_function.l create_index.l create_operator.l \
 		create_rule.l create_sequence.l create_table.l \
-		create_type.l create_version.l create_view.l delete.l \
-		drop.l drop_aggregate.l drop_database.l drop_function.l \
-		drop_index.l drop_operator.l drop_rule.l drop_sequence.l \
+		create_trigger.l create_type.l create_version.l \
+		create_view.l declare.l delete.l drop.l drop_aggregate.l \
+		drop_database.l drop_function.l drop_index.l drop_operator.l \
+		drop_rule.l drop_sequence.l drop_table.l drop_trigger.l \
 		drop_type.l drop_view.l end.l explain.l fetch.l grant.l \
-		insert.l listen.l load.l notify.l purge.l rename.l \
-		reset.l revoke.l rollback.l select.l set.l show.l \
-		sql.l update.l vacuum.l
+		insert.l listen.l load.l move.l notify.l purge.l rename.l \
+		reset.l revoke.l rollback.l select.l set.l show.l sql.l \
+		update.l vacuum.l
+
 MANPREFIX=	${PREFIX}/pgsql
 
+post-build:
+	@ ${ECHO} "------------------------------------------------------------"
+	@ ${ECHO} "Dump existing databases, before installing new db version !!"
+	@ ${ECHO} "Detailed instructions, see INSTALL file under ${WRKDIR}...  "
+	@ ${ECHO} "------------------------------------------------------------"
+
 pre-install:
 	@ ${MKDIR} ${PREFIX}/pgsql
-	@ ${SETENV} ${MAKE_ENV} /usr/bin/perl ${SCRIPTDIR}/createuser
+	@ ${SETENV} ${MAKE_ENV} perl ${SCRIPTDIR}/createuser
 
 post-install:
 	@ if [ ! -f ${PREFIX}/pgsql/.profile ]; then \
-		echo "PATH=${PATH}:${PREFIX}/pgsql/bin" \
+		${ECHO} "PATH=${PATH}:${PREFIX}/pgsql/bin" \
 			> ${PREFIX}/pgsql/.profile; \
-		echo "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \
+		${ECHO} "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \
+			>> ${PREFIX}/pgsql/.profile; \
+		${ECHO} "PGLIB=${PREFIX}/pgsql/lib" \
 			>> ${PREFIX}/pgsql/.profile; \
-		echo "PGLIB=${PREFIX}/pgsql/lib" \
+		${ECHO} "PGDATA=${PREFIX}/pgsql/data" \
 			>> ${PREFIX}/pgsql/.profile; \
-		echo "PGDATA=${PREFIX}/pgsql/data" \
+		${ECHO} "export PATH MANPATH PGLIB PGDATA" \
 			>> ${PREFIX}/pgsql/.profile; \
-		echo "export PATH MANPATH PGLIB PGDATA" \
+		${ECHO} "# if you want to make regression tests use this TZ" \
+			>> ${PREFIX}/pgsql/.profile; \
+		${ECHO} "#TZ=PST8PDT" \
+			>> ${PREFIX}/pgsql/.profile; \
+		${ECHO} "#export TZ" \
 			>> ${PREFIX}/pgsql/.profile; \
 	fi
 	@ chown -R pgsql:pgsql ${PREFIX}/pgsql
-	@ echo 'Initializing PostgreSQL Databases - this may take a few minutes...'
+	@ ${ECHO} 'Initializing PostgreSQL Databases - this may take a few minutes...'
 	@ ${LDCONFIG} -m ${PREFIX}/pgsql/lib
 	@ su -l pgsql -c '${PREFIX}/pgsql/bin/initdb --pglib=${PREFIX}/pgsql/lib --pgdata=${PREFIX}/pgsql/data'
-	@ if [ ! -f ${PREFIX}/etc/rc.d/postgresql.sh ]; then \
-		echo "Installing ${PREFIX}/etc/rc.d/postgresql.sh startup file."; \
-		echo "#!/bin/sh" > ${PREFIX}/etc/rc.d/postgresql.sh; \
-		echo "[ -d ${PREFIX}/pgsql/lib ] && /sbin/ldconfig -m ${PREFIX}/pgsql/lib" >> ${PREFIX}/etc/rc.d/postgresql.sh; \
-		echo "[ -x ${PREFIX}/pgsql/bin/postmaster ] && su -l pgsql -c '${PREFIX}/pgsql/bin/postmaster -D${PREFIX}/pgsql/data -o -F > ${PREFIX}/pgsql/errlog &' && echo -n ' pgsql'" >> ${PREFIX}/etc/rc.d/postgresql.sh; \
-		chmod 751 ${PREFIX}/etc/rc.d/postgresql.sh; \
-	fi
+	@ ${SED} -e "s=!!PREFIX!!=${PREFIX}=g" < ${FILESDIR}/pgsql.sh.tmpl \
+		> ${PREFIX}/etc/rc.d/pgsql.sh
+	@ chmod 554 ${PREFIX}/etc/rc.d/pgsql.sh
+	@ chown root.pgsql ${PREFIX}/etc/rc.d/pgsql.sh
 	@ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/pgsql
 .if !defined(NOPORTDOCS)
 	${MKDIR} ${PREFIX}/share/doc/pgsql
-	${CP} ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql
+	${CP} -r ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql
 .endif
 .if !defined(BATCH)
 	@ more -e ${FILESDIR}/post-install-notes