diff options
| author | andreas <andreas@FreeBSD.org> | 1997-10-03 22:13:36 +0800 |
|---|---|---|
| committer | andreas <andreas@FreeBSD.org> | 1997-10-03 22:13:36 +0800 |
| commit | 29aefee03577958662c4cffbbef6cbc03df2b8fc (patch) | |
| tree | 260ec26c93ff886e9795f67e594a02d688f67608 | |
| parent | 11afda4376396b533c7fc99c374a57706bbc4652 (diff) | |
| download | freebsd-ports-graphics-29aefee03577958662c4cffbbef6cbc03df2b8fc.tar.gz freebsd-ports-graphics-29aefee03577958662c4cffbbef6cbc03df2b8fc.tar.zst freebsd-ports-graphics-29aefee03577958662c4cffbbef6cbc03df2b8fc.zip | |
Upgrade from version 6.1.1 to 6.2
Please note: when performing a migration to 6.2 and you have an existing db,
then you have to use the *new* pg_dumpall script that comes with this new
postgresql release. The INSTALL file points this out explicitely !!!
Changes:
- startup script resides in FILESDIR
- renamed it to be in sync with INSTALL file from sources
- always install this startup script over an existing, because
of the nature of the rc.d directory I can't install it
to pgsql.sh-dist, if a pgsql.sh is already presend ...
- portlint detected trailing whitespace, usage of perl with absolute
path, usage of echo instead of ECHO and plenty things of this kind
- post installation notes updated, mentioned the mailing list
- copies the html pages as well to the share/doc directory (new manual dir)
- had to update PLIST
- shortened DESCR file, to match the 24 lines
- added post build target, that reminds the admin how to proceed when
already having a database -> INSTALL file describes migration
- updated manpages
84 files changed, 1694 insertions, 672 deletions
diff --git a/databases/postgresql-devel-server/Makefile b/databases/postgresql-devel-server/Makefile index f11b16deb17..be9e1d8230a 100644 --- a/databases/postgresql-devel-server/Makefile +++ b/databases/postgresql-devel-server/Makefile @@ -1,17 +1,16 @@ # New ports collection makefile for: PostgreSQL -# Version required: 6.1 +# Version required: 6.1 # Date created: April 2, 1997 # Whom: Marc G. Fournier <scrappy@FreeBSD.ORG> # -# $Id: Makefile,v 1.13 1997/07/17 15:12:40 max Exp $ +# $Id: Makefile,v 1.14 1997/09/27 21:43:48 andreas Exp $ -DISTNAME= postgresql-v6.1.1 -PKGNAME= postgresql-6.1.1 +DISTNAME= postgresql-6.2 CATEGORIES= databases MASTER_SITES= ftp://ftp.PostgreSQL.org/pub/ \ ftp://ftp.luga.or.at/pub/postgres95/ \ - ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ - + ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ + MAINTAINER= andreas@FreeBSD.ORG NO_PACKAGE= "Requires pgsql uid" @@ -20,59 +19,71 @@ USE_GMAKE= YES HAS_CONFIGURE= YES CONFIGURE_ARGS+=--prefix=${PREFIX}/pgsql \ --enable-locale \ - --with-template=`uname -s | tr '[A-Z]' '[a-z]'` + --with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'` MAKEFILE= GNUmakefile MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 postgres.1 postmaster.1 psql.1 unix.1 -MAN3= built-in.3 catalogs.3 large_objects.3 libpq.3 oracle_compat.3 -MAN5= bki.5 page.5 pg_hba.conf.5 + pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + postmaster.1 psql.1 +MAN3= catalogs.3 large_objects.3 libpq.3 oracle_compat.3 pgbuiltin.3 +MAN5= bki.5 page.5 pg_hba.conf.5 MANL= abort.l alter_table.l begin.l close.l cluster.l \ commit.l copy.l create_aggregate.l create_database.l \ create_function.l create_index.l create_operator.l \ create_rule.l create_sequence.l create_table.l \ - create_type.l create_version.l create_view.l delete.l \ - drop.l drop_aggregate.l drop_database.l drop_function.l \ - drop_index.l drop_operator.l drop_rule.l drop_sequence.l \ + create_trigger.l create_type.l create_version.l \ + create_view.l declare.l delete.l drop.l drop_aggregate.l \ + drop_database.l drop_function.l drop_index.l drop_operator.l \ + drop_rule.l drop_sequence.l drop_table.l drop_trigger.l \ drop_type.l drop_view.l end.l explain.l fetch.l grant.l \ - insert.l listen.l load.l notify.l purge.l rename.l \ - reset.l revoke.l rollback.l select.l set.l show.l \ - sql.l update.l vacuum.l + insert.l listen.l load.l move.l notify.l purge.l rename.l \ + reset.l revoke.l rollback.l select.l set.l show.l sql.l \ + update.l vacuum.l + MANPREFIX= ${PREFIX}/pgsql +post-build: + @ ${ECHO} "------------------------------------------------------------" + @ ${ECHO} "Dump existing databases, before installing new db version !!" + @ ${ECHO} "Detailed instructions, see INSTALL file under ${WRKDIR}... " + @ ${ECHO} "------------------------------------------------------------" + pre-install: @ ${MKDIR} ${PREFIX}/pgsql - @ ${SETENV} ${MAKE_ENV} /usr/bin/perl ${SCRIPTDIR}/createuser + @ ${SETENV} ${MAKE_ENV} perl ${SCRIPTDIR}/createuser post-install: @ if [ ! -f ${PREFIX}/pgsql/.profile ]; then \ - echo "PATH=${PATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "PATH=${PATH}:${PREFIX}/pgsql/bin" \ > ${PREFIX}/pgsql/.profile; \ - echo "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "PGLIB=${PREFIX}/pgsql/lib" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGLIB=${PREFIX}/pgsql/lib" \ + ${ECHO} "PGDATA=${PREFIX}/pgsql/data" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGDATA=${PREFIX}/pgsql/data" \ + ${ECHO} "export PATH MANPATH PGLIB PGDATA" \ >> ${PREFIX}/pgsql/.profile; \ - echo "export PATH MANPATH PGLIB PGDATA" \ + ${ECHO} "# if you want to make regression tests use this TZ" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#TZ=PST8PDT" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#export TZ" \ >> ${PREFIX}/pgsql/.profile; \ fi @ chown -R pgsql:pgsql ${PREFIX}/pgsql - @ echo 'Initializing PostgreSQL Databases - this may take a few minutes...' + @ ${ECHO} 'Initializing PostgreSQL Databases - this may take a few minutes...' @ ${LDCONFIG} -m ${PREFIX}/pgsql/lib @ su -l pgsql -c '${PREFIX}/pgsql/bin/initdb --pglib=${PREFIX}/pgsql/lib --pgdata=${PREFIX}/pgsql/data' - @ if [ ! -f ${PREFIX}/etc/rc.d/postgresql.sh ]; then \ - echo "Installing ${PREFIX}/etc/rc.d/postgresql.sh startup file."; \ - echo "#!/bin/sh" > ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -d ${PREFIX}/pgsql/lib ] && /sbin/ldconfig -m ${PREFIX}/pgsql/lib" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -x ${PREFIX}/pgsql/bin/postmaster ] && su -l pgsql -c '${PREFIX}/pgsql/bin/postmaster -D${PREFIX}/pgsql/data -o -F > ${PREFIX}/pgsql/errlog &' && echo -n ' pgsql'" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - chmod 751 ${PREFIX}/etc/rc.d/postgresql.sh; \ - fi + @ ${SED} -e "s=!!PREFIX!!=${PREFIX}=g" < ${FILESDIR}/pgsql.sh.tmpl \ + > ${PREFIX}/etc/rc.d/pgsql.sh + @ chmod 554 ${PREFIX}/etc/rc.d/pgsql.sh + @ chown root.pgsql ${PREFIX}/etc/rc.d/pgsql.sh @ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/pgsql .if !defined(NOPORTDOCS) ${MKDIR} ${PREFIX}/share/doc/pgsql - ${CP} ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql + ${CP} -r ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql .endif .if !defined(BATCH) @ more -e ${FILESDIR}/post-install-notes diff --git a/databases/postgresql-devel-server/distinfo b/databases/postgresql-devel-server/distinfo index 70b03de859e..312e4988872 100644 --- a/databases/postgresql-devel-server/distinfo +++ b/databases/postgresql-devel-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-v6.1.1.tar.gz) = d80f2b459d00bea269435bb4ca05bd78 +MD5 (postgresql-6.2.tar.gz) = 4c59757f6405a6c3011399e3c502afd7 diff --git a/databases/postgresql-devel-server/files/pgsql.sh.tmpl b/databases/postgresql-devel-server/files/pgsql.sh.tmpl new file mode 100644 index 00000000000..7321cf4f472 --- /dev/null +++ b/databases/postgresql-devel-server/files/pgsql.sh.tmpl @@ -0,0 +1,21 @@ +#!/bin/sh + +# $Id$ + +# pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) + +# Changes: +# - renamed startup script to be in sync with INSTALL file +# - merged ldconfig start sequence from former postgrsql.sh script (andreas) +# - modified the postmaster startup sequence as suggested in the +# INSTALL file which was given as example for FreeBSD 2.2 (andreas) + + +[ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib + +[ -x !!PREFIX!!/pgsql/bin/postmaster ] && { + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster + -D!!PREFIX!!/pgsql/data + -S -o -F > !!PREFIX!!/pgsql/errlog' & + echo -n ' pgsql' +} diff --git a/databases/postgresql-devel-server/files/post-install-notes b/databases/postgresql-devel-server/files/post-install-notes index 1956d17766c..910966e67f1 100644 --- a/databases/postgresql-devel-server/files/post-install-notes +++ b/databases/postgresql-devel-server/files/post-install-notes @@ -4,3 +4,7 @@ implementation guides. These can be found at: http://www.PostgreSQL.org/docs +You may wish to subscribe to the PostgreSQL user-support mailing list. +Send an e-mail to pgsql-questions-request@postgresql.org with the +text "subscribe" in the message body. + diff --git a/databases/postgresql-devel-server/pkg-descr b/databases/postgresql-devel-server/pkg-descr index 680bf5c7f2b..f0283be0cd6 100644 --- a/databases/postgresql-devel-server/pkg-descr +++ b/databases/postgresql-devel-server/pkg-descr @@ -1,4 +1,3 @@ - PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), derived from the Berkeley Postgres database management system. While PostgreSQL retains the powerful object-relational data model, rich data types @@ -16,12 +15,10 @@ memory, PostgreSQL was born. PostgreSQL development is presently being performed by a team of Internet developers who are now responsible for all current and future development. The -development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.Org). +development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG). Support is available from the PostgreSQL developer/user community through the -support mailing list (questions@PostgreSQL.Org). +support mailing list (questions@PostgreSQL.ORG). PostgreSQL is free and the complete source is available. -More information and documentation can be found on the PostgreSQL website, -at: http://www.PostgreSQL.Org - +More information and documentation, visit: http://www.PostgreSQL.ORG/ diff --git a/databases/postgresql-devel-server/pkg-plist b/databases/postgresql-devel-server/pkg-plist index 6801de7d0d9..4a28e685189 100644 --- a/databases/postgresql-devel-server/pkg-plist +++ b/databases/postgresql-devel-server/pkg-plist @@ -1,4 +1,4 @@ -etc/rc.d/postgresql.sh +etc/rc.d/pgsql.sh pgsql/.profile pgsql/bin/cleardbdir pgsql/bin/createdb @@ -9,8 +9,10 @@ pgsql/bin/initdb pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id +pgsql/bin/pg_passwd pgsql/bin/pg_version pgsql/bin/postgres +pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -20,6 +22,8 @@ pgsql/data/base/template1/pg_amop pgsql/data/base/template1/pg_amproc pgsql/data/base/template1/pg_attnameind pgsql/data/base/template1/pg_attnumind +pgsql/data/base/template1/pg_attrdef +pgsql/data/base/template1/pg_attrdefind pgsql/data/base/template1/pg_attrelidind pgsql/data/base/template1/pg_attribute pgsql/data/base/template1/pg_class @@ -39,8 +43,12 @@ pgsql/data/base/template1/pg_proc pgsql/data/base/template1/pg_procidind pgsql/data/base/template1/pg_procnameind pgsql/data/base/template1/pg_procsrcind +pgsql/data/base/template1/pg_relcheck +pgsql/data/base/template1/pg_relcheckind pgsql/data/base/template1/pg_rewrite pgsql/data/base/template1/pg_statistic +pgsql/data/base/template1/pg_trigger +pgsql/data/base/template1/pg_trigrelidind pgsql/data/base/template1/pg_type pgsql/data/base/template1/pg_typeidind pgsql/data/base/template1/pg_typenameind @@ -74,6 +82,7 @@ pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source pgsql/lib/libpq.a +pgsql/lib/libpq.so pgsql/lib/libpq.so.1.0 pgsql/lib/local1_template1.bki.source pgsql/lib/pg_geqo.sample @@ -88,15 +97,16 @@ pgsql/man/man1/ipcclean.1.gz pgsql/man/man1/monitor.1.gz pgsql/man/man1/pg_dump.1.gz pgsql/man/man1/pg_dumpall.1.gz +pgsql/man/man1/pg_passwd.1.gz +pgsql/man/man1/pgintro.1.gz pgsql/man/man1/postgres.1.gz pgsql/man/man1/postmaster.1.gz pgsql/man/man1/psql.1.gz -pgsql/man/man1/unix.1.gz -pgsql/man/man3/built-in.3.gz pgsql/man/man3/catalogs.3.gz pgsql/man/man3/large_objects.3.gz pgsql/man/man3/libpq.3.gz pgsql/man/man3/oracle_compat.3.gz +pgsql/man/man3/pgbuiltin.3.gz pgsql/man/man5/bki.5.gz pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz @@ -115,9 +125,11 @@ pgsql/man/manl/create_operator.l.gz pgsql/man/manl/create_rule.l.gz pgsql/man/manl/create_sequence.l.gz pgsql/man/manl/create_table.l.gz +pgsql/man/manl/create_trigger.l.gz pgsql/man/manl/create_type.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz +pgsql/man/manl/declare.l.gz pgsql/man/manl/delete.l.gz pgsql/man/manl/drop.l.gz pgsql/man/manl/drop_aggregate.l.gz @@ -127,6 +139,8 @@ pgsql/man/manl/drop_index.l.gz pgsql/man/manl/drop_operator.l.gz pgsql/man/manl/drop_rule.l.gz pgsql/man/manl/drop_sequence.l.gz +pgsql/man/manl/drop_table.l.gz +pgsql/man/manl/drop_trigger.l.gz pgsql/man/manl/drop_type.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz @@ -136,6 +150,7 @@ pgsql/man/manl/grant.l.gz pgsql/man/manl/insert.l.gz pgsql/man/manl/listen.l.gz pgsql/man/manl/load.l.gz +pgsql/man/manl/move.l.gz pgsql/man/manl/notify.l.gz pgsql/man/manl/purge.l.gz pgsql/man/manl/rename.l.gz @@ -159,24 +174,49 @@ share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO share/doc/pgsql/bug.template share/doc/pgsql/libpgtcl.doc +share/doc/pgsql/manual/admin.html +share/doc/pgsql/manual/advanced.html +share/doc/pgsql/manual/appenda.html +share/doc/pgsql/manual/architec.html +share/doc/pgsql/manual/copy.html +share/doc/pgsql/manual/extend.html +share/doc/pgsql/manual/figure01.gif +share/doc/pgsql/manual/figure02.gif +share/doc/pgsql/manual/figure03.gif +share/doc/pgsql/manual/intro.html +share/doc/pgsql/manual/libpq.html +share/doc/pgsql/manual/lobj.html +share/doc/pgsql/manual/pg95user.html +share/doc/pgsql/manual/query.html +share/doc/pgsql/manual/refs.html +share/doc/pgsql/manual/rules.html +share/doc/pgsql/manual/start.html +share/doc/pgsql/manual/xaggr.html +share/doc/pgsql/manual/xfunc.html +share/doc/pgsql/manual/xindex.html +share/doc/pgsql/manual/xoper.html +share/doc/pgsql/manual/xtypes.html +share/doc/pgsql/spi.txt +share/doc/pgsql/trigger.txt share/doc/pgsql/userguide.ps +@dirrm share/doc/pgsql/manual @dirrm share/doc/pgsql -@dirrm pgsql/lib @dirrm pgsql/bin -@dirrm pgsql/include/port/BSD44_derived -@dirrm pgsql/include/port +@dirrm pgsql/data/base/template1 +@dirrm pgsql/data/base +@dirrm pgsql/data +@dirrm pgsql/include/access @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq +@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port @dirrm pgsql/include/utils -@dirrm pgsql/include/access @dirrm pgsql/include +@dirrm pgsql/lib @dirrm pgsql/man/man1 @dirrm pgsql/man/man3 @dirrm pgsql/man/man5 @dirrm pgsql/man/manl @dirrm pgsql/man -@dirrm pgsql/data/base/template1 -@dirrm pgsql/data/base -@dirrm pgsql/data @dirrm pgsql diff --git a/databases/postgresql-devel/Makefile b/databases/postgresql-devel/Makefile index f11b16deb17..be9e1d8230a 100644 --- a/databases/postgresql-devel/Makefile +++ b/databases/postgresql-devel/Makefile @@ -1,17 +1,16 @@ # New ports collection makefile for: PostgreSQL -# Version required: 6.1 +# Version required: 6.1 # Date created: April 2, 1997 # Whom: Marc G. Fournier <scrappy@FreeBSD.ORG> # -# $Id: Makefile,v 1.13 1997/07/17 15:12:40 max Exp $ +# $Id: Makefile,v 1.14 1997/09/27 21:43:48 andreas Exp $ -DISTNAME= postgresql-v6.1.1 -PKGNAME= postgresql-6.1.1 +DISTNAME= postgresql-6.2 CATEGORIES= databases MASTER_SITES= ftp://ftp.PostgreSQL.org/pub/ \ ftp://ftp.luga.or.at/pub/postgres95/ \ - ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ - + ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ + MAINTAINER= andreas@FreeBSD.ORG NO_PACKAGE= "Requires pgsql uid" @@ -20,59 +19,71 @@ USE_GMAKE= YES HAS_CONFIGURE= YES CONFIGURE_ARGS+=--prefix=${PREFIX}/pgsql \ --enable-locale \ - --with-template=`uname -s | tr '[A-Z]' '[a-z]'` + --with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'` MAKEFILE= GNUmakefile MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 postgres.1 postmaster.1 psql.1 unix.1 -MAN3= built-in.3 catalogs.3 large_objects.3 libpq.3 oracle_compat.3 -MAN5= bki.5 page.5 pg_hba.conf.5 + pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + postmaster.1 psql.1 +MAN3= catalogs.3 large_objects.3 libpq.3 oracle_compat.3 pgbuiltin.3 +MAN5= bki.5 page.5 pg_hba.conf.5 MANL= abort.l alter_table.l begin.l close.l cluster.l \ commit.l copy.l create_aggregate.l create_database.l \ create_function.l create_index.l create_operator.l \ create_rule.l create_sequence.l create_table.l \ - create_type.l create_version.l create_view.l delete.l \ - drop.l drop_aggregate.l drop_database.l drop_function.l \ - drop_index.l drop_operator.l drop_rule.l drop_sequence.l \ + create_trigger.l create_type.l create_version.l \ + create_view.l declare.l delete.l drop.l drop_aggregate.l \ + drop_database.l drop_function.l drop_index.l drop_operator.l \ + drop_rule.l drop_sequence.l drop_table.l drop_trigger.l \ drop_type.l drop_view.l end.l explain.l fetch.l grant.l \ - insert.l listen.l load.l notify.l purge.l rename.l \ - reset.l revoke.l rollback.l select.l set.l show.l \ - sql.l update.l vacuum.l + insert.l listen.l load.l move.l notify.l purge.l rename.l \ + reset.l revoke.l rollback.l select.l set.l show.l sql.l \ + update.l vacuum.l + MANPREFIX= ${PREFIX}/pgsql +post-build: + @ ${ECHO} "------------------------------------------------------------" + @ ${ECHO} "Dump existing databases, before installing new db version !!" + @ ${ECHO} "Detailed instructions, see INSTALL file under ${WRKDIR}... " + @ ${ECHO} "------------------------------------------------------------" + pre-install: @ ${MKDIR} ${PREFIX}/pgsql - @ ${SETENV} ${MAKE_ENV} /usr/bin/perl ${SCRIPTDIR}/createuser + @ ${SETENV} ${MAKE_ENV} perl ${SCRIPTDIR}/createuser post-install: @ if [ ! -f ${PREFIX}/pgsql/.profile ]; then \ - echo "PATH=${PATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "PATH=${PATH}:${PREFIX}/pgsql/bin" \ > ${PREFIX}/pgsql/.profile; \ - echo "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "PGLIB=${PREFIX}/pgsql/lib" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGLIB=${PREFIX}/pgsql/lib" \ + ${ECHO} "PGDATA=${PREFIX}/pgsql/data" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGDATA=${PREFIX}/pgsql/data" \ + ${ECHO} "export PATH MANPATH PGLIB PGDATA" \ >> ${PREFIX}/pgsql/.profile; \ - echo "export PATH MANPATH PGLIB PGDATA" \ + ${ECHO} "# if you want to make regression tests use this TZ" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#TZ=PST8PDT" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#export TZ" \ >> ${PREFIX}/pgsql/.profile; \ fi @ chown -R pgsql:pgsql ${PREFIX}/pgsql - @ echo 'Initializing PostgreSQL Databases - this may take a few minutes...' + @ ${ECHO} 'Initializing PostgreSQL Databases - this may take a few minutes...' @ ${LDCONFIG} -m ${PREFIX}/pgsql/lib @ su -l pgsql -c '${PREFIX}/pgsql/bin/initdb --pglib=${PREFIX}/pgsql/lib --pgdata=${PREFIX}/pgsql/data' - @ if [ ! -f ${PREFIX}/etc/rc.d/postgresql.sh ]; then \ - echo "Installing ${PREFIX}/etc/rc.d/postgresql.sh startup file."; \ - echo "#!/bin/sh" > ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -d ${PREFIX}/pgsql/lib ] && /sbin/ldconfig -m ${PREFIX}/pgsql/lib" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -x ${PREFIX}/pgsql/bin/postmaster ] && su -l pgsql -c '${PREFIX}/pgsql/bin/postmaster -D${PREFIX}/pgsql/data -o -F > ${PREFIX}/pgsql/errlog &' && echo -n ' pgsql'" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - chmod 751 ${PREFIX}/etc/rc.d/postgresql.sh; \ - fi + @ ${SED} -e "s=!!PREFIX!!=${PREFIX}=g" < ${FILESDIR}/pgsql.sh.tmpl \ + > ${PREFIX}/etc/rc.d/pgsql.sh + @ chmod 554 ${PREFIX}/etc/rc.d/pgsql.sh + @ chown root.pgsql ${PREFIX}/etc/rc.d/pgsql.sh @ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/pgsql .if !defined(NOPORTDOCS) ${MKDIR} ${PREFIX}/share/doc/pgsql - ${CP} ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql + ${CP} -r ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql .endif .if !defined(BATCH) @ more -e ${FILESDIR}/post-install-notes diff --git a/databases/postgresql-devel/distinfo b/databases/postgresql-devel/distinfo index 70b03de859e..312e4988872 100644 --- a/databases/postgresql-devel/distinfo +++ b/databases/postgresql-devel/distinfo @@ -1 +1 @@ -MD5 (postgresql-v6.1.1.tar.gz) = d80f2b459d00bea269435bb4ca05bd78 +MD5 (postgresql-6.2.tar.gz) = 4c59757f6405a6c3011399e3c502afd7 diff --git a/databases/postgresql-devel/files/pgsql.sh.tmpl b/databases/postgresql-devel/files/pgsql.sh.tmpl new file mode 100644 index 00000000000..7321cf4f472 --- /dev/null +++ b/databases/postgresql-devel/files/pgsql.sh.tmpl @@ -0,0 +1,21 @@ +#!/bin/sh + +# $Id$ + +# pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) + +# Changes: +# - renamed startup script to be in sync with INSTALL file +# - merged ldconfig start sequence from former postgrsql.sh script (andreas) +# - modified the postmaster startup sequence as suggested in the +# INSTALL file which was given as example for FreeBSD 2.2 (andreas) + + +[ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib + +[ -x !!PREFIX!!/pgsql/bin/postmaster ] && { + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster + -D!!PREFIX!!/pgsql/data + -S -o -F > !!PREFIX!!/pgsql/errlog' & + echo -n ' pgsql' +} diff --git a/databases/postgresql-devel/files/post-install-notes b/databases/postgresql-devel/files/post-install-notes index 1956d17766c..910966e67f1 100644 --- a/databases/postgresql-devel/files/post-install-notes +++ b/databases/postgresql-devel/files/post-install-notes @@ -4,3 +4,7 @@ implementation guides. These can be found at: http://www.PostgreSQL.org/docs +You may wish to subscribe to the PostgreSQL user-support mailing list. +Send an e-mail to pgsql-questions-request@postgresql.org with the +text "subscribe" in the message body. + diff --git a/databases/postgresql-devel/pkg-descr b/databases/postgresql-devel/pkg-descr index 680bf5c7f2b..f0283be0cd6 100644 --- a/databases/postgresql-devel/pkg-descr +++ b/databases/postgresql-devel/pkg-descr @@ -1,4 +1,3 @@ - PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), derived from the Berkeley Postgres database management system. While PostgreSQL retains the powerful object-relational data model, rich data types @@ -16,12 +15,10 @@ memory, PostgreSQL was born. PostgreSQL development is presently being performed by a team of Internet developers who are now responsible for all current and future development. The -development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.Org). +development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG). Support is available from the PostgreSQL developer/user community through the -support mailing list (questions@PostgreSQL.Org). +support mailing list (questions@PostgreSQL.ORG). PostgreSQL is free and the complete source is available. -More information and documentation can be found on the PostgreSQL website, -at: http://www.PostgreSQL.Org - +More information and documentation, visit: http://www.PostgreSQL.ORG/ diff --git a/databases/postgresql-devel/pkg-plist b/databases/postgresql-devel/pkg-plist index 6801de7d0d9..4a28e685189 100644 --- a/databases/postgresql-devel/pkg-plist +++ b/databases/postgresql-devel/pkg-plist @@ -1,4 +1,4 @@ -etc/rc.d/postgresql.sh +etc/rc.d/pgsql.sh pgsql/.profile pgsql/bin/cleardbdir pgsql/bin/createdb @@ -9,8 +9,10 @@ pgsql/bin/initdb pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id +pgsql/bin/pg_passwd pgsql/bin/pg_version pgsql/bin/postgres +pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -20,6 +22,8 @@ pgsql/data/base/template1/pg_amop pgsql/data/base/template1/pg_amproc pgsql/data/base/template1/pg_attnameind pgsql/data/base/template1/pg_attnumind +pgsql/data/base/template1/pg_attrdef +pgsql/data/base/template1/pg_attrdefind pgsql/data/base/template1/pg_attrelidind pgsql/data/base/template1/pg_attribute pgsql/data/base/template1/pg_class @@ -39,8 +43,12 @@ pgsql/data/base/template1/pg_proc pgsql/data/base/template1/pg_procidind pgsql/data/base/template1/pg_procnameind pgsql/data/base/template1/pg_procsrcind +pgsql/data/base/template1/pg_relcheck +pgsql/data/base/template1/pg_relcheckind pgsql/data/base/template1/pg_rewrite pgsql/data/base/template1/pg_statistic +pgsql/data/base/template1/pg_trigger +pgsql/data/base/template1/pg_trigrelidind pgsql/data/base/template1/pg_type pgsql/data/base/template1/pg_typeidind pgsql/data/base/template1/pg_typenameind @@ -74,6 +82,7 @@ pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source pgsql/lib/libpq.a +pgsql/lib/libpq.so pgsql/lib/libpq.so.1.0 pgsql/lib/local1_template1.bki.source pgsql/lib/pg_geqo.sample @@ -88,15 +97,16 @@ pgsql/man/man1/ipcclean.1.gz pgsql/man/man1/monitor.1.gz pgsql/man/man1/pg_dump.1.gz pgsql/man/man1/pg_dumpall.1.gz +pgsql/man/man1/pg_passwd.1.gz +pgsql/man/man1/pgintro.1.gz pgsql/man/man1/postgres.1.gz pgsql/man/man1/postmaster.1.gz pgsql/man/man1/psql.1.gz -pgsql/man/man1/unix.1.gz -pgsql/man/man3/built-in.3.gz pgsql/man/man3/catalogs.3.gz pgsql/man/man3/large_objects.3.gz pgsql/man/man3/libpq.3.gz pgsql/man/man3/oracle_compat.3.gz +pgsql/man/man3/pgbuiltin.3.gz pgsql/man/man5/bki.5.gz pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz @@ -115,9 +125,11 @@ pgsql/man/manl/create_operator.l.gz pgsql/man/manl/create_rule.l.gz pgsql/man/manl/create_sequence.l.gz pgsql/man/manl/create_table.l.gz +pgsql/man/manl/create_trigger.l.gz pgsql/man/manl/create_type.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz +pgsql/man/manl/declare.l.gz pgsql/man/manl/delete.l.gz pgsql/man/manl/drop.l.gz pgsql/man/manl/drop_aggregate.l.gz @@ -127,6 +139,8 @@ pgsql/man/manl/drop_index.l.gz pgsql/man/manl/drop_operator.l.gz pgsql/man/manl/drop_rule.l.gz pgsql/man/manl/drop_sequence.l.gz +pgsql/man/manl/drop_table.l.gz +pgsql/man/manl/drop_trigger.l.gz pgsql/man/manl/drop_type.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz @@ -136,6 +150,7 @@ pgsql/man/manl/grant.l.gz pgsql/man/manl/insert.l.gz pgsql/man/manl/listen.l.gz pgsql/man/manl/load.l.gz +pgsql/man/manl/move.l.gz pgsql/man/manl/notify.l.gz pgsql/man/manl/purge.l.gz pgsql/man/manl/rename.l.gz @@ -159,24 +174,49 @@ share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO share/doc/pgsql/bug.template share/doc/pgsql/libpgtcl.doc +share/doc/pgsql/manual/admin.html +share/doc/pgsql/manual/advanced.html +share/doc/pgsql/manual/appenda.html +share/doc/pgsql/manual/architec.html +share/doc/pgsql/manual/copy.html +share/doc/pgsql/manual/extend.html +share/doc/pgsql/manual/figure01.gif +share/doc/pgsql/manual/figure02.gif +share/doc/pgsql/manual/figure03.gif +share/doc/pgsql/manual/intro.html +share/doc/pgsql/manual/libpq.html +share/doc/pgsql/manual/lobj.html +share/doc/pgsql/manual/pg95user.html +share/doc/pgsql/manual/query.html +share/doc/pgsql/manual/refs.html +share/doc/pgsql/manual/rules.html +share/doc/pgsql/manual/start.html +share/doc/pgsql/manual/xaggr.html +share/doc/pgsql/manual/xfunc.html +share/doc/pgsql/manual/xindex.html +share/doc/pgsql/manual/xoper.html +share/doc/pgsql/manual/xtypes.html +share/doc/pgsql/spi.txt +share/doc/pgsql/trigger.txt share/doc/pgsql/userguide.ps +@dirrm share/doc/pgsql/manual @dirrm share/doc/pgsql -@dirrm pgsql/lib @dirrm pgsql/bin -@dirrm pgsql/include/port/BSD44_derived -@dirrm pgsql/include/port +@dirrm pgsql/data/base/template1 +@dirrm pgsql/data/base +@dirrm pgsql/data +@dirrm pgsql/include/access @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq +@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port @dirrm pgsql/include/utils -@dirrm pgsql/include/access @dirrm pgsql/include +@dirrm pgsql/lib @dirrm pgsql/man/man1 @dirrm pgsql/man/man3 @dirrm pgsql/man/man5 @dirrm pgsql/man/manl @dirrm pgsql/man -@dirrm pgsql/data/base/template1 -@dirrm pgsql/data/base -@dirrm pgsql/data @dirrm pgsql diff --git a/databases/postgresql7/Makefile b/databases/postgresql7/Makefile index f11b16deb17..be9e1d8230a 100644 --- a/databases/postgresql7/Makefile +++ b/databases/postgresql7/Makefile @@ -1,17 +1,16 @@ # New ports collection makefile for: PostgreSQL -# Version required: 6.1 +# Version required: 6.1 # Date created: April 2, 1997 # Whom: Marc G. Fournier <scrappy@FreeBSD.ORG> # -# $Id: Makefile,v 1.13 1997/07/17 15:12:40 max Exp $ +# $Id: Makefile,v 1.14 1997/09/27 21:43:48 andreas Exp $ -DISTNAME= postgresql-v6.1.1 -PKGNAME= postgresql-6.1.1 +DISTNAME= postgresql-6.2 CATEGORIES= databases MASTER_SITES= ftp://ftp.PostgreSQL.org/pub/ \ ftp://ftp.luga.or.at/pub/postgres95/ \ - ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ - + ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ + MAINTAINER= andreas@FreeBSD.ORG NO_PACKAGE= "Requires pgsql uid" @@ -20,59 +19,71 @@ USE_GMAKE= YES HAS_CONFIGURE= YES CONFIGURE_ARGS+=--prefix=${PREFIX}/pgsql \ --enable-locale \ - --with-template=`uname -s | tr '[A-Z]' '[a-z]'` + --with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'` MAKEFILE= GNUmakefile MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 postgres.1 postmaster.1 psql.1 unix.1 -MAN3= built-in.3 catalogs.3 large_objects.3 libpq.3 oracle_compat.3 -MAN5= bki.5 page.5 pg_hba.conf.5 + pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + postmaster.1 psql.1 +MAN3= catalogs.3 large_objects.3 libpq.3 oracle_compat.3 pgbuiltin.3 +MAN5= bki.5 page.5 pg_hba.conf.5 MANL= abort.l alter_table.l begin.l close.l cluster.l \ commit.l copy.l create_aggregate.l create_database.l \ create_function.l create_index.l create_operator.l \ create_rule.l create_sequence.l create_table.l \ - create_type.l create_version.l create_view.l delete.l \ - drop.l drop_aggregate.l drop_database.l drop_function.l \ - drop_index.l drop_operator.l drop_rule.l drop_sequence.l \ + create_trigger.l create_type.l create_version.l \ + create_view.l declare.l delete.l drop.l drop_aggregate.l \ + drop_database.l drop_function.l drop_index.l drop_operator.l \ + drop_rule.l drop_sequence.l drop_table.l drop_trigger.l \ drop_type.l drop_view.l end.l explain.l fetch.l grant.l \ - insert.l listen.l load.l notify.l purge.l rename.l \ - reset.l revoke.l rollback.l select.l set.l show.l \ - sql.l update.l vacuum.l + insert.l listen.l load.l move.l notify.l purge.l rename.l \ + reset.l revoke.l rollback.l select.l set.l show.l sql.l \ + update.l vacuum.l + MANPREFIX= ${PREFIX}/pgsql +post-build: + @ ${ECHO} "------------------------------------------------------------" + @ ${ECHO} "Dump existing databases, before installing new db version !!" + @ ${ECHO} "Detailed instructions, see INSTALL file under ${WRKDIR}... " + @ ${ECHO} "------------------------------------------------------------" + pre-install: @ ${MKDIR} ${PREFIX}/pgsql - @ ${SETENV} ${MAKE_ENV} /usr/bin/perl ${SCRIPTDIR}/createuser + @ ${SETENV} ${MAKE_ENV} perl ${SCRIPTDIR}/createuser post-install: @ if [ ! -f ${PREFIX}/pgsql/.profile ]; then \ - echo "PATH=${PATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "PATH=${PATH}:${PREFIX}/pgsql/bin" \ > ${PREFIX}/pgsql/.profile; \ - echo "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "PGLIB=${PREFIX}/pgsql/lib" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGLIB=${PREFIX}/pgsql/lib" \ + ${ECHO} "PGDATA=${PREFIX}/pgsql/data" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGDATA=${PREFIX}/pgsql/data" \ + ${ECHO} "export PATH MANPATH PGLIB PGDATA" \ >> ${PREFIX}/pgsql/.profile; \ - echo "export PATH MANPATH PGLIB PGDATA" \ + ${ECHO} "# if you want to make regression tests use this TZ" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#TZ=PST8PDT" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#export TZ" \ >> ${PREFIX}/pgsql/.profile; \ fi @ chown -R pgsql:pgsql ${PREFIX}/pgsql - @ echo 'Initializing PostgreSQL Databases - this may take a few minutes...' + @ ${ECHO} 'Initializing PostgreSQL Databases - this may take a few minutes...' @ ${LDCONFIG} -m ${PREFIX}/pgsql/lib @ su -l pgsql -c '${PREFIX}/pgsql/bin/initdb --pglib=${PREFIX}/pgsql/lib --pgdata=${PREFIX}/pgsql/data' - @ if [ ! -f ${PREFIX}/etc/rc.d/postgresql.sh ]; then \ - echo "Installing ${PREFIX}/etc/rc.d/postgresql.sh startup file."; \ - echo "#!/bin/sh" > ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -d ${PREFIX}/pgsql/lib ] && /sbin/ldconfig -m ${PREFIX}/pgsql/lib" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -x ${PREFIX}/pgsql/bin/postmaster ] && su -l pgsql -c '${PREFIX}/pgsql/bin/postmaster -D${PREFIX}/pgsql/data -o -F > ${PREFIX}/pgsql/errlog &' && echo -n ' pgsql'" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - chmod 751 ${PREFIX}/etc/rc.d/postgresql.sh; \ - fi + @ ${SED} -e "s=!!PREFIX!!=${PREFIX}=g" < ${FILESDIR}/pgsql.sh.tmpl \ + > ${PREFIX}/etc/rc.d/pgsql.sh + @ chmod 554 ${PREFIX}/etc/rc.d/pgsql.sh + @ chown root.pgsql ${PREFIX}/etc/rc.d/pgsql.sh @ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/pgsql .if !defined(NOPORTDOCS) ${MKDIR} ${PREFIX}/share/doc/pgsql - ${CP} ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql + ${CP} -r ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql .endif .if !defined(BATCH) @ more -e ${FILESDIR}/post-install-notes diff --git a/databases/postgresql7/distinfo b/databases/postgresql7/distinfo index 70b03de859e..312e4988872 100644 --- a/databases/postgresql7/distinfo +++ b/databases/postgresql7/distinfo @@ -1 +1 @@ -MD5 (postgresql-v6.1.1.tar.gz) = d80f2b459d00bea269435bb4ca05bd78 +MD5 (postgresql-6.2.tar.gz) = 4c59757f6405a6c3011399e3c502afd7 diff --git a/databases/postgresql7/files/pgsql.sh.tmpl b/databases/postgresql7/files/pgsql.sh.tmpl new file mode 100644 index 00000000000..7321cf4f472 --- /dev/null +++ b/databases/postgresql7/files/pgsql.sh.tmpl @@ -0,0 +1,21 @@ +#!/bin/sh + +# $Id$ + +# pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) + +# Changes: +# - renamed startup script to be in sync with INSTALL file +# - merged ldconfig start sequence from former postgrsql.sh script (andreas) +# - modified the postmaster startup sequence as suggested in the +# INSTALL file which was given as example for FreeBSD 2.2 (andreas) + + +[ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib + +[ -x !!PREFIX!!/pgsql/bin/postmaster ] && { + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster + -D!!PREFIX!!/pgsql/data + -S -o -F > !!PREFIX!!/pgsql/errlog' & + echo -n ' pgsql' +} diff --git a/databases/postgresql7/files/post-install-notes b/databases/postgresql7/files/post-install-notes index 1956d17766c..910966e67f1 100644 --- a/databases/postgresql7/files/post-install-notes +++ b/databases/postgresql7/files/post-install-notes @@ -4,3 +4,7 @@ implementation guides. These can be found at: http://www.PostgreSQL.org/docs +You may wish to subscribe to the PostgreSQL user-support mailing list. +Send an e-mail to pgsql-questions-request@postgresql.org with the +text "subscribe" in the message body. + diff --git a/databases/postgresql7/pkg-descr b/databases/postgresql7/pkg-descr index 680bf5c7f2b..f0283be0cd6 100644 --- a/databases/postgresql7/pkg-descr +++ b/databases/postgresql7/pkg-descr @@ -1,4 +1,3 @@ - PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), derived from the Berkeley Postgres database management system. While PostgreSQL retains the powerful object-relational data model, rich data types @@ -16,12 +15,10 @@ memory, PostgreSQL was born. PostgreSQL development is presently being performed by a team of Internet developers who are now responsible for all current and future development. The -development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.Org). +development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG). Support is available from the PostgreSQL developer/user community through the -support mailing list (questions@PostgreSQL.Org). +support mailing list (questions@PostgreSQL.ORG). PostgreSQL is free and the complete source is available. -More information and documentation can be found on the PostgreSQL website, -at: http://www.PostgreSQL.Org - +More information and documentation, visit: http://www.PostgreSQL.ORG/ diff --git a/databases/postgresql7/pkg-plist b/databases/postgresql7/pkg-plist index 6801de7d0d9..4a28e685189 100644 --- a/databases/postgresql7/pkg-plist +++ b/databases/postgresql7/pkg-plist @@ -1,4 +1,4 @@ -etc/rc.d/postgresql.sh +etc/rc.d/pgsql.sh pgsql/.profile pgsql/bin/cleardbdir pgsql/bin/createdb @@ -9,8 +9,10 @@ pgsql/bin/initdb pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id +pgsql/bin/pg_passwd pgsql/bin/pg_version pgsql/bin/postgres +pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -20,6 +22,8 @@ pgsql/data/base/template1/pg_amop pgsql/data/base/template1/pg_amproc pgsql/data/base/template1/pg_attnameind pgsql/data/base/template1/pg_attnumind +pgsql/data/base/template1/pg_attrdef +pgsql/data/base/template1/pg_attrdefind pgsql/data/base/template1/pg_attrelidind pgsql/data/base/template1/pg_attribute pgsql/data/base/template1/pg_class @@ -39,8 +43,12 @@ pgsql/data/base/template1/pg_proc pgsql/data/base/template1/pg_procidind pgsql/data/base/template1/pg_procnameind pgsql/data/base/template1/pg_procsrcind +pgsql/data/base/template1/pg_relcheck +pgsql/data/base/template1/pg_relcheckind pgsql/data/base/template1/pg_rewrite pgsql/data/base/template1/pg_statistic +pgsql/data/base/template1/pg_trigger +pgsql/data/base/template1/pg_trigrelidind pgsql/data/base/template1/pg_type pgsql/data/base/template1/pg_typeidind pgsql/data/base/template1/pg_typenameind @@ -74,6 +82,7 @@ pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source pgsql/lib/libpq.a +pgsql/lib/libpq.so pgsql/lib/libpq.so.1.0 pgsql/lib/local1_template1.bki.source pgsql/lib/pg_geqo.sample @@ -88,15 +97,16 @@ pgsql/man/man1/ipcclean.1.gz pgsql/man/man1/monitor.1.gz pgsql/man/man1/pg_dump.1.gz pgsql/man/man1/pg_dumpall.1.gz +pgsql/man/man1/pg_passwd.1.gz +pgsql/man/man1/pgintro.1.gz pgsql/man/man1/postgres.1.gz pgsql/man/man1/postmaster.1.gz pgsql/man/man1/psql.1.gz -pgsql/man/man1/unix.1.gz -pgsql/man/man3/built-in.3.gz pgsql/man/man3/catalogs.3.gz pgsql/man/man3/large_objects.3.gz pgsql/man/man3/libpq.3.gz pgsql/man/man3/oracle_compat.3.gz +pgsql/man/man3/pgbuiltin.3.gz pgsql/man/man5/bki.5.gz pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz @@ -115,9 +125,11 @@ pgsql/man/manl/create_operator.l.gz pgsql/man/manl/create_rule.l.gz pgsql/man/manl/create_sequence.l.gz pgsql/man/manl/create_table.l.gz +pgsql/man/manl/create_trigger.l.gz pgsql/man/manl/create_type.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz +pgsql/man/manl/declare.l.gz pgsql/man/manl/delete.l.gz pgsql/man/manl/drop.l.gz pgsql/man/manl/drop_aggregate.l.gz @@ -127,6 +139,8 @@ pgsql/man/manl/drop_index.l.gz pgsql/man/manl/drop_operator.l.gz pgsql/man/manl/drop_rule.l.gz pgsql/man/manl/drop_sequence.l.gz +pgsql/man/manl/drop_table.l.gz +pgsql/man/manl/drop_trigger.l.gz pgsql/man/manl/drop_type.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz @@ -136,6 +150,7 @@ pgsql/man/manl/grant.l.gz pgsql/man/manl/insert.l.gz pgsql/man/manl/listen.l.gz pgsql/man/manl/load.l.gz +pgsql/man/manl/move.l.gz pgsql/man/manl/notify.l.gz pgsql/man/manl/purge.l.gz pgsql/man/manl/rename.l.gz @@ -159,24 +174,49 @@ share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO share/doc/pgsql/bug.template share/doc/pgsql/libpgtcl.doc +share/doc/pgsql/manual/admin.html +share/doc/pgsql/manual/advanced.html +share/doc/pgsql/manual/appenda.html +share/doc/pgsql/manual/architec.html +share/doc/pgsql/manual/copy.html +share/doc/pgsql/manual/extend.html +share/doc/pgsql/manual/figure01.gif +share/doc/pgsql/manual/figure02.gif +share/doc/pgsql/manual/figure03.gif +share/doc/pgsql/manual/intro.html +share/doc/pgsql/manual/libpq.html +share/doc/pgsql/manual/lobj.html +share/doc/pgsql/manual/pg95user.html +share/doc/pgsql/manual/query.html +share/doc/pgsql/manual/refs.html +share/doc/pgsql/manual/rules.html +share/doc/pgsql/manual/start.html +share/doc/pgsql/manual/xaggr.html +share/doc/pgsql/manual/xfunc.html +share/doc/pgsql/manual/xindex.html +share/doc/pgsql/manual/xoper.html +share/doc/pgsql/manual/xtypes.html +share/doc/pgsql/spi.txt +share/doc/pgsql/trigger.txt share/doc/pgsql/userguide.ps +@dirrm share/doc/pgsql/manual @dirrm share/doc/pgsql -@dirrm pgsql/lib @dirrm pgsql/bin -@dirrm pgsql/include/port/BSD44_derived -@dirrm pgsql/include/port +@dirrm pgsql/data/base/template1 +@dirrm pgsql/data/base +@dirrm pgsql/data +@dirrm pgsql/include/access @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq +@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port @dirrm pgsql/include/utils -@dirrm pgsql/include/access @dirrm pgsql/include +@dirrm pgsql/lib @dirrm pgsql/man/man1 @dirrm pgsql/man/man3 @dirrm pgsql/man/man5 @dirrm pgsql/man/manl @dirrm pgsql/man -@dirrm pgsql/data/base/template1 -@dirrm pgsql/data/base -@dirrm pgsql/data @dirrm pgsql diff --git a/databases/postgresql73-server/Makefile b/databases/postgresql73-server/Makefile index f11b16deb17..be9e1d8230a 100644 --- a/databases/postgresql73-server/Makefile +++ b/databases/postgresql73-server/Makefile @@ -1,17 +1,16 @@ # New ports collection makefile for: PostgreSQL -# Version required: 6.1 +# Version required: 6.1 # Date created: April 2, 1997 # Whom: Marc G. Fournier <scrappy@FreeBSD.ORG> # -# $Id: Makefile,v 1.13 1997/07/17 15:12:40 max Exp $ +# $Id: Makefile,v 1.14 1997/09/27 21:43:48 andreas Exp $ -DISTNAME= postgresql-v6.1.1 -PKGNAME= postgresql-6.1.1 +DISTNAME= postgresql-6.2 CATEGORIES= databases MASTER_SITES= ftp://ftp.PostgreSQL.org/pub/ \ ftp://ftp.luga.or.at/pub/postgres95/ \ - ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ - + ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ + MAINTAINER= andreas@FreeBSD.ORG NO_PACKAGE= "Requires pgsql uid" @@ -20,59 +19,71 @@ USE_GMAKE= YES HAS_CONFIGURE= YES CONFIGURE_ARGS+=--prefix=${PREFIX}/pgsql \ --enable-locale \ - --with-template=`uname -s | tr '[A-Z]' '[a-z]'` + --with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'` MAKEFILE= GNUmakefile MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 postgres.1 postmaster.1 psql.1 unix.1 -MAN3= built-in.3 catalogs.3 large_objects.3 libpq.3 oracle_compat.3 -MAN5= bki.5 page.5 pg_hba.conf.5 + pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + postmaster.1 psql.1 +MAN3= catalogs.3 large_objects.3 libpq.3 oracle_compat.3 pgbuiltin.3 +MAN5= bki.5 page.5 pg_hba.conf.5 MANL= abort.l alter_table.l begin.l close.l cluster.l \ commit.l copy.l create_aggregate.l create_database.l \ create_function.l create_index.l create_operator.l \ create_rule.l create_sequence.l create_table.l \ - create_type.l create_version.l create_view.l delete.l \ - drop.l drop_aggregate.l drop_database.l drop_function.l \ - drop_index.l drop_operator.l drop_rule.l drop_sequence.l \ + create_trigger.l create_type.l create_version.l \ + create_view.l declare.l delete.l drop.l drop_aggregate.l \ + drop_database.l drop_function.l drop_index.l drop_operator.l \ + drop_rule.l drop_sequence.l drop_table.l drop_trigger.l \ drop_type.l drop_view.l end.l explain.l fetch.l grant.l \ - insert.l listen.l load.l notify.l purge.l rename.l \ - reset.l revoke.l rollback.l select.l set.l show.l \ - sql.l update.l vacuum.l + insert.l listen.l load.l move.l notify.l purge.l rename.l \ + reset.l revoke.l rollback.l select.l set.l show.l sql.l \ + update.l vacuum.l + MANPREFIX= ${PREFIX}/pgsql +post-build: + @ ${ECHO} "------------------------------------------------------------" + @ ${ECHO} "Dump existing databases, before installing new db version !!" + @ ${ECHO} "Detailed instructions, see INSTALL file under ${WRKDIR}... " + @ ${ECHO} "------------------------------------------------------------" + pre-install: @ ${MKDIR} ${PREFIX}/pgsql - @ ${SETENV} ${MAKE_ENV} /usr/bin/perl ${SCRIPTDIR}/createuser + @ ${SETENV} ${MAKE_ENV} perl ${SCRIPTDIR}/createuser post-install: @ if [ ! -f ${PREFIX}/pgsql/.profile ]; then \ - echo "PATH=${PATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "PATH=${PATH}:${PREFIX}/pgsql/bin" \ > ${PREFIX}/pgsql/.profile; \ - echo "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "PGLIB=${PREFIX}/pgsql/lib" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGLIB=${PREFIX}/pgsql/lib" \ + ${ECHO} "PGDATA=${PREFIX}/pgsql/data" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGDATA=${PREFIX}/pgsql/data" \ + ${ECHO} "export PATH MANPATH PGLIB PGDATA" \ >> ${PREFIX}/pgsql/.profile; \ - echo "export PATH MANPATH PGLIB PGDATA" \ + ${ECHO} "# if you want to make regression tests use this TZ" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#TZ=PST8PDT" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#export TZ" \ >> ${PREFIX}/pgsql/.profile; \ fi @ chown -R pgsql:pgsql ${PREFIX}/pgsql - @ echo 'Initializing PostgreSQL Databases - this may take a few minutes...' + @ ${ECHO} 'Initializing PostgreSQL Databases - this may take a few minutes...' @ ${LDCONFIG} -m ${PREFIX}/pgsql/lib @ su -l pgsql -c '${PREFIX}/pgsql/bin/initdb --pglib=${PREFIX}/pgsql/lib --pgdata=${PREFIX}/pgsql/data' - @ if [ ! -f ${PREFIX}/etc/rc.d/postgresql.sh ]; then \ - echo "Installing ${PREFIX}/etc/rc.d/postgresql.sh startup file."; \ - echo "#!/bin/sh" > ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -d ${PREFIX}/pgsql/lib ] && /sbin/ldconfig -m ${PREFIX}/pgsql/lib" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -x ${PREFIX}/pgsql/bin/postmaster ] && su -l pgsql -c '${PREFIX}/pgsql/bin/postmaster -D${PREFIX}/pgsql/data -o -F > ${PREFIX}/pgsql/errlog &' && echo -n ' pgsql'" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - chmod 751 ${PREFIX}/etc/rc.d/postgresql.sh; \ - fi + @ ${SED} -e "s=!!PREFIX!!=${PREFIX}=g" < ${FILESDIR}/pgsql.sh.tmpl \ + > ${PREFIX}/etc/rc.d/pgsql.sh + @ chmod 554 ${PREFIX}/etc/rc.d/pgsql.sh + @ chown root.pgsql ${PREFIX}/etc/rc.d/pgsql.sh @ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/pgsql .if !defined(NOPORTDOCS) ${MKDIR} ${PREFIX}/share/doc/pgsql - ${CP} ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql + ${CP} -r ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql .endif .if !defined(BATCH) @ more -e ${FILESDIR}/post-install-notes diff --git a/databases/postgresql73-server/distinfo b/databases/postgresql73-server/distinfo index 70b03de859e..312e4988872 100644 --- a/databases/postgresql73-server/distinfo +++ b/databases/postgresql73-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-v6.1.1.tar.gz) = d80f2b459d00bea269435bb4ca05bd78 +MD5 (postgresql-6.2.tar.gz) = 4c59757f6405a6c3011399e3c502afd7 diff --git a/databases/postgresql73-server/files/pgsql.sh.tmpl b/databases/postgresql73-server/files/pgsql.sh.tmpl new file mode 100644 index 00000000000..7321cf4f472 --- /dev/null +++ b/databases/postgresql73-server/files/pgsql.sh.tmpl @@ -0,0 +1,21 @@ +#!/bin/sh + +# $Id$ + +# pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) + +# Changes: +# - renamed startup script to be in sync with INSTALL file +# - merged ldconfig start sequence from former postgrsql.sh script (andreas) +# - modified the postmaster startup sequence as suggested in the +# INSTALL file which was given as example for FreeBSD 2.2 (andreas) + + +[ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib + +[ -x !!PREFIX!!/pgsql/bin/postmaster ] && { + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster + -D!!PREFIX!!/pgsql/data + -S -o -F > !!PREFIX!!/pgsql/errlog' & + echo -n ' pgsql' +} diff --git a/databases/postgresql73-server/files/post-install-notes b/databases/postgresql73-server/files/post-install-notes index 1956d17766c..910966e67f1 100644 --- a/databases/postgresql73-server/files/post-install-notes +++ b/databases/postgresql73-server/files/post-install-notes @@ -4,3 +4,7 @@ implementation guides. These can be found at: http://www.PostgreSQL.org/docs +You may wish to subscribe to the PostgreSQL user-support mailing list. +Send an e-mail to pgsql-questions-request@postgresql.org with the +text "subscribe" in the message body. + diff --git a/databases/postgresql73-server/pkg-descr b/databases/postgresql73-server/pkg-descr index 680bf5c7f2b..f0283be0cd6 100644 --- a/databases/postgresql73-server/pkg-descr +++ b/databases/postgresql73-server/pkg-descr @@ -1,4 +1,3 @@ - PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), derived from the Berkeley Postgres database management system. While PostgreSQL retains the powerful object-relational data model, rich data types @@ -16,12 +15,10 @@ memory, PostgreSQL was born. PostgreSQL development is presently being performed by a team of Internet developers who are now responsible for all current and future development. The -development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.Org). +development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG). Support is available from the PostgreSQL developer/user community through the -support mailing list (questions@PostgreSQL.Org). +support mailing list (questions@PostgreSQL.ORG). PostgreSQL is free and the complete source is available. -More information and documentation can be found on the PostgreSQL website, -at: http://www.PostgreSQL.Org - +More information and documentation, visit: http://www.PostgreSQL.ORG/ diff --git a/databases/postgresql73-server/pkg-plist b/databases/postgresql73-server/pkg-plist index 6801de7d0d9..4a28e685189 100644 --- a/databases/postgresql73-server/pkg-plist +++ b/databases/postgresql73-server/pkg-plist @@ -1,4 +1,4 @@ -etc/rc.d/postgresql.sh +etc/rc.d/pgsql.sh pgsql/.profile pgsql/bin/cleardbdir pgsql/bin/createdb @@ -9,8 +9,10 @@ pgsql/bin/initdb pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id +pgsql/bin/pg_passwd pgsql/bin/pg_version pgsql/bin/postgres +pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -20,6 +22,8 @@ pgsql/data/base/template1/pg_amop pgsql/data/base/template1/pg_amproc pgsql/data/base/template1/pg_attnameind pgsql/data/base/template1/pg_attnumind +pgsql/data/base/template1/pg_attrdef +pgsql/data/base/template1/pg_attrdefind pgsql/data/base/template1/pg_attrelidind pgsql/data/base/template1/pg_attribute pgsql/data/base/template1/pg_class @@ -39,8 +43,12 @@ pgsql/data/base/template1/pg_proc pgsql/data/base/template1/pg_procidind pgsql/data/base/template1/pg_procnameind pgsql/data/base/template1/pg_procsrcind +pgsql/data/base/template1/pg_relcheck +pgsql/data/base/template1/pg_relcheckind pgsql/data/base/template1/pg_rewrite pgsql/data/base/template1/pg_statistic +pgsql/data/base/template1/pg_trigger +pgsql/data/base/template1/pg_trigrelidind pgsql/data/base/template1/pg_type pgsql/data/base/template1/pg_typeidind pgsql/data/base/template1/pg_typenameind @@ -74,6 +82,7 @@ pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source pgsql/lib/libpq.a +pgsql/lib/libpq.so pgsql/lib/libpq.so.1.0 pgsql/lib/local1_template1.bki.source pgsql/lib/pg_geqo.sample @@ -88,15 +97,16 @@ pgsql/man/man1/ipcclean.1.gz pgsql/man/man1/monitor.1.gz pgsql/man/man1/pg_dump.1.gz pgsql/man/man1/pg_dumpall.1.gz +pgsql/man/man1/pg_passwd.1.gz +pgsql/man/man1/pgintro.1.gz pgsql/man/man1/postgres.1.gz pgsql/man/man1/postmaster.1.gz pgsql/man/man1/psql.1.gz -pgsql/man/man1/unix.1.gz -pgsql/man/man3/built-in.3.gz pgsql/man/man3/catalogs.3.gz pgsql/man/man3/large_objects.3.gz pgsql/man/man3/libpq.3.gz pgsql/man/man3/oracle_compat.3.gz +pgsql/man/man3/pgbuiltin.3.gz pgsql/man/man5/bki.5.gz pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz @@ -115,9 +125,11 @@ pgsql/man/manl/create_operator.l.gz pgsql/man/manl/create_rule.l.gz pgsql/man/manl/create_sequence.l.gz pgsql/man/manl/create_table.l.gz +pgsql/man/manl/create_trigger.l.gz pgsql/man/manl/create_type.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz +pgsql/man/manl/declare.l.gz pgsql/man/manl/delete.l.gz pgsql/man/manl/drop.l.gz pgsql/man/manl/drop_aggregate.l.gz @@ -127,6 +139,8 @@ pgsql/man/manl/drop_index.l.gz pgsql/man/manl/drop_operator.l.gz pgsql/man/manl/drop_rule.l.gz pgsql/man/manl/drop_sequence.l.gz +pgsql/man/manl/drop_table.l.gz +pgsql/man/manl/drop_trigger.l.gz pgsql/man/manl/drop_type.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz @@ -136,6 +150,7 @@ pgsql/man/manl/grant.l.gz pgsql/man/manl/insert.l.gz pgsql/man/manl/listen.l.gz pgsql/man/manl/load.l.gz +pgsql/man/manl/move.l.gz pgsql/man/manl/notify.l.gz pgsql/man/manl/purge.l.gz pgsql/man/manl/rename.l.gz @@ -159,24 +174,49 @@ share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO share/doc/pgsql/bug.template share/doc/pgsql/libpgtcl.doc +share/doc/pgsql/manual/admin.html +share/doc/pgsql/manual/advanced.html +share/doc/pgsql/manual/appenda.html +share/doc/pgsql/manual/architec.html +share/doc/pgsql/manual/copy.html +share/doc/pgsql/manual/extend.html +share/doc/pgsql/manual/figure01.gif +share/doc/pgsql/manual/figure02.gif +share/doc/pgsql/manual/figure03.gif +share/doc/pgsql/manual/intro.html +share/doc/pgsql/manual/libpq.html +share/doc/pgsql/manual/lobj.html +share/doc/pgsql/manual/pg95user.html +share/doc/pgsql/manual/query.html +share/doc/pgsql/manual/refs.html +share/doc/pgsql/manual/rules.html +share/doc/pgsql/manual/start.html +share/doc/pgsql/manual/xaggr.html +share/doc/pgsql/manual/xfunc.html +share/doc/pgsql/manual/xindex.html +share/doc/pgsql/manual/xoper.html +share/doc/pgsql/manual/xtypes.html +share/doc/pgsql/spi.txt +share/doc/pgsql/trigger.txt share/doc/pgsql/userguide.ps +@dirrm share/doc/pgsql/manual @dirrm share/doc/pgsql -@dirrm pgsql/lib @dirrm pgsql/bin -@dirrm pgsql/include/port/BSD44_derived -@dirrm pgsql/include/port +@dirrm pgsql/data/base/template1 +@dirrm pgsql/data/base +@dirrm pgsql/data +@dirrm pgsql/include/access @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq +@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port @dirrm pgsql/include/utils -@dirrm pgsql/include/access @dirrm pgsql/include +@dirrm pgsql/lib @dirrm pgsql/man/man1 @dirrm pgsql/man/man3 @dirrm pgsql/man/man5 @dirrm pgsql/man/manl @dirrm pgsql/man -@dirrm pgsql/data/base/template1 -@dirrm pgsql/data/base -@dirrm pgsql/data @dirrm pgsql diff --git a/databases/postgresql73/Makefile b/databases/postgresql73/Makefile index f11b16deb17..be9e1d8230a 100644 --- a/databases/postgresql73/Makefile +++ b/databases/postgresql73/Makefile @@ -1,17 +1,16 @@ # New ports collection makefile for: PostgreSQL -# Version required: 6.1 +# Version required: 6.1 # Date created: April 2, 1997 # Whom: Marc G. Fournier <scrappy@FreeBSD.ORG> # -# $Id: Makefile,v 1.13 1997/07/17 15:12:40 max Exp $ +# $Id: Makefile,v 1.14 1997/09/27 21:43:48 andreas Exp $ -DISTNAME= postgresql-v6.1.1 -PKGNAME= postgresql-6.1.1 +DISTNAME= postgresql-6.2 CATEGORIES= databases MASTER_SITES= ftp://ftp.PostgreSQL.org/pub/ \ ftp://ftp.luga.or.at/pub/postgres95/ \ - ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ - + ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ + MAINTAINER= andreas@FreeBSD.ORG NO_PACKAGE= "Requires pgsql uid" @@ -20,59 +19,71 @@ USE_GMAKE= YES HAS_CONFIGURE= YES CONFIGURE_ARGS+=--prefix=${PREFIX}/pgsql \ --enable-locale \ - --with-template=`uname -s | tr '[A-Z]' '[a-z]'` + --with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'` MAKEFILE= GNUmakefile MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 postgres.1 postmaster.1 psql.1 unix.1 -MAN3= built-in.3 catalogs.3 large_objects.3 libpq.3 oracle_compat.3 -MAN5= bki.5 page.5 pg_hba.conf.5 + pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + postmaster.1 psql.1 +MAN3= catalogs.3 large_objects.3 libpq.3 oracle_compat.3 pgbuiltin.3 +MAN5= bki.5 page.5 pg_hba.conf.5 MANL= abort.l alter_table.l begin.l close.l cluster.l \ commit.l copy.l create_aggregate.l create_database.l \ create_function.l create_index.l create_operator.l \ create_rule.l create_sequence.l create_table.l \ - create_type.l create_version.l create_view.l delete.l \ - drop.l drop_aggregate.l drop_database.l drop_function.l \ - drop_index.l drop_operator.l drop_rule.l drop_sequence.l \ + create_trigger.l create_type.l create_version.l \ + create_view.l declare.l delete.l drop.l drop_aggregate.l \ + drop_database.l drop_function.l drop_index.l drop_operator.l \ + drop_rule.l drop_sequence.l drop_table.l drop_trigger.l \ drop_type.l drop_view.l end.l explain.l fetch.l grant.l \ - insert.l listen.l load.l notify.l purge.l rename.l \ - reset.l revoke.l rollback.l select.l set.l show.l \ - sql.l update.l vacuum.l + insert.l listen.l load.l move.l notify.l purge.l rename.l \ + reset.l revoke.l rollback.l select.l set.l show.l sql.l \ + update.l vacuum.l + MANPREFIX= ${PREFIX}/pgsql +post-build: + @ ${ECHO} "------------------------------------------------------------" + @ ${ECHO} "Dump existing databases, before installing new db version !!" + @ ${ECHO} "Detailed instructions, see INSTALL file under ${WRKDIR}... " + @ ${ECHO} "------------------------------------------------------------" + pre-install: @ ${MKDIR} ${PREFIX}/pgsql - @ ${SETENV} ${MAKE_ENV} /usr/bin/perl ${SCRIPTDIR}/createuser + @ ${SETENV} ${MAKE_ENV} perl ${SCRIPTDIR}/createuser post-install: @ if [ ! -f ${PREFIX}/pgsql/.profile ]; then \ - echo "PATH=${PATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "PATH=${PATH}:${PREFIX}/pgsql/bin" \ > ${PREFIX}/pgsql/.profile; \ - echo "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "PGLIB=${PREFIX}/pgsql/lib" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGLIB=${PREFIX}/pgsql/lib" \ + ${ECHO} "PGDATA=${PREFIX}/pgsql/data" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGDATA=${PREFIX}/pgsql/data" \ + ${ECHO} "export PATH MANPATH PGLIB PGDATA" \ >> ${PREFIX}/pgsql/.profile; \ - echo "export PATH MANPATH PGLIB PGDATA" \ + ${ECHO} "# if you want to make regression tests use this TZ" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#TZ=PST8PDT" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#export TZ" \ >> ${PREFIX}/pgsql/.profile; \ fi @ chown -R pgsql:pgsql ${PREFIX}/pgsql - @ echo 'Initializing PostgreSQL Databases - this may take a few minutes...' + @ ${ECHO} 'Initializing PostgreSQL Databases - this may take a few minutes...' @ ${LDCONFIG} -m ${PREFIX}/pgsql/lib @ su -l pgsql -c '${PREFIX}/pgsql/bin/initdb --pglib=${PREFIX}/pgsql/lib --pgdata=${PREFIX}/pgsql/data' - @ if [ ! -f ${PREFIX}/etc/rc.d/postgresql.sh ]; then \ - echo "Installing ${PREFIX}/etc/rc.d/postgresql.sh startup file."; \ - echo "#!/bin/sh" > ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -d ${PREFIX}/pgsql/lib ] && /sbin/ldconfig -m ${PREFIX}/pgsql/lib" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -x ${PREFIX}/pgsql/bin/postmaster ] && su -l pgsql -c '${PREFIX}/pgsql/bin/postmaster -D${PREFIX}/pgsql/data -o -F > ${PREFIX}/pgsql/errlog &' && echo -n ' pgsql'" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - chmod 751 ${PREFIX}/etc/rc.d/postgresql.sh; \ - fi + @ ${SED} -e "s=!!PREFIX!!=${PREFIX}=g" < ${FILESDIR}/pgsql.sh.tmpl \ + > ${PREFIX}/etc/rc.d/pgsql.sh + @ chmod 554 ${PREFIX}/etc/rc.d/pgsql.sh + @ chown root.pgsql ${PREFIX}/etc/rc.d/pgsql.sh @ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/pgsql .if !defined(NOPORTDOCS) ${MKDIR} ${PREFIX}/share/doc/pgsql - ${CP} ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql + ${CP} -r ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql .endif .if !defined(BATCH) @ more -e ${FILESDIR}/post-install-notes diff --git a/databases/postgresql73/distinfo b/databases/postgresql73/distinfo index 70b03de859e..312e4988872 100644 --- a/databases/postgresql73/distinfo +++ b/databases/postgresql73/distinfo @@ -1 +1 @@ -MD5 (postgresql-v6.1.1.tar.gz) = d80f2b459d00bea269435bb4ca05bd78 +MD5 (postgresql-6.2.tar.gz) = 4c59757f6405a6c3011399e3c502afd7 diff --git a/databases/postgresql73/files/pgsql.sh.tmpl b/databases/postgresql73/files/pgsql.sh.tmpl new file mode 100644 index 00000000000..7321cf4f472 --- /dev/null +++ b/databases/postgresql73/files/pgsql.sh.tmpl @@ -0,0 +1,21 @@ +#!/bin/sh + +# $Id$ + +# pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) + +# Changes: +# - renamed startup script to be in sync with INSTALL file +# - merged ldconfig start sequence from former postgrsql.sh script (andreas) +# - modified the postmaster startup sequence as suggested in the +# INSTALL file which was given as example for FreeBSD 2.2 (andreas) + + +[ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib + +[ -x !!PREFIX!!/pgsql/bin/postmaster ] && { + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster + -D!!PREFIX!!/pgsql/data + -S -o -F > !!PREFIX!!/pgsql/errlog' & + echo -n ' pgsql' +} diff --git a/databases/postgresql73/files/post-install-notes b/databases/postgresql73/files/post-install-notes index 1956d17766c..910966e67f1 100644 --- a/databases/postgresql73/files/post-install-notes +++ b/databases/postgresql73/files/post-install-notes @@ -4,3 +4,7 @@ implementation guides. These can be found at: http://www.PostgreSQL.org/docs +You may wish to subscribe to the PostgreSQL user-support mailing list. +Send an e-mail to pgsql-questions-request@postgresql.org with the +text "subscribe" in the message body. + diff --git a/databases/postgresql73/pkg-descr b/databases/postgresql73/pkg-descr index 680bf5c7f2b..f0283be0cd6 100644 --- a/databases/postgresql73/pkg-descr +++ b/databases/postgresql73/pkg-descr @@ -1,4 +1,3 @@ - PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), derived from the Berkeley Postgres database management system. While PostgreSQL retains the powerful object-relational data model, rich data types @@ -16,12 +15,10 @@ memory, PostgreSQL was born. PostgreSQL development is presently being performed by a team of Internet developers who are now responsible for all current and future development. The -development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.Org). +development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG). Support is available from the PostgreSQL developer/user community through the -support mailing list (questions@PostgreSQL.Org). +support mailing list (questions@PostgreSQL.ORG). PostgreSQL is free and the complete source is available. -More information and documentation can be found on the PostgreSQL website, -at: http://www.PostgreSQL.Org - +More information and documentation, visit: http://www.PostgreSQL.ORG/ diff --git a/databases/postgresql73/pkg-plist b/databases/postgresql73/pkg-plist index 6801de7d0d9..4a28e685189 100644 --- a/databases/postgresql73/pkg-plist +++ b/databases/postgresql73/pkg-plist @@ -1,4 +1,4 @@ -etc/rc.d/postgresql.sh +etc/rc.d/pgsql.sh pgsql/.profile pgsql/bin/cleardbdir pgsql/bin/createdb @@ -9,8 +9,10 @@ pgsql/bin/initdb pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id +pgsql/bin/pg_passwd pgsql/bin/pg_version pgsql/bin/postgres +pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -20,6 +22,8 @@ pgsql/data/base/template1/pg_amop pgsql/data/base/template1/pg_amproc pgsql/data/base/template1/pg_attnameind pgsql/data/base/template1/pg_attnumind +pgsql/data/base/template1/pg_attrdef +pgsql/data/base/template1/pg_attrdefind pgsql/data/base/template1/pg_attrelidind pgsql/data/base/template1/pg_attribute pgsql/data/base/template1/pg_class @@ -39,8 +43,12 @@ pgsql/data/base/template1/pg_proc pgsql/data/base/template1/pg_procidind pgsql/data/base/template1/pg_procnameind pgsql/data/base/template1/pg_procsrcind +pgsql/data/base/template1/pg_relcheck +pgsql/data/base/template1/pg_relcheckind pgsql/data/base/template1/pg_rewrite pgsql/data/base/template1/pg_statistic +pgsql/data/base/template1/pg_trigger +pgsql/data/base/template1/pg_trigrelidind pgsql/data/base/template1/pg_type pgsql/data/base/template1/pg_typeidind pgsql/data/base/template1/pg_typenameind @@ -74,6 +82,7 @@ pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source pgsql/lib/libpq.a +pgsql/lib/libpq.so pgsql/lib/libpq.so.1.0 pgsql/lib/local1_template1.bki.source pgsql/lib/pg_geqo.sample @@ -88,15 +97,16 @@ pgsql/man/man1/ipcclean.1.gz pgsql/man/man1/monitor.1.gz pgsql/man/man1/pg_dump.1.gz pgsql/man/man1/pg_dumpall.1.gz +pgsql/man/man1/pg_passwd.1.gz +pgsql/man/man1/pgintro.1.gz pgsql/man/man1/postgres.1.gz pgsql/man/man1/postmaster.1.gz pgsql/man/man1/psql.1.gz -pgsql/man/man1/unix.1.gz -pgsql/man/man3/built-in.3.gz pgsql/man/man3/catalogs.3.gz pgsql/man/man3/large_objects.3.gz pgsql/man/man3/libpq.3.gz pgsql/man/man3/oracle_compat.3.gz +pgsql/man/man3/pgbuiltin.3.gz pgsql/man/man5/bki.5.gz pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz @@ -115,9 +125,11 @@ pgsql/man/manl/create_operator.l.gz pgsql/man/manl/create_rule.l.gz pgsql/man/manl/create_sequence.l.gz pgsql/man/manl/create_table.l.gz +pgsql/man/manl/create_trigger.l.gz pgsql/man/manl/create_type.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz +pgsql/man/manl/declare.l.gz pgsql/man/manl/delete.l.gz pgsql/man/manl/drop.l.gz pgsql/man/manl/drop_aggregate.l.gz @@ -127,6 +139,8 @@ pgsql/man/manl/drop_index.l.gz pgsql/man/manl/drop_operator.l.gz pgsql/man/manl/drop_rule.l.gz pgsql/man/manl/drop_sequence.l.gz +pgsql/man/manl/drop_table.l.gz +pgsql/man/manl/drop_trigger.l.gz pgsql/man/manl/drop_type.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz @@ -136,6 +150,7 @@ pgsql/man/manl/grant.l.gz pgsql/man/manl/insert.l.gz pgsql/man/manl/listen.l.gz pgsql/man/manl/load.l.gz +pgsql/man/manl/move.l.gz pgsql/man/manl/notify.l.gz pgsql/man/manl/purge.l.gz pgsql/man/manl/rename.l.gz @@ -159,24 +174,49 @@ share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO share/doc/pgsql/bug.template share/doc/pgsql/libpgtcl.doc +share/doc/pgsql/manual/admin.html +share/doc/pgsql/manual/advanced.html +share/doc/pgsql/manual/appenda.html +share/doc/pgsql/manual/architec.html +share/doc/pgsql/manual/copy.html +share/doc/pgsql/manual/extend.html +share/doc/pgsql/manual/figure01.gif +share/doc/pgsql/manual/figure02.gif +share/doc/pgsql/manual/figure03.gif +share/doc/pgsql/manual/intro.html +share/doc/pgsql/manual/libpq.html +share/doc/pgsql/manual/lobj.html +share/doc/pgsql/manual/pg95user.html +share/doc/pgsql/manual/query.html +share/doc/pgsql/manual/refs.html +share/doc/pgsql/manual/rules.html +share/doc/pgsql/manual/start.html +share/doc/pgsql/manual/xaggr.html +share/doc/pgsql/manual/xfunc.html +share/doc/pgsql/manual/xindex.html +share/doc/pgsql/manual/xoper.html +share/doc/pgsql/manual/xtypes.html +share/doc/pgsql/spi.txt +share/doc/pgsql/trigger.txt share/doc/pgsql/userguide.ps +@dirrm share/doc/pgsql/manual @dirrm share/doc/pgsql -@dirrm pgsql/lib @dirrm pgsql/bin -@dirrm pgsql/include/port/BSD44_derived -@dirrm pgsql/include/port +@dirrm pgsql/data/base/template1 +@dirrm pgsql/data/base +@dirrm pgsql/data +@dirrm pgsql/include/access @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq +@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port @dirrm pgsql/include/utils -@dirrm pgsql/include/access @dirrm pgsql/include +@dirrm pgsql/lib @dirrm pgsql/man/man1 @dirrm pgsql/man/man3 @dirrm pgsql/man/man5 @dirrm pgsql/man/manl @dirrm pgsql/man -@dirrm pgsql/data/base/template1 -@dirrm pgsql/data/base -@dirrm pgsql/data @dirrm pgsql diff --git a/databases/postgresql74-server/Makefile b/databases/postgresql74-server/Makefile index f11b16deb17..be9e1d8230a 100644 --- a/databases/postgresql74-server/Makefile +++ b/databases/postgresql74-server/Makefile @@ -1,17 +1,16 @@ # New ports collection makefile for: PostgreSQL -# Version required: 6.1 +# Version required: 6.1 # Date created: April 2, 1997 # Whom: Marc G. Fournier <scrappy@FreeBSD.ORG> # -# $Id: Makefile,v 1.13 1997/07/17 15:12:40 max Exp $ +# $Id: Makefile,v 1.14 1997/09/27 21:43:48 andreas Exp $ -DISTNAME= postgresql-v6.1.1 -PKGNAME= postgresql-6.1.1 +DISTNAME= postgresql-6.2 CATEGORIES= databases MASTER_SITES= ftp://ftp.PostgreSQL.org/pub/ \ ftp://ftp.luga.or.at/pub/postgres95/ \ - ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ - + ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ + MAINTAINER= andreas@FreeBSD.ORG NO_PACKAGE= "Requires pgsql uid" @@ -20,59 +19,71 @@ USE_GMAKE= YES HAS_CONFIGURE= YES CONFIGURE_ARGS+=--prefix=${PREFIX}/pgsql \ --enable-locale \ - --with-template=`uname -s | tr '[A-Z]' '[a-z]'` + --with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'` MAKEFILE= GNUmakefile MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 postgres.1 postmaster.1 psql.1 unix.1 -MAN3= built-in.3 catalogs.3 large_objects.3 libpq.3 oracle_compat.3 -MAN5= bki.5 page.5 pg_hba.conf.5 + pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + postmaster.1 psql.1 +MAN3= catalogs.3 large_objects.3 libpq.3 oracle_compat.3 pgbuiltin.3 +MAN5= bki.5 page.5 pg_hba.conf.5 MANL= abort.l alter_table.l begin.l close.l cluster.l \ commit.l copy.l create_aggregate.l create_database.l \ create_function.l create_index.l create_operator.l \ create_rule.l create_sequence.l create_table.l \ - create_type.l create_version.l create_view.l delete.l \ - drop.l drop_aggregate.l drop_database.l drop_function.l \ - drop_index.l drop_operator.l drop_rule.l drop_sequence.l \ + create_trigger.l create_type.l create_version.l \ + create_view.l declare.l delete.l drop.l drop_aggregate.l \ + drop_database.l drop_function.l drop_index.l drop_operator.l \ + drop_rule.l drop_sequence.l drop_table.l drop_trigger.l \ drop_type.l drop_view.l end.l explain.l fetch.l grant.l \ - insert.l listen.l load.l notify.l purge.l rename.l \ - reset.l revoke.l rollback.l select.l set.l show.l \ - sql.l update.l vacuum.l + insert.l listen.l load.l move.l notify.l purge.l rename.l \ + reset.l revoke.l rollback.l select.l set.l show.l sql.l \ + update.l vacuum.l + MANPREFIX= ${PREFIX}/pgsql +post-build: + @ ${ECHO} "------------------------------------------------------------" + @ ${ECHO} "Dump existing databases, before installing new db version !!" + @ ${ECHO} "Detailed instructions, see INSTALL file under ${WRKDIR}... " + @ ${ECHO} "------------------------------------------------------------" + pre-install: @ ${MKDIR} ${PREFIX}/pgsql - @ ${SETENV} ${MAKE_ENV} /usr/bin/perl ${SCRIPTDIR}/createuser + @ ${SETENV} ${MAKE_ENV} perl ${SCRIPTDIR}/createuser post-install: @ if [ ! -f ${PREFIX}/pgsql/.profile ]; then \ - echo "PATH=${PATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "PATH=${PATH}:${PREFIX}/pgsql/bin" \ > ${PREFIX}/pgsql/.profile; \ - echo "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "PGLIB=${PREFIX}/pgsql/lib" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGLIB=${PREFIX}/pgsql/lib" \ + ${ECHO} "PGDATA=${PREFIX}/pgsql/data" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGDATA=${PREFIX}/pgsql/data" \ + ${ECHO} "export PATH MANPATH PGLIB PGDATA" \ >> ${PREFIX}/pgsql/.profile; \ - echo "export PATH MANPATH PGLIB PGDATA" \ + ${ECHO} "# if you want to make regression tests use this TZ" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#TZ=PST8PDT" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#export TZ" \ >> ${PREFIX}/pgsql/.profile; \ fi @ chown -R pgsql:pgsql ${PREFIX}/pgsql - @ echo 'Initializing PostgreSQL Databases - this may take a few minutes...' + @ ${ECHO} 'Initializing PostgreSQL Databases - this may take a few minutes...' @ ${LDCONFIG} -m ${PREFIX}/pgsql/lib @ su -l pgsql -c '${PREFIX}/pgsql/bin/initdb --pglib=${PREFIX}/pgsql/lib --pgdata=${PREFIX}/pgsql/data' - @ if [ ! -f ${PREFIX}/etc/rc.d/postgresql.sh ]; then \ - echo "Installing ${PREFIX}/etc/rc.d/postgresql.sh startup file."; \ - echo "#!/bin/sh" > ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -d ${PREFIX}/pgsql/lib ] && /sbin/ldconfig -m ${PREFIX}/pgsql/lib" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -x ${PREFIX}/pgsql/bin/postmaster ] && su -l pgsql -c '${PREFIX}/pgsql/bin/postmaster -D${PREFIX}/pgsql/data -o -F > ${PREFIX}/pgsql/errlog &' && echo -n ' pgsql'" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - chmod 751 ${PREFIX}/etc/rc.d/postgresql.sh; \ - fi + @ ${SED} -e "s=!!PREFIX!!=${PREFIX}=g" < ${FILESDIR}/pgsql.sh.tmpl \ + > ${PREFIX}/etc/rc.d/pgsql.sh + @ chmod 554 ${PREFIX}/etc/rc.d/pgsql.sh + @ chown root.pgsql ${PREFIX}/etc/rc.d/pgsql.sh @ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/pgsql .if !defined(NOPORTDOCS) ${MKDIR} ${PREFIX}/share/doc/pgsql - ${CP} ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql + ${CP} -r ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql .endif .if !defined(BATCH) @ more -e ${FILESDIR}/post-install-notes diff --git a/databases/postgresql74-server/distinfo b/databases/postgresql74-server/distinfo index 70b03de859e..312e4988872 100644 --- a/databases/postgresql74-server/distinfo +++ b/databases/postgresql74-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-v6.1.1.tar.gz) = d80f2b459d00bea269435bb4ca05bd78 +MD5 (postgresql-6.2.tar.gz) = 4c59757f6405a6c3011399e3c502afd7 diff --git a/databases/postgresql74-server/files/pgsql.sh.tmpl b/databases/postgresql74-server/files/pgsql.sh.tmpl new file mode 100644 index 00000000000..7321cf4f472 --- /dev/null +++ b/databases/postgresql74-server/files/pgsql.sh.tmpl @@ -0,0 +1,21 @@ +#!/bin/sh + +# $Id$ + +# pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) + +# Changes: +# - renamed startup script to be in sync with INSTALL file +# - merged ldconfig start sequence from former postgrsql.sh script (andreas) +# - modified the postmaster startup sequence as suggested in the +# INSTALL file which was given as example for FreeBSD 2.2 (andreas) + + +[ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib + +[ -x !!PREFIX!!/pgsql/bin/postmaster ] && { + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster + -D!!PREFIX!!/pgsql/data + -S -o -F > !!PREFIX!!/pgsql/errlog' & + echo -n ' pgsql' +} diff --git a/databases/postgresql74-server/files/post-install-notes b/databases/postgresql74-server/files/post-install-notes index 1956d17766c..910966e67f1 100644 --- a/databases/postgresql74-server/files/post-install-notes +++ b/databases/postgresql74-server/files/post-install-notes @@ -4,3 +4,7 @@ implementation guides. These can be found at: http://www.PostgreSQL.org/docs +You may wish to subscribe to the PostgreSQL user-support mailing list. +Send an e-mail to pgsql-questions-request@postgresql.org with the +text "subscribe" in the message body. + diff --git a/databases/postgresql74-server/pkg-descr b/databases/postgresql74-server/pkg-descr index 680bf5c7f2b..f0283be0cd6 100644 --- a/databases/postgresql74-server/pkg-descr +++ b/databases/postgresql74-server/pkg-descr @@ -1,4 +1,3 @@ - PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), derived from the Berkeley Postgres database management system. While PostgreSQL retains the powerful object-relational data model, rich data types @@ -16,12 +15,10 @@ memory, PostgreSQL was born. PostgreSQL development is presently being performed by a team of Internet developers who are now responsible for all current and future development. The -development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.Org). +development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG). Support is available from the PostgreSQL developer/user community through the -support mailing list (questions@PostgreSQL.Org). +support mailing list (questions@PostgreSQL.ORG). PostgreSQL is free and the complete source is available. -More information and documentation can be found on the PostgreSQL website, -at: http://www.PostgreSQL.Org - +More information and documentation, visit: http://www.PostgreSQL.ORG/ diff --git a/databases/postgresql74-server/pkg-plist b/databases/postgresql74-server/pkg-plist index 6801de7d0d9..4a28e685189 100644 --- a/databases/postgresql74-server/pkg-plist +++ b/databases/postgresql74-server/pkg-plist @@ -1,4 +1,4 @@ -etc/rc.d/postgresql.sh +etc/rc.d/pgsql.sh pgsql/.profile pgsql/bin/cleardbdir pgsql/bin/createdb @@ -9,8 +9,10 @@ pgsql/bin/initdb pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id +pgsql/bin/pg_passwd pgsql/bin/pg_version pgsql/bin/postgres +pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -20,6 +22,8 @@ pgsql/data/base/template1/pg_amop pgsql/data/base/template1/pg_amproc pgsql/data/base/template1/pg_attnameind pgsql/data/base/template1/pg_attnumind +pgsql/data/base/template1/pg_attrdef +pgsql/data/base/template1/pg_attrdefind pgsql/data/base/template1/pg_attrelidind pgsql/data/base/template1/pg_attribute pgsql/data/base/template1/pg_class @@ -39,8 +43,12 @@ pgsql/data/base/template1/pg_proc pgsql/data/base/template1/pg_procidind pgsql/data/base/template1/pg_procnameind pgsql/data/base/template1/pg_procsrcind +pgsql/data/base/template1/pg_relcheck +pgsql/data/base/template1/pg_relcheckind pgsql/data/base/template1/pg_rewrite pgsql/data/base/template1/pg_statistic +pgsql/data/base/template1/pg_trigger +pgsql/data/base/template1/pg_trigrelidind pgsql/data/base/template1/pg_type pgsql/data/base/template1/pg_typeidind pgsql/data/base/template1/pg_typenameind @@ -74,6 +82,7 @@ pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source pgsql/lib/libpq.a +pgsql/lib/libpq.so pgsql/lib/libpq.so.1.0 pgsql/lib/local1_template1.bki.source pgsql/lib/pg_geqo.sample @@ -88,15 +97,16 @@ pgsql/man/man1/ipcclean.1.gz pgsql/man/man1/monitor.1.gz pgsql/man/man1/pg_dump.1.gz pgsql/man/man1/pg_dumpall.1.gz +pgsql/man/man1/pg_passwd.1.gz +pgsql/man/man1/pgintro.1.gz pgsql/man/man1/postgres.1.gz pgsql/man/man1/postmaster.1.gz pgsql/man/man1/psql.1.gz -pgsql/man/man1/unix.1.gz -pgsql/man/man3/built-in.3.gz pgsql/man/man3/catalogs.3.gz pgsql/man/man3/large_objects.3.gz pgsql/man/man3/libpq.3.gz pgsql/man/man3/oracle_compat.3.gz +pgsql/man/man3/pgbuiltin.3.gz pgsql/man/man5/bki.5.gz pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz @@ -115,9 +125,11 @@ pgsql/man/manl/create_operator.l.gz pgsql/man/manl/create_rule.l.gz pgsql/man/manl/create_sequence.l.gz pgsql/man/manl/create_table.l.gz +pgsql/man/manl/create_trigger.l.gz pgsql/man/manl/create_type.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz +pgsql/man/manl/declare.l.gz pgsql/man/manl/delete.l.gz pgsql/man/manl/drop.l.gz pgsql/man/manl/drop_aggregate.l.gz @@ -127,6 +139,8 @@ pgsql/man/manl/drop_index.l.gz pgsql/man/manl/drop_operator.l.gz pgsql/man/manl/drop_rule.l.gz pgsql/man/manl/drop_sequence.l.gz +pgsql/man/manl/drop_table.l.gz +pgsql/man/manl/drop_trigger.l.gz pgsql/man/manl/drop_type.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz @@ -136,6 +150,7 @@ pgsql/man/manl/grant.l.gz pgsql/man/manl/insert.l.gz pgsql/man/manl/listen.l.gz pgsql/man/manl/load.l.gz +pgsql/man/manl/move.l.gz pgsql/man/manl/notify.l.gz pgsql/man/manl/purge.l.gz pgsql/man/manl/rename.l.gz @@ -159,24 +174,49 @@ share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO share/doc/pgsql/bug.template share/doc/pgsql/libpgtcl.doc +share/doc/pgsql/manual/admin.html +share/doc/pgsql/manual/advanced.html +share/doc/pgsql/manual/appenda.html +share/doc/pgsql/manual/architec.html +share/doc/pgsql/manual/copy.html +share/doc/pgsql/manual/extend.html +share/doc/pgsql/manual/figure01.gif +share/doc/pgsql/manual/figure02.gif +share/doc/pgsql/manual/figure03.gif +share/doc/pgsql/manual/intro.html +share/doc/pgsql/manual/libpq.html +share/doc/pgsql/manual/lobj.html +share/doc/pgsql/manual/pg95user.html +share/doc/pgsql/manual/query.html +share/doc/pgsql/manual/refs.html +share/doc/pgsql/manual/rules.html +share/doc/pgsql/manual/start.html +share/doc/pgsql/manual/xaggr.html +share/doc/pgsql/manual/xfunc.html +share/doc/pgsql/manual/xindex.html +share/doc/pgsql/manual/xoper.html +share/doc/pgsql/manual/xtypes.html +share/doc/pgsql/spi.txt +share/doc/pgsql/trigger.txt share/doc/pgsql/userguide.ps +@dirrm share/doc/pgsql/manual @dirrm share/doc/pgsql -@dirrm pgsql/lib @dirrm pgsql/bin -@dirrm pgsql/include/port/BSD44_derived -@dirrm pgsql/include/port +@dirrm pgsql/data/base/template1 +@dirrm pgsql/data/base +@dirrm pgsql/data +@dirrm pgsql/include/access @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq +@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port @dirrm pgsql/include/utils -@dirrm pgsql/include/access @dirrm pgsql/include +@dirrm pgsql/lib @dirrm pgsql/man/man1 @dirrm pgsql/man/man3 @dirrm pgsql/man/man5 @dirrm pgsql/man/manl @dirrm pgsql/man -@dirrm pgsql/data/base/template1 -@dirrm pgsql/data/base -@dirrm pgsql/data @dirrm pgsql diff --git a/databases/postgresql80-server/Makefile b/databases/postgresql80-server/Makefile index f11b16deb17..be9e1d8230a 100644 --- a/databases/postgresql80-server/Makefile +++ b/databases/postgresql80-server/Makefile @@ -1,17 +1,16 @@ # New ports collection makefile for: PostgreSQL -# Version required: 6.1 +# Version required: 6.1 # Date created: April 2, 1997 # Whom: Marc G. Fournier <scrappy@FreeBSD.ORG> # -# $Id: Makefile,v 1.13 1997/07/17 15:12:40 max Exp $ +# $Id: Makefile,v 1.14 1997/09/27 21:43:48 andreas Exp $ -DISTNAME= postgresql-v6.1.1 -PKGNAME= postgresql-6.1.1 +DISTNAME= postgresql-6.2 CATEGORIES= databases MASTER_SITES= ftp://ftp.PostgreSQL.org/pub/ \ ftp://ftp.luga.or.at/pub/postgres95/ \ - ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ - + ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ + MAINTAINER= andreas@FreeBSD.ORG NO_PACKAGE= "Requires pgsql uid" @@ -20,59 +19,71 @@ USE_GMAKE= YES HAS_CONFIGURE= YES CONFIGURE_ARGS+=--prefix=${PREFIX}/pgsql \ --enable-locale \ - --with-template=`uname -s | tr '[A-Z]' '[a-z]'` + --with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'` MAKEFILE= GNUmakefile MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 postgres.1 postmaster.1 psql.1 unix.1 -MAN3= built-in.3 catalogs.3 large_objects.3 libpq.3 oracle_compat.3 -MAN5= bki.5 page.5 pg_hba.conf.5 + pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + postmaster.1 psql.1 +MAN3= catalogs.3 large_objects.3 libpq.3 oracle_compat.3 pgbuiltin.3 +MAN5= bki.5 page.5 pg_hba.conf.5 MANL= abort.l alter_table.l begin.l close.l cluster.l \ commit.l copy.l create_aggregate.l create_database.l \ create_function.l create_index.l create_operator.l \ create_rule.l create_sequence.l create_table.l \ - create_type.l create_version.l create_view.l delete.l \ - drop.l drop_aggregate.l drop_database.l drop_function.l \ - drop_index.l drop_operator.l drop_rule.l drop_sequence.l \ + create_trigger.l create_type.l create_version.l \ + create_view.l declare.l delete.l drop.l drop_aggregate.l \ + drop_database.l drop_function.l drop_index.l drop_operator.l \ + drop_rule.l drop_sequence.l drop_table.l drop_trigger.l \ drop_type.l drop_view.l end.l explain.l fetch.l grant.l \ - insert.l listen.l load.l notify.l purge.l rename.l \ - reset.l revoke.l rollback.l select.l set.l show.l \ - sql.l update.l vacuum.l + insert.l listen.l load.l move.l notify.l purge.l rename.l \ + reset.l revoke.l rollback.l select.l set.l show.l sql.l \ + update.l vacuum.l + MANPREFIX= ${PREFIX}/pgsql +post-build: + @ ${ECHO} "------------------------------------------------------------" + @ ${ECHO} "Dump existing databases, before installing new db version !!" + @ ${ECHO} "Detailed instructions, see INSTALL file under ${WRKDIR}... " + @ ${ECHO} "------------------------------------------------------------" + pre-install: @ ${MKDIR} ${PREFIX}/pgsql - @ ${SETENV} ${MAKE_ENV} /usr/bin/perl ${SCRIPTDIR}/createuser + @ ${SETENV} ${MAKE_ENV} perl ${SCRIPTDIR}/createuser post-install: @ if [ ! -f ${PREFIX}/pgsql/.profile ]; then \ - echo "PATH=${PATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "PATH=${PATH}:${PREFIX}/pgsql/bin" \ > ${PREFIX}/pgsql/.profile; \ - echo "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "PGLIB=${PREFIX}/pgsql/lib" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGLIB=${PREFIX}/pgsql/lib" \ + ${ECHO} "PGDATA=${PREFIX}/pgsql/data" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGDATA=${PREFIX}/pgsql/data" \ + ${ECHO} "export PATH MANPATH PGLIB PGDATA" \ >> ${PREFIX}/pgsql/.profile; \ - echo "export PATH MANPATH PGLIB PGDATA" \ + ${ECHO} "# if you want to make regression tests use this TZ" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#TZ=PST8PDT" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#export TZ" \ >> ${PREFIX}/pgsql/.profile; \ fi @ chown -R pgsql:pgsql ${PREFIX}/pgsql - @ echo 'Initializing PostgreSQL Databases - this may take a few minutes...' + @ ${ECHO} 'Initializing PostgreSQL Databases - this may take a few minutes...' @ ${LDCONFIG} -m ${PREFIX}/pgsql/lib @ su -l pgsql -c '${PREFIX}/pgsql/bin/initdb --pglib=${PREFIX}/pgsql/lib --pgdata=${PREFIX}/pgsql/data' - @ if [ ! -f ${PREFIX}/etc/rc.d/postgresql.sh ]; then \ - echo "Installing ${PREFIX}/etc/rc.d/postgresql.sh startup file."; \ - echo "#!/bin/sh" > ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -d ${PREFIX}/pgsql/lib ] && /sbin/ldconfig -m ${PREFIX}/pgsql/lib" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -x ${PREFIX}/pgsql/bin/postmaster ] && su -l pgsql -c '${PREFIX}/pgsql/bin/postmaster -D${PREFIX}/pgsql/data -o -F > ${PREFIX}/pgsql/errlog &' && echo -n ' pgsql'" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - chmod 751 ${PREFIX}/etc/rc.d/postgresql.sh; \ - fi + @ ${SED} -e "s=!!PREFIX!!=${PREFIX}=g" < ${FILESDIR}/pgsql.sh.tmpl \ + > ${PREFIX}/etc/rc.d/pgsql.sh + @ chmod 554 ${PREFIX}/etc/rc.d/pgsql.sh + @ chown root.pgsql ${PREFIX}/etc/rc.d/pgsql.sh @ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/pgsql .if !defined(NOPORTDOCS) ${MKDIR} ${PREFIX}/share/doc/pgsql - ${CP} ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql + ${CP} -r ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql .endif .if !defined(BATCH) @ more -e ${FILESDIR}/post-install-notes diff --git a/databases/postgresql80-server/distinfo b/databases/postgresql80-server/distinfo index 70b03de859e..312e4988872 100644 --- a/databases/postgresql80-server/distinfo +++ b/databases/postgresql80-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-v6.1.1.tar.gz) = d80f2b459d00bea269435bb4ca05bd78 +MD5 (postgresql-6.2.tar.gz) = 4c59757f6405a6c3011399e3c502afd7 diff --git a/databases/postgresql80-server/files/pgsql.sh.tmpl b/databases/postgresql80-server/files/pgsql.sh.tmpl new file mode 100644 index 00000000000..7321cf4f472 --- /dev/null +++ b/databases/postgresql80-server/files/pgsql.sh.tmpl @@ -0,0 +1,21 @@ +#!/bin/sh + +# $Id$ + +# pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) + +# Changes: +# - renamed startup script to be in sync with INSTALL file +# - merged ldconfig start sequence from former postgrsql.sh script (andreas) +# - modified the postmaster startup sequence as suggested in the +# INSTALL file which was given as example for FreeBSD 2.2 (andreas) + + +[ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib + +[ -x !!PREFIX!!/pgsql/bin/postmaster ] && { + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster + -D!!PREFIX!!/pgsql/data + -S -o -F > !!PREFIX!!/pgsql/errlog' & + echo -n ' pgsql' +} diff --git a/databases/postgresql80-server/files/post-install-notes b/databases/postgresql80-server/files/post-install-notes index 1956d17766c..910966e67f1 100644 --- a/databases/postgresql80-server/files/post-install-notes +++ b/databases/postgresql80-server/files/post-install-notes @@ -4,3 +4,7 @@ implementation guides. These can be found at: http://www.PostgreSQL.org/docs +You may wish to subscribe to the PostgreSQL user-support mailing list. +Send an e-mail to pgsql-questions-request@postgresql.org with the +text "subscribe" in the message body. + diff --git a/databases/postgresql80-server/pkg-descr b/databases/postgresql80-server/pkg-descr index 680bf5c7f2b..f0283be0cd6 100644 --- a/databases/postgresql80-server/pkg-descr +++ b/databases/postgresql80-server/pkg-descr @@ -1,4 +1,3 @@ - PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), derived from the Berkeley Postgres database management system. While PostgreSQL retains the powerful object-relational data model, rich data types @@ -16,12 +15,10 @@ memory, PostgreSQL was born. PostgreSQL development is presently being performed by a team of Internet developers who are now responsible for all current and future development. The -development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.Org). +development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG). Support is available from the PostgreSQL developer/user community through the -support mailing list (questions@PostgreSQL.Org). +support mailing list (questions@PostgreSQL.ORG). PostgreSQL is free and the complete source is available. -More information and documentation can be found on the PostgreSQL website, -at: http://www.PostgreSQL.Org - +More information and documentation, visit: http://www.PostgreSQL.ORG/ diff --git a/databases/postgresql80-server/pkg-plist b/databases/postgresql80-server/pkg-plist index 6801de7d0d9..4a28e685189 100644 --- a/databases/postgresql80-server/pkg-plist +++ b/databases/postgresql80-server/pkg-plist @@ -1,4 +1,4 @@ -etc/rc.d/postgresql.sh +etc/rc.d/pgsql.sh pgsql/.profile pgsql/bin/cleardbdir pgsql/bin/createdb @@ -9,8 +9,10 @@ pgsql/bin/initdb pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id +pgsql/bin/pg_passwd pgsql/bin/pg_version pgsql/bin/postgres +pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -20,6 +22,8 @@ pgsql/data/base/template1/pg_amop pgsql/data/base/template1/pg_amproc pgsql/data/base/template1/pg_attnameind pgsql/data/base/template1/pg_attnumind +pgsql/data/base/template1/pg_attrdef +pgsql/data/base/template1/pg_attrdefind pgsql/data/base/template1/pg_attrelidind pgsql/data/base/template1/pg_attribute pgsql/data/base/template1/pg_class @@ -39,8 +43,12 @@ pgsql/data/base/template1/pg_proc pgsql/data/base/template1/pg_procidind pgsql/data/base/template1/pg_procnameind pgsql/data/base/template1/pg_procsrcind +pgsql/data/base/template1/pg_relcheck +pgsql/data/base/template1/pg_relcheckind pgsql/data/base/template1/pg_rewrite pgsql/data/base/template1/pg_statistic +pgsql/data/base/template1/pg_trigger +pgsql/data/base/template1/pg_trigrelidind pgsql/data/base/template1/pg_type pgsql/data/base/template1/pg_typeidind pgsql/data/base/template1/pg_typenameind @@ -74,6 +82,7 @@ pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source pgsql/lib/libpq.a +pgsql/lib/libpq.so pgsql/lib/libpq.so.1.0 pgsql/lib/local1_template1.bki.source pgsql/lib/pg_geqo.sample @@ -88,15 +97,16 @@ pgsql/man/man1/ipcclean.1.gz pgsql/man/man1/monitor.1.gz pgsql/man/man1/pg_dump.1.gz pgsql/man/man1/pg_dumpall.1.gz +pgsql/man/man1/pg_passwd.1.gz +pgsql/man/man1/pgintro.1.gz pgsql/man/man1/postgres.1.gz pgsql/man/man1/postmaster.1.gz pgsql/man/man1/psql.1.gz -pgsql/man/man1/unix.1.gz -pgsql/man/man3/built-in.3.gz pgsql/man/man3/catalogs.3.gz pgsql/man/man3/large_objects.3.gz pgsql/man/man3/libpq.3.gz pgsql/man/man3/oracle_compat.3.gz +pgsql/man/man3/pgbuiltin.3.gz pgsql/man/man5/bki.5.gz pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz @@ -115,9 +125,11 @@ pgsql/man/manl/create_operator.l.gz pgsql/man/manl/create_rule.l.gz pgsql/man/manl/create_sequence.l.gz pgsql/man/manl/create_table.l.gz +pgsql/man/manl/create_trigger.l.gz pgsql/man/manl/create_type.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz +pgsql/man/manl/declare.l.gz pgsql/man/manl/delete.l.gz pgsql/man/manl/drop.l.gz pgsql/man/manl/drop_aggregate.l.gz @@ -127,6 +139,8 @@ pgsql/man/manl/drop_index.l.gz pgsql/man/manl/drop_operator.l.gz pgsql/man/manl/drop_rule.l.gz pgsql/man/manl/drop_sequence.l.gz +pgsql/man/manl/drop_table.l.gz +pgsql/man/manl/drop_trigger.l.gz pgsql/man/manl/drop_type.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz @@ -136,6 +150,7 @@ pgsql/man/manl/grant.l.gz pgsql/man/manl/insert.l.gz pgsql/man/manl/listen.l.gz pgsql/man/manl/load.l.gz +pgsql/man/manl/move.l.gz pgsql/man/manl/notify.l.gz pgsql/man/manl/purge.l.gz pgsql/man/manl/rename.l.gz @@ -159,24 +174,49 @@ share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO share/doc/pgsql/bug.template share/doc/pgsql/libpgtcl.doc +share/doc/pgsql/manual/admin.html +share/doc/pgsql/manual/advanced.html +share/doc/pgsql/manual/appenda.html +share/doc/pgsql/manual/architec.html +share/doc/pgsql/manual/copy.html +share/doc/pgsql/manual/extend.html +share/doc/pgsql/manual/figure01.gif +share/doc/pgsql/manual/figure02.gif +share/doc/pgsql/manual/figure03.gif +share/doc/pgsql/manual/intro.html +share/doc/pgsql/manual/libpq.html +share/doc/pgsql/manual/lobj.html +share/doc/pgsql/manual/pg95user.html +share/doc/pgsql/manual/query.html +share/doc/pgsql/manual/refs.html +share/doc/pgsql/manual/rules.html +share/doc/pgsql/manual/start.html +share/doc/pgsql/manual/xaggr.html +share/doc/pgsql/manual/xfunc.html +share/doc/pgsql/manual/xindex.html +share/doc/pgsql/manual/xoper.html +share/doc/pgsql/manual/xtypes.html +share/doc/pgsql/spi.txt +share/doc/pgsql/trigger.txt share/doc/pgsql/userguide.ps +@dirrm share/doc/pgsql/manual @dirrm share/doc/pgsql -@dirrm pgsql/lib @dirrm pgsql/bin -@dirrm pgsql/include/port/BSD44_derived -@dirrm pgsql/include/port +@dirrm pgsql/data/base/template1 +@dirrm pgsql/data/base +@dirrm pgsql/data +@dirrm pgsql/include/access @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq +@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port @dirrm pgsql/include/utils -@dirrm pgsql/include/access @dirrm pgsql/include +@dirrm pgsql/lib @dirrm pgsql/man/man1 @dirrm pgsql/man/man3 @dirrm pgsql/man/man5 @dirrm pgsql/man/manl @dirrm pgsql/man -@dirrm pgsql/data/base/template1 -@dirrm pgsql/data/base -@dirrm pgsql/data @dirrm pgsql diff --git a/databases/postgresql81-server/Makefile b/databases/postgresql81-server/Makefile index f11b16deb17..be9e1d8230a 100644 --- a/databases/postgresql81-server/Makefile +++ b/databases/postgresql81-server/Makefile @@ -1,17 +1,16 @@ # New ports collection makefile for: PostgreSQL -# Version required: 6.1 +# Version required: 6.1 # Date created: April 2, 1997 # Whom: Marc G. Fournier <scrappy@FreeBSD.ORG> # -# $Id: Makefile,v 1.13 1997/07/17 15:12:40 max Exp $ +# $Id: Makefile,v 1.14 1997/09/27 21:43:48 andreas Exp $ -DISTNAME= postgresql-v6.1.1 -PKGNAME= postgresql-6.1.1 +DISTNAME= postgresql-6.2 CATEGORIES= databases MASTER_SITES= ftp://ftp.PostgreSQL.org/pub/ \ ftp://ftp.luga.or.at/pub/postgres95/ \ - ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ - + ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ + MAINTAINER= andreas@FreeBSD.ORG NO_PACKAGE= "Requires pgsql uid" @@ -20,59 +19,71 @@ USE_GMAKE= YES HAS_CONFIGURE= YES CONFIGURE_ARGS+=--prefix=${PREFIX}/pgsql \ --enable-locale \ - --with-template=`uname -s | tr '[A-Z]' '[a-z]'` + --with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'` MAKEFILE= GNUmakefile MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 postgres.1 postmaster.1 psql.1 unix.1 -MAN3= built-in.3 catalogs.3 large_objects.3 libpq.3 oracle_compat.3 -MAN5= bki.5 page.5 pg_hba.conf.5 + pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + postmaster.1 psql.1 +MAN3= catalogs.3 large_objects.3 libpq.3 oracle_compat.3 pgbuiltin.3 +MAN5= bki.5 page.5 pg_hba.conf.5 MANL= abort.l alter_table.l begin.l close.l cluster.l \ commit.l copy.l create_aggregate.l create_database.l \ create_function.l create_index.l create_operator.l \ create_rule.l create_sequence.l create_table.l \ - create_type.l create_version.l create_view.l delete.l \ - drop.l drop_aggregate.l drop_database.l drop_function.l \ - drop_index.l drop_operator.l drop_rule.l drop_sequence.l \ + create_trigger.l create_type.l create_version.l \ + create_view.l declare.l delete.l drop.l drop_aggregate.l \ + drop_database.l drop_function.l drop_index.l drop_operator.l \ + drop_rule.l drop_sequence.l drop_table.l drop_trigger.l \ drop_type.l drop_view.l end.l explain.l fetch.l grant.l \ - insert.l listen.l load.l notify.l purge.l rename.l \ - reset.l revoke.l rollback.l select.l set.l show.l \ - sql.l update.l vacuum.l + insert.l listen.l load.l move.l notify.l purge.l rename.l \ + reset.l revoke.l rollback.l select.l set.l show.l sql.l \ + update.l vacuum.l + MANPREFIX= ${PREFIX}/pgsql +post-build: + @ ${ECHO} "------------------------------------------------------------" + @ ${ECHO} "Dump existing databases, before installing new db version !!" + @ ${ECHO} "Detailed instructions, see INSTALL file under ${WRKDIR}... " + @ ${ECHO} "------------------------------------------------------------" + pre-install: @ ${MKDIR} ${PREFIX}/pgsql - @ ${SETENV} ${MAKE_ENV} /usr/bin/perl ${SCRIPTDIR}/createuser + @ ${SETENV} ${MAKE_ENV} perl ${SCRIPTDIR}/createuser post-install: @ if [ ! -f ${PREFIX}/pgsql/.profile ]; then \ - echo "PATH=${PATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "PATH=${PATH}:${PREFIX}/pgsql/bin" \ > ${PREFIX}/pgsql/.profile; \ - echo "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "PGLIB=${PREFIX}/pgsql/lib" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGLIB=${PREFIX}/pgsql/lib" \ + ${ECHO} "PGDATA=${PREFIX}/pgsql/data" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGDATA=${PREFIX}/pgsql/data" \ + ${ECHO} "export PATH MANPATH PGLIB PGDATA" \ >> ${PREFIX}/pgsql/.profile; \ - echo "export PATH MANPATH PGLIB PGDATA" \ + ${ECHO} "# if you want to make regression tests use this TZ" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#TZ=PST8PDT" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#export TZ" \ >> ${PREFIX}/pgsql/.profile; \ fi @ chown -R pgsql:pgsql ${PREFIX}/pgsql - @ echo 'Initializing PostgreSQL Databases - this may take a few minutes...' + @ ${ECHO} 'Initializing PostgreSQL Databases - this may take a few minutes...' @ ${LDCONFIG} -m ${PREFIX}/pgsql/lib @ su -l pgsql -c '${PREFIX}/pgsql/bin/initdb --pglib=${PREFIX}/pgsql/lib --pgdata=${PREFIX}/pgsql/data' - @ if [ ! -f ${PREFIX}/etc/rc.d/postgresql.sh ]; then \ - echo "Installing ${PREFIX}/etc/rc.d/postgresql.sh startup file."; \ - echo "#!/bin/sh" > ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -d ${PREFIX}/pgsql/lib ] && /sbin/ldconfig -m ${PREFIX}/pgsql/lib" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -x ${PREFIX}/pgsql/bin/postmaster ] && su -l pgsql -c '${PREFIX}/pgsql/bin/postmaster -D${PREFIX}/pgsql/data -o -F > ${PREFIX}/pgsql/errlog &' && echo -n ' pgsql'" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - chmod 751 ${PREFIX}/etc/rc.d/postgresql.sh; \ - fi + @ ${SED} -e "s=!!PREFIX!!=${PREFIX}=g" < ${FILESDIR}/pgsql.sh.tmpl \ + > ${PREFIX}/etc/rc.d/pgsql.sh + @ chmod 554 ${PREFIX}/etc/rc.d/pgsql.sh + @ chown root.pgsql ${PREFIX}/etc/rc.d/pgsql.sh @ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/pgsql .if !defined(NOPORTDOCS) ${MKDIR} ${PREFIX}/share/doc/pgsql - ${CP} ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql + ${CP} -r ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql .endif .if !defined(BATCH) @ more -e ${FILESDIR}/post-install-notes diff --git a/databases/postgresql81-server/distinfo b/databases/postgresql81-server/distinfo index 70b03de859e..312e4988872 100644 --- a/databases/postgresql81-server/distinfo +++ b/databases/postgresql81-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-v6.1.1.tar.gz) = d80f2b459d00bea269435bb4ca05bd78 +MD5 (postgresql-6.2.tar.gz) = 4c59757f6405a6c3011399e3c502afd7 diff --git a/databases/postgresql81-server/files/pgsql.sh.tmpl b/databases/postgresql81-server/files/pgsql.sh.tmpl new file mode 100644 index 00000000000..7321cf4f472 --- /dev/null +++ b/databases/postgresql81-server/files/pgsql.sh.tmpl @@ -0,0 +1,21 @@ +#!/bin/sh + +# $Id$ + +# pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) + +# Changes: +# - renamed startup script to be in sync with INSTALL file +# - merged ldconfig start sequence from former postgrsql.sh script (andreas) +# - modified the postmaster startup sequence as suggested in the +# INSTALL file which was given as example for FreeBSD 2.2 (andreas) + + +[ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib + +[ -x !!PREFIX!!/pgsql/bin/postmaster ] && { + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster + -D!!PREFIX!!/pgsql/data + -S -o -F > !!PREFIX!!/pgsql/errlog' & + echo -n ' pgsql' +} diff --git a/databases/postgresql81-server/files/post-install-notes b/databases/postgresql81-server/files/post-install-notes index 1956d17766c..910966e67f1 100644 --- a/databases/postgresql81-server/files/post-install-notes +++ b/databases/postgresql81-server/files/post-install-notes @@ -4,3 +4,7 @@ implementation guides. These can be found at: http://www.PostgreSQL.org/docs +You may wish to subscribe to the PostgreSQL user-support mailing list. +Send an e-mail to pgsql-questions-request@postgresql.org with the +text "subscribe" in the message body. + diff --git a/databases/postgresql81-server/pkg-descr b/databases/postgresql81-server/pkg-descr index 680bf5c7f2b..f0283be0cd6 100644 --- a/databases/postgresql81-server/pkg-descr +++ b/databases/postgresql81-server/pkg-descr @@ -1,4 +1,3 @@ - PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), derived from the Berkeley Postgres database management system. While PostgreSQL retains the powerful object-relational data model, rich data types @@ -16,12 +15,10 @@ memory, PostgreSQL was born. PostgreSQL development is presently being performed by a team of Internet developers who are now responsible for all current and future development. The -development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.Org). +development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG). Support is available from the PostgreSQL developer/user community through the -support mailing list (questions@PostgreSQL.Org). +support mailing list (questions@PostgreSQL.ORG). PostgreSQL is free and the complete source is available. -More information and documentation can be found on the PostgreSQL website, -at: http://www.PostgreSQL.Org - +More information and documentation, visit: http://www.PostgreSQL.ORG/ diff --git a/databases/postgresql81-server/pkg-plist b/databases/postgresql81-server/pkg-plist index 6801de7d0d9..4a28e685189 100644 --- a/databases/postgresql81-server/pkg-plist +++ b/databases/postgresql81-server/pkg-plist @@ -1,4 +1,4 @@ -etc/rc.d/postgresql.sh +etc/rc.d/pgsql.sh pgsql/.profile pgsql/bin/cleardbdir pgsql/bin/createdb @@ -9,8 +9,10 @@ pgsql/bin/initdb pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id +pgsql/bin/pg_passwd pgsql/bin/pg_version pgsql/bin/postgres +pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -20,6 +22,8 @@ pgsql/data/base/template1/pg_amop pgsql/data/base/template1/pg_amproc pgsql/data/base/template1/pg_attnameind pgsql/data/base/template1/pg_attnumind +pgsql/data/base/template1/pg_attrdef +pgsql/data/base/template1/pg_attrdefind pgsql/data/base/template1/pg_attrelidind pgsql/data/base/template1/pg_attribute pgsql/data/base/template1/pg_class @@ -39,8 +43,12 @@ pgsql/data/base/template1/pg_proc pgsql/data/base/template1/pg_procidind pgsql/data/base/template1/pg_procnameind pgsql/data/base/template1/pg_procsrcind +pgsql/data/base/template1/pg_relcheck +pgsql/data/base/template1/pg_relcheckind pgsql/data/base/template1/pg_rewrite pgsql/data/base/template1/pg_statistic +pgsql/data/base/template1/pg_trigger +pgsql/data/base/template1/pg_trigrelidind pgsql/data/base/template1/pg_type pgsql/data/base/template1/pg_typeidind pgsql/data/base/template1/pg_typenameind @@ -74,6 +82,7 @@ pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source pgsql/lib/libpq.a +pgsql/lib/libpq.so pgsql/lib/libpq.so.1.0 pgsql/lib/local1_template1.bki.source pgsql/lib/pg_geqo.sample @@ -88,15 +97,16 @@ pgsql/man/man1/ipcclean.1.gz pgsql/man/man1/monitor.1.gz pgsql/man/man1/pg_dump.1.gz pgsql/man/man1/pg_dumpall.1.gz +pgsql/man/man1/pg_passwd.1.gz +pgsql/man/man1/pgintro.1.gz pgsql/man/man1/postgres.1.gz pgsql/man/man1/postmaster.1.gz pgsql/man/man1/psql.1.gz -pgsql/man/man1/unix.1.gz -pgsql/man/man3/built-in.3.gz pgsql/man/man3/catalogs.3.gz pgsql/man/man3/large_objects.3.gz pgsql/man/man3/libpq.3.gz pgsql/man/man3/oracle_compat.3.gz +pgsql/man/man3/pgbuiltin.3.gz pgsql/man/man5/bki.5.gz pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz @@ -115,9 +125,11 @@ pgsql/man/manl/create_operator.l.gz pgsql/man/manl/create_rule.l.gz pgsql/man/manl/create_sequence.l.gz pgsql/man/manl/create_table.l.gz +pgsql/man/manl/create_trigger.l.gz pgsql/man/manl/create_type.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz +pgsql/man/manl/declare.l.gz pgsql/man/manl/delete.l.gz pgsql/man/manl/drop.l.gz pgsql/man/manl/drop_aggregate.l.gz @@ -127,6 +139,8 @@ pgsql/man/manl/drop_index.l.gz pgsql/man/manl/drop_operator.l.gz pgsql/man/manl/drop_rule.l.gz pgsql/man/manl/drop_sequence.l.gz +pgsql/man/manl/drop_table.l.gz +pgsql/man/manl/drop_trigger.l.gz pgsql/man/manl/drop_type.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz @@ -136,6 +150,7 @@ pgsql/man/manl/grant.l.gz pgsql/man/manl/insert.l.gz pgsql/man/manl/listen.l.gz pgsql/man/manl/load.l.gz +pgsql/man/manl/move.l.gz pgsql/man/manl/notify.l.gz pgsql/man/manl/purge.l.gz pgsql/man/manl/rename.l.gz @@ -159,24 +174,49 @@ share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO share/doc/pgsql/bug.template share/doc/pgsql/libpgtcl.doc +share/doc/pgsql/manual/admin.html +share/doc/pgsql/manual/advanced.html +share/doc/pgsql/manual/appenda.html +share/doc/pgsql/manual/architec.html +share/doc/pgsql/manual/copy.html +share/doc/pgsql/manual/extend.html +share/doc/pgsql/manual/figure01.gif +share/doc/pgsql/manual/figure02.gif +share/doc/pgsql/manual/figure03.gif +share/doc/pgsql/manual/intro.html +share/doc/pgsql/manual/libpq.html +share/doc/pgsql/manual/lobj.html +share/doc/pgsql/manual/pg95user.html +share/doc/pgsql/manual/query.html +share/doc/pgsql/manual/refs.html +share/doc/pgsql/manual/rules.html +share/doc/pgsql/manual/start.html +share/doc/pgsql/manual/xaggr.html +share/doc/pgsql/manual/xfunc.html +share/doc/pgsql/manual/xindex.html +share/doc/pgsql/manual/xoper.html +share/doc/pgsql/manual/xtypes.html +share/doc/pgsql/spi.txt +share/doc/pgsql/trigger.txt share/doc/pgsql/userguide.ps +@dirrm share/doc/pgsql/manual @dirrm share/doc/pgsql -@dirrm pgsql/lib @dirrm pgsql/bin -@dirrm pgsql/include/port/BSD44_derived -@dirrm pgsql/include/port +@dirrm pgsql/data/base/template1 +@dirrm pgsql/data/base +@dirrm pgsql/data +@dirrm pgsql/include/access @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq +@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port @dirrm pgsql/include/utils -@dirrm pgsql/include/access @dirrm pgsql/include +@dirrm pgsql/lib @dirrm pgsql/man/man1 @dirrm pgsql/man/man3 @dirrm pgsql/man/man5 @dirrm pgsql/man/manl @dirrm pgsql/man -@dirrm pgsql/data/base/template1 -@dirrm pgsql/data/base -@dirrm pgsql/data @dirrm pgsql diff --git a/databases/postgresql82-server/Makefile b/databases/postgresql82-server/Makefile index f11b16deb17..be9e1d8230a 100644 --- a/databases/postgresql82-server/Makefile +++ b/databases/postgresql82-server/Makefile @@ -1,17 +1,16 @@ # New ports collection makefile for: PostgreSQL -# Version required: 6.1 +# Version required: 6.1 # Date created: April 2, 1997 # Whom: Marc G. Fournier <scrappy@FreeBSD.ORG> # -# $Id: Makefile,v 1.13 1997/07/17 15:12:40 max Exp $ +# $Id: Makefile,v 1.14 1997/09/27 21:43:48 andreas Exp $ -DISTNAME= postgresql-v6.1.1 -PKGNAME= postgresql-6.1.1 +DISTNAME= postgresql-6.2 CATEGORIES= databases MASTER_SITES= ftp://ftp.PostgreSQL.org/pub/ \ ftp://ftp.luga.or.at/pub/postgres95/ \ - ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ - + ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ + MAINTAINER= andreas@FreeBSD.ORG NO_PACKAGE= "Requires pgsql uid" @@ -20,59 +19,71 @@ USE_GMAKE= YES HAS_CONFIGURE= YES CONFIGURE_ARGS+=--prefix=${PREFIX}/pgsql \ --enable-locale \ - --with-template=`uname -s | tr '[A-Z]' '[a-z]'` + --with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'` MAKEFILE= GNUmakefile MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 postgres.1 postmaster.1 psql.1 unix.1 -MAN3= built-in.3 catalogs.3 large_objects.3 libpq.3 oracle_compat.3 -MAN5= bki.5 page.5 pg_hba.conf.5 + pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + postmaster.1 psql.1 +MAN3= catalogs.3 large_objects.3 libpq.3 oracle_compat.3 pgbuiltin.3 +MAN5= bki.5 page.5 pg_hba.conf.5 MANL= abort.l alter_table.l begin.l close.l cluster.l \ commit.l copy.l create_aggregate.l create_database.l \ create_function.l create_index.l create_operator.l \ create_rule.l create_sequence.l create_table.l \ - create_type.l create_version.l create_view.l delete.l \ - drop.l drop_aggregate.l drop_database.l drop_function.l \ - drop_index.l drop_operator.l drop_rule.l drop_sequence.l \ + create_trigger.l create_type.l create_version.l \ + create_view.l declare.l delete.l drop.l drop_aggregate.l \ + drop_database.l drop_function.l drop_index.l drop_operator.l \ + drop_rule.l drop_sequence.l drop_table.l drop_trigger.l \ drop_type.l drop_view.l end.l explain.l fetch.l grant.l \ - insert.l listen.l load.l notify.l purge.l rename.l \ - reset.l revoke.l rollback.l select.l set.l show.l \ - sql.l update.l vacuum.l + insert.l listen.l load.l move.l notify.l purge.l rename.l \ + reset.l revoke.l rollback.l select.l set.l show.l sql.l \ + update.l vacuum.l + MANPREFIX= ${PREFIX}/pgsql +post-build: + @ ${ECHO} "------------------------------------------------------------" + @ ${ECHO} "Dump existing databases, before installing new db version !!" + @ ${ECHO} "Detailed instructions, see INSTALL file under ${WRKDIR}... " + @ ${ECHO} "------------------------------------------------------------" + pre-install: @ ${MKDIR} ${PREFIX}/pgsql - @ ${SETENV} ${MAKE_ENV} /usr/bin/perl ${SCRIPTDIR}/createuser + @ ${SETENV} ${MAKE_ENV} perl ${SCRIPTDIR}/createuser post-install: @ if [ ! -f ${PREFIX}/pgsql/.profile ]; then \ - echo "PATH=${PATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "PATH=${PATH}:${PREFIX}/pgsql/bin" \ > ${PREFIX}/pgsql/.profile; \ - echo "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "PGLIB=${PREFIX}/pgsql/lib" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGLIB=${PREFIX}/pgsql/lib" \ + ${ECHO} "PGDATA=${PREFIX}/pgsql/data" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGDATA=${PREFIX}/pgsql/data" \ + ${ECHO} "export PATH MANPATH PGLIB PGDATA" \ >> ${PREFIX}/pgsql/.profile; \ - echo "export PATH MANPATH PGLIB PGDATA" \ + ${ECHO} "# if you want to make regression tests use this TZ" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#TZ=PST8PDT" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#export TZ" \ >> ${PREFIX}/pgsql/.profile; \ fi @ chown -R pgsql:pgsql ${PREFIX}/pgsql - @ echo 'Initializing PostgreSQL Databases - this may take a few minutes...' + @ ${ECHO} 'Initializing PostgreSQL Databases - this may take a few minutes...' @ ${LDCONFIG} -m ${PREFIX}/pgsql/lib @ su -l pgsql -c '${PREFIX}/pgsql/bin/initdb --pglib=${PREFIX}/pgsql/lib --pgdata=${PREFIX}/pgsql/data' - @ if [ ! -f ${PREFIX}/etc/rc.d/postgresql.sh ]; then \ - echo "Installing ${PREFIX}/etc/rc.d/postgresql.sh startup file."; \ - echo "#!/bin/sh" > ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -d ${PREFIX}/pgsql/lib ] && /sbin/ldconfig -m ${PREFIX}/pgsql/lib" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -x ${PREFIX}/pgsql/bin/postmaster ] && su -l pgsql -c '${PREFIX}/pgsql/bin/postmaster -D${PREFIX}/pgsql/data -o -F > ${PREFIX}/pgsql/errlog &' && echo -n ' pgsql'" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - chmod 751 ${PREFIX}/etc/rc.d/postgresql.sh; \ - fi + @ ${SED} -e "s=!!PREFIX!!=${PREFIX}=g" < ${FILESDIR}/pgsql.sh.tmpl \ + > ${PREFIX}/etc/rc.d/pgsql.sh + @ chmod 554 ${PREFIX}/etc/rc.d/pgsql.sh + @ chown root.pgsql ${PREFIX}/etc/rc.d/pgsql.sh @ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/pgsql .if !defined(NOPORTDOCS) ${MKDIR} ${PREFIX}/share/doc/pgsql - ${CP} ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql + ${CP} -r ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql .endif .if !defined(BATCH) @ more -e ${FILESDIR}/post-install-notes diff --git a/databases/postgresql82-server/distinfo b/databases/postgresql82-server/distinfo index 70b03de859e..312e4988872 100644 --- a/databases/postgresql82-server/distinfo +++ b/databases/postgresql82-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-v6.1.1.tar.gz) = d80f2b459d00bea269435bb4ca05bd78 +MD5 (postgresql-6.2.tar.gz) = 4c59757f6405a6c3011399e3c502afd7 diff --git a/databases/postgresql82-server/files/pgsql.sh.tmpl b/databases/postgresql82-server/files/pgsql.sh.tmpl new file mode 100644 index 00000000000..7321cf4f472 --- /dev/null +++ b/databases/postgresql82-server/files/pgsql.sh.tmpl @@ -0,0 +1,21 @@ +#!/bin/sh + +# $Id$ + +# pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) + +# Changes: +# - renamed startup script to be in sync with INSTALL file +# - merged ldconfig start sequence from former postgrsql.sh script (andreas) +# - modified the postmaster startup sequence as suggested in the +# INSTALL file which was given as example for FreeBSD 2.2 (andreas) + + +[ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib + +[ -x !!PREFIX!!/pgsql/bin/postmaster ] && { + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster + -D!!PREFIX!!/pgsql/data + -S -o -F > !!PREFIX!!/pgsql/errlog' & + echo -n ' pgsql' +} diff --git a/databases/postgresql82-server/files/post-install-notes b/databases/postgresql82-server/files/post-install-notes index 1956d17766c..910966e67f1 100644 --- a/databases/postgresql82-server/files/post-install-notes +++ b/databases/postgresql82-server/files/post-install-notes @@ -4,3 +4,7 @@ implementation guides. These can be found at: http://www.PostgreSQL.org/docs +You may wish to subscribe to the PostgreSQL user-support mailing list. +Send an e-mail to pgsql-questions-request@postgresql.org with the +text "subscribe" in the message body. + diff --git a/databases/postgresql82-server/pkg-descr b/databases/postgresql82-server/pkg-descr index 680bf5c7f2b..f0283be0cd6 100644 --- a/databases/postgresql82-server/pkg-descr +++ b/databases/postgresql82-server/pkg-descr @@ -1,4 +1,3 @@ - PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), derived from the Berkeley Postgres database management system. While PostgreSQL retains the powerful object-relational data model, rich data types @@ -16,12 +15,10 @@ memory, PostgreSQL was born. PostgreSQL development is presently being performed by a team of Internet developers who are now responsible for all current and future development. The -development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.Org). +development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG). Support is available from the PostgreSQL developer/user community through the -support mailing list (questions@PostgreSQL.Org). +support mailing list (questions@PostgreSQL.ORG). PostgreSQL is free and the complete source is available. -More information and documentation can be found on the PostgreSQL website, -at: http://www.PostgreSQL.Org - +More information and documentation, visit: http://www.PostgreSQL.ORG/ diff --git a/databases/postgresql82-server/pkg-plist b/databases/postgresql82-server/pkg-plist index 6801de7d0d9..4a28e685189 100644 --- a/databases/postgresql82-server/pkg-plist +++ b/databases/postgresql82-server/pkg-plist @@ -1,4 +1,4 @@ -etc/rc.d/postgresql.sh +etc/rc.d/pgsql.sh pgsql/.profile pgsql/bin/cleardbdir pgsql/bin/createdb @@ -9,8 +9,10 @@ pgsql/bin/initdb pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id +pgsql/bin/pg_passwd pgsql/bin/pg_version pgsql/bin/postgres +pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -20,6 +22,8 @@ pgsql/data/base/template1/pg_amop pgsql/data/base/template1/pg_amproc pgsql/data/base/template1/pg_attnameind pgsql/data/base/template1/pg_attnumind +pgsql/data/base/template1/pg_attrdef +pgsql/data/base/template1/pg_attrdefind pgsql/data/base/template1/pg_attrelidind pgsql/data/base/template1/pg_attribute pgsql/data/base/template1/pg_class @@ -39,8 +43,12 @@ pgsql/data/base/template1/pg_proc pgsql/data/base/template1/pg_procidind pgsql/data/base/template1/pg_procnameind pgsql/data/base/template1/pg_procsrcind +pgsql/data/base/template1/pg_relcheck +pgsql/data/base/template1/pg_relcheckind pgsql/data/base/template1/pg_rewrite pgsql/data/base/template1/pg_statistic +pgsql/data/base/template1/pg_trigger +pgsql/data/base/template1/pg_trigrelidind pgsql/data/base/template1/pg_type pgsql/data/base/template1/pg_typeidind pgsql/data/base/template1/pg_typenameind @@ -74,6 +82,7 @@ pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source pgsql/lib/libpq.a +pgsql/lib/libpq.so pgsql/lib/libpq.so.1.0 pgsql/lib/local1_template1.bki.source pgsql/lib/pg_geqo.sample @@ -88,15 +97,16 @@ pgsql/man/man1/ipcclean.1.gz pgsql/man/man1/monitor.1.gz pgsql/man/man1/pg_dump.1.gz pgsql/man/man1/pg_dumpall.1.gz +pgsql/man/man1/pg_passwd.1.gz +pgsql/man/man1/pgintro.1.gz pgsql/man/man1/postgres.1.gz pgsql/man/man1/postmaster.1.gz pgsql/man/man1/psql.1.gz -pgsql/man/man1/unix.1.gz -pgsql/man/man3/built-in.3.gz pgsql/man/man3/catalogs.3.gz pgsql/man/man3/large_objects.3.gz pgsql/man/man3/libpq.3.gz pgsql/man/man3/oracle_compat.3.gz +pgsql/man/man3/pgbuiltin.3.gz pgsql/man/man5/bki.5.gz pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz @@ -115,9 +125,11 @@ pgsql/man/manl/create_operator.l.gz pgsql/man/manl/create_rule.l.gz pgsql/man/manl/create_sequence.l.gz pgsql/man/manl/create_table.l.gz +pgsql/man/manl/create_trigger.l.gz pgsql/man/manl/create_type.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz +pgsql/man/manl/declare.l.gz pgsql/man/manl/delete.l.gz pgsql/man/manl/drop.l.gz pgsql/man/manl/drop_aggregate.l.gz @@ -127,6 +139,8 @@ pgsql/man/manl/drop_index.l.gz pgsql/man/manl/drop_operator.l.gz pgsql/man/manl/drop_rule.l.gz pgsql/man/manl/drop_sequence.l.gz +pgsql/man/manl/drop_table.l.gz +pgsql/man/manl/drop_trigger.l.gz pgsql/man/manl/drop_type.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz @@ -136,6 +150,7 @@ pgsql/man/manl/grant.l.gz pgsql/man/manl/insert.l.gz pgsql/man/manl/listen.l.gz pgsql/man/manl/load.l.gz +pgsql/man/manl/move.l.gz pgsql/man/manl/notify.l.gz pgsql/man/manl/purge.l.gz pgsql/man/manl/rename.l.gz @@ -159,24 +174,49 @@ share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO share/doc/pgsql/bug.template share/doc/pgsql/libpgtcl.doc +share/doc/pgsql/manual/admin.html +share/doc/pgsql/manual/advanced.html +share/doc/pgsql/manual/appenda.html +share/doc/pgsql/manual/architec.html +share/doc/pgsql/manual/copy.html +share/doc/pgsql/manual/extend.html +share/doc/pgsql/manual/figure01.gif +share/doc/pgsql/manual/figure02.gif +share/doc/pgsql/manual/figure03.gif +share/doc/pgsql/manual/intro.html +share/doc/pgsql/manual/libpq.html +share/doc/pgsql/manual/lobj.html +share/doc/pgsql/manual/pg95user.html +share/doc/pgsql/manual/query.html +share/doc/pgsql/manual/refs.html +share/doc/pgsql/manual/rules.html +share/doc/pgsql/manual/start.html +share/doc/pgsql/manual/xaggr.html +share/doc/pgsql/manual/xfunc.html +share/doc/pgsql/manual/xindex.html +share/doc/pgsql/manual/xoper.html +share/doc/pgsql/manual/xtypes.html +share/doc/pgsql/spi.txt +share/doc/pgsql/trigger.txt share/doc/pgsql/userguide.ps +@dirrm share/doc/pgsql/manual @dirrm share/doc/pgsql -@dirrm pgsql/lib @dirrm pgsql/bin -@dirrm pgsql/include/port/BSD44_derived -@dirrm pgsql/include/port +@dirrm pgsql/data/base/template1 +@dirrm pgsql/data/base +@dirrm pgsql/data +@dirrm pgsql/include/access @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq +@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port @dirrm pgsql/include/utils -@dirrm pgsql/include/access @dirrm pgsql/include +@dirrm pgsql/lib @dirrm pgsql/man/man1 @dirrm pgsql/man/man3 @dirrm pgsql/man/man5 @dirrm pgsql/man/manl @dirrm pgsql/man -@dirrm pgsql/data/base/template1 -@dirrm pgsql/data/base -@dirrm pgsql/data @dirrm pgsql diff --git a/databases/postgresql83-server/Makefile b/databases/postgresql83-server/Makefile index f11b16deb17..be9e1d8230a 100644 --- a/databases/postgresql83-server/Makefile +++ b/databases/postgresql83-server/Makefile @@ -1,17 +1,16 @@ # New ports collection makefile for: PostgreSQL -# Version required: 6.1 +# Version required: 6.1 # Date created: April 2, 1997 # Whom: Marc G. Fournier <scrappy@FreeBSD.ORG> # -# $Id: Makefile,v 1.13 1997/07/17 15:12:40 max Exp $ +# $Id: Makefile,v 1.14 1997/09/27 21:43:48 andreas Exp $ -DISTNAME= postgresql-v6.1.1 -PKGNAME= postgresql-6.1.1 +DISTNAME= postgresql-6.2 CATEGORIES= databases MASTER_SITES= ftp://ftp.PostgreSQL.org/pub/ \ ftp://ftp.luga.or.at/pub/postgres95/ \ - ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ - + ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ + MAINTAINER= andreas@FreeBSD.ORG NO_PACKAGE= "Requires pgsql uid" @@ -20,59 +19,71 @@ USE_GMAKE= YES HAS_CONFIGURE= YES CONFIGURE_ARGS+=--prefix=${PREFIX}/pgsql \ --enable-locale \ - --with-template=`uname -s | tr '[A-Z]' '[a-z]'` + --with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'` MAKEFILE= GNUmakefile MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 postgres.1 postmaster.1 psql.1 unix.1 -MAN3= built-in.3 catalogs.3 large_objects.3 libpq.3 oracle_compat.3 -MAN5= bki.5 page.5 pg_hba.conf.5 + pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + postmaster.1 psql.1 +MAN3= catalogs.3 large_objects.3 libpq.3 oracle_compat.3 pgbuiltin.3 +MAN5= bki.5 page.5 pg_hba.conf.5 MANL= abort.l alter_table.l begin.l close.l cluster.l \ commit.l copy.l create_aggregate.l create_database.l \ create_function.l create_index.l create_operator.l \ create_rule.l create_sequence.l create_table.l \ - create_type.l create_version.l create_view.l delete.l \ - drop.l drop_aggregate.l drop_database.l drop_function.l \ - drop_index.l drop_operator.l drop_rule.l drop_sequence.l \ + create_trigger.l create_type.l create_version.l \ + create_view.l declare.l delete.l drop.l drop_aggregate.l \ + drop_database.l drop_function.l drop_index.l drop_operator.l \ + drop_rule.l drop_sequence.l drop_table.l drop_trigger.l \ drop_type.l drop_view.l end.l explain.l fetch.l grant.l \ - insert.l listen.l load.l notify.l purge.l rename.l \ - reset.l revoke.l rollback.l select.l set.l show.l \ - sql.l update.l vacuum.l + insert.l listen.l load.l move.l notify.l purge.l rename.l \ + reset.l revoke.l rollback.l select.l set.l show.l sql.l \ + update.l vacuum.l + MANPREFIX= ${PREFIX}/pgsql +post-build: + @ ${ECHO} "------------------------------------------------------------" + @ ${ECHO} "Dump existing databases, before installing new db version !!" + @ ${ECHO} "Detailed instructions, see INSTALL file under ${WRKDIR}... " + @ ${ECHO} "------------------------------------------------------------" + pre-install: @ ${MKDIR} ${PREFIX}/pgsql - @ ${SETENV} ${MAKE_ENV} /usr/bin/perl ${SCRIPTDIR}/createuser + @ ${SETENV} ${MAKE_ENV} perl ${SCRIPTDIR}/createuser post-install: @ if [ ! -f ${PREFIX}/pgsql/.profile ]; then \ - echo "PATH=${PATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "PATH=${PATH}:${PREFIX}/pgsql/bin" \ > ${PREFIX}/pgsql/.profile; \ - echo "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "PGLIB=${PREFIX}/pgsql/lib" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGLIB=${PREFIX}/pgsql/lib" \ + ${ECHO} "PGDATA=${PREFIX}/pgsql/data" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGDATA=${PREFIX}/pgsql/data" \ + ${ECHO} "export PATH MANPATH PGLIB PGDATA" \ >> ${PREFIX}/pgsql/.profile; \ - echo "export PATH MANPATH PGLIB PGDATA" \ + ${ECHO} "# if you want to make regression tests use this TZ" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#TZ=PST8PDT" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#export TZ" \ >> ${PREFIX}/pgsql/.profile; \ fi @ chown -R pgsql:pgsql ${PREFIX}/pgsql - @ echo 'Initializing PostgreSQL Databases - this may take a few minutes...' + @ ${ECHO} 'Initializing PostgreSQL Databases - this may take a few minutes...' @ ${LDCONFIG} -m ${PREFIX}/pgsql/lib @ su -l pgsql -c '${PREFIX}/pgsql/bin/initdb --pglib=${PREFIX}/pgsql/lib --pgdata=${PREFIX}/pgsql/data' - @ if [ ! -f ${PREFIX}/etc/rc.d/postgresql.sh ]; then \ - echo "Installing ${PREFIX}/etc/rc.d/postgresql.sh startup file."; \ - echo "#!/bin/sh" > ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -d ${PREFIX}/pgsql/lib ] && /sbin/ldconfig -m ${PREFIX}/pgsql/lib" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -x ${PREFIX}/pgsql/bin/postmaster ] && su -l pgsql -c '${PREFIX}/pgsql/bin/postmaster -D${PREFIX}/pgsql/data -o -F > ${PREFIX}/pgsql/errlog &' && echo -n ' pgsql'" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - chmod 751 ${PREFIX}/etc/rc.d/postgresql.sh; \ - fi + @ ${SED} -e "s=!!PREFIX!!=${PREFIX}=g" < ${FILESDIR}/pgsql.sh.tmpl \ + > ${PREFIX}/etc/rc.d/pgsql.sh + @ chmod 554 ${PREFIX}/etc/rc.d/pgsql.sh + @ chown root.pgsql ${PREFIX}/etc/rc.d/pgsql.sh @ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/pgsql .if !defined(NOPORTDOCS) ${MKDIR} ${PREFIX}/share/doc/pgsql - ${CP} ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql + ${CP} -r ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql .endif .if !defined(BATCH) @ more -e ${FILESDIR}/post-install-notes diff --git a/databases/postgresql83-server/distinfo b/databases/postgresql83-server/distinfo index 70b03de859e..312e4988872 100644 --- a/databases/postgresql83-server/distinfo +++ b/databases/postgresql83-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-v6.1.1.tar.gz) = d80f2b459d00bea269435bb4ca05bd78 +MD5 (postgresql-6.2.tar.gz) = 4c59757f6405a6c3011399e3c502afd7 diff --git a/databases/postgresql83-server/files/pgsql.sh.tmpl b/databases/postgresql83-server/files/pgsql.sh.tmpl new file mode 100644 index 00000000000..7321cf4f472 --- /dev/null +++ b/databases/postgresql83-server/files/pgsql.sh.tmpl @@ -0,0 +1,21 @@ +#!/bin/sh + +# $Id$ + +# pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) + +# Changes: +# - renamed startup script to be in sync with INSTALL file +# - merged ldconfig start sequence from former postgrsql.sh script (andreas) +# - modified the postmaster startup sequence as suggested in the +# INSTALL file which was given as example for FreeBSD 2.2 (andreas) + + +[ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib + +[ -x !!PREFIX!!/pgsql/bin/postmaster ] && { + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster + -D!!PREFIX!!/pgsql/data + -S -o -F > !!PREFIX!!/pgsql/errlog' & + echo -n ' pgsql' +} diff --git a/databases/postgresql83-server/files/post-install-notes b/databases/postgresql83-server/files/post-install-notes index 1956d17766c..910966e67f1 100644 --- a/databases/postgresql83-server/files/post-install-notes +++ b/databases/postgresql83-server/files/post-install-notes @@ -4,3 +4,7 @@ implementation guides. These can be found at: http://www.PostgreSQL.org/docs +You may wish to subscribe to the PostgreSQL user-support mailing list. +Send an e-mail to pgsql-questions-request@postgresql.org with the +text "subscribe" in the message body. + diff --git a/databases/postgresql83-server/pkg-descr b/databases/postgresql83-server/pkg-descr index 680bf5c7f2b..f0283be0cd6 100644 --- a/databases/postgresql83-server/pkg-descr +++ b/databases/postgresql83-server/pkg-descr @@ -1,4 +1,3 @@ - PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), derived from the Berkeley Postgres database management system. While PostgreSQL retains the powerful object-relational data model, rich data types @@ -16,12 +15,10 @@ memory, PostgreSQL was born. PostgreSQL development is presently being performed by a team of Internet developers who are now responsible for all current and future development. The -development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.Org). +development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG). Support is available from the PostgreSQL developer/user community through the -support mailing list (questions@PostgreSQL.Org). +support mailing list (questions@PostgreSQL.ORG). PostgreSQL is free and the complete source is available. -More information and documentation can be found on the PostgreSQL website, -at: http://www.PostgreSQL.Org - +More information and documentation, visit: http://www.PostgreSQL.ORG/ diff --git a/databases/postgresql83-server/pkg-plist b/databases/postgresql83-server/pkg-plist index 6801de7d0d9..4a28e685189 100644 --- a/databases/postgresql83-server/pkg-plist +++ b/databases/postgresql83-server/pkg-plist @@ -1,4 +1,4 @@ -etc/rc.d/postgresql.sh +etc/rc.d/pgsql.sh pgsql/.profile pgsql/bin/cleardbdir pgsql/bin/createdb @@ -9,8 +9,10 @@ pgsql/bin/initdb pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id +pgsql/bin/pg_passwd pgsql/bin/pg_version pgsql/bin/postgres +pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -20,6 +22,8 @@ pgsql/data/base/template1/pg_amop pgsql/data/base/template1/pg_amproc pgsql/data/base/template1/pg_attnameind pgsql/data/base/template1/pg_attnumind +pgsql/data/base/template1/pg_attrdef +pgsql/data/base/template1/pg_attrdefind pgsql/data/base/template1/pg_attrelidind pgsql/data/base/template1/pg_attribute pgsql/data/base/template1/pg_class @@ -39,8 +43,12 @@ pgsql/data/base/template1/pg_proc pgsql/data/base/template1/pg_procidind pgsql/data/base/template1/pg_procnameind pgsql/data/base/template1/pg_procsrcind +pgsql/data/base/template1/pg_relcheck +pgsql/data/base/template1/pg_relcheckind pgsql/data/base/template1/pg_rewrite pgsql/data/base/template1/pg_statistic +pgsql/data/base/template1/pg_trigger +pgsql/data/base/template1/pg_trigrelidind pgsql/data/base/template1/pg_type pgsql/data/base/template1/pg_typeidind pgsql/data/base/template1/pg_typenameind @@ -74,6 +82,7 @@ pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source pgsql/lib/libpq.a +pgsql/lib/libpq.so pgsql/lib/libpq.so.1.0 pgsql/lib/local1_template1.bki.source pgsql/lib/pg_geqo.sample @@ -88,15 +97,16 @@ pgsql/man/man1/ipcclean.1.gz pgsql/man/man1/monitor.1.gz pgsql/man/man1/pg_dump.1.gz pgsql/man/man1/pg_dumpall.1.gz +pgsql/man/man1/pg_passwd.1.gz +pgsql/man/man1/pgintro.1.gz pgsql/man/man1/postgres.1.gz pgsql/man/man1/postmaster.1.gz pgsql/man/man1/psql.1.gz -pgsql/man/man1/unix.1.gz -pgsql/man/man3/built-in.3.gz pgsql/man/man3/catalogs.3.gz pgsql/man/man3/large_objects.3.gz pgsql/man/man3/libpq.3.gz pgsql/man/man3/oracle_compat.3.gz +pgsql/man/man3/pgbuiltin.3.gz pgsql/man/man5/bki.5.gz pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz @@ -115,9 +125,11 @@ pgsql/man/manl/create_operator.l.gz pgsql/man/manl/create_rule.l.gz pgsql/man/manl/create_sequence.l.gz pgsql/man/manl/create_table.l.gz +pgsql/man/manl/create_trigger.l.gz pgsql/man/manl/create_type.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz +pgsql/man/manl/declare.l.gz pgsql/man/manl/delete.l.gz pgsql/man/manl/drop.l.gz pgsql/man/manl/drop_aggregate.l.gz @@ -127,6 +139,8 @@ pgsql/man/manl/drop_index.l.gz pgsql/man/manl/drop_operator.l.gz pgsql/man/manl/drop_rule.l.gz pgsql/man/manl/drop_sequence.l.gz +pgsql/man/manl/drop_table.l.gz +pgsql/man/manl/drop_trigger.l.gz pgsql/man/manl/drop_type.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz @@ -136,6 +150,7 @@ pgsql/man/manl/grant.l.gz pgsql/man/manl/insert.l.gz pgsql/man/manl/listen.l.gz pgsql/man/manl/load.l.gz +pgsql/man/manl/move.l.gz pgsql/man/manl/notify.l.gz pgsql/man/manl/purge.l.gz pgsql/man/manl/rename.l.gz @@ -159,24 +174,49 @@ share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO share/doc/pgsql/bug.template share/doc/pgsql/libpgtcl.doc +share/doc/pgsql/manual/admin.html +share/doc/pgsql/manual/advanced.html +share/doc/pgsql/manual/appenda.html +share/doc/pgsql/manual/architec.html +share/doc/pgsql/manual/copy.html +share/doc/pgsql/manual/extend.html +share/doc/pgsql/manual/figure01.gif +share/doc/pgsql/manual/figure02.gif +share/doc/pgsql/manual/figure03.gif +share/doc/pgsql/manual/intro.html +share/doc/pgsql/manual/libpq.html +share/doc/pgsql/manual/lobj.html +share/doc/pgsql/manual/pg95user.html +share/doc/pgsql/manual/query.html +share/doc/pgsql/manual/refs.html +share/doc/pgsql/manual/rules.html +share/doc/pgsql/manual/start.html +share/doc/pgsql/manual/xaggr.html +share/doc/pgsql/manual/xfunc.html +share/doc/pgsql/manual/xindex.html +share/doc/pgsql/manual/xoper.html +share/doc/pgsql/manual/xtypes.html +share/doc/pgsql/spi.txt +share/doc/pgsql/trigger.txt share/doc/pgsql/userguide.ps +@dirrm share/doc/pgsql/manual @dirrm share/doc/pgsql -@dirrm pgsql/lib @dirrm pgsql/bin -@dirrm pgsql/include/port/BSD44_derived -@dirrm pgsql/include/port +@dirrm pgsql/data/base/template1 +@dirrm pgsql/data/base +@dirrm pgsql/data +@dirrm pgsql/include/access @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq +@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port @dirrm pgsql/include/utils -@dirrm pgsql/include/access @dirrm pgsql/include +@dirrm pgsql/lib @dirrm pgsql/man/man1 @dirrm pgsql/man/man3 @dirrm pgsql/man/man5 @dirrm pgsql/man/manl @dirrm pgsql/man -@dirrm pgsql/data/base/template1 -@dirrm pgsql/data/base -@dirrm pgsql/data @dirrm pgsql diff --git a/databases/postgresql84-server/Makefile b/databases/postgresql84-server/Makefile index f11b16deb17..be9e1d8230a 100644 --- a/databases/postgresql84-server/Makefile +++ b/databases/postgresql84-server/Makefile @@ -1,17 +1,16 @@ # New ports collection makefile for: PostgreSQL -# Version required: 6.1 +# Version required: 6.1 # Date created: April 2, 1997 # Whom: Marc G. Fournier <scrappy@FreeBSD.ORG> # -# $Id: Makefile,v 1.13 1997/07/17 15:12:40 max Exp $ +# $Id: Makefile,v 1.14 1997/09/27 21:43:48 andreas Exp $ -DISTNAME= postgresql-v6.1.1 -PKGNAME= postgresql-6.1.1 +DISTNAME= postgresql-6.2 CATEGORIES= databases MASTER_SITES= ftp://ftp.PostgreSQL.org/pub/ \ ftp://ftp.luga.or.at/pub/postgres95/ \ - ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ - + ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ + MAINTAINER= andreas@FreeBSD.ORG NO_PACKAGE= "Requires pgsql uid" @@ -20,59 +19,71 @@ USE_GMAKE= YES HAS_CONFIGURE= YES CONFIGURE_ARGS+=--prefix=${PREFIX}/pgsql \ --enable-locale \ - --with-template=`uname -s | tr '[A-Z]' '[a-z]'` + --with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'` MAKEFILE= GNUmakefile MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 postgres.1 postmaster.1 psql.1 unix.1 -MAN3= built-in.3 catalogs.3 large_objects.3 libpq.3 oracle_compat.3 -MAN5= bki.5 page.5 pg_hba.conf.5 + pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + postmaster.1 psql.1 +MAN3= catalogs.3 large_objects.3 libpq.3 oracle_compat.3 pgbuiltin.3 +MAN5= bki.5 page.5 pg_hba.conf.5 MANL= abort.l alter_table.l begin.l close.l cluster.l \ commit.l copy.l create_aggregate.l create_database.l \ create_function.l create_index.l create_operator.l \ create_rule.l create_sequence.l create_table.l \ - create_type.l create_version.l create_view.l delete.l \ - drop.l drop_aggregate.l drop_database.l drop_function.l \ - drop_index.l drop_operator.l drop_rule.l drop_sequence.l \ + create_trigger.l create_type.l create_version.l \ + create_view.l declare.l delete.l drop.l drop_aggregate.l \ + drop_database.l drop_function.l drop_index.l drop_operator.l \ + drop_rule.l drop_sequence.l drop_table.l drop_trigger.l \ drop_type.l drop_view.l end.l explain.l fetch.l grant.l \ - insert.l listen.l load.l notify.l purge.l rename.l \ - reset.l revoke.l rollback.l select.l set.l show.l \ - sql.l update.l vacuum.l + insert.l listen.l load.l move.l notify.l purge.l rename.l \ + reset.l revoke.l rollback.l select.l set.l show.l sql.l \ + update.l vacuum.l + MANPREFIX= ${PREFIX}/pgsql +post-build: + @ ${ECHO} "------------------------------------------------------------" + @ ${ECHO} "Dump existing databases, before installing new db version !!" + @ ${ECHO} "Detailed instructions, see INSTALL file under ${WRKDIR}... " + @ ${ECHO} "------------------------------------------------------------" + pre-install: @ ${MKDIR} ${PREFIX}/pgsql - @ ${SETENV} ${MAKE_ENV} /usr/bin/perl ${SCRIPTDIR}/createuser + @ ${SETENV} ${MAKE_ENV} perl ${SCRIPTDIR}/createuser post-install: @ if [ ! -f ${PREFIX}/pgsql/.profile ]; then \ - echo "PATH=${PATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "PATH=${PATH}:${PREFIX}/pgsql/bin" \ > ${PREFIX}/pgsql/.profile; \ - echo "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "PGLIB=${PREFIX}/pgsql/lib" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGLIB=${PREFIX}/pgsql/lib" \ + ${ECHO} "PGDATA=${PREFIX}/pgsql/data" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGDATA=${PREFIX}/pgsql/data" \ + ${ECHO} "export PATH MANPATH PGLIB PGDATA" \ >> ${PREFIX}/pgsql/.profile; \ - echo "export PATH MANPATH PGLIB PGDATA" \ + ${ECHO} "# if you want to make regression tests use this TZ" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#TZ=PST8PDT" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#export TZ" \ >> ${PREFIX}/pgsql/.profile; \ fi @ chown -R pgsql:pgsql ${PREFIX}/pgsql - @ echo 'Initializing PostgreSQL Databases - this may take a few minutes...' + @ ${ECHO} 'Initializing PostgreSQL Databases - this may take a few minutes...' @ ${LDCONFIG} -m ${PREFIX}/pgsql/lib @ su -l pgsql -c '${PREFIX}/pgsql/bin/initdb --pglib=${PREFIX}/pgsql/lib --pgdata=${PREFIX}/pgsql/data' - @ if [ ! -f ${PREFIX}/etc/rc.d/postgresql.sh ]; then \ - echo "Installing ${PREFIX}/etc/rc.d/postgresql.sh startup file."; \ - echo "#!/bin/sh" > ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -d ${PREFIX}/pgsql/lib ] && /sbin/ldconfig -m ${PREFIX}/pgsql/lib" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -x ${PREFIX}/pgsql/bin/postmaster ] && su -l pgsql -c '${PREFIX}/pgsql/bin/postmaster -D${PREFIX}/pgsql/data -o -F > ${PREFIX}/pgsql/errlog &' && echo -n ' pgsql'" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - chmod 751 ${PREFIX}/etc/rc.d/postgresql.sh; \ - fi + @ ${SED} -e "s=!!PREFIX!!=${PREFIX}=g" < ${FILESDIR}/pgsql.sh.tmpl \ + > ${PREFIX}/etc/rc.d/pgsql.sh + @ chmod 554 ${PREFIX}/etc/rc.d/pgsql.sh + @ chown root.pgsql ${PREFIX}/etc/rc.d/pgsql.sh @ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/pgsql .if !defined(NOPORTDOCS) ${MKDIR} ${PREFIX}/share/doc/pgsql - ${CP} ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql + ${CP} -r ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql .endif .if !defined(BATCH) @ more -e ${FILESDIR}/post-install-notes diff --git a/databases/postgresql84-server/distinfo b/databases/postgresql84-server/distinfo index 70b03de859e..312e4988872 100644 --- a/databases/postgresql84-server/distinfo +++ b/databases/postgresql84-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-v6.1.1.tar.gz) = d80f2b459d00bea269435bb4ca05bd78 +MD5 (postgresql-6.2.tar.gz) = 4c59757f6405a6c3011399e3c502afd7 diff --git a/databases/postgresql84-server/files/pgsql.sh.tmpl b/databases/postgresql84-server/files/pgsql.sh.tmpl new file mode 100644 index 00000000000..7321cf4f472 --- /dev/null +++ b/databases/postgresql84-server/files/pgsql.sh.tmpl @@ -0,0 +1,21 @@ +#!/bin/sh + +# $Id$ + +# pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) + +# Changes: +# - renamed startup script to be in sync with INSTALL file +# - merged ldconfig start sequence from former postgrsql.sh script (andreas) +# - modified the postmaster startup sequence as suggested in the +# INSTALL file which was given as example for FreeBSD 2.2 (andreas) + + +[ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib + +[ -x !!PREFIX!!/pgsql/bin/postmaster ] && { + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster + -D!!PREFIX!!/pgsql/data + -S -o -F > !!PREFIX!!/pgsql/errlog' & + echo -n ' pgsql' +} diff --git a/databases/postgresql84-server/files/post-install-notes b/databases/postgresql84-server/files/post-install-notes index 1956d17766c..910966e67f1 100644 --- a/databases/postgresql84-server/files/post-install-notes +++ b/databases/postgresql84-server/files/post-install-notes @@ -4,3 +4,7 @@ implementation guides. These can be found at: http://www.PostgreSQL.org/docs +You may wish to subscribe to the PostgreSQL user-support mailing list. +Send an e-mail to pgsql-questions-request@postgresql.org with the +text "subscribe" in the message body. + diff --git a/databases/postgresql84-server/pkg-descr b/databases/postgresql84-server/pkg-descr index 680bf5c7f2b..f0283be0cd6 100644 --- a/databases/postgresql84-server/pkg-descr +++ b/databases/postgresql84-server/pkg-descr @@ -1,4 +1,3 @@ - PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), derived from the Berkeley Postgres database management system. While PostgreSQL retains the powerful object-relational data model, rich data types @@ -16,12 +15,10 @@ memory, PostgreSQL was born. PostgreSQL development is presently being performed by a team of Internet developers who are now responsible for all current and future development. The -development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.Org). +development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG). Support is available from the PostgreSQL developer/user community through the -support mailing list (questions@PostgreSQL.Org). +support mailing list (questions@PostgreSQL.ORG). PostgreSQL is free and the complete source is available. -More information and documentation can be found on the PostgreSQL website, -at: http://www.PostgreSQL.Org - +More information and documentation, visit: http://www.PostgreSQL.ORG/ diff --git a/databases/postgresql84-server/pkg-plist b/databases/postgresql84-server/pkg-plist index 6801de7d0d9..4a28e685189 100644 --- a/databases/postgresql84-server/pkg-plist +++ b/databases/postgresql84-server/pkg-plist @@ -1,4 +1,4 @@ -etc/rc.d/postgresql.sh +etc/rc.d/pgsql.sh pgsql/.profile pgsql/bin/cleardbdir pgsql/bin/createdb @@ -9,8 +9,10 @@ pgsql/bin/initdb pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id +pgsql/bin/pg_passwd pgsql/bin/pg_version pgsql/bin/postgres +pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -20,6 +22,8 @@ pgsql/data/base/template1/pg_amop pgsql/data/base/template1/pg_amproc pgsql/data/base/template1/pg_attnameind pgsql/data/base/template1/pg_attnumind +pgsql/data/base/template1/pg_attrdef +pgsql/data/base/template1/pg_attrdefind pgsql/data/base/template1/pg_attrelidind pgsql/data/base/template1/pg_attribute pgsql/data/base/template1/pg_class @@ -39,8 +43,12 @@ pgsql/data/base/template1/pg_proc pgsql/data/base/template1/pg_procidind pgsql/data/base/template1/pg_procnameind pgsql/data/base/template1/pg_procsrcind +pgsql/data/base/template1/pg_relcheck +pgsql/data/base/template1/pg_relcheckind pgsql/data/base/template1/pg_rewrite pgsql/data/base/template1/pg_statistic +pgsql/data/base/template1/pg_trigger +pgsql/data/base/template1/pg_trigrelidind pgsql/data/base/template1/pg_type pgsql/data/base/template1/pg_typeidind pgsql/data/base/template1/pg_typenameind @@ -74,6 +82,7 @@ pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source pgsql/lib/libpq.a +pgsql/lib/libpq.so pgsql/lib/libpq.so.1.0 pgsql/lib/local1_template1.bki.source pgsql/lib/pg_geqo.sample @@ -88,15 +97,16 @@ pgsql/man/man1/ipcclean.1.gz pgsql/man/man1/monitor.1.gz pgsql/man/man1/pg_dump.1.gz pgsql/man/man1/pg_dumpall.1.gz +pgsql/man/man1/pg_passwd.1.gz +pgsql/man/man1/pgintro.1.gz pgsql/man/man1/postgres.1.gz pgsql/man/man1/postmaster.1.gz pgsql/man/man1/psql.1.gz -pgsql/man/man1/unix.1.gz -pgsql/man/man3/built-in.3.gz pgsql/man/man3/catalogs.3.gz pgsql/man/man3/large_objects.3.gz pgsql/man/man3/libpq.3.gz pgsql/man/man3/oracle_compat.3.gz +pgsql/man/man3/pgbuiltin.3.gz pgsql/man/man5/bki.5.gz pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz @@ -115,9 +125,11 @@ pgsql/man/manl/create_operator.l.gz pgsql/man/manl/create_rule.l.gz pgsql/man/manl/create_sequence.l.gz pgsql/man/manl/create_table.l.gz +pgsql/man/manl/create_trigger.l.gz pgsql/man/manl/create_type.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz +pgsql/man/manl/declare.l.gz pgsql/man/manl/delete.l.gz pgsql/man/manl/drop.l.gz pgsql/man/manl/drop_aggregate.l.gz @@ -127,6 +139,8 @@ pgsql/man/manl/drop_index.l.gz pgsql/man/manl/drop_operator.l.gz pgsql/man/manl/drop_rule.l.gz pgsql/man/manl/drop_sequence.l.gz +pgsql/man/manl/drop_table.l.gz +pgsql/man/manl/drop_trigger.l.gz pgsql/man/manl/drop_type.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz @@ -136,6 +150,7 @@ pgsql/man/manl/grant.l.gz pgsql/man/manl/insert.l.gz pgsql/man/manl/listen.l.gz pgsql/man/manl/load.l.gz +pgsql/man/manl/move.l.gz pgsql/man/manl/notify.l.gz pgsql/man/manl/purge.l.gz pgsql/man/manl/rename.l.gz @@ -159,24 +174,49 @@ share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO share/doc/pgsql/bug.template share/doc/pgsql/libpgtcl.doc +share/doc/pgsql/manual/admin.html +share/doc/pgsql/manual/advanced.html +share/doc/pgsql/manual/appenda.html +share/doc/pgsql/manual/architec.html +share/doc/pgsql/manual/copy.html +share/doc/pgsql/manual/extend.html +share/doc/pgsql/manual/figure01.gif +share/doc/pgsql/manual/figure02.gif +share/doc/pgsql/manual/figure03.gif +share/doc/pgsql/manual/intro.html +share/doc/pgsql/manual/libpq.html +share/doc/pgsql/manual/lobj.html +share/doc/pgsql/manual/pg95user.html +share/doc/pgsql/manual/query.html +share/doc/pgsql/manual/refs.html +share/doc/pgsql/manual/rules.html +share/doc/pgsql/manual/start.html +share/doc/pgsql/manual/xaggr.html +share/doc/pgsql/manual/xfunc.html +share/doc/pgsql/manual/xindex.html +share/doc/pgsql/manual/xoper.html +share/doc/pgsql/manual/xtypes.html +share/doc/pgsql/spi.txt +share/doc/pgsql/trigger.txt share/doc/pgsql/userguide.ps +@dirrm share/doc/pgsql/manual @dirrm share/doc/pgsql -@dirrm pgsql/lib @dirrm pgsql/bin -@dirrm pgsql/include/port/BSD44_derived -@dirrm pgsql/include/port +@dirrm pgsql/data/base/template1 +@dirrm pgsql/data/base +@dirrm pgsql/data +@dirrm pgsql/include/access @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq +@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port @dirrm pgsql/include/utils -@dirrm pgsql/include/access @dirrm pgsql/include +@dirrm pgsql/lib @dirrm pgsql/man/man1 @dirrm pgsql/man/man3 @dirrm pgsql/man/man5 @dirrm pgsql/man/manl @dirrm pgsql/man -@dirrm pgsql/data/base/template1 -@dirrm pgsql/data/base -@dirrm pgsql/data @dirrm pgsql diff --git a/databases/postgresql90-server/Makefile b/databases/postgresql90-server/Makefile index f11b16deb17..be9e1d8230a 100644 --- a/databases/postgresql90-server/Makefile +++ b/databases/postgresql90-server/Makefile @@ -1,17 +1,16 @@ # New ports collection makefile for: PostgreSQL -# Version required: 6.1 +# Version required: 6.1 # Date created: April 2, 1997 # Whom: Marc G. Fournier <scrappy@FreeBSD.ORG> # -# $Id: Makefile,v 1.13 1997/07/17 15:12:40 max Exp $ +# $Id: Makefile,v 1.14 1997/09/27 21:43:48 andreas Exp $ -DISTNAME= postgresql-v6.1.1 -PKGNAME= postgresql-6.1.1 +DISTNAME= postgresql-6.2 CATEGORIES= databases MASTER_SITES= ftp://ftp.PostgreSQL.org/pub/ \ ftp://ftp.luga.or.at/pub/postgres95/ \ - ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ - + ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ + MAINTAINER= andreas@FreeBSD.ORG NO_PACKAGE= "Requires pgsql uid" @@ -20,59 +19,71 @@ USE_GMAKE= YES HAS_CONFIGURE= YES CONFIGURE_ARGS+=--prefix=${PREFIX}/pgsql \ --enable-locale \ - --with-template=`uname -s | tr '[A-Z]' '[a-z]'` + --with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'` MAKEFILE= GNUmakefile MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 postgres.1 postmaster.1 psql.1 unix.1 -MAN3= built-in.3 catalogs.3 large_objects.3 libpq.3 oracle_compat.3 -MAN5= bki.5 page.5 pg_hba.conf.5 + pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + postmaster.1 psql.1 +MAN3= catalogs.3 large_objects.3 libpq.3 oracle_compat.3 pgbuiltin.3 +MAN5= bki.5 page.5 pg_hba.conf.5 MANL= abort.l alter_table.l begin.l close.l cluster.l \ commit.l copy.l create_aggregate.l create_database.l \ create_function.l create_index.l create_operator.l \ create_rule.l create_sequence.l create_table.l \ - create_type.l create_version.l create_view.l delete.l \ - drop.l drop_aggregate.l drop_database.l drop_function.l \ - drop_index.l drop_operator.l drop_rule.l drop_sequence.l \ + create_trigger.l create_type.l create_version.l \ + create_view.l declare.l delete.l drop.l drop_aggregate.l \ + drop_database.l drop_function.l drop_index.l drop_operator.l \ + drop_rule.l drop_sequence.l drop_table.l drop_trigger.l \ drop_type.l drop_view.l end.l explain.l fetch.l grant.l \ - insert.l listen.l load.l notify.l purge.l rename.l \ - reset.l revoke.l rollback.l select.l set.l show.l \ - sql.l update.l vacuum.l + insert.l listen.l load.l move.l notify.l purge.l rename.l \ + reset.l revoke.l rollback.l select.l set.l show.l sql.l \ + update.l vacuum.l + MANPREFIX= ${PREFIX}/pgsql +post-build: + @ ${ECHO} "------------------------------------------------------------" + @ ${ECHO} "Dump existing databases, before installing new db version !!" + @ ${ECHO} "Detailed instructions, see INSTALL file under ${WRKDIR}... " + @ ${ECHO} "------------------------------------------------------------" + pre-install: @ ${MKDIR} ${PREFIX}/pgsql - @ ${SETENV} ${MAKE_ENV} /usr/bin/perl ${SCRIPTDIR}/createuser + @ ${SETENV} ${MAKE_ENV} perl ${SCRIPTDIR}/createuser post-install: @ if [ ! -f ${PREFIX}/pgsql/.profile ]; then \ - echo "PATH=${PATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "PATH=${PATH}:${PREFIX}/pgsql/bin" \ > ${PREFIX}/pgsql/.profile; \ - echo "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "PGLIB=${PREFIX}/pgsql/lib" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGLIB=${PREFIX}/pgsql/lib" \ + ${ECHO} "PGDATA=${PREFIX}/pgsql/data" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGDATA=${PREFIX}/pgsql/data" \ + ${ECHO} "export PATH MANPATH PGLIB PGDATA" \ >> ${PREFIX}/pgsql/.profile; \ - echo "export PATH MANPATH PGLIB PGDATA" \ + ${ECHO} "# if you want to make regression tests use this TZ" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#TZ=PST8PDT" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#export TZ" \ >> ${PREFIX}/pgsql/.profile; \ fi @ chown -R pgsql:pgsql ${PREFIX}/pgsql - @ echo 'Initializing PostgreSQL Databases - this may take a few minutes...' + @ ${ECHO} 'Initializing PostgreSQL Databases - this may take a few minutes...' @ ${LDCONFIG} -m ${PREFIX}/pgsql/lib @ su -l pgsql -c '${PREFIX}/pgsql/bin/initdb --pglib=${PREFIX}/pgsql/lib --pgdata=${PREFIX}/pgsql/data' - @ if [ ! -f ${PREFIX}/etc/rc.d/postgresql.sh ]; then \ - echo "Installing ${PREFIX}/etc/rc.d/postgresql.sh startup file."; \ - echo "#!/bin/sh" > ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -d ${PREFIX}/pgsql/lib ] && /sbin/ldconfig -m ${PREFIX}/pgsql/lib" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -x ${PREFIX}/pgsql/bin/postmaster ] && su -l pgsql -c '${PREFIX}/pgsql/bin/postmaster -D${PREFIX}/pgsql/data -o -F > ${PREFIX}/pgsql/errlog &' && echo -n ' pgsql'" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - chmod 751 ${PREFIX}/etc/rc.d/postgresql.sh; \ - fi + @ ${SED} -e "s=!!PREFIX!!=${PREFIX}=g" < ${FILESDIR}/pgsql.sh.tmpl \ + > ${PREFIX}/etc/rc.d/pgsql.sh + @ chmod 554 ${PREFIX}/etc/rc.d/pgsql.sh + @ chown root.pgsql ${PREFIX}/etc/rc.d/pgsql.sh @ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/pgsql .if !defined(NOPORTDOCS) ${MKDIR} ${PREFIX}/share/doc/pgsql - ${CP} ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql + ${CP} -r ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql .endif .if !defined(BATCH) @ more -e ${FILESDIR}/post-install-notes diff --git a/databases/postgresql90-server/distinfo b/databases/postgresql90-server/distinfo index 70b03de859e..312e4988872 100644 --- a/databases/postgresql90-server/distinfo +++ b/databases/postgresql90-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-v6.1.1.tar.gz) = d80f2b459d00bea269435bb4ca05bd78 +MD5 (postgresql-6.2.tar.gz) = 4c59757f6405a6c3011399e3c502afd7 diff --git a/databases/postgresql90-server/files/pgsql.sh.tmpl b/databases/postgresql90-server/files/pgsql.sh.tmpl new file mode 100644 index 00000000000..7321cf4f472 --- /dev/null +++ b/databases/postgresql90-server/files/pgsql.sh.tmpl @@ -0,0 +1,21 @@ +#!/bin/sh + +# $Id$ + +# pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) + +# Changes: +# - renamed startup script to be in sync with INSTALL file +# - merged ldconfig start sequence from former postgrsql.sh script (andreas) +# - modified the postmaster startup sequence as suggested in the +# INSTALL file which was given as example for FreeBSD 2.2 (andreas) + + +[ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib + +[ -x !!PREFIX!!/pgsql/bin/postmaster ] && { + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster + -D!!PREFIX!!/pgsql/data + -S -o -F > !!PREFIX!!/pgsql/errlog' & + echo -n ' pgsql' +} diff --git a/databases/postgresql90-server/files/post-install-notes b/databases/postgresql90-server/files/post-install-notes index 1956d17766c..910966e67f1 100644 --- a/databases/postgresql90-server/files/post-install-notes +++ b/databases/postgresql90-server/files/post-install-notes @@ -4,3 +4,7 @@ implementation guides. These can be found at: http://www.PostgreSQL.org/docs +You may wish to subscribe to the PostgreSQL user-support mailing list. +Send an e-mail to pgsql-questions-request@postgresql.org with the +text "subscribe" in the message body. + diff --git a/databases/postgresql90-server/pkg-descr b/databases/postgresql90-server/pkg-descr index 680bf5c7f2b..f0283be0cd6 100644 --- a/databases/postgresql90-server/pkg-descr +++ b/databases/postgresql90-server/pkg-descr @@ -1,4 +1,3 @@ - PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), derived from the Berkeley Postgres database management system. While PostgreSQL retains the powerful object-relational data model, rich data types @@ -16,12 +15,10 @@ memory, PostgreSQL was born. PostgreSQL development is presently being performed by a team of Internet developers who are now responsible for all current and future development. The -development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.Org). +development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG). Support is available from the PostgreSQL developer/user community through the -support mailing list (questions@PostgreSQL.Org). +support mailing list (questions@PostgreSQL.ORG). PostgreSQL is free and the complete source is available. -More information and documentation can be found on the PostgreSQL website, -at: http://www.PostgreSQL.Org - +More information and documentation, visit: http://www.PostgreSQL.ORG/ diff --git a/databases/postgresql90-server/pkg-plist b/databases/postgresql90-server/pkg-plist index 6801de7d0d9..4a28e685189 100644 --- a/databases/postgresql90-server/pkg-plist +++ b/databases/postgresql90-server/pkg-plist @@ -1,4 +1,4 @@ -etc/rc.d/postgresql.sh +etc/rc.d/pgsql.sh pgsql/.profile pgsql/bin/cleardbdir pgsql/bin/createdb @@ -9,8 +9,10 @@ pgsql/bin/initdb pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id +pgsql/bin/pg_passwd pgsql/bin/pg_version pgsql/bin/postgres +pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -20,6 +22,8 @@ pgsql/data/base/template1/pg_amop pgsql/data/base/template1/pg_amproc pgsql/data/base/template1/pg_attnameind pgsql/data/base/template1/pg_attnumind +pgsql/data/base/template1/pg_attrdef +pgsql/data/base/template1/pg_attrdefind pgsql/data/base/template1/pg_attrelidind pgsql/data/base/template1/pg_attribute pgsql/data/base/template1/pg_class @@ -39,8 +43,12 @@ pgsql/data/base/template1/pg_proc pgsql/data/base/template1/pg_procidind pgsql/data/base/template1/pg_procnameind pgsql/data/base/template1/pg_procsrcind +pgsql/data/base/template1/pg_relcheck +pgsql/data/base/template1/pg_relcheckind pgsql/data/base/template1/pg_rewrite pgsql/data/base/template1/pg_statistic +pgsql/data/base/template1/pg_trigger +pgsql/data/base/template1/pg_trigrelidind pgsql/data/base/template1/pg_type pgsql/data/base/template1/pg_typeidind pgsql/data/base/template1/pg_typenameind @@ -74,6 +82,7 @@ pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source pgsql/lib/libpq.a +pgsql/lib/libpq.so pgsql/lib/libpq.so.1.0 pgsql/lib/local1_template1.bki.source pgsql/lib/pg_geqo.sample @@ -88,15 +97,16 @@ pgsql/man/man1/ipcclean.1.gz pgsql/man/man1/monitor.1.gz pgsql/man/man1/pg_dump.1.gz pgsql/man/man1/pg_dumpall.1.gz +pgsql/man/man1/pg_passwd.1.gz +pgsql/man/man1/pgintro.1.gz pgsql/man/man1/postgres.1.gz pgsql/man/man1/postmaster.1.gz pgsql/man/man1/psql.1.gz -pgsql/man/man1/unix.1.gz -pgsql/man/man3/built-in.3.gz pgsql/man/man3/catalogs.3.gz pgsql/man/man3/large_objects.3.gz pgsql/man/man3/libpq.3.gz pgsql/man/man3/oracle_compat.3.gz +pgsql/man/man3/pgbuiltin.3.gz pgsql/man/man5/bki.5.gz pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz @@ -115,9 +125,11 @@ pgsql/man/manl/create_operator.l.gz pgsql/man/manl/create_rule.l.gz pgsql/man/manl/create_sequence.l.gz pgsql/man/manl/create_table.l.gz +pgsql/man/manl/create_trigger.l.gz pgsql/man/manl/create_type.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz +pgsql/man/manl/declare.l.gz pgsql/man/manl/delete.l.gz pgsql/man/manl/drop.l.gz pgsql/man/manl/drop_aggregate.l.gz @@ -127,6 +139,8 @@ pgsql/man/manl/drop_index.l.gz pgsql/man/manl/drop_operator.l.gz pgsql/man/manl/drop_rule.l.gz pgsql/man/manl/drop_sequence.l.gz +pgsql/man/manl/drop_table.l.gz +pgsql/man/manl/drop_trigger.l.gz pgsql/man/manl/drop_type.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz @@ -136,6 +150,7 @@ pgsql/man/manl/grant.l.gz pgsql/man/manl/insert.l.gz pgsql/man/manl/listen.l.gz pgsql/man/manl/load.l.gz +pgsql/man/manl/move.l.gz pgsql/man/manl/notify.l.gz pgsql/man/manl/purge.l.gz pgsql/man/manl/rename.l.gz @@ -159,24 +174,49 @@ share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO share/doc/pgsql/bug.template share/doc/pgsql/libpgtcl.doc +share/doc/pgsql/manual/admin.html +share/doc/pgsql/manual/advanced.html +share/doc/pgsql/manual/appenda.html +share/doc/pgsql/manual/architec.html +share/doc/pgsql/manual/copy.html +share/doc/pgsql/manual/extend.html +share/doc/pgsql/manual/figure01.gif +share/doc/pgsql/manual/figure02.gif +share/doc/pgsql/manual/figure03.gif +share/doc/pgsql/manual/intro.html +share/doc/pgsql/manual/libpq.html +share/doc/pgsql/manual/lobj.html +share/doc/pgsql/manual/pg95user.html +share/doc/pgsql/manual/query.html +share/doc/pgsql/manual/refs.html +share/doc/pgsql/manual/rules.html +share/doc/pgsql/manual/start.html +share/doc/pgsql/manual/xaggr.html +share/doc/pgsql/manual/xfunc.html +share/doc/pgsql/manual/xindex.html +share/doc/pgsql/manual/xoper.html +share/doc/pgsql/manual/xtypes.html +share/doc/pgsql/spi.txt +share/doc/pgsql/trigger.txt share/doc/pgsql/userguide.ps +@dirrm share/doc/pgsql/manual @dirrm share/doc/pgsql -@dirrm pgsql/lib @dirrm pgsql/bin -@dirrm pgsql/include/port/BSD44_derived -@dirrm pgsql/include/port +@dirrm pgsql/data/base/template1 +@dirrm pgsql/data/base +@dirrm pgsql/data +@dirrm pgsql/include/access @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq +@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port @dirrm pgsql/include/utils -@dirrm pgsql/include/access @dirrm pgsql/include +@dirrm pgsql/lib @dirrm pgsql/man/man1 @dirrm pgsql/man/man3 @dirrm pgsql/man/man5 @dirrm pgsql/man/manl @dirrm pgsql/man -@dirrm pgsql/data/base/template1 -@dirrm pgsql/data/base -@dirrm pgsql/data @dirrm pgsql diff --git a/databases/postgresql91-server/Makefile b/databases/postgresql91-server/Makefile index f11b16deb17..be9e1d8230a 100644 --- a/databases/postgresql91-server/Makefile +++ b/databases/postgresql91-server/Makefile @@ -1,17 +1,16 @@ # New ports collection makefile for: PostgreSQL -# Version required: 6.1 +# Version required: 6.1 # Date created: April 2, 1997 # Whom: Marc G. Fournier <scrappy@FreeBSD.ORG> # -# $Id: Makefile,v 1.13 1997/07/17 15:12:40 max Exp $ +# $Id: Makefile,v 1.14 1997/09/27 21:43:48 andreas Exp $ -DISTNAME= postgresql-v6.1.1 -PKGNAME= postgresql-6.1.1 +DISTNAME= postgresql-6.2 CATEGORIES= databases MASTER_SITES= ftp://ftp.PostgreSQL.org/pub/ \ ftp://ftp.luga.or.at/pub/postgres95/ \ - ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ - + ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ + MAINTAINER= andreas@FreeBSD.ORG NO_PACKAGE= "Requires pgsql uid" @@ -20,59 +19,71 @@ USE_GMAKE= YES HAS_CONFIGURE= YES CONFIGURE_ARGS+=--prefix=${PREFIX}/pgsql \ --enable-locale \ - --with-template=`uname -s | tr '[A-Z]' '[a-z]'` + --with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'` MAKEFILE= GNUmakefile MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 postgres.1 postmaster.1 psql.1 unix.1 -MAN3= built-in.3 catalogs.3 large_objects.3 libpq.3 oracle_compat.3 -MAN5= bki.5 page.5 pg_hba.conf.5 + pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + postmaster.1 psql.1 +MAN3= catalogs.3 large_objects.3 libpq.3 oracle_compat.3 pgbuiltin.3 +MAN5= bki.5 page.5 pg_hba.conf.5 MANL= abort.l alter_table.l begin.l close.l cluster.l \ commit.l copy.l create_aggregate.l create_database.l \ create_function.l create_index.l create_operator.l \ create_rule.l create_sequence.l create_table.l \ - create_type.l create_version.l create_view.l delete.l \ - drop.l drop_aggregate.l drop_database.l drop_function.l \ - drop_index.l drop_operator.l drop_rule.l drop_sequence.l \ + create_trigger.l create_type.l create_version.l \ + create_view.l declare.l delete.l drop.l drop_aggregate.l \ + drop_database.l drop_function.l drop_index.l drop_operator.l \ + drop_rule.l drop_sequence.l drop_table.l drop_trigger.l \ drop_type.l drop_view.l end.l explain.l fetch.l grant.l \ - insert.l listen.l load.l notify.l purge.l rename.l \ - reset.l revoke.l rollback.l select.l set.l show.l \ - sql.l update.l vacuum.l + insert.l listen.l load.l move.l notify.l purge.l rename.l \ + reset.l revoke.l rollback.l select.l set.l show.l sql.l \ + update.l vacuum.l + MANPREFIX= ${PREFIX}/pgsql +post-build: + @ ${ECHO} "------------------------------------------------------------" + @ ${ECHO} "Dump existing databases, before installing new db version !!" + @ ${ECHO} "Detailed instructions, see INSTALL file under ${WRKDIR}... " + @ ${ECHO} "------------------------------------------------------------" + pre-install: @ ${MKDIR} ${PREFIX}/pgsql - @ ${SETENV} ${MAKE_ENV} /usr/bin/perl ${SCRIPTDIR}/createuser + @ ${SETENV} ${MAKE_ENV} perl ${SCRIPTDIR}/createuser post-install: @ if [ ! -f ${PREFIX}/pgsql/.profile ]; then \ - echo "PATH=${PATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "PATH=${PATH}:${PREFIX}/pgsql/bin" \ > ${PREFIX}/pgsql/.profile; \ - echo "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "PGLIB=${PREFIX}/pgsql/lib" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGLIB=${PREFIX}/pgsql/lib" \ + ${ECHO} "PGDATA=${PREFIX}/pgsql/data" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGDATA=${PREFIX}/pgsql/data" \ + ${ECHO} "export PATH MANPATH PGLIB PGDATA" \ >> ${PREFIX}/pgsql/.profile; \ - echo "export PATH MANPATH PGLIB PGDATA" \ + ${ECHO} "# if you want to make regression tests use this TZ" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#TZ=PST8PDT" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#export TZ" \ >> ${PREFIX}/pgsql/.profile; \ fi @ chown -R pgsql:pgsql ${PREFIX}/pgsql - @ echo 'Initializing PostgreSQL Databases - this may take a few minutes...' + @ ${ECHO} 'Initializing PostgreSQL Databases - this may take a few minutes...' @ ${LDCONFIG} -m ${PREFIX}/pgsql/lib @ su -l pgsql -c '${PREFIX}/pgsql/bin/initdb --pglib=${PREFIX}/pgsql/lib --pgdata=${PREFIX}/pgsql/data' - @ if [ ! -f ${PREFIX}/etc/rc.d/postgresql.sh ]; then \ - echo "Installing ${PREFIX}/etc/rc.d/postgresql.sh startup file."; \ - echo "#!/bin/sh" > ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -d ${PREFIX}/pgsql/lib ] && /sbin/ldconfig -m ${PREFIX}/pgsql/lib" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -x ${PREFIX}/pgsql/bin/postmaster ] && su -l pgsql -c '${PREFIX}/pgsql/bin/postmaster -D${PREFIX}/pgsql/data -o -F > ${PREFIX}/pgsql/errlog &' && echo -n ' pgsql'" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - chmod 751 ${PREFIX}/etc/rc.d/postgresql.sh; \ - fi + @ ${SED} -e "s=!!PREFIX!!=${PREFIX}=g" < ${FILESDIR}/pgsql.sh.tmpl \ + > ${PREFIX}/etc/rc.d/pgsql.sh + @ chmod 554 ${PREFIX}/etc/rc.d/pgsql.sh + @ chown root.pgsql ${PREFIX}/etc/rc.d/pgsql.sh @ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/pgsql .if !defined(NOPORTDOCS) ${MKDIR} ${PREFIX}/share/doc/pgsql - ${CP} ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql + ${CP} -r ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql .endif .if !defined(BATCH) @ more -e ${FILESDIR}/post-install-notes diff --git a/databases/postgresql91-server/distinfo b/databases/postgresql91-server/distinfo index 70b03de859e..312e4988872 100644 --- a/databases/postgresql91-server/distinfo +++ b/databases/postgresql91-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-v6.1.1.tar.gz) = d80f2b459d00bea269435bb4ca05bd78 +MD5 (postgresql-6.2.tar.gz) = 4c59757f6405a6c3011399e3c502afd7 diff --git a/databases/postgresql91-server/files/pgsql.sh.tmpl b/databases/postgresql91-server/files/pgsql.sh.tmpl new file mode 100644 index 00000000000..7321cf4f472 --- /dev/null +++ b/databases/postgresql91-server/files/pgsql.sh.tmpl @@ -0,0 +1,21 @@ +#!/bin/sh + +# $Id$ + +# pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) + +# Changes: +# - renamed startup script to be in sync with INSTALL file +# - merged ldconfig start sequence from former postgrsql.sh script (andreas) +# - modified the postmaster startup sequence as suggested in the +# INSTALL file which was given as example for FreeBSD 2.2 (andreas) + + +[ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib + +[ -x !!PREFIX!!/pgsql/bin/postmaster ] && { + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster + -D!!PREFIX!!/pgsql/data + -S -o -F > !!PREFIX!!/pgsql/errlog' & + echo -n ' pgsql' +} diff --git a/databases/postgresql91-server/files/post-install-notes b/databases/postgresql91-server/files/post-install-notes index 1956d17766c..910966e67f1 100644 --- a/databases/postgresql91-server/files/post-install-notes +++ b/databases/postgresql91-server/files/post-install-notes @@ -4,3 +4,7 @@ implementation guides. These can be found at: http://www.PostgreSQL.org/docs +You may wish to subscribe to the PostgreSQL user-support mailing list. +Send an e-mail to pgsql-questions-request@postgresql.org with the +text "subscribe" in the message body. + diff --git a/databases/postgresql91-server/pkg-descr b/databases/postgresql91-server/pkg-descr index 680bf5c7f2b..f0283be0cd6 100644 --- a/databases/postgresql91-server/pkg-descr +++ b/databases/postgresql91-server/pkg-descr @@ -1,4 +1,3 @@ - PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), derived from the Berkeley Postgres database management system. While PostgreSQL retains the powerful object-relational data model, rich data types @@ -16,12 +15,10 @@ memory, PostgreSQL was born. PostgreSQL development is presently being performed by a team of Internet developers who are now responsible for all current and future development. The -development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.Org). +development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG). Support is available from the PostgreSQL developer/user community through the -support mailing list (questions@PostgreSQL.Org). +support mailing list (questions@PostgreSQL.ORG). PostgreSQL is free and the complete source is available. -More information and documentation can be found on the PostgreSQL website, -at: http://www.PostgreSQL.Org - +More information and documentation, visit: http://www.PostgreSQL.ORG/ diff --git a/databases/postgresql91-server/pkg-plist b/databases/postgresql91-server/pkg-plist index 6801de7d0d9..4a28e685189 100644 --- a/databases/postgresql91-server/pkg-plist +++ b/databases/postgresql91-server/pkg-plist @@ -1,4 +1,4 @@ -etc/rc.d/postgresql.sh +etc/rc.d/pgsql.sh pgsql/.profile pgsql/bin/cleardbdir pgsql/bin/createdb @@ -9,8 +9,10 @@ pgsql/bin/initdb pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id +pgsql/bin/pg_passwd pgsql/bin/pg_version pgsql/bin/postgres +pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -20,6 +22,8 @@ pgsql/data/base/template1/pg_amop pgsql/data/base/template1/pg_amproc pgsql/data/base/template1/pg_attnameind pgsql/data/base/template1/pg_attnumind +pgsql/data/base/template1/pg_attrdef +pgsql/data/base/template1/pg_attrdefind pgsql/data/base/template1/pg_attrelidind pgsql/data/base/template1/pg_attribute pgsql/data/base/template1/pg_class @@ -39,8 +43,12 @@ pgsql/data/base/template1/pg_proc pgsql/data/base/template1/pg_procidind pgsql/data/base/template1/pg_procnameind pgsql/data/base/template1/pg_procsrcind +pgsql/data/base/template1/pg_relcheck +pgsql/data/base/template1/pg_relcheckind pgsql/data/base/template1/pg_rewrite pgsql/data/base/template1/pg_statistic +pgsql/data/base/template1/pg_trigger +pgsql/data/base/template1/pg_trigrelidind pgsql/data/base/template1/pg_type pgsql/data/base/template1/pg_typeidind pgsql/data/base/template1/pg_typenameind @@ -74,6 +82,7 @@ pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source pgsql/lib/libpq.a +pgsql/lib/libpq.so pgsql/lib/libpq.so.1.0 pgsql/lib/local1_template1.bki.source pgsql/lib/pg_geqo.sample @@ -88,15 +97,16 @@ pgsql/man/man1/ipcclean.1.gz pgsql/man/man1/monitor.1.gz pgsql/man/man1/pg_dump.1.gz pgsql/man/man1/pg_dumpall.1.gz +pgsql/man/man1/pg_passwd.1.gz +pgsql/man/man1/pgintro.1.gz pgsql/man/man1/postgres.1.gz pgsql/man/man1/postmaster.1.gz pgsql/man/man1/psql.1.gz -pgsql/man/man1/unix.1.gz -pgsql/man/man3/built-in.3.gz pgsql/man/man3/catalogs.3.gz pgsql/man/man3/large_objects.3.gz pgsql/man/man3/libpq.3.gz pgsql/man/man3/oracle_compat.3.gz +pgsql/man/man3/pgbuiltin.3.gz pgsql/man/man5/bki.5.gz pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz @@ -115,9 +125,11 @@ pgsql/man/manl/create_operator.l.gz pgsql/man/manl/create_rule.l.gz pgsql/man/manl/create_sequence.l.gz pgsql/man/manl/create_table.l.gz +pgsql/man/manl/create_trigger.l.gz pgsql/man/manl/create_type.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz +pgsql/man/manl/declare.l.gz pgsql/man/manl/delete.l.gz pgsql/man/manl/drop.l.gz pgsql/man/manl/drop_aggregate.l.gz @@ -127,6 +139,8 @@ pgsql/man/manl/drop_index.l.gz pgsql/man/manl/drop_operator.l.gz pgsql/man/manl/drop_rule.l.gz pgsql/man/manl/drop_sequence.l.gz +pgsql/man/manl/drop_table.l.gz +pgsql/man/manl/drop_trigger.l.gz pgsql/man/manl/drop_type.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz @@ -136,6 +150,7 @@ pgsql/man/manl/grant.l.gz pgsql/man/manl/insert.l.gz pgsql/man/manl/listen.l.gz pgsql/man/manl/load.l.gz +pgsql/man/manl/move.l.gz pgsql/man/manl/notify.l.gz pgsql/man/manl/purge.l.gz pgsql/man/manl/rename.l.gz @@ -159,24 +174,49 @@ share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO share/doc/pgsql/bug.template share/doc/pgsql/libpgtcl.doc +share/doc/pgsql/manual/admin.html +share/doc/pgsql/manual/advanced.html +share/doc/pgsql/manual/appenda.html +share/doc/pgsql/manual/architec.html +share/doc/pgsql/manual/copy.html +share/doc/pgsql/manual/extend.html +share/doc/pgsql/manual/figure01.gif +share/doc/pgsql/manual/figure02.gif +share/doc/pgsql/manual/figure03.gif +share/doc/pgsql/manual/intro.html +share/doc/pgsql/manual/libpq.html +share/doc/pgsql/manual/lobj.html +share/doc/pgsql/manual/pg95user.html +share/doc/pgsql/manual/query.html +share/doc/pgsql/manual/refs.html +share/doc/pgsql/manual/rules.html +share/doc/pgsql/manual/start.html +share/doc/pgsql/manual/xaggr.html +share/doc/pgsql/manual/xfunc.html +share/doc/pgsql/manual/xindex.html +share/doc/pgsql/manual/xoper.html +share/doc/pgsql/manual/xtypes.html +share/doc/pgsql/spi.txt +share/doc/pgsql/trigger.txt share/doc/pgsql/userguide.ps +@dirrm share/doc/pgsql/manual @dirrm share/doc/pgsql -@dirrm pgsql/lib @dirrm pgsql/bin -@dirrm pgsql/include/port/BSD44_derived -@dirrm pgsql/include/port +@dirrm pgsql/data/base/template1 +@dirrm pgsql/data/base +@dirrm pgsql/data +@dirrm pgsql/include/access @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq +@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port @dirrm pgsql/include/utils -@dirrm pgsql/include/access @dirrm pgsql/include +@dirrm pgsql/lib @dirrm pgsql/man/man1 @dirrm pgsql/man/man3 @dirrm pgsql/man/man5 @dirrm pgsql/man/manl @dirrm pgsql/man -@dirrm pgsql/data/base/template1 -@dirrm pgsql/data/base -@dirrm pgsql/data @dirrm pgsql diff --git a/databases/postgresql92-server/Makefile b/databases/postgresql92-server/Makefile index f11b16deb17..be9e1d8230a 100644 --- a/databases/postgresql92-server/Makefile +++ b/databases/postgresql92-server/Makefile @@ -1,17 +1,16 @@ # New ports collection makefile for: PostgreSQL -# Version required: 6.1 +# Version required: 6.1 # Date created: April 2, 1997 # Whom: Marc G. Fournier <scrappy@FreeBSD.ORG> # -# $Id: Makefile,v 1.13 1997/07/17 15:12:40 max Exp $ +# $Id: Makefile,v 1.14 1997/09/27 21:43:48 andreas Exp $ -DISTNAME= postgresql-v6.1.1 -PKGNAME= postgresql-6.1.1 +DISTNAME= postgresql-6.2 CATEGORIES= databases MASTER_SITES= ftp://ftp.PostgreSQL.org/pub/ \ ftp://ftp.luga.or.at/pub/postgres95/ \ - ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ - + ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/ + MAINTAINER= andreas@FreeBSD.ORG NO_PACKAGE= "Requires pgsql uid" @@ -20,59 +19,71 @@ USE_GMAKE= YES HAS_CONFIGURE= YES CONFIGURE_ARGS+=--prefix=${PREFIX}/pgsql \ --enable-locale \ - --with-template=`uname -s | tr '[A-Z]' '[a-z]'` + --with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'` MAKEFILE= GNUmakefile MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 postgres.1 postmaster.1 psql.1 unix.1 -MAN3= built-in.3 catalogs.3 large_objects.3 libpq.3 oracle_compat.3 -MAN5= bki.5 page.5 pg_hba.conf.5 + pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + postmaster.1 psql.1 +MAN3= catalogs.3 large_objects.3 libpq.3 oracle_compat.3 pgbuiltin.3 +MAN5= bki.5 page.5 pg_hba.conf.5 MANL= abort.l alter_table.l begin.l close.l cluster.l \ commit.l copy.l create_aggregate.l create_database.l \ create_function.l create_index.l create_operator.l \ create_rule.l create_sequence.l create_table.l \ - create_type.l create_version.l create_view.l delete.l \ - drop.l drop_aggregate.l drop_database.l drop_function.l \ - drop_index.l drop_operator.l drop_rule.l drop_sequence.l \ + create_trigger.l create_type.l create_version.l \ + create_view.l declare.l delete.l drop.l drop_aggregate.l \ + drop_database.l drop_function.l drop_index.l drop_operator.l \ + drop_rule.l drop_sequence.l drop_table.l drop_trigger.l \ drop_type.l drop_view.l end.l explain.l fetch.l grant.l \ - insert.l listen.l load.l notify.l purge.l rename.l \ - reset.l revoke.l rollback.l select.l set.l show.l \ - sql.l update.l vacuum.l + insert.l listen.l load.l move.l notify.l purge.l rename.l \ + reset.l revoke.l rollback.l select.l set.l show.l sql.l \ + update.l vacuum.l + MANPREFIX= ${PREFIX}/pgsql +post-build: + @ ${ECHO} "------------------------------------------------------------" + @ ${ECHO} "Dump existing databases, before installing new db version !!" + @ ${ECHO} "Detailed instructions, see INSTALL file under ${WRKDIR}... " + @ ${ECHO} "------------------------------------------------------------" + pre-install: @ ${MKDIR} ${PREFIX}/pgsql - @ ${SETENV} ${MAKE_ENV} /usr/bin/perl ${SCRIPTDIR}/createuser + @ ${SETENV} ${MAKE_ENV} perl ${SCRIPTDIR}/createuser post-install: @ if [ ! -f ${PREFIX}/pgsql/.profile ]; then \ - echo "PATH=${PATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "PATH=${PATH}:${PREFIX}/pgsql/bin" \ > ${PREFIX}/pgsql/.profile; \ - echo "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + ${ECHO} "MANPATH=${MANPATH}:${PREFIX}/pgsql/bin" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "PGLIB=${PREFIX}/pgsql/lib" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGLIB=${PREFIX}/pgsql/lib" \ + ${ECHO} "PGDATA=${PREFIX}/pgsql/data" \ >> ${PREFIX}/pgsql/.profile; \ - echo "PGDATA=${PREFIX}/pgsql/data" \ + ${ECHO} "export PATH MANPATH PGLIB PGDATA" \ >> ${PREFIX}/pgsql/.profile; \ - echo "export PATH MANPATH PGLIB PGDATA" \ + ${ECHO} "# if you want to make regression tests use this TZ" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#TZ=PST8PDT" \ + >> ${PREFIX}/pgsql/.profile; \ + ${ECHO} "#export TZ" \ >> ${PREFIX}/pgsql/.profile; \ fi @ chown -R pgsql:pgsql ${PREFIX}/pgsql - @ echo 'Initializing PostgreSQL Databases - this may take a few minutes...' + @ ${ECHO} 'Initializing PostgreSQL Databases - this may take a few minutes...' @ ${LDCONFIG} -m ${PREFIX}/pgsql/lib @ su -l pgsql -c '${PREFIX}/pgsql/bin/initdb --pglib=${PREFIX}/pgsql/lib --pgdata=${PREFIX}/pgsql/data' - @ if [ ! -f ${PREFIX}/etc/rc.d/postgresql.sh ]; then \ - echo "Installing ${PREFIX}/etc/rc.d/postgresql.sh startup file."; \ - echo "#!/bin/sh" > ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -d ${PREFIX}/pgsql/lib ] && /sbin/ldconfig -m ${PREFIX}/pgsql/lib" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - echo "[ -x ${PREFIX}/pgsql/bin/postmaster ] && su -l pgsql -c '${PREFIX}/pgsql/bin/postmaster -D${PREFIX}/pgsql/data -o -F > ${PREFIX}/pgsql/errlog &' && echo -n ' pgsql'" >> ${PREFIX}/etc/rc.d/postgresql.sh; \ - chmod 751 ${PREFIX}/etc/rc.d/postgresql.sh; \ - fi + @ ${SED} -e "s=!!PREFIX!!=${PREFIX}=g" < ${FILESDIR}/pgsql.sh.tmpl \ + > ${PREFIX}/etc/rc.d/pgsql.sh + @ chmod 554 ${PREFIX}/etc/rc.d/pgsql.sh + @ chown root.pgsql ${PREFIX}/etc/rc.d/pgsql.sh @ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/pgsql .if !defined(NOPORTDOCS) ${MKDIR} ${PREFIX}/share/doc/pgsql - ${CP} ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql + ${CP} -r ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql .endif .if !defined(BATCH) @ more -e ${FILESDIR}/post-install-notes diff --git a/databases/postgresql92-server/distinfo b/databases/postgresql92-server/distinfo index 70b03de859e..312e4988872 100644 --- a/databases/postgresql92-server/distinfo +++ b/databases/postgresql92-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-v6.1.1.tar.gz) = d80f2b459d00bea269435bb4ca05bd78 +MD5 (postgresql-6.2.tar.gz) = 4c59757f6405a6c3011399e3c502afd7 diff --git a/databases/postgresql92-server/files/pgsql.sh.tmpl b/databases/postgresql92-server/files/pgsql.sh.tmpl new file mode 100644 index 00000000000..7321cf4f472 --- /dev/null +++ b/databases/postgresql92-server/files/pgsql.sh.tmpl @@ -0,0 +1,21 @@ +#!/bin/sh + +# $Id$ + +# pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) + +# Changes: +# - renamed startup script to be in sync with INSTALL file +# - merged ldconfig start sequence from former postgrsql.sh script (andreas) +# - modified the postmaster startup sequence as suggested in the +# INSTALL file which was given as example for FreeBSD 2.2 (andreas) + + +[ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib + +[ -x !!PREFIX!!/pgsql/bin/postmaster ] && { + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster + -D!!PREFIX!!/pgsql/data + -S -o -F > !!PREFIX!!/pgsql/errlog' & + echo -n ' pgsql' +} diff --git a/databases/postgresql92-server/files/post-install-notes b/databases/postgresql92-server/files/post-install-notes index 1956d17766c..910966e67f1 100644 --- a/databases/postgresql92-server/files/post-install-notes +++ b/databases/postgresql92-server/files/post-install-notes @@ -4,3 +4,7 @@ implementation guides. These can be found at: http://www.PostgreSQL.org/docs +You may wish to subscribe to the PostgreSQL user-support mailing list. +Send an e-mail to pgsql-questions-request@postgresql.org with the +text "subscribe" in the message body. + diff --git a/databases/postgresql92-server/pkg-descr b/databases/postgresql92-server/pkg-descr index 680bf5c7f2b..f0283be0cd6 100644 --- a/databases/postgresql92-server/pkg-descr +++ b/databases/postgresql92-server/pkg-descr @@ -1,4 +1,3 @@ - PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), derived from the Berkeley Postgres database management system. While PostgreSQL retains the powerful object-relational data model, rich data types @@ -16,12 +15,10 @@ memory, PostgreSQL was born. PostgreSQL development is presently being performed by a team of Internet developers who are now responsible for all current and future development. The -development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.Org). +development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG). Support is available from the PostgreSQL developer/user community through the -support mailing list (questions@PostgreSQL.Org). +support mailing list (questions@PostgreSQL.ORG). PostgreSQL is free and the complete source is available. -More information and documentation can be found on the PostgreSQL website, -at: http://www.PostgreSQL.Org - +More information and documentation, visit: http://www.PostgreSQL.ORG/ diff --git a/databases/postgresql92-server/pkg-plist b/databases/postgresql92-server/pkg-plist index 6801de7d0d9..4a28e685189 100644 --- a/databases/postgresql92-server/pkg-plist +++ b/databases/postgresql92-server/pkg-plist @@ -1,4 +1,4 @@ -etc/rc.d/postgresql.sh +etc/rc.d/pgsql.sh pgsql/.profile pgsql/bin/cleardbdir pgsql/bin/createdb @@ -9,8 +9,10 @@ pgsql/bin/initdb pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id +pgsql/bin/pg_passwd pgsql/bin/pg_version pgsql/bin/postgres +pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -20,6 +22,8 @@ pgsql/data/base/template1/pg_amop pgsql/data/base/template1/pg_amproc pgsql/data/base/template1/pg_attnameind pgsql/data/base/template1/pg_attnumind +pgsql/data/base/template1/pg_attrdef +pgsql/data/base/template1/pg_attrdefind pgsql/data/base/template1/pg_attrelidind pgsql/data/base/template1/pg_attribute pgsql/data/base/template1/pg_class @@ -39,8 +43,12 @@ pgsql/data/base/template1/pg_proc pgsql/data/base/template1/pg_procidind pgsql/data/base/template1/pg_procnameind pgsql/data/base/template1/pg_procsrcind +pgsql/data/base/template1/pg_relcheck +pgsql/data/base/template1/pg_relcheckind pgsql/data/base/template1/pg_rewrite pgsql/data/base/template1/pg_statistic +pgsql/data/base/template1/pg_trigger +pgsql/data/base/template1/pg_trigrelidind pgsql/data/base/template1/pg_type pgsql/data/base/template1/pg_typeidind pgsql/data/base/template1/pg_typenameind @@ -74,6 +82,7 @@ pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source pgsql/lib/libpq.a +pgsql/lib/libpq.so pgsql/lib/libpq.so.1.0 pgsql/lib/local1_template1.bki.source pgsql/lib/pg_geqo.sample @@ -88,15 +97,16 @@ pgsql/man/man1/ipcclean.1.gz pgsql/man/man1/monitor.1.gz pgsql/man/man1/pg_dump.1.gz pgsql/man/man1/pg_dumpall.1.gz +pgsql/man/man1/pg_passwd.1.gz +pgsql/man/man1/pgintro.1.gz pgsql/man/man1/postgres.1.gz pgsql/man/man1/postmaster.1.gz pgsql/man/man1/psql.1.gz -pgsql/man/man1/unix.1.gz -pgsql/man/man3/built-in.3.gz pgsql/man/man3/catalogs.3.gz pgsql/man/man3/large_objects.3.gz pgsql/man/man3/libpq.3.gz pgsql/man/man3/oracle_compat.3.gz +pgsql/man/man3/pgbuiltin.3.gz pgsql/man/man5/bki.5.gz pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz @@ -115,9 +125,11 @@ pgsql/man/manl/create_operator.l.gz pgsql/man/manl/create_rule.l.gz pgsql/man/manl/create_sequence.l.gz pgsql/man/manl/create_table.l.gz +pgsql/man/manl/create_trigger.l.gz pgsql/man/manl/create_type.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz +pgsql/man/manl/declare.l.gz pgsql/man/manl/delete.l.gz pgsql/man/manl/drop.l.gz pgsql/man/manl/drop_aggregate.l.gz @@ -127,6 +139,8 @@ pgsql/man/manl/drop_index.l.gz pgsql/man/manl/drop_operator.l.gz pgsql/man/manl/drop_rule.l.gz pgsql/man/manl/drop_sequence.l.gz +pgsql/man/manl/drop_table.l.gz +pgsql/man/manl/drop_trigger.l.gz pgsql/man/manl/drop_type.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz @@ -136,6 +150,7 @@ pgsql/man/manl/grant.l.gz pgsql/man/manl/insert.l.gz pgsql/man/manl/listen.l.gz pgsql/man/manl/load.l.gz +pgsql/man/manl/move.l.gz pgsql/man/manl/notify.l.gz pgsql/man/manl/purge.l.gz pgsql/man/manl/rename.l.gz @@ -159,24 +174,49 @@ share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO share/doc/pgsql/bug.template share/doc/pgsql/libpgtcl.doc +share/doc/pgsql/manual/admin.html +share/doc/pgsql/manual/advanced.html +share/doc/pgsql/manual/appenda.html +share/doc/pgsql/manual/architec.html +share/doc/pgsql/manual/copy.html +share/doc/pgsql/manual/extend.html +share/doc/pgsql/manual/figure01.gif +share/doc/pgsql/manual/figure02.gif +share/doc/pgsql/manual/figure03.gif +share/doc/pgsql/manual/intro.html +share/doc/pgsql/manual/libpq.html +share/doc/pgsql/manual/lobj.html +share/doc/pgsql/manual/pg95user.html +share/doc/pgsql/manual/query.html +share/doc/pgsql/manual/refs.html +share/doc/pgsql/manual/rules.html +share/doc/pgsql/manual/start.html +share/doc/pgsql/manual/xaggr.html +share/doc/pgsql/manual/xfunc.html +share/doc/pgsql/manual/xindex.html +share/doc/pgsql/manual/xoper.html +share/doc/pgsql/manual/xtypes.html +share/doc/pgsql/spi.txt +share/doc/pgsql/trigger.txt share/doc/pgsql/userguide.ps +@dirrm share/doc/pgsql/manual @dirrm share/doc/pgsql -@dirrm pgsql/lib @dirrm pgsql/bin -@dirrm pgsql/include/port/BSD44_derived -@dirrm pgsql/include/port +@dirrm pgsql/data/base/template1 +@dirrm pgsql/data/base +@dirrm pgsql/data +@dirrm pgsql/include/access @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq +@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port @dirrm pgsql/include/utils -@dirrm pgsql/include/access @dirrm pgsql/include +@dirrm pgsql/lib @dirrm pgsql/man/man1 @dirrm pgsql/man/man3 @dirrm pgsql/man/man5 @dirrm pgsql/man/manl @dirrm pgsql/man -@dirrm pgsql/data/base/template1 -@dirrm pgsql/data/base -@dirrm pgsql/data @dirrm pgsql |