summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorjdolecek <jdolecek>2005-02-06 12:32:05 +0000
committerjdolecek <jdolecek>2005-02-06 12:32:05 +0000
commit3a9529421f2a318513742c6050f06cb608487488 (patch)
treeca025c7eef396d233c2e4340a7c68a2a92ecf72b
parent0ec7cadf09691474a4437fb7ee5f484198022130 (diff)
downloadpkgsrc-3a9529421f2a318513742c6050f06cb608487488.tar.gz
PostgreSQL 8.0.1 packages. A dump/restore using pg_dump is required
for those wishing to migrate data from any previous release. Major changes relative to 7.4.x: * Savepoints * Point-in-Time recovery * Tablespaces * Improved buffer management * ALTER TABLE column management improvements Full list of changes is available at: http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0 Also note that PostgreSQL server listens also on localhost (127.0.0.1) by default now.
-rw-r--r--databases/postgresql80-client/DESCR9
-rw-r--r--databases/postgresql80-client/Makefile38
-rw-r--r--databases/postgresql80-client/PLIST294
-rw-r--r--databases/postgresql80-client/files/man.exclude7
-rw-r--r--databases/postgresql80-docs/DESCR9
-rw-r--r--databases/postgresql80-docs/Makefile32
-rw-r--r--databases/postgresql80-docs/PLIST640
-rw-r--r--databases/postgresql80-lib/DESCR9
-rw-r--r--databases/postgresql80-lib/Makefile61
-rw-r--r--databases/postgresql80-lib/PLIST438
-rw-r--r--databases/postgresql80-lib/buildlink3.mk26
-rw-r--r--databases/postgresql80-lib/files/man.lib3
-rw-r--r--databases/postgresql80-server/DEINSTALL20
-rw-r--r--databases/postgresql80-server/DESCR9
-rw-r--r--databases/postgresql80-server/MESSAGE19
-rw-r--r--databases/postgresql80-server/Makefile80
-rw-r--r--databases/postgresql80-server/PLIST61
-rw-r--r--databases/postgresql80-server/files/man.server4
-rw-r--r--databases/postgresql80-server/files/pgsql.sh142
-rw-r--r--databases/postgresql80/DESCR9
-rw-r--r--databases/postgresql80/Makefile19
-rw-r--r--databases/postgresql80/Makefile.common117
-rw-r--r--databases/postgresql80/PLIST2
-rw-r--r--databases/postgresql80/distinfo5
-rw-r--r--databases/postgresql80/files/GNUmakefile.libpgtcl20
-rw-r--r--databases/postgresql80/files/GNUmakefile.libpq20
-rw-r--r--databases/postgresql80/files/Makefile.custom15
-rw-r--r--databases/postgresql80/files/netbsd.c73
-rw-r--r--databases/postgresql80/files/netbsd.h45
-rw-r--r--databases/postgresql80/patches/patch-aa31
30 files changed, 2257 insertions, 0 deletions
diff --git a/databases/postgresql80-client/DESCR b/databases/postgresql80-client/DESCR
new file mode 100644
index 00000000000..a485664e6f1
--- /dev/null
+++ b/databases/postgresql80-client/DESCR
@@ -0,0 +1,9 @@
+PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS),
+derived from the Berkeley Postgres database management system. While
+PostgreSQL retains the powerful object-relational data model, rich data types
+and easy extensibility of Postgres, it replaces the PostQuel query language
+with an extended subset of SQL.
+
+PostgreSQL is free and the complete source is available.
+
+This package contains the database client programs.
diff --git a/databases/postgresql80-client/Makefile b/databases/postgresql80-client/Makefile
new file mode 100644
index 00000000000..9ef65f164ed
--- /dev/null
+++ b/databases/postgresql80-client/Makefile
@@ -0,0 +1,38 @@
+# $NetBSD: Makefile,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $
+
+PKGNAME= postgresql80-client-${BASE_VERS}
+PKGREVISION= # empty
+COMMENT= PostgreSQL database client programs
+
+.include "../../wip/postgresql80/Makefile.common"
+
+# XXX work around core dumps with the native libedit
+USE_GNU_READLINE= yes
+
+CONFIGURE_ARGS+= --with-openssl
+CONFIGURE_ARGS+= --with-zlib
+CONFIGURE_ARGS+= --with-readline
+MAKE_ENV+= INSTALLED_LIBPQ=1
+
+BUILD_DIRS= ${WRKSRC}/src/bin
+
+pre-build:
+ ${_PKG_SILENT}${_PKG_DEBUG}${_ULIMIT_CMD}cd ${WRKSRC}/src/backend && \
+ ${SETENV} ${MAKE_ENV} ${MAKE_PROGRAM} ${BUILD_MAKE_FLAGS} \
+ ../../src/include/parser/parse.h ../../src/include/utils/fmgroids.h
+
+post-install:
+ ${EGREP} -v "^#" ${FILESDIR}/man.exclude > ${WRKDIR}/man_tar_exclude
+ ${TAR} -zxm -C ${PG_DIR}/man -X ${WRKDIR}/man_tar_exclude \
+ -f ${WRKSRC}/doc/man.tar.gz
+
+.include "../../mk/bsd.prefs.mk"
+.if ${OPSYS} == "FreeBSD" && ${LOWER_OPSYS_VERSUFFIX} == "4"
+USE_GNU_READLINE=yes
+.endif
+
+.include "../../wip/postgresql80-lib/buildlink3.mk"
+.include "../../devel/readline/buildlink3.mk"
+.include "../../devel/zlib/buildlink3.mk"
+
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql80-client/PLIST b/databases/postgresql80-client/PLIST
new file mode 100644
index 00000000000..cd3afb02600
--- /dev/null
+++ b/databases/postgresql80-client/PLIST
@@ -0,0 +1,294 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $
+bin/clusterdb
+bin/createdb
+bin/createlang
+bin/createuser
+bin/dropdb
+bin/droplang
+bin/dropuser
+bin/initdb
+bin/ipcclean
+bin/pg_config
+bin/pg_controldata
+bin/pg_ctl
+bin/pg_dump
+bin/pg_dumpall
+bin/pg_resetxlog
+bin/pg_restore
+bin/psql
+bin/vacuumdb
+man/man1/clusterdb.1
+man/man1/createdb.1
+man/man1/createlang.1
+man/man1/createuser.1
+man/man1/dropdb.1
+man/man1/droplang.1
+man/man1/dropuser.1
+man/man1/initdb.1
+man/man1/ipcclean.1
+man/man1/pg_config.1
+man/man1/pg_controldata.1
+man/man1/pg_ctl.1
+man/man1/pg_dump.1
+man/man1/pg_dumpall.1
+man/man1/pg_resetxlog.1
+man/man1/pg_restore.1
+man/man1/vacuumdb.1
+man/manl/abort.l
+man/manl/alter_aggregate.l
+man/manl/alter_conversion.l
+man/manl/alter_database.l
+man/manl/alter_domain.l
+man/manl/alter_function.l
+man/manl/alter_group.l
+man/manl/alter_index.l
+man/manl/alter_language.l
+man/manl/alter_operator.l
+man/manl/alter_operator_class.l
+man/manl/alter_schema.l
+man/manl/alter_sequence.l
+man/manl/alter_table.l
+man/manl/alter_trigger.l
+man/manl/alter_type.l
+man/manl/alter_user.l
+man/manl/analyze.l
+man/manl/begin.l
+man/manl/checkpoint.l
+man/manl/close.l
+man/manl/cluster.l
+man/manl/comment.l
+man/manl/commit.l
+man/manl/copy.l
+man/manl/create_aggregate.l
+man/manl/create_cast.l
+man/manl/create_constraint_trigger.l
+man/manl/create_conversion.l
+man/manl/create_database.l
+man/manl/create_domain.l
+man/manl/create_function.l
+man/manl/create_group.l
+man/manl/create_index.l
+man/manl/create_language.l
+man/manl/create_operator.l
+man/manl/create_operator_class.l
+man/manl/create_rule.l
+man/manl/create_schema.l
+man/manl/create_sequence.l
+man/manl/create_table.l
+man/manl/create_table_as.l
+man/manl/create_tablespace.l
+man/manl/create_trigger.l
+man/manl/create_type.l
+man/manl/create_user.l
+man/manl/create_view.l
+man/manl/deallocate.l
+man/manl/declare.l
+man/manl/delete.l
+man/manl/drop_aggregate.l
+man/manl/drop_cast.l
+man/manl/drop_conversion.l
+man/manl/drop_database.l
+man/manl/drop_domain.l
+man/manl/drop_function.l
+man/manl/drop_group.l
+man/manl/drop_index.l
+man/manl/drop_language.l
+man/manl/drop_operator.l
+man/manl/drop_operator_class.l
+man/manl/drop_rule.l
+man/manl/drop_schema.l
+man/manl/drop_sequence.l
+man/manl/drop_table.l
+man/manl/drop_tablespace.l
+man/manl/drop_trigger.l
+man/manl/drop_type.l
+man/manl/drop_user.l
+man/manl/drop_view.l
+man/manl/end.l
+man/manl/execute.l
+man/manl/explain.l
+man/manl/fetch.l
+man/manl/grant.l
+man/manl/insert.l
+man/manl/listen.l
+man/manl/load.l
+man/manl/lock.l
+man/manl/move.l
+man/manl/notify.l
+man/manl/prepare.l
+man/manl/reindex.l
+man/manl/release_savepoint.l
+man/manl/reset.l
+man/manl/revoke.l
+man/manl/rollback.l
+man/manl/rollback_to_savepoint.l
+man/manl/savepoint.l
+man/manl/select.l
+man/manl/select_into.l
+man/manl/set.l
+man/manl/set_constraints.l
+man/manl/set_session_authorization.l
+man/manl/set_transaction.l
+man/manl/show.l
+man/manl/spi_connect.l
+man/manl/spi_copytuple.l
+man/manl/spi_cursor_close.l
+man/manl/spi_cursor_fetch.l
+man/manl/spi_cursor_find.l
+man/manl/spi_cursor_move.l
+man/manl/spi_cursor_open.l
+man/manl/spi_exec.l
+man/manl/spi_execp.l
+man/manl/spi_execute.l
+man/manl/spi_execute_plan.l
+man/manl/spi_finish.l
+man/manl/spi_fname.l
+man/manl/spi_fnumber.l
+man/manl/spi_freeplan.l
+man/manl/spi_freetuple.l
+man/manl/spi_freetuptable.l
+man/manl/spi_getargcount.l
+man/manl/spi_getargtypeid.l
+man/manl/spi_getbinval.l
+man/manl/spi_getrelname.l
+man/manl/spi_gettype.l
+man/manl/spi_gettypeid.l
+man/manl/spi_getvalue.l
+man/manl/spi_is_cursor_plan.l
+man/manl/spi_modifytuple.l
+man/manl/spi_palloc.l
+man/manl/spi_pfree.l
+man/manl/spi_pop.l
+man/manl/spi_prepare.l
+man/manl/spi_push.l
+man/manl/spi_repalloc.l
+man/manl/spi_returntuple.l
+man/manl/spi_saveplan.l
+man/manl/start_transaction.l
+man/manl/truncate.l
+man/manl/unlisten.l
+man/manl/update.l
+man/manl/vacuum.l
+${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/initdb.mo
+${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/pg_config.mo
+${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/pg_controldata.mo
+${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/pg_ctl.mo
+${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/pg_dump.mo
+${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/pg_resetxlog.mo
+${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/pgscripts.mo
+${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/psql.mo
+${PKGLOCALEDIR}/locale/de/LC_MESSAGES/initdb.mo
+${PKGLOCALEDIR}/locale/de/LC_MESSAGES/pg_config.mo
+${PKGLOCALEDIR}/locale/de/LC_MESSAGES/pg_controldata.mo
+${PKGLOCALEDIR}/locale/de/LC_MESSAGES/pg_ctl.mo
+${PKGLOCALEDIR}/locale/de/LC_MESSAGES/pg_dump.mo
+${PKGLOCALEDIR}/locale/de/LC_MESSAGES/pg_resetxlog.mo
+${PKGLOCALEDIR}/locale/de/LC_MESSAGES/pgscripts.mo
+${PKGLOCALEDIR}/locale/de/LC_MESSAGES/psql.mo
+${PKGLOCALEDIR}/locale/es/LC_MESSAGES/initdb.mo
+${PKGLOCALEDIR}/locale/es/LC_MESSAGES/pg_config.mo
+${PKGLOCALEDIR}/locale/es/LC_MESSAGES/pg_ctl.mo
+${PKGLOCALEDIR}/locale/es/LC_MESSAGES/pg_dump.mo
+${PKGLOCALEDIR}/locale/es/LC_MESSAGES/pg_resetxlog.mo
+${PKGLOCALEDIR}/locale/es/LC_MESSAGES/pgscripts.mo
+${PKGLOCALEDIR}/locale/es/LC_MESSAGES/psql.mo
+${PKGLOCALEDIR}/locale/fa/LC_MESSAGES/pg_controldata.mo
+${PKGLOCALEDIR}/locale/fa/LC_MESSAGES/psql.mo
+${PKGLOCALEDIR}/locale/fr/LC_MESSAGES/initdb.mo
+${PKGLOCALEDIR}/locale/fr/LC_MESSAGES/pg_config.mo
+${PKGLOCALEDIR}/locale/fr/LC_MESSAGES/pg_controldata.mo
+${PKGLOCALEDIR}/locale/fr/LC_MESSAGES/pg_ctl.mo
+${PKGLOCALEDIR}/locale/fr/LC_MESSAGES/pg_dump.mo
+${PKGLOCALEDIR}/locale/fr/LC_MESSAGES/pg_resetxlog.mo
+${PKGLOCALEDIR}/locale/fr/LC_MESSAGES/pgscripts.mo
+${PKGLOCALEDIR}/locale/fr/LC_MESSAGES/psql.mo
+${PKGLOCALEDIR}/locale/hu/LC_MESSAGES/pg_controldata.mo
+${PKGLOCALEDIR}/locale/hu/LC_MESSAGES/pg_resetxlog.mo
+${PKGLOCALEDIR}/locale/hu/LC_MESSAGES/psql.mo
+${PKGLOCALEDIR}/locale/it/LC_MESSAGES/initdb.mo
+${PKGLOCALEDIR}/locale/it/LC_MESSAGES/pg_controldata.mo
+${PKGLOCALEDIR}/locale/it/LC_MESSAGES/pg_dump.mo
+${PKGLOCALEDIR}/locale/it/LC_MESSAGES/pg_resetxlog.mo
+${PKGLOCALEDIR}/locale/it/LC_MESSAGES/pgscripts.mo
+${PKGLOCALEDIR}/locale/it/LC_MESSAGES/psql.mo
+${PKGLOCALEDIR}/locale/ko/LC_MESSAGES/initdb.mo
+${PKGLOCALEDIR}/locale/ko/LC_MESSAGES/pg_config.mo
+${PKGLOCALEDIR}/locale/ko/LC_MESSAGES/pg_controldata.mo
+${PKGLOCALEDIR}/locale/ko/LC_MESSAGES/pg_ctl.mo
+${PKGLOCALEDIR}/locale/ko/LC_MESSAGES/pg_resetxlog.mo
+${PKGLOCALEDIR}/locale/ko/LC_MESSAGES/pgscripts.mo
+${PKGLOCALEDIR}/locale/nb/LC_MESSAGES/pg_controldata.mo
+${PKGLOCALEDIR}/locale/nb/LC_MESSAGES/pg_dump.mo
+${PKGLOCALEDIR}/locale/nb/LC_MESSAGES/pg_resetxlog.mo
+${PKGLOCALEDIR}/locale/nb/LC_MESSAGES/psql.mo
+${PKGLOCALEDIR}/locale/pl/LC_MESSAGES/initdb.mo
+${PKGLOCALEDIR}/locale/pl/LC_MESSAGES/pg_config.mo
+${PKGLOCALEDIR}/locale/pl/LC_MESSAGES/pg_controldata.mo
+${PKGLOCALEDIR}/locale/pt_BR/LC_MESSAGES/initdb.mo
+${PKGLOCALEDIR}/locale/pt_BR/LC_MESSAGES/pg_config.mo
+${PKGLOCALEDIR}/locale/pt_BR/LC_MESSAGES/pg_controldata.mo
+${PKGLOCALEDIR}/locale/pt_BR/LC_MESSAGES/pg_ctl.mo
+${PKGLOCALEDIR}/locale/pt_BR/LC_MESSAGES/pg_dump.mo
+${PKGLOCALEDIR}/locale/pt_BR/LC_MESSAGES/pg_resetxlog.mo
+${PKGLOCALEDIR}/locale/pt_BR/LC_MESSAGES/pgscripts.mo
+${PKGLOCALEDIR}/locale/pt_BR/LC_MESSAGES/psql.mo
+${PKGLOCALEDIR}/locale/ru/LC_MESSAGES/initdb.mo
+${PKGLOCALEDIR}/locale/ru/LC_MESSAGES/pg_config.mo
+${PKGLOCALEDIR}/locale/ru/LC_MESSAGES/pg_controldata.mo
+${PKGLOCALEDIR}/locale/ru/LC_MESSAGES/pg_ctl.mo
+${PKGLOCALEDIR}/locale/ru/LC_MESSAGES/pg_dump.mo
+${PKGLOCALEDIR}/locale/ru/LC_MESSAGES/pg_resetxlog.mo
+${PKGLOCALEDIR}/locale/ru/LC_MESSAGES/pgscripts.mo
+${PKGLOCALEDIR}/locale/ru/LC_MESSAGES/psql.mo
+${PKGLOCALEDIR}/locale/sk/LC_MESSAGES/initdb.mo
+${PKGLOCALEDIR}/locale/sk/LC_MESSAGES/pg_controldata.mo
+${PKGLOCALEDIR}/locale/sk/LC_MESSAGES/pg_ctl.mo
+${PKGLOCALEDIR}/locale/sk/LC_MESSAGES/pg_dump.mo
+${PKGLOCALEDIR}/locale/sk/LC_MESSAGES/pg_resetxlog.mo
+${PKGLOCALEDIR}/locale/sk/LC_MESSAGES/pgscripts.mo
+${PKGLOCALEDIR}/locale/sk/LC_MESSAGES/psql.mo
+${PKGLOCALEDIR}/locale/sl/LC_MESSAGES/initdb.mo
+${PKGLOCALEDIR}/locale/sl/LC_MESSAGES/pg_config.mo
+${PKGLOCALEDIR}/locale/sl/LC_MESSAGES/pg_controldata.mo
+${PKGLOCALEDIR}/locale/sl/LC_MESSAGES/pg_ctl.mo
+${PKGLOCALEDIR}/locale/sl/LC_MESSAGES/pg_dump.mo
+${PKGLOCALEDIR}/locale/sl/LC_MESSAGES/pg_resetxlog.mo
+${PKGLOCALEDIR}/locale/sl/LC_MESSAGES/pgscripts.mo
+${PKGLOCALEDIR}/locale/sl/LC_MESSAGES/psql.mo
+${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/initdb.mo
+${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/pg_config.mo
+${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/pg_controldata.mo
+${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/pg_ctl.mo
+${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/pg_dump.mo
+${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/pg_resetxlog.mo
+${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/pgscripts.mo
+${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/psql.mo
+${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/initdb.mo
+${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/pg_config.mo
+${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/pg_controldata.mo
+${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/pg_ctl.mo
+${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/pg_dump.mo
+${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/pg_resetxlog.mo
+${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/pgscripts.mo
+${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/psql.mo
+${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/initdb.mo
+${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/pg_config.mo
+${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/pg_controldata.mo
+${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/pg_ctl.mo
+${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/pg_dump.mo
+${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/pg_resetxlog.mo
+${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/pgscripts.mo
+${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/psql.mo
+${PKGLOCALEDIR}/locale/zh_TW/LC_MESSAGES/initdb.mo
+${PKGLOCALEDIR}/locale/zh_TW/LC_MESSAGES/pg_config.mo
+${PKGLOCALEDIR}/locale/zh_TW/LC_MESSAGES/pg_controldata.mo
+${PKGLOCALEDIR}/locale/zh_TW/LC_MESSAGES/pg_ctl.mo
+${PKGLOCALEDIR}/locale/zh_TW/LC_MESSAGES/pg_dump.mo
+${PKGLOCALEDIR}/locale/zh_TW/LC_MESSAGES/pg_resetxlog.mo
+${PKGLOCALEDIR}/locale/zh_TW/LC_MESSAGES/pgscripts.mo
+${PKGLOCALEDIR}/locale/zh_TW/LC_MESSAGES/psql.mo
+share/postgresql/psqlrc.sample
+@comment in postgresql80-lib: @dirrm man/man1
+@comment in postgresql80-lib: @dirrm man
+@comment in postgresql80-lib: @dirrm bin
+@comment in postgresql80-lib: @dirrm share/postgresql
diff --git a/databases/postgresql80-client/files/man.exclude b/databases/postgresql80-client/files/man.exclude
new file mode 100644
index 00000000000..e28339c3ffa
--- /dev/null
+++ b/databases/postgresql80-client/files/man.exclude
@@ -0,0 +1,7 @@
+# $NetBSD: man.exclude,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $
+#
+man1/ecpg.1
+man1/pgtclsh.1
+man1/pgtksh.1
+man1/postgres.1
+man1/postmaster.1
diff --git a/databases/postgresql80-docs/DESCR b/databases/postgresql80-docs/DESCR
new file mode 100644
index 00000000000..89dd99e91c2
--- /dev/null
+++ b/databases/postgresql80-docs/DESCR
@@ -0,0 +1,9 @@
+PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS),
+derived from the Berkeley Postgres database management system. While
+PostgreSQL retains the powerful object-relational data model, rich data types
+and easy extensibility of Postgres, it replaces the PostQuel query language
+with an extended subset of SQL.
+
+PostgreSQL is free and the complete source is available.
+
+This package contains the database documentation.
diff --git a/databases/postgresql80-docs/Makefile b/databases/postgresql80-docs/Makefile
new file mode 100644
index 00000000000..938354cd5f7
--- /dev/null
+++ b/databases/postgresql80-docs/Makefile
@@ -0,0 +1,32 @@
+# $NetBSD: Makefile,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $
+
+PKGNAME= postgresql80-docs-${BASE_VERS}
+COMMENT= PostgreSQL database system documentation
+
+.include "../../wip/postgresql80/Makefile.common"
+
+NO_BUILD= yes
+NO_BUILDLINK= yes
+NO_CONFIGURE= yes
+
+#BUILD_DIRS= ${WRKSRC}/doc
+DOCDIR= ${PREFIX}/share/doc/postgresql80
+
+# The manpage documentation is installed with the relevant packages.
+#pre-build:
+# cd ${WRKSRC}/doc && ${RM} -f man.tar.gz
+
+do-install:
+ ${INSTALL_DATA_DIR} ${DOCDIR}
+ ${INSTALL_DATA_DIR} ${DOCDIR}/TODO.detail
+ cd ${WRKSRC}/doc; for file in \
+ FAQ* KNOWN_BUGS MISSING_FEATURES README.* TODO \
+ bug.template; \
+ do \
+ ${INSTALL_DATA} $${file} ${DOCDIR}/$${file}; \
+ done
+ cd ${WRKSRC}/doc/TODO.detail && \
+ ${PAX} -rwppm . ${DOCDIR}/TODO.detail
+ ${TAR} -zxm -C ${DOCDIR} -f ${WRKSRC}/doc/postgres.tar.gz
+
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql80-docs/PLIST b/databases/postgresql80-docs/PLIST
new file mode 100644
index 00000000000..e73bb73c722
--- /dev/null
+++ b/databases/postgresql80-docs/PLIST
@@ -0,0 +1,640 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $
+share/doc/postgresql80/FAQ
+share/doc/postgresql80/FAQ_AIX
+share/doc/postgresql80/FAQ_CYGWIN
+share/doc/postgresql80/FAQ_DEV
+share/doc/postgresql80/FAQ_HPUX
+share/doc/postgresql80/FAQ_IRIX
+share/doc/postgresql80/FAQ_MINGW
+share/doc/postgresql80/FAQ_QNX4
+share/doc/postgresql80/FAQ_SCO
+share/doc/postgresql80/FAQ_Solaris
+share/doc/postgresql80/FAQ_brazilian
+share/doc/postgresql80/FAQ_czech
+share/doc/postgresql80/FAQ_farsi
+share/doc/postgresql80/FAQ_french
+share/doc/postgresql80/FAQ_german
+share/doc/postgresql80/FAQ_hungarian
+share/doc/postgresql80/FAQ_japanese
+share/doc/postgresql80/FAQ_polish
+share/doc/postgresql80/FAQ_russian
+share/doc/postgresql80/FAQ_turkish
+share/doc/postgresql80/KNOWN_BUGS
+share/doc/postgresql80/LEGALNOTICE.html
+share/doc/postgresql80/MISSING_FEATURES
+share/doc/postgresql80/README.mb.big5
+share/doc/postgresql80/README.mb.jp
+share/doc/postgresql80/TODO
+share/doc/postgresql80/TODO.detail/README
+share/doc/postgresql80/TODO.detail/psql
+share/doc/postgresql80/TODO.detail/thread
+share/doc/postgresql80/TODO.detail/trigger
+share/doc/postgresql80/TODO.detail/update
+share/doc/postgresql80/TODO.detail/wal
+share/doc/postgresql80/admin.html
+share/doc/postgresql80/app-clusterdb.html
+share/doc/postgresql80/app-createdb.html
+share/doc/postgresql80/app-createlang.html
+share/doc/postgresql80/app-createuser.html
+share/doc/postgresql80/app-dropdb.html
+share/doc/postgresql80/app-droplang.html
+share/doc/postgresql80/app-dropuser.html
+share/doc/postgresql80/app-ecpg.html
+share/doc/postgresql80/app-initdb.html
+share/doc/postgresql80/app-ipcclean.html
+share/doc/postgresql80/app-pg-ctl.html
+share/doc/postgresql80/app-pg-dumpall.html
+share/doc/postgresql80/app-pgconfig.html
+share/doc/postgresql80/app-pgcontroldata.html
+share/doc/postgresql80/app-pgdump.html
+share/doc/postgresql80/app-pgresetxlog.html
+share/doc/postgresql80/app-pgrestore.html
+share/doc/postgresql80/app-postgres.html
+share/doc/postgresql80/app-postmaster.html
+share/doc/postgresql80/app-psql.html
+share/doc/postgresql80/app-vacuumdb.html
+share/doc/postgresql80/appendixes.html
+share/doc/postgresql80/applevel-consistency.html
+share/doc/postgresql80/arrays.html
+share/doc/postgresql80/auth-methods.html
+share/doc/postgresql80/backup-file.html
+share/doc/postgresql80/backup-online.html
+share/doc/postgresql80/backup.html
+share/doc/postgresql80/biblio.html
+share/doc/postgresql80/bki-commands.html
+share/doc/postgresql80/bki-example.html
+share/doc/postgresql80/bki.html
+share/doc/postgresql80/bookindex.html
+share/doc/postgresql80/bug-reporting.html
+share/doc/postgresql80/bug.template
+share/doc/postgresql80/catalog-pg-aggregate.html
+share/doc/postgresql80/catalog-pg-am.html
+share/doc/postgresql80/catalog-pg-amop.html
+share/doc/postgresql80/catalog-pg-amproc.html
+share/doc/postgresql80/catalog-pg-attrdef.html
+share/doc/postgresql80/catalog-pg-attribute.html
+share/doc/postgresql80/catalog-pg-cast.html
+share/doc/postgresql80/catalog-pg-class.html
+share/doc/postgresql80/catalog-pg-constraint.html
+share/doc/postgresql80/catalog-pg-conversion.html
+share/doc/postgresql80/catalog-pg-database.html
+share/doc/postgresql80/catalog-pg-depend.html
+share/doc/postgresql80/catalog-pg-description.html
+share/doc/postgresql80/catalog-pg-group.html
+share/doc/postgresql80/catalog-pg-index.html
+share/doc/postgresql80/catalog-pg-inherits.html
+share/doc/postgresql80/catalog-pg-language.html
+share/doc/postgresql80/catalog-pg-largeobject.html
+share/doc/postgresql80/catalog-pg-listener.html
+share/doc/postgresql80/catalog-pg-namespace.html
+share/doc/postgresql80/catalog-pg-opclass.html
+share/doc/postgresql80/catalog-pg-operator.html
+share/doc/postgresql80/catalog-pg-proc.html
+share/doc/postgresql80/catalog-pg-rewrite.html
+share/doc/postgresql80/catalog-pg-shadow.html
+share/doc/postgresql80/catalog-pg-statistic.html
+share/doc/postgresql80/catalog-pg-tablespace.html
+share/doc/postgresql80/catalog-pg-trigger.html
+share/doc/postgresql80/catalog-pg-type.html
+share/doc/postgresql80/catalogs.html
+share/doc/postgresql80/charset.html
+share/doc/postgresql80/client-authentication-problems.html
+share/doc/postgresql80/client-authentication.html
+share/doc/postgresql80/client-interfaces.html
+share/doc/postgresql80/connect-estab.html
+share/doc/postgresql80/creating-cluster.html
+share/doc/postgresql80/cvs-tree.html
+share/doc/postgresql80/cvs.html
+share/doc/postgresql80/cvsup.html
+share/doc/postgresql80/datatype-binary.html
+share/doc/postgresql80/datatype-bit.html
+share/doc/postgresql80/datatype-boolean.html
+share/doc/postgresql80/datatype-character.html
+share/doc/postgresql80/datatype-datetime.html
+share/doc/postgresql80/datatype-geometric.html
+share/doc/postgresql80/datatype-money.html
+share/doc/postgresql80/datatype-net-types.html
+share/doc/postgresql80/datatype-oid.html
+share/doc/postgresql80/datatype-pseudo.html
+share/doc/postgresql80/datatype.html
+share/doc/postgresql80/datetime-appendix.html
+share/doc/postgresql80/datetime-keywords.html
+share/doc/postgresql80/datetime-units-history.html
+share/doc/postgresql80/ddl-alter.html
+share/doc/postgresql80/ddl-constraints.html
+share/doc/postgresql80/ddl-default.html
+share/doc/postgresql80/ddl-depend.html
+share/doc/postgresql80/ddl-inherit.html
+share/doc/postgresql80/ddl-others.html
+share/doc/postgresql80/ddl-priv.html
+share/doc/postgresql80/ddl-schemas.html
+share/doc/postgresql80/ddl-system-columns.html
+share/doc/postgresql80/ddl.html
+share/doc/postgresql80/disk-full.html
+share/doc/postgresql80/diskusage.html
+share/doc/postgresql80/dml-delete.html
+share/doc/postgresql80/dml-update.html
+share/doc/postgresql80/dml.html
+share/doc/postgresql80/docguide-authoring.html
+share/doc/postgresql80/docguide-build.html
+share/doc/postgresql80/docguide-style.html
+share/doc/postgresql80/docguide-toolsets.html
+share/doc/postgresql80/docguide.html
+share/doc/postgresql80/ecpg-commands.html
+share/doc/postgresql80/ecpg-connect.html
+share/doc/postgresql80/ecpg-descriptors.html
+share/doc/postgresql80/ecpg-develop.html
+share/doc/postgresql80/ecpg-disconnect.html
+share/doc/postgresql80/ecpg-dynamic.html
+share/doc/postgresql80/ecpg-errors.html
+share/doc/postgresql80/ecpg-include.html
+share/doc/postgresql80/ecpg-library.html
+share/doc/postgresql80/ecpg-process.html
+share/doc/postgresql80/ecpg-set-connection.html
+share/doc/postgresql80/ecpg-variables.html
+share/doc/postgresql80/ecpg.html
+share/doc/postgresql80/errcodes-appendix.html
+share/doc/postgresql80/error-message-reporting.html
+share/doc/postgresql80/error-style-guide.html
+share/doc/postgresql80/examples.html
+share/doc/postgresql80/executor.html
+share/doc/postgresql80/explicit-joins.html
+share/doc/postgresql80/explicit-locking.html
+share/doc/postgresql80/extend-type-system.html
+share/doc/postgresql80/extend.html
+share/doc/postgresql80/extensibility.html
+share/doc/postgresql80/external-extensions.html
+share/doc/postgresql80/external-projects.html
+share/doc/postgresql80/features.html
+share/doc/postgresql80/functions-admin.html
+share/doc/postgresql80/functions-aggregate.html
+share/doc/postgresql80/functions-array.html
+share/doc/postgresql80/functions-binarystring.html
+share/doc/postgresql80/functions-bitstring.html
+share/doc/postgresql80/functions-comparison.html
+share/doc/postgresql80/functions-comparisons.html
+share/doc/postgresql80/functions-conditional.html
+share/doc/postgresql80/functions-datetime.html
+share/doc/postgresql80/functions-formatting.html
+share/doc/postgresql80/functions-geometry.html
+share/doc/postgresql80/functions-info.html
+share/doc/postgresql80/functions-matching.html
+share/doc/postgresql80/functions-math.html
+share/doc/postgresql80/functions-net.html
+share/doc/postgresql80/functions-sequence.html
+share/doc/postgresql80/functions-srf.html
+share/doc/postgresql80/functions-string.html
+share/doc/postgresql80/functions-subquery.html
+share/doc/postgresql80/functions.html
+share/doc/postgresql80/geqo-biblio.html
+share/doc/postgresql80/geqo-intro2.html
+share/doc/postgresql80/geqo-pg-intro.html
+share/doc/postgresql80/geqo.html
+share/doc/postgresql80/gist.html
+share/doc/postgresql80/groups.html
+share/doc/postgresql80/history.html
+share/doc/postgresql80/implementation.html
+share/doc/postgresql80/index.html
+share/doc/postgresql80/indexcost.html
+share/doc/postgresql80/indexes-examine.html
+share/doc/postgresql80/indexes-expressional.html
+share/doc/postgresql80/indexes-multicolumn.html
+share/doc/postgresql80/indexes-opclass.html
+share/doc/postgresql80/indexes-partial.html
+share/doc/postgresql80/indexes-types.html
+share/doc/postgresql80/indexes-unique.html
+share/doc/postgresql80/indexes.html
+share/doc/postgresql80/information-schema.html
+share/doc/postgresql80/infoschema-applicable-roles.html
+share/doc/postgresql80/infoschema-check-constraints.html
+share/doc/postgresql80/infoschema-column-domain-usage.html
+share/doc/postgresql80/infoschema-column-privileges.html
+share/doc/postgresql80/infoschema-column-udt-usage.html
+share/doc/postgresql80/infoschema-columns.html
+share/doc/postgresql80/infoschema-constraint-column-usage.html
+share/doc/postgresql80/infoschema-constraint-table-usage.html
+share/doc/postgresql80/infoschema-data-type-privileges.html
+share/doc/postgresql80/infoschema-datatypes.html
+share/doc/postgresql80/infoschema-domain-constraints.html
+share/doc/postgresql80/infoschema-domain-udt-usage.html
+share/doc/postgresql80/infoschema-domains.html
+share/doc/postgresql80/infoschema-element-types.html
+share/doc/postgresql80/infoschema-enabled-roles.html
+share/doc/postgresql80/infoschema-information-schema-catalog-name.html
+share/doc/postgresql80/infoschema-key-column-usage.html
+share/doc/postgresql80/infoschema-parameters.html
+share/doc/postgresql80/infoschema-referential-constraints.html
+share/doc/postgresql80/infoschema-role-column-grants.html
+share/doc/postgresql80/infoschema-role-routine-grants.html
+share/doc/postgresql80/infoschema-role-table-grants.html
+share/doc/postgresql80/infoschema-role-usage-grants.html
+share/doc/postgresql80/infoschema-routine-privileges.html
+share/doc/postgresql80/infoschema-routines.html
+share/doc/postgresql80/infoschema-schemata.html
+share/doc/postgresql80/infoschema-sql-features.html
+share/doc/postgresql80/infoschema-sql-implementation-info.html
+share/doc/postgresql80/infoschema-sql-languages.html
+share/doc/postgresql80/infoschema-sql-packages.html
+share/doc/postgresql80/infoschema-sql-sizing-profiles.html
+share/doc/postgresql80/infoschema-sql-sizing.html
+share/doc/postgresql80/infoschema-table-constraints.html
+share/doc/postgresql80/infoschema-table-privileges.html
+share/doc/postgresql80/infoschema-tables.html
+share/doc/postgresql80/infoschema-triggers.html
+share/doc/postgresql80/infoschema-usage-privileges.html
+share/doc/postgresql80/infoschema-view-column-usage.html
+share/doc/postgresql80/infoschema-view-table-usage.html
+share/doc/postgresql80/infoschema-views.html
+share/doc/postgresql80/install-getsource.html
+share/doc/postgresql80/install-post.html
+share/doc/postgresql80/install-procedure.html
+share/doc/postgresql80/install-requirements.html
+share/doc/postgresql80/install-upgrading.html
+share/doc/postgresql80/install-win32.html
+share/doc/postgresql80/installation.html
+share/doc/postgresql80/internals.html
+share/doc/postgresql80/kernel-resources.html
+share/doc/postgresql80/largeobjects.html
+share/doc/postgresql80/libpq-async.html
+share/doc/postgresql80/libpq-build.html
+share/doc/postgresql80/libpq-cancel.html
+share/doc/postgresql80/libpq-control.html
+share/doc/postgresql80/libpq-copy.html
+share/doc/postgresql80/libpq-envars.html
+share/doc/postgresql80/libpq-example.html
+share/doc/postgresql80/libpq-exec.html
+share/doc/postgresql80/libpq-fastpath.html
+share/doc/postgresql80/libpq-notice-processing.html
+share/doc/postgresql80/libpq-notify.html
+share/doc/postgresql80/libpq-pgpass.html
+share/doc/postgresql80/libpq-ssl.html
+share/doc/postgresql80/libpq-status.html
+share/doc/postgresql80/libpq-threading.html
+share/doc/postgresql80/libpq.html
+share/doc/postgresql80/limitations.html
+share/doc/postgresql80/lo-examplesect.html
+share/doc/postgresql80/lo-funcs.html
+share/doc/postgresql80/lo-implementation.html
+share/doc/postgresql80/lo-interfaces.html
+share/doc/postgresql80/locking-indexes.html
+share/doc/postgresql80/logfile-maintenance.html
+share/doc/postgresql80/maintenance.html
+share/doc/postgresql80/manage-ag-config.html
+share/doc/postgresql80/manage-ag-createdb.html
+share/doc/postgresql80/manage-ag-dropdb.html
+share/doc/postgresql80/manage-ag-tablespaces.html
+share/doc/postgresql80/manage-ag-templatedbs.html
+share/doc/postgresql80/managing-databases.html
+share/doc/postgresql80/migration.html
+share/doc/postgresql80/monitoring-locks.html
+share/doc/postgresql80/monitoring-stats.html
+share/doc/postgresql80/monitoring.html
+share/doc/postgresql80/multibyte.html
+share/doc/postgresql80/mvcc.html
+share/doc/postgresql80/nls-programmer.html
+share/doc/postgresql80/nls.html
+share/doc/postgresql80/notation.html
+share/doc/postgresql80/overview.html
+share/doc/postgresql80/parser-stage.html
+share/doc/postgresql80/performance-tips.html
+share/doc/postgresql80/perm-functions.html
+share/doc/postgresql80/planner-optimizer.html
+share/doc/postgresql80/planner-stats.html
+share/doc/postgresql80/plhandler.html
+share/doc/postgresql80/plperl-data.html
+share/doc/postgresql80/plperl-database.html
+share/doc/postgresql80/plperl-global.html
+share/doc/postgresql80/plperl-missing.html
+share/doc/postgresql80/plperl-triggers.html
+share/doc/postgresql80/plperl-trusted.html
+share/doc/postgresql80/plperl.html
+share/doc/postgresql80/plpgsql-control-structures.html
+share/doc/postgresql80/plpgsql-cursors.html
+share/doc/postgresql80/plpgsql-declarations.html
+share/doc/postgresql80/plpgsql-development-tips.html
+share/doc/postgresql80/plpgsql-errors-and-messages.html
+share/doc/postgresql80/plpgsql-expressions.html
+share/doc/postgresql80/plpgsql-porting.html
+share/doc/postgresql80/plpgsql-statements.html
+share/doc/postgresql80/plpgsql-structure.html
+share/doc/postgresql80/plpgsql-trigger.html
+share/doc/postgresql80/plpgsql.html
+share/doc/postgresql80/plpython-database.html
+share/doc/postgresql80/plpython-trigger.html
+share/doc/postgresql80/plpython.html
+share/doc/postgresql80/pltcl-data.html
+share/doc/postgresql80/pltcl-dbaccess.html
+share/doc/postgresql80/pltcl-functions.html
+share/doc/postgresql80/pltcl-global.html
+share/doc/postgresql80/pltcl-procnames.html
+share/doc/postgresql80/pltcl-trigger.html
+share/doc/postgresql80/pltcl-unknown.html
+share/doc/postgresql80/pltcl.html
+share/doc/postgresql80/populate.html
+share/doc/postgresql80/postmaster-shutdown.html
+share/doc/postgresql80/postmaster-start.html
+share/doc/postgresql80/preface.html
+share/doc/postgresql80/privileges.html
+share/doc/postgresql80/protocol-changes.html
+share/doc/postgresql80/protocol-error-fields.html
+share/doc/postgresql80/protocol-flow.html
+share/doc/postgresql80/protocol-message-formats.html
+share/doc/postgresql80/protocol-message-types.html
+share/doc/postgresql80/protocol.html
+share/doc/postgresql80/queries-limit.html
+share/doc/postgresql80/queries-order.html
+share/doc/postgresql80/queries-select-lists.html
+share/doc/postgresql80/queries-table-expressions.html
+share/doc/postgresql80/queries-union.html
+share/doc/postgresql80/queries.html
+share/doc/postgresql80/reference-client.html
+share/doc/postgresql80/reference-server.html
+share/doc/postgresql80/reference.html
+share/doc/postgresql80/regress-evaluation.html
+share/doc/postgresql80/regress-platform.html
+share/doc/postgresql80/regress.html
+share/doc/postgresql80/release-0-01.html
+share/doc/postgresql80/release-0-02.html
+share/doc/postgresql80/release-0-03.html
+share/doc/postgresql80/release-1-0.html
+share/doc/postgresql80/release-1-01.html
+share/doc/postgresql80/release-1-02.html
+share/doc/postgresql80/release-1-09.html
+share/doc/postgresql80/release-6-0.html
+share/doc/postgresql80/release-6-1-1.html
+share/doc/postgresql80/release-6-1.html
+share/doc/postgresql80/release-6-2-1.html
+share/doc/postgresql80/release-6-2.html
+share/doc/postgresql80/release-6-3-1.html
+share/doc/postgresql80/release-6-3-2.html
+share/doc/postgresql80/release-6-3.html
+share/doc/postgresql80/release-6-4-1.html
+share/doc/postgresql80/release-6-4-2.html
+share/doc/postgresql80/release-6-4.html
+share/doc/postgresql80/release-6-5-1.html
+share/doc/postgresql80/release-6-5-2.html
+share/doc/postgresql80/release-6-5-3.html
+share/doc/postgresql80/release-6-5.html
+share/doc/postgresql80/release-7-0-1.html
+share/doc/postgresql80/release-7-0-2.html
+share/doc/postgresql80/release-7-0-3.html
+share/doc/postgresql80/release-7-0.html
+share/doc/postgresql80/release-7-1-1.html
+share/doc/postgresql80/release-7-1-2.html
+share/doc/postgresql80/release-7-1-3.html
+share/doc/postgresql80/release-7-1.html
+share/doc/postgresql80/release-7-2-1.html
+share/doc/postgresql80/release-7-2-2.html
+share/doc/postgresql80/release-7-2-3.html
+share/doc/postgresql80/release-7-2-4.html
+share/doc/postgresql80/release-7-2-5.html
+share/doc/postgresql80/release-7-2-6.html
+share/doc/postgresql80/release-7-2-7.html
+share/doc/postgresql80/release-7-2.html
+share/doc/postgresql80/release-7-3-1.html
+share/doc/postgresql80/release-7-3-2.html
+share/doc/postgresql80/release-7-3-3.html
+share/doc/postgresql80/release-7-3-4.html
+share/doc/postgresql80/release-7-3-5.html
+share/doc/postgresql80/release-7-3-6.html
+share/doc/postgresql80/release-7-3-7.html
+share/doc/postgresql80/release-7-3-8.html
+share/doc/postgresql80/release-7-3-9.html
+share/doc/postgresql80/release-7-3.html
+share/doc/postgresql80/release-7-4-1.html
+share/doc/postgresql80/release-7-4-2.html
+share/doc/postgresql80/release-7-4-3.html
+share/doc/postgresql80/release-7-4-4.html
+share/doc/postgresql80/release-7-4-5.html
+share/doc/postgresql80/release-7-4-6.html
+share/doc/postgresql80/release-7-4-7.html
+share/doc/postgresql80/release-7-4.html
+share/doc/postgresql80/release-8-0.html
+share/doc/postgresql80/release.html
+share/doc/postgresql80/resources.html
+share/doc/postgresql80/routine-reindex.html
+share/doc/postgresql80/rowtypes.html
+share/doc/postgresql80/rule-system.html
+share/doc/postgresql80/rules-privileges.html
+share/doc/postgresql80/rules-status.html
+share/doc/postgresql80/rules-triggers.html
+share/doc/postgresql80/rules-update.html
+share/doc/postgresql80/rules-views.html
+share/doc/postgresql80/rules.html
+share/doc/postgresql80/runtime-config.html
+share/doc/postgresql80/runtime.html
+share/doc/postgresql80/server-programming.html
+share/doc/postgresql80/source.html
+share/doc/postgresql80/spi-examples.html
+share/doc/postgresql80/spi-interface-support.html
+share/doc/postgresql80/spi-memory.html
+share/doc/postgresql80/spi-realloc.html
+share/doc/postgresql80/spi-spi-connect.html
+share/doc/postgresql80/spi-spi-copytuple.html
+share/doc/postgresql80/spi-spi-cursor-close.html
+share/doc/postgresql80/spi-spi-cursor-fetch.html
+share/doc/postgresql80/spi-spi-cursor-find.html
+share/doc/postgresql80/spi-spi-cursor-move.html
+share/doc/postgresql80/spi-spi-cursor-open.html
+share/doc/postgresql80/spi-spi-exec.html
+share/doc/postgresql80/spi-spi-execp.html
+share/doc/postgresql80/spi-spi-execute-plan.html
+share/doc/postgresql80/spi-spi-execute.html
+share/doc/postgresql80/spi-spi-finish.html
+share/doc/postgresql80/spi-spi-fname.html
+share/doc/postgresql80/spi-spi-fnumber.html
+share/doc/postgresql80/spi-spi-freeplan.html
+share/doc/postgresql80/spi-spi-freetuple.html
+share/doc/postgresql80/spi-spi-freetupletable.html
+share/doc/postgresql80/spi-spi-getargcount.html
+share/doc/postgresql80/spi-spi-getargtypeid.html
+share/doc/postgresql80/spi-spi-getbinval.html
+share/doc/postgresql80/spi-spi-getrelname.html
+share/doc/postgresql80/spi-spi-gettype.html
+share/doc/postgresql80/spi-spi-gettypeid.html
+share/doc/postgresql80/spi-spi-getvalue.html
+share/doc/postgresql80/spi-spi-is-cursor-plan.html
+share/doc/postgresql80/spi-spi-modifytuple.html
+share/doc/postgresql80/spi-spi-palloc.html
+share/doc/postgresql80/spi-spi-pfree.html
+share/doc/postgresql80/spi-spi-pop.html
+share/doc/postgresql80/spi-spi-prepare.html
+share/doc/postgresql80/spi-spi-push.html
+share/doc/postgresql80/spi-spi-returntuple.html
+share/doc/postgresql80/spi-spi-saveplan.html
+share/doc/postgresql80/spi-visibility.html
+share/doc/postgresql80/spi.html
+share/doc/postgresql80/sql-abort.html
+share/doc/postgresql80/sql-alteraggregate.html
+share/doc/postgresql80/sql-alterconversion.html
+share/doc/postgresql80/sql-alterdatabase.html
+share/doc/postgresql80/sql-alterdomain.html
+share/doc/postgresql80/sql-alterfunction.html
+share/doc/postgresql80/sql-altergroup.html
+share/doc/postgresql80/sql-alterindex.html
+share/doc/postgresql80/sql-alterlanguage.html
+share/doc/postgresql80/sql-alteropclass.html
+share/doc/postgresql80/sql-alteroperator.html
+share/doc/postgresql80/sql-alterschema.html
+share/doc/postgresql80/sql-altersequence.html
+share/doc/postgresql80/sql-altertable.html
+share/doc/postgresql80/sql-altertablespace.html
+share/doc/postgresql80/sql-altertrigger.html
+share/doc/postgresql80/sql-altertype.html
+share/doc/postgresql80/sql-alteruser.html
+share/doc/postgresql80/sql-analyze.html
+share/doc/postgresql80/sql-begin.html
+share/doc/postgresql80/sql-checkpoint.html
+share/doc/postgresql80/sql-close.html
+share/doc/postgresql80/sql-cluster.html
+share/doc/postgresql80/sql-commands.html
+share/doc/postgresql80/sql-comment.html
+share/doc/postgresql80/sql-commit.html
+share/doc/postgresql80/sql-copy.html
+share/doc/postgresql80/sql-createaggregate.html
+share/doc/postgresql80/sql-createcast.html
+share/doc/postgresql80/sql-createconstraint.html
+share/doc/postgresql80/sql-createconversion.html
+share/doc/postgresql80/sql-createdatabase.html
+share/doc/postgresql80/sql-createdomain.html
+share/doc/postgresql80/sql-createfunction.html
+share/doc/postgresql80/sql-creategroup.html
+share/doc/postgresql80/sql-createindex.html
+share/doc/postgresql80/sql-createlanguage.html
+share/doc/postgresql80/sql-createopclass.html
+share/doc/postgresql80/sql-createoperator.html
+share/doc/postgresql80/sql-createrule.html
+share/doc/postgresql80/sql-createschema.html
+share/doc/postgresql80/sql-createsequence.html
+share/doc/postgresql80/sql-createtable.html
+share/doc/postgresql80/sql-createtableas.html
+share/doc/postgresql80/sql-createtablespace.html
+share/doc/postgresql80/sql-createtrigger.html
+share/doc/postgresql80/sql-createtype.html
+share/doc/postgresql80/sql-createuser.html
+share/doc/postgresql80/sql-createview.html
+share/doc/postgresql80/sql-deallocate.html
+share/doc/postgresql80/sql-declare.html
+share/doc/postgresql80/sql-delete.html
+share/doc/postgresql80/sql-dropaggregate.html
+share/doc/postgresql80/sql-dropcast.html
+share/doc/postgresql80/sql-dropconversion.html
+share/doc/postgresql80/sql-dropdatabase.html
+share/doc/postgresql80/sql-dropdomain.html
+share/doc/postgresql80/sql-dropfunction.html
+share/doc/postgresql80/sql-dropgroup.html
+share/doc/postgresql80/sql-dropindex.html
+share/doc/postgresql80/sql-droplanguage.html
+share/doc/postgresql80/sql-dropopclass.html
+share/doc/postgresql80/sql-dropoperator.html
+share/doc/postgresql80/sql-droprule.html
+share/doc/postgresql80/sql-dropschema.html
+share/doc/postgresql80/sql-dropsequence.html
+share/doc/postgresql80/sql-droptable.html
+share/doc/postgresql80/sql-droptablespace.html
+share/doc/postgresql80/sql-droptrigger.html
+share/doc/postgresql80/sql-droptype.html
+share/doc/postgresql80/sql-dropuser.html
+share/doc/postgresql80/sql-dropview.html
+share/doc/postgresql80/sql-end.html
+share/doc/postgresql80/sql-execute.html
+share/doc/postgresql80/sql-explain.html
+share/doc/postgresql80/sql-expressions.html
+share/doc/postgresql80/sql-fetch.html
+share/doc/postgresql80/sql-grant.html
+share/doc/postgresql80/sql-insert.html
+share/doc/postgresql80/sql-keywords-appendix.html
+share/doc/postgresql80/sql-listen.html
+share/doc/postgresql80/sql-load.html
+share/doc/postgresql80/sql-lock.html
+share/doc/postgresql80/sql-move.html
+share/doc/postgresql80/sql-notify.html
+share/doc/postgresql80/sql-prepare.html
+share/doc/postgresql80/sql-reindex.html
+share/doc/postgresql80/sql-release-savepoint.html
+share/doc/postgresql80/sql-reset.html
+share/doc/postgresql80/sql-revoke.html
+share/doc/postgresql80/sql-rollback-to.html
+share/doc/postgresql80/sql-rollback.html
+share/doc/postgresql80/sql-savepoint.html
+share/doc/postgresql80/sql-select.html
+share/doc/postgresql80/sql-selectinto.html
+share/doc/postgresql80/sql-set-constraints.html
+share/doc/postgresql80/sql-set-session-authorization.html
+share/doc/postgresql80/sql-set-transaction.html
+share/doc/postgresql80/sql-set.html
+share/doc/postgresql80/sql-show.html
+share/doc/postgresql80/sql-start-transaction.html
+share/doc/postgresql80/sql-syntax.html
+share/doc/postgresql80/sql-truncate.html
+share/doc/postgresql80/sql-unlisten.html
+share/doc/postgresql80/sql-update.html
+share/doc/postgresql80/sql-vacuum.html
+share/doc/postgresql80/sql.html
+share/doc/postgresql80/ssh-tunnels.html
+share/doc/postgresql80/ssl-tcp.html
+share/doc/postgresql80/storage-page-layout.html
+share/doc/postgresql80/storage-toast.html
+share/doc/postgresql80/storage.html
+share/doc/postgresql80/stylesheet.css
+share/doc/postgresql80/supported-platforms.html
+share/doc/postgresql80/transaction-iso.html
+share/doc/postgresql80/trigger-datachanges.html
+share/doc/postgresql80/trigger-example.html
+share/doc/postgresql80/trigger-interface.html
+share/doc/postgresql80/triggers.html
+share/doc/postgresql80/tutorial-accessdb.html
+share/doc/postgresql80/tutorial-advanced.html
+share/doc/postgresql80/tutorial-agg.html
+share/doc/postgresql80/tutorial-arch.html
+share/doc/postgresql80/tutorial-concepts.html
+share/doc/postgresql80/tutorial-conclusion.html
+share/doc/postgresql80/tutorial-createdb.html
+share/doc/postgresql80/tutorial-delete.html
+share/doc/postgresql80/tutorial-fk.html
+share/doc/postgresql80/tutorial-inheritance.html
+share/doc/postgresql80/tutorial-join.html
+share/doc/postgresql80/tutorial-populate.html
+share/doc/postgresql80/tutorial-select.html
+share/doc/postgresql80/tutorial-sql.html
+share/doc/postgresql80/tutorial-start.html
+share/doc/postgresql80/tutorial-table.html
+share/doc/postgresql80/tutorial-transactions.html
+share/doc/postgresql80/tutorial-update.html
+share/doc/postgresql80/tutorial-views.html
+share/doc/postgresql80/tutorial.html
+share/doc/postgresql80/typeconv-func.html
+share/doc/postgresql80/typeconv-oper.html
+share/doc/postgresql80/typeconv-query.html
+share/doc/postgresql80/typeconv-union-case.html
+share/doc/postgresql80/typeconv.html
+share/doc/postgresql80/unsupported-features-sql-standard.html
+share/doc/postgresql80/user-attributes.html
+share/doc/postgresql80/user-manag.html
+share/doc/postgresql80/view-pg-indexes.html
+share/doc/postgresql80/view-pg-locks.html
+share/doc/postgresql80/view-pg-rules.html
+share/doc/postgresql80/view-pg-settings.html
+share/doc/postgresql80/view-pg-stats.html
+share/doc/postgresql80/view-pg-tables.html
+share/doc/postgresql80/view-pg-user.html
+share/doc/postgresql80/view-pg-views.html
+share/doc/postgresql80/views-overview.html
+share/doc/postgresql80/wal-configuration.html
+share/doc/postgresql80/wal-internals.html
+share/doc/postgresql80/wal.html
+share/doc/postgresql80/xaggr.html
+share/doc/postgresql80/xfunc-c.html
+share/doc/postgresql80/xfunc-internal.html
+share/doc/postgresql80/xfunc-overload.html
+share/doc/postgresql80/xfunc-pl.html
+share/doc/postgresql80/xfunc-sql.html
+share/doc/postgresql80/xfunc-volatility.html
+share/doc/postgresql80/xfunc.html
+share/doc/postgresql80/xindex.html
+share/doc/postgresql80/xoper-optimization.html
+share/doc/postgresql80/xoper.html
+share/doc/postgresql80/xplang.html
+share/doc/postgresql80/xtypes.html
+@dirrm share/doc/postgresql80/TODO.detail
+@dirrm share/doc/postgresql80
diff --git a/databases/postgresql80-lib/DESCR b/databases/postgresql80-lib/DESCR
new file mode 100644
index 00000000000..8e9d35b4af6
--- /dev/null
+++ b/databases/postgresql80-lib/DESCR
@@ -0,0 +1,9 @@
+PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS),
+derived from the Berkeley Postgres database management system. While
+PostgreSQL retains the powerful object-relational data model, rich data types
+and easy extensibility of Postgres, it replaces the PostQuel query language
+with an extended subset of SQL.
+
+PostgreSQL is free and the complete source is available.
+
+This package contains the database headers and libraries.
diff --git a/databases/postgresql80-lib/Makefile b/databases/postgresql80-lib/Makefile
new file mode 100644
index 00000000000..5c9c245edc9
--- /dev/null
+++ b/databases/postgresql80-lib/Makefile
@@ -0,0 +1,61 @@
+# $NetBSD: Makefile,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $
+
+PKGNAME= postgresql80-lib-${BASE_VERS}
+PKGREVISION= # empty
+COMMENT= PostgreSQL database headers and libraries
+
+.include "../../wip/postgresql80/Makefile.common"
+
+CONFIGURE_ARGS+= --with-openssl
+
+.include "../../mk/bsd.prefs.mk"
+
+BUILD_DIRS+= ${WRKSRC}/src/include
+BUILD_DIRS+= ${WRKSRC}/src/interfaces
+
+# without this the Darwin build fails
+# (-bundle_loader related)
+BUILD_DIRS+= ${WRKSRC}/src/backend
+
+BUILD_DIRS+= ${WRKSRC}/src/pl
+
+# As told by Josh Berkus
+.include "../../mk/pthread.buildlink3.mk"
+.if defined(PTHREAD_TYPE) && ${PTHREAD_TYPE} == "native" \
+ && ${OPSYS} != "NetBSD"
+CONFIGURE_ARGS+= --enable-thread-safety
+.endif
+
+# handle additional headers installed by hierarchical queries patch
+.if defined(PGSQL_USE_HIER) && !empty(PGSQL_USE_HIER:M[yY][eE][sS])
+PLIST_SUBST+= PG_HIER=
+.else
+PLIST_SUBST+= PG_HIER="@comment "
+.endif
+
+post-buildlink:
+#
+# Avoid conflict between "${LOCALBASE}/include/openssl/des.h" and
+# "/usr/include/crypt.h" -- we want the definitions in the former.
+#
+.if (${OPSYS} == "SunOS")
+ ${TOUCH} ${BUILDLINK_DIR}/include/crypt.h
+.endif
+do-install:
+ cd ${WRKSRC} && ${SETENV} ${MAKE_ENV} \
+ ${MAKE_PROGRAM} -C src/include install
+ cd ${WRKSRC} && ${SETENV} ${MAKE_ENV} \
+ ${MAKE_PROGRAM} -C src/interfaces install
+ cd ${WRKSRC} && ${SETENV} ${MAKE_ENV} \
+ ${MAKE_PROGRAM} -C src/pl install
+# cd ${WRKSRC}/src/include && ${SETENV} ${MAKE_ENV} \
+# ${MAKE_PROGRAM} install-all-headers
+
+post-install:
+ ${INSTALL_MAN_DIR} ${PG_DIR}/man
+ ${EGREP} -v "^#" ${FILESDIR}/man.lib > ${WRKDIR}/man_tar
+ cd ${PG_DIR}/man && ${TAR} -zxm -T ${WRKDIR}/man_tar \
+ -f ${WRKSRC}/doc/man.tar.gz
+
+.include "../../security/openssl/buildlink3.mk"
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql80-lib/PLIST b/databases/postgresql80-lib/PLIST
new file mode 100644
index 00000000000..1bf6ce5cbb8
--- /dev/null
+++ b/databases/postgresql80-lib/PLIST
@@ -0,0 +1,438 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $
+bin/ecpg
+include/ecpg_informix.h
+include/ecpgerrno.h
+include/ecpglib.h
+include/ecpgtype.h
+include/libpq-fe.h
+include/libpq/libpq-fs.h
+include/pg_config.h
+include/pg_config_manual.h
+include/pg_config_os.h
+include/pgtypes_date.h
+include/pgtypes_error.h
+include/pgtypes_interval.h
+include/pgtypes_numeric.h
+include/pgtypes_timestamp.h
+include/postgres_ext.h
+include/postgresql/informix/esql/datetime.h
+include/postgresql/informix/esql/decimal.h
+include/postgresql/informix/esql/sqlda.h
+include/postgresql/informix/esql/sqltypes.h
+include/postgresql/internal/c.h
+include/postgresql/internal/libpq-int.h
+include/postgresql/internal/libpq/pqcomm.h
+include/postgresql/internal/port.h
+include/postgresql/internal/postgres_fe.h
+include/postgresql/internal/pqexpbuffer.h
+include/postgresql/server/access/attnum.h
+include/postgresql/server/access/clog.h
+include/postgresql/server/access/genam.h
+include/postgresql/server/access/gist.h
+include/postgresql/server/access/gistscan.h
+include/postgresql/server/access/hash.h
+include/postgresql/server/access/heapam.h
+include/postgresql/server/access/hio.h
+include/postgresql/server/access/htup.h
+include/postgresql/server/access/ibit.h
+include/postgresql/server/access/iqual.h
+include/postgresql/server/access/itup.h
+include/postgresql/server/access/nbtree.h
+include/postgresql/server/access/printtup.h
+include/postgresql/server/access/relscan.h
+include/postgresql/server/access/rmgr.h
+include/postgresql/server/access/rtree.h
+include/postgresql/server/access/rtscan.h
+include/postgresql/server/access/sdir.h
+include/postgresql/server/access/skey.h
+include/postgresql/server/access/slru.h
+include/postgresql/server/access/subtrans.h
+include/postgresql/server/access/transam.h
+include/postgresql/server/access/tupdesc.h
+include/postgresql/server/access/tupmacs.h
+include/postgresql/server/access/tuptoaster.h
+include/postgresql/server/access/valid.h
+include/postgresql/server/access/xact.h
+include/postgresql/server/access/xlog.h
+include/postgresql/server/access/xlog_internal.h
+include/postgresql/server/access/xlogdefs.h
+include/postgresql/server/access/xlogutils.h
+include/postgresql/server/bootstrap/bootstrap.h
+include/postgresql/server/c.h
+include/postgresql/server/catalog/catalog.h
+include/postgresql/server/catalog/catname.h
+include/postgresql/server/catalog/catversion.h
+include/postgresql/server/catalog/dependency.h
+include/postgresql/server/catalog/heap.h
+include/postgresql/server/catalog/index.h
+include/postgresql/server/catalog/indexing.h
+include/postgresql/server/catalog/namespace.h
+include/postgresql/server/catalog/pg_aggregate.h
+include/postgresql/server/catalog/pg_am.h
+include/postgresql/server/catalog/pg_amop.h
+include/postgresql/server/catalog/pg_amproc.h
+include/postgresql/server/catalog/pg_attrdef.h
+include/postgresql/server/catalog/pg_attribute.h
+include/postgresql/server/catalog/pg_cast.h
+include/postgresql/server/catalog/pg_class.h
+include/postgresql/server/catalog/pg_constraint.h
+include/postgresql/server/catalog/pg_control.h
+include/postgresql/server/catalog/pg_conversion.h
+include/postgresql/server/catalog/pg_database.h
+include/postgresql/server/catalog/pg_depend.h
+include/postgresql/server/catalog/pg_description.h
+include/postgresql/server/catalog/pg_group.h
+include/postgresql/server/catalog/pg_index.h
+include/postgresql/server/catalog/pg_inherits.h
+include/postgresql/server/catalog/pg_language.h
+include/postgresql/server/catalog/pg_largeobject.h
+include/postgresql/server/catalog/pg_listener.h
+include/postgresql/server/catalog/pg_namespace.h
+include/postgresql/server/catalog/pg_opclass.h
+include/postgresql/server/catalog/pg_operator.h
+include/postgresql/server/catalog/pg_proc.h
+include/postgresql/server/catalog/pg_rewrite.h
+include/postgresql/server/catalog/pg_shadow.h
+include/postgresql/server/catalog/pg_statistic.h
+include/postgresql/server/catalog/pg_tablespace.h
+include/postgresql/server/catalog/pg_trigger.h
+include/postgresql/server/catalog/pg_type.h
+include/postgresql/server/catalog/pg_version.h
+include/postgresql/server/commands/alter.h
+include/postgresql/server/commands/async.h
+include/postgresql/server/commands/cluster.h
+include/postgresql/server/commands/comment.h
+include/postgresql/server/commands/conversioncmds.h
+include/postgresql/server/commands/copy.h
+include/postgresql/server/commands/dbcommands.h
+include/postgresql/server/commands/defrem.h
+include/postgresql/server/commands/explain.h
+include/postgresql/server/commands/lockcmds.h
+include/postgresql/server/commands/portalcmds.h
+include/postgresql/server/commands/prepare.h
+include/postgresql/server/commands/proclang.h
+include/postgresql/server/commands/schemacmds.h
+include/postgresql/server/commands/sequence.h
+include/postgresql/server/commands/tablecmds.h
+include/postgresql/server/commands/tablespace.h
+include/postgresql/server/commands/trigger.h
+include/postgresql/server/commands/typecmds.h
+include/postgresql/server/commands/user.h
+include/postgresql/server/commands/vacuum.h
+include/postgresql/server/commands/variable.h
+include/postgresql/server/commands/version.h
+include/postgresql/server/commands/view.h
+include/postgresql/server/dynloader.h
+include/postgresql/server/executor/execdebug.h
+include/postgresql/server/executor/execdefs.h
+include/postgresql/server/executor/execdesc.h
+include/postgresql/server/executor/executor.h
+include/postgresql/server/executor/functions.h
+include/postgresql/server/executor/hashjoin.h
+include/postgresql/server/executor/instrument.h
+include/postgresql/server/executor/nodeAgg.h
+include/postgresql/server/executor/nodeAppend.h
+include/postgresql/server/executor/nodeFunctionscan.h
+include/postgresql/server/executor/nodeGroup.h
+include/postgresql/server/executor/nodeHash.h
+include/postgresql/server/executor/nodeHashjoin.h
+include/postgresql/server/executor/nodeIndexscan.h
+include/postgresql/server/executor/nodeLimit.h
+include/postgresql/server/executor/nodeMaterial.h
+include/postgresql/server/executor/nodeMergejoin.h
+include/postgresql/server/executor/nodeNestloop.h
+include/postgresql/server/executor/nodeResult.h
+include/postgresql/server/executor/nodeSeqscan.h
+include/postgresql/server/executor/nodeSetOp.h
+include/postgresql/server/executor/nodeSort.h
+include/postgresql/server/executor/nodeSubplan.h
+include/postgresql/server/executor/nodeSubqueryscan.h
+include/postgresql/server/executor/nodeTidscan.h
+include/postgresql/server/executor/nodeUnique.h
+include/postgresql/server/executor/spi.h
+include/postgresql/server/executor/spi_priv.h
+include/postgresql/server/executor/tstoreReceiver.h
+include/postgresql/server/executor/tuptable.h
+include/postgresql/server/fmgr.h
+include/postgresql/server/funcapi.h
+include/postgresql/server/getaddrinfo.h
+include/postgresql/server/getopt_long.h
+include/postgresql/server/lib/dllist.h
+include/postgresql/server/lib/stringinfo.h
+include/postgresql/server/libpq/auth.h
+include/postgresql/server/libpq/be-fsstubs.h
+include/postgresql/server/libpq/crypt.h
+include/postgresql/server/libpq/hba.h
+include/postgresql/server/libpq/ip.h
+include/postgresql/server/libpq/libpq-be.h
+include/postgresql/server/libpq/libpq-fs.h
+include/postgresql/server/libpq/libpq.h
+include/postgresql/server/libpq/pqcomm.h
+include/postgresql/server/libpq/pqformat.h
+include/postgresql/server/libpq/pqsignal.h
+include/postgresql/server/mb/pg_wchar.h
+include/postgresql/server/miscadmin.h
+include/postgresql/server/nodes/bitmapset.h
+include/postgresql/server/nodes/execnodes.h
+include/postgresql/server/nodes/makefuncs.h
+include/postgresql/server/nodes/memnodes.h
+include/postgresql/server/nodes/nodeFuncs.h
+include/postgresql/server/nodes/nodes.h
+include/postgresql/server/nodes/params.h
+include/postgresql/server/nodes/parsenodes.h
+include/postgresql/server/nodes/pg_list.h
+include/postgresql/server/nodes/plannodes.h
+include/postgresql/server/nodes/primnodes.h
+include/postgresql/server/nodes/print.h
+include/postgresql/server/nodes/readfuncs.h
+include/postgresql/server/nodes/relation.h
+include/postgresql/server/nodes/value.h
+include/postgresql/server/optimizer/clauses.h
+include/postgresql/server/optimizer/cost.h
+include/postgresql/server/optimizer/geqo.h
+include/postgresql/server/optimizer/geqo_copy.h
+include/postgresql/server/optimizer/geqo_gene.h
+include/postgresql/server/optimizer/geqo_misc.h
+include/postgresql/server/optimizer/geqo_mutation.h
+include/postgresql/server/optimizer/geqo_pool.h
+include/postgresql/server/optimizer/geqo_random.h
+include/postgresql/server/optimizer/geqo_recombination.h
+include/postgresql/server/optimizer/geqo_selection.h
+include/postgresql/server/optimizer/joininfo.h
+include/postgresql/server/optimizer/pathnode.h
+include/postgresql/server/optimizer/paths.h
+include/postgresql/server/optimizer/plancat.h
+include/postgresql/server/optimizer/planmain.h
+include/postgresql/server/optimizer/planner.h
+include/postgresql/server/optimizer/prep.h
+include/postgresql/server/optimizer/restrictinfo.h
+include/postgresql/server/optimizer/subselect.h
+include/postgresql/server/optimizer/tlist.h
+include/postgresql/server/optimizer/var.h
+include/postgresql/server/parser/analyze.h
+include/postgresql/server/parser/gramparse.h
+include/postgresql/server/parser/keywords.h
+include/postgresql/server/parser/parse.h
+include/postgresql/server/parser/parse_agg.h
+include/postgresql/server/parser/parse_clause.h
+include/postgresql/server/parser/parse_coerce.h
+include/postgresql/server/parser/parse_expr.h
+include/postgresql/server/parser/parse_func.h
+include/postgresql/server/parser/parse_node.h
+include/postgresql/server/parser/parse_oper.h
+include/postgresql/server/parser/parse_relation.h
+include/postgresql/server/parser/parse_target.h
+include/postgresql/server/parser/parse_type.h
+include/postgresql/server/parser/parser.h
+include/postgresql/server/parser/parsetree.h
+include/postgresql/server/parser/scansup.h
+include/postgresql/server/pg_config.h
+include/postgresql/server/pg_config_manual.h
+include/postgresql/server/pg_config_os.h
+include/postgresql/server/pgstat.h
+include/postgresql/server/pgtime.h
+include/postgresql/server/port.h
+include/postgresql/server/port/aix.h
+include/postgresql/server/port/beos.h
+include/postgresql/server/port/bsdi.h
+include/postgresql/server/port/cygwin.h
+include/postgresql/server/port/darwin.h
+include/postgresql/server/port/dgux.h
+include/postgresql/server/port/freebsd.h
+include/postgresql/server/port/hpux.h
+include/postgresql/server/port/irix.h
+include/postgresql/server/port/linux.h
+include/postgresql/server/port/netbsd.h
+include/postgresql/server/port/nextstep.h
+include/postgresql/server/port/openbsd.h
+include/postgresql/server/port/osf.h
+include/postgresql/server/port/qnx4.h
+include/postgresql/server/port/sco.h
+include/postgresql/server/port/solaris.h
+include/postgresql/server/port/sunos4.h
+include/postgresql/server/port/svr4.h
+include/postgresql/server/port/ultrix4.h
+include/postgresql/server/port/univel.h
+include/postgresql/server/port/unixware.h
+include/postgresql/server/port/win32.h
+include/postgresql/server/port/win32/arpa/inet.h
+include/postgresql/server/port/win32/dlfcn.h
+include/postgresql/server/port/win32/grp.h
+include/postgresql/server/port/win32/netdb.h
+include/postgresql/server/port/win32/netinet/in.h
+include/postgresql/server/port/win32/pwd.h
+include/postgresql/server/port/win32/sys/socket.h
+include/postgresql/server/port/win32/sys/wait.h
+include/postgresql/server/postgres.h
+include/postgresql/server/postgres_ext.h
+include/postgresql/server/postgres_fe.h
+include/postgresql/server/regex/regcustom.h
+include/postgresql/server/regex/regerrs.h
+include/postgresql/server/regex/regex.h
+include/postgresql/server/regex/regguts.h
+include/postgresql/server/rewrite/prs2lock.h
+include/postgresql/server/rewrite/rewriteDefine.h
+include/postgresql/server/rewrite/rewriteHandler.h
+include/postgresql/server/rewrite/rewriteManip.h
+include/postgresql/server/rewrite/rewriteRemove.h
+include/postgresql/server/rewrite/rewriteSupport.h
+include/postgresql/server/rusagestub.h
+include/postgresql/server/storage/backendid.h
+include/postgresql/server/storage/block.h
+include/postgresql/server/storage/buf.h
+include/postgresql/server/storage/buf_internals.h
+include/postgresql/server/storage/buffile.h
+include/postgresql/server/storage/bufmgr.h
+include/postgresql/server/storage/bufpage.h
+include/postgresql/server/storage/fd.h
+include/postgresql/server/storage/freespace.h
+include/postgresql/server/storage/ipc.h
+include/postgresql/server/storage/item.h
+include/postgresql/server/storage/itemid.h
+include/postgresql/server/storage/itempos.h
+include/postgresql/server/storage/itemptr.h
+include/postgresql/server/storage/large_object.h
+include/postgresql/server/storage/lmgr.h
+include/postgresql/server/storage/lock.h
+include/postgresql/server/storage/lwlock.h
+include/postgresql/server/storage/off.h
+include/postgresql/server/storage/pg_sema.h
+include/postgresql/server/storage/pg_shmem.h
+include/postgresql/server/storage/pmsignal.h
+include/postgresql/server/storage/pos.h
+include/postgresql/server/storage/proc.h
+include/postgresql/server/storage/relfilenode.h
+include/postgresql/server/storage/s_lock.h
+include/postgresql/server/storage/shmem.h
+include/postgresql/server/storage/sinval.h
+include/postgresql/server/storage/sinvaladt.h
+include/postgresql/server/storage/smgr.h
+include/postgresql/server/storage/spin.h
+include/postgresql/server/strdup.h
+include/postgresql/server/tcop/dest.h
+include/postgresql/server/tcop/fastpath.h
+include/postgresql/server/tcop/pquery.h
+include/postgresql/server/tcop/tcopdebug.h
+include/postgresql/server/tcop/tcopprot.h
+include/postgresql/server/tcop/utility.h
+include/postgresql/server/utils/acl.h
+include/postgresql/server/utils/array.h
+include/postgresql/server/utils/ascii.h
+include/postgresql/server/utils/builtins.h
+include/postgresql/server/utils/cash.h
+include/postgresql/server/utils/catcache.h
+include/postgresql/server/utils/date.h
+include/postgresql/server/utils/datetime.h
+include/postgresql/server/utils/datum.h
+include/postgresql/server/utils/dynahash.h
+include/postgresql/server/utils/dynamic_loader.h
+include/postgresql/server/utils/elog.h
+include/postgresql/server/utils/errcodes.h
+include/postgresql/server/utils/fmgroids.h
+include/postgresql/server/utils/fmgrtab.h
+include/postgresql/server/utils/formatting.h
+include/postgresql/server/utils/geo_decls.h
+include/postgresql/server/utils/guc.h
+include/postgresql/server/utils/guc_tables.h
+include/postgresql/server/utils/help_config.h
+include/postgresql/server/utils/hsearch.h
+include/postgresql/server/utils/inet.h
+include/postgresql/server/utils/int8.h
+include/postgresql/server/utils/inval.h
+include/postgresql/server/utils/logtape.h
+include/postgresql/server/utils/lsyscache.h
+include/postgresql/server/utils/memutils.h
+include/postgresql/server/utils/nabstime.h
+include/postgresql/server/utils/numeric.h
+include/postgresql/server/utils/palloc.h
+include/postgresql/server/utils/pg_crc.h
+include/postgresql/server/utils/pg_locale.h
+include/postgresql/server/utils/pg_lzcompress.h
+include/postgresql/server/utils/portal.h
+include/postgresql/server/utils/ps_status.h
+include/postgresql/server/utils/rel.h
+include/postgresql/server/utils/relcache.h
+include/postgresql/server/utils/resowner.h
+include/postgresql/server/utils/selfuncs.h
+include/postgresql/server/utils/syscache.h
+include/postgresql/server/utils/timestamp.h
+include/postgresql/server/utils/tqual.h
+include/postgresql/server/utils/tuplesort.h
+include/postgresql/server/utils/tuplestore.h
+include/postgresql/server/utils/typcache.h
+include/postgresql/server/utils/varbit.h
+include/sql3types.h
+include/sqlca.h
+lib/libecpg.a
+lib/libecpg.so
+lib/libecpg.so.4
+lib/libecpg.so.4.2
+lib/libecpg_compat.a
+lib/libecpg_compat.so
+lib/libecpg_compat.so.1
+lib/libecpg_compat.so.1.1
+lib/libpgtypes.a
+lib/libpgtypes.so
+lib/libpgtypes.so.1
+lib/libpgtypes.so.1.2
+lib/libpq.a
+lib/libpq.so
+lib/libpq.so.3
+lib/libpq.so.3.2
+lib/postgresql/plpgsql.so
+@comment lib/libecpg.4.2.dylib
+@comment lib/libecpg.4.dylib
+@comment lib/libecpg.dylib
+@comment lib/libecpg_compat.1.1.dylib
+@comment lib/libecpg_compat.1.dylib
+@comment lib/libecpg_compat.dylib
+@comment lib/libpgtypes.1.2.dylib
+@comment lib/libpgtypes.1.dylib
+@comment lib/libpgtypes.dylib
+@comment lib/libpq.3.2.dylib
+@comment lib/libpq.3.dylib
+@comment lib/libpq.dylib
+man/man1/ecpg.1
+${PKGLOCALEDIR}/locale/af/LC_MESSAGES/libpq.mo
+${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/libpq.mo
+${PKGLOCALEDIR}/locale/de/LC_MESSAGES/libpq.mo
+${PKGLOCALEDIR}/locale/es/LC_MESSAGES/libpq.mo
+${PKGLOCALEDIR}/locale/fr/LC_MESSAGES/libpq.mo
+${PKGLOCALEDIR}/locale/hr/LC_MESSAGES/libpq.mo
+${PKGLOCALEDIR}/locale/it/LC_MESSAGES/libpq.mo
+${PKGLOCALEDIR}/locale/nb/LC_MESSAGES/libpq.mo
+${PKGLOCALEDIR}/locale/pt_BR/LC_MESSAGES/libpq.mo
+${PKGLOCALEDIR}/locale/ru/LC_MESSAGES/libpq.mo
+${PKGLOCALEDIR}/locale/sk/LC_MESSAGES/libpq.mo
+${PKGLOCALEDIR}/locale/sl/LC_MESSAGES/libpq.mo
+${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/libpq.mo
+${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/libpq.mo
+${PKGLOCALEDIR}/locale/zh_TW/LC_MESSAGES/libpq.mo
+share/postgresql/pg_service.conf.sample
+@dirrm include/postgresql/server/utils
+@dirrm include/postgresql/server/tcop
+@dirrm include/postgresql/server/storage
+@dirrm include/postgresql/server/rewrite
+@dirrm include/postgresql/server/regex
+@dirrm include/postgresql/server/port/win32/sys
+@dirrm include/postgresql/server/port/win32/netinet
+@dirrm include/postgresql/server/port/win32/arpa
+@dirrm include/postgresql/server/port/win32
+@dirrm include/postgresql/server/port
+@dirrm include/postgresql/server/parser
+@dirrm include/postgresql/server/optimizer
+@dirrm include/postgresql/server/nodes
+@dirrm include/postgresql/server/mb
+@dirrm include/postgresql/server/libpq
+@dirrm include/postgresql/server/lib
+@dirrm include/postgresql/server/executor
+@dirrm include/postgresql/server/commands
+@dirrm include/postgresql/server/catalog
+@dirrm include/postgresql/server/bootstrap
+@dirrm include/postgresql/server/access
+@dirrm include/postgresql/server
+@dirrm include/postgresql/internal/libpq
+@dirrm include/postgresql/internal
+@dirrm include/postgresql/informix/esql
+@dirrm include/postgresql/informix
+@dirrm include/postgresql
diff --git a/databases/postgresql80-lib/buildlink3.mk b/databases/postgresql80-lib/buildlink3.mk
new file mode 100644
index 00000000000..911990ece45
--- /dev/null
+++ b/databases/postgresql80-lib/buildlink3.mk
@@ -0,0 +1,26 @@
+# $NetBSD: buildlink3.mk,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $
+
+BUILDLINK_DEPTH:= ${BUILDLINK_DEPTH}+
+POSTGRESQL80_LIB_BUILDLINK3_MK:= ${POSTGRESQL80_LIB_BUILDLINK3_MK}+
+
+.if !empty(BUILDLINK_DEPTH:M+)
+BUILDLINK_DEPENDS+= postgresql80-lib
+.endif
+
+BUILDLINK_PACKAGES:= ${BUILDLINK_PACKAGES:Npostgresql80-lib}
+BUILDLINK_PACKAGES+= postgresql80-lib
+
+.if !empty(POSTGRESQL80_LIB_BUILDLINK3_MK:M+)
+BUILDLINK_DEPENDS.postgresql80-lib+= postgresql80-lib>=8.0.0beta4
+BUILDLINK_PKGSRCDIR.postgresql80-lib?= ../../wip/postgresql80-lib
+
+BUILDLINK_INCDIRS.postgresql80-lib+= pgsql80/include
+BUILDLINK_LIBDIRS.postgresql80-lib+= pgsql80/lib
+
+.endif # POSTGRESQL80_LIB_BUILDLINK3_MK
+
+.include "../../security/openssl/buildlink3.mk"
+.include "../../devel/gettext-lib/buildlink3.mk"
+.include "../../devel/zlib/buildlink3.mk"
+
+BUILDLINK_DEPTH:= ${BUILDLINK_DEPTH:S/+$//}
diff --git a/databases/postgresql80-lib/files/man.lib b/databases/postgresql80-lib/files/man.lib
new file mode 100644
index 00000000000..686084a20c1
--- /dev/null
+++ b/databases/postgresql80-lib/files/man.lib
@@ -0,0 +1,3 @@
+# $NetBSD: man.lib,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $
+#
+man1/ecpg.1
diff --git a/databases/postgresql80-server/DEINSTALL b/databases/postgresql80-server/DEINSTALL
new file mode 100644
index 00000000000..761da62253f
--- /dev/null
+++ b/databases/postgresql80-server/DEINSTALL
@@ -0,0 +1,20 @@
+# $NetBSD: DEINSTALL,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $
+
+case ${STAGE} in
+DEINSTALL)
+ ${CAT} << EOF
+===========================================================================
+
+If you intend to upgrade your PostgreSQL installation, you may need to
+perform a dump-and-restore to move your current databases into the newer
+PostgreSQL installation. Please dump your databases *prior* to installing
+the new PostgreSQL.
+
+Please see the Backup and Restore section of the PostgreSQL Administrator's
+Guide (databases/postgresql-docs) for complete information on how to
+perform the databases dump.
+
+===========================================================================
+EOF
+ ;;
+esac
diff --git a/databases/postgresql80-server/DESCR b/databases/postgresql80-server/DESCR
new file mode 100644
index 00000000000..68bb2b05748
--- /dev/null
+++ b/databases/postgresql80-server/DESCR
@@ -0,0 +1,9 @@
+PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS),
+derived from the Berkeley Postgres database management system. While
+PostgreSQL retains the powerful object-relational data model, rich data types
+and easy extensibility of Postgres, it replaces the PostQuel query language
+with an extended subset of SQL.
+
+PostgreSQL is free and the complete source is available.
+
+This package contains the database server programs.
diff --git a/databases/postgresql80-server/MESSAGE b/databases/postgresql80-server/MESSAGE
new file mode 100644
index 00000000000..7981e9017d8
--- /dev/null
+++ b/databases/postgresql80-server/MESSAGE
@@ -0,0 +1,19 @@
+===========================================================================
+$NetBSD: MESSAGE,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $
+
+To enable this package, put the following into your /etc/rc.conf:
+
+ pgsql=yes
+ pgsql_flags="-l" # enables SSL connections (TCP/IP and
+ # ~pgsql/data/server.crt required)
+
+and ensure that
+
+ ${RCD_SCRIPTS_DIR}/pgsql start
+
+is run at the appropriate time.
+
+Note: PostgreSQL 8.0 accepts TCP/IP connections on localhost address
+by default.
+
+===========================================================================
diff --git a/databases/postgresql80-server/Makefile b/databases/postgresql80-server/Makefile
new file mode 100644
index 00000000000..5ae50325f47
--- /dev/null
+++ b/databases/postgresql80-server/Makefile
@@ -0,0 +1,80 @@
+# $NetBSD: Makefile,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $
+
+PKGNAME= postgresql80-server-${BASE_VERS}
+PKGREVISION= # empty
+COMMENT= PostgreSQL database server programs
+
+DEPENDS+= postgresql80-client>=${BASE_VERS}:../../wip/postgresql80-client
+
+# mips has no TAS implementation
+NOT_FOR_PLATFORM= *-*-mips
+
+.include "../../wip/postgresql80/Makefile.common"
+
+USE_PKGINSTALL= yes
+DEINSTALL_EXTRA_TMPL+= ${.CURDIR}/DEINSTALL
+MESSAGE_SRC= ${.CURDIR}/MESSAGE
+
+CONFIGURE_ARGS+= --with-openssl
+BUILD_DIRS= ${WRKSRC}/src/backend
+BUILD_DIRS+= ${WRKSRC}/src/backend/utils/mb/conversion_procs
+
+.if defined(USE_PAM)
+. include "../../security/PAM/buildlink3.mk"
+CONFIGURE_ARGS+= --with-pam
+.endif
+
+# PGUSER username of the database administrator
+# PGGROUP group of the database administrator
+# PGHOME home directory of the database administrator and location of
+# the databases
+#
+PGUSER?= pgsql
+PGGROUP?= pgsql
+PGHOME?= ${PREFIX}/${PGUSER}
+FILES_SUBST+= PGUSER=${PGUSER}
+FILES_SUBST+= PGGROUP=${PGGROUP}
+FILES_SUBST+= PGHOME=${PGHOME}
+BUILD_DEFS= PGUSER PGGROUP PGHOME
+
+PKG_USERS= ${PGUSER}:${PGGROUP}::PostgreSQL\\ database\\ administrator:${PGHOME}:${SH}
+PKG_GROUPS= ${PGGROUP}
+
+RCD_SCRIPTS= pgsql
+
+post-buildlink:
+#
+# Avoid conflict between "${LOCALBASE}/include/openssl/des.h" and
+# "/usr/include/crypt.h" -- we want the definitions in the former.
+#
+.if (${OPSYS} == "SunOS")
+ ${TOUCH} ${BUILDLINK_DIR}/include/crypt.h
+.endif
+
+pre-build:
+ ${_PKG_SILENT}${_PKG_DEBUG}${_ULIMIT_CMD}cd ${WRKSRC}/src/backend && \
+ ${SETENV} ${MAKE_ENV} ${MAKE_PROGRAM} ${BUILD_MAKE_FLAGS} \
+ ../../src/include/parser/parse.h ../../src/include/utils/fmgroids.h
+ ${_PKG_SILENT}${_PKG_DEBUG}${_ULIMIT_CMD}cd ${WRKSRC}/src/port && \
+ ${SETENV} ${MAKE_ENV} ${MAKE_PROGRAM} ${BUILD_MAKE_FLAGS}
+
+pre-install:
+ @case "X${PGUSER}" in \
+ Xbin|Xetc|Xinclude|Xinfo|Xlib|Xlibdata|Xlibexec|Xman|Xsbin|Xshare) \
+ ${ECHO} "You have chosen PGUSER=${PGUSER} which will"; \
+ ${ECHO} "cause trouble, because the postgres home directory"; \
+ ${ECHO} "would be ${PGHOME}. Please"; \
+ ${ECHO} "set PGUSER to something more reasonable"; \
+ ${ECHO} "like pgsql."; \
+ ${ECHO} ""; \
+ ${FALSE}; \
+ ;; \
+ esac
+
+post-install:
+ ${EGREP} -v "^#" ${FILESDIR}/man.server > ${WRKDIR}/man_tar
+ cd ${PG_DIR}/man && ${TAR} -zxm -T ${WRKDIR}/man_tar \
+ -f ${WRKSRC}/doc/man.tar.gz
+
+.include "../../wip/postgresql80-lib/buildlink3.mk"
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql80-server/PLIST b/databases/postgresql80-server/PLIST
new file mode 100644
index 00000000000..957df03487f
--- /dev/null
+++ b/databases/postgresql80-server/PLIST
@@ -0,0 +1,61 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $
+bin/postgres
+bin/postmaster
+lib/postgresql/ascii_and_mic.so
+lib/postgresql/cyrillic_and_mic.so
+lib/postgresql/euc_cn_and_mic.so
+lib/postgresql/euc_jp_and_sjis.so
+lib/postgresql/euc_kr_and_mic.so
+lib/postgresql/euc_tw_and_big5.so
+lib/postgresql/latin2_and_win1250.so
+lib/postgresql/latin_and_mic.so
+lib/postgresql/utf8_and_ascii.so
+lib/postgresql/utf8_and_big5.so
+lib/postgresql/utf8_and_cyrillic.so
+lib/postgresql/utf8_and_euc_cn.so
+lib/postgresql/utf8_and_euc_jp.so
+lib/postgresql/utf8_and_euc_kr.so
+lib/postgresql/utf8_and_euc_tw.so
+lib/postgresql/utf8_and_gb18030.so
+lib/postgresql/utf8_and_gbk.so
+lib/postgresql/utf8_and_iso8859.so
+lib/postgresql/utf8_and_iso8859_1.so
+lib/postgresql/utf8_and_johab.so
+lib/postgresql/utf8_and_sjis.so
+lib/postgresql/utf8_and_tcvn.so
+lib/postgresql/utf8_and_uhc.so
+lib/postgresql/utf8_and_win1250.so
+lib/postgresql/utf8_and_win1256.so
+lib/postgresql/utf8_and_win874.so
+man/man1/postgres.1
+man/man1/postmaster.1
+share/postgresql/conversion_create.sql
+share/postgresql/information_schema.sql
+${PKGLOCALEDIR}/locale/af/LC_MESSAGES/postgres.mo
+${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/postgres.mo
+${PKGLOCALEDIR}/locale/de/LC_MESSAGES/postgres.mo
+${PKGLOCALEDIR}/locale/es/LC_MESSAGES/postgres.mo
+${PKGLOCALEDIR}/locale/fr/LC_MESSAGES/postgres.mo
+${PKGLOCALEDIR}/locale/hr/LC_MESSAGES/postgres.mo
+${PKGLOCALEDIR}/locale/hu/LC_MESSAGES/postgres.mo
+${PKGLOCALEDIR}/locale/it/LC_MESSAGES/postgres.mo
+${PKGLOCALEDIR}/locale/nb/LC_MESSAGES/postgres.mo
+${PKGLOCALEDIR}/locale/pt_BR/LC_MESSAGES/postgres.mo
+${PKGLOCALEDIR}/locale/ru/LC_MESSAGES/postgres.mo
+${PKGLOCALEDIR}/locale/sk/LC_MESSAGES/postgres.mo
+${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/postgres.mo
+${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/postgres.mo
+${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/postgres.mo
+${PKGLOCALEDIR}/locale/zh_TW/LC_MESSAGES/postgres.mo
+share/postgresql/pg_hba.conf.sample
+share/postgresql/pg_ident.conf.sample
+share/postgresql/postgres.bki
+share/postgresql/postgres.description
+share/postgresql/postgresql.conf.sample
+share/postgresql/recovery.conf.sample
+share/postgresql/sql_features.txt
+share/postgresql/system_views.sql
+@comment in postgresql80-client: @dirrm share
+@comment in postgresql80-lib: @dirrm man/man1
+@comment in postgresql80-lib: @dirrm lib/postgresql
+@comment in postgresql80-lib: @dirrm bin
diff --git a/databases/postgresql80-server/files/man.server b/databases/postgresql80-server/files/man.server
new file mode 100644
index 00000000000..7a76d2c3193
--- /dev/null
+++ b/databases/postgresql80-server/files/man.server
@@ -0,0 +1,4 @@
+# $NetBSD: man.server,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $
+#
+man1/postgres.1
+man1/postmaster.1
diff --git a/databases/postgresql80-server/files/pgsql.sh b/databases/postgresql80-server/files/pgsql.sh
new file mode 100644
index 00000000000..481fc1e9d14
--- /dev/null
+++ b/databases/postgresql80-server/files/pgsql.sh
@@ -0,0 +1,142 @@
+#!@RCD_SCRIPTS_SHELL@
+#
+# $NetBSD: pgsql.sh,v 1.1.1.1 2005/02/06 12:32:06 jdolecek Exp $
+#
+# PostgreSQL database rc.d control script
+#
+# PROVIDE: pgsql
+# REQUIRE: DAEMON
+# KEYWORD: shutdown
+#
+# You will need to set some variables in /etc/rc.conf to start PostgreSQL:
+#
+# pgsql=YES
+#
+# The following variables are optional:
+#
+# pgsql_flags="-i" # allows TCP/IP connections
+# pgsql_flags="-i -l" # enables SSL connections
+# pgsql_home="/path/to/home" # path to pgsql database directory
+#
+# "pgsql_flags" contains options for the PostgreSQL postmaster. See
+# postmaster(1) for possible options.
+
+if [ -f /etc/rc.subr ]; then
+ . /etc/rc.subr
+fi
+
+name="pgsql"
+rcvar=$name
+pgsql_user="@PGUSER@"
+pgsql_group="@PGGROUP@"
+eval pgsql_home="~$pgsql_user"
+
+command="@PREFIX@/bin/postmaster"
+ctl_command="@PREFIX@/bin/pg_ctl"
+extra_commands="initdb"
+
+if [ -f /etc/rc.subr -a -d /etc/rc.d -a -f /etc/rc.d/DAEMON ]; then
+ load_rc_config $name
+elif [ -f /etc/rc.conf ]; then
+ . /etc/rc.conf
+fi
+
+pidfile="${pgsql_home}/data/postmaster.pid"
+common_args="-D ${pgsql_home}/data"
+start_command_args="-w -s -l ${pgsql_home}/errlog"
+stop_command_args="-s -m fast"
+
+initdb_cmd="pgsql_initdb"
+start_precmd="pgsql_precmd"
+start_cmd="pgsql_doit start"
+restart_cmd="pgsql_doit restart"
+stop_cmd="pgsql_doit stop"
+
+ulimit -n 4096
+
+pgsql_precmd()
+{
+ if [ ! -d ${pgsql_home}/data/base ]; then
+ pgsql_initdb
+ fi
+}
+
+pgsql_initdb()
+{
+ initdb="@PREFIX@/bin/initdb"
+
+ if [ ! -x ${initdb} ]; then
+ return 1
+ fi
+ if [ -d ${pgsql_home}/data/base ]; then
+ @ECHO@ "The PostgreSQL template databases have already been initialized."
+ @ECHO@ "Skipping database initialization."
+ else
+ @ECHO@ "Initializing PostgreSQL databases."
+ @MKDIR@ -p ${pgsql_home}
+ @CHOWN@ ${pgsql_user} ${pgsql_home}
+ @CHGRP@ ${pgsql_group} ${pgsql_home}
+ @CHMOD@ 0750 ${pgsql_home}
+ eval doit_command=\"${initdb} ${common_args} ${flags}\"
+ doit="@SU@ -m ${pgsql_user} -c '${doit_command}'"
+ eval $doit
+ fi
+}
+
+pgsql_doit()
+{
+ action=$1
+
+ case ${action} in
+ start|restart)
+ if [ -n "${pgsql_flags}" ]; then
+ start_command_args="${start_command_args} -o \\\"${pgsql_flags}\\\""
+ fi
+ command_args="${common_args} ${start_command_args} ${command_args}"
+ ;;
+ stop)
+ command_args="${common_args} ${stop_command_args} ${command_args}"
+ ;;
+ *)
+ command_args="${common_args} ${command_args}"
+ ;;
+ esac
+
+ if [ ! -x ${ctl_command} ]; then
+ return
+ fi
+
+ case ${action} in
+ start) @ECHO@ "Starting ${name}." ;;
+ stop) @ECHO@ "Stopping ${name}." ;;
+ restart) @ECHO@ "Restarting ${name}." ;;
+ esac
+
+ eval doit_command=\"${ctl_command} ${action} ${command_args}\"
+ doit="@SU@ -m ${pgsql_user} -c '${doit_command}'"
+ eval $doit
+}
+
+if [ -f /etc/rc.subr -a -d /etc/rc.d -a -f /etc/rc.d/DAEMON ]; then
+ load_rc_config $name
+ run_rc_command "$1"
+else
+ if [ -f /etc/rc.conf ]; then
+ . /etc/rc.conf
+ fi
+ case "$1" in
+ initdb)
+ eval ${initdb_cmd}
+ ;;
+ restart)
+ eval ${restart_cmd}
+ ;;
+ stop)
+ eval ${stop_cmd}
+ ;;
+ *)
+ eval ${start_precmd}
+ eval ${start_cmd}
+ ;;
+ esac
+fi
diff --git a/databases/postgresql80/DESCR b/databases/postgresql80/DESCR
new file mode 100644
index 00000000000..9f6b5b5b0f9
--- /dev/null
+++ b/databases/postgresql80/DESCR
@@ -0,0 +1,9 @@
+PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS),
+derived from the Berkeley Postgres database management system. While
+PostgreSQL retains the powerful object-relational data model, rich data types
+and easy extensibility of Postgres, it replaces the PostQuel query language
+with an extended subset of SQL.
+
+PostgreSQL is free and the complete source is available.
+
+This is the meta-package for the PostgreSQL database system.
diff --git a/databases/postgresql80/Makefile b/databases/postgresql80/Makefile
new file mode 100644
index 00000000000..2d29f27c5e9
--- /dev/null
+++ b/databases/postgresql80/Makefile
@@ -0,0 +1,19 @@
+
+PKGNAME= postgresql80-${BASE_VERS}
+COMMENT= Robust, next generation, object-relational DBMS
+
+DEPENDS+= postgresql80-client>=${BASE_VERS}:../../wip/postgresql80-client
+DEPENDS+= postgresql80-server>=${BASE_VERS}:../../wip/postgresql80-server
+DEPENDS+= postgresql80-docs>=${BASE_VERS}:../../wip/postgresql80-docs
+
+.include "Makefile.common"
+
+EXTRACT_ONLY= # empty
+NO_CHECKSUM= YES
+NO_CONFIGURE= YES
+NO_BUILD= YES
+
+do-install: # empty
+do-patch: # empty
+
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql80/Makefile.common b/databases/postgresql80/Makefile.common
new file mode 100644
index 00000000000..93991c625a7
--- /dev/null
+++ b/databases/postgresql80/Makefile.common
@@ -0,0 +1,117 @@
+# $NetBSD: Makefile.common,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $
+#
+# This Makefile fragment is included by all PostgreSQL packages built from
+# the main sources of the PostgreSQL distribution except jdbc-postgresql.
+#
+# The PostgreSQL package naming scheme, aside from the obvious piecewise
+# packages, is as follows:
+#
+# <lang>-postgresql client-side interface to PostgreSQL
+# postgresql-<lang> server-side module for PostgreSQL backend
+
+DISTNAME?= postgresql-${DIST_VERS}
+CATEGORIES+= databases
+MASTER_SITES?= \
+ ftp://ftp.de.postgresql.org/mirror/postgresql/source/v${DIST_VERS}/ \
+ ftp://gd.tuwien.ac.at/db/www.postgresql.org/pub/source/v${DIST_VERS}/ \
+ ftp://ftp.sunsite.auc.dk/mirrors/postgresql/source/v${DIST_VERS}/ \
+ ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/source/v${DIST_VERS}/ \
+ http://www.postgresql.org/ftpsite/source/v${DIST_VERS}/ \
+ ftp://ftp.postgresql.org/pub/source/v${DIST_VERS}/
+
+EXTRACT_SUFX= .tar.bz2
+
+MAINTAINER?= recht@NetBSD.org
+HOMEPAGE?= http://www.postgresql.org/
+
+CONFLICTS+= postgresql-[0-9]* postgresql73-* postgresql74-*
+
+DISTINFO_FILE?= ${.CURDIR}/../postgresql80/distinfo
+COMMON_FILESDIR?= ${.CURDIR}/../postgresql80/files
+PATCHDIR?= ${.CURDIR}/../postgresql80/patches
+
+# Version numbering scheme:
+#
+# DIST_VERS version number on the postgresql distfile
+# BASE_VERS pkgsrc-mangled version number (convert pl -> .)
+#
+# Note: Do not forget jdbc-postgresql when updating version
+DIST_VERS?= 8.0.1
+BASE_VERS?= ${DIST_VERS}
+
+BUILDLINK_DEPENDS.postgresql80-lib?= postgresql80-lib>=${BASE_VERS}
+#BUILDLINK_DEPENDS.tcl-postgresql80?= tcl-postgresql80>=${BASE_VERS}
+
+USE_BUILDLINK3= yes
+GNU_CONFIGURE= yes
+BUILD_USES_MSGFMT= yes
+USE_GNU_TOOLS+= lex make yacc
+PKG_SYSCONFSUBDIR= postgresql
+
+# in 7.4.2, this is done by autoconf stuff which has leading whitespace
+#USE_PKGLOCALEDIR= yes
+#SUBST_CLASSES+= pkglocaledir2
+#SUBST_FILES.pkglocaledir2= configure config/programs.m4
+#SUBST_STAGE.pkglocaledir2= pre-configure
+#SUBST_SED.pkglocaledir2= -e 's|\( localedir[ :]*=\).*|\1${_PKGLOCALEDIR}|'
+
+.include "../../mk/bsd.prefs.mk"
+
+# Add support for hierarchical queries with Oracle like CONNECT BY syntax.
+# see http://gppl.terminal.ru/README.html for details.
+.if defined(PGSQL_USE_HIER) && !empty(PGSQL_USE_HIER:M[yY][eE][sS])
+PATCH_SITES= http://gppl.moonbone.ru/
+PATCHFILES= hier-Pg7.4-0.5.3.tar.gz
+PATCH_DIST_STRIP= -p1
+.endif
+BUILD_DEFS+= PGSQL_USE_HIER
+
+PGSQL_TEMPLATE.SunOS= solaris
+.if !defined(PGSQL_TEMPLATE.${OPSYS})
+PGSQL_TEMPLATE.${OPSYS}= ${LOWER_OPSYS}
+.endif
+
+PG_DIR= ${PREFIX}
+GNU_CONFIGURE_PREFIX= ${PG_DIR}
+INSTALLATION_DIRS+= ${PG_DIR}
+
+#CONFIGURE_ARGS+= --sysconfdir=${PKG_SYSCONFDIR}
+CONFIGURE_ARGS+= --with-docdir=${PREFIX}/share/doc/postgresql80
+CONFIGURE_ARGS+= --with-template="${PGSQL_TEMPLATE.${OPSYS}}"
+CONFIGURE_ARGS+= --without-readline
+CONFIGURE_ARGS+= --with-zlib
+CONFIGURE_ARGS+= --enable-nls
+
+CONFIGURE_ARGS+= --without-java
+CONFIGURE_ARGS+= --without-perl
+CONFIGURE_ARGS+= --without-python
+CONFIGURE_ARGS+= --without-tcl
+CONFIGURE_ARGS+= --without-tk
+
+# Postgresql explicitly forbids any use of -ffast-math
+CFLAGS:= ${CFLAGS:S/-ffast-math//}
+
+post-extract:
+ if [ -d ${WRKSRC}/src ]; then \
+ ${RM} -f ${WRKSRC}/src/Makefile.custom; \
+ ${CP} -f ${COMMON_FILESDIR}/Makefile.custom \
+ ${WRKSRC}/src/Makefile.custom; \
+ fi
+ if [ -d ${WRKSRC}/src/interfaces/libpq ]; then \
+ ${RM} -f ${WRKSRC}/src/interfaces/libpq/GNUmakefile; \
+ ${CP} -f ${COMMON_FILESDIR}/GNUmakefile.libpq \
+ ${WRKSRC}/src/interfaces/libpq/GNUmakefile; \
+ fi
+ if [ -d ${WRKSRC}/src/interfaces/libpgtcl ]; then \
+ ${RM} -f ${WRKSRC}/src/interfaces/libpgtcl/GNUmakefile; \
+ ${CP} -f ${COMMON_FILESDIR}/GNUmakefile.libpgtcl \
+ ${WRKSRC}/src/interfaces/libpgtcl/GNUmakefile; \
+ fi
+ if [ -d ${WRKSRC}/src/backend/port/dynloader ]; then \
+ ${RM} -f ${WRKSRC}/src/backend/port/dynloader/netbsd.[ch];\
+ ${CP} -f ${COMMON_FILESDIR}/netbsd.[ch] \
+ ${WRKSRC}/src/backend/port/dynloader/; \
+ fi
+
+.include "../../devel/gettext-lib/buildlink3.mk"
+.include "../../devel/zlib/buildlink3.mk"
diff --git a/databases/postgresql80/PLIST b/databases/postgresql80/PLIST
new file mode 100644
index 00000000000..42ad3c2e849
--- /dev/null
+++ b/databases/postgresql80/PLIST
@@ -0,0 +1,2 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $
+@comment this plist intentionally left empty
diff --git a/databases/postgresql80/distinfo b/databases/postgresql80/distinfo
new file mode 100644
index 00000000000..48b7c2ae471
--- /dev/null
+++ b/databases/postgresql80/distinfo
@@ -0,0 +1,5 @@
+$NetBSD: distinfo,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $
+
+SHA1 (postgresql-8.0.1.tar.bz2) = 42a16fe13a6271b1612fb0a9f41f7da0a2e307b6
+Size (postgresql-8.0.1.tar.bz2) = 11049626 bytes
+SHA1 (patch-aa) = 20492216de0e5238a02b4cdd18c297731cf6462a
diff --git a/databases/postgresql80/files/GNUmakefile.libpgtcl b/databases/postgresql80/files/GNUmakefile.libpgtcl
new file mode 100644
index 00000000000..b1ea47d2775
--- /dev/null
+++ b/databases/postgresql80/files/GNUmakefile.libpgtcl
@@ -0,0 +1,20 @@
+# $NetBSD: GNUmakefile.libpgtcl,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $
+#
+# This GNUmakefile overrides the `all' target of $(libpgtcl_srcdir)/Makefile
+# to be empty if INSTALLED_LIBPGTCL is defined. This handles the submake
+# targets sprinkled throughout the PostgreSQL Makefiles that execute
+#
+# @$(MAKE) -C $(libpgtcl_builddir) all
+#
+# to ensure that the libpgtcl libraries are built first. If INSTALLED_LIBPGTCL
+# is defined, then have the `all' target simple return success.
+
+ifdef INSTALLED_LIBPGTCL
+all:
+ @test -f libpgtcl.a || touch libpgtcl.a
+endif
+
+%: force
+ @$(MAKE) -f Makefile $@
+
+force: ;
diff --git a/databases/postgresql80/files/GNUmakefile.libpq b/databases/postgresql80/files/GNUmakefile.libpq
new file mode 100644
index 00000000000..16a1e9834fc
--- /dev/null
+++ b/databases/postgresql80/files/GNUmakefile.libpq
@@ -0,0 +1,20 @@
+# $NetBSD: GNUmakefile.libpq,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $
+#
+# This GNUmakefile overrides the `all' target of $(libpq_srcdir)/Makefile
+# to be empty if INSTALLED_LIBPQ is defined. This handles the submake
+# targets sprinkled throughout the PostgreSQL Makefiles that execute
+#
+# @$(MAKE) -C $(libpq_builddir) all
+#
+# to ensure that the libpq libraries are built first. If INSTALLED_LIBPQ
+# is defined, then have the `all' target simple return success.
+
+ifdef INSTALLED_LIBPQ
+all:
+ @test -f libpq.a || touch libpq.a
+endif
+
+%: force
+ @$(MAKE) -f Makefile $@
+
+force: ;
diff --git a/databases/postgresql80/files/Makefile.custom b/databases/postgresql80/files/Makefile.custom
new file mode 100644
index 00000000000..2c27efbc3a4
--- /dev/null
+++ b/databases/postgresql80/files/Makefile.custom
@@ -0,0 +1,15 @@
+# $NetBSD: Makefile.custom,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $
+#
+# This file is included by Makefile.global, which is included by every
+# sub-Makefile in the build tree. Makefiles for shared libraries include
+# Makefile.global then Makefile.shlib.
+
+pkglibdir = $(exec_prefix)/lib/postgresql
+
+ifdef INSTALLED_LIBPQ
+libpq = -lpq
+endif
+
+ifdef INSTALLED_LIBPGTCL
+libpgtcl = -lpgtcl
+endif
diff --git a/databases/postgresql80/files/netbsd.c b/databases/postgresql80/files/netbsd.c
new file mode 100644
index 00000000000..d2ef8e70699
--- /dev/null
+++ b/databases/postgresql80/files/netbsd.c
@@ -0,0 +1,73 @@
+/*-
+ * Portions Copyright (c) 1996-2003, PostgreSQL Global Development Group
+ * Portions Copyright (c) 1990 The Regents of the University of California.
+ * All rights reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions
+ * are met:
+ * 1. Redistributions of source code must retain the above copyright
+ * notice, this list of conditions and the following disclaimer.
+ * 2. Redistributions in binary form must reproduce the above copyright
+ * notice, this list of conditions and the following disclaimer in the
+ * documentation and/or other materials provided with the distribution.
+ * 3. All advertising materials mentioning features or use of this software
+ * must display the following acknowledgement:
+ * This product includes software developed by the University of
+ * California, Berkeley and its contributors.
+ * 4. Neither the name of the University nor the names of its contributors
+ * may be used to endorse or promote products derived from this software
+ * without specific prior written permission.
+ *
+ * THIS SOFTWARE IS PROVIDED BY THE REGENTS AND CONTRIBUTORS ``AS IS'' AND
+ * ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+ * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
+ * ARE DISCLAIMED. IN NO EVENT SHALL THE REGENTS OR CONTRIBUTORS BE LIABLE
+ * FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
+ * DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS
+ * OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
+ * HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
+ * LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY
+ * OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
+ * SUCH DAMAGE.
+ */
+
+#if defined(LIBC_SCCS) && !defined(lint)
+static char sccsid[] = "@(#)dl.c 5.4 (Berkeley) 2/23/91";
+#endif /* LIBC_SCCS and not lint */
+
+#include "postgres.h"
+
+#include <nlist.h>
+#include <link.h>
+#include <dlfcn.h>
+
+#include "dynloader.h"
+
+#ifndef HAVE_DLOPEN
+
+char *
+pg_dlerror(void)
+{
+ return "dynaloader unsupported";
+}
+
+void *
+pg_dlopen(const char *file, int num)
+{
+ elog(ERROR, "dynamic load not supported");
+ return NULL;
+}
+
+void *
+pg_dlsym(void *handle, const char *name)
+{
+ return NULL;
+}
+
+void
+pg_dlclose(void *handle)
+{
+}
+
+#endif /* ! HAVE_DLOPEN */
diff --git a/databases/postgresql80/files/netbsd.h b/databases/postgresql80/files/netbsd.h
new file mode 100644
index 00000000000..b9ac224d9e5
--- /dev/null
+++ b/databases/postgresql80/files/netbsd.h
@@ -0,0 +1,45 @@
+/*-------------------------------------------------------------------------
+ *
+ * netbsd.h
+ * port-specific prototypes for NetBSD
+ *
+ *
+ * Portions Copyright (c) 1996-2003, PostgreSQL Global Development Group
+ * Portions Copyright (c) 1994, Regents of the University of California
+ *
+ * $Id: netbsd.h,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $
+ *
+ *-------------------------------------------------------------------------
+ */
+#ifndef PORT_PROTOS_H
+#define PORT_PROTOS_H
+
+#include <sys/types.h>
+#include <nlist.h>
+#include <link.h>
+#include <dlfcn.h>
+
+#include "utils/dynamic_loader.h"
+
+#ifdef HAVE_DLOPEN
+/*
+ * In some older systems, the RTLD_NOW flag isn't defined and the mode
+ * argument to dlopen must always be 1. The RTLD_GLOBAL flag is wanted
+ * if available, but it doesn't exist everywhere.
+ * If it doesn't exist, set it to 0 so it has no effect.
+ */
+#ifndef RTLD_NOW
+#define RTLD_NOW 1
+#endif
+#ifndef RTLD_GLOBAL
+#define RTLD_GLOBAL 0
+#endif
+
+#define pg_dlopen(f) dlopen((f), RTLD_NOW | RTLD_GLOBAL)
+#define pg_dlsym dlsym
+#define pg_dlclose dlclose
+#define pg_dlerror dlerror
+
+#endif /* HAVE_DLOPEN */
+
+#endif /* PORT_PROTOS_H */
diff --git a/databases/postgresql80/patches/patch-aa b/databases/postgresql80/patches/patch-aa
new file mode 100644
index 00000000000..a6592ae3d6f
--- /dev/null
+++ b/databases/postgresql80/patches/patch-aa
@@ -0,0 +1,31 @@
+$NetBSD: patch-aa,v 1.1.1.1 2005/02/06 12:32:05 jdolecek Exp $
+
+--- src/Makefile.shlib.orig Tue Nov 9 17:02:42 2004
++++ src/Makefile.shlib
+@@ -132,7 +132,7 @@ endif
+
+ ifeq ($(PORTNAME), freebsd)
+ ifdef ELF_SYSTEM
+- shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
++ shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
+ LINK.shared = $(COMPILER) -shared -Wl,-x,-soname,$(soname)
+ else
+ shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
+@@ -149,7 +149,7 @@ ifeq ($(PORTNAME), netbsd)
+ endif
+
+ ifeq ($(PORTNAME), hpux)
+- shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
++ shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
+ ifeq ($(GCC), yes)
+ SHLIB_LINK += `$(CC) $(LDFLAGS) -print-libgcc-file-name`
+ endif
+@@ -161,7 +161,7 @@ ifeq ($(PORTNAME), hpux)
+ endif
+
+ ifeq ($(PORTNAME), irix)
+- shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)
++ shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
+ LINK.shared = $(COMPILER) -shared -Wl,-set_version,sgi$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)
+ endif
+