revive postgres95 as postgresql with full history as requested by Satoshi.

6 files changed, 299 insertions, 0 deletions

diff --git a/databases/postgresql7/Makefile b/databases/postgresql7/Makefile
new file mode 100644
index 00000000000..8fe4bc783e4
--- /dev/null
+++ b/databases/postgresql7/Makefile
@@ -0,0 +1,66 @@
+# New ports collection makefile for:	postgres95
+# Version required:			1.08
+# Date created:				Oct 9 1996
+# Whom:	      				Matthew Stein <matt@bdd.net>
+#
+#   $Id: Makefile,v 1.7 1997/04/02 09:15:26 scrappy Exp $
+
+PKGNAME=	postgres95-1.08
+CATEGORIES=	databases
+MASTER_SITES=	ftp://ftp.PostgreSQL.org/pub/oldstuff/ \
+		ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/oldstuff/ \
+		ftp://postgres95.vnet.net:/pub/postgres95/oldstuff/ \
+		ftp://ftp.itm.tu-clausthal.de/pub/mirrors/postgres95/oldstuff/ \
+		ftp://rocker.sch.bme.hu/pub/mirrors/postgreSQL/oldstuff/ \
+		ftp://ftp.luga.or.at/pub/postgres95/ 
+
+DISTFILES=	postgres95-1.08.tar.gz \
+		flex-2.5.2.tgz
+		
+MAINTAINER=	matt@bdd.net
+
+NO_PACKAGE=	"Requires postgres uid"
+WRKSRC=		${WRKDIR}/postgres95/src/
+MAKE_ENV+=	WRKSRC=${WRKSRC} WRKDIR=${WRKDIR}
+USE_GMAKE=	yes
+
+pre-fetch:
+.if exists(/usr/lib/libc.so.3.0)
+		@ ${CAT} ${FILESDIR}/md5.libc30 ${FILESDIR}/md5.all > ${FILESDIR}/md5
+MASTER_SITES+=	ftp://eddie.cis.uoguelph.ca/pub/flex/ \
+		ftp://ftp.teamos2.org/pub/flex/ \
+		ftp://ftp.bdd.net/pub/flex/
+.else
+		@ ${CAT} ${FILESDIR}/md5.libc22 ${FILESDIR}/md5.all > ${FILESDIR}/md5
+MASTER_SITES+=	ftp://ftp.freebsd.org/pub/FreeBSD/packages-2.1.5/All/
+.endif
+
+pre-install:
+		@ ${MKDIR} ${PREFIX}/postgres95
+		@ ${SETENV} ${MAKE_ENV} /usr/bin/perl ${SCRIPTDIR}/createuser
+
+post-install:
+.if !defined(NOMANCOMPRESS)
+		@ for file in ${PREFIX}/postgres95/man/man[135l]/*; do \
+			gzip -9nf $$file ; \
+		done
+.endif
+		@ chown -R postgres:postgres ${PREFIX}/postgres95
+		@ echo 'Initializing Postgres95 Databases - this may take a few minutes...'
+		@ su -l postgres -c ${PREFIX}/postgres95/bin/initdb
+		@ ${MKDIR} ${PREFIX}/etc/rc.d
+		@ if [ ! -f ${PREFIX}/etc/rc.d/postgres95.sh ]; then \
+			echo "Installing ${PREFIX}/etc/rc.d/postgres95.sh startup file."; \
+			echo "#!/bin/sh" > ${PREFIX}/etc/rc.d/postgres95.sh; \
+			echo "[ -x ${PREFIX}/postgres95/bin/postmaster ] && su -l postgres -c ${PREFIX}/postgres95/bin/postmaster & && echo -n ' postgres95'" >> ${PREFIX}/etc/rc.d/postgres95.sh; \
+			chmod 751 ${PREFIX}/etc/rc.d/postgres95.sh; \
+		fi
+		@ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/postgres95
+.ifndef(BATCH)
+		@ more -e ${FILESDIR}/post-install-notes
+.endif
+
+pre-clean:
+		@ ${RM} -f ${FILESDIR}/md5
+
+.include <bsd.port.mk>
diff --git a/databases/postgresql7/files/post-install-notes b/databases/postgresql7/files/post-install-notes
new file mode 100644
index 00000000000..6d26c879933
--- /dev/null
+++ b/databases/postgresql7/files/post-install-notes
@@ -0,0 +1,8 @@
+
+Now that postgres95 is installed, you should read the documentation and
+implementation guides.  These can be found at
+
+http://www.PostgreSQL.org/docs/
+
+--
+mat.
diff --git a/databases/postgresql7/pkg-comment b/databases/postgresql7/pkg-comment
new file mode 100644
index 00000000000..55a303f3106
--- /dev/null
+++ b/databases/postgresql7/pkg-comment
@@ -0,0 +1 @@
+a next-generation DBMS research prototype.
diff --git a/databases/postgresql7/pkg-descr b/databases/postgresql7/pkg-descr
new file mode 100644
index 00000000000..2743afb2583
--- /dev/null
+++ b/databases/postgresql7/pkg-descr
@@ -0,0 +1,20 @@
+Postgres95 is an enhancement of the POSTGRES database management system, a
+next-generation DBMS research prototype.  While Postgres95 retains the
+powerful data model and rich data types of POSTGRES, it replaces the
+PostQuel query language with an extended subset of SQL.  Postgres95 is free
+and the complete source is available.
+
+Postgres95 development is being performed by a team of Internet developers
+who all subscribe to the Postgres95 development mailing list.  The current
+coordinator is Marc G. Fournier (scrappy@ki.net).  This team is now
+responsible for all current and future development of Postgres95.
+
+The authors of Postgres95 1.01 were Andrew Yu and Jolly Chen. Many others
+have contributed to the porting, testing, debugging and enhancement of the
+code.  The original Postgres code, from which Postgres95 is derived, was the
+effort of many graduate students, undergraduate students, and staff
+programmers working under the direction of Professor Michael Stonebraker at
+the University of California, Berkeley.
+
+More information and documentation can be found at the postgres95 website,
+at http://www.ki.net/postgres95/
diff --git a/databases/postgresql7/pkg-plist b/databases/postgresql7/pkg-plist
new file mode 100644
index 00000000000..43a0ebb2e78
--- /dev/null
+++ b/databases/postgresql7/pkg-plist
@@ -0,0 +1,154 @@
+etc/rc.d/postgres95.sh
+postgres95/lib/libpq.a
+postgres95/bin/postgres
+postgres95/bin/postmaster
+postgres95/bin/pg_id
+postgres95/bin/pg_version
+postgres95/bin/psql
+postgres95/bin/pg_dump
+postgres95/bin/cleardbdir
+postgres95/bin/createdb
+postgres95/bin/createuser
+postgres95/bin/destroydb
+postgres95/bin/destroyuser
+postgres95/bin/initdb
+postgres95/data/files/global1.bki
+postgres95/data/files/global1.bki.source
+postgres95/data/files/local1_template1.bki
+postgres95/data/files/local1_template1.bki.source
+postgres95/data/pg_hba
+postgres95/data/base/template1/pg_proc
+postgres95/data/base/template1/pg_type
+postgres95/data/base/template1/pg_attribute
+postgres95/data/base/template1/pg_class
+postgres95/data/base/template1/pg_inherits
+postgres95/data/base/template1/pg_index
+postgres95/data/base/template1/pg_version
+postgres95/data/base/template1/pg_statistic
+postgres95/data/base/template1/pg_operator
+postgres95/data/base/template1/pg_opclass
+postgres95/data/base/template1/pg_am
+postgres95/data/base/template1/pg_amop
+postgres95/data/base/template1/pg_amproc
+postgres95/data/base/template1/pg_language
+postgres95/data/base/template1/pg_parg
+postgres95/data/base/template1/pg_aggregate
+postgres95/data/base/template1/pg_ipl
+postgres95/data/base/template1/pg_inheritproc
+postgres95/data/base/template1/pg_rewrite
+postgres95/data/base/template1/pg_listener
+postgres95/data/base/template1/pg_attnameind
+postgres95/data/base/template1/pg_attnumind
+postgres95/data/base/template1/pg_attrelidind
+postgres95/data/base/template1/pg_procidind
+postgres95/data/base/template1/pg_procnameind
+postgres95/data/base/template1/pg_procsrcind
+postgres95/data/base/template1/pg_typeidind
+postgres95/data/base/template1/pg_typenameind
+postgres95/data/base/template1/pg_classnameind
+postgres95/data/base/template1/pg_classoidind
+postgres95/data/base/template1/PG_VERSION
+postgres95/data/base/template1/pg_internal.init
+postgres95/data/pg_variable
+postgres95/data/pg_database
+postgres95/data/pg_demon
+postgres95/data/pg_magic
+postgres95/data/pg_defaults
+postgres95/data/pg_server
+postgres95/data/pg_user
+postgres95/data/pg_hosts
+postgres95/data/pg_group
+postgres95/data/pg_log
+postgres95/data/pg_time
+postgres95/data/PG_VERSION
+postgres95/include/fmgr.h
+postgres95/include/lib/dllist.h
+postgres95/include/libpq/pqcomm.h
+postgres95/include/libpq/libpq-fs.h
+postgres95/include/utils/geo-decls.h
+postgres95/include/libpq-fe.h
+postgres95/include/postgres.h
+postgres95/include/c.h
+postgres95/man/man1/cleardbdir.1.gz
+postgres95/man/man1/psql.1.gz
+postgres95/man/man1/postmaster.1.gz
+postgres95/man/man1/postgres.1.gz
+postgres95/man/man1/pg_dump.1.gz
+postgres95/man/man1/monitor.1.gz
+postgres95/man/man1/ipcclean.1.gz
+postgres95/man/man1/initdb.1.gz
+postgres95/man/man1/destroyuser.1.gz
+postgres95/man/man1/destroydb.1.gz
+postgres95/man/man1/createuser.1.gz
+postgres95/man/man1/createdb.1.gz
+postgres95/man/man1/unix.1.gz
+postgres95/man/man3/libpq.3.gz
+postgres95/man/man3/large_objects.3.gz
+postgres95/man/man3/catalogs.3.gz
+postgres95/man/man3/built-in.3.gz
+postgres95/man/man5/template.5.gz
+postgres95/man/man5/pg_hba.5.gz
+postgres95/man/man5/page.5.gz
+postgres95/man/man5/files.5.gz
+postgres95/man/man5/bki.5.gz
+postgres95/man/manl/abort.l.gz
+postgres95/man/manl/update.l.gz
+postgres95/man/manl/sql.l.gz
+postgres95/man/manl/select.l.gz
+postgres95/man/manl/rollback.l.gz
+postgres95/man/manl/revoke.l.gz
+postgres95/man/manl/rename.l.gz
+postgres95/man/manl/remove_view.l.gz
+postgres95/man/manl/purge.l.gz
+postgres95/man/manl/notify.l.gz
+postgres95/man/manl/load.l.gz
+postgres95/man/manl/listen.l.gz
+postgres95/man/manl/insert.l.gz
+postgres95/man/manl/grant.l.gz
+postgres95/man/manl/fetch.l.gz
+postgres95/man/manl/end.l.gz
+postgres95/man/manl/drop_type.l.gz
+postgres95/man/manl/drop_rule.l.gz
+postgres95/man/manl/drop_operator.l.gz
+postgres95/man/manl/drop_index.l.gz
+postgres95/man/manl/drop_function.l.gz
+postgres95/man/manl/drop_aggregate.l.gz
+postgres95/man/manl/drop.l.gz
+postgres95/man/manl/destroydb.l.gz
+postgres95/man/manl/copy.l.gz
+postgres95/man/manl/delete.l.gz
+postgres95/man/manl/create_database.l.gz
+postgres95/man/manl/create_view.l.gz
+postgres95/man/manl/create_version.l.gz
+postgres95/man/manl/create_type.l.gz
+postgres95/man/manl/create_table.l.gz
+postgres95/man/manl/create_rule.l.gz
+postgres95/man/manl/create_operator.l.gz
+postgres95/man/manl/create_index.l.gz
+postgres95/man/manl/create_function.l.gz
+postgres95/man/manl/create_aggregate.l.gz
+postgres95/man/manl/commit.l.gz
+postgres95/man/manl/cluster.l.gz
+postgres95/man/manl/close.l.gz
+postgres95/man/manl/begin.l.gz
+postgres95/man/manl/alter_table.l.gz
+postgres95/man/manl/vacuum.l.gz
+postgres95/post-install-notes
+@dirrm postgres95/man/man1/
+@dirrm postgres95/man/man3/
+@dirrm postgres95/man/man5/
+@dirrm postgres95/man/manl/
+@dirrm postgres95/man/
+@dirrm postgres95/lib/
+@dirrm postgres95/include/utils/
+@dirrm postgres95/include/port/BSD44_derived/
+@dirrm postgres95/include/port/
+@dirrm postgres95/include/libpq/
+@dirrm postgres95/include/lib/
+@dirrm postgres95/include/
+@dirrm postgres95/data/files/
+@dirrm postgres95/data/base/template1/
+@dirrm postgres95/data/base/
+@dirrm postgres95/data/
+@dirrm postgres95/bin/
+@dirrm postgres95/
diff --git a/databases/postgresql7/scripts/createuser b/databases/postgresql7/scripts/createuser
new file mode 100644
index 00000000000..4c24a164fbd
--- /dev/null
+++ b/databases/postgresql7/scripts/createuser
@@ -0,0 +1,50 @@
+#!/usr/bin/perl
+#
+
+eval '(exit $?0)' && eval 'exec /usr/bin/perl -S $0 ${1+"$@"}'
+& eval 'exec /usr/bin/perl -S $0 $argv:q'
+if 0;
+
+if( $> ) {
+	print "\nYou must be root to run this step!\n\n";
+	exit 1;
+} 
+
+if( getpwnam( "postgres" ) ) {
+	( $null, $null, $pgUID ) = getpwnam( "postgres" );
+} else {
+	$pgUID = 70;
+	while( getpwuid( $pgUID ) ) {
+		$pgUID++;
+	}
+}
+
+if( getgrnam( "postgres" ) ) {
+	( $null, $null, $pgGID ) = getgrnam( "postgres" );
+} else {
+	$pgGID = 70;
+	while( getgrgid( $pgGID ) ) {
+		$pgGID++;
+	}
+	&append_file( "/etc/group", "postgres:*:$pgGID:" );
+}
+
+print "postgres user using uid $pgUID\n";
+print "postgres user using gid $pgGID\n";
+
+system( "/usr/bin/chpass -a \"postgres:*:$pgUID:$pgGID::0:0:Postgres95 pseudo-user:$ENV{'PREFIX'}/postgres95:/bin/sh\"" );
+
+sub append_file {
+	local($file,@list) = @_;
+	local($LOCK_EX) = 2;
+	local($LOCK_NB) = 4;
+	local($LOCK_UN) = 8;
+
+	open(F, ">> $file") || die "$file: $!\n";
+	while( ! flock( F, $LOCK_EX | $LOCK_NB ) ) {
+		exit 1;
+	}
+	print F join( "\n", @list) . "\n";
+	close F;
+	flock( F, $LOCK_UN );
+}