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.

4 files changed, 348 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