summaryrefslogtreecommitdiff
path: root/databases
diff options
context:
space:
mode:
authorPeter Wemm <peter@FreeBSD.org>1997-04-09 15:30:55 +0000
committerPeter Wemm <peter@FreeBSD.org>1997-04-09 15:30:55 +0000
commit52f5f9f7a284fc184aacadeb73cf6bd231756fb7 (patch)
tree00446ea86f5980a1d3b25d9672cca7ea2c28848d /databases
parentUpgrade to 4.0b3 (note: Java not work for unknown reason) (diff)
revive postgres95 as postgresql with full history as requested by Satoshi.
Notes
Notes: svn path=/head/; revision=6172
Diffstat (limited to 'databases')
-rw-r--r--databases/postgresql-devel-server/Makefile66
-rw-r--r--databases/postgresql-devel-server/files/post-install-notes8
-rw-r--r--databases/postgresql-devel-server/pkg-comment1
-rw-r--r--databases/postgresql-devel-server/pkg-descr20
-rw-r--r--databases/postgresql-devel-server/pkg-plist154
-rw-r--r--databases/postgresql-devel-server/scripts/createuser50
-rw-r--r--databases/postgresql-devel/Makefile66
-rw-r--r--databases/postgresql-devel/files/post-install-notes8
-rw-r--r--databases/postgresql-devel/pkg-comment1
-rw-r--r--databases/postgresql-devel/pkg-descr20
-rw-r--r--databases/postgresql-devel/pkg-plist154
-rw-r--r--databases/postgresql-devel/scripts/createuser50
-rw-r--r--databases/postgresql7/Makefile66
-rw-r--r--databases/postgresql7/files/post-install-notes8
-rw-r--r--databases/postgresql7/pkg-comment1
-rw-r--r--databases/postgresql7/pkg-descr20
-rw-r--r--databases/postgresql7/pkg-plist154
-rw-r--r--databases/postgresql7/scripts/createuser50
-rw-r--r--databases/postgresql73-server/Makefile66
-rw-r--r--databases/postgresql73-server/files/post-install-notes8
-rw-r--r--databases/postgresql73-server/pkg-comment1
-rw-r--r--databases/postgresql73-server/pkg-descr20
-rw-r--r--databases/postgresql73-server/pkg-plist154
-rw-r--r--databases/postgresql73-server/scripts/createuser50
-rw-r--r--databases/postgresql73/Makefile66
-rw-r--r--databases/postgresql73/files/post-install-notes8
-rw-r--r--databases/postgresql73/pkg-comment1
-rw-r--r--databases/postgresql73/pkg-descr20
-rw-r--r--databases/postgresql73/pkg-plist154
-rw-r--r--databases/postgresql73/scripts/createuser50
-rw-r--r--databases/postgresql74-server/Makefile66
-rw-r--r--databases/postgresql74-server/files/post-install-notes8
-rw-r--r--databases/postgresql74-server/pkg-comment1
-rw-r--r--databases/postgresql74-server/pkg-descr20
-rw-r--r--databases/postgresql74-server/pkg-plist154
-rw-r--r--databases/postgresql74-server/scripts/createuser50
-rw-r--r--databases/postgresql80-server/Makefile66
-rw-r--r--databases/postgresql80-server/files/post-install-notes8
-rw-r--r--databases/postgresql80-server/pkg-comment1
-rw-r--r--databases/postgresql80-server/pkg-descr20
-rw-r--r--databases/postgresql80-server/pkg-plist154
-rw-r--r--databases/postgresql80-server/scripts/createuser50
-rw-r--r--databases/postgresql81-server/Makefile66
-rw-r--r--databases/postgresql81-server/files/post-install-notes8
-rw-r--r--databases/postgresql81-server/pkg-comment1
-rw-r--r--databases/postgresql81-server/pkg-descr20
-rw-r--r--databases/postgresql81-server/pkg-plist154
-rw-r--r--databases/postgresql81-server/scripts/createuser50
-rw-r--r--databases/postgresql82-server/Makefile66
-rw-r--r--databases/postgresql82-server/files/post-install-notes8
-rw-r--r--databases/postgresql82-server/pkg-comment1
-rw-r--r--databases/postgresql82-server/pkg-descr20
-rw-r--r--databases/postgresql82-server/pkg-plist154
-rw-r--r--databases/postgresql82-server/scripts/createuser50
-rw-r--r--databases/postgresql83-server/Makefile66
-rw-r--r--databases/postgresql83-server/files/post-install-notes8
-rw-r--r--databases/postgresql83-server/pkg-comment1
-rw-r--r--databases/postgresql83-server/pkg-descr20
-rw-r--r--databases/postgresql83-server/pkg-plist154
-rw-r--r--databases/postgresql83-server/scripts/createuser50
-rw-r--r--databases/postgresql84-server/Makefile66
-rw-r--r--databases/postgresql84-server/files/post-install-notes8
-rw-r--r--databases/postgresql84-server/pkg-comment1
-rw-r--r--databases/postgresql84-server/pkg-descr20
-rw-r--r--databases/postgresql84-server/pkg-plist154
-rw-r--r--databases/postgresql84-server/scripts/createuser50
-rw-r--r--databases/postgresql90-server/Makefile66
-rw-r--r--databases/postgresql90-server/files/post-install-notes8
-rw-r--r--databases/postgresql90-server/pkg-comment1
-rw-r--r--databases/postgresql90-server/pkg-descr20
-rw-r--r--databases/postgresql90-server/pkg-plist154
-rw-r--r--databases/postgresql90-server/scripts/createuser50
-rw-r--r--databases/postgresql91-server/Makefile66
-rw-r--r--databases/postgresql91-server/files/post-install-notes8
-rw-r--r--databases/postgresql91-server/pkg-comment1
-rw-r--r--databases/postgresql91-server/pkg-descr20
-rw-r--r--databases/postgresql91-server/pkg-plist154
-rw-r--r--databases/postgresql91-server/scripts/createuser50
-rw-r--r--databases/postgresql92-server/Makefile66
-rw-r--r--databases/postgresql92-server/files/post-install-notes8
-rw-r--r--databases/postgresql92-server/pkg-comment1
-rw-r--r--databases/postgresql92-server/pkg-descr20
-rw-r--r--databases/postgresql92-server/pkg-plist154
-rw-r--r--databases/postgresql92-server/scripts/createuser50
84 files changed, 4186 insertions, 0 deletions
diff --git a/databases/postgresql-devel-server/Makefile b/databases/postgresql-devel-server/Makefile
new file mode 100644
index 000000000000..8fe4bc783e44
--- /dev/null
+++ b/databases/postgresql-devel-server/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/postgresql-devel-server/files/post-install-notes b/databases/postgresql-devel-server/files/post-install-notes
new file mode 100644
index 000000000000..6d26c8799339
--- /dev/null
+++ b/databases/postgresql-devel-server/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/postgresql-devel-server/pkg-comment b/databases/postgresql-devel-server/pkg-comment
new file mode 100644
index 000000000000..55a303f3106a
--- /dev/null
+++ b/databases/postgresql-devel-server/pkg-comment
@@ -0,0 +1 @@
+a next-generation DBMS research prototype.
diff --git a/databases/postgresql-devel-server/pkg-descr b/databases/postgresql-devel-server/pkg-descr
new file mode 100644
index 000000000000..2743afb25835
--- /dev/null
+++ b/databases/postgresql-devel-server/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/postgresql-devel-server/pkg-plist b/databases/postgresql-devel-server/pkg-plist
new file mode 100644
index 000000000000..43a0ebb2e780
--- /dev/null
+++ b/databases/postgresql-devel-server/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/postgresql-devel-server/scripts/createuser b/databases/postgresql-devel-server/scripts/createuser
new file mode 100644
index 000000000000..4c24a164fbd6
--- /dev/null
+++ b/databases/postgresql-devel-server/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 );
+}
diff --git a/databases/postgresql-devel/Makefile b/databases/postgresql-devel/Makefile
new file mode 100644
index 000000000000..8fe4bc783e44
--- /dev/null
+++ b/databases/postgresql-devel/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/postgresql-devel/files/post-install-notes b/databases/postgresql-devel/files/post-install-notes
new file mode 100644
index 000000000000..6d26c8799339
--- /dev/null
+++ b/databases/postgresql-devel/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/postgresql-devel/pkg-comment b/databases/postgresql-devel/pkg-comment
new file mode 100644
index 000000000000..55a303f3106a
--- /dev/null
+++ b/databases/postgresql-devel/pkg-comment
@@ -0,0 +1 @@
+a next-generation DBMS research prototype.
diff --git a/databases/postgresql-devel/pkg-descr b/databases/postgresql-devel/pkg-descr
new file mode 100644
index 000000000000..2743afb25835
--- /dev/null
+++ b/databases/postgresql-devel/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/postgresql-devel/pkg-plist b/databases/postgresql-devel/pkg-plist
new file mode 100644
index 000000000000..43a0ebb2e780
--- /dev/null
+++ b/databases/postgresql-devel/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/postgresql-devel/scripts/createuser b/databases/postgresql-devel/scripts/createuser
new file mode 100644
index 000000000000..4c24a164fbd6
--- /dev/null
+++ b/databases/postgresql-devel/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 );
+}
diff --git a/databases/postgresql7/Makefile b/databases/postgresql7/Makefile
new file mode 100644
index 000000000000..8fe4bc783e44
--- /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 000000000000..6d26c8799339
--- /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 000000000000..55a303f3106a
--- /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 000000000000..2743afb25835
--- /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 000000000000..43a0ebb2e780
--- /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 000000000000..4c24a164fbd6
--- /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 );
+}
diff --git a/databases/postgresql73-server/Makefile b/databases/postgresql73-server/Makefile
new file mode 100644
index 000000000000..8fe4bc783e44
--- /dev/null
+++ b/databases/postgresql73-server/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/postgresql73-server/files/post-install-notes b/databases/postgresql73-server/files/post-install-notes
new file mode 100644
index 000000000000..6d26c8799339
--- /dev/null
+++ b/databases/postgresql73-server/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/postgresql73-server/pkg-comment b/databases/postgresql73-server/pkg-comment
new file mode 100644
index 000000000000..55a303f3106a
--- /dev/null
+++ b/databases/postgresql73-server/pkg-comment
@@ -0,0 +1 @@
+a next-generation DBMS research prototype.
diff --git a/databases/postgresql73-server/pkg-descr b/databases/postgresql73-server/pkg-descr
new file mode 100644
index 000000000000..2743afb25835
--- /dev/null
+++ b/databases/postgresql73-server/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/postgresql73-server/pkg-plist b/databases/postgresql73-server/pkg-plist
new file mode 100644
index 000000000000..43a0ebb2e780
--- /dev/null
+++ b/databases/postgresql73-server/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/postgresql73-server/scripts/createuser b/databases/postgresql73-server/scripts/createuser
new file mode 100644
index 000000000000..4c24a164fbd6
--- /dev/null
+++ b/databases/postgresql73-server/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 );
+}
diff --git a/databases/postgresql73/Makefile b/databases/postgresql73/Makefile
new file mode 100644
index 000000000000..8fe4bc783e44
--- /dev/null
+++ b/databases/postgresql73/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/postgresql73/files/post-install-notes b/databases/postgresql73/files/post-install-notes
new file mode 100644
index 000000000000..6d26c8799339
--- /dev/null
+++ b/databases/postgresql73/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/postgresql73/pkg-comment b/databases/postgresql73/pkg-comment
new file mode 100644
index 000000000000..55a303f3106a
--- /dev/null
+++ b/databases/postgresql73/pkg-comment
@@ -0,0 +1 @@
+a next-generation DBMS research prototype.
diff --git a/databases/postgresql73/pkg-descr b/databases/postgresql73/pkg-descr
new file mode 100644
index 000000000000..2743afb25835
--- /dev/null
+++ b/databases/postgresql73/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/postgresql73/pkg-plist b/databases/postgresql73/pkg-plist
new file mode 100644
index 000000000000..43a0ebb2e780
--- /dev/null
+++ b/databases/postgresql73/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/postgresql73/scripts/createuser b/databases/postgresql73/scripts/createuser
new file mode 100644
index 000000000000..4c24a164fbd6
--- /dev/null
+++ b/databases/postgresql73/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 );
+}
diff --git a/databases/postgresql74-server/Makefile b/databases/postgresql74-server/Makefile
new file mode 100644
index 000000000000..8fe4bc783e44
--- /dev/null
+++ b/databases/postgresql74-server/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/postgresql74-server/files/post-install-notes b/databases/postgresql74-server/files/post-install-notes
new file mode 100644
index 000000000000..6d26c8799339
--- /dev/null
+++ b/databases/postgresql74-server/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/postgresql74-server/pkg-comment b/databases/postgresql74-server/pkg-comment
new file mode 100644
index 000000000000..55a303f3106a
--- /dev/null
+++ b/databases/postgresql74-server/pkg-comment
@@ -0,0 +1 @@
+a next-generation DBMS research prototype.
diff --git a/databases/postgresql74-server/pkg-descr b/databases/postgresql74-server/pkg-descr
new file mode 100644
index 000000000000..2743afb25835
--- /dev/null
+++ b/databases/postgresql74-server/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/postgresql74-server/pkg-plist b/databases/postgresql74-server/pkg-plist
new file mode 100644
index 000000000000..43a0ebb2e780
--- /dev/null
+++ b/databases/postgresql74-server/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/postgresql74-server/scripts/createuser b/databases/postgresql74-server/scripts/createuser
new file mode 100644
index 000000000000..4c24a164fbd6
--- /dev/null
+++ b/databases/postgresql74-server/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 );
+}
diff --git a/databases/postgresql80-server/Makefile b/databases/postgresql80-server/Makefile
new file mode 100644
index 000000000000..8fe4bc783e44
--- /dev/null
+++ b/databases/postgresql80-server/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/postgresql80-server/files/post-install-notes b/databases/postgresql80-server/files/post-install-notes
new file mode 100644
index 000000000000..6d26c8799339
--- /dev/null
+++ b/databases/postgresql80-server/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/postgresql80-server/pkg-comment b/databases/postgresql80-server/pkg-comment
new file mode 100644
index 000000000000..55a303f3106a
--- /dev/null
+++ b/databases/postgresql80-server/pkg-comment
@@ -0,0 +1 @@
+a next-generation DBMS research prototype.
diff --git a/databases/postgresql80-server/pkg-descr b/databases/postgresql80-server/pkg-descr
new file mode 100644
index 000000000000..2743afb25835
--- /dev/null
+++ b/databases/postgresql80-server/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/postgresql80-server/pkg-plist b/databases/postgresql80-server/pkg-plist
new file mode 100644
index 000000000000..43a0ebb2e780
--- /dev/null
+++ b/databases/postgresql80-server/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/postgresql80-server/scripts/createuser b/databases/postgresql80-server/scripts/createuser
new file mode 100644
index 000000000000..4c24a164fbd6
--- /dev/null
+++ b/databases/postgresql80-server/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 );
+}
diff --git a/databases/postgresql81-server/Makefile b/databases/postgresql81-server/Makefile
new file mode 100644
index 000000000000..8fe4bc783e44
--- /dev/null
+++ b/databases/postgresql81-server/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/postgresql81-server/files/post-install-notes b/databases/postgresql81-server/files/post-install-notes
new file mode 100644
index 000000000000..6d26c8799339
--- /dev/null
+++ b/databases/postgresql81-server/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/postgresql81-server/pkg-comment b/databases/postgresql81-server/pkg-comment
new file mode 100644
index 000000000000..55a303f3106a
--- /dev/null
+++ b/databases/postgresql81-server/pkg-comment
@@ -0,0 +1 @@
+a next-generation DBMS research prototype.
diff --git a/databases/postgresql81-server/pkg-descr b/databases/postgresql81-server/pkg-descr
new file mode 100644
index 000000000000..2743afb25835
--- /dev/null
+++ b/databases/postgresql81-server/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/postgresql81-server/pkg-plist b/databases/postgresql81-server/pkg-plist
new file mode 100644
index 000000000000..43a0ebb2e780
--- /dev/null
+++ b/databases/postgresql81-server/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/postgresql81-server/scripts/createuser b/databases/postgresql81-server/scripts/createuser
new file mode 100644
index 000000000000..4c24a164fbd6
--- /dev/null
+++ b/databases/postgresql81-server/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 );
+}
diff --git a/databases/postgresql82-server/Makefile b/databases/postgresql82-server/Makefile
new file mode 100644
index 000000000000..8fe4bc783e44
--- /dev/null
+++ b/databases/postgresql82-server/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/postgresql82-server/files/post-install-notes b/databases/postgresql82-server/files/post-install-notes
new file mode 100644
index 000000000000..6d26c8799339
--- /dev/null
+++ b/databases/postgresql82-server/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/postgresql82-server/pkg-comment b/databases/postgresql82-server/pkg-comment
new file mode 100644
index 000000000000..55a303f3106a
--- /dev/null
+++ b/databases/postgresql82-server/pkg-comment
@@ -0,0 +1 @@
+a next-generation DBMS research prototype.
diff --git a/databases/postgresql82-server/pkg-descr b/databases/postgresql82-server/pkg-descr
new file mode 100644
index 000000000000..2743afb25835
--- /dev/null
+++ b/databases/postgresql82-server/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/postgresql82-server/pkg-plist b/databases/postgresql82-server/pkg-plist
new file mode 100644
index 000000000000..43a0ebb2e780
--- /dev/null
+++ b/databases/postgresql82-server/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/postgresql82-server/scripts/createuser b/databases/postgresql82-server/scripts/createuser
new file mode 100644
index 000000000000..4c24a164fbd6
--- /dev/null
+++ b/databases/postgresql82-server/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 );
+}
diff --git a/databases/postgresql83-server/Makefile b/databases/postgresql83-server/Makefile
new file mode 100644
index 000000000000..8fe4bc783e44
--- /dev/null
+++ b/databases/postgresql83-server/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/postgresql83-server/files/post-install-notes b/databases/postgresql83-server/files/post-install-notes
new file mode 100644
index 000000000000..6d26c8799339
--- /dev/null
+++ b/databases/postgresql83-server/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/postgresql83-server/pkg-comment b/databases/postgresql83-server/pkg-comment
new file mode 100644
index 000000000000..55a303f3106a
--- /dev/null
+++ b/databases/postgresql83-server/pkg-comment
@@ -0,0 +1 @@
+a next-generation DBMS research prototype.
diff --git a/databases/postgresql83-server/pkg-descr b/databases/postgresql83-server/pkg-descr
new file mode 100644
index 000000000000..2743afb25835
--- /dev/null
+++ b/databases/postgresql83-server/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/postgresql83-server/pkg-plist b/databases/postgresql83-server/pkg-plist
new file mode 100644
index 000000000000..43a0ebb2e780
--- /dev/null
+++ b/databases/postgresql83-server/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/postgresql83-server/scripts/createuser b/databases/postgresql83-server/scripts/createuser
new file mode 100644
index 000000000000..4c24a164fbd6
--- /dev/null
+++ b/databases/postgresql83-server/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 );
+}
diff --git a/databases/postgresql84-server/Makefile b/databases/postgresql84-server/Makefile
new file mode 100644
index 000000000000..8fe4bc783e44
--- /dev/null
+++ b/databases/postgresql84-server/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/postgresql84-server/files/post-install-notes b/databases/postgresql84-server/files/post-install-notes
new file mode 100644
index 000000000000..6d26c8799339
--- /dev/null
+++ b/databases/postgresql84-server/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/postgresql84-server/pkg-comment b/databases/postgresql84-server/pkg-comment
new file mode 100644
index 000000000000..55a303f3106a
--- /dev/null
+++ b/databases/postgresql84-server/pkg-comment
@@ -0,0 +1 @@
+a next-generation DBMS research prototype.
diff --git a/databases/postgresql84-server/pkg-descr b/databases/postgresql84-server/pkg-descr
new file mode 100644
index 000000000000..2743afb25835
--- /dev/null
+++ b/databases/postgresql84-server/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/postgresql84-server/pkg-plist b/databases/postgresql84-server/pkg-plist
new file mode 100644
index 000000000000..43a0ebb2e780
--- /dev/null
+++ b/databases/postgresql84-server/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/postgresql84-server/scripts/createuser b/databases/postgresql84-server/scripts/createuser
new file mode 100644
index 000000000000..4c24a164fbd6
--- /dev/null
+++ b/databases/postgresql84-server/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 );
+}
diff --git a/databases/postgresql90-server/Makefile b/databases/postgresql90-server/Makefile
new file mode 100644
index 000000000000..8fe4bc783e44
--- /dev/null
+++ b/databases/postgresql90-server/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/postgresql90-server/files/post-install-notes b/databases/postgresql90-server/files/post-install-notes
new file mode 100644
index 000000000000..6d26c8799339
--- /dev/null
+++ b/databases/postgresql90-server/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/postgresql90-server/pkg-comment b/databases/postgresql90-server/pkg-comment
new file mode 100644
index 000000000000..55a303f3106a
--- /dev/null
+++ b/databases/postgresql90-server/pkg-comment
@@ -0,0 +1 @@
+a next-generation DBMS research prototype.
diff --git a/databases/postgresql90-server/pkg-descr b/databases/postgresql90-server/pkg-descr
new file mode 100644
index 000000000000..2743afb25835
--- /dev/null
+++ b/databases/postgresql90-server/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/postgresql90-server/pkg-plist b/databases/postgresql90-server/pkg-plist
new file mode 100644
index 000000000000..43a0ebb2e780
--- /dev/null
+++ b/databases/postgresql90-server/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/postgresql90-server/scripts/createuser b/databases/postgresql90-server/scripts/createuser
new file mode 100644
index 000000000000..4c24a164fbd6
--- /dev/null
+++ b/databases/postgresql90-server/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 );
+}
diff --git a/databases/postgresql91-server/Makefile b/databases/postgresql91-server/Makefile
new file mode 100644
index 000000000000..8fe4bc783e44
--- /dev/null
+++ b/databases/postgresql91-server/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/postgresql91-server/files/post-install-notes b/databases/postgresql91-server/files/post-install-notes
new file mode 100644
index 000000000000..6d26c8799339
--- /dev/null
+++ b/databases/postgresql91-server/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/postgresql91-server/pkg-comment b/databases/postgresql91-server/pkg-comment
new file mode 100644
index 000000000000..55a303f3106a
--- /dev/null
+++ b/databases/postgresql91-server/pkg-comment
@@ -0,0 +1 @@
+a next-generation DBMS research prototype.
diff --git a/databases/postgresql91-server/pkg-descr b/databases/postgresql91-server/pkg-descr
new file mode 100644
index 000000000000..2743afb25835
--- /dev/null
+++ b/databases/postgresql91-server/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/postgresql91-server/pkg-plist b/databases/postgresql91-server/pkg-plist
new file mode 100644
index 000000000000..43a0ebb2e780
--- /dev/null
+++ b/databases/postgresql91-server/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/postgresql91-server/scripts/createuser b/databases/postgresql91-server/scripts/createuser
new file mode 100644
index 000000000000..4c24a164fbd6
--- /dev/null
+++ b/databases/postgresql91-server/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 );
+}
diff --git a/databases/postgresql92-server/Makefile b/databases/postgresql92-server/Makefile
new file mode 100644
index 000000000000..8fe4bc783e44
--- /dev/null
+++ b/databases/postgresql92-server/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/postgresql92-server/files/post-install-notes b/databases/postgresql92-server/files/post-install-notes
new file mode 100644
index 000000000000..6d26c8799339
--- /dev/null
+++ b/databases/postgresql92-server/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/postgresql92-server/pkg-comment b/databases/postgresql92-server/pkg-comment
new file mode 100644
index 000000000000..55a303f3106a
--- /dev/null
+++ b/databases/postgresql92-server/pkg-comment
@@ -0,0 +1 @@
+a next-generation DBMS research prototype.
diff --git a/databases/postgresql92-server/pkg-descr b/databases/postgresql92-server/pkg-descr
new file mode 100644
index 000000000000..2743afb25835
--- /dev/null
+++ b/databases/postgresql92-server/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/postgresql92-server/pkg-plist b/databases/postgresql92-server/pkg-plist
new file mode 100644
index 000000000000..43a0ebb2e780
--- /dev/null
+++ b/databases/postgresql92-server/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/postgresql92-server/scripts/createuser b/databases/postgresql92-server/scripts/createuser
new file mode 100644
index 000000000000..4c24a164fbd6
--- /dev/null
+++ b/databases/postgresql92-server/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 );
+}