From 36f89aec96a7e05ab98027269654b5437626b6a2 Mon Sep 17 00:00:00 2001 From: Andreas Klemm Date: Tue, 21 Apr 1998 21:52:10 +0000 Subject: Upgrade postgresql to version 6.3.2 Many bugfixes and cosmetic changes Changes by Scrappy and me My additional changes: - had to link libpgtcl.so with the crypt library to get rid of the pgaccess error message, that crypt is missing - had to add -i option in the startup script, so that pgaccess is able to connect to the postmaster process - removed all unnecessary patches - updated PLIST Thanks to the postgresql developement team, who did a great job to simplify the postgresql port, by applying the patches and making the autoconf mechanism more consistent. Submitted by: The Hermit Hacker --- databases/postgresql-devel-server/Makefile | 39 +++-- databases/postgresql-devel-server/distinfo | 2 +- .../postgresql-devel-server/files/pgsql.sh.tmpl | 6 +- databases/postgresql-devel-server/pkg-plist | 178 ++++++++++++++------- databases/postgresql-devel/Makefile | 39 +++-- databases/postgresql-devel/distinfo | 2 +- databases/postgresql-devel/files/pgsql.sh.tmpl | 6 +- databases/postgresql-devel/pkg-plist | 178 ++++++++++++++------- databases/postgresql7/Makefile | 39 +++-- databases/postgresql7/distinfo | 2 +- databases/postgresql7/files/pgsql.sh.tmpl | 6 +- databases/postgresql7/pkg-plist | 178 ++++++++++++++------- databases/postgresql73-server/Makefile | 39 +++-- databases/postgresql73-server/distinfo | 2 +- databases/postgresql73-server/files/pgsql.sh.tmpl | 6 +- databases/postgresql73-server/pkg-plist | 178 ++++++++++++++------- databases/postgresql73/Makefile | 39 +++-- databases/postgresql73/distinfo | 2 +- databases/postgresql73/files/pgsql.sh.tmpl | 6 +- databases/postgresql73/pkg-plist | 178 ++++++++++++++------- databases/postgresql74-server/Makefile | 39 +++-- databases/postgresql74-server/distinfo | 2 +- databases/postgresql74-server/files/pgsql.sh.tmpl | 6 +- databases/postgresql74-server/pkg-plist | 178 ++++++++++++++------- databases/postgresql80-server/Makefile | 39 +++-- databases/postgresql80-server/distinfo | 2 +- databases/postgresql80-server/files/pgsql.sh.tmpl | 6 +- databases/postgresql80-server/pkg-plist | 178 ++++++++++++++------- databases/postgresql81-server/Makefile | 39 +++-- databases/postgresql81-server/distinfo | 2 +- databases/postgresql81-server/files/pgsql.sh.tmpl | 6 +- databases/postgresql81-server/pkg-plist | 178 ++++++++++++++------- databases/postgresql82-server/Makefile | 39 +++-- databases/postgresql82-server/distinfo | 2 +- databases/postgresql82-server/files/pgsql.sh.tmpl | 6 +- databases/postgresql82-server/pkg-plist | 178 ++++++++++++++------- databases/postgresql83-server/Makefile | 39 +++-- databases/postgresql83-server/distinfo | 2 +- databases/postgresql83-server/files/pgsql.sh.tmpl | 6 +- databases/postgresql83-server/pkg-plist | 178 ++++++++++++++------- databases/postgresql84-server/Makefile | 39 +++-- databases/postgresql84-server/distinfo | 2 +- databases/postgresql84-server/files/pgsql.sh.tmpl | 6 +- databases/postgresql84-server/pkg-plist | 178 ++++++++++++++------- databases/postgresql90-server/Makefile | 39 +++-- databases/postgresql90-server/distinfo | 2 +- databases/postgresql90-server/files/pgsql.sh.tmpl | 6 +- databases/postgresql90-server/pkg-plist | 178 ++++++++++++++------- databases/postgresql91-server/Makefile | 39 +++-- databases/postgresql91-server/distinfo | 2 +- databases/postgresql91-server/files/pgsql.sh.tmpl | 6 +- databases/postgresql91-server/pkg-plist | 178 ++++++++++++++------- databases/postgresql92-server/Makefile | 39 +++-- databases/postgresql92-server/distinfo | 2 +- databases/postgresql92-server/files/pgsql.sh.tmpl | 6 +- databases/postgresql92-server/pkg-plist | 178 ++++++++++++++------- 56 files changed, 2072 insertions(+), 1078 deletions(-) (limited to 'databases') diff --git a/databases/postgresql-devel-server/Makefile b/databases/postgresql-devel-server/Makefile index 0cc83efe5fc4..476257fd2ee4 100644 --- a/databases/postgresql-devel-server/Makefile +++ b/databases/postgresql-devel-server/Makefile @@ -3,11 +3,13 @@ # Date created: April 2, 1997 # Whom: Marc G. Fournier # -# $Id: Makefile,v 1.22 1997/12/24 01:21:37 alex Exp $ +# $Id: Makefile,v 1.23 1998/03/22 16:45:18 andreas Exp $ -DISTNAME= postgresql-6.2.1 +PATCH_DEBUG= yes + +DISTNAME= postgresql-6.3.2 CATEGORIES= databases -MASTER_SITES= http://www.freebsd.org/~andreas/download/ +MASTER_SITES= ftp://ftp.postgresql.org/pub/ MAINTAINER= andreas@FreeBSD.ORG @@ -16,6 +18,7 @@ MAINTAINER= andreas@FreeBSD.ORG .if defined(USE_TCL) MAKE_ENV= USE_TCL=true TCL_INCDIR=${PREFIX}/include/tcl8.0 LIB_DEPENDS= tcl80\\.1\\.:${PORTSDIR}/lang/tcl80 +WITH_TCL= --with-tcl .endif NO_PACKAGE= "Requires pgsql uid" @@ -26,26 +29,28 @@ MAKEFILE= GNUmakefile 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]'` \ + --with-includes=/usr/local/include ${WITH_TCL} \ + --with-libraries=/usr/local/lib MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ - destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + destroyuser.1 ecpg.1 initdb.1 ipcclean.1 initlocation.1 \ + pg_dump.1 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 \ +MANL= abort.l alter_table.l alter_user.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_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 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 + create_function.l create_index.l create_language.l \ + create_operator.l create_rule.l create_sequence.l \ + create_table.l create_trigger.l create_type.l create_user.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_language.l drop_operator.l drop_rule.l drop_sequence.l \ + drop_table.l drop_trigger.l drop_type.l drop_user.l \ + drop_view.l end.l explain.l fetch.l grant.l insert.l listen.l \ + load.l lock.l move.l notify.l reset.l revoke.l \ + rollback.l select.l set.l show.l sql.l update.l vacuum.l MANPREFIX= ${PREFIX}/pgsql diff --git a/databases/postgresql-devel-server/distinfo b/databases/postgresql-devel-server/distinfo index 5d42f88c853a..dc42f89ecf8d 100644 --- a/databases/postgresql-devel-server/distinfo +++ b/databases/postgresql-devel-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-6.2.1.tar.gz) = bd606dcab6b09a3a3d276d88b504a1d3 +MD5 (postgresql-6.3.2.tar.gz) = 8902842461c9a42854ba9883bee56a4c diff --git a/databases/postgresql-devel-server/files/pgsql.sh.tmpl b/databases/postgresql-devel-server/files/pgsql.sh.tmpl index 9fd81e4ff367..ed6c54d18839 100644 --- a/databases/postgresql-devel-server/files/pgsql.sh.tmpl +++ b/databases/postgresql-devel-server/files/pgsql.sh.tmpl @@ -1,6 +1,6 @@ #!/bin/sh -# $Id: pgsql.sh.tmpl,v 1.2 1997/10/03 18:26:54 andreas Exp $ +# $Id: pgsql.sh.tmpl,v 1.3 1997/10/05 21:00:49 andreas Exp $ # pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) @@ -19,7 +19,7 @@ [ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib [ -x !!PREFIX!!/pgsql/bin/postmaster ] && { - su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster \ - -S -o -F > !!PREFIX!!/pgsql/errlog' + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster -i -S -o -F \ + -D!!PREFIX!!/pgsql/data > !!PREFIX!!/pgsql/errlog' echo -n ' pgsql' } diff --git a/databases/postgresql-devel-server/pkg-plist b/databases/postgresql-devel-server/pkg-plist index 985c0a47ac30..5e5936ec028e 100644 --- a/databases/postgresql-devel-server/pkg-plist +++ b/databases/postgresql-devel-server/pkg-plist @@ -5,7 +5,10 @@ pgsql/bin/createdb pgsql/bin/createuser pgsql/bin/destroydb pgsql/bin/destroyuser +pgsql/bin/ecpg pgsql/bin/initdb +pgsql/bin/initlocation +pgsql/bin/ipcclean pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id @@ -14,7 +17,6 @@ pgsql/bin/pg_version pgsql/bin/pgtclsh pgsql/bin/pgtksh pgsql/bin/postgres -pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -22,15 +24,17 @@ pgsql/data/base/template1/pg_aggregate pgsql/data/base/template1/pg_am 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_attrdef_adrelid_index pgsql/data/base/template1/pg_attribute +pgsql/data/base/template1/pg_attribute_attrelid_index +pgsql/data/base/template1/pg_attribute_relid_attnam_index +pgsql/data/base/template1/pg_attribute_relid_attnum_index pgsql/data/base/template1/pg_class -pgsql/data/base/template1/pg_classnameind -pgsql/data/base/template1/pg_classoidind +pgsql/data/base/template1/pg_class_oid_index +pgsql/data/base/template1/pg_class_relname_index +pgsql/data/base/template1/pg_description +pgsql/data/base/template1/pg_description_objoid_index pgsql/data/base/template1/pg_index pgsql/data/base/template1/pg_inheritproc pgsql/data/base/template1/pg_inherits @@ -42,35 +46,36 @@ pgsql/data/base/template1/pg_opclass pgsql/data/base/template1/pg_operator pgsql/data/base/template1/pg_parg 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_proc_oid_index +pgsql/data/base/template1/pg_proc_proname_index +pgsql/data/base/template1/pg_proc_prosrc_index pgsql/data/base/template1/pg_relcheck -pgsql/data/base/template1/pg_relcheckind +pgsql/data/base/template1/pg_relcheck_rcrelid_index 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_trigger_tgrelid_index pgsql/data/base/template1/pg_type -pgsql/data/base/template1/pg_typeidind -pgsql/data/base/template1/pg_typenameind +pgsql/data/base/template1/pg_type_oid_index +pgsql/data/base/template1/pg_type_typname_index +pgsql/data/base/template1/pg_user pgsql/data/base/template1/pg_version pgsql/data/pg_database -pgsql/data/pg_defaults -pgsql/data/pg_demon pgsql/data/pg_geqo.sample pgsql/data/pg_group pgsql/data/pg_hba.conf -pgsql/data/pg_hosts pgsql/data/pg_log -pgsql/data/pg_magic -pgsql/data/pg_server -pgsql/data/pg_time -pgsql/data/pg_user +pgsql/data/pg_pwd +pgsql/data/pg_shadow pgsql/data/pg_variable +pgsql/errlog pgsql/include/access/attnum.h pgsql/include/c.h +pgsql/include/commands/trigger.h pgsql/include/config.h +pgsql/include/ecpglib.h +pgsql/include/ecpgtype.h +pgsql/include/executor/spi.h pgsql/include/fmgr.h pgsql/include/lib/dllist.h pgsql/include/libpgtcl.h @@ -80,17 +85,20 @@ pgsql/include/libpq/pqcomm.h pgsql/include/os.h pgsql/include/postgres.h pgsql/include/postgres_ext.h +pgsql/include/sqlca.h pgsql/include/utils/elog.h pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source +pgsql/lib/global1.description +pgsql/lib/libecpg.a +pgsql/lib/libecpg.so.1.1 pgsql/lib/libpgtcl.a -pgsql/lib/libpgtcl.so pgsql/lib/libpgtcl.so.1.0 pgsql/lib/libpq.a -pgsql/lib/libpq.so -pgsql/lib/libpq.so.1.0 +pgsql/lib/libpq.so.1.1 pgsql/lib/local1_template1.bki.source +pgsql/lib/local1_template1.description pgsql/lib/pg_geqo.sample pgsql/lib/pg_hba.conf.sample pgsql/man/man1/cleardbdir.1.gz @@ -98,9 +106,10 @@ pgsql/man/man1/createdb.1.gz pgsql/man/man1/createuser.1.gz pgsql/man/man1/destroydb.1.gz pgsql/man/man1/destroyuser.1.gz +pgsql/man/man1/ecpg.1.gz pgsql/man/man1/initdb.1.gz +pgsql/man/man1/initlocation.1.gz 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 @@ -118,6 +127,7 @@ pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz pgsql/man/manl/abort.l.gz pgsql/man/manl/alter_table.l.gz +pgsql/man/manl/alter_user.l.gz pgsql/man/manl/begin.l.gz pgsql/man/manl/close.l.gz pgsql/man/manl/cluster.l.gz @@ -127,12 +137,14 @@ pgsql/man/manl/create_aggregate.l.gz pgsql/man/manl/create_database.l.gz pgsql/man/manl/create_function.l.gz pgsql/man/manl/create_index.l.gz +pgsql/man/manl/create_language.l.gz 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_user.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz pgsql/man/manl/declare.l.gz @@ -142,12 +154,14 @@ pgsql/man/manl/drop_aggregate.l.gz pgsql/man/manl/drop_database.l.gz pgsql/man/manl/drop_function.l.gz pgsql/man/manl/drop_index.l.gz +pgsql/man/manl/drop_language.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_user.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz pgsql/man/manl/explain.l.gz @@ -156,10 +170,9 @@ 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/lock.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 pgsql/man/manl/reset.l.gz pgsql/man/manl/revoke.l.gz pgsql/man/manl/rollback.l.gz @@ -171,51 +184,104 @@ pgsql/man/manl/update.l.gz pgsql/man/manl/vacuum.l.gz pgsql/post-install-notes share/doc/pgsql/FAQ -share/doc/pgsql/FAQ-Irix -share/doc/pgsql/FAQ-Linux +share/doc/pgsql/FAQ_FreeBSD +share/doc/pgsql/FAQ_Irix +share/doc/pgsql/FAQ_Linux +share/doc/pgsql/Makefile share/doc/pgsql/README.GEQO share/doc/pgsql/README.fsync +share/doc/pgsql/README.mb +share/doc/pgsql/README.mb.jp share/doc/pgsql/README.support share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO +share/doc/pgsql/admin.ps.gz +share/doc/pgsql/admin.tar.gz 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/postgres.tar.gz +share/doc/pgsql/programmer.ps.gz +share/doc/pgsql/programmer.tar.gz +share/doc/pgsql/src/Makefile +share/doc/pgsql/src/graphics/catalogs.gif +share/doc/pgsql/src/graphics/clientserver.ag +share/doc/pgsql/src/graphics/clientserver.gif +share/doc/pgsql/src/graphics/connections.ag +share/doc/pgsql/src/graphics/connections.gif +share/doc/pgsql/src/graphics/layout.ag +share/doc/pgsql/src/graphics/layout.gif +share/doc/pgsql/src/sgml/Makefile +share/doc/pgsql/src/sgml/admin.sgml +share/doc/pgsql/src/sgml/advanced.sgml +share/doc/pgsql/src/sgml/arch-dev.sgml +share/doc/pgsql/src/sgml/arch-pg.sgml +share/doc/pgsql/src/sgml/arch.sgml +share/doc/pgsql/src/sgml/array.sgml +share/doc/pgsql/src/sgml/biblio.sgml +share/doc/pgsql/src/sgml/compiler.sgml +share/doc/pgsql/src/sgml/contacts.sgml +share/doc/pgsql/src/sgml/datatype.sgml +share/doc/pgsql/src/sgml/dfunc.sgml +share/doc/pgsql/src/sgml/docguide.sgml +share/doc/pgsql/src/sgml/ecpg.sgml +share/doc/pgsql/src/sgml/environ.sgml +share/doc/pgsql/src/sgml/extend.sgml +share/doc/pgsql/src/sgml/func-ref.sgml +share/doc/pgsql/src/sgml/geqo.sgml +share/doc/pgsql/src/sgml/gist.sgml +share/doc/pgsql/src/sgml/inherit.sgml +share/doc/pgsql/src/sgml/install.sgml +share/doc/pgsql/src/sgml/intro-pg.sgml +share/doc/pgsql/src/sgml/intro.sgml +share/doc/pgsql/src/sgml/jdbc.sgml +share/doc/pgsql/src/sgml/libpgtcl.sgml +share/doc/pgsql/src/sgml/libpq.sgml +share/doc/pgsql/src/sgml/lobj.sgml +share/doc/pgsql/src/sgml/manage.sgml +share/doc/pgsql/src/sgml/odbc.sgml +share/doc/pgsql/src/sgml/pgaccess.sgml +share/doc/pgsql/src/sgml/ports.sgml +share/doc/pgsql/src/sgml/postgres.sgml +share/doc/pgsql/src/sgml/programmer.sgml +share/doc/pgsql/src/sgml/protocol.sgml +share/doc/pgsql/src/sgml/psql.sgml +share/doc/pgsql/src/sgml/query-ug.sgml +share/doc/pgsql/src/sgml/query.sgml +share/doc/pgsql/src/sgml/recovery.sgml +share/doc/pgsql/src/sgml/regress.sgml +share/doc/pgsql/src/sgml/release.sgml +share/doc/pgsql/src/sgml/rules.sgml +share/doc/pgsql/src/sgml/spi.sgml +share/doc/pgsql/src/sgml/start-ag.sgml +share/doc/pgsql/src/sgml/start.sgml +share/doc/pgsql/src/sgml/storage.sgml +share/doc/pgsql/src/sgml/trigger.sgml +share/doc/pgsql/src/sgml/tutorial.sgml +share/doc/pgsql/src/sgml/user.sgml +share/doc/pgsql/src/sgml/xaggr.sgml +share/doc/pgsql/src/sgml/xfunc.sgml +share/doc/pgsql/src/sgml/xindex.sgml +share/doc/pgsql/src/sgml/xoper.sgml +share/doc/pgsql/src/sgml/xtypes.sgml +share/doc/pgsql/tutorial.ps.gz +share/doc/pgsql/tutorial.tar.gz +share/doc/pgsql/user.ps.gz +share/doc/pgsql/user.tar.gz share/doc/pgsql/userguide.ps -@dirrm share/doc/pgsql/manual +@dirrm share/doc/pgsql/src/graphics +@dirrm share/doc/pgsql/src/sgml +@dirrm share/doc/pgsql/src @dirrm share/doc/pgsql @dirrm pgsql/bin @dirrm pgsql/data/base/template1 @dirrm pgsql/data/base @dirrm pgsql/data @dirrm pgsql/include/access +@dirrm pgsql/include/commands +@dirrm pgsql/include/executor @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq -@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port/bsd @dirrm pgsql/include/port @dirrm pgsql/include/utils @dirrm pgsql/include diff --git a/databases/postgresql-devel/Makefile b/databases/postgresql-devel/Makefile index 0cc83efe5fc4..476257fd2ee4 100644 --- a/databases/postgresql-devel/Makefile +++ b/databases/postgresql-devel/Makefile @@ -3,11 +3,13 @@ # Date created: April 2, 1997 # Whom: Marc G. Fournier # -# $Id: Makefile,v 1.22 1997/12/24 01:21:37 alex Exp $ +# $Id: Makefile,v 1.23 1998/03/22 16:45:18 andreas Exp $ -DISTNAME= postgresql-6.2.1 +PATCH_DEBUG= yes + +DISTNAME= postgresql-6.3.2 CATEGORIES= databases -MASTER_SITES= http://www.freebsd.org/~andreas/download/ +MASTER_SITES= ftp://ftp.postgresql.org/pub/ MAINTAINER= andreas@FreeBSD.ORG @@ -16,6 +18,7 @@ MAINTAINER= andreas@FreeBSD.ORG .if defined(USE_TCL) MAKE_ENV= USE_TCL=true TCL_INCDIR=${PREFIX}/include/tcl8.0 LIB_DEPENDS= tcl80\\.1\\.:${PORTSDIR}/lang/tcl80 +WITH_TCL= --with-tcl .endif NO_PACKAGE= "Requires pgsql uid" @@ -26,26 +29,28 @@ MAKEFILE= GNUmakefile 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]'` \ + --with-includes=/usr/local/include ${WITH_TCL} \ + --with-libraries=/usr/local/lib MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ - destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + destroyuser.1 ecpg.1 initdb.1 ipcclean.1 initlocation.1 \ + pg_dump.1 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 \ +MANL= abort.l alter_table.l alter_user.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_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 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 + create_function.l create_index.l create_language.l \ + create_operator.l create_rule.l create_sequence.l \ + create_table.l create_trigger.l create_type.l create_user.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_language.l drop_operator.l drop_rule.l drop_sequence.l \ + drop_table.l drop_trigger.l drop_type.l drop_user.l \ + drop_view.l end.l explain.l fetch.l grant.l insert.l listen.l \ + load.l lock.l move.l notify.l reset.l revoke.l \ + rollback.l select.l set.l show.l sql.l update.l vacuum.l MANPREFIX= ${PREFIX}/pgsql diff --git a/databases/postgresql-devel/distinfo b/databases/postgresql-devel/distinfo index 5d42f88c853a..dc42f89ecf8d 100644 --- a/databases/postgresql-devel/distinfo +++ b/databases/postgresql-devel/distinfo @@ -1 +1 @@ -MD5 (postgresql-6.2.1.tar.gz) = bd606dcab6b09a3a3d276d88b504a1d3 +MD5 (postgresql-6.3.2.tar.gz) = 8902842461c9a42854ba9883bee56a4c diff --git a/databases/postgresql-devel/files/pgsql.sh.tmpl b/databases/postgresql-devel/files/pgsql.sh.tmpl index 9fd81e4ff367..ed6c54d18839 100644 --- a/databases/postgresql-devel/files/pgsql.sh.tmpl +++ b/databases/postgresql-devel/files/pgsql.sh.tmpl @@ -1,6 +1,6 @@ #!/bin/sh -# $Id: pgsql.sh.tmpl,v 1.2 1997/10/03 18:26:54 andreas Exp $ +# $Id: pgsql.sh.tmpl,v 1.3 1997/10/05 21:00:49 andreas Exp $ # pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) @@ -19,7 +19,7 @@ [ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib [ -x !!PREFIX!!/pgsql/bin/postmaster ] && { - su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster \ - -S -o -F > !!PREFIX!!/pgsql/errlog' + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster -i -S -o -F \ + -D!!PREFIX!!/pgsql/data > !!PREFIX!!/pgsql/errlog' echo -n ' pgsql' } diff --git a/databases/postgresql-devel/pkg-plist b/databases/postgresql-devel/pkg-plist index 985c0a47ac30..5e5936ec028e 100644 --- a/databases/postgresql-devel/pkg-plist +++ b/databases/postgresql-devel/pkg-plist @@ -5,7 +5,10 @@ pgsql/bin/createdb pgsql/bin/createuser pgsql/bin/destroydb pgsql/bin/destroyuser +pgsql/bin/ecpg pgsql/bin/initdb +pgsql/bin/initlocation +pgsql/bin/ipcclean pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id @@ -14,7 +17,6 @@ pgsql/bin/pg_version pgsql/bin/pgtclsh pgsql/bin/pgtksh pgsql/bin/postgres -pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -22,15 +24,17 @@ pgsql/data/base/template1/pg_aggregate pgsql/data/base/template1/pg_am 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_attrdef_adrelid_index pgsql/data/base/template1/pg_attribute +pgsql/data/base/template1/pg_attribute_attrelid_index +pgsql/data/base/template1/pg_attribute_relid_attnam_index +pgsql/data/base/template1/pg_attribute_relid_attnum_index pgsql/data/base/template1/pg_class -pgsql/data/base/template1/pg_classnameind -pgsql/data/base/template1/pg_classoidind +pgsql/data/base/template1/pg_class_oid_index +pgsql/data/base/template1/pg_class_relname_index +pgsql/data/base/template1/pg_description +pgsql/data/base/template1/pg_description_objoid_index pgsql/data/base/template1/pg_index pgsql/data/base/template1/pg_inheritproc pgsql/data/base/template1/pg_inherits @@ -42,35 +46,36 @@ pgsql/data/base/template1/pg_opclass pgsql/data/base/template1/pg_operator pgsql/data/base/template1/pg_parg 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_proc_oid_index +pgsql/data/base/template1/pg_proc_proname_index +pgsql/data/base/template1/pg_proc_prosrc_index pgsql/data/base/template1/pg_relcheck -pgsql/data/base/template1/pg_relcheckind +pgsql/data/base/template1/pg_relcheck_rcrelid_index 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_trigger_tgrelid_index pgsql/data/base/template1/pg_type -pgsql/data/base/template1/pg_typeidind -pgsql/data/base/template1/pg_typenameind +pgsql/data/base/template1/pg_type_oid_index +pgsql/data/base/template1/pg_type_typname_index +pgsql/data/base/template1/pg_user pgsql/data/base/template1/pg_version pgsql/data/pg_database -pgsql/data/pg_defaults -pgsql/data/pg_demon pgsql/data/pg_geqo.sample pgsql/data/pg_group pgsql/data/pg_hba.conf -pgsql/data/pg_hosts pgsql/data/pg_log -pgsql/data/pg_magic -pgsql/data/pg_server -pgsql/data/pg_time -pgsql/data/pg_user +pgsql/data/pg_pwd +pgsql/data/pg_shadow pgsql/data/pg_variable +pgsql/errlog pgsql/include/access/attnum.h pgsql/include/c.h +pgsql/include/commands/trigger.h pgsql/include/config.h +pgsql/include/ecpglib.h +pgsql/include/ecpgtype.h +pgsql/include/executor/spi.h pgsql/include/fmgr.h pgsql/include/lib/dllist.h pgsql/include/libpgtcl.h @@ -80,17 +85,20 @@ pgsql/include/libpq/pqcomm.h pgsql/include/os.h pgsql/include/postgres.h pgsql/include/postgres_ext.h +pgsql/include/sqlca.h pgsql/include/utils/elog.h pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source +pgsql/lib/global1.description +pgsql/lib/libecpg.a +pgsql/lib/libecpg.so.1.1 pgsql/lib/libpgtcl.a -pgsql/lib/libpgtcl.so pgsql/lib/libpgtcl.so.1.0 pgsql/lib/libpq.a -pgsql/lib/libpq.so -pgsql/lib/libpq.so.1.0 +pgsql/lib/libpq.so.1.1 pgsql/lib/local1_template1.bki.source +pgsql/lib/local1_template1.description pgsql/lib/pg_geqo.sample pgsql/lib/pg_hba.conf.sample pgsql/man/man1/cleardbdir.1.gz @@ -98,9 +106,10 @@ pgsql/man/man1/createdb.1.gz pgsql/man/man1/createuser.1.gz pgsql/man/man1/destroydb.1.gz pgsql/man/man1/destroyuser.1.gz +pgsql/man/man1/ecpg.1.gz pgsql/man/man1/initdb.1.gz +pgsql/man/man1/initlocation.1.gz 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 @@ -118,6 +127,7 @@ pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz pgsql/man/manl/abort.l.gz pgsql/man/manl/alter_table.l.gz +pgsql/man/manl/alter_user.l.gz pgsql/man/manl/begin.l.gz pgsql/man/manl/close.l.gz pgsql/man/manl/cluster.l.gz @@ -127,12 +137,14 @@ pgsql/man/manl/create_aggregate.l.gz pgsql/man/manl/create_database.l.gz pgsql/man/manl/create_function.l.gz pgsql/man/manl/create_index.l.gz +pgsql/man/manl/create_language.l.gz 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_user.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz pgsql/man/manl/declare.l.gz @@ -142,12 +154,14 @@ pgsql/man/manl/drop_aggregate.l.gz pgsql/man/manl/drop_database.l.gz pgsql/man/manl/drop_function.l.gz pgsql/man/manl/drop_index.l.gz +pgsql/man/manl/drop_language.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_user.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz pgsql/man/manl/explain.l.gz @@ -156,10 +170,9 @@ 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/lock.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 pgsql/man/manl/reset.l.gz pgsql/man/manl/revoke.l.gz pgsql/man/manl/rollback.l.gz @@ -171,51 +184,104 @@ pgsql/man/manl/update.l.gz pgsql/man/manl/vacuum.l.gz pgsql/post-install-notes share/doc/pgsql/FAQ -share/doc/pgsql/FAQ-Irix -share/doc/pgsql/FAQ-Linux +share/doc/pgsql/FAQ_FreeBSD +share/doc/pgsql/FAQ_Irix +share/doc/pgsql/FAQ_Linux +share/doc/pgsql/Makefile share/doc/pgsql/README.GEQO share/doc/pgsql/README.fsync +share/doc/pgsql/README.mb +share/doc/pgsql/README.mb.jp share/doc/pgsql/README.support share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO +share/doc/pgsql/admin.ps.gz +share/doc/pgsql/admin.tar.gz 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/postgres.tar.gz +share/doc/pgsql/programmer.ps.gz +share/doc/pgsql/programmer.tar.gz +share/doc/pgsql/src/Makefile +share/doc/pgsql/src/graphics/catalogs.gif +share/doc/pgsql/src/graphics/clientserver.ag +share/doc/pgsql/src/graphics/clientserver.gif +share/doc/pgsql/src/graphics/connections.ag +share/doc/pgsql/src/graphics/connections.gif +share/doc/pgsql/src/graphics/layout.ag +share/doc/pgsql/src/graphics/layout.gif +share/doc/pgsql/src/sgml/Makefile +share/doc/pgsql/src/sgml/admin.sgml +share/doc/pgsql/src/sgml/advanced.sgml +share/doc/pgsql/src/sgml/arch-dev.sgml +share/doc/pgsql/src/sgml/arch-pg.sgml +share/doc/pgsql/src/sgml/arch.sgml +share/doc/pgsql/src/sgml/array.sgml +share/doc/pgsql/src/sgml/biblio.sgml +share/doc/pgsql/src/sgml/compiler.sgml +share/doc/pgsql/src/sgml/contacts.sgml +share/doc/pgsql/src/sgml/datatype.sgml +share/doc/pgsql/src/sgml/dfunc.sgml +share/doc/pgsql/src/sgml/docguide.sgml +share/doc/pgsql/src/sgml/ecpg.sgml +share/doc/pgsql/src/sgml/environ.sgml +share/doc/pgsql/src/sgml/extend.sgml +share/doc/pgsql/src/sgml/func-ref.sgml +share/doc/pgsql/src/sgml/geqo.sgml +share/doc/pgsql/src/sgml/gist.sgml +share/doc/pgsql/src/sgml/inherit.sgml +share/doc/pgsql/src/sgml/install.sgml +share/doc/pgsql/src/sgml/intro-pg.sgml +share/doc/pgsql/src/sgml/intro.sgml +share/doc/pgsql/src/sgml/jdbc.sgml +share/doc/pgsql/src/sgml/libpgtcl.sgml +share/doc/pgsql/src/sgml/libpq.sgml +share/doc/pgsql/src/sgml/lobj.sgml +share/doc/pgsql/src/sgml/manage.sgml +share/doc/pgsql/src/sgml/odbc.sgml +share/doc/pgsql/src/sgml/pgaccess.sgml +share/doc/pgsql/src/sgml/ports.sgml +share/doc/pgsql/src/sgml/postgres.sgml +share/doc/pgsql/src/sgml/programmer.sgml +share/doc/pgsql/src/sgml/protocol.sgml +share/doc/pgsql/src/sgml/psql.sgml +share/doc/pgsql/src/sgml/query-ug.sgml +share/doc/pgsql/src/sgml/query.sgml +share/doc/pgsql/src/sgml/recovery.sgml +share/doc/pgsql/src/sgml/regress.sgml +share/doc/pgsql/src/sgml/release.sgml +share/doc/pgsql/src/sgml/rules.sgml +share/doc/pgsql/src/sgml/spi.sgml +share/doc/pgsql/src/sgml/start-ag.sgml +share/doc/pgsql/src/sgml/start.sgml +share/doc/pgsql/src/sgml/storage.sgml +share/doc/pgsql/src/sgml/trigger.sgml +share/doc/pgsql/src/sgml/tutorial.sgml +share/doc/pgsql/src/sgml/user.sgml +share/doc/pgsql/src/sgml/xaggr.sgml +share/doc/pgsql/src/sgml/xfunc.sgml +share/doc/pgsql/src/sgml/xindex.sgml +share/doc/pgsql/src/sgml/xoper.sgml +share/doc/pgsql/src/sgml/xtypes.sgml +share/doc/pgsql/tutorial.ps.gz +share/doc/pgsql/tutorial.tar.gz +share/doc/pgsql/user.ps.gz +share/doc/pgsql/user.tar.gz share/doc/pgsql/userguide.ps -@dirrm share/doc/pgsql/manual +@dirrm share/doc/pgsql/src/graphics +@dirrm share/doc/pgsql/src/sgml +@dirrm share/doc/pgsql/src @dirrm share/doc/pgsql @dirrm pgsql/bin @dirrm pgsql/data/base/template1 @dirrm pgsql/data/base @dirrm pgsql/data @dirrm pgsql/include/access +@dirrm pgsql/include/commands +@dirrm pgsql/include/executor @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq -@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port/bsd @dirrm pgsql/include/port @dirrm pgsql/include/utils @dirrm pgsql/include diff --git a/databases/postgresql7/Makefile b/databases/postgresql7/Makefile index 0cc83efe5fc4..476257fd2ee4 100644 --- a/databases/postgresql7/Makefile +++ b/databases/postgresql7/Makefile @@ -3,11 +3,13 @@ # Date created: April 2, 1997 # Whom: Marc G. Fournier # -# $Id: Makefile,v 1.22 1997/12/24 01:21:37 alex Exp $ +# $Id: Makefile,v 1.23 1998/03/22 16:45:18 andreas Exp $ -DISTNAME= postgresql-6.2.1 +PATCH_DEBUG= yes + +DISTNAME= postgresql-6.3.2 CATEGORIES= databases -MASTER_SITES= http://www.freebsd.org/~andreas/download/ +MASTER_SITES= ftp://ftp.postgresql.org/pub/ MAINTAINER= andreas@FreeBSD.ORG @@ -16,6 +18,7 @@ MAINTAINER= andreas@FreeBSD.ORG .if defined(USE_TCL) MAKE_ENV= USE_TCL=true TCL_INCDIR=${PREFIX}/include/tcl8.0 LIB_DEPENDS= tcl80\\.1\\.:${PORTSDIR}/lang/tcl80 +WITH_TCL= --with-tcl .endif NO_PACKAGE= "Requires pgsql uid" @@ -26,26 +29,28 @@ MAKEFILE= GNUmakefile 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]'` \ + --with-includes=/usr/local/include ${WITH_TCL} \ + --with-libraries=/usr/local/lib MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ - destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + destroyuser.1 ecpg.1 initdb.1 ipcclean.1 initlocation.1 \ + pg_dump.1 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 \ +MANL= abort.l alter_table.l alter_user.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_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 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 + create_function.l create_index.l create_language.l \ + create_operator.l create_rule.l create_sequence.l \ + create_table.l create_trigger.l create_type.l create_user.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_language.l drop_operator.l drop_rule.l drop_sequence.l \ + drop_table.l drop_trigger.l drop_type.l drop_user.l \ + drop_view.l end.l explain.l fetch.l grant.l insert.l listen.l \ + load.l lock.l move.l notify.l reset.l revoke.l \ + rollback.l select.l set.l show.l sql.l update.l vacuum.l MANPREFIX= ${PREFIX}/pgsql diff --git a/databases/postgresql7/distinfo b/databases/postgresql7/distinfo index 5d42f88c853a..dc42f89ecf8d 100644 --- a/databases/postgresql7/distinfo +++ b/databases/postgresql7/distinfo @@ -1 +1 @@ -MD5 (postgresql-6.2.1.tar.gz) = bd606dcab6b09a3a3d276d88b504a1d3 +MD5 (postgresql-6.3.2.tar.gz) = 8902842461c9a42854ba9883bee56a4c diff --git a/databases/postgresql7/files/pgsql.sh.tmpl b/databases/postgresql7/files/pgsql.sh.tmpl index 9fd81e4ff367..ed6c54d18839 100644 --- a/databases/postgresql7/files/pgsql.sh.tmpl +++ b/databases/postgresql7/files/pgsql.sh.tmpl @@ -1,6 +1,6 @@ #!/bin/sh -# $Id: pgsql.sh.tmpl,v 1.2 1997/10/03 18:26:54 andreas Exp $ +# $Id: pgsql.sh.tmpl,v 1.3 1997/10/05 21:00:49 andreas Exp $ # pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) @@ -19,7 +19,7 @@ [ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib [ -x !!PREFIX!!/pgsql/bin/postmaster ] && { - su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster \ - -S -o -F > !!PREFIX!!/pgsql/errlog' + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster -i -S -o -F \ + -D!!PREFIX!!/pgsql/data > !!PREFIX!!/pgsql/errlog' echo -n ' pgsql' } diff --git a/databases/postgresql7/pkg-plist b/databases/postgresql7/pkg-plist index 985c0a47ac30..5e5936ec028e 100644 --- a/databases/postgresql7/pkg-plist +++ b/databases/postgresql7/pkg-plist @@ -5,7 +5,10 @@ pgsql/bin/createdb pgsql/bin/createuser pgsql/bin/destroydb pgsql/bin/destroyuser +pgsql/bin/ecpg pgsql/bin/initdb +pgsql/bin/initlocation +pgsql/bin/ipcclean pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id @@ -14,7 +17,6 @@ pgsql/bin/pg_version pgsql/bin/pgtclsh pgsql/bin/pgtksh pgsql/bin/postgres -pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -22,15 +24,17 @@ pgsql/data/base/template1/pg_aggregate pgsql/data/base/template1/pg_am 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_attrdef_adrelid_index pgsql/data/base/template1/pg_attribute +pgsql/data/base/template1/pg_attribute_attrelid_index +pgsql/data/base/template1/pg_attribute_relid_attnam_index +pgsql/data/base/template1/pg_attribute_relid_attnum_index pgsql/data/base/template1/pg_class -pgsql/data/base/template1/pg_classnameind -pgsql/data/base/template1/pg_classoidind +pgsql/data/base/template1/pg_class_oid_index +pgsql/data/base/template1/pg_class_relname_index +pgsql/data/base/template1/pg_description +pgsql/data/base/template1/pg_description_objoid_index pgsql/data/base/template1/pg_index pgsql/data/base/template1/pg_inheritproc pgsql/data/base/template1/pg_inherits @@ -42,35 +46,36 @@ pgsql/data/base/template1/pg_opclass pgsql/data/base/template1/pg_operator pgsql/data/base/template1/pg_parg 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_proc_oid_index +pgsql/data/base/template1/pg_proc_proname_index +pgsql/data/base/template1/pg_proc_prosrc_index pgsql/data/base/template1/pg_relcheck -pgsql/data/base/template1/pg_relcheckind +pgsql/data/base/template1/pg_relcheck_rcrelid_index 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_trigger_tgrelid_index pgsql/data/base/template1/pg_type -pgsql/data/base/template1/pg_typeidind -pgsql/data/base/template1/pg_typenameind +pgsql/data/base/template1/pg_type_oid_index +pgsql/data/base/template1/pg_type_typname_index +pgsql/data/base/template1/pg_user pgsql/data/base/template1/pg_version pgsql/data/pg_database -pgsql/data/pg_defaults -pgsql/data/pg_demon pgsql/data/pg_geqo.sample pgsql/data/pg_group pgsql/data/pg_hba.conf -pgsql/data/pg_hosts pgsql/data/pg_log -pgsql/data/pg_magic -pgsql/data/pg_server -pgsql/data/pg_time -pgsql/data/pg_user +pgsql/data/pg_pwd +pgsql/data/pg_shadow pgsql/data/pg_variable +pgsql/errlog pgsql/include/access/attnum.h pgsql/include/c.h +pgsql/include/commands/trigger.h pgsql/include/config.h +pgsql/include/ecpglib.h +pgsql/include/ecpgtype.h +pgsql/include/executor/spi.h pgsql/include/fmgr.h pgsql/include/lib/dllist.h pgsql/include/libpgtcl.h @@ -80,17 +85,20 @@ pgsql/include/libpq/pqcomm.h pgsql/include/os.h pgsql/include/postgres.h pgsql/include/postgres_ext.h +pgsql/include/sqlca.h pgsql/include/utils/elog.h pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source +pgsql/lib/global1.description +pgsql/lib/libecpg.a +pgsql/lib/libecpg.so.1.1 pgsql/lib/libpgtcl.a -pgsql/lib/libpgtcl.so pgsql/lib/libpgtcl.so.1.0 pgsql/lib/libpq.a -pgsql/lib/libpq.so -pgsql/lib/libpq.so.1.0 +pgsql/lib/libpq.so.1.1 pgsql/lib/local1_template1.bki.source +pgsql/lib/local1_template1.description pgsql/lib/pg_geqo.sample pgsql/lib/pg_hba.conf.sample pgsql/man/man1/cleardbdir.1.gz @@ -98,9 +106,10 @@ pgsql/man/man1/createdb.1.gz pgsql/man/man1/createuser.1.gz pgsql/man/man1/destroydb.1.gz pgsql/man/man1/destroyuser.1.gz +pgsql/man/man1/ecpg.1.gz pgsql/man/man1/initdb.1.gz +pgsql/man/man1/initlocation.1.gz 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 @@ -118,6 +127,7 @@ pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz pgsql/man/manl/abort.l.gz pgsql/man/manl/alter_table.l.gz +pgsql/man/manl/alter_user.l.gz pgsql/man/manl/begin.l.gz pgsql/man/manl/close.l.gz pgsql/man/manl/cluster.l.gz @@ -127,12 +137,14 @@ pgsql/man/manl/create_aggregate.l.gz pgsql/man/manl/create_database.l.gz pgsql/man/manl/create_function.l.gz pgsql/man/manl/create_index.l.gz +pgsql/man/manl/create_language.l.gz 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_user.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz pgsql/man/manl/declare.l.gz @@ -142,12 +154,14 @@ pgsql/man/manl/drop_aggregate.l.gz pgsql/man/manl/drop_database.l.gz pgsql/man/manl/drop_function.l.gz pgsql/man/manl/drop_index.l.gz +pgsql/man/manl/drop_language.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_user.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz pgsql/man/manl/explain.l.gz @@ -156,10 +170,9 @@ 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/lock.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 pgsql/man/manl/reset.l.gz pgsql/man/manl/revoke.l.gz pgsql/man/manl/rollback.l.gz @@ -171,51 +184,104 @@ pgsql/man/manl/update.l.gz pgsql/man/manl/vacuum.l.gz pgsql/post-install-notes share/doc/pgsql/FAQ -share/doc/pgsql/FAQ-Irix -share/doc/pgsql/FAQ-Linux +share/doc/pgsql/FAQ_FreeBSD +share/doc/pgsql/FAQ_Irix +share/doc/pgsql/FAQ_Linux +share/doc/pgsql/Makefile share/doc/pgsql/README.GEQO share/doc/pgsql/README.fsync +share/doc/pgsql/README.mb +share/doc/pgsql/README.mb.jp share/doc/pgsql/README.support share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO +share/doc/pgsql/admin.ps.gz +share/doc/pgsql/admin.tar.gz 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/postgres.tar.gz +share/doc/pgsql/programmer.ps.gz +share/doc/pgsql/programmer.tar.gz +share/doc/pgsql/src/Makefile +share/doc/pgsql/src/graphics/catalogs.gif +share/doc/pgsql/src/graphics/clientserver.ag +share/doc/pgsql/src/graphics/clientserver.gif +share/doc/pgsql/src/graphics/connections.ag +share/doc/pgsql/src/graphics/connections.gif +share/doc/pgsql/src/graphics/layout.ag +share/doc/pgsql/src/graphics/layout.gif +share/doc/pgsql/src/sgml/Makefile +share/doc/pgsql/src/sgml/admin.sgml +share/doc/pgsql/src/sgml/advanced.sgml +share/doc/pgsql/src/sgml/arch-dev.sgml +share/doc/pgsql/src/sgml/arch-pg.sgml +share/doc/pgsql/src/sgml/arch.sgml +share/doc/pgsql/src/sgml/array.sgml +share/doc/pgsql/src/sgml/biblio.sgml +share/doc/pgsql/src/sgml/compiler.sgml +share/doc/pgsql/src/sgml/contacts.sgml +share/doc/pgsql/src/sgml/datatype.sgml +share/doc/pgsql/src/sgml/dfunc.sgml +share/doc/pgsql/src/sgml/docguide.sgml +share/doc/pgsql/src/sgml/ecpg.sgml +share/doc/pgsql/src/sgml/environ.sgml +share/doc/pgsql/src/sgml/extend.sgml +share/doc/pgsql/src/sgml/func-ref.sgml +share/doc/pgsql/src/sgml/geqo.sgml +share/doc/pgsql/src/sgml/gist.sgml +share/doc/pgsql/src/sgml/inherit.sgml +share/doc/pgsql/src/sgml/install.sgml +share/doc/pgsql/src/sgml/intro-pg.sgml +share/doc/pgsql/src/sgml/intro.sgml +share/doc/pgsql/src/sgml/jdbc.sgml +share/doc/pgsql/src/sgml/libpgtcl.sgml +share/doc/pgsql/src/sgml/libpq.sgml +share/doc/pgsql/src/sgml/lobj.sgml +share/doc/pgsql/src/sgml/manage.sgml +share/doc/pgsql/src/sgml/odbc.sgml +share/doc/pgsql/src/sgml/pgaccess.sgml +share/doc/pgsql/src/sgml/ports.sgml +share/doc/pgsql/src/sgml/postgres.sgml +share/doc/pgsql/src/sgml/programmer.sgml +share/doc/pgsql/src/sgml/protocol.sgml +share/doc/pgsql/src/sgml/psql.sgml +share/doc/pgsql/src/sgml/query-ug.sgml +share/doc/pgsql/src/sgml/query.sgml +share/doc/pgsql/src/sgml/recovery.sgml +share/doc/pgsql/src/sgml/regress.sgml +share/doc/pgsql/src/sgml/release.sgml +share/doc/pgsql/src/sgml/rules.sgml +share/doc/pgsql/src/sgml/spi.sgml +share/doc/pgsql/src/sgml/start-ag.sgml +share/doc/pgsql/src/sgml/start.sgml +share/doc/pgsql/src/sgml/storage.sgml +share/doc/pgsql/src/sgml/trigger.sgml +share/doc/pgsql/src/sgml/tutorial.sgml +share/doc/pgsql/src/sgml/user.sgml +share/doc/pgsql/src/sgml/xaggr.sgml +share/doc/pgsql/src/sgml/xfunc.sgml +share/doc/pgsql/src/sgml/xindex.sgml +share/doc/pgsql/src/sgml/xoper.sgml +share/doc/pgsql/src/sgml/xtypes.sgml +share/doc/pgsql/tutorial.ps.gz +share/doc/pgsql/tutorial.tar.gz +share/doc/pgsql/user.ps.gz +share/doc/pgsql/user.tar.gz share/doc/pgsql/userguide.ps -@dirrm share/doc/pgsql/manual +@dirrm share/doc/pgsql/src/graphics +@dirrm share/doc/pgsql/src/sgml +@dirrm share/doc/pgsql/src @dirrm share/doc/pgsql @dirrm pgsql/bin @dirrm pgsql/data/base/template1 @dirrm pgsql/data/base @dirrm pgsql/data @dirrm pgsql/include/access +@dirrm pgsql/include/commands +@dirrm pgsql/include/executor @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq -@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port/bsd @dirrm pgsql/include/port @dirrm pgsql/include/utils @dirrm pgsql/include diff --git a/databases/postgresql73-server/Makefile b/databases/postgresql73-server/Makefile index 0cc83efe5fc4..476257fd2ee4 100644 --- a/databases/postgresql73-server/Makefile +++ b/databases/postgresql73-server/Makefile @@ -3,11 +3,13 @@ # Date created: April 2, 1997 # Whom: Marc G. Fournier # -# $Id: Makefile,v 1.22 1997/12/24 01:21:37 alex Exp $ +# $Id: Makefile,v 1.23 1998/03/22 16:45:18 andreas Exp $ -DISTNAME= postgresql-6.2.1 +PATCH_DEBUG= yes + +DISTNAME= postgresql-6.3.2 CATEGORIES= databases -MASTER_SITES= http://www.freebsd.org/~andreas/download/ +MASTER_SITES= ftp://ftp.postgresql.org/pub/ MAINTAINER= andreas@FreeBSD.ORG @@ -16,6 +18,7 @@ MAINTAINER= andreas@FreeBSD.ORG .if defined(USE_TCL) MAKE_ENV= USE_TCL=true TCL_INCDIR=${PREFIX}/include/tcl8.0 LIB_DEPENDS= tcl80\\.1\\.:${PORTSDIR}/lang/tcl80 +WITH_TCL= --with-tcl .endif NO_PACKAGE= "Requires pgsql uid" @@ -26,26 +29,28 @@ MAKEFILE= GNUmakefile 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]'` \ + --with-includes=/usr/local/include ${WITH_TCL} \ + --with-libraries=/usr/local/lib MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ - destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + destroyuser.1 ecpg.1 initdb.1 ipcclean.1 initlocation.1 \ + pg_dump.1 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 \ +MANL= abort.l alter_table.l alter_user.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_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 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 + create_function.l create_index.l create_language.l \ + create_operator.l create_rule.l create_sequence.l \ + create_table.l create_trigger.l create_type.l create_user.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_language.l drop_operator.l drop_rule.l drop_sequence.l \ + drop_table.l drop_trigger.l drop_type.l drop_user.l \ + drop_view.l end.l explain.l fetch.l grant.l insert.l listen.l \ + load.l lock.l move.l notify.l reset.l revoke.l \ + rollback.l select.l set.l show.l sql.l update.l vacuum.l MANPREFIX= ${PREFIX}/pgsql diff --git a/databases/postgresql73-server/distinfo b/databases/postgresql73-server/distinfo index 5d42f88c853a..dc42f89ecf8d 100644 --- a/databases/postgresql73-server/distinfo +++ b/databases/postgresql73-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-6.2.1.tar.gz) = bd606dcab6b09a3a3d276d88b504a1d3 +MD5 (postgresql-6.3.2.tar.gz) = 8902842461c9a42854ba9883bee56a4c diff --git a/databases/postgresql73-server/files/pgsql.sh.tmpl b/databases/postgresql73-server/files/pgsql.sh.tmpl index 9fd81e4ff367..ed6c54d18839 100644 --- a/databases/postgresql73-server/files/pgsql.sh.tmpl +++ b/databases/postgresql73-server/files/pgsql.sh.tmpl @@ -1,6 +1,6 @@ #!/bin/sh -# $Id: pgsql.sh.tmpl,v 1.2 1997/10/03 18:26:54 andreas Exp $ +# $Id: pgsql.sh.tmpl,v 1.3 1997/10/05 21:00:49 andreas Exp $ # pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) @@ -19,7 +19,7 @@ [ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib [ -x !!PREFIX!!/pgsql/bin/postmaster ] && { - su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster \ - -S -o -F > !!PREFIX!!/pgsql/errlog' + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster -i -S -o -F \ + -D!!PREFIX!!/pgsql/data > !!PREFIX!!/pgsql/errlog' echo -n ' pgsql' } diff --git a/databases/postgresql73-server/pkg-plist b/databases/postgresql73-server/pkg-plist index 985c0a47ac30..5e5936ec028e 100644 --- a/databases/postgresql73-server/pkg-plist +++ b/databases/postgresql73-server/pkg-plist @@ -5,7 +5,10 @@ pgsql/bin/createdb pgsql/bin/createuser pgsql/bin/destroydb pgsql/bin/destroyuser +pgsql/bin/ecpg pgsql/bin/initdb +pgsql/bin/initlocation +pgsql/bin/ipcclean pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id @@ -14,7 +17,6 @@ pgsql/bin/pg_version pgsql/bin/pgtclsh pgsql/bin/pgtksh pgsql/bin/postgres -pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -22,15 +24,17 @@ pgsql/data/base/template1/pg_aggregate pgsql/data/base/template1/pg_am 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_attrdef_adrelid_index pgsql/data/base/template1/pg_attribute +pgsql/data/base/template1/pg_attribute_attrelid_index +pgsql/data/base/template1/pg_attribute_relid_attnam_index +pgsql/data/base/template1/pg_attribute_relid_attnum_index pgsql/data/base/template1/pg_class -pgsql/data/base/template1/pg_classnameind -pgsql/data/base/template1/pg_classoidind +pgsql/data/base/template1/pg_class_oid_index +pgsql/data/base/template1/pg_class_relname_index +pgsql/data/base/template1/pg_description +pgsql/data/base/template1/pg_description_objoid_index pgsql/data/base/template1/pg_index pgsql/data/base/template1/pg_inheritproc pgsql/data/base/template1/pg_inherits @@ -42,35 +46,36 @@ pgsql/data/base/template1/pg_opclass pgsql/data/base/template1/pg_operator pgsql/data/base/template1/pg_parg 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_proc_oid_index +pgsql/data/base/template1/pg_proc_proname_index +pgsql/data/base/template1/pg_proc_prosrc_index pgsql/data/base/template1/pg_relcheck -pgsql/data/base/template1/pg_relcheckind +pgsql/data/base/template1/pg_relcheck_rcrelid_index 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_trigger_tgrelid_index pgsql/data/base/template1/pg_type -pgsql/data/base/template1/pg_typeidind -pgsql/data/base/template1/pg_typenameind +pgsql/data/base/template1/pg_type_oid_index +pgsql/data/base/template1/pg_type_typname_index +pgsql/data/base/template1/pg_user pgsql/data/base/template1/pg_version pgsql/data/pg_database -pgsql/data/pg_defaults -pgsql/data/pg_demon pgsql/data/pg_geqo.sample pgsql/data/pg_group pgsql/data/pg_hba.conf -pgsql/data/pg_hosts pgsql/data/pg_log -pgsql/data/pg_magic -pgsql/data/pg_server -pgsql/data/pg_time -pgsql/data/pg_user +pgsql/data/pg_pwd +pgsql/data/pg_shadow pgsql/data/pg_variable +pgsql/errlog pgsql/include/access/attnum.h pgsql/include/c.h +pgsql/include/commands/trigger.h pgsql/include/config.h +pgsql/include/ecpglib.h +pgsql/include/ecpgtype.h +pgsql/include/executor/spi.h pgsql/include/fmgr.h pgsql/include/lib/dllist.h pgsql/include/libpgtcl.h @@ -80,17 +85,20 @@ pgsql/include/libpq/pqcomm.h pgsql/include/os.h pgsql/include/postgres.h pgsql/include/postgres_ext.h +pgsql/include/sqlca.h pgsql/include/utils/elog.h pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source +pgsql/lib/global1.description +pgsql/lib/libecpg.a +pgsql/lib/libecpg.so.1.1 pgsql/lib/libpgtcl.a -pgsql/lib/libpgtcl.so pgsql/lib/libpgtcl.so.1.0 pgsql/lib/libpq.a -pgsql/lib/libpq.so -pgsql/lib/libpq.so.1.0 +pgsql/lib/libpq.so.1.1 pgsql/lib/local1_template1.bki.source +pgsql/lib/local1_template1.description pgsql/lib/pg_geqo.sample pgsql/lib/pg_hba.conf.sample pgsql/man/man1/cleardbdir.1.gz @@ -98,9 +106,10 @@ pgsql/man/man1/createdb.1.gz pgsql/man/man1/createuser.1.gz pgsql/man/man1/destroydb.1.gz pgsql/man/man1/destroyuser.1.gz +pgsql/man/man1/ecpg.1.gz pgsql/man/man1/initdb.1.gz +pgsql/man/man1/initlocation.1.gz 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 @@ -118,6 +127,7 @@ pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz pgsql/man/manl/abort.l.gz pgsql/man/manl/alter_table.l.gz +pgsql/man/manl/alter_user.l.gz pgsql/man/manl/begin.l.gz pgsql/man/manl/close.l.gz pgsql/man/manl/cluster.l.gz @@ -127,12 +137,14 @@ pgsql/man/manl/create_aggregate.l.gz pgsql/man/manl/create_database.l.gz pgsql/man/manl/create_function.l.gz pgsql/man/manl/create_index.l.gz +pgsql/man/manl/create_language.l.gz 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_user.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz pgsql/man/manl/declare.l.gz @@ -142,12 +154,14 @@ pgsql/man/manl/drop_aggregate.l.gz pgsql/man/manl/drop_database.l.gz pgsql/man/manl/drop_function.l.gz pgsql/man/manl/drop_index.l.gz +pgsql/man/manl/drop_language.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_user.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz pgsql/man/manl/explain.l.gz @@ -156,10 +170,9 @@ 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/lock.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 pgsql/man/manl/reset.l.gz pgsql/man/manl/revoke.l.gz pgsql/man/manl/rollback.l.gz @@ -171,51 +184,104 @@ pgsql/man/manl/update.l.gz pgsql/man/manl/vacuum.l.gz pgsql/post-install-notes share/doc/pgsql/FAQ -share/doc/pgsql/FAQ-Irix -share/doc/pgsql/FAQ-Linux +share/doc/pgsql/FAQ_FreeBSD +share/doc/pgsql/FAQ_Irix +share/doc/pgsql/FAQ_Linux +share/doc/pgsql/Makefile share/doc/pgsql/README.GEQO share/doc/pgsql/README.fsync +share/doc/pgsql/README.mb +share/doc/pgsql/README.mb.jp share/doc/pgsql/README.support share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO +share/doc/pgsql/admin.ps.gz +share/doc/pgsql/admin.tar.gz 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/postgres.tar.gz +share/doc/pgsql/programmer.ps.gz +share/doc/pgsql/programmer.tar.gz +share/doc/pgsql/src/Makefile +share/doc/pgsql/src/graphics/catalogs.gif +share/doc/pgsql/src/graphics/clientserver.ag +share/doc/pgsql/src/graphics/clientserver.gif +share/doc/pgsql/src/graphics/connections.ag +share/doc/pgsql/src/graphics/connections.gif +share/doc/pgsql/src/graphics/layout.ag +share/doc/pgsql/src/graphics/layout.gif +share/doc/pgsql/src/sgml/Makefile +share/doc/pgsql/src/sgml/admin.sgml +share/doc/pgsql/src/sgml/advanced.sgml +share/doc/pgsql/src/sgml/arch-dev.sgml +share/doc/pgsql/src/sgml/arch-pg.sgml +share/doc/pgsql/src/sgml/arch.sgml +share/doc/pgsql/src/sgml/array.sgml +share/doc/pgsql/src/sgml/biblio.sgml +share/doc/pgsql/src/sgml/compiler.sgml +share/doc/pgsql/src/sgml/contacts.sgml +share/doc/pgsql/src/sgml/datatype.sgml +share/doc/pgsql/src/sgml/dfunc.sgml +share/doc/pgsql/src/sgml/docguide.sgml +share/doc/pgsql/src/sgml/ecpg.sgml +share/doc/pgsql/src/sgml/environ.sgml +share/doc/pgsql/src/sgml/extend.sgml +share/doc/pgsql/src/sgml/func-ref.sgml +share/doc/pgsql/src/sgml/geqo.sgml +share/doc/pgsql/src/sgml/gist.sgml +share/doc/pgsql/src/sgml/inherit.sgml +share/doc/pgsql/src/sgml/install.sgml +share/doc/pgsql/src/sgml/intro-pg.sgml +share/doc/pgsql/src/sgml/intro.sgml +share/doc/pgsql/src/sgml/jdbc.sgml +share/doc/pgsql/src/sgml/libpgtcl.sgml +share/doc/pgsql/src/sgml/libpq.sgml +share/doc/pgsql/src/sgml/lobj.sgml +share/doc/pgsql/src/sgml/manage.sgml +share/doc/pgsql/src/sgml/odbc.sgml +share/doc/pgsql/src/sgml/pgaccess.sgml +share/doc/pgsql/src/sgml/ports.sgml +share/doc/pgsql/src/sgml/postgres.sgml +share/doc/pgsql/src/sgml/programmer.sgml +share/doc/pgsql/src/sgml/protocol.sgml +share/doc/pgsql/src/sgml/psql.sgml +share/doc/pgsql/src/sgml/query-ug.sgml +share/doc/pgsql/src/sgml/query.sgml +share/doc/pgsql/src/sgml/recovery.sgml +share/doc/pgsql/src/sgml/regress.sgml +share/doc/pgsql/src/sgml/release.sgml +share/doc/pgsql/src/sgml/rules.sgml +share/doc/pgsql/src/sgml/spi.sgml +share/doc/pgsql/src/sgml/start-ag.sgml +share/doc/pgsql/src/sgml/start.sgml +share/doc/pgsql/src/sgml/storage.sgml +share/doc/pgsql/src/sgml/trigger.sgml +share/doc/pgsql/src/sgml/tutorial.sgml +share/doc/pgsql/src/sgml/user.sgml +share/doc/pgsql/src/sgml/xaggr.sgml +share/doc/pgsql/src/sgml/xfunc.sgml +share/doc/pgsql/src/sgml/xindex.sgml +share/doc/pgsql/src/sgml/xoper.sgml +share/doc/pgsql/src/sgml/xtypes.sgml +share/doc/pgsql/tutorial.ps.gz +share/doc/pgsql/tutorial.tar.gz +share/doc/pgsql/user.ps.gz +share/doc/pgsql/user.tar.gz share/doc/pgsql/userguide.ps -@dirrm share/doc/pgsql/manual +@dirrm share/doc/pgsql/src/graphics +@dirrm share/doc/pgsql/src/sgml +@dirrm share/doc/pgsql/src @dirrm share/doc/pgsql @dirrm pgsql/bin @dirrm pgsql/data/base/template1 @dirrm pgsql/data/base @dirrm pgsql/data @dirrm pgsql/include/access +@dirrm pgsql/include/commands +@dirrm pgsql/include/executor @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq -@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port/bsd @dirrm pgsql/include/port @dirrm pgsql/include/utils @dirrm pgsql/include diff --git a/databases/postgresql73/Makefile b/databases/postgresql73/Makefile index 0cc83efe5fc4..476257fd2ee4 100644 --- a/databases/postgresql73/Makefile +++ b/databases/postgresql73/Makefile @@ -3,11 +3,13 @@ # Date created: April 2, 1997 # Whom: Marc G. Fournier # -# $Id: Makefile,v 1.22 1997/12/24 01:21:37 alex Exp $ +# $Id: Makefile,v 1.23 1998/03/22 16:45:18 andreas Exp $ -DISTNAME= postgresql-6.2.1 +PATCH_DEBUG= yes + +DISTNAME= postgresql-6.3.2 CATEGORIES= databases -MASTER_SITES= http://www.freebsd.org/~andreas/download/ +MASTER_SITES= ftp://ftp.postgresql.org/pub/ MAINTAINER= andreas@FreeBSD.ORG @@ -16,6 +18,7 @@ MAINTAINER= andreas@FreeBSD.ORG .if defined(USE_TCL) MAKE_ENV= USE_TCL=true TCL_INCDIR=${PREFIX}/include/tcl8.0 LIB_DEPENDS= tcl80\\.1\\.:${PORTSDIR}/lang/tcl80 +WITH_TCL= --with-tcl .endif NO_PACKAGE= "Requires pgsql uid" @@ -26,26 +29,28 @@ MAKEFILE= GNUmakefile 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]'` \ + --with-includes=/usr/local/include ${WITH_TCL} \ + --with-libraries=/usr/local/lib MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ - destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + destroyuser.1 ecpg.1 initdb.1 ipcclean.1 initlocation.1 \ + pg_dump.1 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 \ +MANL= abort.l alter_table.l alter_user.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_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 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 + create_function.l create_index.l create_language.l \ + create_operator.l create_rule.l create_sequence.l \ + create_table.l create_trigger.l create_type.l create_user.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_language.l drop_operator.l drop_rule.l drop_sequence.l \ + drop_table.l drop_trigger.l drop_type.l drop_user.l \ + drop_view.l end.l explain.l fetch.l grant.l insert.l listen.l \ + load.l lock.l move.l notify.l reset.l revoke.l \ + rollback.l select.l set.l show.l sql.l update.l vacuum.l MANPREFIX= ${PREFIX}/pgsql diff --git a/databases/postgresql73/distinfo b/databases/postgresql73/distinfo index 5d42f88c853a..dc42f89ecf8d 100644 --- a/databases/postgresql73/distinfo +++ b/databases/postgresql73/distinfo @@ -1 +1 @@ -MD5 (postgresql-6.2.1.tar.gz) = bd606dcab6b09a3a3d276d88b504a1d3 +MD5 (postgresql-6.3.2.tar.gz) = 8902842461c9a42854ba9883bee56a4c diff --git a/databases/postgresql73/files/pgsql.sh.tmpl b/databases/postgresql73/files/pgsql.sh.tmpl index 9fd81e4ff367..ed6c54d18839 100644 --- a/databases/postgresql73/files/pgsql.sh.tmpl +++ b/databases/postgresql73/files/pgsql.sh.tmpl @@ -1,6 +1,6 @@ #!/bin/sh -# $Id: pgsql.sh.tmpl,v 1.2 1997/10/03 18:26:54 andreas Exp $ +# $Id: pgsql.sh.tmpl,v 1.3 1997/10/05 21:00:49 andreas Exp $ # pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) @@ -19,7 +19,7 @@ [ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib [ -x !!PREFIX!!/pgsql/bin/postmaster ] && { - su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster \ - -S -o -F > !!PREFIX!!/pgsql/errlog' + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster -i -S -o -F \ + -D!!PREFIX!!/pgsql/data > !!PREFIX!!/pgsql/errlog' echo -n ' pgsql' } diff --git a/databases/postgresql73/pkg-plist b/databases/postgresql73/pkg-plist index 985c0a47ac30..5e5936ec028e 100644 --- a/databases/postgresql73/pkg-plist +++ b/databases/postgresql73/pkg-plist @@ -5,7 +5,10 @@ pgsql/bin/createdb pgsql/bin/createuser pgsql/bin/destroydb pgsql/bin/destroyuser +pgsql/bin/ecpg pgsql/bin/initdb +pgsql/bin/initlocation +pgsql/bin/ipcclean pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id @@ -14,7 +17,6 @@ pgsql/bin/pg_version pgsql/bin/pgtclsh pgsql/bin/pgtksh pgsql/bin/postgres -pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -22,15 +24,17 @@ pgsql/data/base/template1/pg_aggregate pgsql/data/base/template1/pg_am 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_attrdef_adrelid_index pgsql/data/base/template1/pg_attribute +pgsql/data/base/template1/pg_attribute_attrelid_index +pgsql/data/base/template1/pg_attribute_relid_attnam_index +pgsql/data/base/template1/pg_attribute_relid_attnum_index pgsql/data/base/template1/pg_class -pgsql/data/base/template1/pg_classnameind -pgsql/data/base/template1/pg_classoidind +pgsql/data/base/template1/pg_class_oid_index +pgsql/data/base/template1/pg_class_relname_index +pgsql/data/base/template1/pg_description +pgsql/data/base/template1/pg_description_objoid_index pgsql/data/base/template1/pg_index pgsql/data/base/template1/pg_inheritproc pgsql/data/base/template1/pg_inherits @@ -42,35 +46,36 @@ pgsql/data/base/template1/pg_opclass pgsql/data/base/template1/pg_operator pgsql/data/base/template1/pg_parg 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_proc_oid_index +pgsql/data/base/template1/pg_proc_proname_index +pgsql/data/base/template1/pg_proc_prosrc_index pgsql/data/base/template1/pg_relcheck -pgsql/data/base/template1/pg_relcheckind +pgsql/data/base/template1/pg_relcheck_rcrelid_index 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_trigger_tgrelid_index pgsql/data/base/template1/pg_type -pgsql/data/base/template1/pg_typeidind -pgsql/data/base/template1/pg_typenameind +pgsql/data/base/template1/pg_type_oid_index +pgsql/data/base/template1/pg_type_typname_index +pgsql/data/base/template1/pg_user pgsql/data/base/template1/pg_version pgsql/data/pg_database -pgsql/data/pg_defaults -pgsql/data/pg_demon pgsql/data/pg_geqo.sample pgsql/data/pg_group pgsql/data/pg_hba.conf -pgsql/data/pg_hosts pgsql/data/pg_log -pgsql/data/pg_magic -pgsql/data/pg_server -pgsql/data/pg_time -pgsql/data/pg_user +pgsql/data/pg_pwd +pgsql/data/pg_shadow pgsql/data/pg_variable +pgsql/errlog pgsql/include/access/attnum.h pgsql/include/c.h +pgsql/include/commands/trigger.h pgsql/include/config.h +pgsql/include/ecpglib.h +pgsql/include/ecpgtype.h +pgsql/include/executor/spi.h pgsql/include/fmgr.h pgsql/include/lib/dllist.h pgsql/include/libpgtcl.h @@ -80,17 +85,20 @@ pgsql/include/libpq/pqcomm.h pgsql/include/os.h pgsql/include/postgres.h pgsql/include/postgres_ext.h +pgsql/include/sqlca.h pgsql/include/utils/elog.h pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source +pgsql/lib/global1.description +pgsql/lib/libecpg.a +pgsql/lib/libecpg.so.1.1 pgsql/lib/libpgtcl.a -pgsql/lib/libpgtcl.so pgsql/lib/libpgtcl.so.1.0 pgsql/lib/libpq.a -pgsql/lib/libpq.so -pgsql/lib/libpq.so.1.0 +pgsql/lib/libpq.so.1.1 pgsql/lib/local1_template1.bki.source +pgsql/lib/local1_template1.description pgsql/lib/pg_geqo.sample pgsql/lib/pg_hba.conf.sample pgsql/man/man1/cleardbdir.1.gz @@ -98,9 +106,10 @@ pgsql/man/man1/createdb.1.gz pgsql/man/man1/createuser.1.gz pgsql/man/man1/destroydb.1.gz pgsql/man/man1/destroyuser.1.gz +pgsql/man/man1/ecpg.1.gz pgsql/man/man1/initdb.1.gz +pgsql/man/man1/initlocation.1.gz 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 @@ -118,6 +127,7 @@ pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz pgsql/man/manl/abort.l.gz pgsql/man/manl/alter_table.l.gz +pgsql/man/manl/alter_user.l.gz pgsql/man/manl/begin.l.gz pgsql/man/manl/close.l.gz pgsql/man/manl/cluster.l.gz @@ -127,12 +137,14 @@ pgsql/man/manl/create_aggregate.l.gz pgsql/man/manl/create_database.l.gz pgsql/man/manl/create_function.l.gz pgsql/man/manl/create_index.l.gz +pgsql/man/manl/create_language.l.gz 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_user.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz pgsql/man/manl/declare.l.gz @@ -142,12 +154,14 @@ pgsql/man/manl/drop_aggregate.l.gz pgsql/man/manl/drop_database.l.gz pgsql/man/manl/drop_function.l.gz pgsql/man/manl/drop_index.l.gz +pgsql/man/manl/drop_language.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_user.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz pgsql/man/manl/explain.l.gz @@ -156,10 +170,9 @@ 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/lock.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 pgsql/man/manl/reset.l.gz pgsql/man/manl/revoke.l.gz pgsql/man/manl/rollback.l.gz @@ -171,51 +184,104 @@ pgsql/man/manl/update.l.gz pgsql/man/manl/vacuum.l.gz pgsql/post-install-notes share/doc/pgsql/FAQ -share/doc/pgsql/FAQ-Irix -share/doc/pgsql/FAQ-Linux +share/doc/pgsql/FAQ_FreeBSD +share/doc/pgsql/FAQ_Irix +share/doc/pgsql/FAQ_Linux +share/doc/pgsql/Makefile share/doc/pgsql/README.GEQO share/doc/pgsql/README.fsync +share/doc/pgsql/README.mb +share/doc/pgsql/README.mb.jp share/doc/pgsql/README.support share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO +share/doc/pgsql/admin.ps.gz +share/doc/pgsql/admin.tar.gz 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/postgres.tar.gz +share/doc/pgsql/programmer.ps.gz +share/doc/pgsql/programmer.tar.gz +share/doc/pgsql/src/Makefile +share/doc/pgsql/src/graphics/catalogs.gif +share/doc/pgsql/src/graphics/clientserver.ag +share/doc/pgsql/src/graphics/clientserver.gif +share/doc/pgsql/src/graphics/connections.ag +share/doc/pgsql/src/graphics/connections.gif +share/doc/pgsql/src/graphics/layout.ag +share/doc/pgsql/src/graphics/layout.gif +share/doc/pgsql/src/sgml/Makefile +share/doc/pgsql/src/sgml/admin.sgml +share/doc/pgsql/src/sgml/advanced.sgml +share/doc/pgsql/src/sgml/arch-dev.sgml +share/doc/pgsql/src/sgml/arch-pg.sgml +share/doc/pgsql/src/sgml/arch.sgml +share/doc/pgsql/src/sgml/array.sgml +share/doc/pgsql/src/sgml/biblio.sgml +share/doc/pgsql/src/sgml/compiler.sgml +share/doc/pgsql/src/sgml/contacts.sgml +share/doc/pgsql/src/sgml/datatype.sgml +share/doc/pgsql/src/sgml/dfunc.sgml +share/doc/pgsql/src/sgml/docguide.sgml +share/doc/pgsql/src/sgml/ecpg.sgml +share/doc/pgsql/src/sgml/environ.sgml +share/doc/pgsql/src/sgml/extend.sgml +share/doc/pgsql/src/sgml/func-ref.sgml +share/doc/pgsql/src/sgml/geqo.sgml +share/doc/pgsql/src/sgml/gist.sgml +share/doc/pgsql/src/sgml/inherit.sgml +share/doc/pgsql/src/sgml/install.sgml +share/doc/pgsql/src/sgml/intro-pg.sgml +share/doc/pgsql/src/sgml/intro.sgml +share/doc/pgsql/src/sgml/jdbc.sgml +share/doc/pgsql/src/sgml/libpgtcl.sgml +share/doc/pgsql/src/sgml/libpq.sgml +share/doc/pgsql/src/sgml/lobj.sgml +share/doc/pgsql/src/sgml/manage.sgml +share/doc/pgsql/src/sgml/odbc.sgml +share/doc/pgsql/src/sgml/pgaccess.sgml +share/doc/pgsql/src/sgml/ports.sgml +share/doc/pgsql/src/sgml/postgres.sgml +share/doc/pgsql/src/sgml/programmer.sgml +share/doc/pgsql/src/sgml/protocol.sgml +share/doc/pgsql/src/sgml/psql.sgml +share/doc/pgsql/src/sgml/query-ug.sgml +share/doc/pgsql/src/sgml/query.sgml +share/doc/pgsql/src/sgml/recovery.sgml +share/doc/pgsql/src/sgml/regress.sgml +share/doc/pgsql/src/sgml/release.sgml +share/doc/pgsql/src/sgml/rules.sgml +share/doc/pgsql/src/sgml/spi.sgml +share/doc/pgsql/src/sgml/start-ag.sgml +share/doc/pgsql/src/sgml/start.sgml +share/doc/pgsql/src/sgml/storage.sgml +share/doc/pgsql/src/sgml/trigger.sgml +share/doc/pgsql/src/sgml/tutorial.sgml +share/doc/pgsql/src/sgml/user.sgml +share/doc/pgsql/src/sgml/xaggr.sgml +share/doc/pgsql/src/sgml/xfunc.sgml +share/doc/pgsql/src/sgml/xindex.sgml +share/doc/pgsql/src/sgml/xoper.sgml +share/doc/pgsql/src/sgml/xtypes.sgml +share/doc/pgsql/tutorial.ps.gz +share/doc/pgsql/tutorial.tar.gz +share/doc/pgsql/user.ps.gz +share/doc/pgsql/user.tar.gz share/doc/pgsql/userguide.ps -@dirrm share/doc/pgsql/manual +@dirrm share/doc/pgsql/src/graphics +@dirrm share/doc/pgsql/src/sgml +@dirrm share/doc/pgsql/src @dirrm share/doc/pgsql @dirrm pgsql/bin @dirrm pgsql/data/base/template1 @dirrm pgsql/data/base @dirrm pgsql/data @dirrm pgsql/include/access +@dirrm pgsql/include/commands +@dirrm pgsql/include/executor @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq -@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port/bsd @dirrm pgsql/include/port @dirrm pgsql/include/utils @dirrm pgsql/include diff --git a/databases/postgresql74-server/Makefile b/databases/postgresql74-server/Makefile index 0cc83efe5fc4..476257fd2ee4 100644 --- a/databases/postgresql74-server/Makefile +++ b/databases/postgresql74-server/Makefile @@ -3,11 +3,13 @@ # Date created: April 2, 1997 # Whom: Marc G. Fournier # -# $Id: Makefile,v 1.22 1997/12/24 01:21:37 alex Exp $ +# $Id: Makefile,v 1.23 1998/03/22 16:45:18 andreas Exp $ -DISTNAME= postgresql-6.2.1 +PATCH_DEBUG= yes + +DISTNAME= postgresql-6.3.2 CATEGORIES= databases -MASTER_SITES= http://www.freebsd.org/~andreas/download/ +MASTER_SITES= ftp://ftp.postgresql.org/pub/ MAINTAINER= andreas@FreeBSD.ORG @@ -16,6 +18,7 @@ MAINTAINER= andreas@FreeBSD.ORG .if defined(USE_TCL) MAKE_ENV= USE_TCL=true TCL_INCDIR=${PREFIX}/include/tcl8.0 LIB_DEPENDS= tcl80\\.1\\.:${PORTSDIR}/lang/tcl80 +WITH_TCL= --with-tcl .endif NO_PACKAGE= "Requires pgsql uid" @@ -26,26 +29,28 @@ MAKEFILE= GNUmakefile 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]'` \ + --with-includes=/usr/local/include ${WITH_TCL} \ + --with-libraries=/usr/local/lib MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ - destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + destroyuser.1 ecpg.1 initdb.1 ipcclean.1 initlocation.1 \ + pg_dump.1 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 \ +MANL= abort.l alter_table.l alter_user.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_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 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 + create_function.l create_index.l create_language.l \ + create_operator.l create_rule.l create_sequence.l \ + create_table.l create_trigger.l create_type.l create_user.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_language.l drop_operator.l drop_rule.l drop_sequence.l \ + drop_table.l drop_trigger.l drop_type.l drop_user.l \ + drop_view.l end.l explain.l fetch.l grant.l insert.l listen.l \ + load.l lock.l move.l notify.l reset.l revoke.l \ + rollback.l select.l set.l show.l sql.l update.l vacuum.l MANPREFIX= ${PREFIX}/pgsql diff --git a/databases/postgresql74-server/distinfo b/databases/postgresql74-server/distinfo index 5d42f88c853a..dc42f89ecf8d 100644 --- a/databases/postgresql74-server/distinfo +++ b/databases/postgresql74-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-6.2.1.tar.gz) = bd606dcab6b09a3a3d276d88b504a1d3 +MD5 (postgresql-6.3.2.tar.gz) = 8902842461c9a42854ba9883bee56a4c diff --git a/databases/postgresql74-server/files/pgsql.sh.tmpl b/databases/postgresql74-server/files/pgsql.sh.tmpl index 9fd81e4ff367..ed6c54d18839 100644 --- a/databases/postgresql74-server/files/pgsql.sh.tmpl +++ b/databases/postgresql74-server/files/pgsql.sh.tmpl @@ -1,6 +1,6 @@ #!/bin/sh -# $Id: pgsql.sh.tmpl,v 1.2 1997/10/03 18:26:54 andreas Exp $ +# $Id: pgsql.sh.tmpl,v 1.3 1997/10/05 21:00:49 andreas Exp $ # pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) @@ -19,7 +19,7 @@ [ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib [ -x !!PREFIX!!/pgsql/bin/postmaster ] && { - su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster \ - -S -o -F > !!PREFIX!!/pgsql/errlog' + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster -i -S -o -F \ + -D!!PREFIX!!/pgsql/data > !!PREFIX!!/pgsql/errlog' echo -n ' pgsql' } diff --git a/databases/postgresql74-server/pkg-plist b/databases/postgresql74-server/pkg-plist index 985c0a47ac30..5e5936ec028e 100644 --- a/databases/postgresql74-server/pkg-plist +++ b/databases/postgresql74-server/pkg-plist @@ -5,7 +5,10 @@ pgsql/bin/createdb pgsql/bin/createuser pgsql/bin/destroydb pgsql/bin/destroyuser +pgsql/bin/ecpg pgsql/bin/initdb +pgsql/bin/initlocation +pgsql/bin/ipcclean pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id @@ -14,7 +17,6 @@ pgsql/bin/pg_version pgsql/bin/pgtclsh pgsql/bin/pgtksh pgsql/bin/postgres -pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -22,15 +24,17 @@ pgsql/data/base/template1/pg_aggregate pgsql/data/base/template1/pg_am 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_attrdef_adrelid_index pgsql/data/base/template1/pg_attribute +pgsql/data/base/template1/pg_attribute_attrelid_index +pgsql/data/base/template1/pg_attribute_relid_attnam_index +pgsql/data/base/template1/pg_attribute_relid_attnum_index pgsql/data/base/template1/pg_class -pgsql/data/base/template1/pg_classnameind -pgsql/data/base/template1/pg_classoidind +pgsql/data/base/template1/pg_class_oid_index +pgsql/data/base/template1/pg_class_relname_index +pgsql/data/base/template1/pg_description +pgsql/data/base/template1/pg_description_objoid_index pgsql/data/base/template1/pg_index pgsql/data/base/template1/pg_inheritproc pgsql/data/base/template1/pg_inherits @@ -42,35 +46,36 @@ pgsql/data/base/template1/pg_opclass pgsql/data/base/template1/pg_operator pgsql/data/base/template1/pg_parg 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_proc_oid_index +pgsql/data/base/template1/pg_proc_proname_index +pgsql/data/base/template1/pg_proc_prosrc_index pgsql/data/base/template1/pg_relcheck -pgsql/data/base/template1/pg_relcheckind +pgsql/data/base/template1/pg_relcheck_rcrelid_index 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_trigger_tgrelid_index pgsql/data/base/template1/pg_type -pgsql/data/base/template1/pg_typeidind -pgsql/data/base/template1/pg_typenameind +pgsql/data/base/template1/pg_type_oid_index +pgsql/data/base/template1/pg_type_typname_index +pgsql/data/base/template1/pg_user pgsql/data/base/template1/pg_version pgsql/data/pg_database -pgsql/data/pg_defaults -pgsql/data/pg_demon pgsql/data/pg_geqo.sample pgsql/data/pg_group pgsql/data/pg_hba.conf -pgsql/data/pg_hosts pgsql/data/pg_log -pgsql/data/pg_magic -pgsql/data/pg_server -pgsql/data/pg_time -pgsql/data/pg_user +pgsql/data/pg_pwd +pgsql/data/pg_shadow pgsql/data/pg_variable +pgsql/errlog pgsql/include/access/attnum.h pgsql/include/c.h +pgsql/include/commands/trigger.h pgsql/include/config.h +pgsql/include/ecpglib.h +pgsql/include/ecpgtype.h +pgsql/include/executor/spi.h pgsql/include/fmgr.h pgsql/include/lib/dllist.h pgsql/include/libpgtcl.h @@ -80,17 +85,20 @@ pgsql/include/libpq/pqcomm.h pgsql/include/os.h pgsql/include/postgres.h pgsql/include/postgres_ext.h +pgsql/include/sqlca.h pgsql/include/utils/elog.h pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source +pgsql/lib/global1.description +pgsql/lib/libecpg.a +pgsql/lib/libecpg.so.1.1 pgsql/lib/libpgtcl.a -pgsql/lib/libpgtcl.so pgsql/lib/libpgtcl.so.1.0 pgsql/lib/libpq.a -pgsql/lib/libpq.so -pgsql/lib/libpq.so.1.0 +pgsql/lib/libpq.so.1.1 pgsql/lib/local1_template1.bki.source +pgsql/lib/local1_template1.description pgsql/lib/pg_geqo.sample pgsql/lib/pg_hba.conf.sample pgsql/man/man1/cleardbdir.1.gz @@ -98,9 +106,10 @@ pgsql/man/man1/createdb.1.gz pgsql/man/man1/createuser.1.gz pgsql/man/man1/destroydb.1.gz pgsql/man/man1/destroyuser.1.gz +pgsql/man/man1/ecpg.1.gz pgsql/man/man1/initdb.1.gz +pgsql/man/man1/initlocation.1.gz 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 @@ -118,6 +127,7 @@ pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz pgsql/man/manl/abort.l.gz pgsql/man/manl/alter_table.l.gz +pgsql/man/manl/alter_user.l.gz pgsql/man/manl/begin.l.gz pgsql/man/manl/close.l.gz pgsql/man/manl/cluster.l.gz @@ -127,12 +137,14 @@ pgsql/man/manl/create_aggregate.l.gz pgsql/man/manl/create_database.l.gz pgsql/man/manl/create_function.l.gz pgsql/man/manl/create_index.l.gz +pgsql/man/manl/create_language.l.gz 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_user.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz pgsql/man/manl/declare.l.gz @@ -142,12 +154,14 @@ pgsql/man/manl/drop_aggregate.l.gz pgsql/man/manl/drop_database.l.gz pgsql/man/manl/drop_function.l.gz pgsql/man/manl/drop_index.l.gz +pgsql/man/manl/drop_language.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_user.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz pgsql/man/manl/explain.l.gz @@ -156,10 +170,9 @@ 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/lock.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 pgsql/man/manl/reset.l.gz pgsql/man/manl/revoke.l.gz pgsql/man/manl/rollback.l.gz @@ -171,51 +184,104 @@ pgsql/man/manl/update.l.gz pgsql/man/manl/vacuum.l.gz pgsql/post-install-notes share/doc/pgsql/FAQ -share/doc/pgsql/FAQ-Irix -share/doc/pgsql/FAQ-Linux +share/doc/pgsql/FAQ_FreeBSD +share/doc/pgsql/FAQ_Irix +share/doc/pgsql/FAQ_Linux +share/doc/pgsql/Makefile share/doc/pgsql/README.GEQO share/doc/pgsql/README.fsync +share/doc/pgsql/README.mb +share/doc/pgsql/README.mb.jp share/doc/pgsql/README.support share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO +share/doc/pgsql/admin.ps.gz +share/doc/pgsql/admin.tar.gz 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/postgres.tar.gz +share/doc/pgsql/programmer.ps.gz +share/doc/pgsql/programmer.tar.gz +share/doc/pgsql/src/Makefile +share/doc/pgsql/src/graphics/catalogs.gif +share/doc/pgsql/src/graphics/clientserver.ag +share/doc/pgsql/src/graphics/clientserver.gif +share/doc/pgsql/src/graphics/connections.ag +share/doc/pgsql/src/graphics/connections.gif +share/doc/pgsql/src/graphics/layout.ag +share/doc/pgsql/src/graphics/layout.gif +share/doc/pgsql/src/sgml/Makefile +share/doc/pgsql/src/sgml/admin.sgml +share/doc/pgsql/src/sgml/advanced.sgml +share/doc/pgsql/src/sgml/arch-dev.sgml +share/doc/pgsql/src/sgml/arch-pg.sgml +share/doc/pgsql/src/sgml/arch.sgml +share/doc/pgsql/src/sgml/array.sgml +share/doc/pgsql/src/sgml/biblio.sgml +share/doc/pgsql/src/sgml/compiler.sgml +share/doc/pgsql/src/sgml/contacts.sgml +share/doc/pgsql/src/sgml/datatype.sgml +share/doc/pgsql/src/sgml/dfunc.sgml +share/doc/pgsql/src/sgml/docguide.sgml +share/doc/pgsql/src/sgml/ecpg.sgml +share/doc/pgsql/src/sgml/environ.sgml +share/doc/pgsql/src/sgml/extend.sgml +share/doc/pgsql/src/sgml/func-ref.sgml +share/doc/pgsql/src/sgml/geqo.sgml +share/doc/pgsql/src/sgml/gist.sgml +share/doc/pgsql/src/sgml/inherit.sgml +share/doc/pgsql/src/sgml/install.sgml +share/doc/pgsql/src/sgml/intro-pg.sgml +share/doc/pgsql/src/sgml/intro.sgml +share/doc/pgsql/src/sgml/jdbc.sgml +share/doc/pgsql/src/sgml/libpgtcl.sgml +share/doc/pgsql/src/sgml/libpq.sgml +share/doc/pgsql/src/sgml/lobj.sgml +share/doc/pgsql/src/sgml/manage.sgml +share/doc/pgsql/src/sgml/odbc.sgml +share/doc/pgsql/src/sgml/pgaccess.sgml +share/doc/pgsql/src/sgml/ports.sgml +share/doc/pgsql/src/sgml/postgres.sgml +share/doc/pgsql/src/sgml/programmer.sgml +share/doc/pgsql/src/sgml/protocol.sgml +share/doc/pgsql/src/sgml/psql.sgml +share/doc/pgsql/src/sgml/query-ug.sgml +share/doc/pgsql/src/sgml/query.sgml +share/doc/pgsql/src/sgml/recovery.sgml +share/doc/pgsql/src/sgml/regress.sgml +share/doc/pgsql/src/sgml/release.sgml +share/doc/pgsql/src/sgml/rules.sgml +share/doc/pgsql/src/sgml/spi.sgml +share/doc/pgsql/src/sgml/start-ag.sgml +share/doc/pgsql/src/sgml/start.sgml +share/doc/pgsql/src/sgml/storage.sgml +share/doc/pgsql/src/sgml/trigger.sgml +share/doc/pgsql/src/sgml/tutorial.sgml +share/doc/pgsql/src/sgml/user.sgml +share/doc/pgsql/src/sgml/xaggr.sgml +share/doc/pgsql/src/sgml/xfunc.sgml +share/doc/pgsql/src/sgml/xindex.sgml +share/doc/pgsql/src/sgml/xoper.sgml +share/doc/pgsql/src/sgml/xtypes.sgml +share/doc/pgsql/tutorial.ps.gz +share/doc/pgsql/tutorial.tar.gz +share/doc/pgsql/user.ps.gz +share/doc/pgsql/user.tar.gz share/doc/pgsql/userguide.ps -@dirrm share/doc/pgsql/manual +@dirrm share/doc/pgsql/src/graphics +@dirrm share/doc/pgsql/src/sgml +@dirrm share/doc/pgsql/src @dirrm share/doc/pgsql @dirrm pgsql/bin @dirrm pgsql/data/base/template1 @dirrm pgsql/data/base @dirrm pgsql/data @dirrm pgsql/include/access +@dirrm pgsql/include/commands +@dirrm pgsql/include/executor @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq -@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port/bsd @dirrm pgsql/include/port @dirrm pgsql/include/utils @dirrm pgsql/include diff --git a/databases/postgresql80-server/Makefile b/databases/postgresql80-server/Makefile index 0cc83efe5fc4..476257fd2ee4 100644 --- a/databases/postgresql80-server/Makefile +++ b/databases/postgresql80-server/Makefile @@ -3,11 +3,13 @@ # Date created: April 2, 1997 # Whom: Marc G. Fournier # -# $Id: Makefile,v 1.22 1997/12/24 01:21:37 alex Exp $ +# $Id: Makefile,v 1.23 1998/03/22 16:45:18 andreas Exp $ -DISTNAME= postgresql-6.2.1 +PATCH_DEBUG= yes + +DISTNAME= postgresql-6.3.2 CATEGORIES= databases -MASTER_SITES= http://www.freebsd.org/~andreas/download/ +MASTER_SITES= ftp://ftp.postgresql.org/pub/ MAINTAINER= andreas@FreeBSD.ORG @@ -16,6 +18,7 @@ MAINTAINER= andreas@FreeBSD.ORG .if defined(USE_TCL) MAKE_ENV= USE_TCL=true TCL_INCDIR=${PREFIX}/include/tcl8.0 LIB_DEPENDS= tcl80\\.1\\.:${PORTSDIR}/lang/tcl80 +WITH_TCL= --with-tcl .endif NO_PACKAGE= "Requires pgsql uid" @@ -26,26 +29,28 @@ MAKEFILE= GNUmakefile 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]'` \ + --with-includes=/usr/local/include ${WITH_TCL} \ + --with-libraries=/usr/local/lib MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ - destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + destroyuser.1 ecpg.1 initdb.1 ipcclean.1 initlocation.1 \ + pg_dump.1 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 \ +MANL= abort.l alter_table.l alter_user.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_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 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 + create_function.l create_index.l create_language.l \ + create_operator.l create_rule.l create_sequence.l \ + create_table.l create_trigger.l create_type.l create_user.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_language.l drop_operator.l drop_rule.l drop_sequence.l \ + drop_table.l drop_trigger.l drop_type.l drop_user.l \ + drop_view.l end.l explain.l fetch.l grant.l insert.l listen.l \ + load.l lock.l move.l notify.l reset.l revoke.l \ + rollback.l select.l set.l show.l sql.l update.l vacuum.l MANPREFIX= ${PREFIX}/pgsql diff --git a/databases/postgresql80-server/distinfo b/databases/postgresql80-server/distinfo index 5d42f88c853a..dc42f89ecf8d 100644 --- a/databases/postgresql80-server/distinfo +++ b/databases/postgresql80-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-6.2.1.tar.gz) = bd606dcab6b09a3a3d276d88b504a1d3 +MD5 (postgresql-6.3.2.tar.gz) = 8902842461c9a42854ba9883bee56a4c diff --git a/databases/postgresql80-server/files/pgsql.sh.tmpl b/databases/postgresql80-server/files/pgsql.sh.tmpl index 9fd81e4ff367..ed6c54d18839 100644 --- a/databases/postgresql80-server/files/pgsql.sh.tmpl +++ b/databases/postgresql80-server/files/pgsql.sh.tmpl @@ -1,6 +1,6 @@ #!/bin/sh -# $Id: pgsql.sh.tmpl,v 1.2 1997/10/03 18:26:54 andreas Exp $ +# $Id: pgsql.sh.tmpl,v 1.3 1997/10/05 21:00:49 andreas Exp $ # pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) @@ -19,7 +19,7 @@ [ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib [ -x !!PREFIX!!/pgsql/bin/postmaster ] && { - su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster \ - -S -o -F > !!PREFIX!!/pgsql/errlog' + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster -i -S -o -F \ + -D!!PREFIX!!/pgsql/data > !!PREFIX!!/pgsql/errlog' echo -n ' pgsql' } diff --git a/databases/postgresql80-server/pkg-plist b/databases/postgresql80-server/pkg-plist index 985c0a47ac30..5e5936ec028e 100644 --- a/databases/postgresql80-server/pkg-plist +++ b/databases/postgresql80-server/pkg-plist @@ -5,7 +5,10 @@ pgsql/bin/createdb pgsql/bin/createuser pgsql/bin/destroydb pgsql/bin/destroyuser +pgsql/bin/ecpg pgsql/bin/initdb +pgsql/bin/initlocation +pgsql/bin/ipcclean pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id @@ -14,7 +17,6 @@ pgsql/bin/pg_version pgsql/bin/pgtclsh pgsql/bin/pgtksh pgsql/bin/postgres -pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -22,15 +24,17 @@ pgsql/data/base/template1/pg_aggregate pgsql/data/base/template1/pg_am 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_attrdef_adrelid_index pgsql/data/base/template1/pg_attribute +pgsql/data/base/template1/pg_attribute_attrelid_index +pgsql/data/base/template1/pg_attribute_relid_attnam_index +pgsql/data/base/template1/pg_attribute_relid_attnum_index pgsql/data/base/template1/pg_class -pgsql/data/base/template1/pg_classnameind -pgsql/data/base/template1/pg_classoidind +pgsql/data/base/template1/pg_class_oid_index +pgsql/data/base/template1/pg_class_relname_index +pgsql/data/base/template1/pg_description +pgsql/data/base/template1/pg_description_objoid_index pgsql/data/base/template1/pg_index pgsql/data/base/template1/pg_inheritproc pgsql/data/base/template1/pg_inherits @@ -42,35 +46,36 @@ pgsql/data/base/template1/pg_opclass pgsql/data/base/template1/pg_operator pgsql/data/base/template1/pg_parg 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_proc_oid_index +pgsql/data/base/template1/pg_proc_proname_index +pgsql/data/base/template1/pg_proc_prosrc_index pgsql/data/base/template1/pg_relcheck -pgsql/data/base/template1/pg_relcheckind +pgsql/data/base/template1/pg_relcheck_rcrelid_index 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_trigger_tgrelid_index pgsql/data/base/template1/pg_type -pgsql/data/base/template1/pg_typeidind -pgsql/data/base/template1/pg_typenameind +pgsql/data/base/template1/pg_type_oid_index +pgsql/data/base/template1/pg_type_typname_index +pgsql/data/base/template1/pg_user pgsql/data/base/template1/pg_version pgsql/data/pg_database -pgsql/data/pg_defaults -pgsql/data/pg_demon pgsql/data/pg_geqo.sample pgsql/data/pg_group pgsql/data/pg_hba.conf -pgsql/data/pg_hosts pgsql/data/pg_log -pgsql/data/pg_magic -pgsql/data/pg_server -pgsql/data/pg_time -pgsql/data/pg_user +pgsql/data/pg_pwd +pgsql/data/pg_shadow pgsql/data/pg_variable +pgsql/errlog pgsql/include/access/attnum.h pgsql/include/c.h +pgsql/include/commands/trigger.h pgsql/include/config.h +pgsql/include/ecpglib.h +pgsql/include/ecpgtype.h +pgsql/include/executor/spi.h pgsql/include/fmgr.h pgsql/include/lib/dllist.h pgsql/include/libpgtcl.h @@ -80,17 +85,20 @@ pgsql/include/libpq/pqcomm.h pgsql/include/os.h pgsql/include/postgres.h pgsql/include/postgres_ext.h +pgsql/include/sqlca.h pgsql/include/utils/elog.h pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source +pgsql/lib/global1.description +pgsql/lib/libecpg.a +pgsql/lib/libecpg.so.1.1 pgsql/lib/libpgtcl.a -pgsql/lib/libpgtcl.so pgsql/lib/libpgtcl.so.1.0 pgsql/lib/libpq.a -pgsql/lib/libpq.so -pgsql/lib/libpq.so.1.0 +pgsql/lib/libpq.so.1.1 pgsql/lib/local1_template1.bki.source +pgsql/lib/local1_template1.description pgsql/lib/pg_geqo.sample pgsql/lib/pg_hba.conf.sample pgsql/man/man1/cleardbdir.1.gz @@ -98,9 +106,10 @@ pgsql/man/man1/createdb.1.gz pgsql/man/man1/createuser.1.gz pgsql/man/man1/destroydb.1.gz pgsql/man/man1/destroyuser.1.gz +pgsql/man/man1/ecpg.1.gz pgsql/man/man1/initdb.1.gz +pgsql/man/man1/initlocation.1.gz 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 @@ -118,6 +127,7 @@ pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz pgsql/man/manl/abort.l.gz pgsql/man/manl/alter_table.l.gz +pgsql/man/manl/alter_user.l.gz pgsql/man/manl/begin.l.gz pgsql/man/manl/close.l.gz pgsql/man/manl/cluster.l.gz @@ -127,12 +137,14 @@ pgsql/man/manl/create_aggregate.l.gz pgsql/man/manl/create_database.l.gz pgsql/man/manl/create_function.l.gz pgsql/man/manl/create_index.l.gz +pgsql/man/manl/create_language.l.gz 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_user.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz pgsql/man/manl/declare.l.gz @@ -142,12 +154,14 @@ pgsql/man/manl/drop_aggregate.l.gz pgsql/man/manl/drop_database.l.gz pgsql/man/manl/drop_function.l.gz pgsql/man/manl/drop_index.l.gz +pgsql/man/manl/drop_language.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_user.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz pgsql/man/manl/explain.l.gz @@ -156,10 +170,9 @@ 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/lock.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 pgsql/man/manl/reset.l.gz pgsql/man/manl/revoke.l.gz pgsql/man/manl/rollback.l.gz @@ -171,51 +184,104 @@ pgsql/man/manl/update.l.gz pgsql/man/manl/vacuum.l.gz pgsql/post-install-notes share/doc/pgsql/FAQ -share/doc/pgsql/FAQ-Irix -share/doc/pgsql/FAQ-Linux +share/doc/pgsql/FAQ_FreeBSD +share/doc/pgsql/FAQ_Irix +share/doc/pgsql/FAQ_Linux +share/doc/pgsql/Makefile share/doc/pgsql/README.GEQO share/doc/pgsql/README.fsync +share/doc/pgsql/README.mb +share/doc/pgsql/README.mb.jp share/doc/pgsql/README.support share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO +share/doc/pgsql/admin.ps.gz +share/doc/pgsql/admin.tar.gz 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/postgres.tar.gz +share/doc/pgsql/programmer.ps.gz +share/doc/pgsql/programmer.tar.gz +share/doc/pgsql/src/Makefile +share/doc/pgsql/src/graphics/catalogs.gif +share/doc/pgsql/src/graphics/clientserver.ag +share/doc/pgsql/src/graphics/clientserver.gif +share/doc/pgsql/src/graphics/connections.ag +share/doc/pgsql/src/graphics/connections.gif +share/doc/pgsql/src/graphics/layout.ag +share/doc/pgsql/src/graphics/layout.gif +share/doc/pgsql/src/sgml/Makefile +share/doc/pgsql/src/sgml/admin.sgml +share/doc/pgsql/src/sgml/advanced.sgml +share/doc/pgsql/src/sgml/arch-dev.sgml +share/doc/pgsql/src/sgml/arch-pg.sgml +share/doc/pgsql/src/sgml/arch.sgml +share/doc/pgsql/src/sgml/array.sgml +share/doc/pgsql/src/sgml/biblio.sgml +share/doc/pgsql/src/sgml/compiler.sgml +share/doc/pgsql/src/sgml/contacts.sgml +share/doc/pgsql/src/sgml/datatype.sgml +share/doc/pgsql/src/sgml/dfunc.sgml +share/doc/pgsql/src/sgml/docguide.sgml +share/doc/pgsql/src/sgml/ecpg.sgml +share/doc/pgsql/src/sgml/environ.sgml +share/doc/pgsql/src/sgml/extend.sgml +share/doc/pgsql/src/sgml/func-ref.sgml +share/doc/pgsql/src/sgml/geqo.sgml +share/doc/pgsql/src/sgml/gist.sgml +share/doc/pgsql/src/sgml/inherit.sgml +share/doc/pgsql/src/sgml/install.sgml +share/doc/pgsql/src/sgml/intro-pg.sgml +share/doc/pgsql/src/sgml/intro.sgml +share/doc/pgsql/src/sgml/jdbc.sgml +share/doc/pgsql/src/sgml/libpgtcl.sgml +share/doc/pgsql/src/sgml/libpq.sgml +share/doc/pgsql/src/sgml/lobj.sgml +share/doc/pgsql/src/sgml/manage.sgml +share/doc/pgsql/src/sgml/odbc.sgml +share/doc/pgsql/src/sgml/pgaccess.sgml +share/doc/pgsql/src/sgml/ports.sgml +share/doc/pgsql/src/sgml/postgres.sgml +share/doc/pgsql/src/sgml/programmer.sgml +share/doc/pgsql/src/sgml/protocol.sgml +share/doc/pgsql/src/sgml/psql.sgml +share/doc/pgsql/src/sgml/query-ug.sgml +share/doc/pgsql/src/sgml/query.sgml +share/doc/pgsql/src/sgml/recovery.sgml +share/doc/pgsql/src/sgml/regress.sgml +share/doc/pgsql/src/sgml/release.sgml +share/doc/pgsql/src/sgml/rules.sgml +share/doc/pgsql/src/sgml/spi.sgml +share/doc/pgsql/src/sgml/start-ag.sgml +share/doc/pgsql/src/sgml/start.sgml +share/doc/pgsql/src/sgml/storage.sgml +share/doc/pgsql/src/sgml/trigger.sgml +share/doc/pgsql/src/sgml/tutorial.sgml +share/doc/pgsql/src/sgml/user.sgml +share/doc/pgsql/src/sgml/xaggr.sgml +share/doc/pgsql/src/sgml/xfunc.sgml +share/doc/pgsql/src/sgml/xindex.sgml +share/doc/pgsql/src/sgml/xoper.sgml +share/doc/pgsql/src/sgml/xtypes.sgml +share/doc/pgsql/tutorial.ps.gz +share/doc/pgsql/tutorial.tar.gz +share/doc/pgsql/user.ps.gz +share/doc/pgsql/user.tar.gz share/doc/pgsql/userguide.ps -@dirrm share/doc/pgsql/manual +@dirrm share/doc/pgsql/src/graphics +@dirrm share/doc/pgsql/src/sgml +@dirrm share/doc/pgsql/src @dirrm share/doc/pgsql @dirrm pgsql/bin @dirrm pgsql/data/base/template1 @dirrm pgsql/data/base @dirrm pgsql/data @dirrm pgsql/include/access +@dirrm pgsql/include/commands +@dirrm pgsql/include/executor @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq -@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port/bsd @dirrm pgsql/include/port @dirrm pgsql/include/utils @dirrm pgsql/include diff --git a/databases/postgresql81-server/Makefile b/databases/postgresql81-server/Makefile index 0cc83efe5fc4..476257fd2ee4 100644 --- a/databases/postgresql81-server/Makefile +++ b/databases/postgresql81-server/Makefile @@ -3,11 +3,13 @@ # Date created: April 2, 1997 # Whom: Marc G. Fournier # -# $Id: Makefile,v 1.22 1997/12/24 01:21:37 alex Exp $ +# $Id: Makefile,v 1.23 1998/03/22 16:45:18 andreas Exp $ -DISTNAME= postgresql-6.2.1 +PATCH_DEBUG= yes + +DISTNAME= postgresql-6.3.2 CATEGORIES= databases -MASTER_SITES= http://www.freebsd.org/~andreas/download/ +MASTER_SITES= ftp://ftp.postgresql.org/pub/ MAINTAINER= andreas@FreeBSD.ORG @@ -16,6 +18,7 @@ MAINTAINER= andreas@FreeBSD.ORG .if defined(USE_TCL) MAKE_ENV= USE_TCL=true TCL_INCDIR=${PREFIX}/include/tcl8.0 LIB_DEPENDS= tcl80\\.1\\.:${PORTSDIR}/lang/tcl80 +WITH_TCL= --with-tcl .endif NO_PACKAGE= "Requires pgsql uid" @@ -26,26 +29,28 @@ MAKEFILE= GNUmakefile 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]'` \ + --with-includes=/usr/local/include ${WITH_TCL} \ + --with-libraries=/usr/local/lib MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ - destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + destroyuser.1 ecpg.1 initdb.1 ipcclean.1 initlocation.1 \ + pg_dump.1 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 \ +MANL= abort.l alter_table.l alter_user.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_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 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 + create_function.l create_index.l create_language.l \ + create_operator.l create_rule.l create_sequence.l \ + create_table.l create_trigger.l create_type.l create_user.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_language.l drop_operator.l drop_rule.l drop_sequence.l \ + drop_table.l drop_trigger.l drop_type.l drop_user.l \ + drop_view.l end.l explain.l fetch.l grant.l insert.l listen.l \ + load.l lock.l move.l notify.l reset.l revoke.l \ + rollback.l select.l set.l show.l sql.l update.l vacuum.l MANPREFIX= ${PREFIX}/pgsql diff --git a/databases/postgresql81-server/distinfo b/databases/postgresql81-server/distinfo index 5d42f88c853a..dc42f89ecf8d 100644 --- a/databases/postgresql81-server/distinfo +++ b/databases/postgresql81-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-6.2.1.tar.gz) = bd606dcab6b09a3a3d276d88b504a1d3 +MD5 (postgresql-6.3.2.tar.gz) = 8902842461c9a42854ba9883bee56a4c diff --git a/databases/postgresql81-server/files/pgsql.sh.tmpl b/databases/postgresql81-server/files/pgsql.sh.tmpl index 9fd81e4ff367..ed6c54d18839 100644 --- a/databases/postgresql81-server/files/pgsql.sh.tmpl +++ b/databases/postgresql81-server/files/pgsql.sh.tmpl @@ -1,6 +1,6 @@ #!/bin/sh -# $Id: pgsql.sh.tmpl,v 1.2 1997/10/03 18:26:54 andreas Exp $ +# $Id: pgsql.sh.tmpl,v 1.3 1997/10/05 21:00:49 andreas Exp $ # pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) @@ -19,7 +19,7 @@ [ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib [ -x !!PREFIX!!/pgsql/bin/postmaster ] && { - su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster \ - -S -o -F > !!PREFIX!!/pgsql/errlog' + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster -i -S -o -F \ + -D!!PREFIX!!/pgsql/data > !!PREFIX!!/pgsql/errlog' echo -n ' pgsql' } diff --git a/databases/postgresql81-server/pkg-plist b/databases/postgresql81-server/pkg-plist index 985c0a47ac30..5e5936ec028e 100644 --- a/databases/postgresql81-server/pkg-plist +++ b/databases/postgresql81-server/pkg-plist @@ -5,7 +5,10 @@ pgsql/bin/createdb pgsql/bin/createuser pgsql/bin/destroydb pgsql/bin/destroyuser +pgsql/bin/ecpg pgsql/bin/initdb +pgsql/bin/initlocation +pgsql/bin/ipcclean pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id @@ -14,7 +17,6 @@ pgsql/bin/pg_version pgsql/bin/pgtclsh pgsql/bin/pgtksh pgsql/bin/postgres -pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -22,15 +24,17 @@ pgsql/data/base/template1/pg_aggregate pgsql/data/base/template1/pg_am 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_attrdef_adrelid_index pgsql/data/base/template1/pg_attribute +pgsql/data/base/template1/pg_attribute_attrelid_index +pgsql/data/base/template1/pg_attribute_relid_attnam_index +pgsql/data/base/template1/pg_attribute_relid_attnum_index pgsql/data/base/template1/pg_class -pgsql/data/base/template1/pg_classnameind -pgsql/data/base/template1/pg_classoidind +pgsql/data/base/template1/pg_class_oid_index +pgsql/data/base/template1/pg_class_relname_index +pgsql/data/base/template1/pg_description +pgsql/data/base/template1/pg_description_objoid_index pgsql/data/base/template1/pg_index pgsql/data/base/template1/pg_inheritproc pgsql/data/base/template1/pg_inherits @@ -42,35 +46,36 @@ pgsql/data/base/template1/pg_opclass pgsql/data/base/template1/pg_operator pgsql/data/base/template1/pg_parg 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_proc_oid_index +pgsql/data/base/template1/pg_proc_proname_index +pgsql/data/base/template1/pg_proc_prosrc_index pgsql/data/base/template1/pg_relcheck -pgsql/data/base/template1/pg_relcheckind +pgsql/data/base/template1/pg_relcheck_rcrelid_index 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_trigger_tgrelid_index pgsql/data/base/template1/pg_type -pgsql/data/base/template1/pg_typeidind -pgsql/data/base/template1/pg_typenameind +pgsql/data/base/template1/pg_type_oid_index +pgsql/data/base/template1/pg_type_typname_index +pgsql/data/base/template1/pg_user pgsql/data/base/template1/pg_version pgsql/data/pg_database -pgsql/data/pg_defaults -pgsql/data/pg_demon pgsql/data/pg_geqo.sample pgsql/data/pg_group pgsql/data/pg_hba.conf -pgsql/data/pg_hosts pgsql/data/pg_log -pgsql/data/pg_magic -pgsql/data/pg_server -pgsql/data/pg_time -pgsql/data/pg_user +pgsql/data/pg_pwd +pgsql/data/pg_shadow pgsql/data/pg_variable +pgsql/errlog pgsql/include/access/attnum.h pgsql/include/c.h +pgsql/include/commands/trigger.h pgsql/include/config.h +pgsql/include/ecpglib.h +pgsql/include/ecpgtype.h +pgsql/include/executor/spi.h pgsql/include/fmgr.h pgsql/include/lib/dllist.h pgsql/include/libpgtcl.h @@ -80,17 +85,20 @@ pgsql/include/libpq/pqcomm.h pgsql/include/os.h pgsql/include/postgres.h pgsql/include/postgres_ext.h +pgsql/include/sqlca.h pgsql/include/utils/elog.h pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source +pgsql/lib/global1.description +pgsql/lib/libecpg.a +pgsql/lib/libecpg.so.1.1 pgsql/lib/libpgtcl.a -pgsql/lib/libpgtcl.so pgsql/lib/libpgtcl.so.1.0 pgsql/lib/libpq.a -pgsql/lib/libpq.so -pgsql/lib/libpq.so.1.0 +pgsql/lib/libpq.so.1.1 pgsql/lib/local1_template1.bki.source +pgsql/lib/local1_template1.description pgsql/lib/pg_geqo.sample pgsql/lib/pg_hba.conf.sample pgsql/man/man1/cleardbdir.1.gz @@ -98,9 +106,10 @@ pgsql/man/man1/createdb.1.gz pgsql/man/man1/createuser.1.gz pgsql/man/man1/destroydb.1.gz pgsql/man/man1/destroyuser.1.gz +pgsql/man/man1/ecpg.1.gz pgsql/man/man1/initdb.1.gz +pgsql/man/man1/initlocation.1.gz 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 @@ -118,6 +127,7 @@ pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz pgsql/man/manl/abort.l.gz pgsql/man/manl/alter_table.l.gz +pgsql/man/manl/alter_user.l.gz pgsql/man/manl/begin.l.gz pgsql/man/manl/close.l.gz pgsql/man/manl/cluster.l.gz @@ -127,12 +137,14 @@ pgsql/man/manl/create_aggregate.l.gz pgsql/man/manl/create_database.l.gz pgsql/man/manl/create_function.l.gz pgsql/man/manl/create_index.l.gz +pgsql/man/manl/create_language.l.gz 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_user.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz pgsql/man/manl/declare.l.gz @@ -142,12 +154,14 @@ pgsql/man/manl/drop_aggregate.l.gz pgsql/man/manl/drop_database.l.gz pgsql/man/manl/drop_function.l.gz pgsql/man/manl/drop_index.l.gz +pgsql/man/manl/drop_language.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_user.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz pgsql/man/manl/explain.l.gz @@ -156,10 +170,9 @@ 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/lock.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 pgsql/man/manl/reset.l.gz pgsql/man/manl/revoke.l.gz pgsql/man/manl/rollback.l.gz @@ -171,51 +184,104 @@ pgsql/man/manl/update.l.gz pgsql/man/manl/vacuum.l.gz pgsql/post-install-notes share/doc/pgsql/FAQ -share/doc/pgsql/FAQ-Irix -share/doc/pgsql/FAQ-Linux +share/doc/pgsql/FAQ_FreeBSD +share/doc/pgsql/FAQ_Irix +share/doc/pgsql/FAQ_Linux +share/doc/pgsql/Makefile share/doc/pgsql/README.GEQO share/doc/pgsql/README.fsync +share/doc/pgsql/README.mb +share/doc/pgsql/README.mb.jp share/doc/pgsql/README.support share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO +share/doc/pgsql/admin.ps.gz +share/doc/pgsql/admin.tar.gz 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/postgres.tar.gz +share/doc/pgsql/programmer.ps.gz +share/doc/pgsql/programmer.tar.gz +share/doc/pgsql/src/Makefile +share/doc/pgsql/src/graphics/catalogs.gif +share/doc/pgsql/src/graphics/clientserver.ag +share/doc/pgsql/src/graphics/clientserver.gif +share/doc/pgsql/src/graphics/connections.ag +share/doc/pgsql/src/graphics/connections.gif +share/doc/pgsql/src/graphics/layout.ag +share/doc/pgsql/src/graphics/layout.gif +share/doc/pgsql/src/sgml/Makefile +share/doc/pgsql/src/sgml/admin.sgml +share/doc/pgsql/src/sgml/advanced.sgml +share/doc/pgsql/src/sgml/arch-dev.sgml +share/doc/pgsql/src/sgml/arch-pg.sgml +share/doc/pgsql/src/sgml/arch.sgml +share/doc/pgsql/src/sgml/array.sgml +share/doc/pgsql/src/sgml/biblio.sgml +share/doc/pgsql/src/sgml/compiler.sgml +share/doc/pgsql/src/sgml/contacts.sgml +share/doc/pgsql/src/sgml/datatype.sgml +share/doc/pgsql/src/sgml/dfunc.sgml +share/doc/pgsql/src/sgml/docguide.sgml +share/doc/pgsql/src/sgml/ecpg.sgml +share/doc/pgsql/src/sgml/environ.sgml +share/doc/pgsql/src/sgml/extend.sgml +share/doc/pgsql/src/sgml/func-ref.sgml +share/doc/pgsql/src/sgml/geqo.sgml +share/doc/pgsql/src/sgml/gist.sgml +share/doc/pgsql/src/sgml/inherit.sgml +share/doc/pgsql/src/sgml/install.sgml +share/doc/pgsql/src/sgml/intro-pg.sgml +share/doc/pgsql/src/sgml/intro.sgml +share/doc/pgsql/src/sgml/jdbc.sgml +share/doc/pgsql/src/sgml/libpgtcl.sgml +share/doc/pgsql/src/sgml/libpq.sgml +share/doc/pgsql/src/sgml/lobj.sgml +share/doc/pgsql/src/sgml/manage.sgml +share/doc/pgsql/src/sgml/odbc.sgml +share/doc/pgsql/src/sgml/pgaccess.sgml +share/doc/pgsql/src/sgml/ports.sgml +share/doc/pgsql/src/sgml/postgres.sgml +share/doc/pgsql/src/sgml/programmer.sgml +share/doc/pgsql/src/sgml/protocol.sgml +share/doc/pgsql/src/sgml/psql.sgml +share/doc/pgsql/src/sgml/query-ug.sgml +share/doc/pgsql/src/sgml/query.sgml +share/doc/pgsql/src/sgml/recovery.sgml +share/doc/pgsql/src/sgml/regress.sgml +share/doc/pgsql/src/sgml/release.sgml +share/doc/pgsql/src/sgml/rules.sgml +share/doc/pgsql/src/sgml/spi.sgml +share/doc/pgsql/src/sgml/start-ag.sgml +share/doc/pgsql/src/sgml/start.sgml +share/doc/pgsql/src/sgml/storage.sgml +share/doc/pgsql/src/sgml/trigger.sgml +share/doc/pgsql/src/sgml/tutorial.sgml +share/doc/pgsql/src/sgml/user.sgml +share/doc/pgsql/src/sgml/xaggr.sgml +share/doc/pgsql/src/sgml/xfunc.sgml +share/doc/pgsql/src/sgml/xindex.sgml +share/doc/pgsql/src/sgml/xoper.sgml +share/doc/pgsql/src/sgml/xtypes.sgml +share/doc/pgsql/tutorial.ps.gz +share/doc/pgsql/tutorial.tar.gz +share/doc/pgsql/user.ps.gz +share/doc/pgsql/user.tar.gz share/doc/pgsql/userguide.ps -@dirrm share/doc/pgsql/manual +@dirrm share/doc/pgsql/src/graphics +@dirrm share/doc/pgsql/src/sgml +@dirrm share/doc/pgsql/src @dirrm share/doc/pgsql @dirrm pgsql/bin @dirrm pgsql/data/base/template1 @dirrm pgsql/data/base @dirrm pgsql/data @dirrm pgsql/include/access +@dirrm pgsql/include/commands +@dirrm pgsql/include/executor @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq -@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port/bsd @dirrm pgsql/include/port @dirrm pgsql/include/utils @dirrm pgsql/include diff --git a/databases/postgresql82-server/Makefile b/databases/postgresql82-server/Makefile index 0cc83efe5fc4..476257fd2ee4 100644 --- a/databases/postgresql82-server/Makefile +++ b/databases/postgresql82-server/Makefile @@ -3,11 +3,13 @@ # Date created: April 2, 1997 # Whom: Marc G. Fournier # -# $Id: Makefile,v 1.22 1997/12/24 01:21:37 alex Exp $ +# $Id: Makefile,v 1.23 1998/03/22 16:45:18 andreas Exp $ -DISTNAME= postgresql-6.2.1 +PATCH_DEBUG= yes + +DISTNAME= postgresql-6.3.2 CATEGORIES= databases -MASTER_SITES= http://www.freebsd.org/~andreas/download/ +MASTER_SITES= ftp://ftp.postgresql.org/pub/ MAINTAINER= andreas@FreeBSD.ORG @@ -16,6 +18,7 @@ MAINTAINER= andreas@FreeBSD.ORG .if defined(USE_TCL) MAKE_ENV= USE_TCL=true TCL_INCDIR=${PREFIX}/include/tcl8.0 LIB_DEPENDS= tcl80\\.1\\.:${PORTSDIR}/lang/tcl80 +WITH_TCL= --with-tcl .endif NO_PACKAGE= "Requires pgsql uid" @@ -26,26 +29,28 @@ MAKEFILE= GNUmakefile 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]'` \ + --with-includes=/usr/local/include ${WITH_TCL} \ + --with-libraries=/usr/local/lib MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ - destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + destroyuser.1 ecpg.1 initdb.1 ipcclean.1 initlocation.1 \ + pg_dump.1 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 \ +MANL= abort.l alter_table.l alter_user.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_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 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 + create_function.l create_index.l create_language.l \ + create_operator.l create_rule.l create_sequence.l \ + create_table.l create_trigger.l create_type.l create_user.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_language.l drop_operator.l drop_rule.l drop_sequence.l \ + drop_table.l drop_trigger.l drop_type.l drop_user.l \ + drop_view.l end.l explain.l fetch.l grant.l insert.l listen.l \ + load.l lock.l move.l notify.l reset.l revoke.l \ + rollback.l select.l set.l show.l sql.l update.l vacuum.l MANPREFIX= ${PREFIX}/pgsql diff --git a/databases/postgresql82-server/distinfo b/databases/postgresql82-server/distinfo index 5d42f88c853a..dc42f89ecf8d 100644 --- a/databases/postgresql82-server/distinfo +++ b/databases/postgresql82-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-6.2.1.tar.gz) = bd606dcab6b09a3a3d276d88b504a1d3 +MD5 (postgresql-6.3.2.tar.gz) = 8902842461c9a42854ba9883bee56a4c diff --git a/databases/postgresql82-server/files/pgsql.sh.tmpl b/databases/postgresql82-server/files/pgsql.sh.tmpl index 9fd81e4ff367..ed6c54d18839 100644 --- a/databases/postgresql82-server/files/pgsql.sh.tmpl +++ b/databases/postgresql82-server/files/pgsql.sh.tmpl @@ -1,6 +1,6 @@ #!/bin/sh -# $Id: pgsql.sh.tmpl,v 1.2 1997/10/03 18:26:54 andreas Exp $ +# $Id: pgsql.sh.tmpl,v 1.3 1997/10/05 21:00:49 andreas Exp $ # pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) @@ -19,7 +19,7 @@ [ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib [ -x !!PREFIX!!/pgsql/bin/postmaster ] && { - su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster \ - -S -o -F > !!PREFIX!!/pgsql/errlog' + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster -i -S -o -F \ + -D!!PREFIX!!/pgsql/data > !!PREFIX!!/pgsql/errlog' echo -n ' pgsql' } diff --git a/databases/postgresql82-server/pkg-plist b/databases/postgresql82-server/pkg-plist index 985c0a47ac30..5e5936ec028e 100644 --- a/databases/postgresql82-server/pkg-plist +++ b/databases/postgresql82-server/pkg-plist @@ -5,7 +5,10 @@ pgsql/bin/createdb pgsql/bin/createuser pgsql/bin/destroydb pgsql/bin/destroyuser +pgsql/bin/ecpg pgsql/bin/initdb +pgsql/bin/initlocation +pgsql/bin/ipcclean pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id @@ -14,7 +17,6 @@ pgsql/bin/pg_version pgsql/bin/pgtclsh pgsql/bin/pgtksh pgsql/bin/postgres -pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -22,15 +24,17 @@ pgsql/data/base/template1/pg_aggregate pgsql/data/base/template1/pg_am 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_attrdef_adrelid_index pgsql/data/base/template1/pg_attribute +pgsql/data/base/template1/pg_attribute_attrelid_index +pgsql/data/base/template1/pg_attribute_relid_attnam_index +pgsql/data/base/template1/pg_attribute_relid_attnum_index pgsql/data/base/template1/pg_class -pgsql/data/base/template1/pg_classnameind -pgsql/data/base/template1/pg_classoidind +pgsql/data/base/template1/pg_class_oid_index +pgsql/data/base/template1/pg_class_relname_index +pgsql/data/base/template1/pg_description +pgsql/data/base/template1/pg_description_objoid_index pgsql/data/base/template1/pg_index pgsql/data/base/template1/pg_inheritproc pgsql/data/base/template1/pg_inherits @@ -42,35 +46,36 @@ pgsql/data/base/template1/pg_opclass pgsql/data/base/template1/pg_operator pgsql/data/base/template1/pg_parg 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_proc_oid_index +pgsql/data/base/template1/pg_proc_proname_index +pgsql/data/base/template1/pg_proc_prosrc_index pgsql/data/base/template1/pg_relcheck -pgsql/data/base/template1/pg_relcheckind +pgsql/data/base/template1/pg_relcheck_rcrelid_index 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_trigger_tgrelid_index pgsql/data/base/template1/pg_type -pgsql/data/base/template1/pg_typeidind -pgsql/data/base/template1/pg_typenameind +pgsql/data/base/template1/pg_type_oid_index +pgsql/data/base/template1/pg_type_typname_index +pgsql/data/base/template1/pg_user pgsql/data/base/template1/pg_version pgsql/data/pg_database -pgsql/data/pg_defaults -pgsql/data/pg_demon pgsql/data/pg_geqo.sample pgsql/data/pg_group pgsql/data/pg_hba.conf -pgsql/data/pg_hosts pgsql/data/pg_log -pgsql/data/pg_magic -pgsql/data/pg_server -pgsql/data/pg_time -pgsql/data/pg_user +pgsql/data/pg_pwd +pgsql/data/pg_shadow pgsql/data/pg_variable +pgsql/errlog pgsql/include/access/attnum.h pgsql/include/c.h +pgsql/include/commands/trigger.h pgsql/include/config.h +pgsql/include/ecpglib.h +pgsql/include/ecpgtype.h +pgsql/include/executor/spi.h pgsql/include/fmgr.h pgsql/include/lib/dllist.h pgsql/include/libpgtcl.h @@ -80,17 +85,20 @@ pgsql/include/libpq/pqcomm.h pgsql/include/os.h pgsql/include/postgres.h pgsql/include/postgres_ext.h +pgsql/include/sqlca.h pgsql/include/utils/elog.h pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source +pgsql/lib/global1.description +pgsql/lib/libecpg.a +pgsql/lib/libecpg.so.1.1 pgsql/lib/libpgtcl.a -pgsql/lib/libpgtcl.so pgsql/lib/libpgtcl.so.1.0 pgsql/lib/libpq.a -pgsql/lib/libpq.so -pgsql/lib/libpq.so.1.0 +pgsql/lib/libpq.so.1.1 pgsql/lib/local1_template1.bki.source +pgsql/lib/local1_template1.description pgsql/lib/pg_geqo.sample pgsql/lib/pg_hba.conf.sample pgsql/man/man1/cleardbdir.1.gz @@ -98,9 +106,10 @@ pgsql/man/man1/createdb.1.gz pgsql/man/man1/createuser.1.gz pgsql/man/man1/destroydb.1.gz pgsql/man/man1/destroyuser.1.gz +pgsql/man/man1/ecpg.1.gz pgsql/man/man1/initdb.1.gz +pgsql/man/man1/initlocation.1.gz 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 @@ -118,6 +127,7 @@ pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz pgsql/man/manl/abort.l.gz pgsql/man/manl/alter_table.l.gz +pgsql/man/manl/alter_user.l.gz pgsql/man/manl/begin.l.gz pgsql/man/manl/close.l.gz pgsql/man/manl/cluster.l.gz @@ -127,12 +137,14 @@ pgsql/man/manl/create_aggregate.l.gz pgsql/man/manl/create_database.l.gz pgsql/man/manl/create_function.l.gz pgsql/man/manl/create_index.l.gz +pgsql/man/manl/create_language.l.gz 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_user.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz pgsql/man/manl/declare.l.gz @@ -142,12 +154,14 @@ pgsql/man/manl/drop_aggregate.l.gz pgsql/man/manl/drop_database.l.gz pgsql/man/manl/drop_function.l.gz pgsql/man/manl/drop_index.l.gz +pgsql/man/manl/drop_language.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_user.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz pgsql/man/manl/explain.l.gz @@ -156,10 +170,9 @@ 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/lock.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 pgsql/man/manl/reset.l.gz pgsql/man/manl/revoke.l.gz pgsql/man/manl/rollback.l.gz @@ -171,51 +184,104 @@ pgsql/man/manl/update.l.gz pgsql/man/manl/vacuum.l.gz pgsql/post-install-notes share/doc/pgsql/FAQ -share/doc/pgsql/FAQ-Irix -share/doc/pgsql/FAQ-Linux +share/doc/pgsql/FAQ_FreeBSD +share/doc/pgsql/FAQ_Irix +share/doc/pgsql/FAQ_Linux +share/doc/pgsql/Makefile share/doc/pgsql/README.GEQO share/doc/pgsql/README.fsync +share/doc/pgsql/README.mb +share/doc/pgsql/README.mb.jp share/doc/pgsql/README.support share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO +share/doc/pgsql/admin.ps.gz +share/doc/pgsql/admin.tar.gz 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/postgres.tar.gz +share/doc/pgsql/programmer.ps.gz +share/doc/pgsql/programmer.tar.gz +share/doc/pgsql/src/Makefile +share/doc/pgsql/src/graphics/catalogs.gif +share/doc/pgsql/src/graphics/clientserver.ag +share/doc/pgsql/src/graphics/clientserver.gif +share/doc/pgsql/src/graphics/connections.ag +share/doc/pgsql/src/graphics/connections.gif +share/doc/pgsql/src/graphics/layout.ag +share/doc/pgsql/src/graphics/layout.gif +share/doc/pgsql/src/sgml/Makefile +share/doc/pgsql/src/sgml/admin.sgml +share/doc/pgsql/src/sgml/advanced.sgml +share/doc/pgsql/src/sgml/arch-dev.sgml +share/doc/pgsql/src/sgml/arch-pg.sgml +share/doc/pgsql/src/sgml/arch.sgml +share/doc/pgsql/src/sgml/array.sgml +share/doc/pgsql/src/sgml/biblio.sgml +share/doc/pgsql/src/sgml/compiler.sgml +share/doc/pgsql/src/sgml/contacts.sgml +share/doc/pgsql/src/sgml/datatype.sgml +share/doc/pgsql/src/sgml/dfunc.sgml +share/doc/pgsql/src/sgml/docguide.sgml +share/doc/pgsql/src/sgml/ecpg.sgml +share/doc/pgsql/src/sgml/environ.sgml +share/doc/pgsql/src/sgml/extend.sgml +share/doc/pgsql/src/sgml/func-ref.sgml +share/doc/pgsql/src/sgml/geqo.sgml +share/doc/pgsql/src/sgml/gist.sgml +share/doc/pgsql/src/sgml/inherit.sgml +share/doc/pgsql/src/sgml/install.sgml +share/doc/pgsql/src/sgml/intro-pg.sgml +share/doc/pgsql/src/sgml/intro.sgml +share/doc/pgsql/src/sgml/jdbc.sgml +share/doc/pgsql/src/sgml/libpgtcl.sgml +share/doc/pgsql/src/sgml/libpq.sgml +share/doc/pgsql/src/sgml/lobj.sgml +share/doc/pgsql/src/sgml/manage.sgml +share/doc/pgsql/src/sgml/odbc.sgml +share/doc/pgsql/src/sgml/pgaccess.sgml +share/doc/pgsql/src/sgml/ports.sgml +share/doc/pgsql/src/sgml/postgres.sgml +share/doc/pgsql/src/sgml/programmer.sgml +share/doc/pgsql/src/sgml/protocol.sgml +share/doc/pgsql/src/sgml/psql.sgml +share/doc/pgsql/src/sgml/query-ug.sgml +share/doc/pgsql/src/sgml/query.sgml +share/doc/pgsql/src/sgml/recovery.sgml +share/doc/pgsql/src/sgml/regress.sgml +share/doc/pgsql/src/sgml/release.sgml +share/doc/pgsql/src/sgml/rules.sgml +share/doc/pgsql/src/sgml/spi.sgml +share/doc/pgsql/src/sgml/start-ag.sgml +share/doc/pgsql/src/sgml/start.sgml +share/doc/pgsql/src/sgml/storage.sgml +share/doc/pgsql/src/sgml/trigger.sgml +share/doc/pgsql/src/sgml/tutorial.sgml +share/doc/pgsql/src/sgml/user.sgml +share/doc/pgsql/src/sgml/xaggr.sgml +share/doc/pgsql/src/sgml/xfunc.sgml +share/doc/pgsql/src/sgml/xindex.sgml +share/doc/pgsql/src/sgml/xoper.sgml +share/doc/pgsql/src/sgml/xtypes.sgml +share/doc/pgsql/tutorial.ps.gz +share/doc/pgsql/tutorial.tar.gz +share/doc/pgsql/user.ps.gz +share/doc/pgsql/user.tar.gz share/doc/pgsql/userguide.ps -@dirrm share/doc/pgsql/manual +@dirrm share/doc/pgsql/src/graphics +@dirrm share/doc/pgsql/src/sgml +@dirrm share/doc/pgsql/src @dirrm share/doc/pgsql @dirrm pgsql/bin @dirrm pgsql/data/base/template1 @dirrm pgsql/data/base @dirrm pgsql/data @dirrm pgsql/include/access +@dirrm pgsql/include/commands +@dirrm pgsql/include/executor @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq -@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port/bsd @dirrm pgsql/include/port @dirrm pgsql/include/utils @dirrm pgsql/include diff --git a/databases/postgresql83-server/Makefile b/databases/postgresql83-server/Makefile index 0cc83efe5fc4..476257fd2ee4 100644 --- a/databases/postgresql83-server/Makefile +++ b/databases/postgresql83-server/Makefile @@ -3,11 +3,13 @@ # Date created: April 2, 1997 # Whom: Marc G. Fournier # -# $Id: Makefile,v 1.22 1997/12/24 01:21:37 alex Exp $ +# $Id: Makefile,v 1.23 1998/03/22 16:45:18 andreas Exp $ -DISTNAME= postgresql-6.2.1 +PATCH_DEBUG= yes + +DISTNAME= postgresql-6.3.2 CATEGORIES= databases -MASTER_SITES= http://www.freebsd.org/~andreas/download/ +MASTER_SITES= ftp://ftp.postgresql.org/pub/ MAINTAINER= andreas@FreeBSD.ORG @@ -16,6 +18,7 @@ MAINTAINER= andreas@FreeBSD.ORG .if defined(USE_TCL) MAKE_ENV= USE_TCL=true TCL_INCDIR=${PREFIX}/include/tcl8.0 LIB_DEPENDS= tcl80\\.1\\.:${PORTSDIR}/lang/tcl80 +WITH_TCL= --with-tcl .endif NO_PACKAGE= "Requires pgsql uid" @@ -26,26 +29,28 @@ MAKEFILE= GNUmakefile 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]'` \ + --with-includes=/usr/local/include ${WITH_TCL} \ + --with-libraries=/usr/local/lib MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ - destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + destroyuser.1 ecpg.1 initdb.1 ipcclean.1 initlocation.1 \ + pg_dump.1 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 \ +MANL= abort.l alter_table.l alter_user.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_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 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 + create_function.l create_index.l create_language.l \ + create_operator.l create_rule.l create_sequence.l \ + create_table.l create_trigger.l create_type.l create_user.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_language.l drop_operator.l drop_rule.l drop_sequence.l \ + drop_table.l drop_trigger.l drop_type.l drop_user.l \ + drop_view.l end.l explain.l fetch.l grant.l insert.l listen.l \ + load.l lock.l move.l notify.l reset.l revoke.l \ + rollback.l select.l set.l show.l sql.l update.l vacuum.l MANPREFIX= ${PREFIX}/pgsql diff --git a/databases/postgresql83-server/distinfo b/databases/postgresql83-server/distinfo index 5d42f88c853a..dc42f89ecf8d 100644 --- a/databases/postgresql83-server/distinfo +++ b/databases/postgresql83-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-6.2.1.tar.gz) = bd606dcab6b09a3a3d276d88b504a1d3 +MD5 (postgresql-6.3.2.tar.gz) = 8902842461c9a42854ba9883bee56a4c diff --git a/databases/postgresql83-server/files/pgsql.sh.tmpl b/databases/postgresql83-server/files/pgsql.sh.tmpl index 9fd81e4ff367..ed6c54d18839 100644 --- a/databases/postgresql83-server/files/pgsql.sh.tmpl +++ b/databases/postgresql83-server/files/pgsql.sh.tmpl @@ -1,6 +1,6 @@ #!/bin/sh -# $Id: pgsql.sh.tmpl,v 1.2 1997/10/03 18:26:54 andreas Exp $ +# $Id: pgsql.sh.tmpl,v 1.3 1997/10/05 21:00:49 andreas Exp $ # pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) @@ -19,7 +19,7 @@ [ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib [ -x !!PREFIX!!/pgsql/bin/postmaster ] && { - su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster \ - -S -o -F > !!PREFIX!!/pgsql/errlog' + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster -i -S -o -F \ + -D!!PREFIX!!/pgsql/data > !!PREFIX!!/pgsql/errlog' echo -n ' pgsql' } diff --git a/databases/postgresql83-server/pkg-plist b/databases/postgresql83-server/pkg-plist index 985c0a47ac30..5e5936ec028e 100644 --- a/databases/postgresql83-server/pkg-plist +++ b/databases/postgresql83-server/pkg-plist @@ -5,7 +5,10 @@ pgsql/bin/createdb pgsql/bin/createuser pgsql/bin/destroydb pgsql/bin/destroyuser +pgsql/bin/ecpg pgsql/bin/initdb +pgsql/bin/initlocation +pgsql/bin/ipcclean pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id @@ -14,7 +17,6 @@ pgsql/bin/pg_version pgsql/bin/pgtclsh pgsql/bin/pgtksh pgsql/bin/postgres -pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -22,15 +24,17 @@ pgsql/data/base/template1/pg_aggregate pgsql/data/base/template1/pg_am 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_attrdef_adrelid_index pgsql/data/base/template1/pg_attribute +pgsql/data/base/template1/pg_attribute_attrelid_index +pgsql/data/base/template1/pg_attribute_relid_attnam_index +pgsql/data/base/template1/pg_attribute_relid_attnum_index pgsql/data/base/template1/pg_class -pgsql/data/base/template1/pg_classnameind -pgsql/data/base/template1/pg_classoidind +pgsql/data/base/template1/pg_class_oid_index +pgsql/data/base/template1/pg_class_relname_index +pgsql/data/base/template1/pg_description +pgsql/data/base/template1/pg_description_objoid_index pgsql/data/base/template1/pg_index pgsql/data/base/template1/pg_inheritproc pgsql/data/base/template1/pg_inherits @@ -42,35 +46,36 @@ pgsql/data/base/template1/pg_opclass pgsql/data/base/template1/pg_operator pgsql/data/base/template1/pg_parg 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_proc_oid_index +pgsql/data/base/template1/pg_proc_proname_index +pgsql/data/base/template1/pg_proc_prosrc_index pgsql/data/base/template1/pg_relcheck -pgsql/data/base/template1/pg_relcheckind +pgsql/data/base/template1/pg_relcheck_rcrelid_index 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_trigger_tgrelid_index pgsql/data/base/template1/pg_type -pgsql/data/base/template1/pg_typeidind -pgsql/data/base/template1/pg_typenameind +pgsql/data/base/template1/pg_type_oid_index +pgsql/data/base/template1/pg_type_typname_index +pgsql/data/base/template1/pg_user pgsql/data/base/template1/pg_version pgsql/data/pg_database -pgsql/data/pg_defaults -pgsql/data/pg_demon pgsql/data/pg_geqo.sample pgsql/data/pg_group pgsql/data/pg_hba.conf -pgsql/data/pg_hosts pgsql/data/pg_log -pgsql/data/pg_magic -pgsql/data/pg_server -pgsql/data/pg_time -pgsql/data/pg_user +pgsql/data/pg_pwd +pgsql/data/pg_shadow pgsql/data/pg_variable +pgsql/errlog pgsql/include/access/attnum.h pgsql/include/c.h +pgsql/include/commands/trigger.h pgsql/include/config.h +pgsql/include/ecpglib.h +pgsql/include/ecpgtype.h +pgsql/include/executor/spi.h pgsql/include/fmgr.h pgsql/include/lib/dllist.h pgsql/include/libpgtcl.h @@ -80,17 +85,20 @@ pgsql/include/libpq/pqcomm.h pgsql/include/os.h pgsql/include/postgres.h pgsql/include/postgres_ext.h +pgsql/include/sqlca.h pgsql/include/utils/elog.h pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source +pgsql/lib/global1.description +pgsql/lib/libecpg.a +pgsql/lib/libecpg.so.1.1 pgsql/lib/libpgtcl.a -pgsql/lib/libpgtcl.so pgsql/lib/libpgtcl.so.1.0 pgsql/lib/libpq.a -pgsql/lib/libpq.so -pgsql/lib/libpq.so.1.0 +pgsql/lib/libpq.so.1.1 pgsql/lib/local1_template1.bki.source +pgsql/lib/local1_template1.description pgsql/lib/pg_geqo.sample pgsql/lib/pg_hba.conf.sample pgsql/man/man1/cleardbdir.1.gz @@ -98,9 +106,10 @@ pgsql/man/man1/createdb.1.gz pgsql/man/man1/createuser.1.gz pgsql/man/man1/destroydb.1.gz pgsql/man/man1/destroyuser.1.gz +pgsql/man/man1/ecpg.1.gz pgsql/man/man1/initdb.1.gz +pgsql/man/man1/initlocation.1.gz 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 @@ -118,6 +127,7 @@ pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz pgsql/man/manl/abort.l.gz pgsql/man/manl/alter_table.l.gz +pgsql/man/manl/alter_user.l.gz pgsql/man/manl/begin.l.gz pgsql/man/manl/close.l.gz pgsql/man/manl/cluster.l.gz @@ -127,12 +137,14 @@ pgsql/man/manl/create_aggregate.l.gz pgsql/man/manl/create_database.l.gz pgsql/man/manl/create_function.l.gz pgsql/man/manl/create_index.l.gz +pgsql/man/manl/create_language.l.gz 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_user.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz pgsql/man/manl/declare.l.gz @@ -142,12 +154,14 @@ pgsql/man/manl/drop_aggregate.l.gz pgsql/man/manl/drop_database.l.gz pgsql/man/manl/drop_function.l.gz pgsql/man/manl/drop_index.l.gz +pgsql/man/manl/drop_language.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_user.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz pgsql/man/manl/explain.l.gz @@ -156,10 +170,9 @@ 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/lock.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 pgsql/man/manl/reset.l.gz pgsql/man/manl/revoke.l.gz pgsql/man/manl/rollback.l.gz @@ -171,51 +184,104 @@ pgsql/man/manl/update.l.gz pgsql/man/manl/vacuum.l.gz pgsql/post-install-notes share/doc/pgsql/FAQ -share/doc/pgsql/FAQ-Irix -share/doc/pgsql/FAQ-Linux +share/doc/pgsql/FAQ_FreeBSD +share/doc/pgsql/FAQ_Irix +share/doc/pgsql/FAQ_Linux +share/doc/pgsql/Makefile share/doc/pgsql/README.GEQO share/doc/pgsql/README.fsync +share/doc/pgsql/README.mb +share/doc/pgsql/README.mb.jp share/doc/pgsql/README.support share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO +share/doc/pgsql/admin.ps.gz +share/doc/pgsql/admin.tar.gz 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/postgres.tar.gz +share/doc/pgsql/programmer.ps.gz +share/doc/pgsql/programmer.tar.gz +share/doc/pgsql/src/Makefile +share/doc/pgsql/src/graphics/catalogs.gif +share/doc/pgsql/src/graphics/clientserver.ag +share/doc/pgsql/src/graphics/clientserver.gif +share/doc/pgsql/src/graphics/connections.ag +share/doc/pgsql/src/graphics/connections.gif +share/doc/pgsql/src/graphics/layout.ag +share/doc/pgsql/src/graphics/layout.gif +share/doc/pgsql/src/sgml/Makefile +share/doc/pgsql/src/sgml/admin.sgml +share/doc/pgsql/src/sgml/advanced.sgml +share/doc/pgsql/src/sgml/arch-dev.sgml +share/doc/pgsql/src/sgml/arch-pg.sgml +share/doc/pgsql/src/sgml/arch.sgml +share/doc/pgsql/src/sgml/array.sgml +share/doc/pgsql/src/sgml/biblio.sgml +share/doc/pgsql/src/sgml/compiler.sgml +share/doc/pgsql/src/sgml/contacts.sgml +share/doc/pgsql/src/sgml/datatype.sgml +share/doc/pgsql/src/sgml/dfunc.sgml +share/doc/pgsql/src/sgml/docguide.sgml +share/doc/pgsql/src/sgml/ecpg.sgml +share/doc/pgsql/src/sgml/environ.sgml +share/doc/pgsql/src/sgml/extend.sgml +share/doc/pgsql/src/sgml/func-ref.sgml +share/doc/pgsql/src/sgml/geqo.sgml +share/doc/pgsql/src/sgml/gist.sgml +share/doc/pgsql/src/sgml/inherit.sgml +share/doc/pgsql/src/sgml/install.sgml +share/doc/pgsql/src/sgml/intro-pg.sgml +share/doc/pgsql/src/sgml/intro.sgml +share/doc/pgsql/src/sgml/jdbc.sgml +share/doc/pgsql/src/sgml/libpgtcl.sgml +share/doc/pgsql/src/sgml/libpq.sgml +share/doc/pgsql/src/sgml/lobj.sgml +share/doc/pgsql/src/sgml/manage.sgml +share/doc/pgsql/src/sgml/odbc.sgml +share/doc/pgsql/src/sgml/pgaccess.sgml +share/doc/pgsql/src/sgml/ports.sgml +share/doc/pgsql/src/sgml/postgres.sgml +share/doc/pgsql/src/sgml/programmer.sgml +share/doc/pgsql/src/sgml/protocol.sgml +share/doc/pgsql/src/sgml/psql.sgml +share/doc/pgsql/src/sgml/query-ug.sgml +share/doc/pgsql/src/sgml/query.sgml +share/doc/pgsql/src/sgml/recovery.sgml +share/doc/pgsql/src/sgml/regress.sgml +share/doc/pgsql/src/sgml/release.sgml +share/doc/pgsql/src/sgml/rules.sgml +share/doc/pgsql/src/sgml/spi.sgml +share/doc/pgsql/src/sgml/start-ag.sgml +share/doc/pgsql/src/sgml/start.sgml +share/doc/pgsql/src/sgml/storage.sgml +share/doc/pgsql/src/sgml/trigger.sgml +share/doc/pgsql/src/sgml/tutorial.sgml +share/doc/pgsql/src/sgml/user.sgml +share/doc/pgsql/src/sgml/xaggr.sgml +share/doc/pgsql/src/sgml/xfunc.sgml +share/doc/pgsql/src/sgml/xindex.sgml +share/doc/pgsql/src/sgml/xoper.sgml +share/doc/pgsql/src/sgml/xtypes.sgml +share/doc/pgsql/tutorial.ps.gz +share/doc/pgsql/tutorial.tar.gz +share/doc/pgsql/user.ps.gz +share/doc/pgsql/user.tar.gz share/doc/pgsql/userguide.ps -@dirrm share/doc/pgsql/manual +@dirrm share/doc/pgsql/src/graphics +@dirrm share/doc/pgsql/src/sgml +@dirrm share/doc/pgsql/src @dirrm share/doc/pgsql @dirrm pgsql/bin @dirrm pgsql/data/base/template1 @dirrm pgsql/data/base @dirrm pgsql/data @dirrm pgsql/include/access +@dirrm pgsql/include/commands +@dirrm pgsql/include/executor @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq -@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port/bsd @dirrm pgsql/include/port @dirrm pgsql/include/utils @dirrm pgsql/include diff --git a/databases/postgresql84-server/Makefile b/databases/postgresql84-server/Makefile index 0cc83efe5fc4..476257fd2ee4 100644 --- a/databases/postgresql84-server/Makefile +++ b/databases/postgresql84-server/Makefile @@ -3,11 +3,13 @@ # Date created: April 2, 1997 # Whom: Marc G. Fournier # -# $Id: Makefile,v 1.22 1997/12/24 01:21:37 alex Exp $ +# $Id: Makefile,v 1.23 1998/03/22 16:45:18 andreas Exp $ -DISTNAME= postgresql-6.2.1 +PATCH_DEBUG= yes + +DISTNAME= postgresql-6.3.2 CATEGORIES= databases -MASTER_SITES= http://www.freebsd.org/~andreas/download/ +MASTER_SITES= ftp://ftp.postgresql.org/pub/ MAINTAINER= andreas@FreeBSD.ORG @@ -16,6 +18,7 @@ MAINTAINER= andreas@FreeBSD.ORG .if defined(USE_TCL) MAKE_ENV= USE_TCL=true TCL_INCDIR=${PREFIX}/include/tcl8.0 LIB_DEPENDS= tcl80\\.1\\.:${PORTSDIR}/lang/tcl80 +WITH_TCL= --with-tcl .endif NO_PACKAGE= "Requires pgsql uid" @@ -26,26 +29,28 @@ MAKEFILE= GNUmakefile 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]'` \ + --with-includes=/usr/local/include ${WITH_TCL} \ + --with-libraries=/usr/local/lib MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ - destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + destroyuser.1 ecpg.1 initdb.1 ipcclean.1 initlocation.1 \ + pg_dump.1 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 \ +MANL= abort.l alter_table.l alter_user.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_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 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 + create_function.l create_index.l create_language.l \ + create_operator.l create_rule.l create_sequence.l \ + create_table.l create_trigger.l create_type.l create_user.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_language.l drop_operator.l drop_rule.l drop_sequence.l \ + drop_table.l drop_trigger.l drop_type.l drop_user.l \ + drop_view.l end.l explain.l fetch.l grant.l insert.l listen.l \ + load.l lock.l move.l notify.l reset.l revoke.l \ + rollback.l select.l set.l show.l sql.l update.l vacuum.l MANPREFIX= ${PREFIX}/pgsql diff --git a/databases/postgresql84-server/distinfo b/databases/postgresql84-server/distinfo index 5d42f88c853a..dc42f89ecf8d 100644 --- a/databases/postgresql84-server/distinfo +++ b/databases/postgresql84-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-6.2.1.tar.gz) = bd606dcab6b09a3a3d276d88b504a1d3 +MD5 (postgresql-6.3.2.tar.gz) = 8902842461c9a42854ba9883bee56a4c diff --git a/databases/postgresql84-server/files/pgsql.sh.tmpl b/databases/postgresql84-server/files/pgsql.sh.tmpl index 9fd81e4ff367..ed6c54d18839 100644 --- a/databases/postgresql84-server/files/pgsql.sh.tmpl +++ b/databases/postgresql84-server/files/pgsql.sh.tmpl @@ -1,6 +1,6 @@ #!/bin/sh -# $Id: pgsql.sh.tmpl,v 1.2 1997/10/03 18:26:54 andreas Exp $ +# $Id: pgsql.sh.tmpl,v 1.3 1997/10/05 21:00:49 andreas Exp $ # pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) @@ -19,7 +19,7 @@ [ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib [ -x !!PREFIX!!/pgsql/bin/postmaster ] && { - su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster \ - -S -o -F > !!PREFIX!!/pgsql/errlog' + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster -i -S -o -F \ + -D!!PREFIX!!/pgsql/data > !!PREFIX!!/pgsql/errlog' echo -n ' pgsql' } diff --git a/databases/postgresql84-server/pkg-plist b/databases/postgresql84-server/pkg-plist index 985c0a47ac30..5e5936ec028e 100644 --- a/databases/postgresql84-server/pkg-plist +++ b/databases/postgresql84-server/pkg-plist @@ -5,7 +5,10 @@ pgsql/bin/createdb pgsql/bin/createuser pgsql/bin/destroydb pgsql/bin/destroyuser +pgsql/bin/ecpg pgsql/bin/initdb +pgsql/bin/initlocation +pgsql/bin/ipcclean pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id @@ -14,7 +17,6 @@ pgsql/bin/pg_version pgsql/bin/pgtclsh pgsql/bin/pgtksh pgsql/bin/postgres -pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -22,15 +24,17 @@ pgsql/data/base/template1/pg_aggregate pgsql/data/base/template1/pg_am 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_attrdef_adrelid_index pgsql/data/base/template1/pg_attribute +pgsql/data/base/template1/pg_attribute_attrelid_index +pgsql/data/base/template1/pg_attribute_relid_attnam_index +pgsql/data/base/template1/pg_attribute_relid_attnum_index pgsql/data/base/template1/pg_class -pgsql/data/base/template1/pg_classnameind -pgsql/data/base/template1/pg_classoidind +pgsql/data/base/template1/pg_class_oid_index +pgsql/data/base/template1/pg_class_relname_index +pgsql/data/base/template1/pg_description +pgsql/data/base/template1/pg_description_objoid_index pgsql/data/base/template1/pg_index pgsql/data/base/template1/pg_inheritproc pgsql/data/base/template1/pg_inherits @@ -42,35 +46,36 @@ pgsql/data/base/template1/pg_opclass pgsql/data/base/template1/pg_operator pgsql/data/base/template1/pg_parg 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_proc_oid_index +pgsql/data/base/template1/pg_proc_proname_index +pgsql/data/base/template1/pg_proc_prosrc_index pgsql/data/base/template1/pg_relcheck -pgsql/data/base/template1/pg_relcheckind +pgsql/data/base/template1/pg_relcheck_rcrelid_index 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_trigger_tgrelid_index pgsql/data/base/template1/pg_type -pgsql/data/base/template1/pg_typeidind -pgsql/data/base/template1/pg_typenameind +pgsql/data/base/template1/pg_type_oid_index +pgsql/data/base/template1/pg_type_typname_index +pgsql/data/base/template1/pg_user pgsql/data/base/template1/pg_version pgsql/data/pg_database -pgsql/data/pg_defaults -pgsql/data/pg_demon pgsql/data/pg_geqo.sample pgsql/data/pg_group pgsql/data/pg_hba.conf -pgsql/data/pg_hosts pgsql/data/pg_log -pgsql/data/pg_magic -pgsql/data/pg_server -pgsql/data/pg_time -pgsql/data/pg_user +pgsql/data/pg_pwd +pgsql/data/pg_shadow pgsql/data/pg_variable +pgsql/errlog pgsql/include/access/attnum.h pgsql/include/c.h +pgsql/include/commands/trigger.h pgsql/include/config.h +pgsql/include/ecpglib.h +pgsql/include/ecpgtype.h +pgsql/include/executor/spi.h pgsql/include/fmgr.h pgsql/include/lib/dllist.h pgsql/include/libpgtcl.h @@ -80,17 +85,20 @@ pgsql/include/libpq/pqcomm.h pgsql/include/os.h pgsql/include/postgres.h pgsql/include/postgres_ext.h +pgsql/include/sqlca.h pgsql/include/utils/elog.h pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source +pgsql/lib/global1.description +pgsql/lib/libecpg.a +pgsql/lib/libecpg.so.1.1 pgsql/lib/libpgtcl.a -pgsql/lib/libpgtcl.so pgsql/lib/libpgtcl.so.1.0 pgsql/lib/libpq.a -pgsql/lib/libpq.so -pgsql/lib/libpq.so.1.0 +pgsql/lib/libpq.so.1.1 pgsql/lib/local1_template1.bki.source +pgsql/lib/local1_template1.description pgsql/lib/pg_geqo.sample pgsql/lib/pg_hba.conf.sample pgsql/man/man1/cleardbdir.1.gz @@ -98,9 +106,10 @@ pgsql/man/man1/createdb.1.gz pgsql/man/man1/createuser.1.gz pgsql/man/man1/destroydb.1.gz pgsql/man/man1/destroyuser.1.gz +pgsql/man/man1/ecpg.1.gz pgsql/man/man1/initdb.1.gz +pgsql/man/man1/initlocation.1.gz 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 @@ -118,6 +127,7 @@ pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz pgsql/man/manl/abort.l.gz pgsql/man/manl/alter_table.l.gz +pgsql/man/manl/alter_user.l.gz pgsql/man/manl/begin.l.gz pgsql/man/manl/close.l.gz pgsql/man/manl/cluster.l.gz @@ -127,12 +137,14 @@ pgsql/man/manl/create_aggregate.l.gz pgsql/man/manl/create_database.l.gz pgsql/man/manl/create_function.l.gz pgsql/man/manl/create_index.l.gz +pgsql/man/manl/create_language.l.gz 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_user.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz pgsql/man/manl/declare.l.gz @@ -142,12 +154,14 @@ pgsql/man/manl/drop_aggregate.l.gz pgsql/man/manl/drop_database.l.gz pgsql/man/manl/drop_function.l.gz pgsql/man/manl/drop_index.l.gz +pgsql/man/manl/drop_language.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_user.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz pgsql/man/manl/explain.l.gz @@ -156,10 +170,9 @@ 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/lock.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 pgsql/man/manl/reset.l.gz pgsql/man/manl/revoke.l.gz pgsql/man/manl/rollback.l.gz @@ -171,51 +184,104 @@ pgsql/man/manl/update.l.gz pgsql/man/manl/vacuum.l.gz pgsql/post-install-notes share/doc/pgsql/FAQ -share/doc/pgsql/FAQ-Irix -share/doc/pgsql/FAQ-Linux +share/doc/pgsql/FAQ_FreeBSD +share/doc/pgsql/FAQ_Irix +share/doc/pgsql/FAQ_Linux +share/doc/pgsql/Makefile share/doc/pgsql/README.GEQO share/doc/pgsql/README.fsync +share/doc/pgsql/README.mb +share/doc/pgsql/README.mb.jp share/doc/pgsql/README.support share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO +share/doc/pgsql/admin.ps.gz +share/doc/pgsql/admin.tar.gz 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/postgres.tar.gz +share/doc/pgsql/programmer.ps.gz +share/doc/pgsql/programmer.tar.gz +share/doc/pgsql/src/Makefile +share/doc/pgsql/src/graphics/catalogs.gif +share/doc/pgsql/src/graphics/clientserver.ag +share/doc/pgsql/src/graphics/clientserver.gif +share/doc/pgsql/src/graphics/connections.ag +share/doc/pgsql/src/graphics/connections.gif +share/doc/pgsql/src/graphics/layout.ag +share/doc/pgsql/src/graphics/layout.gif +share/doc/pgsql/src/sgml/Makefile +share/doc/pgsql/src/sgml/admin.sgml +share/doc/pgsql/src/sgml/advanced.sgml +share/doc/pgsql/src/sgml/arch-dev.sgml +share/doc/pgsql/src/sgml/arch-pg.sgml +share/doc/pgsql/src/sgml/arch.sgml +share/doc/pgsql/src/sgml/array.sgml +share/doc/pgsql/src/sgml/biblio.sgml +share/doc/pgsql/src/sgml/compiler.sgml +share/doc/pgsql/src/sgml/contacts.sgml +share/doc/pgsql/src/sgml/datatype.sgml +share/doc/pgsql/src/sgml/dfunc.sgml +share/doc/pgsql/src/sgml/docguide.sgml +share/doc/pgsql/src/sgml/ecpg.sgml +share/doc/pgsql/src/sgml/environ.sgml +share/doc/pgsql/src/sgml/extend.sgml +share/doc/pgsql/src/sgml/func-ref.sgml +share/doc/pgsql/src/sgml/geqo.sgml +share/doc/pgsql/src/sgml/gist.sgml +share/doc/pgsql/src/sgml/inherit.sgml +share/doc/pgsql/src/sgml/install.sgml +share/doc/pgsql/src/sgml/intro-pg.sgml +share/doc/pgsql/src/sgml/intro.sgml +share/doc/pgsql/src/sgml/jdbc.sgml +share/doc/pgsql/src/sgml/libpgtcl.sgml +share/doc/pgsql/src/sgml/libpq.sgml +share/doc/pgsql/src/sgml/lobj.sgml +share/doc/pgsql/src/sgml/manage.sgml +share/doc/pgsql/src/sgml/odbc.sgml +share/doc/pgsql/src/sgml/pgaccess.sgml +share/doc/pgsql/src/sgml/ports.sgml +share/doc/pgsql/src/sgml/postgres.sgml +share/doc/pgsql/src/sgml/programmer.sgml +share/doc/pgsql/src/sgml/protocol.sgml +share/doc/pgsql/src/sgml/psql.sgml +share/doc/pgsql/src/sgml/query-ug.sgml +share/doc/pgsql/src/sgml/query.sgml +share/doc/pgsql/src/sgml/recovery.sgml +share/doc/pgsql/src/sgml/regress.sgml +share/doc/pgsql/src/sgml/release.sgml +share/doc/pgsql/src/sgml/rules.sgml +share/doc/pgsql/src/sgml/spi.sgml +share/doc/pgsql/src/sgml/start-ag.sgml +share/doc/pgsql/src/sgml/start.sgml +share/doc/pgsql/src/sgml/storage.sgml +share/doc/pgsql/src/sgml/trigger.sgml +share/doc/pgsql/src/sgml/tutorial.sgml +share/doc/pgsql/src/sgml/user.sgml +share/doc/pgsql/src/sgml/xaggr.sgml +share/doc/pgsql/src/sgml/xfunc.sgml +share/doc/pgsql/src/sgml/xindex.sgml +share/doc/pgsql/src/sgml/xoper.sgml +share/doc/pgsql/src/sgml/xtypes.sgml +share/doc/pgsql/tutorial.ps.gz +share/doc/pgsql/tutorial.tar.gz +share/doc/pgsql/user.ps.gz +share/doc/pgsql/user.tar.gz share/doc/pgsql/userguide.ps -@dirrm share/doc/pgsql/manual +@dirrm share/doc/pgsql/src/graphics +@dirrm share/doc/pgsql/src/sgml +@dirrm share/doc/pgsql/src @dirrm share/doc/pgsql @dirrm pgsql/bin @dirrm pgsql/data/base/template1 @dirrm pgsql/data/base @dirrm pgsql/data @dirrm pgsql/include/access +@dirrm pgsql/include/commands +@dirrm pgsql/include/executor @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq -@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port/bsd @dirrm pgsql/include/port @dirrm pgsql/include/utils @dirrm pgsql/include diff --git a/databases/postgresql90-server/Makefile b/databases/postgresql90-server/Makefile index 0cc83efe5fc4..476257fd2ee4 100644 --- a/databases/postgresql90-server/Makefile +++ b/databases/postgresql90-server/Makefile @@ -3,11 +3,13 @@ # Date created: April 2, 1997 # Whom: Marc G. Fournier # -# $Id: Makefile,v 1.22 1997/12/24 01:21:37 alex Exp $ +# $Id: Makefile,v 1.23 1998/03/22 16:45:18 andreas Exp $ -DISTNAME= postgresql-6.2.1 +PATCH_DEBUG= yes + +DISTNAME= postgresql-6.3.2 CATEGORIES= databases -MASTER_SITES= http://www.freebsd.org/~andreas/download/ +MASTER_SITES= ftp://ftp.postgresql.org/pub/ MAINTAINER= andreas@FreeBSD.ORG @@ -16,6 +18,7 @@ MAINTAINER= andreas@FreeBSD.ORG .if defined(USE_TCL) MAKE_ENV= USE_TCL=true TCL_INCDIR=${PREFIX}/include/tcl8.0 LIB_DEPENDS= tcl80\\.1\\.:${PORTSDIR}/lang/tcl80 +WITH_TCL= --with-tcl .endif NO_PACKAGE= "Requires pgsql uid" @@ -26,26 +29,28 @@ MAKEFILE= GNUmakefile 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]'` \ + --with-includes=/usr/local/include ${WITH_TCL} \ + --with-libraries=/usr/local/lib MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ - destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + destroyuser.1 ecpg.1 initdb.1 ipcclean.1 initlocation.1 \ + pg_dump.1 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 \ +MANL= abort.l alter_table.l alter_user.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_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 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 + create_function.l create_index.l create_language.l \ + create_operator.l create_rule.l create_sequence.l \ + create_table.l create_trigger.l create_type.l create_user.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_language.l drop_operator.l drop_rule.l drop_sequence.l \ + drop_table.l drop_trigger.l drop_type.l drop_user.l \ + drop_view.l end.l explain.l fetch.l grant.l insert.l listen.l \ + load.l lock.l move.l notify.l reset.l revoke.l \ + rollback.l select.l set.l show.l sql.l update.l vacuum.l MANPREFIX= ${PREFIX}/pgsql diff --git a/databases/postgresql90-server/distinfo b/databases/postgresql90-server/distinfo index 5d42f88c853a..dc42f89ecf8d 100644 --- a/databases/postgresql90-server/distinfo +++ b/databases/postgresql90-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-6.2.1.tar.gz) = bd606dcab6b09a3a3d276d88b504a1d3 +MD5 (postgresql-6.3.2.tar.gz) = 8902842461c9a42854ba9883bee56a4c diff --git a/databases/postgresql90-server/files/pgsql.sh.tmpl b/databases/postgresql90-server/files/pgsql.sh.tmpl index 9fd81e4ff367..ed6c54d18839 100644 --- a/databases/postgresql90-server/files/pgsql.sh.tmpl +++ b/databases/postgresql90-server/files/pgsql.sh.tmpl @@ -1,6 +1,6 @@ #!/bin/sh -# $Id: pgsql.sh.tmpl,v 1.2 1997/10/03 18:26:54 andreas Exp $ +# $Id: pgsql.sh.tmpl,v 1.3 1997/10/05 21:00:49 andreas Exp $ # pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) @@ -19,7 +19,7 @@ [ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib [ -x !!PREFIX!!/pgsql/bin/postmaster ] && { - su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster \ - -S -o -F > !!PREFIX!!/pgsql/errlog' + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster -i -S -o -F \ + -D!!PREFIX!!/pgsql/data > !!PREFIX!!/pgsql/errlog' echo -n ' pgsql' } diff --git a/databases/postgresql90-server/pkg-plist b/databases/postgresql90-server/pkg-plist index 985c0a47ac30..5e5936ec028e 100644 --- a/databases/postgresql90-server/pkg-plist +++ b/databases/postgresql90-server/pkg-plist @@ -5,7 +5,10 @@ pgsql/bin/createdb pgsql/bin/createuser pgsql/bin/destroydb pgsql/bin/destroyuser +pgsql/bin/ecpg pgsql/bin/initdb +pgsql/bin/initlocation +pgsql/bin/ipcclean pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id @@ -14,7 +17,6 @@ pgsql/bin/pg_version pgsql/bin/pgtclsh pgsql/bin/pgtksh pgsql/bin/postgres -pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -22,15 +24,17 @@ pgsql/data/base/template1/pg_aggregate pgsql/data/base/template1/pg_am 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_attrdef_adrelid_index pgsql/data/base/template1/pg_attribute +pgsql/data/base/template1/pg_attribute_attrelid_index +pgsql/data/base/template1/pg_attribute_relid_attnam_index +pgsql/data/base/template1/pg_attribute_relid_attnum_index pgsql/data/base/template1/pg_class -pgsql/data/base/template1/pg_classnameind -pgsql/data/base/template1/pg_classoidind +pgsql/data/base/template1/pg_class_oid_index +pgsql/data/base/template1/pg_class_relname_index +pgsql/data/base/template1/pg_description +pgsql/data/base/template1/pg_description_objoid_index pgsql/data/base/template1/pg_index pgsql/data/base/template1/pg_inheritproc pgsql/data/base/template1/pg_inherits @@ -42,35 +46,36 @@ pgsql/data/base/template1/pg_opclass pgsql/data/base/template1/pg_operator pgsql/data/base/template1/pg_parg 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_proc_oid_index +pgsql/data/base/template1/pg_proc_proname_index +pgsql/data/base/template1/pg_proc_prosrc_index pgsql/data/base/template1/pg_relcheck -pgsql/data/base/template1/pg_relcheckind +pgsql/data/base/template1/pg_relcheck_rcrelid_index 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_trigger_tgrelid_index pgsql/data/base/template1/pg_type -pgsql/data/base/template1/pg_typeidind -pgsql/data/base/template1/pg_typenameind +pgsql/data/base/template1/pg_type_oid_index +pgsql/data/base/template1/pg_type_typname_index +pgsql/data/base/template1/pg_user pgsql/data/base/template1/pg_version pgsql/data/pg_database -pgsql/data/pg_defaults -pgsql/data/pg_demon pgsql/data/pg_geqo.sample pgsql/data/pg_group pgsql/data/pg_hba.conf -pgsql/data/pg_hosts pgsql/data/pg_log -pgsql/data/pg_magic -pgsql/data/pg_server -pgsql/data/pg_time -pgsql/data/pg_user +pgsql/data/pg_pwd +pgsql/data/pg_shadow pgsql/data/pg_variable +pgsql/errlog pgsql/include/access/attnum.h pgsql/include/c.h +pgsql/include/commands/trigger.h pgsql/include/config.h +pgsql/include/ecpglib.h +pgsql/include/ecpgtype.h +pgsql/include/executor/spi.h pgsql/include/fmgr.h pgsql/include/lib/dllist.h pgsql/include/libpgtcl.h @@ -80,17 +85,20 @@ pgsql/include/libpq/pqcomm.h pgsql/include/os.h pgsql/include/postgres.h pgsql/include/postgres_ext.h +pgsql/include/sqlca.h pgsql/include/utils/elog.h pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source +pgsql/lib/global1.description +pgsql/lib/libecpg.a +pgsql/lib/libecpg.so.1.1 pgsql/lib/libpgtcl.a -pgsql/lib/libpgtcl.so pgsql/lib/libpgtcl.so.1.0 pgsql/lib/libpq.a -pgsql/lib/libpq.so -pgsql/lib/libpq.so.1.0 +pgsql/lib/libpq.so.1.1 pgsql/lib/local1_template1.bki.source +pgsql/lib/local1_template1.description pgsql/lib/pg_geqo.sample pgsql/lib/pg_hba.conf.sample pgsql/man/man1/cleardbdir.1.gz @@ -98,9 +106,10 @@ pgsql/man/man1/createdb.1.gz pgsql/man/man1/createuser.1.gz pgsql/man/man1/destroydb.1.gz pgsql/man/man1/destroyuser.1.gz +pgsql/man/man1/ecpg.1.gz pgsql/man/man1/initdb.1.gz +pgsql/man/man1/initlocation.1.gz 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 @@ -118,6 +127,7 @@ pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz pgsql/man/manl/abort.l.gz pgsql/man/manl/alter_table.l.gz +pgsql/man/manl/alter_user.l.gz pgsql/man/manl/begin.l.gz pgsql/man/manl/close.l.gz pgsql/man/manl/cluster.l.gz @@ -127,12 +137,14 @@ pgsql/man/manl/create_aggregate.l.gz pgsql/man/manl/create_database.l.gz pgsql/man/manl/create_function.l.gz pgsql/man/manl/create_index.l.gz +pgsql/man/manl/create_language.l.gz 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_user.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz pgsql/man/manl/declare.l.gz @@ -142,12 +154,14 @@ pgsql/man/manl/drop_aggregate.l.gz pgsql/man/manl/drop_database.l.gz pgsql/man/manl/drop_function.l.gz pgsql/man/manl/drop_index.l.gz +pgsql/man/manl/drop_language.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_user.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz pgsql/man/manl/explain.l.gz @@ -156,10 +170,9 @@ 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/lock.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 pgsql/man/manl/reset.l.gz pgsql/man/manl/revoke.l.gz pgsql/man/manl/rollback.l.gz @@ -171,51 +184,104 @@ pgsql/man/manl/update.l.gz pgsql/man/manl/vacuum.l.gz pgsql/post-install-notes share/doc/pgsql/FAQ -share/doc/pgsql/FAQ-Irix -share/doc/pgsql/FAQ-Linux +share/doc/pgsql/FAQ_FreeBSD +share/doc/pgsql/FAQ_Irix +share/doc/pgsql/FAQ_Linux +share/doc/pgsql/Makefile share/doc/pgsql/README.GEQO share/doc/pgsql/README.fsync +share/doc/pgsql/README.mb +share/doc/pgsql/README.mb.jp share/doc/pgsql/README.support share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO +share/doc/pgsql/admin.ps.gz +share/doc/pgsql/admin.tar.gz 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/postgres.tar.gz +share/doc/pgsql/programmer.ps.gz +share/doc/pgsql/programmer.tar.gz +share/doc/pgsql/src/Makefile +share/doc/pgsql/src/graphics/catalogs.gif +share/doc/pgsql/src/graphics/clientserver.ag +share/doc/pgsql/src/graphics/clientserver.gif +share/doc/pgsql/src/graphics/connections.ag +share/doc/pgsql/src/graphics/connections.gif +share/doc/pgsql/src/graphics/layout.ag +share/doc/pgsql/src/graphics/layout.gif +share/doc/pgsql/src/sgml/Makefile +share/doc/pgsql/src/sgml/admin.sgml +share/doc/pgsql/src/sgml/advanced.sgml +share/doc/pgsql/src/sgml/arch-dev.sgml +share/doc/pgsql/src/sgml/arch-pg.sgml +share/doc/pgsql/src/sgml/arch.sgml +share/doc/pgsql/src/sgml/array.sgml +share/doc/pgsql/src/sgml/biblio.sgml +share/doc/pgsql/src/sgml/compiler.sgml +share/doc/pgsql/src/sgml/contacts.sgml +share/doc/pgsql/src/sgml/datatype.sgml +share/doc/pgsql/src/sgml/dfunc.sgml +share/doc/pgsql/src/sgml/docguide.sgml +share/doc/pgsql/src/sgml/ecpg.sgml +share/doc/pgsql/src/sgml/environ.sgml +share/doc/pgsql/src/sgml/extend.sgml +share/doc/pgsql/src/sgml/func-ref.sgml +share/doc/pgsql/src/sgml/geqo.sgml +share/doc/pgsql/src/sgml/gist.sgml +share/doc/pgsql/src/sgml/inherit.sgml +share/doc/pgsql/src/sgml/install.sgml +share/doc/pgsql/src/sgml/intro-pg.sgml +share/doc/pgsql/src/sgml/intro.sgml +share/doc/pgsql/src/sgml/jdbc.sgml +share/doc/pgsql/src/sgml/libpgtcl.sgml +share/doc/pgsql/src/sgml/libpq.sgml +share/doc/pgsql/src/sgml/lobj.sgml +share/doc/pgsql/src/sgml/manage.sgml +share/doc/pgsql/src/sgml/odbc.sgml +share/doc/pgsql/src/sgml/pgaccess.sgml +share/doc/pgsql/src/sgml/ports.sgml +share/doc/pgsql/src/sgml/postgres.sgml +share/doc/pgsql/src/sgml/programmer.sgml +share/doc/pgsql/src/sgml/protocol.sgml +share/doc/pgsql/src/sgml/psql.sgml +share/doc/pgsql/src/sgml/query-ug.sgml +share/doc/pgsql/src/sgml/query.sgml +share/doc/pgsql/src/sgml/recovery.sgml +share/doc/pgsql/src/sgml/regress.sgml +share/doc/pgsql/src/sgml/release.sgml +share/doc/pgsql/src/sgml/rules.sgml +share/doc/pgsql/src/sgml/spi.sgml +share/doc/pgsql/src/sgml/start-ag.sgml +share/doc/pgsql/src/sgml/start.sgml +share/doc/pgsql/src/sgml/storage.sgml +share/doc/pgsql/src/sgml/trigger.sgml +share/doc/pgsql/src/sgml/tutorial.sgml +share/doc/pgsql/src/sgml/user.sgml +share/doc/pgsql/src/sgml/xaggr.sgml +share/doc/pgsql/src/sgml/xfunc.sgml +share/doc/pgsql/src/sgml/xindex.sgml +share/doc/pgsql/src/sgml/xoper.sgml +share/doc/pgsql/src/sgml/xtypes.sgml +share/doc/pgsql/tutorial.ps.gz +share/doc/pgsql/tutorial.tar.gz +share/doc/pgsql/user.ps.gz +share/doc/pgsql/user.tar.gz share/doc/pgsql/userguide.ps -@dirrm share/doc/pgsql/manual +@dirrm share/doc/pgsql/src/graphics +@dirrm share/doc/pgsql/src/sgml +@dirrm share/doc/pgsql/src @dirrm share/doc/pgsql @dirrm pgsql/bin @dirrm pgsql/data/base/template1 @dirrm pgsql/data/base @dirrm pgsql/data @dirrm pgsql/include/access +@dirrm pgsql/include/commands +@dirrm pgsql/include/executor @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq -@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port/bsd @dirrm pgsql/include/port @dirrm pgsql/include/utils @dirrm pgsql/include diff --git a/databases/postgresql91-server/Makefile b/databases/postgresql91-server/Makefile index 0cc83efe5fc4..476257fd2ee4 100644 --- a/databases/postgresql91-server/Makefile +++ b/databases/postgresql91-server/Makefile @@ -3,11 +3,13 @@ # Date created: April 2, 1997 # Whom: Marc G. Fournier # -# $Id: Makefile,v 1.22 1997/12/24 01:21:37 alex Exp $ +# $Id: Makefile,v 1.23 1998/03/22 16:45:18 andreas Exp $ -DISTNAME= postgresql-6.2.1 +PATCH_DEBUG= yes + +DISTNAME= postgresql-6.3.2 CATEGORIES= databases -MASTER_SITES= http://www.freebsd.org/~andreas/download/ +MASTER_SITES= ftp://ftp.postgresql.org/pub/ MAINTAINER= andreas@FreeBSD.ORG @@ -16,6 +18,7 @@ MAINTAINER= andreas@FreeBSD.ORG .if defined(USE_TCL) MAKE_ENV= USE_TCL=true TCL_INCDIR=${PREFIX}/include/tcl8.0 LIB_DEPENDS= tcl80\\.1\\.:${PORTSDIR}/lang/tcl80 +WITH_TCL= --with-tcl .endif NO_PACKAGE= "Requires pgsql uid" @@ -26,26 +29,28 @@ MAKEFILE= GNUmakefile 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]'` \ + --with-includes=/usr/local/include ${WITH_TCL} \ + --with-libraries=/usr/local/lib MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ - destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + destroyuser.1 ecpg.1 initdb.1 ipcclean.1 initlocation.1 \ + pg_dump.1 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 \ +MANL= abort.l alter_table.l alter_user.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_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 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 + create_function.l create_index.l create_language.l \ + create_operator.l create_rule.l create_sequence.l \ + create_table.l create_trigger.l create_type.l create_user.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_language.l drop_operator.l drop_rule.l drop_sequence.l \ + drop_table.l drop_trigger.l drop_type.l drop_user.l \ + drop_view.l end.l explain.l fetch.l grant.l insert.l listen.l \ + load.l lock.l move.l notify.l reset.l revoke.l \ + rollback.l select.l set.l show.l sql.l update.l vacuum.l MANPREFIX= ${PREFIX}/pgsql diff --git a/databases/postgresql91-server/distinfo b/databases/postgresql91-server/distinfo index 5d42f88c853a..dc42f89ecf8d 100644 --- a/databases/postgresql91-server/distinfo +++ b/databases/postgresql91-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-6.2.1.tar.gz) = bd606dcab6b09a3a3d276d88b504a1d3 +MD5 (postgresql-6.3.2.tar.gz) = 8902842461c9a42854ba9883bee56a4c diff --git a/databases/postgresql91-server/files/pgsql.sh.tmpl b/databases/postgresql91-server/files/pgsql.sh.tmpl index 9fd81e4ff367..ed6c54d18839 100644 --- a/databases/postgresql91-server/files/pgsql.sh.tmpl +++ b/databases/postgresql91-server/files/pgsql.sh.tmpl @@ -1,6 +1,6 @@ #!/bin/sh -# $Id: pgsql.sh.tmpl,v 1.2 1997/10/03 18:26:54 andreas Exp $ +# $Id: pgsql.sh.tmpl,v 1.3 1997/10/05 21:00:49 andreas Exp $ # pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) @@ -19,7 +19,7 @@ [ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib [ -x !!PREFIX!!/pgsql/bin/postmaster ] && { - su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster \ - -S -o -F > !!PREFIX!!/pgsql/errlog' + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster -i -S -o -F \ + -D!!PREFIX!!/pgsql/data > !!PREFIX!!/pgsql/errlog' echo -n ' pgsql' } diff --git a/databases/postgresql91-server/pkg-plist b/databases/postgresql91-server/pkg-plist index 985c0a47ac30..5e5936ec028e 100644 --- a/databases/postgresql91-server/pkg-plist +++ b/databases/postgresql91-server/pkg-plist @@ -5,7 +5,10 @@ pgsql/bin/createdb pgsql/bin/createuser pgsql/bin/destroydb pgsql/bin/destroyuser +pgsql/bin/ecpg pgsql/bin/initdb +pgsql/bin/initlocation +pgsql/bin/ipcclean pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id @@ -14,7 +17,6 @@ pgsql/bin/pg_version pgsql/bin/pgtclsh pgsql/bin/pgtksh pgsql/bin/postgres -pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -22,15 +24,17 @@ pgsql/data/base/template1/pg_aggregate pgsql/data/base/template1/pg_am 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_attrdef_adrelid_index pgsql/data/base/template1/pg_attribute +pgsql/data/base/template1/pg_attribute_attrelid_index +pgsql/data/base/template1/pg_attribute_relid_attnam_index +pgsql/data/base/template1/pg_attribute_relid_attnum_index pgsql/data/base/template1/pg_class -pgsql/data/base/template1/pg_classnameind -pgsql/data/base/template1/pg_classoidind +pgsql/data/base/template1/pg_class_oid_index +pgsql/data/base/template1/pg_class_relname_index +pgsql/data/base/template1/pg_description +pgsql/data/base/template1/pg_description_objoid_index pgsql/data/base/template1/pg_index pgsql/data/base/template1/pg_inheritproc pgsql/data/base/template1/pg_inherits @@ -42,35 +46,36 @@ pgsql/data/base/template1/pg_opclass pgsql/data/base/template1/pg_operator pgsql/data/base/template1/pg_parg 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_proc_oid_index +pgsql/data/base/template1/pg_proc_proname_index +pgsql/data/base/template1/pg_proc_prosrc_index pgsql/data/base/template1/pg_relcheck -pgsql/data/base/template1/pg_relcheckind +pgsql/data/base/template1/pg_relcheck_rcrelid_index 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_trigger_tgrelid_index pgsql/data/base/template1/pg_type -pgsql/data/base/template1/pg_typeidind -pgsql/data/base/template1/pg_typenameind +pgsql/data/base/template1/pg_type_oid_index +pgsql/data/base/template1/pg_type_typname_index +pgsql/data/base/template1/pg_user pgsql/data/base/template1/pg_version pgsql/data/pg_database -pgsql/data/pg_defaults -pgsql/data/pg_demon pgsql/data/pg_geqo.sample pgsql/data/pg_group pgsql/data/pg_hba.conf -pgsql/data/pg_hosts pgsql/data/pg_log -pgsql/data/pg_magic -pgsql/data/pg_server -pgsql/data/pg_time -pgsql/data/pg_user +pgsql/data/pg_pwd +pgsql/data/pg_shadow pgsql/data/pg_variable +pgsql/errlog pgsql/include/access/attnum.h pgsql/include/c.h +pgsql/include/commands/trigger.h pgsql/include/config.h +pgsql/include/ecpglib.h +pgsql/include/ecpgtype.h +pgsql/include/executor/spi.h pgsql/include/fmgr.h pgsql/include/lib/dllist.h pgsql/include/libpgtcl.h @@ -80,17 +85,20 @@ pgsql/include/libpq/pqcomm.h pgsql/include/os.h pgsql/include/postgres.h pgsql/include/postgres_ext.h +pgsql/include/sqlca.h pgsql/include/utils/elog.h pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source +pgsql/lib/global1.description +pgsql/lib/libecpg.a +pgsql/lib/libecpg.so.1.1 pgsql/lib/libpgtcl.a -pgsql/lib/libpgtcl.so pgsql/lib/libpgtcl.so.1.0 pgsql/lib/libpq.a -pgsql/lib/libpq.so -pgsql/lib/libpq.so.1.0 +pgsql/lib/libpq.so.1.1 pgsql/lib/local1_template1.bki.source +pgsql/lib/local1_template1.description pgsql/lib/pg_geqo.sample pgsql/lib/pg_hba.conf.sample pgsql/man/man1/cleardbdir.1.gz @@ -98,9 +106,10 @@ pgsql/man/man1/createdb.1.gz pgsql/man/man1/createuser.1.gz pgsql/man/man1/destroydb.1.gz pgsql/man/man1/destroyuser.1.gz +pgsql/man/man1/ecpg.1.gz pgsql/man/man1/initdb.1.gz +pgsql/man/man1/initlocation.1.gz 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 @@ -118,6 +127,7 @@ pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz pgsql/man/manl/abort.l.gz pgsql/man/manl/alter_table.l.gz +pgsql/man/manl/alter_user.l.gz pgsql/man/manl/begin.l.gz pgsql/man/manl/close.l.gz pgsql/man/manl/cluster.l.gz @@ -127,12 +137,14 @@ pgsql/man/manl/create_aggregate.l.gz pgsql/man/manl/create_database.l.gz pgsql/man/manl/create_function.l.gz pgsql/man/manl/create_index.l.gz +pgsql/man/manl/create_language.l.gz 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_user.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz pgsql/man/manl/declare.l.gz @@ -142,12 +154,14 @@ pgsql/man/manl/drop_aggregate.l.gz pgsql/man/manl/drop_database.l.gz pgsql/man/manl/drop_function.l.gz pgsql/man/manl/drop_index.l.gz +pgsql/man/manl/drop_language.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_user.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz pgsql/man/manl/explain.l.gz @@ -156,10 +170,9 @@ 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/lock.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 pgsql/man/manl/reset.l.gz pgsql/man/manl/revoke.l.gz pgsql/man/manl/rollback.l.gz @@ -171,51 +184,104 @@ pgsql/man/manl/update.l.gz pgsql/man/manl/vacuum.l.gz pgsql/post-install-notes share/doc/pgsql/FAQ -share/doc/pgsql/FAQ-Irix -share/doc/pgsql/FAQ-Linux +share/doc/pgsql/FAQ_FreeBSD +share/doc/pgsql/FAQ_Irix +share/doc/pgsql/FAQ_Linux +share/doc/pgsql/Makefile share/doc/pgsql/README.GEQO share/doc/pgsql/README.fsync +share/doc/pgsql/README.mb +share/doc/pgsql/README.mb.jp share/doc/pgsql/README.support share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO +share/doc/pgsql/admin.ps.gz +share/doc/pgsql/admin.tar.gz 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/postgres.tar.gz +share/doc/pgsql/programmer.ps.gz +share/doc/pgsql/programmer.tar.gz +share/doc/pgsql/src/Makefile +share/doc/pgsql/src/graphics/catalogs.gif +share/doc/pgsql/src/graphics/clientserver.ag +share/doc/pgsql/src/graphics/clientserver.gif +share/doc/pgsql/src/graphics/connections.ag +share/doc/pgsql/src/graphics/connections.gif +share/doc/pgsql/src/graphics/layout.ag +share/doc/pgsql/src/graphics/layout.gif +share/doc/pgsql/src/sgml/Makefile +share/doc/pgsql/src/sgml/admin.sgml +share/doc/pgsql/src/sgml/advanced.sgml +share/doc/pgsql/src/sgml/arch-dev.sgml +share/doc/pgsql/src/sgml/arch-pg.sgml +share/doc/pgsql/src/sgml/arch.sgml +share/doc/pgsql/src/sgml/array.sgml +share/doc/pgsql/src/sgml/biblio.sgml +share/doc/pgsql/src/sgml/compiler.sgml +share/doc/pgsql/src/sgml/contacts.sgml +share/doc/pgsql/src/sgml/datatype.sgml +share/doc/pgsql/src/sgml/dfunc.sgml +share/doc/pgsql/src/sgml/docguide.sgml +share/doc/pgsql/src/sgml/ecpg.sgml +share/doc/pgsql/src/sgml/environ.sgml +share/doc/pgsql/src/sgml/extend.sgml +share/doc/pgsql/src/sgml/func-ref.sgml +share/doc/pgsql/src/sgml/geqo.sgml +share/doc/pgsql/src/sgml/gist.sgml +share/doc/pgsql/src/sgml/inherit.sgml +share/doc/pgsql/src/sgml/install.sgml +share/doc/pgsql/src/sgml/intro-pg.sgml +share/doc/pgsql/src/sgml/intro.sgml +share/doc/pgsql/src/sgml/jdbc.sgml +share/doc/pgsql/src/sgml/libpgtcl.sgml +share/doc/pgsql/src/sgml/libpq.sgml +share/doc/pgsql/src/sgml/lobj.sgml +share/doc/pgsql/src/sgml/manage.sgml +share/doc/pgsql/src/sgml/odbc.sgml +share/doc/pgsql/src/sgml/pgaccess.sgml +share/doc/pgsql/src/sgml/ports.sgml +share/doc/pgsql/src/sgml/postgres.sgml +share/doc/pgsql/src/sgml/programmer.sgml +share/doc/pgsql/src/sgml/protocol.sgml +share/doc/pgsql/src/sgml/psql.sgml +share/doc/pgsql/src/sgml/query-ug.sgml +share/doc/pgsql/src/sgml/query.sgml +share/doc/pgsql/src/sgml/recovery.sgml +share/doc/pgsql/src/sgml/regress.sgml +share/doc/pgsql/src/sgml/release.sgml +share/doc/pgsql/src/sgml/rules.sgml +share/doc/pgsql/src/sgml/spi.sgml +share/doc/pgsql/src/sgml/start-ag.sgml +share/doc/pgsql/src/sgml/start.sgml +share/doc/pgsql/src/sgml/storage.sgml +share/doc/pgsql/src/sgml/trigger.sgml +share/doc/pgsql/src/sgml/tutorial.sgml +share/doc/pgsql/src/sgml/user.sgml +share/doc/pgsql/src/sgml/xaggr.sgml +share/doc/pgsql/src/sgml/xfunc.sgml +share/doc/pgsql/src/sgml/xindex.sgml +share/doc/pgsql/src/sgml/xoper.sgml +share/doc/pgsql/src/sgml/xtypes.sgml +share/doc/pgsql/tutorial.ps.gz +share/doc/pgsql/tutorial.tar.gz +share/doc/pgsql/user.ps.gz +share/doc/pgsql/user.tar.gz share/doc/pgsql/userguide.ps -@dirrm share/doc/pgsql/manual +@dirrm share/doc/pgsql/src/graphics +@dirrm share/doc/pgsql/src/sgml +@dirrm share/doc/pgsql/src @dirrm share/doc/pgsql @dirrm pgsql/bin @dirrm pgsql/data/base/template1 @dirrm pgsql/data/base @dirrm pgsql/data @dirrm pgsql/include/access +@dirrm pgsql/include/commands +@dirrm pgsql/include/executor @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq -@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port/bsd @dirrm pgsql/include/port @dirrm pgsql/include/utils @dirrm pgsql/include diff --git a/databases/postgresql92-server/Makefile b/databases/postgresql92-server/Makefile index 0cc83efe5fc4..476257fd2ee4 100644 --- a/databases/postgresql92-server/Makefile +++ b/databases/postgresql92-server/Makefile @@ -3,11 +3,13 @@ # Date created: April 2, 1997 # Whom: Marc G. Fournier # -# $Id: Makefile,v 1.22 1997/12/24 01:21:37 alex Exp $ +# $Id: Makefile,v 1.23 1998/03/22 16:45:18 andreas Exp $ -DISTNAME= postgresql-6.2.1 +PATCH_DEBUG= yes + +DISTNAME= postgresql-6.3.2 CATEGORIES= databases -MASTER_SITES= http://www.freebsd.org/~andreas/download/ +MASTER_SITES= ftp://ftp.postgresql.org/pub/ MAINTAINER= andreas@FreeBSD.ORG @@ -16,6 +18,7 @@ MAINTAINER= andreas@FreeBSD.ORG .if defined(USE_TCL) MAKE_ENV= USE_TCL=true TCL_INCDIR=${PREFIX}/include/tcl8.0 LIB_DEPENDS= tcl80\\.1\\.:${PORTSDIR}/lang/tcl80 +WITH_TCL= --with-tcl .endif NO_PACKAGE= "Requires pgsql uid" @@ -26,26 +29,28 @@ MAKEFILE= GNUmakefile 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]'` \ + --with-includes=/usr/local/include ${WITH_TCL} \ + --with-libraries=/usr/local/lib MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \ - destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \ - pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \ + destroyuser.1 ecpg.1 initdb.1 ipcclean.1 initlocation.1 \ + pg_dump.1 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 \ +MANL= abort.l alter_table.l alter_user.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_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 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 + create_function.l create_index.l create_language.l \ + create_operator.l create_rule.l create_sequence.l \ + create_table.l create_trigger.l create_type.l create_user.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_language.l drop_operator.l drop_rule.l drop_sequence.l \ + drop_table.l drop_trigger.l drop_type.l drop_user.l \ + drop_view.l end.l explain.l fetch.l grant.l insert.l listen.l \ + load.l lock.l move.l notify.l reset.l revoke.l \ + rollback.l select.l set.l show.l sql.l update.l vacuum.l MANPREFIX= ${PREFIX}/pgsql diff --git a/databases/postgresql92-server/distinfo b/databases/postgresql92-server/distinfo index 5d42f88c853a..dc42f89ecf8d 100644 --- a/databases/postgresql92-server/distinfo +++ b/databases/postgresql92-server/distinfo @@ -1 +1 @@ -MD5 (postgresql-6.2.1.tar.gz) = bd606dcab6b09a3a3d276d88b504a1d3 +MD5 (postgresql-6.3.2.tar.gz) = 8902842461c9a42854ba9883bee56a4c diff --git a/databases/postgresql92-server/files/pgsql.sh.tmpl b/databases/postgresql92-server/files/pgsql.sh.tmpl index 9fd81e4ff367..ed6c54d18839 100644 --- a/databases/postgresql92-server/files/pgsql.sh.tmpl +++ b/databases/postgresql92-server/files/pgsql.sh.tmpl @@ -1,6 +1,6 @@ #!/bin/sh -# $Id: pgsql.sh.tmpl,v 1.2 1997/10/03 18:26:54 andreas Exp $ +# $Id: pgsql.sh.tmpl,v 1.3 1997/10/05 21:00:49 andreas Exp $ # pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested) @@ -19,7 +19,7 @@ [ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib [ -x !!PREFIX!!/pgsql/bin/postmaster ] && { - su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster \ - -S -o -F > !!PREFIX!!/pgsql/errlog' + su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster -i -S -o -F \ + -D!!PREFIX!!/pgsql/data > !!PREFIX!!/pgsql/errlog' echo -n ' pgsql' } diff --git a/databases/postgresql92-server/pkg-plist b/databases/postgresql92-server/pkg-plist index 985c0a47ac30..5e5936ec028e 100644 --- a/databases/postgresql92-server/pkg-plist +++ b/databases/postgresql92-server/pkg-plist @@ -5,7 +5,10 @@ pgsql/bin/createdb pgsql/bin/createuser pgsql/bin/destroydb pgsql/bin/destroyuser +pgsql/bin/ecpg pgsql/bin/initdb +pgsql/bin/initlocation +pgsql/bin/ipcclean pgsql/bin/pg_dump pgsql/bin/pg_dumpall pgsql/bin/pg_id @@ -14,7 +17,6 @@ pgsql/bin/pg_version pgsql/bin/pgtclsh pgsql/bin/pgtksh pgsql/bin/postgres -pgsql/bin/postmaster pgsql/bin/psql pgsql/data/PG_VERSION pgsql/data/base/template1/PG_VERSION @@ -22,15 +24,17 @@ pgsql/data/base/template1/pg_aggregate pgsql/data/base/template1/pg_am 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_attrdef_adrelid_index pgsql/data/base/template1/pg_attribute +pgsql/data/base/template1/pg_attribute_attrelid_index +pgsql/data/base/template1/pg_attribute_relid_attnam_index +pgsql/data/base/template1/pg_attribute_relid_attnum_index pgsql/data/base/template1/pg_class -pgsql/data/base/template1/pg_classnameind -pgsql/data/base/template1/pg_classoidind +pgsql/data/base/template1/pg_class_oid_index +pgsql/data/base/template1/pg_class_relname_index +pgsql/data/base/template1/pg_description +pgsql/data/base/template1/pg_description_objoid_index pgsql/data/base/template1/pg_index pgsql/data/base/template1/pg_inheritproc pgsql/data/base/template1/pg_inherits @@ -42,35 +46,36 @@ pgsql/data/base/template1/pg_opclass pgsql/data/base/template1/pg_operator pgsql/data/base/template1/pg_parg 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_proc_oid_index +pgsql/data/base/template1/pg_proc_proname_index +pgsql/data/base/template1/pg_proc_prosrc_index pgsql/data/base/template1/pg_relcheck -pgsql/data/base/template1/pg_relcheckind +pgsql/data/base/template1/pg_relcheck_rcrelid_index 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_trigger_tgrelid_index pgsql/data/base/template1/pg_type -pgsql/data/base/template1/pg_typeidind -pgsql/data/base/template1/pg_typenameind +pgsql/data/base/template1/pg_type_oid_index +pgsql/data/base/template1/pg_type_typname_index +pgsql/data/base/template1/pg_user pgsql/data/base/template1/pg_version pgsql/data/pg_database -pgsql/data/pg_defaults -pgsql/data/pg_demon pgsql/data/pg_geqo.sample pgsql/data/pg_group pgsql/data/pg_hba.conf -pgsql/data/pg_hosts pgsql/data/pg_log -pgsql/data/pg_magic -pgsql/data/pg_server -pgsql/data/pg_time -pgsql/data/pg_user +pgsql/data/pg_pwd +pgsql/data/pg_shadow pgsql/data/pg_variable +pgsql/errlog pgsql/include/access/attnum.h pgsql/include/c.h +pgsql/include/commands/trigger.h pgsql/include/config.h +pgsql/include/ecpglib.h +pgsql/include/ecpgtype.h +pgsql/include/executor/spi.h pgsql/include/fmgr.h pgsql/include/lib/dllist.h pgsql/include/libpgtcl.h @@ -80,17 +85,20 @@ pgsql/include/libpq/pqcomm.h pgsql/include/os.h pgsql/include/postgres.h pgsql/include/postgres_ext.h +pgsql/include/sqlca.h pgsql/include/utils/elog.h pgsql/include/utils/geo_decls.h pgsql/include/utils/palloc.h pgsql/lib/global1.bki.source +pgsql/lib/global1.description +pgsql/lib/libecpg.a +pgsql/lib/libecpg.so.1.1 pgsql/lib/libpgtcl.a -pgsql/lib/libpgtcl.so pgsql/lib/libpgtcl.so.1.0 pgsql/lib/libpq.a -pgsql/lib/libpq.so -pgsql/lib/libpq.so.1.0 +pgsql/lib/libpq.so.1.1 pgsql/lib/local1_template1.bki.source +pgsql/lib/local1_template1.description pgsql/lib/pg_geqo.sample pgsql/lib/pg_hba.conf.sample pgsql/man/man1/cleardbdir.1.gz @@ -98,9 +106,10 @@ pgsql/man/man1/createdb.1.gz pgsql/man/man1/createuser.1.gz pgsql/man/man1/destroydb.1.gz pgsql/man/man1/destroyuser.1.gz +pgsql/man/man1/ecpg.1.gz pgsql/man/man1/initdb.1.gz +pgsql/man/man1/initlocation.1.gz 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 @@ -118,6 +127,7 @@ pgsql/man/man5/page.5.gz pgsql/man/man5/pg_hba.conf.5.gz pgsql/man/manl/abort.l.gz pgsql/man/manl/alter_table.l.gz +pgsql/man/manl/alter_user.l.gz pgsql/man/manl/begin.l.gz pgsql/man/manl/close.l.gz pgsql/man/manl/cluster.l.gz @@ -127,12 +137,14 @@ pgsql/man/manl/create_aggregate.l.gz pgsql/man/manl/create_database.l.gz pgsql/man/manl/create_function.l.gz pgsql/man/manl/create_index.l.gz +pgsql/man/manl/create_language.l.gz 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_user.l.gz pgsql/man/manl/create_version.l.gz pgsql/man/manl/create_view.l.gz pgsql/man/manl/declare.l.gz @@ -142,12 +154,14 @@ pgsql/man/manl/drop_aggregate.l.gz pgsql/man/manl/drop_database.l.gz pgsql/man/manl/drop_function.l.gz pgsql/man/manl/drop_index.l.gz +pgsql/man/manl/drop_language.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_user.l.gz pgsql/man/manl/drop_view.l.gz pgsql/man/manl/end.l.gz pgsql/man/manl/explain.l.gz @@ -156,10 +170,9 @@ 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/lock.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 pgsql/man/manl/reset.l.gz pgsql/man/manl/revoke.l.gz pgsql/man/manl/rollback.l.gz @@ -171,51 +184,104 @@ pgsql/man/manl/update.l.gz pgsql/man/manl/vacuum.l.gz pgsql/post-install-notes share/doc/pgsql/FAQ -share/doc/pgsql/FAQ-Irix -share/doc/pgsql/FAQ-Linux +share/doc/pgsql/FAQ_FreeBSD +share/doc/pgsql/FAQ_Irix +share/doc/pgsql/FAQ_Linux +share/doc/pgsql/Makefile share/doc/pgsql/README.GEQO share/doc/pgsql/README.fsync +share/doc/pgsql/README.mb +share/doc/pgsql/README.mb.jp share/doc/pgsql/README.support share/doc/pgsql/TODO share/doc/pgsql/TODO.GEQO +share/doc/pgsql/admin.ps.gz +share/doc/pgsql/admin.tar.gz 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/postgres.tar.gz +share/doc/pgsql/programmer.ps.gz +share/doc/pgsql/programmer.tar.gz +share/doc/pgsql/src/Makefile +share/doc/pgsql/src/graphics/catalogs.gif +share/doc/pgsql/src/graphics/clientserver.ag +share/doc/pgsql/src/graphics/clientserver.gif +share/doc/pgsql/src/graphics/connections.ag +share/doc/pgsql/src/graphics/connections.gif +share/doc/pgsql/src/graphics/layout.ag +share/doc/pgsql/src/graphics/layout.gif +share/doc/pgsql/src/sgml/Makefile +share/doc/pgsql/src/sgml/admin.sgml +share/doc/pgsql/src/sgml/advanced.sgml +share/doc/pgsql/src/sgml/arch-dev.sgml +share/doc/pgsql/src/sgml/arch-pg.sgml +share/doc/pgsql/src/sgml/arch.sgml +share/doc/pgsql/src/sgml/array.sgml +share/doc/pgsql/src/sgml/biblio.sgml +share/doc/pgsql/src/sgml/compiler.sgml +share/doc/pgsql/src/sgml/contacts.sgml +share/doc/pgsql/src/sgml/datatype.sgml +share/doc/pgsql/src/sgml/dfunc.sgml +share/doc/pgsql/src/sgml/docguide.sgml +share/doc/pgsql/src/sgml/ecpg.sgml +share/doc/pgsql/src/sgml/environ.sgml +share/doc/pgsql/src/sgml/extend.sgml +share/doc/pgsql/src/sgml/func-ref.sgml +share/doc/pgsql/src/sgml/geqo.sgml +share/doc/pgsql/src/sgml/gist.sgml +share/doc/pgsql/src/sgml/inherit.sgml +share/doc/pgsql/src/sgml/install.sgml +share/doc/pgsql/src/sgml/intro-pg.sgml +share/doc/pgsql/src/sgml/intro.sgml +share/doc/pgsql/src/sgml/jdbc.sgml +share/doc/pgsql/src/sgml/libpgtcl.sgml +share/doc/pgsql/src/sgml/libpq.sgml +share/doc/pgsql/src/sgml/lobj.sgml +share/doc/pgsql/src/sgml/manage.sgml +share/doc/pgsql/src/sgml/odbc.sgml +share/doc/pgsql/src/sgml/pgaccess.sgml +share/doc/pgsql/src/sgml/ports.sgml +share/doc/pgsql/src/sgml/postgres.sgml +share/doc/pgsql/src/sgml/programmer.sgml +share/doc/pgsql/src/sgml/protocol.sgml +share/doc/pgsql/src/sgml/psql.sgml +share/doc/pgsql/src/sgml/query-ug.sgml +share/doc/pgsql/src/sgml/query.sgml +share/doc/pgsql/src/sgml/recovery.sgml +share/doc/pgsql/src/sgml/regress.sgml +share/doc/pgsql/src/sgml/release.sgml +share/doc/pgsql/src/sgml/rules.sgml +share/doc/pgsql/src/sgml/spi.sgml +share/doc/pgsql/src/sgml/start-ag.sgml +share/doc/pgsql/src/sgml/start.sgml +share/doc/pgsql/src/sgml/storage.sgml +share/doc/pgsql/src/sgml/trigger.sgml +share/doc/pgsql/src/sgml/tutorial.sgml +share/doc/pgsql/src/sgml/user.sgml +share/doc/pgsql/src/sgml/xaggr.sgml +share/doc/pgsql/src/sgml/xfunc.sgml +share/doc/pgsql/src/sgml/xindex.sgml +share/doc/pgsql/src/sgml/xoper.sgml +share/doc/pgsql/src/sgml/xtypes.sgml +share/doc/pgsql/tutorial.ps.gz +share/doc/pgsql/tutorial.tar.gz +share/doc/pgsql/user.ps.gz +share/doc/pgsql/user.tar.gz share/doc/pgsql/userguide.ps -@dirrm share/doc/pgsql/manual +@dirrm share/doc/pgsql/src/graphics +@dirrm share/doc/pgsql/src/sgml +@dirrm share/doc/pgsql/src @dirrm share/doc/pgsql @dirrm pgsql/bin @dirrm pgsql/data/base/template1 @dirrm pgsql/data/base @dirrm pgsql/data @dirrm pgsql/include/access +@dirrm pgsql/include/commands +@dirrm pgsql/include/executor @dirrm pgsql/include/include @dirrm pgsql/include/lib @dirrm pgsql/include/libpq -@dirrm pgsql/include/port/BSD44_derived +@dirrm pgsql/include/port/bsd @dirrm pgsql/include/port @dirrm pgsql/include/utils @dirrm pgsql/include -- cgit v1.2.3