diff options
| author | Peter Wemm <peter@FreeBSD.org> | 1997-04-09 15:30:55 +0000 |
|---|---|---|
| committer | Peter Wemm <peter@FreeBSD.org> | 1997-04-09 15:30:55 +0000 |
| commit | 52f5f9f7a284fc184aacadeb73cf6bd231756fb7 (patch) | |
| tree | 00446ea86f5980a1d3b25d9672cca7ea2c28848d /databases | |
| parent | Upgrade 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')
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 ); +} |