diff options
author | adam <adam@pkgsrc.org> | 2011-09-15 08:27:38 +0000 |
---|---|---|
committer | adam <adam@pkgsrc.org> | 2011-09-15 08:27:38 +0000 |
commit | bfd12bfb1edc31693ca2b3ac46752e60f3f5f362 (patch) | |
tree | e4278cd9abc25bd225f1dd7ef33d4023332332b6 | |
parent | d162e8d1617159d190abd1e6ec4d1fdca0c6bdb2 (diff) | |
download | pkgsrc-bfd12bfb1edc31693ca2b3ac46752e60f3f5f362.tar.gz |
Version 9.1 delivers several features which users have been requesting for
years, removing roadblocks to deploying new or ported applications on
PostgreSQL. These include:
* Synchronous Replication: enable high-availability with consistency across
multiple servers
* Per-Column Collations: support linguistically-correct sorting per database,
table or column.
* Unlogged Tables: greatly improves performance for ephemeral data
Our community of contributors innovates with cutting-edge features. Version 9.1
includes several which are new to the database industry, such as:
* K-Nearest-Neighbor Indexing: index on "distance" for faster location and text
search queries
* Serializable Snapshot Isolation: keeps concurrent transactions consistent
without blocking, using "true serializability"
* Writeable Common Table Expressions: execute complex multi-stage data updates
in a single query
* Security-Enhanced Postgres: deploy military-grade security and Mandatory
Access Control
70 files changed, 4014 insertions, 0 deletions
diff --git a/databases/postgresql91-adminpack/DESCR b/databases/postgresql91-adminpack/DESCR new file mode 100644 index 00000000000..69453f2b72c --- /dev/null +++ b/databases/postgresql91-adminpack/DESCR @@ -0,0 +1,4 @@ +The ``adminpack'' PostgreSQL contrib module implements a number of +support functions which pgAdmin and other administration and management +tools can use to provide additional functionality if installed on a +server. diff --git a/databases/postgresql91-adminpack/Makefile b/databases/postgresql91-adminpack/Makefile new file mode 100644 index 00000000000..c5d21b6484a --- /dev/null +++ b/databases/postgresql91-adminpack/Makefile @@ -0,0 +1,17 @@ +# $NetBSD: Makefile,v 1.1.1.1 2011/09/15 08:29:43 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/91-adminpack-/} +COMMENT= Admin pack module for pgAdmin management + +PKG_DESTDIR_SUPPORT= user-destdir + +DEPENDS+= postgresql91-server>=${PKGVERSION_NOREV}:../../databases/postgresql91-server + +.include "../../databases/postgresql91/Makefile.common" + +BUILD_MAKE_FLAGS= PGXS=1 + +BUILD_DIRS= contrib/adminpack + +.include "../../databases/postgresql91-client/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql91-adminpack/PLIST b/databases/postgresql91-adminpack/PLIST new file mode 100644 index 00000000000..ef078db136a --- /dev/null +++ b/databases/postgresql91-adminpack/PLIST @@ -0,0 +1,4 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2011/09/15 08:29:43 adam Exp $ +lib/postgresql/adminpack.so +share/postgresql/extension/adminpack--1.0.sql +share/postgresql/extension/adminpack.control diff --git a/databases/postgresql91-client/DESCR b/databases/postgresql91-client/DESCR new file mode 100644 index 00000000000..a485664e6f1 --- /dev/null +++ b/databases/postgresql91-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/postgresql91-client/Makefile b/databases/postgresql91-client/Makefile new file mode 100644 index 00000000000..0e70aa0187d --- /dev/null +++ b/databases/postgresql91-client/Makefile @@ -0,0 +1,85 @@ +# $NetBSD: Makefile,v 1.1.1.1 2011/09/15 08:28:07 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/91-client-/} +COMMENT= PostgreSQL database client programs + +PKG_DESTDIR_SUPPORT= user-destdir + +.include "../../databases/postgresql91/Makefile.common" + +USE_TOOLS+= gzip tar +CONFIGURE_ARGS+= --with-openssl +CONFIGURE_ARGS+= --with-readline +CONFIGURE_ARGS+= --with-zlib + +# 1. The thread-safety test in ${WRSRC}/src/tools/thread does not pass on +# NetBSD earler than 4.0 or DragonFly. +# 2. configure with --enable-thread-safety fails on OpenBSD. +.if (${OPSYS} == "NetBSD" && !empty(OS_VERSION:M[0-3].*)) || \ + ${OPSYS} == "DragonFly" || ${OPSYS} == "OpenBSD" +PGSQL_THREAD_SAFETY?= no +.endif +PGSQL_THREAD_SAFETY?= yes +BUILD_DEFS+= PGSQL_THREAD_SAFETY + +.if !empty(PGSQL_THREAD_SAFETY:M[yY][eE][sS]) +. include "../../mk/pthread.buildlink3.mk" +. if (${PTHREAD_TYPE} == "native") +CONFIGURE_ARGS+= --enable-thread-safety +. endif +.endif + +LIBS.SunOS+= -lintl + +INSTALL_DIRS= src/include +INSTALL_DIRS+= src/interfaces +INSTALL_DIRS+= src/bin +INSTALL_DIRS+= src/port +BUILD_DIRS= ${INSTALL_DIRS} +# Without this, the Darwin build fails (related to -bundle_loader). +BUILD_DIRS+= src/backend + +.for f in pg_service.conf psqlrc +CONF_FILES+= share/postgresql/${f}.sample ${PKG_SYSCONFDIR}/${f} +.endfor + +# XXX work around core dumps with the native libedit +USE_GNU_READLINE= yes + +.include "../../devel/readline/buildlink3.mk" +.include "../../devel/zlib/buildlink3.mk" +.include "../../security/openssl/buildlink3.mk" + +SUBST_CLASSES+= pgxs +SUBST_STAGE.pgxs= post-build +SUBST_MESSAGE.pgxs= Fixing workdir tools references in pgxs Makefile +SUBST_FILES.pgxs= src/Makefile.global +SUBST_SED.pgxs= -e 's,${WRKDIR}/.tools,${PREFIX},' +SUBST_SED.pgxs+= -e 's,${WRKDIR}/.wrapper/bin/ld,${LD},' +SUBST_SED.pgxs+= -e 's,${WRKDIR}/.wrapper,${PREFIX},' +SUBST_SED.pgxs+= -e 's,${WRKSRC},/dev/null,' + +INSTALLATION_DIRS+= lib/postgresql/pgxs +INSTALLATION_DIRS+= lib/postgresql/pgxs/config +INSTALLATION_DIRS+= lib/postgresql/pgxs/src +INSTALLATION_DIRS+= lib/postgresql/pgxs/src/makefiles + +DEST_PGXS= ${DESTDIR}${PREFIX}/lib/postgresql/pgxs +PGXS_FILES= config/install-sh +PGXS_FILES+= src/makefiles/pgxs.mk src/Makefile.global +PGXS_FILES+= src/Makefile.port src/Makefile.shlib +PGXS_FILES+= src/nls-global.mk + +# On Solaris, avoid conflicts between "${SSLBASE}/include/openssl/des.h" +# and "/usr/include/crypt.h" -- we want the definitions in the former. +.if ${OPSYS} == "SunOS" +post-wrapper: + touch ${BUILDLINK_DIR}/include/crypt.h +.endif + +post-install: +.for file in ${PGXS_FILES} + ${INSTALL_DATA} ${WRKSRC}/${file} ${DEST_PGXS}/${file} +.endfor + +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql91-client/PLIST b/databases/postgresql91-client/PLIST new file mode 100644 index 00000000000..547805429a4 --- /dev/null +++ b/databases/postgresql91-client/PLIST @@ -0,0 +1,716 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2011/09/15 08:28:07 adam Exp $ +bin/clusterdb +bin/createdb +bin/createlang +bin/createuser +bin/dropdb +bin/droplang +bin/dropuser +bin/ecpg +bin/initdb +bin/pg_basebackup +bin/pg_config +bin/pg_controldata +bin/pg_ctl +bin/pg_dump +bin/pg_dumpall +bin/pg_resetxlog +bin/pg_restore +bin/psql +bin/reindexdb +bin/vacuumdb +include/ecpg_config.h +include/ecpg_informix.h +include/ecpgerrno.h +include/ecpglib.h +include/ecpgtype.h +include/libpq-events.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/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/gin.h +include/postgresql/server/access/gin_private.h +include/postgresql/server/access/gist.h +include/postgresql/server/access/gist_private.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/itup.h +include/postgresql/server/access/multixact.h +include/postgresql/server/access/nbtree.h +include/postgresql/server/access/printtup.h +include/postgresql/server/access/reloptions.h +include/postgresql/server/access/relscan.h +include/postgresql/server/access/rewriteheap.h +include/postgresql/server/access/rmgr.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/sysattr.h +include/postgresql/server/access/transam.h +include/postgresql/server/access/tupconvert.h +include/postgresql/server/access/tupdesc.h +include/postgresql/server/access/tupmacs.h +include/postgresql/server/access/tuptoaster.h +include/postgresql/server/access/twophase.h +include/postgresql/server/access/twophase_rmgr.h +include/postgresql/server/access/valid.h +include/postgresql/server/access/visibilitymap.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/catversion.h +include/postgresql/server/catalog/dependency.h +include/postgresql/server/catalog/genbki.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/objectaccess.h +include/postgresql/server/catalog/objectaddress.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_auth_members.h +include/postgresql/server/catalog/pg_authid.h +include/postgresql/server/catalog/pg_cast.h +include/postgresql/server/catalog/pg_class.h +include/postgresql/server/catalog/pg_collation.h +include/postgresql/server/catalog/pg_collation_fn.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_conversion_fn.h +include/postgresql/server/catalog/pg_database.h +include/postgresql/server/catalog/pg_db_role_setting.h +include/postgresql/server/catalog/pg_default_acl.h +include/postgresql/server/catalog/pg_depend.h +include/postgresql/server/catalog/pg_description.h +include/postgresql/server/catalog/pg_enum.h +include/postgresql/server/catalog/pg_extension.h +include/postgresql/server/catalog/pg_foreign_data_wrapper.h +include/postgresql/server/catalog/pg_foreign_server.h +include/postgresql/server/catalog/pg_foreign_table.h +include/postgresql/server/catalog/pg_index.h +include/postgresql/server/catalog/pg_inherits.h +include/postgresql/server/catalog/pg_inherits_fn.h +include/postgresql/server/catalog/pg_language.h +include/postgresql/server/catalog/pg_largeobject.h +include/postgresql/server/catalog/pg_largeobject_metadata.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_opfamily.h +include/postgresql/server/catalog/pg_pltemplate.h +include/postgresql/server/catalog/pg_proc.h +include/postgresql/server/catalog/pg_proc_fn.h +include/postgresql/server/catalog/pg_rewrite.h +include/postgresql/server/catalog/pg_seclabel.h +include/postgresql/server/catalog/pg_shdepend.h +include/postgresql/server/catalog/pg_shdescription.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_ts_config.h +include/postgresql/server/catalog/pg_ts_config_map.h +include/postgresql/server/catalog/pg_ts_dict.h +include/postgresql/server/catalog/pg_ts_parser.h +include/postgresql/server/catalog/pg_ts_template.h +include/postgresql/server/catalog/pg_type.h +include/postgresql/server/catalog/pg_type_fn.h +include/postgresql/server/catalog/pg_user_mapping.h +include/postgresql/server/catalog/schemapg.h +include/postgresql/server/catalog/storage.h +include/postgresql/server/catalog/toasting.h +include/postgresql/server/commands/alter.h +include/postgresql/server/commands/async.h +include/postgresql/server/commands/cluster.h +include/postgresql/server/commands/collationcmds.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/discard.h +include/postgresql/server/commands/explain.h +include/postgresql/server/commands/extension.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/seclabel.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/view.h +include/postgresql/server/dynloader.h +include/postgresql/server/executor/execdebug.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/nodeBitmapAnd.h +include/postgresql/server/executor/nodeBitmapHeapscan.h +include/postgresql/server/executor/nodeBitmapIndexscan.h +include/postgresql/server/executor/nodeBitmapOr.h +include/postgresql/server/executor/nodeCtescan.h +include/postgresql/server/executor/nodeForeignscan.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/nodeLockRows.h +include/postgresql/server/executor/nodeMaterial.h +include/postgresql/server/executor/nodeMergeAppend.h +include/postgresql/server/executor/nodeMergejoin.h +include/postgresql/server/executor/nodeModifyTable.h +include/postgresql/server/executor/nodeNestloop.h +include/postgresql/server/executor/nodeRecursiveunion.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/nodeValuesscan.h +include/postgresql/server/executor/nodeWindowAgg.h +include/postgresql/server/executor/nodeWorktablescan.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/foreign/fdwapi.h +include/postgresql/server/foreign/foreign.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/md5.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/replnodes.h +include/postgresql/server/nodes/tidbitmap.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/placeholder.h +include/postgresql/server/optimizer/plancat.h +include/postgresql/server/optimizer/planmain.h +include/postgresql/server/optimizer/planner.h +include/postgresql/server/optimizer/predtest.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/gram.h +include/postgresql/server/parser/gramparse.h +include/postgresql/server/parser/keywords.h +include/postgresql/server/parser/kwlist.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_collate.h +include/postgresql/server/parser/parse_cte.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_param.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/parse_utilcmd.h +include/postgresql/server/parser/parser.h +include/postgresql/server/parser/parsetree.h +include/postgresql/server/parser/scanner.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/pg_trace.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/bsdi.h +include/postgresql/server/port/cygwin.h +include/postgresql/server/port/darwin.h +include/postgresql/server/port/dgux.h +include/postgresql/server/port/dragonfly.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/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/port/win32_msvc/dirent.h +include/postgresql/server/port/win32_msvc/sys/file.h +include/postgresql/server/port/win32_msvc/sys/param.h +include/postgresql/server/port/win32_msvc/sys/time.h +include/postgresql/server/port/win32_msvc/unistd.h +include/postgresql/server/port/win32_msvc/utime.h +include/postgresql/server/portability/instr_time.h +include/postgresql/server/postgres.h +include/postgresql/server/postgres_ext.h +include/postgresql/server/postgres_fe.h +include/postgresql/server/postmaster/autovacuum.h +include/postgresql/server/postmaster/bgwriter.h +include/postgresql/server/postmaster/fork_process.h +include/postgresql/server/postmaster/pgarch.h +include/postgresql/server/postmaster/postmaster.h +include/postgresql/server/postmaster/syslogger.h +include/postgresql/server/postmaster/walwriter.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/replication/basebackup.h +include/postgresql/server/replication/syncrep.h +include/postgresql/server/replication/walprotocol.h +include/postgresql/server/replication/walreceiver.h +include/postgresql/server/replication/walsender.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/snowball/header.h +include/postgresql/server/snowball/libstemmer/api.h +include/postgresql/server/snowball/libstemmer/header.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_danish.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_dutch.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_english.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_finnish.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_french.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_german.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_hungarian.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_italian.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_norwegian.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_porter.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_portuguese.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_spanish.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_swedish.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_2_romanian.h +include/postgresql/server/snowball/libstemmer/stem_KOI8_R_russian.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_danish.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_dutch.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_english.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_finnish.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_french.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_german.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_hungarian.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_italian.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_norwegian.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_porter.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_portuguese.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_romanian.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_russian.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_spanish.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_swedish.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_turkish.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/copydir.h +include/postgresql/server/storage/fd.h +include/postgresql/server/storage/freespace.h +include/postgresql/server/storage/fsm_internals.h +include/postgresql/server/storage/indexfsm.h +include/postgresql/server/storage/ipc.h +include/postgresql/server/storage/item.h +include/postgresql/server/storage/itemid.h +include/postgresql/server/storage/itemptr.h +include/postgresql/server/storage/large_object.h +include/postgresql/server/storage/latch.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/predicate.h +include/postgresql/server/storage/predicate_internals.h +include/postgresql/server/storage/proc.h +include/postgresql/server/storage/procarray.h +include/postgresql/server/storage/procsignal.h +include/postgresql/server/storage/reinit.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/storage/standby.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/tsearch/dicts/regis.h +include/postgresql/server/tsearch/dicts/spell.h +include/postgresql/server/tsearch/ts_cache.h +include/postgresql/server/tsearch/ts_locale.h +include/postgresql/server/tsearch/ts_public.h +include/postgresql/server/tsearch/ts_type.h +include/postgresql/server/tsearch/ts_utils.h +include/postgresql/server/utils/acl.h +include/postgresql/server/utils/array.h +include/postgresql/server/utils/ascii.h +include/postgresql/server/utils/attoptcache.h +include/postgresql/server/utils/builtins.h +include/postgresql/server/utils/bytea.h +include/postgresql/server/utils/cash.h +include/postgresql/server/utils/catcache.h +include/postgresql/server/utils/combocid.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/pg_rusage.h +include/postgresql/server/utils/plancache.h +include/postgresql/server/utils/portal.h +include/postgresql/server/utils/probes.h +include/postgresql/server/utils/ps_status.h +include/postgresql/server/utils/rbtree.h +include/postgresql/server/utils/rel.h +include/postgresql/server/utils/relcache.h +include/postgresql/server/utils/relmapper.h +include/postgresql/server/utils/resowner.h +include/postgresql/server/utils/selfuncs.h +include/postgresql/server/utils/snapmgr.h +include/postgresql/server/utils/snapshot.h +include/postgresql/server/utils/spccache.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/tzparser.h +include/postgresql/server/utils/uuid.h +include/postgresql/server/utils/varbit.h +include/postgresql/server/utils/xml.h +include/postgresql/server/windowapi.h +include/sql3types.h +include/sqlca.h +include/sqlda-compat.h +include/sqlda-native.h +include/sqlda.h +lib/libecpg.6.3.dylib +lib/libecpg.a +lib/libecpg.so +lib/libecpg.so.6 +lib/libecpg.so.6.2 +lib/libecpg_compat.3.3.dylib +lib/libecpg_compat.a +lib/libecpg_compat.so +lib/libecpg_compat.so.3 +lib/libecpg_compat.so.3.2 +lib/libpgport.a +lib/libpgtypes.3.2.dylib +lib/libpgtypes.a +lib/libpgtypes.so +lib/libpgtypes.so.3 +lib/libpgtypes.so.3.1 +lib/libpq.5.4.dylib +lib/libpq.a +lib/libpq.so +lib/libpq.so.5 +lib/libpq.so.5.3 +lib/postgresql/pgxs/config/install-sh +lib/postgresql/pgxs/src/Makefile.global +lib/postgresql/pgxs/src/Makefile.port +lib/postgresql/pgxs/src/Makefile.shlib +lib/postgresql/pgxs/src/makefiles/pgxs.mk +lib/postgresql/pgxs/src/nls-global.mk +share/locale/cs/LC_MESSAGES/ecpg-9.1.mo +share/locale/cs/LC_MESSAGES/ecpglib6-9.1.mo +share/locale/cs/LC_MESSAGES/initdb-9.1.mo +share/locale/cs/LC_MESSAGES/libpq5-9.1.mo +share/locale/cs/LC_MESSAGES/pg_basebackup-9.1.mo +share/locale/cs/LC_MESSAGES/pg_config-9.1.mo +share/locale/cs/LC_MESSAGES/pg_controldata-9.1.mo +share/locale/cs/LC_MESSAGES/pg_ctl-9.1.mo +share/locale/cs/LC_MESSAGES/pg_dump-9.1.mo +share/locale/cs/LC_MESSAGES/pg_resetxlog-9.1.mo +share/locale/cs/LC_MESSAGES/pgscripts-9.1.mo +share/locale/cs/LC_MESSAGES/psql-9.1.mo +share/locale/de/LC_MESSAGES/ecpg-9.1.mo +share/locale/de/LC_MESSAGES/ecpglib6-9.1.mo +share/locale/de/LC_MESSAGES/initdb-9.1.mo +share/locale/de/LC_MESSAGES/libpq5-9.1.mo +share/locale/de/LC_MESSAGES/pg_basebackup-9.1.mo +share/locale/de/LC_MESSAGES/pg_config-9.1.mo +share/locale/de/LC_MESSAGES/pg_controldata-9.1.mo +share/locale/de/LC_MESSAGES/pg_ctl-9.1.mo +share/locale/de/LC_MESSAGES/pg_dump-9.1.mo +share/locale/de/LC_MESSAGES/pg_resetxlog-9.1.mo +share/locale/de/LC_MESSAGES/pgscripts-9.1.mo +share/locale/de/LC_MESSAGES/psql-9.1.mo +share/locale/es/LC_MESSAGES/ecpg-9.1.mo +share/locale/es/LC_MESSAGES/ecpglib6-9.1.mo +share/locale/es/LC_MESSAGES/initdb-9.1.mo +share/locale/es/LC_MESSAGES/libpq5-9.1.mo +share/locale/es/LC_MESSAGES/pg_basebackup-9.1.mo +share/locale/es/LC_MESSAGES/pg_config-9.1.mo +share/locale/es/LC_MESSAGES/pg_controldata-9.1.mo +share/locale/es/LC_MESSAGES/pg_ctl-9.1.mo +share/locale/es/LC_MESSAGES/pg_dump-9.1.mo +share/locale/es/LC_MESSAGES/pg_resetxlog-9.1.mo +share/locale/es/LC_MESSAGES/pgscripts-9.1.mo +share/locale/es/LC_MESSAGES/psql-9.1.mo +share/locale/fr/LC_MESSAGES/ecpg-9.1.mo +share/locale/fr/LC_MESSAGES/ecpglib6-9.1.mo +share/locale/fr/LC_MESSAGES/initdb-9.1.mo +share/locale/fr/LC_MESSAGES/libpq5-9.1.mo +share/locale/fr/LC_MESSAGES/pg_basebackup-9.1.mo +share/locale/fr/LC_MESSAGES/pg_config-9.1.mo +share/locale/fr/LC_MESSAGES/pg_controldata-9.1.mo +share/locale/fr/LC_MESSAGES/pg_ctl-9.1.mo +share/locale/fr/LC_MESSAGES/pg_dump-9.1.mo +share/locale/fr/LC_MESSAGES/pg_resetxlog-9.1.mo +share/locale/fr/LC_MESSAGES/pgscripts-9.1.mo +share/locale/fr/LC_MESSAGES/psql-9.1.mo +share/locale/it/LC_MESSAGES/ecpg-9.1.mo +share/locale/it/LC_MESSAGES/ecpglib6-9.1.mo +share/locale/it/LC_MESSAGES/initdb-9.1.mo +share/locale/it/LC_MESSAGES/libpq5-9.1.mo +share/locale/it/LC_MESSAGES/pg_config-9.1.mo +share/locale/it/LC_MESSAGES/pg_controldata-9.1.mo +share/locale/it/LC_MESSAGES/pg_dump-9.1.mo +share/locale/it/LC_MESSAGES/pg_resetxlog-9.1.mo +share/locale/it/LC_MESSAGES/pgscripts-9.1.mo +share/locale/ja/LC_MESSAGES/ecpg-9.1.mo +share/locale/ja/LC_MESSAGES/ecpglib6-9.1.mo +share/locale/ja/LC_MESSAGES/initdb-9.1.mo +share/locale/ja/LC_MESSAGES/libpq5-9.1.mo +share/locale/ja/LC_MESSAGES/pg_basebackup-9.1.mo +share/locale/ja/LC_MESSAGES/pg_config-9.1.mo +share/locale/ja/LC_MESSAGES/pg_controldata-9.1.mo +share/locale/ja/LC_MESSAGES/pg_ctl-9.1.mo +share/locale/ja/LC_MESSAGES/pg_dump-9.1.mo +share/locale/ja/LC_MESSAGES/pg_resetxlog-9.1.mo +share/locale/ja/LC_MESSAGES/pgscripts-9.1.mo +share/locale/ja/LC_MESSAGES/psql-9.1.mo +share/locale/ko/LC_MESSAGES/ecpg-9.1.mo +share/locale/ko/LC_MESSAGES/initdb-9.1.mo +share/locale/ko/LC_MESSAGES/libpq5-9.1.mo +share/locale/ko/LC_MESSAGES/pg_config-9.1.mo +share/locale/ko/LC_MESSAGES/pg_controldata-9.1.mo +share/locale/ko/LC_MESSAGES/pg_dump-9.1.mo +share/locale/ko/LC_MESSAGES/pg_resetxlog-9.1.mo +share/locale/ko/LC_MESSAGES/pgscripts-9.1.mo +share/locale/nb/LC_MESSAGES/pg_config-9.1.mo +share/locale/pl/LC_MESSAGES/ecpg-9.1.mo +share/locale/pl/LC_MESSAGES/ecpglib6-9.1.mo +share/locale/pl/LC_MESSAGES/initdb-9.1.mo +share/locale/pl/LC_MESSAGES/libpq5-9.1.mo +share/locale/pl/LC_MESSAGES/pg_basebackup-9.1.mo +share/locale/pl/LC_MESSAGES/pg_config-9.1.mo +share/locale/pl/LC_MESSAGES/pg_controldata-9.1.mo +share/locale/pl/LC_MESSAGES/pg_ctl-9.1.mo +share/locale/pl/LC_MESSAGES/pg_dump-9.1.mo +share/locale/pl/LC_MESSAGES/pg_resetxlog-9.1.mo +share/locale/pl/LC_MESSAGES/pgscripts-9.1.mo +share/locale/pl/LC_MESSAGES/psql-9.1.mo +share/locale/pt_BR/LC_MESSAGES/ecpg-9.1.mo +share/locale/pt_BR/LC_MESSAGES/ecpglib6-9.1.mo +share/locale/pt_BR/LC_MESSAGES/initdb-9.1.mo +share/locale/pt_BR/LC_MESSAGES/libpq5-9.1.mo +share/locale/pt_BR/LC_MESSAGES/pg_basebackup-9.1.mo +share/locale/pt_BR/LC_MESSAGES/pg_config-9.1.mo +share/locale/pt_BR/LC_MESSAGES/pg_controldata-9.1.mo +share/locale/pt_BR/LC_MESSAGES/pg_ctl-9.1.mo +share/locale/pt_BR/LC_MESSAGES/pg_dump-9.1.mo +share/locale/pt_BR/LC_MESSAGES/pg_resetxlog-9.1.mo +share/locale/pt_BR/LC_MESSAGES/pgscripts-9.1.mo +share/locale/pt_BR/LC_MESSAGES/psql-9.1.mo +share/locale/ro/LC_MESSAGES/initdb-9.1.mo +share/locale/ro/LC_MESSAGES/pg_config-9.1.mo +share/locale/ro/LC_MESSAGES/pg_controldata-9.1.mo +share/locale/ro/LC_MESSAGES/pg_resetxlog-9.1.mo +share/locale/ro/LC_MESSAGES/pgscripts-9.1.mo +share/locale/ru/LC_MESSAGES/initdb-9.1.mo +share/locale/ru/LC_MESSAGES/libpq5-9.1.mo +share/locale/ru/LC_MESSAGES/pg_config-9.1.mo +share/locale/ru/LC_MESSAGES/pg_controldata-9.1.mo +share/locale/ru/LC_MESSAGES/pg_ctl-9.1.mo +share/locale/ru/LC_MESSAGES/pg_resetxlog-9.1.mo +share/locale/sv/LC_MESSAGES/initdb-9.1.mo +share/locale/sv/LC_MESSAGES/libpq5-9.1.mo +share/locale/sv/LC_MESSAGES/pg_config-9.1.mo +share/locale/sv/LC_MESSAGES/pg_dump-9.1.mo +share/locale/sv/LC_MESSAGES/pg_resetxlog-9.1.mo +share/locale/sv/LC_MESSAGES/pgscripts-9.1.mo +share/locale/ta/LC_MESSAGES/pg_config-9.1.mo +share/locale/ta/LC_MESSAGES/pg_resetxlog-9.1.mo +share/locale/ta/LC_MESSAGES/pgscripts-9.1.mo +share/locale/tr/LC_MESSAGES/ecpg-9.1.mo +share/locale/tr/LC_MESSAGES/ecpglib6-9.1.mo +share/locale/tr/LC_MESSAGES/initdb-9.1.mo +share/locale/tr/LC_MESSAGES/libpq5-9.1.mo +share/locale/tr/LC_MESSAGES/pg_config-9.1.mo +share/locale/tr/LC_MESSAGES/pg_controldata-9.1.mo +share/locale/tr/LC_MESSAGES/pg_ctl-9.1.mo +share/locale/tr/LC_MESSAGES/pg_dump-9.1.mo +share/locale/tr/LC_MESSAGES/pg_resetxlog-9.1.mo +share/locale/tr/LC_MESSAGES/pgscripts-9.1.mo +share/locale/tr/LC_MESSAGES/psql-9.1.mo +share/locale/zh_CN/LC_MESSAGES/ecpg-9.1.mo +share/locale/zh_CN/LC_MESSAGES/ecpglib6-9.1.mo +share/locale/zh_CN/LC_MESSAGES/initdb-9.1.mo +share/locale/zh_CN/LC_MESSAGES/libpq5-9.1.mo +share/locale/zh_CN/LC_MESSAGES/pg_config-9.1.mo +share/locale/zh_CN/LC_MESSAGES/pg_controldata-9.1.mo +share/locale/zh_CN/LC_MESSAGES/pg_dump-9.1.mo +share/locale/zh_CN/LC_MESSAGES/pg_resetxlog-9.1.mo +share/locale/zh_CN/LC_MESSAGES/pgscripts-9.1.mo +share/locale/zh_CN/LC_MESSAGES/psql-9.1.mo +share/locale/zh_TW/LC_MESSAGES/ecpg-9.1.mo +share/locale/zh_TW/LC_MESSAGES/initdb-9.1.mo +share/locale/zh_TW/LC_MESSAGES/libpq5-9.1.mo +share/locale/zh_TW/LC_MESSAGES/pg_config-9.1.mo +share/locale/zh_TW/LC_MESSAGES/pg_controldata-9.1.mo +share/locale/zh_TW/LC_MESSAGES/pg_ctl-9.1.mo +share/locale/zh_TW/LC_MESSAGES/pg_dump-9.1.mo +share/locale/zh_TW/LC_MESSAGES/pg_resetxlog-9.1.mo +share/locale/zh_TW/LC_MESSAGES/pgscripts-9.1.mo +share/locale/zh_TW/LC_MESSAGES/psql-9.1.mo +share/postgresql/pg_service.conf.sample +share/postgresql/psqlrc.sample diff --git a/databases/postgresql91-client/buildlink3.mk b/databases/postgresql91-client/buildlink3.mk new file mode 100644 index 00000000000..a59f8496114 --- /dev/null +++ b/databases/postgresql91-client/buildlink3.mk @@ -0,0 +1,21 @@ +# $NetBSD: buildlink3.mk,v 1.1.1.1 2011/09/15 08:28:07 adam Exp $ + +BUILDLINK_TREE+= postgresql91-client + +.if !defined(POSTGRESQL91_CLIENT_BUILDLINK3_MK) +POSTGRESQL91_CLIENT_BUILDLINK3_MK:= + +BUILDLINK_API_DEPENDS.postgresql91-client+= postgresql91-client>=9.1.0 +BUILDLINK_ABI_DEPENDS.postgresql91-client+= postgresql91-client>=9.1.0 +BUILDLINK_PKGSRCDIR.postgresql91-client?= ../../databases/postgresql91-client + +# This variable contains the libraries need to link most clients. +BUILDLINK_LDADD.postgresql91-client= -lpq ${BUILDLINK_LDADD.gettext} +BUILDLINK_FILES.postgresql91-client+= bin/pg_config + +.include "../../devel/gettext-lib/buildlink3.mk" +.include "../../devel/zlib/buildlink3.mk" +.include "../../security/openssl/buildlink3.mk" +.endif # POSTGRESQL91_CLIENT_BUILDLINK3_MK + +BUILDLINK_TREE+= -postgresql91-client diff --git a/databases/postgresql91-datatypes/DESCR b/databases/postgresql91-datatypes/DESCR new file mode 100644 index 00000000000..0fd1fb2d6cd --- /dev/null +++ b/databases/postgresql91-datatypes/DESCR @@ -0,0 +1,43 @@ +This package provides the following PostgreSQL modules: + - citext + - hstore + - intarray + - isn + - ltree + - lo + - uuid-ossp + - unaccent + +The "citext" module provides a case-insensitive character string type, +citext. Essentially, it internally calls lower when comparing values. +Otherwise, it behaves almost exactly like text. + +The "hstore" module implements the "hstore" data type for storing sets +of key/value pairs within a single PostgreSQL value. This can be useful +in various scenarios, such as rows with many attributes that are rarely +examined, or semi-structured data. Keys and values are simply text strings. + +The "intarray" module provides a number of useful functions and operators +for manipulating one-dimensional arrays of integers. There is also support +for indexed searches using some of the operators. + +The "isn" module provides data types for the following international +product numbering standards: EAN13, UPC, ISBN (books), ISMN (music), +and ISSN (serials). Numbers are validated on input, and correctly +hyphenated on output. + +The "ltree" module implements a data type ltree for representing +labels of data stored in a hierarchical tree-like structure. +Extensive facilities for searching through label trees are provided. + +The "lo" module provides support for managing Large Objects (also called +LOs or BLOBs). This includes a data type "lo" and a trigger "lo_manage." + +The "uuid-ossp" module provides functions to generate universally unique +identifiers (UUIDs) using one of several standard algorithms. There are +also functions to produce certain special UUID constants. + +"unaccent" is a text search dictionary that removes accents (diacritic signs) +from lexemes. It's a filtering dictionary, which means its output is always +passed to the next dictionary (if any), unlike the normal behavior of +dictionaries. This allows accent-insensitive processing for full text search. diff --git a/databases/postgresql91-datatypes/Makefile b/databases/postgresql91-datatypes/Makefile new file mode 100644 index 00000000000..90ab4336b64 --- /dev/null +++ b/databases/postgresql91-datatypes/Makefile @@ -0,0 +1,28 @@ +# $NetBSD: Makefile,v 1.1.1.1 2011/09/15 08:30:08 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/91-datatypes-/} +COMMENT= PostgreSQL data types support modules + +PKG_DESTDIR_SUPPORT= user-destdir + +DEPENDS+= postgresql91-server>=${PKGVERSION_NOREV}:../../databases/postgresql91-server + +.include "../../databases/postgresql91/Makefile.common" + +CONFIGURE_ARGS+= --with-ossp-uuid +# because global pg_config.h is included, we have to define this +CPPFLAGS+= -DHAVE_UUID_H + +BUILD_DIRS+= contrib/citext +BUILD_DIRS+= contrib/hstore +BUILD_DIRS+= contrib/intarray +BUILD_DIRS+= contrib/isn +BUILD_DIRS+= contrib/ltree +BUILD_DIRS+= contrib/lo +BUILD_DIRS+= contrib/uuid-ossp +BUILD_DIRS+= contrib/unaccent +BUILD_MAKE_FLAGS= PGXS=1 + +.include "../../databases/postgresql91-client/buildlink3.mk" +.include "../../devel/ossp-uuid/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql91-datatypes/PLIST b/databases/postgresql91-datatypes/PLIST new file mode 100644 index 00000000000..31d3f5deaa0 --- /dev/null +++ b/databases/postgresql91-datatypes/PLIST @@ -0,0 +1,34 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2011/09/15 08:30:08 adam Exp $ +lib/postgresql/_int.so +lib/postgresql/citext.so +lib/postgresql/hstore.so +lib/postgresql/isn.so +lib/postgresql/lo.so +lib/postgresql/ltree.so +lib/postgresql/unaccent.so +lib/postgresql/uuid-ossp.so +share/postgresql/extension/citext--1.0.sql +share/postgresql/extension/citext--unpackaged--1.0.sql +share/postgresql/extension/citext.control +share/postgresql/extension/hstore--1.0.sql +share/postgresql/extension/hstore--unpackaged--1.0.sql +share/postgresql/extension/hstore.control +share/postgresql/extension/intarray--1.0.sql +share/postgresql/extension/intarray--unpackaged--1.0.sql +share/postgresql/extension/intarray.control +share/postgresql/extension/isn--1.0.sql +share/postgresql/extension/isn--unpackaged--1.0.sql +share/postgresql/extension/isn.control +share/postgresql/extension/lo--1.0.sql +share/postgresql/extension/lo--unpackaged--1.0.sql +share/postgresql/extension/lo.control +share/postgresql/extension/ltree--1.0.sql +share/postgresql/extension/ltree--unpackaged--1.0.sql +share/postgresql/extension/ltree.control +share/postgresql/extension/unaccent--1.0.sql +share/postgresql/extension/unaccent--unpackaged--1.0.sql +share/postgresql/extension/unaccent.control +share/postgresql/extension/uuid-ossp--1.0.sql +share/postgresql/extension/uuid-ossp--unpackaged--1.0.sql +share/postgresql/extension/uuid-ossp.control +share/postgresql/tsearch_data/unaccent.rules diff --git a/databases/postgresql91-dblink/DESCR b/databases/postgresql91-dblink/DESCR new file mode 100644 index 00000000000..d6641c1971b --- /dev/null +++ b/databases/postgresql91-dblink/DESCR @@ -0,0 +1,2 @@ +The ``dblink'' PostgreSQL contrib module to connect to remote database +servers. diff --git a/databases/postgresql91-dblink/Makefile b/databases/postgresql91-dblink/Makefile new file mode 100644 index 00000000000..1929edbf439 --- /dev/null +++ b/databases/postgresql91-dblink/Makefile @@ -0,0 +1,18 @@ +# $NetBSD: Makefile,v 1.1.1.1 2011/09/15 08:30:25 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/91-dblink-/} +COMMENT= Dblink module for remote database connections + +PKG_DESTDIR_SUPPORT= user-destdir + +DEPENDS+= postgresql91-server>=${PKGVERSION_NOREV}:../../databases/postgresql91-server + +.include "../../databases/postgresql91/Makefile.common" + +CONFIGURE_ARGS+= --with-openssl +BUILD_MAKE_FLAGS= PGXS=1 + +BUILD_DIRS= contrib/dblink + +.include "../../databases/postgresql91-client/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql91-dblink/PLIST b/databases/postgresql91-dblink/PLIST new file mode 100644 index 00000000000..f927238a59e --- /dev/null +++ b/databases/postgresql91-dblink/PLIST @@ -0,0 +1,5 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2011/09/15 08:30:25 adam Exp $ +lib/postgresql/dblink.so +share/postgresql/extension/dblink--1.0.sql +share/postgresql/extension/dblink--unpackaged--1.0.sql +share/postgresql/extension/dblink.control diff --git a/databases/postgresql91-docs/DESCR b/databases/postgresql91-docs/DESCR new file mode 100644 index 00000000000..89dd99e91c2 --- /dev/null +++ b/databases/postgresql91-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/postgresql91-docs/Makefile b/databases/postgresql91-docs/Makefile new file mode 100644 index 00000000000..9461c872f25 --- /dev/null +++ b/databases/postgresql91-docs/Makefile @@ -0,0 +1,23 @@ +# $NetBSD: Makefile,v 1.1.1.1 2011/09/15 08:28:56 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/91-docs-/} +COMMENT= PostgreSQL database documentation + +PKG_DESTDIR_SUPPORT= user-destdir + +.include "../../databases/postgresql91/Makefile.common" + +BUILD_DEPENDS+= docbook-xml>=4.5:../../textproc/docbook-xml +BUILD_DEPENDS+= docbook-xsl>=1.75.2:../../textproc/docbook-xsl +BUILD_DEPENDS+= dsssl-docbook-modular>=1.79:../../textproc/dsssl-docbook-modular +BUILD_DEPENDS+= iso8879>=1986:../../textproc/iso8879 +BUILD_DEPENDS+= openjade>=1.3.2:../../textproc/openjade +BUILD_DEPENDS+= libxslt-[0-9]*:../../textproc/libxslt + +USE_TOOLS+= gzip tar perl:build +CONFIGURE_ARGS+= --datarootdir=${PREFIX}/share +CONFIGURE_ENV+= DOCBOOKSTYLE="${PREFIX}/share/sgml/docbook/dsssl/modular" + +BUILD_DIRS= doc + +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql91-docs/PLIST b/databases/postgresql91-docs/PLIST new file mode 100644 index 00000000000..1a2f929a48d --- /dev/null +++ b/databases/postgresql91-docs/PLIST @@ -0,0 +1,1098 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2011/09/15 08:28:56 adam Exp $ +share/doc/postgresql/html/LEGALNOTICE.html +share/doc/postgresql/html/acronyms.html +share/doc/postgresql/html/admin.html +share/doc/postgresql/html/adminpack.html +share/doc/postgresql/html/app-clusterdb.html +share/doc/postgresql/html/app-createdb.html +share/doc/postgresql/html/app-createlang.html +share/doc/postgresql/html/app-createuser.html +share/doc/postgresql/html/app-dropdb.html +share/doc/postgresql/html/app-droplang.html +share/doc/postgresql/html/app-dropuser.html +share/doc/postgresql/html/app-ecpg.html +share/doc/postgresql/html/app-initdb.html +share/doc/postgresql/html/app-pg-ctl.html +share/doc/postgresql/html/app-pg-dumpall.html +share/doc/postgresql/html/app-pgbasebackup.html +share/doc/postgresql/html/app-pgconfig.html +share/doc/postgresql/html/app-pgcontroldata.html +share/doc/postgresql/html/app-pgdump.html +share/doc/postgresql/html/app-pgresetxlog.html +share/doc/postgresql/html/app-pgrestore.html +share/doc/postgresql/html/app-postgres.html +share/doc/postgresql/html/app-postmaster.html +share/doc/postgresql/html/app-psql.html +share/doc/postgresql/html/app-reindexdb.html +share/doc/postgresql/html/app-vacuumdb.html +share/doc/postgresql/html/appendixes.html +share/doc/postgresql/html/applevel-consistency.html +share/doc/postgresql/html/archive-recovery-settings.html +share/doc/postgresql/html/arrays.html +share/doc/postgresql/html/auth-delay.html +share/doc/postgresql/html/auth-methods.html +share/doc/postgresql/html/auth-pg-hba-conf.html +share/doc/postgresql/html/auth-username-maps.html +share/doc/postgresql/html/auto-explain.html +share/doc/postgresql/html/backup-dump.html +share/doc/postgresql/html/backup-file.html +share/doc/postgresql/html/backup.html +share/doc/postgresql/html/biblio.html +share/doc/postgresql/html/bki-commands.html +share/doc/postgresql/html/bki-example.html +share/doc/postgresql/html/bki-format.html +share/doc/postgresql/html/bki-structure.html +share/doc/postgresql/html/bki.html +share/doc/postgresql/html/bookindex.html +share/doc/postgresql/html/btree-gin.html +share/doc/postgresql/html/btree-gist.html +share/doc/postgresql/html/bug-reporting.html +share/doc/postgresql/html/catalog-pg-aggregate.html +share/doc/postgresql/html/catalog-pg-am.html +share/doc/postgresql/html/catalog-pg-amop.html +share/doc/postgresql/html/catalog-pg-amproc.html +share/doc/postgresql/html/catalog-pg-attrdef.html +share/doc/postgresql/html/catalog-pg-attribute.html +share/doc/postgresql/html/catalog-pg-auth-members.html +share/doc/postgresql/html/catalog-pg-authid.html +share/doc/postgresql/html/catalog-pg-cast.html +share/doc/postgresql/html/catalog-pg-class.html +share/doc/postgresql/html/catalog-pg-collation.html +share/doc/postgresql/html/catalog-pg-constraint.html +share/doc/postgresql/html/catalog-pg-conversion.html +share/doc/postgresql/html/catalog-pg-database.html +share/doc/postgresql/html/catalog-pg-db-role-setting.html +share/doc/postgresql/html/catalog-pg-default-acl.html +share/doc/postgresql/html/catalog-pg-depend.html +share/doc/postgresql/html/catalog-pg-description.html +share/doc/postgresql/html/catalog-pg-enum.html +share/doc/postgresql/html/catalog-pg-extension.html +share/doc/postgresql/html/catalog-pg-foreign-data-wrapper.html +share/doc/postgresql/html/catalog-pg-foreign-server.html +share/doc/postgresql/html/catalog-pg-foreign-table.html +share/doc/postgresql/html/catalog-pg-index.html +share/doc/postgresql/html/catalog-pg-inherits.html +share/doc/postgresql/html/catalog-pg-language.html +share/doc/postgresql/html/catalog-pg-largeobject-metadata.html +share/doc/postgresql/html/catalog-pg-largeobject.html +share/doc/postgresql/html/catalog-pg-namespace.html +share/doc/postgresql/html/catalog-pg-opclass.html +share/doc/postgresql/html/catalog-pg-operator.html +share/doc/postgresql/html/catalog-pg-opfamily.html +share/doc/postgresql/html/catalog-pg-pltemplate.html +share/doc/postgresql/html/catalog-pg-proc.html +share/doc/postgresql/html/catalog-pg-rewrite.html +share/doc/postgresql/html/catalog-pg-seclabel.html +share/doc/postgresql/html/catalog-pg-shdepend.html +share/doc/postgresql/html/catalog-pg-shdescription.html +share/doc/postgresql/html/catalog-pg-statistic.html +share/doc/postgresql/html/catalog-pg-tablespace.html +share/doc/postgresql/html/catalog-pg-trigger.html +share/doc/postgresql/html/catalog-pg-ts-config-map.html +share/doc/postgresql/html/catalog-pg-ts-config.html +share/doc/postgresql/html/catalog-pg-ts-dict.html +share/doc/postgresql/html/catalog-pg-ts-parser.html +share/doc/postgresql/html/catalog-pg-ts-template.html +share/doc/postgresql/html/catalog-pg-type.html +share/doc/postgresql/html/catalog-pg-user-mapping.html +share/doc/postgresql/html/catalogs-overview.html +share/doc/postgresql/html/catalogs.html +share/doc/postgresql/html/charset.html +share/doc/postgresql/html/chkpass.html +share/doc/postgresql/html/citext.html +share/doc/postgresql/html/client-authentication-problems.html +share/doc/postgresql/html/client-authentication.html +share/doc/postgresql/html/client-interfaces.html +share/doc/postgresql/html/collation.html +share/doc/postgresql/html/config-setting.html +share/doc/postgresql/html/connect-estab.html +share/doc/postgresql/html/continuous-archiving.html +share/doc/postgresql/html/contrib-dblink-build-sql-delete.html +share/doc/postgresql/html/contrib-dblink-build-sql-insert.html +share/doc/postgresql/html/contrib-dblink-build-sql-update.html +share/doc/postgresql/html/contrib-dblink-cancel-query.html +share/doc/postgresql/html/contrib-dblink-close.html +share/doc/postgresql/html/contrib-dblink-connect-u.html +share/doc/postgresql/html/contrib-dblink-connect.html +share/doc/postgresql/html/contrib-dblink-disconnect.html +share/doc/postgresql/html/contrib-dblink-error-message.html +share/doc/postgresql/html/contrib-dblink-exec.html +share/doc/postgresql/html/contrib-dblink-fetch.html +share/doc/postgresql/html/contrib-dblink-function.html +share/doc/postgresql/html/contrib-dblink-get-connections.html +share/doc/postgresql/html/contrib-dblink-get-notify.html +share/doc/postgresql/html/contrib-dblink-get-pkey.html +share/doc/postgresql/html/contrib-dblink-get-result.html +share/doc/postgresql/html/contrib-dblink-is-busy.html +share/doc/postgresql/html/contrib-dblink-open.html +share/doc/postgresql/html/contrib-dblink-send-query.html +share/doc/postgresql/html/contrib-spi.html +share/doc/postgresql/html/contrib.html +share/doc/postgresql/html/creating-cluster.html +share/doc/postgresql/html/cube.html +share/doc/postgresql/html/database-roles.html +share/doc/postgresql/html/datatype-binary.html +share/doc/postgresql/html/datatype-bit.html +share/doc/postgresql/html/datatype-boolean.html +share/doc/postgresql/html/datatype-character.html +share/doc/postgresql/html/datatype-datetime.html +share/doc/postgresql/html/datatype-enum.html +share/doc/postgresql/html/datatype-geometric.html +share/doc/postgresql/html/datatype-money.html +share/doc/postgresql/html/datatype-net-types.html +share/doc/postgresql/html/datatype-numeric.html +share/doc/postgresql/html/datatype-oid.html +share/doc/postgresql/html/datatype-pseudo.html +share/doc/postgresql/html/datatype-textsearch.html +share/doc/postgresql/html/datatype-uuid.html +share/doc/postgresql/html/datatype-xml.html +share/doc/postgresql/html/datatype.html +share/doc/postgresql/html/datetime-appendix.html +share/doc/postgresql/html/datetime-config-files.html +share/doc/postgresql/html/datetime-input-rules.html +share/doc/postgresql/html/datetime-keywords.html +share/doc/postgresql/html/datetime-units-history.html +share/doc/postgresql/html/dblink.html +share/doc/postgresql/html/ddl-alter.html +share/doc/postgresql/html/ddl-basics.html +share/doc/postgresql/html/ddl-constraints.html +share/doc/postgresql/html/ddl-default.html +share/doc/postgresql/html/ddl-depend.html +share/doc/postgresql/html/ddl-foreign-data.html +share/doc/postgresql/html/ddl-inherit.html +share/doc/postgresql/html/ddl-others.html +share/doc/postgresql/html/ddl-partitioning.html +share/doc/postgresql/html/ddl-priv.html +share/doc/postgresql/html/ddl-schemas.html +share/doc/postgresql/html/ddl-system-columns.html +share/doc/postgresql/html/ddl.html +share/doc/postgresql/html/dict-int.html +share/doc/postgresql/html/dict-xsyn.html +share/doc/postgresql/html/different-replication-solutions.html +share/doc/postgresql/html/disk-full.html +share/doc/postgresql/html/disk-usage.html +share/doc/postgresql/html/diskusage.html +share/doc/postgresql/html/dml-delete.html +share/doc/postgresql/html/dml-insert.html +share/doc/postgresql/html/dml-update.html +share/doc/postgresql/html/dml.html +share/doc/postgresql/html/docguide-authoring.html +share/doc/postgresql/html/docguide-build.html +share/doc/postgresql/html/docguide-docbook.html +share/doc/postgresql/html/docguide-style.html +share/doc/postgresql/html/docguide-toolsets.html +share/doc/postgresql/html/docguide.html +share/doc/postgresql/html/dummy-seclabel.html +share/doc/postgresql/html/dynamic-trace.html +share/doc/postgresql/html/earthdistance.html +share/doc/postgresql/html/ecpg-commands.html +share/doc/postgresql/html/ecpg-concept.html +share/doc/postgresql/html/ecpg-connect.html +share/doc/postgresql/html/ecpg-cpp.html +share/doc/postgresql/html/ecpg-descriptors.html +share/doc/postgresql/html/ecpg-develop.html +share/doc/postgresql/html/ecpg-dynamic.html +share/doc/postgresql/html/ecpg-errors.html +share/doc/postgresql/html/ecpg-informix-compat.html +share/doc/postgresql/html/ecpg-library.html +share/doc/postgresql/html/ecpg-lo.html +share/doc/postgresql/html/ecpg-pgtypes.html +share/doc/postgresql/html/ecpg-preproc.html +share/doc/postgresql/html/ecpg-process.html +share/doc/postgresql/html/ecpg-sql-allocate-descriptor.html +share/doc/postgresql/html/ecpg-sql-commands.html +share/doc/postgresql/html/ecpg-sql-connect.html +share/doc/postgresql/html/ecpg-sql-deallocate-descriptor.html +share/doc/postgresql/html/ecpg-sql-declare.html +share/doc/postgresql/html/ecpg-sql-describe.html +share/doc/postgresql/html/ecpg-sql-disconnect.html +share/doc/postgresql/html/ecpg-sql-execute-immediate.html +share/doc/postgresql/html/ecpg-sql-get-descriptor.html +share/doc/postgresql/html/ecpg-sql-open.html +share/doc/postgresql/html/ecpg-sql-prepare.html +share/doc/postgresql/html/ecpg-sql-set-autocommit.html +share/doc/postgresql/html/ecpg-sql-set-connection.html +share/doc/postgresql/html/ecpg-sql-set-descriptor.html +share/doc/postgresql/html/ecpg-sql-type.html +share/doc/postgresql/html/ecpg-sql-var.html +share/doc/postgresql/html/ecpg-sql-whenever.html +share/doc/postgresql/html/ecpg-variables.html +share/doc/postgresql/html/ecpg.html +share/doc/postgresql/html/encryption-options.html +share/doc/postgresql/html/errcodes-appendix.html +share/doc/postgresql/html/error-message-reporting.html +share/doc/postgresql/html/error-style-guide.html +share/doc/postgresql/html/executor.html +share/doc/postgresql/html/explicit-joins.html +share/doc/postgresql/html/explicit-locking.html +share/doc/postgresql/html/extend-extensions.html +share/doc/postgresql/html/extend-how.html +share/doc/postgresql/html/extend-pgxs.html +share/doc/postgresql/html/extend-type-system.html +share/doc/postgresql/html/extend.html +share/doc/postgresql/html/external-admin-tools.html +share/doc/postgresql/html/external-extensions.html +share/doc/postgresql/html/external-interfaces.html +share/doc/postgresql/html/external-pl.html +share/doc/postgresql/html/external-projects.html +share/doc/postgresql/html/fdw-callbacks.html +share/doc/postgresql/html/fdw-functions.html +share/doc/postgresql/html/fdwhandler.html +share/doc/postgresql/html/features-sql-standard.html +share/doc/postgresql/html/features.html +share/doc/postgresql/html/file-fdw.html +share/doc/postgresql/html/functions-admin.html +share/doc/postgresql/html/functions-aggregate.html +share/doc/postgresql/html/functions-array.html +share/doc/postgresql/html/functions-binarystring.html +share/doc/postgresql/html/functions-bitstring.html +share/doc/postgresql/html/functions-comparison.html +share/doc/postgresql/html/functions-comparisons.html +share/doc/postgresql/html/functions-conditional.html +share/doc/postgresql/html/functions-datetime.html +share/doc/postgresql/html/functions-enum.html +share/doc/postgresql/html/functions-formatting.html +share/doc/postgresql/html/functions-geometry.html +share/doc/postgresql/html/functions-info.html +share/doc/postgresql/html/functions-logical.html +share/doc/postgresql/html/functions-matching.html +share/doc/postgresql/html/functions-math.html +share/doc/postgresql/html/functions-net.html +share/doc/postgresql/html/functions-sequence.html +share/doc/postgresql/html/functions-srf.html +share/doc/postgresql/html/functions-string.html +share/doc/postgresql/html/functions-subquery.html +share/doc/postgresql/html/functions-textsearch.html +share/doc/postgresql/html/functions-trigger.html +share/doc/postgresql/html/functions-window.html +share/doc/postgresql/html/functions-xml.html +share/doc/postgresql/html/functions.html +share/doc/postgresql/html/fuzzystrmatch.html +share/doc/postgresql/html/geqo-biblio.html +share/doc/postgresql/html/geqo-intro.html +share/doc/postgresql/html/geqo-intro2.html +share/doc/postgresql/html/geqo-pg-intro.html +share/doc/postgresql/html/geqo.html +share/doc/postgresql/html/gin-examples.html +share/doc/postgresql/html/gin-extensibility.html +share/doc/postgresql/html/gin-implementation.html +share/doc/postgresql/html/gin-intro.html +share/doc/postgresql/html/gin-limit.html +share/doc/postgresql/html/gin-tips.html +share/doc/postgresql/html/gin.html +share/doc/postgresql/html/gist-examples.html +share/doc/postgresql/html/gist-extensibility.html +share/doc/postgresql/html/gist-implementation.html +share/doc/postgresql/html/gist-intro.html +share/doc/postgresql/html/gist.html +share/doc/postgresql/html/git.html +share/doc/postgresql/html/high-availability.html +share/doc/postgresql/html/history.html +share/doc/postgresql/html/hot-standby.html +share/doc/postgresql/html/hstore.html +share/doc/postgresql/html/index-catalog.html +share/doc/postgresql/html/index-cost-estimation.html +share/doc/postgresql/html/index-functions.html +share/doc/postgresql/html/index-locking.html +share/doc/postgresql/html/index-scanning.html +share/doc/postgresql/html/index-unique-checks.html +share/doc/postgresql/html/index.html +share/doc/postgresql/html/indexam.html +share/doc/postgresql/html/indexes-bitmap-scans.html +share/doc/postgresql/html/indexes-collations.html +share/doc/postgresql/html/indexes-examine.html +share/doc/postgresql/html/indexes-expressional.html +share/doc/postgresql/html/indexes-intro.html +share/doc/postgresql/html/indexes-multicolumn.html +share/doc/postgresql/html/indexes-opclass.html +share/doc/postgresql/html/indexes-ordering.html +share/doc/postgresql/html/indexes-partial.html +share/doc/postgresql/html/indexes-types.html +share/doc/postgresql/html/indexes-unique.html +share/doc/postgresql/html/indexes.html +share/doc/postgresql/html/information-schema.html +share/doc/postgresql/html/infoschema-administrable-role-authorizations.html +share/doc/postgresql/html/infoschema-applicable-roles.html +share/doc/postgresql/html/infoschema-attributes.html +share/doc/postgresql/html/infoschema-character-sets.html +share/doc/postgresql/html/infoschema-check-constraint-routine-usage.html +share/doc/postgresql/html/infoschema-check-constraints.html +share/doc/postgresql/html/infoschema-collation-character-set-applicab.html +share/doc/postgresql/html/infoschema-collations.html +share/doc/postgresql/html/infoschema-column-domain-usage.html +share/doc/postgresql/html/infoschema-column-privileges.html +share/doc/postgresql/html/infoschema-column-udt-usage.html +share/doc/postgresql/html/infoschema-columns.html +share/doc/postgresql/html/infoschema-constraint-column-usage.html +share/doc/postgresql/html/infoschema-constraint-table-usage.html +share/doc/postgresql/html/infoschema-data-type-privileges.html +share/doc/postgresql/html/infoschema-datatypes.html +share/doc/postgresql/html/infoschema-domain-constraints.html +share/doc/postgresql/html/infoschema-domain-udt-usage.html +share/doc/postgresql/html/infoschema-domains.html +share/doc/postgresql/html/infoschema-element-types.html +share/doc/postgresql/html/infoschema-enabled-roles.html +share/doc/postgresql/html/infoschema-foreign-data-wrapper-options.html +share/doc/postgresql/html/infoschema-foreign-data-wrappers.html +share/doc/postgresql/html/infoschema-foreign-server-options.html +share/doc/postgresql/html/infoschema-foreign-servers.html +share/doc/postgresql/html/infoschema-foreign-table-options.html +share/doc/postgresql/html/infoschema-foreign-tables.html +share/doc/postgresql/html/infoschema-information-schema-catalog-name.html +share/doc/postgresql/html/infoschema-key-column-usage.html +share/doc/postgresql/html/infoschema-parameters.html +share/doc/postgresql/html/infoschema-referential-constraints.html +share/doc/postgresql/html/infoschema-role-column-grants.html +share/doc/postgresql/html/infoschema-role-routine-grants.html +share/doc/postgresql/html/infoschema-role-table-grants.html +share/doc/postgresql/html/infoschema-role-usage-grants.html +share/doc/postgresql/html/infoschema-routine-privileges.html +share/doc/postgresql/html/infoschema-routines.html +share/doc/postgresql/html/infoschema-schema.html +share/doc/postgresql/html/infoschema-schemata.html +share/doc/postgresql/html/infoschema-sequences.html +share/doc/postgresql/html/infoschema-sql-features.html +share/doc/postgresql/html/infoschema-sql-implementation-info.html +share/doc/postgresql/html/infoschema-sql-languages.html +share/doc/postgresql/html/infoschema-sql-packages.html +share/doc/postgresql/html/infoschema-sql-parts.html +share/doc/postgresql/html/infoschema-sql-sizing-profiles.html +share/doc/postgresql/html/infoschema-sql-sizing.html +share/doc/postgresql/html/infoschema-table-constraints.html +share/doc/postgresql/html/infoschema-table-privileges.html +share/doc/postgresql/html/infoschema-tables.html +share/doc/postgresql/html/infoschema-triggered-update-columns.html +share/doc/postgresql/html/infoschema-triggers.html +share/doc/postgresql/html/infoschema-usage-privileges.html +share/doc/postgresql/html/infoschema-user-mapping-options.html +share/doc/postgresql/html/infoschema-user-mappings.html +share/doc/postgresql/html/infoschema-view-column-usage.html +share/doc/postgresql/html/infoschema-view-routine-usage.html +share/doc/postgresql/html/infoschema-view-table-usage.html +share/doc/postgresql/html/infoschema-views.html +share/doc/postgresql/html/install-getsource.html +share/doc/postgresql/html/install-post.html +share/doc/postgresql/html/install-procedure.html +share/doc/postgresql/html/install-requirements.html +share/doc/postgresql/html/install-short.html +share/doc/postgresql/html/install-windows-full.html +share/doc/postgresql/html/install-windows-libpq.html +share/doc/postgresql/html/install-windows.html +share/doc/postgresql/html/installation-platform-notes.html +share/doc/postgresql/html/installation.html +share/doc/postgresql/html/intagg.html +share/doc/postgresql/html/intarray.html +share/doc/postgresql/html/internals.html +share/doc/postgresql/html/intro-whatis.html +share/doc/postgresql/html/isn.html +share/doc/postgresql/html/kernel-resources.html +share/doc/postgresql/html/largeobjects.html +share/doc/postgresql/html/libpq-async.html +share/doc/postgresql/html/libpq-build.html +share/doc/postgresql/html/libpq-cancel.html +share/doc/postgresql/html/libpq-connect.html +share/doc/postgresql/html/libpq-control.html +share/doc/postgresql/html/libpq-copy.html +share/doc/postgresql/html/libpq-envars.html +share/doc/postgresql/html/libpq-events.html +share/doc/postgresql/html/libpq-example.html +share/doc/postgresql/html/libpq-exec.html +share/doc/postgresql/html/libpq-fastpath.html +share/doc/postgresql/html/libpq-ldap.html +share/doc/postgresql/html/libpq-misc.html +share/doc/postgresql/html/libpq-notice-processing.html +share/doc/postgresql/html/libpq-notify.html +share/doc/postgresql/html/libpq-pgpass.html +share/doc/postgresql/html/libpq-pgservice.html +share/doc/postgresql/html/libpq-ssl.html +share/doc/postgresql/html/libpq-status.html +share/doc/postgresql/html/libpq-threading.html +share/doc/postgresql/html/libpq.html +share/doc/postgresql/html/lo-examplesect.html +share/doc/postgresql/html/lo-funcs.html +share/doc/postgresql/html/lo-implementation.html +share/doc/postgresql/html/lo-interfaces.html +share/doc/postgresql/html/lo-intro.html +share/doc/postgresql/html/lo.html +share/doc/postgresql/html/locale.html +share/doc/postgresql/html/locking-indexes.html +share/doc/postgresql/html/log-shipping-alternative.html +share/doc/postgresql/html/logfile-maintenance.html +share/doc/postgresql/html/ltree.html +share/doc/postgresql/html/maintenance.html +share/doc/postgresql/html/manage-ag-config.html +share/doc/postgresql/html/manage-ag-createdb.html +share/doc/postgresql/html/manage-ag-dropdb.html +share/doc/postgresql/html/manage-ag-overview.html +share/doc/postgresql/html/manage-ag-tablespaces.html +share/doc/postgresql/html/manage-ag-templatedbs.html +share/doc/postgresql/html/managing-databases.html +share/doc/postgresql/html/monitoring-locks.html +share/doc/postgresql/html/monitoring-ps.html +share/doc/postgresql/html/monitoring-stats.html +share/doc/postgresql/html/monitoring.html +share/doc/postgresql/html/multibyte.html +share/doc/postgresql/html/mvcc-intro.html +share/doc/postgresql/html/mvcc.html +share/doc/postgresql/html/nls-programmer.html +share/doc/postgresql/html/nls-translator.html +share/doc/postgresql/html/nls.html +share/doc/postgresql/html/non-durability.html +share/doc/postgresql/html/notation.html +share/doc/postgresql/html/oid2name.html +share/doc/postgresql/html/overview.html +share/doc/postgresql/html/pageinspect.html +share/doc/postgresql/html/parser-stage.html +share/doc/postgresql/html/passwordcheck.html +share/doc/postgresql/html/performance-tips.html +share/doc/postgresql/html/perm-functions.html +share/doc/postgresql/html/pgarchivecleanup.html +share/doc/postgresql/html/pgbench.html +share/doc/postgresql/html/pgbuffercache.html +share/doc/postgresql/html/pgcrypto.html +share/doc/postgresql/html/pgfreespacemap.html +share/doc/postgresql/html/pgrowlocks.html +share/doc/postgresql/html/pgstandby.html +share/doc/postgresql/html/pgstatstatements.html +share/doc/postgresql/html/pgstattuple.html +share/doc/postgresql/html/pgtestfsync.html +share/doc/postgresql/html/pgtrgm.html +share/doc/postgresql/html/pgupgrade.html +share/doc/postgresql/html/planner-optimizer.html +share/doc/postgresql/html/planner-stats-details.html +share/doc/postgresql/html/planner-stats.html +share/doc/postgresql/html/plhandler.html +share/doc/postgresql/html/plperl-builtins.html +share/doc/postgresql/html/plperl-data.html +share/doc/postgresql/html/plperl-funcs.html +share/doc/postgresql/html/plperl-global.html +share/doc/postgresql/html/plperl-triggers.html +share/doc/postgresql/html/plperl-trusted.html +share/doc/postgresql/html/plperl-under-the-hood.html +share/doc/postgresql/html/plperl.html +share/doc/postgresql/html/plpgsql-control-structures.html +share/doc/postgresql/html/plpgsql-cursors.html +share/doc/postgresql/html/plpgsql-declarations.html +share/doc/postgresql/html/plpgsql-development-tips.html +share/doc/postgresql/html/plpgsql-errors-and-messages.html +share/doc/postgresql/html/plpgsql-expressions.html +share/doc/postgresql/html/plpgsql-implementation.html +share/doc/postgresql/html/plpgsql-overview.html +share/doc/postgresql/html/plpgsql-porting.html +share/doc/postgresql/html/plpgsql-statements.html +share/doc/postgresql/html/plpgsql-structure.html +share/doc/postgresql/html/plpgsql-trigger.html +share/doc/postgresql/html/plpgsql.html +share/doc/postgresql/html/plpython-data.html +share/doc/postgresql/html/plpython-database.html +share/doc/postgresql/html/plpython-do.html +share/doc/postgresql/html/plpython-envar.html +share/doc/postgresql/html/plpython-funcs.html +share/doc/postgresql/html/plpython-python23.html +share/doc/postgresql/html/plpython-sharing.html +share/doc/postgresql/html/plpython-subtransaction.html +share/doc/postgresql/html/plpython-trigger.html +share/doc/postgresql/html/plpython-util.html +share/doc/postgresql/html/plpython.html +share/doc/postgresql/html/pltcl-data.html +share/doc/postgresql/html/pltcl-dbaccess.html +share/doc/postgresql/html/pltcl-functions.html +share/doc/postgresql/html/pltcl-global.html +share/doc/postgresql/html/pltcl-overview.html +share/doc/postgresql/html/pltcl-procnames.html +share/doc/postgresql/html/pltcl-trigger.html +share/doc/postgresql/html/pltcl-unknown.html +share/doc/postgresql/html/pltcl.html +share/doc/postgresql/html/populate.html +share/doc/postgresql/html/postgres-user.html +share/doc/postgresql/html/preface.html +share/doc/postgresql/html/preventing-server-spoofing.html +share/doc/postgresql/html/protocol-changes.html +share/doc/postgresql/html/protocol-error-fields.html +share/doc/postgresql/html/protocol-flow.html +share/doc/postgresql/html/protocol-message-formats.html +share/doc/postgresql/html/protocol-message-types.html +share/doc/postgresql/html/protocol-overview.html +share/doc/postgresql/html/protocol-replication.html +share/doc/postgresql/html/protocol.html +share/doc/postgresql/html/queries-limit.html +share/doc/postgresql/html/queries-order.html +share/doc/postgresql/html/queries-overview.html +share/doc/postgresql/html/queries-select-lists.html +share/doc/postgresql/html/queries-table-expressions.html +share/doc/postgresql/html/queries-union.html +share/doc/postgresql/html/queries-values.html +share/doc/postgresql/html/queries-with.html +share/doc/postgresql/html/queries.html +share/doc/postgresql/html/query-path.html +share/doc/postgresql/html/querytree.html +share/doc/postgresql/html/recovery-config.html +share/doc/postgresql/html/recovery-target-settings.html +share/doc/postgresql/html/reference-client.html +share/doc/postgresql/html/reference-server.html +share/doc/postgresql/html/reference.html +share/doc/postgresql/html/regress-coverage.html +share/doc/postgresql/html/regress-evaluation.html +share/doc/postgresql/html/regress-run.html +share/doc/postgresql/html/regress-variant.html +share/doc/postgresql/html/regress.html +share/doc/postgresql/html/release-0-01.html +share/doc/postgresql/html/release-0-02.html +share/doc/postgresql/html/release-0-03.html +share/doc/postgresql/html/release-1-0.html +share/doc/postgresql/html/release-1-01.html +share/doc/postgresql/html/release-1-02.html +share/doc/postgresql/html/release-1-09.html +share/doc/postgresql/html/release-6-0.html +share/doc/postgresql/html/release-6-1-1.html +share/doc/postgresql/html/release-6-1.html +share/doc/postgresql/html/release-6-2-1.html +share/doc/postgresql/html/release-6-2.html +share/doc/postgresql/html/release-6-3-1.html +share/doc/postgresql/html/release-6-3-2.html +share/doc/postgresql/html/release-6-3.html +share/doc/postgresql/html/release-6-4-1.html +share/doc/postgresql/html/release-6-4-2.html +share/doc/postgresql/html/release-6-4.html +share/doc/postgresql/html/release-6-5-1.html +share/doc/postgresql/html/release-6-5-2.html +share/doc/postgresql/html/release-6-5-3.html +share/doc/postgresql/html/release-6-5.html +share/doc/postgresql/html/release-7-0-1.html +share/doc/postgresql/html/release-7-0-2.html +share/doc/postgresql/html/release-7-0-3.html +share/doc/postgresql/html/release-7-0.html +share/doc/postgresql/html/release-7-1-1.html +share/doc/postgresql/html/release-7-1-2.html +share/doc/postgresql/html/release-7-1-3.html +share/doc/postgresql/html/release-7-1.html +share/doc/postgresql/html/release-7-2-1.html +share/doc/postgresql/html/release-7-2-2.html +share/doc/postgresql/html/release-7-2-3.html +share/doc/postgresql/html/release-7-2-4.html +share/doc/postgresql/html/release-7-2-5.html +share/doc/postgresql/html/release-7-2-6.html +share/doc/postgresql/html/release-7-2-7.html +share/doc/postgresql/html/release-7-2-8.html +share/doc/postgresql/html/release-7-2.html +share/doc/postgresql/html/release-7-3-1.html +share/doc/postgresql/html/release-7-3-10.html +share/doc/postgresql/html/release-7-3-11.html +share/doc/postgresql/html/release-7-3-12.html +share/doc/postgresql/html/release-7-3-13.html +share/doc/postgresql/html/release-7-3-14.html +share/doc/postgresql/html/release-7-3-15.html +share/doc/postgresql/html/release-7-3-16.html +share/doc/postgresql/html/release-7-3-17.html +share/doc/postgresql/html/release-7-3-18.html +share/doc/postgresql/html/release-7-3-19.html +share/doc/postgresql/html/release-7-3-2.html +share/doc/postgresql/html/release-7-3-20.html +share/doc/postgresql/html/release-7-3-21.html +share/doc/postgresql/html/release-7-3-3.html +share/doc/postgresql/html/release-7-3-4.html +share/doc/postgresql/html/release-7-3-5.html +share/doc/postgresql/html/release-7-3-6.html +share/doc/postgresql/html/release-7-3-7.html +share/doc/postgresql/html/release-7-3-8.html +share/doc/postgresql/html/release-7-3-9.html +share/doc/postgresql/html/release-7-3.html +share/doc/postgresql/html/release-7-4-1.html +share/doc/postgresql/html/release-7-4-10.html +share/doc/postgresql/html/release-7-4-11.html +share/doc/postgresql/html/release-7-4-12.html +share/doc/postgresql/html/release-7-4-13.html +share/doc/postgresql/html/release-7-4-14.html +share/doc/postgresql/html/release-7-4-15.html +share/doc/postgresql/html/release-7-4-16.html +share/doc/postgresql/html/release-7-4-17.html +share/doc/postgresql/html/release-7-4-18.html +share/doc/postgresql/html/release-7-4-19.html +share/doc/postgresql/html/release-7-4-2.html +share/doc/postgresql/html/release-7-4-20.html +share/doc/postgresql/html/release-7-4-21.html +share/doc/postgresql/html/release-7-4-22.html +share/doc/postgresql/html/release-7-4-23.html +share/doc/postgresql/html/release-7-4-24.html +share/doc/postgresql/html/release-7-4-25.html +share/doc/postgresql/html/release-7-4-26.html +share/doc/postgresql/html/release-7-4-27.html +share/doc/postgresql/html/release-7-4-28.html +share/doc/postgresql/html/release-7-4-29.html +share/doc/postgresql/html/release-7-4-3.html +share/doc/postgresql/html/release-7-4-30.html +share/doc/postgresql/html/release-7-4-4.html +share/doc/postgresql/html/release-7-4-5.html +share/doc/postgresql/html/release-7-4-6.html +share/doc/postgresql/html/release-7-4-7.html +share/doc/postgresql/html/release-7-4-8.html +share/doc/postgresql/html/release-7-4-9.html +share/doc/postgresql/html/release-7-4.html +share/doc/postgresql/html/release-8-0-1.html +share/doc/postgresql/html/release-8-0-10.html +share/doc/postgresql/html/release-8-0-11.html +share/doc/postgresql/html/release-8-0-12.html +share/doc/postgresql/html/release-8-0-13.html +share/doc/postgresql/html/release-8-0-14.html +share/doc/postgresql/html/release-8-0-15.html +share/doc/postgresql/html/release-8-0-16.html +share/doc/postgresql/html/release-8-0-17.html +share/doc/postgresql/html/release-8-0-18.html +share/doc/postgresql/html/release-8-0-19.html +share/doc/postgresql/html/release-8-0-2.html +share/doc/postgresql/html/release-8-0-20.html +share/doc/postgresql/html/release-8-0-21.html +share/doc/postgresql/html/release-8-0-22.html +share/doc/postgresql/html/release-8-0-23.html +share/doc/postgresql/html/release-8-0-24.html +share/doc/postgresql/html/release-8-0-25.html +share/doc/postgresql/html/release-8-0-26.html +share/doc/postgresql/html/release-8-0-3.html +share/doc/postgresql/html/release-8-0-4.html +share/doc/postgresql/html/release-8-0-5.html +share/doc/postgresql/html/release-8-0-6.html +share/doc/postgresql/html/release-8-0-7.html +share/doc/postgresql/html/release-8-0-8.html +share/doc/postgresql/html/release-8-0-9.html +share/doc/postgresql/html/release-8-0.html +share/doc/postgresql/html/release-8-1-1.html +share/doc/postgresql/html/release-8-1-10.html +share/doc/postgresql/html/release-8-1-11.html +share/doc/postgresql/html/release-8-1-12.html +share/doc/postgresql/html/release-8-1-13.html +share/doc/postgresql/html/release-8-1-14.html +share/doc/postgresql/html/release-8-1-15.html +share/doc/postgresql/html/release-8-1-16.html +share/doc/postgresql/html/release-8-1-17.html +share/doc/postgresql/html/release-8-1-18.html +share/doc/postgresql/html/release-8-1-19.html +share/doc/postgresql/html/release-8-1-2.html +share/doc/postgresql/html/release-8-1-20.html +share/doc/postgresql/html/release-8-1-21.html +share/doc/postgresql/html/release-8-1-22.html +share/doc/postgresql/html/release-8-1-23.html +share/doc/postgresql/html/release-8-1-3.html +share/doc/postgresql/html/release-8-1-4.html +share/doc/postgresql/html/release-8-1-5.html +share/doc/postgresql/html/release-8-1-6.html +share/doc/postgresql/html/release-8-1-7.html +share/doc/postgresql/html/release-8-1-8.html +share/doc/postgresql/html/release-8-1-9.html +share/doc/postgresql/html/release-8-1.html +share/doc/postgresql/html/release-8-2-1.html +share/doc/postgresql/html/release-8-2-10.html +share/doc/postgresql/html/release-8-2-11.html +share/doc/postgresql/html/release-8-2-12.html +share/doc/postgresql/html/release-8-2-13.html +share/doc/postgresql/html/release-8-2-14.html +share/doc/postgresql/html/release-8-2-15.html +share/doc/postgresql/html/release-8-2-16.html +share/doc/postgresql/html/release-8-2-17.html +share/doc/postgresql/html/release-8-2-18.html +share/doc/postgresql/html/release-8-2-19.html +share/doc/postgresql/html/release-8-2-2.html +share/doc/postgresql/html/release-8-2-20.html +share/doc/postgresql/html/release-8-2-21.html +share/doc/postgresql/html/release-8-2-3.html +share/doc/postgresql/html/release-8-2-4.html +share/doc/postgresql/html/release-8-2-5.html +share/doc/postgresql/html/release-8-2-6.html +share/doc/postgresql/html/release-8-2-7.html +share/doc/postgresql/html/release-8-2-8.html +share/doc/postgresql/html/release-8-2-9.html +share/doc/postgresql/html/release-8-2.html +share/doc/postgresql/html/release-8-3-1.html +share/doc/postgresql/html/release-8-3-10.html +share/doc/postgresql/html/release-8-3-11.html +share/doc/postgresql/html/release-8-3-12.html +share/doc/postgresql/html/release-8-3-13.html +share/doc/postgresql/html/release-8-3-14.html +share/doc/postgresql/html/release-8-3-15.html +share/doc/postgresql/html/release-8-3-2.html +share/doc/postgresql/html/release-8-3-3.html +share/doc/postgresql/html/release-8-3-4.html +share/doc/postgresql/html/release-8-3-5.html +share/doc/postgresql/html/release-8-3-6.html +share/doc/postgresql/html/release-8-3-7.html +share/doc/postgresql/html/release-8-3-8.html +share/doc/postgresql/html/release-8-3-9.html +share/doc/postgresql/html/release-8-3.html +share/doc/postgresql/html/release-8-4-1.html +share/doc/postgresql/html/release-8-4-2.html +share/doc/postgresql/html/release-8-4-3.html +share/doc/postgresql/html/release-8-4-4.html +share/doc/postgresql/html/release-8-4-5.html +share/doc/postgresql/html/release-8-4-6.html +share/doc/postgresql/html/release-8-4-7.html +share/doc/postgresql/html/release-8-4-8.html +share/doc/postgresql/html/release-8-4.html +share/doc/postgresql/html/release-9-0-1.html +share/doc/postgresql/html/release-9-0-2.html +share/doc/postgresql/html/release-9-0-3.html +share/doc/postgresql/html/release-9-0-4.html +share/doc/postgresql/html/release-9-0.html +share/doc/postgresql/html/release-9-1.html +share/doc/postgresql/html/release.html +share/doc/postgresql/html/resources.html +share/doc/postgresql/html/role-attributes.html +share/doc/postgresql/html/role-membership.html +share/doc/postgresql/html/routine-reindex.html +share/doc/postgresql/html/routine-vacuuming.html +share/doc/postgresql/html/row-estimation-examples.html +share/doc/postgresql/html/rowtypes.html +share/doc/postgresql/html/rule-system.html +share/doc/postgresql/html/rules-privileges.html +share/doc/postgresql/html/rules-status.html +share/doc/postgresql/html/rules-triggers.html +share/doc/postgresql/html/rules-update.html +share/doc/postgresql/html/rules-views.html +share/doc/postgresql/html/rules.html +share/doc/postgresql/html/runtime-config-autovacuum.html +share/doc/postgresql/html/runtime-config-client.html +share/doc/postgresql/html/runtime-config-compatible.html +share/doc/postgresql/html/runtime-config-connection.html +share/doc/postgresql/html/runtime-config-custom.html +share/doc/postgresql/html/runtime-config-developer.html +share/doc/postgresql/html/runtime-config-error-handling.html +share/doc/postgresql/html/runtime-config-file-locations.html +share/doc/postgresql/html/runtime-config-locks.html +share/doc/postgresql/html/runtime-config-logging.html +share/doc/postgresql/html/runtime-config-preset.html +share/doc/postgresql/html/runtime-config-query.html +share/doc/postgresql/html/runtime-config-replication.html +share/doc/postgresql/html/runtime-config-resource.html +share/doc/postgresql/html/runtime-config-short.html +share/doc/postgresql/html/runtime-config-statistics.html +share/doc/postgresql/html/runtime-config-wal.html +share/doc/postgresql/html/runtime-config.html +share/doc/postgresql/html/runtime.html +share/doc/postgresql/html/seg.html +share/doc/postgresql/html/sepgsql.html +share/doc/postgresql/html/server-programming.html +share/doc/postgresql/html/server-shutdown.html +share/doc/postgresql/html/server-start.html +share/doc/postgresql/html/source-format.html +share/doc/postgresql/html/source.html +share/doc/postgresql/html/sourcerepo.html +share/doc/postgresql/html/spi-examples.html +share/doc/postgresql/html/spi-interface-support.html +share/doc/postgresql/html/spi-interface.html +share/doc/postgresql/html/spi-memory.html +share/doc/postgresql/html/spi-realloc.html +share/doc/postgresql/html/spi-spi-connect.html +share/doc/postgresql/html/spi-spi-copytuple.html +share/doc/postgresql/html/spi-spi-cursor-close.html +share/doc/postgresql/html/spi-spi-cursor-fetch.html +share/doc/postgresql/html/spi-spi-cursor-find.html +share/doc/postgresql/html/spi-spi-cursor-move.html +share/doc/postgresql/html/spi-spi-cursor-open-with-args.html +share/doc/postgresql/html/spi-spi-cursor-open-with-paramlist.html +share/doc/postgresql/html/spi-spi-cursor-open.html +share/doc/postgresql/html/spi-spi-exec.html +share/doc/postgresql/html/spi-spi-execp.html +share/doc/postgresql/html/spi-spi-execute-plan-with-paramlist.html +share/doc/postgresql/html/spi-spi-execute-plan.html +share/doc/postgresql/html/spi-spi-execute-with-args.html +share/doc/postgresql/html/spi-spi-execute.html +share/doc/postgresql/html/spi-spi-finish.html +share/doc/postgresql/html/spi-spi-fname.html +share/doc/postgresql/html/spi-spi-fnumber.html +share/doc/postgresql/html/spi-spi-freeplan.html +share/doc/postgresql/html/spi-spi-freetuple.html +share/doc/postgresql/html/spi-spi-freetupletable.html +share/doc/postgresql/html/spi-spi-getargcount.html +share/doc/postgresql/html/spi-spi-getargtypeid.html +share/doc/postgresql/html/spi-spi-getbinval.html +share/doc/postgresql/html/spi-spi-getnspname.html +share/doc/postgresql/html/spi-spi-getrelname.html +share/doc/postgresql/html/spi-spi-gettype.html +share/doc/postgresql/html/spi-spi-gettypeid.html +share/doc/postgresql/html/spi-spi-getvalue.html +share/doc/postgresql/html/spi-spi-is-cursor-plan.html +share/doc/postgresql/html/spi-spi-modifytuple.html +share/doc/postgresql/html/spi-spi-palloc.html +share/doc/postgresql/html/spi-spi-pfree.html +share/doc/postgresql/html/spi-spi-pop.html +share/doc/postgresql/html/spi-spi-prepare-cursor.html +share/doc/postgresql/html/spi-spi-prepare-params.html +share/doc/postgresql/html/spi-spi-prepare.html +share/doc/postgresql/html/spi-spi-push.html +share/doc/postgresql/html/spi-spi-returntuple.html +share/doc/postgresql/html/spi-spi-saveplan.html +share/doc/postgresql/html/spi-spi-scroll-cursor-fetch.html +share/doc/postgresql/html/spi-spi-scroll-cursor-move.html +share/doc/postgresql/html/spi-visibility.html +share/doc/postgresql/html/spi.html +share/doc/postgresql/html/sql-abort.html +share/doc/postgresql/html/sql-alteraggregate.html +share/doc/postgresql/html/sql-altercollation.html +share/doc/postgresql/html/sql-alterconversion.html +share/doc/postgresql/html/sql-alterdatabase.html +share/doc/postgresql/html/sql-alterdefaultprivileges.html +share/doc/postgresql/html/sql-alterdomain.html +share/doc/postgresql/html/sql-alterextension.html +share/doc/postgresql/html/sql-alterforeigndatawrapper.html +share/doc/postgresql/html/sql-alterforeigntable.html +share/doc/postgresql/html/sql-alterfunction.html +share/doc/postgresql/html/sql-altergroup.html +share/doc/postgresql/html/sql-alterindex.html +share/doc/postgresql/html/sql-alterlanguage.html +share/doc/postgresql/html/sql-alterlargeobject.html +share/doc/postgresql/html/sql-alteropclass.html +share/doc/postgresql/html/sql-alteroperator.html +share/doc/postgresql/html/sql-alteropfamily.html +share/doc/postgresql/html/sql-alterrole.html +share/doc/postgresql/html/sql-alterschema.html +share/doc/postgresql/html/sql-altersequence.html +share/doc/postgresql/html/sql-alterserver.html +share/doc/postgresql/html/sql-altertable.html +share/doc/postgresql/html/sql-altertablespace.html +share/doc/postgresql/html/sql-altertrigger.html +share/doc/postgresql/html/sql-altertsconfig.html +share/doc/postgresql/html/sql-altertsdictionary.html +share/doc/postgresql/html/sql-altertsparser.html +share/doc/postgresql/html/sql-altertstemplate.html +share/doc/postgresql/html/sql-altertype.html +share/doc/postgresql/html/sql-alteruser.html +share/doc/postgresql/html/sql-alterusermapping.html +share/doc/postgresql/html/sql-alterview.html +share/doc/postgresql/html/sql-analyze.html +share/doc/postgresql/html/sql-begin.html +share/doc/postgresql/html/sql-checkpoint.html +share/doc/postgresql/html/sql-close.html +share/doc/postgresql/html/sql-cluster.html +share/doc/postgresql/html/sql-commands.html +share/doc/postgresql/html/sql-comment.html +share/doc/postgresql/html/sql-commit-prepared.html +share/doc/postgresql/html/sql-commit.html +share/doc/postgresql/html/sql-copy.html +share/doc/postgresql/html/sql-createaggregate.html +share/doc/postgresql/html/sql-createcast.html +share/doc/postgresql/html/sql-createcollation.html +share/doc/postgresql/html/sql-createconversion.html +share/doc/postgresql/html/sql-createdatabase.html +share/doc/postgresql/html/sql-createdomain.html +share/doc/postgresql/html/sql-createextension.html +share/doc/postgresql/html/sql-createforeigndatawrapper.html +share/doc/postgresql/html/sql-createforeigntable.html +share/doc/postgresql/html/sql-createfunction.html +share/doc/postgresql/html/sql-creategroup.html +share/doc/postgresql/html/sql-createindex.html +share/doc/postgresql/html/sql-createlanguage.html +share/doc/postgresql/html/sql-createopclass.html +share/doc/postgresql/html/sql-createoperator.html +share/doc/postgresql/html/sql-createopfamily.html +share/doc/postgresql/html/sql-createrole.html +share/doc/postgresql/html/sql-createrule.html +share/doc/postgresql/html/sql-createschema.html +share/doc/postgresql/html/sql-createsequence.html +share/doc/postgresql/html/sql-createserver.html +share/doc/postgresql/html/sql-createtable.html +share/doc/postgresql/html/sql-createtableas.html +share/doc/postgresql/html/sql-createtablespace.html +share/doc/postgresql/html/sql-createtrigger.html +share/doc/postgresql/html/sql-createtsconfig.html +share/doc/postgresql/html/sql-createtsdictionary.html +share/doc/postgresql/html/sql-createtsparser.html +share/doc/postgresql/html/sql-createtstemplate.html +share/doc/postgresql/html/sql-createtype.html +share/doc/postgresql/html/sql-createuser.html +share/doc/postgresql/html/sql-createusermapping.html +share/doc/postgresql/html/sql-createview.html +share/doc/postgresql/html/sql-deallocate.html +share/doc/postgresql/html/sql-declare.html +share/doc/postgresql/html/sql-delete.html +share/doc/postgresql/html/sql-discard.html +share/doc/postgresql/html/sql-do.html +share/doc/postgresql/html/sql-drop-owned.html +share/doc/postgresql/html/sql-dropaggregate.html +share/doc/postgresql/html/sql-dropcast.html +share/doc/postgresql/html/sql-dropcollation.html +share/doc/postgresql/html/sql-dropconversion.html +share/doc/postgresql/html/sql-dropdatabase.html +share/doc/postgresql/html/sql-dropdomain.html +share/doc/postgresql/html/sql-dropextension.html +share/doc/postgresql/html/sql-dropforeigndatawrapper.html +share/doc/postgresql/html/sql-dropforeigntable.html +share/doc/postgresql/html/sql-dropfunction.html +share/doc/postgresql/html/sql-dropgroup.html +share/doc/postgresql/html/sql-dropindex.html +share/doc/postgresql/html/sql-droplanguage.html +share/doc/postgresql/html/sql-dropopclass.html +share/doc/postgresql/html/sql-dropoperator.html +share/doc/postgresql/html/sql-dropopfamily.html +share/doc/postgresql/html/sql-droprole.html +share/doc/postgresql/html/sql-droprule.html +share/doc/postgresql/html/sql-dropschema.html +share/doc/postgresql/html/sql-dropsequence.html +share/doc/postgresql/html/sql-dropserver.html +share/doc/postgresql/html/sql-droptable.html +share/doc/postgresql/html/sql-droptablespace.html +share/doc/postgresql/html/sql-droptrigger.html +share/doc/postgresql/html/sql-droptsconfig.html +share/doc/postgresql/html/sql-droptsdictionary.html +share/doc/postgresql/html/sql-droptsparser.html +share/doc/postgresql/html/sql-droptstemplate.html +share/doc/postgresql/html/sql-droptype.html +share/doc/postgresql/html/sql-dropuser.html +share/doc/postgresql/html/sql-dropusermapping.html +share/doc/postgresql/html/sql-dropview.html +share/doc/postgresql/html/sql-end.html +share/doc/postgresql/html/sql-execute.html +share/doc/postgresql/html/sql-explain.html +share/doc/postgresql/html/sql-expressions.html +share/doc/postgresql/html/sql-fetch.html +share/doc/postgresql/html/sql-grant.html +share/doc/postgresql/html/sql-insert.html +share/doc/postgresql/html/sql-keywords-appendix.html +share/doc/postgresql/html/sql-listen.html +share/doc/postgresql/html/sql-load.html +share/doc/postgresql/html/sql-lock.html +share/doc/postgresql/html/sql-move.html +share/doc/postgresql/html/sql-notify.html +share/doc/postgresql/html/sql-prepare-transaction.html +share/doc/postgresql/html/sql-prepare.html +share/doc/postgresql/html/sql-reassign-owned.html +share/doc/postgresql/html/sql-reindex.html +share/doc/postgresql/html/sql-release-savepoint.html +share/doc/postgresql/html/sql-reset.html +share/doc/postgresql/html/sql-revoke.html +share/doc/postgresql/html/sql-rollback-prepared.html +share/doc/postgresql/html/sql-rollback-to.html +share/doc/postgresql/html/sql-rollback.html +share/doc/postgresql/html/sql-savepoint.html +share/doc/postgresql/html/sql-security-label.html +share/doc/postgresql/html/sql-select.html +share/doc/postgresql/html/sql-selectinto.html +share/doc/postgresql/html/sql-set-constraints.html +share/doc/postgresql/html/sql-set-role.html +share/doc/postgresql/html/sql-set-session-authorization.html +share/doc/postgresql/html/sql-set-transaction.html +share/doc/postgresql/html/sql-set.html +share/doc/postgresql/html/sql-show.html +share/doc/postgresql/html/sql-start-transaction.html +share/doc/postgresql/html/sql-syntax-calling-funcs.html +share/doc/postgresql/html/sql-syntax-lexical.html +share/doc/postgresql/html/sql-syntax.html +share/doc/postgresql/html/sql-truncate.html +share/doc/postgresql/html/sql-unlisten.html +share/doc/postgresql/html/sql-update.html +share/doc/postgresql/html/sql-vacuum.html +share/doc/postgresql/html/sql-values.html +share/doc/postgresql/html/sql.html +share/doc/postgresql/html/ssh-tunnels.html +share/doc/postgresql/html/ssl-tcp.html +share/doc/postgresql/html/sslinfo.html +share/doc/postgresql/html/standby-settings.html +share/doc/postgresql/html/storage-file-layout.html +share/doc/postgresql/html/storage-fsm.html +share/doc/postgresql/html/storage-init.html +share/doc/postgresql/html/storage-page-layout.html +share/doc/postgresql/html/storage-toast.html +share/doc/postgresql/html/storage-vm.html +share/doc/postgresql/html/storage.html +share/doc/postgresql/html/stylesheet.css +share/doc/postgresql/html/supported-platforms.html +share/doc/postgresql/html/tablefunc.html +share/doc/postgresql/html/test-parser.html +share/doc/postgresql/html/textsearch-configuration.html +share/doc/postgresql/html/textsearch-controls.html +share/doc/postgresql/html/textsearch-debugging.html +share/doc/postgresql/html/textsearch-dictionaries.html +share/doc/postgresql/html/textsearch-features.html +share/doc/postgresql/html/textsearch-indexes.html +share/doc/postgresql/html/textsearch-intro.html +share/doc/postgresql/html/textsearch-limitations.html +share/doc/postgresql/html/textsearch-migration.html +share/doc/postgresql/html/textsearch-parsers.html +share/doc/postgresql/html/textsearch-psql.html +share/doc/postgresql/html/textsearch-tables.html +share/doc/postgresql/html/textsearch.html +share/doc/postgresql/html/transaction-iso.html +share/doc/postgresql/html/trigger-datachanges.html +share/doc/postgresql/html/trigger-definition.html +share/doc/postgresql/html/trigger-example.html +share/doc/postgresql/html/trigger-interface.html +share/doc/postgresql/html/triggers.html +share/doc/postgresql/html/tsearch2.html +share/doc/postgresql/html/tutorial-accessdb.html +share/doc/postgresql/html/tutorial-advanced-intro.html +share/doc/postgresql/html/tutorial-advanced.html +share/doc/postgresql/html/tutorial-agg.html +share/doc/postgresql/html/tutorial-arch.html +share/doc/postgresql/html/tutorial-concepts.html +share/doc/postgresql/html/tutorial-conclusion.html +share/doc/postgresql/html/tutorial-createdb.html +share/doc/postgresql/html/tutorial-delete.html +share/doc/postgresql/html/tutorial-fk.html +share/doc/postgresql/html/tutorial-inheritance.html +share/doc/postgresql/html/tutorial-install.html +share/doc/postgresql/html/tutorial-join.html +share/doc/postgresql/html/tutorial-populate.html +share/doc/postgresql/html/tutorial-select.html +share/doc/postgresql/html/tutorial-sql-intro.html +share/doc/postgresql/html/tutorial-sql.html +share/doc/postgresql/html/tutorial-start.html +share/doc/postgresql/html/tutorial-table.html +share/doc/postgresql/html/tutorial-transactions.html +share/doc/postgresql/html/tutorial-update.html +share/doc/postgresql/html/tutorial-views.html +share/doc/postgresql/html/tutorial-window.html +share/doc/postgresql/html/tutorial.html +share/doc/postgresql/html/typeconv-func.html +share/doc/postgresql/html/typeconv-oper.html +share/doc/postgresql/html/typeconv-overview.html +share/doc/postgresql/html/typeconv-query.html +share/doc/postgresql/html/typeconv-union-case.html +share/doc/postgresql/html/typeconv.html +share/doc/postgresql/html/unaccent.html +share/doc/postgresql/html/unsupported-features-sql-standard.html +share/doc/postgresql/html/upgrading.html +share/doc/postgresql/html/user-manag.html +share/doc/postgresql/html/using-explain.html +share/doc/postgresql/html/uuid-ossp.html +share/doc/postgresql/html/vacuumlo.html +share/doc/postgresql/html/view-pg-available-extension-versions.html +share/doc/postgresql/html/view-pg-available-extensions.html +share/doc/postgresql/html/view-pg-cursors.html +share/doc/postgresql/html/view-pg-group.html +share/doc/postgresql/html/view-pg-indexes.html +share/doc/postgresql/html/view-pg-locks.html +share/doc/postgresql/html/view-pg-prepared-statements.html +share/doc/postgresql/html/view-pg-prepared-xacts.html +share/doc/postgresql/html/view-pg-roles.html +share/doc/postgresql/html/view-pg-rules.html +share/doc/postgresql/html/view-pg-seclabels.html +share/doc/postgresql/html/view-pg-settings.html +share/doc/postgresql/html/view-pg-shadow.html +share/doc/postgresql/html/view-pg-stats.html +share/doc/postgresql/html/view-pg-tables.html +share/doc/postgresql/html/view-pg-timezone-abbrevs.html +share/doc/postgresql/html/view-pg-timezone-names.html +share/doc/postgresql/html/view-pg-user-mappings.html +share/doc/postgresql/html/view-pg-user.html +share/doc/postgresql/html/view-pg-views.html +share/doc/postgresql/html/views-overview.html +share/doc/postgresql/html/wal-async-commit.html +share/doc/postgresql/html/wal-configuration.html +share/doc/postgresql/html/wal-internals.html +share/doc/postgresql/html/wal-intro.html +share/doc/postgresql/html/wal-reliability.html +share/doc/postgresql/html/wal.html +share/doc/postgresql/html/warm-standby-failover.html +share/doc/postgresql/html/warm-standby.html +share/doc/postgresql/html/xaggr.html +share/doc/postgresql/html/xfunc-c.html +share/doc/postgresql/html/xfunc-internal.html +share/doc/postgresql/html/xfunc-overload.html +share/doc/postgresql/html/xfunc-pl.html +share/doc/postgresql/html/xfunc-sql.html +share/doc/postgresql/html/xfunc-volatility.html +share/doc/postgresql/html/xfunc.html +share/doc/postgresql/html/xindex.html +share/doc/postgresql/html/xml2.html +share/doc/postgresql/html/xoper-optimization.html +share/doc/postgresql/html/xoper.html +share/doc/postgresql/html/xplang-install.html +share/doc/postgresql/html/xplang.html +share/doc/postgresql/html/xtypes.html diff --git a/databases/postgresql91-fuzzystrmatch/DESCR b/databases/postgresql91-fuzzystrmatch/DESCR new file mode 100644 index 00000000000..98051db50c1 --- /dev/null +++ b/databases/postgresql91-fuzzystrmatch/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 fuzzystrmatch contribution diff --git a/databases/postgresql91-fuzzystrmatch/MESSAGE b/databases/postgresql91-fuzzystrmatch/MESSAGE new file mode 100644 index 00000000000..0665170fe31 --- /dev/null +++ b/databases/postgresql91-fuzzystrmatch/MESSAGE @@ -0,0 +1,8 @@ +=========================================================================== +$NetBSD: MESSAGE,v 1.1.1.1 2011/09/15 08:32:22 adam Exp $ + +To enable this package, run the following command as pgsql superuser + + psql database < ${PREFIX}/share/postgresql/contrib/fuzzystrmatch.sql + +=========================================================================== diff --git a/databases/postgresql91-fuzzystrmatch/Makefile b/databases/postgresql91-fuzzystrmatch/Makefile new file mode 100644 index 00000000000..4ee87f3a02b --- /dev/null +++ b/databases/postgresql91-fuzzystrmatch/Makefile @@ -0,0 +1,17 @@ +# $NetBSD: Makefile,v 1.1.1.1 2011/09/15 08:32:22 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/91-fuzzystrmatch-/} +COMMENT= PostgreSQL fuzzystrmatch contribution + +PKG_DESTDIR_SUPPORT= user-destdir + +DEPENDS+= postgresql91-server>=${PKGVERSION_NOREV}:../../databases/postgresql91-server + +.include "../../databases/postgresql91/Makefile.common" + +BUILD_MAKE_FLAGS= USE_PGXS=1 + +BUILD_DIRS= contrib/fuzzystrmatch + +.include "../../databases/postgresql91-client/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql91-fuzzystrmatch/PLIST b/databases/postgresql91-fuzzystrmatch/PLIST new file mode 100644 index 00000000000..337bae31ee3 --- /dev/null +++ b/databases/postgresql91-fuzzystrmatch/PLIST @@ -0,0 +1,5 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2011/09/15 08:32:22 adam Exp $ +lib/postgresql/fuzzystrmatch.so +share/postgresql/extension/fuzzystrmatch--1.0.sql +share/postgresql/extension/fuzzystrmatch--unpackaged--1.0.sql +share/postgresql/extension/fuzzystrmatch.control diff --git a/databases/postgresql91-monitoring/DESCR b/databases/postgresql91-monitoring/DESCR new file mode 100644 index 00000000000..a7d6d0fd016 --- /dev/null +++ b/databases/postgresql91-monitoring/DESCR @@ -0,0 +1,19 @@ +This package provides the following PostgreSQL modules: + - auto_explain + - pg_buffercache + - pg_stat_statements + - pgstattuple + +The "auto_explain" module provides a means for logging execution +plans of slow statements automatically, without having to run +EXPLAIN(7) by hand. This is especially helpful for tracking down +un-optimized queries in large applications. + +The "pg_buffercache" module provides a means for examining what's +happening in the shared buffer cache in real time. + +The "pg_stat_statements" module provides a means for tracking +execution statistics of all SQL statements executed by a server. + +The "pgstattuple" module provides various functions to obtain +tuple-level statistics. diff --git a/databases/postgresql91-monitoring/Makefile b/databases/postgresql91-monitoring/Makefile new file mode 100644 index 00000000000..b5c384f7f1d --- /dev/null +++ b/databases/postgresql91-monitoring/Makefile @@ -0,0 +1,20 @@ +# $NetBSD: Makefile,v 1.1.1.1 2011/09/15 08:30:47 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/91-monitoring-/} +COMMENT= PostgreSQL monitoring tools + +PKG_DESTDIR_SUPPORT= user-destdir + +DEPENDS+= postgresql91-server>=${PKGVERSION_NOREV}:../../databases/postgresql91-server + +.include "../../databases/postgresql91/Makefile.common" + +BUILD_MAKE_FLAGS= PGXS=1 + +BUILD_DIRS+= contrib/auto_explain +BUILD_DIRS+= contrib/pg_buffercache +BUILD_DIRS+= contrib/pg_stat_statements +BUILD_DIRS+= contrib/pgstattuple + +.include "../../databases/postgresql91-client/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql91-monitoring/PLIST b/databases/postgresql91-monitoring/PLIST new file mode 100644 index 00000000000..c1ad22b11b3 --- /dev/null +++ b/databases/postgresql91-monitoring/PLIST @@ -0,0 +1,14 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2011/09/15 08:30:47 adam Exp $ +lib/postgresql/auto_explain.so +lib/postgresql/pg_buffercache.so +lib/postgresql/pg_stat_statements.so +lib/postgresql/pgstattuple.so +share/postgresql/extension/pg_buffercache--1.0.sql +share/postgresql/extension/pg_buffercache--unpackaged--1.0.sql +share/postgresql/extension/pg_buffercache.control +share/postgresql/extension/pg_stat_statements--1.0.sql +share/postgresql/extension/pg_stat_statements--unpackaged--1.0.sql +share/postgresql/extension/pg_stat_statements.control +share/postgresql/extension/pgstattuple--1.0.sql +share/postgresql/extension/pgstattuple--unpackaged--1.0.sql +share/postgresql/extension/pgstattuple.control diff --git a/databases/postgresql91-pgcrypto/DESCR b/databases/postgresql91-pgcrypto/DESCR new file mode 100644 index 00000000000..3ce89d05b9d --- /dev/null +++ b/databases/postgresql91-pgcrypto/DESCR @@ -0,0 +1,3 @@ +The ``pgcrypto'' PostgreSQL contrib module implements a number of +cryptographic functions - general hashing, password hashing, PGP encryption, +raw encryption, random data. diff --git a/databases/postgresql91-pgcrypto/Makefile b/databases/postgresql91-pgcrypto/Makefile new file mode 100644 index 00000000000..9606b548c4a --- /dev/null +++ b/databases/postgresql91-pgcrypto/Makefile @@ -0,0 +1,18 @@ +# $NetBSD: Makefile,v 1.1.1.1 2011/09/15 08:31:09 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/91-pgcrypto-/} +COMMENT= Module providing cryptographic functions for PostgreSQL + +PKG_DESTDIR_SUPPORT= user-destdir + +DEPENDS+= postgresql91-server>=${PKGVERSION_NOREV}:../../databases/postgresql91-server + +.include "../../databases/postgresql91/Makefile.common" + +CONFIGURE_ARGS+= --with-zlib +BUILD_MAKE_FLAGS= PGXS=1 + +BUILD_DIRS= contrib/pgcrypto + +.include "../../databases/postgresql91-client/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql91-pgcrypto/PLIST b/databases/postgresql91-pgcrypto/PLIST new file mode 100644 index 00000000000..692c1376281 --- /dev/null +++ b/databases/postgresql91-pgcrypto/PLIST @@ -0,0 +1,5 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2011/09/15 08:31:09 adam Exp $ +lib/postgresql/pgcrypto.so +share/postgresql/extension/pgcrypto--1.0.sql +share/postgresql/extension/pgcrypto--unpackaged--1.0.sql +share/postgresql/extension/pgcrypto.control diff --git a/databases/postgresql91-plperl/DESCR b/databases/postgresql91-plperl/DESCR new file mode 100644 index 00000000000..9057591c0ba --- /dev/null +++ b/databases/postgresql91-plperl/DESCR @@ -0,0 +1,5 @@ +PL/Perl allows you to write functions in the Perl programming language +that may be used in SQL queries as if they were built into Postgres. +The PL/Perl intepreter is a full Perl interpreter. However, certain +operations have been disabled in order to maintain the security of the +system. diff --git a/databases/postgresql91-plperl/MESSAGE b/databases/postgresql91-plperl/MESSAGE new file mode 100644 index 00000000000..8f4ca2fbb00 --- /dev/null +++ b/databases/postgresql91-plperl/MESSAGE @@ -0,0 +1,7 @@ +=========================================================================== +$NetBSD: MESSAGE,v 1.1.1.1 2011/09/15 08:31:25 adam Exp $ + +Please see the PL/Perl section of the PostgreSQL Programmer's Guide +(databases/postgresql-docs) for information on programming with +${PKGNAME}. +=========================================================================== diff --git a/databases/postgresql91-plperl/Makefile b/databases/postgresql91-plperl/Makefile new file mode 100644 index 00000000000..3f6773182aa --- /dev/null +++ b/databases/postgresql91-plperl/Makefile @@ -0,0 +1,22 @@ +# $NetBSD: Makefile,v 1.1.1.1 2011/09/15 08:31:25 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/91-plperl-/} +COMMENT= PL/Perl procedural language for the PostgreSQL backend + +PKG_DESTDIR_SUPPORT= user-destdir + +DEPENDS+= postgresql91-server>=${PKGVERSION_NOREV}:../../databases/postgresql91-server + +.include "../../databases/postgresql91/Makefile.common" + +USE_TOOLS+= perl +PERL5_CONFIGURE= no +CONFIGURE_ARGS+= --with-perl +BUILD_MAKE_FLAGS= PGXS=1 + +BUILD_DIRS= src/pl/plperl +MAKE_FILE= GNUmakefile + +.include "../../databases/postgresql91-client/buildlink3.mk" +.include "../../lang/perl5/module.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql91-plperl/PLIST b/databases/postgresql91-plperl/PLIST new file mode 100644 index 00000000000..19ddd37ed4c --- /dev/null +++ b/databases/postgresql91-plperl/PLIST @@ -0,0 +1,19 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2011/09/15 08:31:25 adam Exp $ +lib/postgresql/plperl.so +share/locale/cs/LC_MESSAGES/plperl-9.1.mo +share/locale/de/LC_MESSAGES/plperl-9.1.mo +share/locale/es/LC_MESSAGES/plperl-9.1.mo +share/locale/fr/LC_MESSAGES/plperl-9.1.mo +share/locale/ja/LC_MESSAGES/plperl-9.1.mo +share/locale/pl/LC_MESSAGES/plperl-9.1.mo +share/locale/pt_BR/LC_MESSAGES/plperl-9.1.mo +share/locale/ro/LC_MESSAGES/plperl-9.1.mo +share/locale/tr/LC_MESSAGES/plperl-9.1.mo +share/locale/zh_CN/LC_MESSAGES/plperl-9.1.mo +share/locale/zh_TW/LC_MESSAGES/plperl-9.1.mo +share/postgresql/extension/plperl--1.0.sql +share/postgresql/extension/plperl--unpackaged--1.0.sql +share/postgresql/extension/plperl.control +share/postgresql/extension/plperlu--1.0.sql +share/postgresql/extension/plperlu--unpackaged--1.0.sql +share/postgresql/extension/plperlu.control diff --git a/databases/postgresql91-plpython/DESCR b/databases/postgresql91-plpython/DESCR new file mode 100644 index 00000000000..142bb15309d --- /dev/null +++ b/databases/postgresql91-plpython/DESCR @@ -0,0 +1,9 @@ +PL/Python allows you to write functions in the Python programming +language that may be used in SQL queries as if they were built into +Postgres. The PL/Python intepreter is a full Python interpreter. + +PL/Python is currently only available as an "untrusted" language +(meaning it does not offer any way of restricting what users can do +in it). It has therefore been named "plpythonu". The trusted variant +plpython may become available again in future, if a new secure execution +mechanism is developed in Python. diff --git a/databases/postgresql91-plpython/MESSAGE b/databases/postgresql91-plpython/MESSAGE new file mode 100644 index 00000000000..e5d4494239f --- /dev/null +++ b/databases/postgresql91-plpython/MESSAGE @@ -0,0 +1,17 @@ +=========================================================================== +$NetBSD: MESSAGE,v 1.1.1.1 2011/09/15 08:31:43 adam Exp $ + +Please see the PL/Python section of the PostgreSQL Programmer's Guide +(databases/postgresql-docs) for information on programming with +${PKGNAME}. + +Note that PL/Python is unrestricted language, meaning it does not +offer any way of restricting what users can do in it. Any DB user with +access to PL/Python can run arbitrary Python code under privileges +of the PostgreSQL server process. + +To enable PL/Python for database <dbname>, run following: + +createlang plpythonu <dbname> + +=========================================================================== diff --git a/databases/postgresql91-plpython/Makefile b/databases/postgresql91-plpython/Makefile new file mode 100644 index 00000000000..eb4f195ffdb --- /dev/null +++ b/databases/postgresql91-plpython/Makefile @@ -0,0 +1,20 @@ +# $NetBSD: Makefile,v 1.1.1.1 2011/09/15 08:31:43 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/91-plpython-/} +COMMENT= PL/Python procedural language for the PostgreSQL backend + +PKG_DESTDIR_SUPPORT= user-destdir + +DEPENDS+= postgresql91-server>=${PKGVERSION_NOREV}:../../databases/postgresql91-server + +.include "../../databases/postgresql91/Makefile.common" + +CONFIGURE_ARGS+= --with-python +CONFIGURE_ENV+= PYTHON="${PYTHONBIN}" +BUILD_MAKE_FLAGS= PGXS=1 + +BUILD_DIRS= src/pl/plpython + +.include "../../databases/postgresql91-client/buildlink3.mk" +.include "../../lang/python/extension.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql91-plpython/PLIST b/databases/postgresql91-plpython/PLIST new file mode 100644 index 00000000000..e3034a524f6 --- /dev/null +++ b/databases/postgresql91-plpython/PLIST @@ -0,0 +1,22 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2011/09/15 08:31:43 adam Exp $ +lib/postgresql/plpython2.so +share/locale/cs/LC_MESSAGES/plpython-9.1.mo +share/locale/de/LC_MESSAGES/plpython-9.1.mo +share/locale/es/LC_MESSAGES/plpython-9.1.mo +share/locale/fr/LC_MESSAGES/plpython-9.1.mo +share/locale/ja/LC_MESSAGES/plpython-9.1.mo +share/locale/pl/LC_MESSAGES/plpython-9.1.mo +share/locale/pt_BR/LC_MESSAGES/plpython-9.1.mo +share/locale/ro/LC_MESSAGES/plpython-9.1.mo +share/locale/tr/LC_MESSAGES/plpython-9.1.mo +share/locale/zh_CN/LC_MESSAGES/plpython-9.1.mo +share/locale/zh_TW/LC_MESSAGES/plpython-9.1.mo +share/postgresql/extension/plpython2u--1.0.sql +share/postgresql/extension/plpython2u--unpackaged--1.0.sql +share/postgresql/extension/plpython2u.control +share/postgresql/extension/plpython3u--1.0.sql +share/postgresql/extension/plpython3u--unpackaged--1.0.sql +share/postgresql/extension/plpython3u.control +share/postgresql/extension/plpythonu--1.0.sql +share/postgresql/extension/plpythonu--unpackaged--1.0.sql +share/postgresql/extension/plpythonu.control diff --git a/databases/postgresql91-pltcl/DESCR b/databases/postgresql91-pltcl/DESCR new file mode 100644 index 00000000000..e1aca2980b9 --- /dev/null +++ b/databases/postgresql91-pltcl/DESCR @@ -0,0 +1,4 @@ +PL/Tcl is a dynamic loadable extension for the PostgreSQL database system +that enables the Tcl language to be used to create functions and +trigger-procedures. It offers most of the capabilities a function +writer has in the C language. diff --git a/databases/postgresql91-pltcl/MESSAGE b/databases/postgresql91-pltcl/MESSAGE new file mode 100644 index 00000000000..d5dc1b2bb20 --- /dev/null +++ b/databases/postgresql91-pltcl/MESSAGE @@ -0,0 +1,7 @@ +=========================================================================== +$NetBSD: MESSAGE,v 1.1.1.1 2011/09/15 08:32:01 adam Exp $ + +Please see the PL/Tcl section of the PostgreSQL Programmer's Guide +(databases/postgresql-docs) for information on programming with +${PKGNAME}. +=========================================================================== diff --git a/databases/postgresql91-pltcl/Makefile b/databases/postgresql91-pltcl/Makefile new file mode 100644 index 00000000000..4c0cc0378ec --- /dev/null +++ b/databases/postgresql91-pltcl/Makefile @@ -0,0 +1,22 @@ +# $NetBSD: Makefile,v 1.1.1.1 2011/09/15 08:32:01 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/91-pltcl-/} +COMMENT= PL/Tcl procedural language for the PostgreSQL backend + +PKG_DESTDIR_SUPPORT= user-destdir + +DEPENDS+= postgresql91-server>=${PKGVERSION_NOREV}:../../databases/postgresql91-server + +.include "../../databases/postgresql91/Makefile.common" + +CONFIGURE_ARGS+= --with-tcl +CONFIGURE_ARGS+= --with-tclconfig="${BUILDLINK_PREFIX.tcl}/lib" +CONFIGURE_ENV+= TCLSH="${TCLSH}" +TCLSH= ${BUILDLINK_PREFIX.tcl}/bin/tclsh +BUILD_MAKE_FLAGS= PGXS=1 + +BUILD_DIRS= src/pl/tcl + +.include "../../databases/postgresql91-client/buildlink3.mk" +.include "../../lang/tcl/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql91-pltcl/PLIST b/databases/postgresql91-pltcl/PLIST new file mode 100644 index 00000000000..79c6fcdc07f --- /dev/null +++ b/databases/postgresql91-pltcl/PLIST @@ -0,0 +1,24 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2011/09/15 08:32:01 adam Exp $ +bin/pltcl_delmod +bin/pltcl_listmod +bin/pltcl_loadmod +lib/postgresql/pltcl.so +share/locale/cs/LC_MESSAGES/pltcl-9.1.mo +share/locale/de/LC_MESSAGES/pltcl-9.1.mo +share/locale/es/LC_MESSAGES/pltcl-9.1.mo +share/locale/fr/LC_MESSAGES/pltcl-9.1.mo +share/locale/it/LC_MESSAGES/pltcl-9.1.mo +share/locale/ja/LC_MESSAGES/pltcl-9.1.mo +share/locale/pl/LC_MESSAGES/pltcl-9.1.mo +share/locale/pt_BR/LC_MESSAGES/pltcl-9.1.mo +share/locale/ro/LC_MESSAGES/pltcl-9.1.mo +share/locale/tr/LC_MESSAGES/pltcl-9.1.mo +share/locale/zh_CN/LC_MESSAGES/pltcl-9.1.mo +share/locale/zh_TW/LC_MESSAGES/pltcl-9.1.mo +share/postgresql/extension/pltcl--1.0.sql +share/postgresql/extension/pltcl--unpackaged--1.0.sql +share/postgresql/extension/pltcl.control +share/postgresql/extension/pltclu--1.0.sql +share/postgresql/extension/pltclu--unpackaged--1.0.sql +share/postgresql/extension/pltclu.control +share/postgresql/unknown.pltcl diff --git a/databases/postgresql91-replicationtools/DESCR b/databases/postgresql91-replicationtools/DESCR new file mode 100644 index 00000000000..781934b4da0 --- /dev/null +++ b/databases/postgresql91-replicationtools/DESCR @@ -0,0 +1,12 @@ +This package provides the following PostgreSQL tools: + - pg_archivecleanup + - pg_standby + +pg_standby supports creation of a "warm standby" database server. +It is designed to be a waiting restore_command, which is needed +to turn a standard archive recovery into a warm standby operation. + +pg_archivecleanup is designed to cleanup an archive when used as +an archive_cleanup_command when running with standby_mode = on. +pg_archivecleanup can also be used as a standalone program to +clean WAL file archives. diff --git a/databases/postgresql91-replicationtools/Makefile b/databases/postgresql91-replicationtools/Makefile new file mode 100644 index 00000000000..1e5c87bedd6 --- /dev/null +++ b/databases/postgresql91-replicationtools/Makefile @@ -0,0 +1,14 @@ +# $NetBSD: Makefile,v 1.1.1.1 2011/09/15 08:33:19 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/91-replicationtools-/} +COMMENT= PostgreSQL replication tools + +PKG_DESTDIR_SUPPORT= user-destdir + +.include "../../databases/postgresql91/Makefile.common" + +BUILD_DIRS+= contrib/pg_archivecleanup +BUILD_DIRS+= contrib/pg_standby + +.include "../../databases/postgresql91-client/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql91-replicationtools/PLIST b/databases/postgresql91-replicationtools/PLIST new file mode 100644 index 00000000000..1936edec3dc --- /dev/null +++ b/databases/postgresql91-replicationtools/PLIST @@ -0,0 +1,3 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2011/09/15 08:33:19 adam Exp $ +bin/pg_archivecleanup +bin/pg_standby diff --git a/databases/postgresql91-server/DEINSTALL b/databases/postgresql91-server/DEINSTALL new file mode 100644 index 00000000000..99587755cff --- /dev/null +++ b/databases/postgresql91-server/DEINSTALL @@ -0,0 +1,20 @@ +# $NetBSD: DEINSTALL,v 1.1.1.1 2011/09/15 08:28:29 adam 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/postgresql91-server/DESCR b/databases/postgresql91-server/DESCR new file mode 100644 index 00000000000..68bb2b05748 --- /dev/null +++ b/databases/postgresql91-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/postgresql91-server/MESSAGE b/databases/postgresql91-server/MESSAGE new file mode 100644 index 00000000000..517a5ef8624 --- /dev/null +++ b/databases/postgresql91-server/MESSAGE @@ -0,0 +1,18 @@ +=========================================================================== +$NetBSD: MESSAGE,v 1.1.1.1 2011/09/15 08:28:29 adam 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 accepts TCP/IP connections on localhost address by default. + +=========================================================================== diff --git a/databases/postgresql91-server/Makefile b/databases/postgresql91-server/Makefile new file mode 100644 index 00000000000..eee4bbaefc1 --- /dev/null +++ b/databases/postgresql91-server/Makefile @@ -0,0 +1,85 @@ +# $NetBSD: Makefile,v 1.1.1.1 2011/09/15 08:28:29 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/91-server-/} +COMMENT= PostgreSQL database server programs + +PKG_DESTDIR_SUPPORT= user-destdir + +# mips has no TAS implementation +NOT_FOR_PLATFORM= *-*-mips + +.include "../../databases/postgresql91/Makefile.common" + +CONFIGURE_ARGS+= --with-openssl + +INSTALL_DIRS= src/backend +INSTALL_DIRS+= src/backend/replication/libpqwalreceiver +INSTALL_DIRS+= src/backend/utils/mb/conversion_procs +INSTALL_DIRS+= src/backend/snowball +INSTALL_DIRS+= src/timezone +INSTALL_DIRS+= src/pl +BUILD_DIRS= src/port +BUILD_DIRS+= ${INSTALL_DIRS} + +LIBS.SunOS+= -lintl + +# PostgreSQL has loadable server-side language modules. +# +# Explicitly set DLOPEN_REQUIRE_PTHREADS to "no" on NetBSD as NetBSD-2.x +# had problems with mixing dlopen() and pthreads, which blows up in +# PostgreSQL's backend (pkg/28729). This works on older and newer +# versions of NetBSD as well since they don't have the bad interaction +# between dlopen() and pthreads. +.if ${OPSYS} == "NetBSD" +DLOPEN_REQUIRE_PTHREADS= no +.endif +.include "../../mk/dlopen.buildlink3.mk" + +# If we're using libltdl to provide "dlopen" functionality, then add the +# dependency and make sure that we link against -lltdl. +.if !empty(USE_LIBLTDL:M[yY][eE][sS]) +DL_LIBS+= -lltdl +. include "../../devel/libltdl/buildlink3.mk" +.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+= PGHOME + +ALL_ENV+= INSTALLED_LIBPQ=yes + +PKG_GROUPS_VARS+= PGGROUP +PKG_USERS_VARS+= PGUSER + +PKG_GROUPS= ${PGGROUP} +PKG_USERS= ${PGUSER}:${PGGROUP} +PKG_GECOS.${PGUSER}= PostgreSQL database administrator +PKG_HOME.${PGUSER}= ${PGHOME} + +RCD_SCRIPTS= pgsql + +.include "../../databases/postgresql91-client/buildlink3.mk" +.include "../../security/openssl/buildlink3.mk" + +# Avoid conflict between "${SSLBASE}/include/openssl/des.h" and +# "/usr/include/crypt.h" -- we want the definitions in the former. +post-wrapper: +.if ${OPSYS} == "SunOS" + touch ${BUILDLINK_DIR}/include/crypt.h +.endif + +.include "../../mk/bsd.pkg.mk" + +# Because RCD_SCRIPTS_EXAMPLEDIR isn't configurable (yet?), +# we override it here: +.if !empty(PG_SUBPREFIX) +RCD_SCRIPTS_EXAMPLEDIR:= $(PG_SUBPREFIX:/=)/$(RCD_SCRIPTS_EXAMPLEDIR) +.endif diff --git a/databases/postgresql91-server/PLIST b/databases/postgresql91-server/PLIST new file mode 100644 index 00000000000..dac1a12229e --- /dev/null +++ b/databases/postgresql91-server/PLIST @@ -0,0 +1,681 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2011/09/15 08:28:29 adam Exp $ +bin/postgres +bin/postmaster +lib/postgresql/ascii_and_mic.so +lib/postgresql/cyrillic_and_mic.so +lib/postgresql/dict_snowball.so +lib/postgresql/euc2004_sjis2004.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/libpqwalreceiver.so +lib/postgresql/plpgsql.so +lib/postgresql/utf8_and_ascii.so +lib/postgresql/utf8_and_big5.so +lib/postgresql/utf8_and_cyrillic.so +lib/postgresql/utf8_and_euc2004.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_sjis2004.so +lib/postgresql/utf8_and_uhc.so +lib/postgresql/utf8_and_win.so +share/examples/rc.d/pgsql +share/locale/cs/LC_MESSAGES/plpgsql-9.1.mo +share/locale/de/LC_MESSAGES/plpgsql-9.1.mo +share/locale/de/LC_MESSAGES/postgres-9.1.mo +share/locale/es/LC_MESSAGES/plpgsql-9.1.mo +share/locale/es/LC_MESSAGES/postgres-9.1.mo +share/locale/fr/LC_MESSAGES/plpgsql-9.1.mo +share/locale/fr/LC_MESSAGES/postgres-9.1.mo +share/locale/it/LC_MESSAGES/plpgsql-9.1.mo +share/locale/ja/LC_MESSAGES/plpgsql-9.1.mo +share/locale/ja/LC_MESSAGES/postgres-9.1.mo +share/locale/ko/LC_MESSAGES/plpgsql-9.1.mo +share/locale/pl/LC_MESSAGES/plpgsql-9.1.mo +share/locale/pt_BR/LC_MESSAGES/plpgsql-9.1.mo +share/locale/pt_BR/LC_MESSAGES/postgres-9.1.mo +share/locale/ro/LC_MESSAGES/plpgsql-9.1.mo +share/locale/tr/LC_MESSAGES/plpgsql-9.1.mo +share/locale/zh_CN/LC_MESSAGES/plpgsql-9.1.mo +share/locale/zh_CN/LC_MESSAGES/postgres-9.1.mo +share/locale/zh_TW/LC_MESSAGES/plpgsql-9.1.mo +share/locale/zh_TW/LC_MESSAGES/postgres-9.1.mo +share/postgresql/conversion_create.sql +share/postgresql/extension/plpgsql--1.0.sql +share/postgresql/extension/plpgsql--unpackaged--1.0.sql +share/postgresql/extension/plpgsql.control +share/postgresql/information_schema.sql +share/postgresql/pg_hba.conf.sample +share/postgresql/pg_ident.conf.sample +share/postgresql/postgres.bki +share/postgresql/postgres.description +share/postgresql/postgres.shdescription +share/postgresql/postgresql.conf.sample +share/postgresql/recovery.conf.sample +share/postgresql/snowball_create.sql +share/postgresql/sql_features.txt +share/postgresql/system_views.sql +share/postgresql/timezone/Africa/Abidjan +share/postgresql/timezone/Africa/Accra +share/postgresql/timezone/Africa/Addis_Ababa +share/postgresql/timezone/Africa/Algiers +share/postgresql/timezone/Africa/Asmara +share/postgresql/timezone/Africa/Asmera +share/postgresql/timezone/Africa/Bamako +share/postgresql/timezone/Africa/Bangui +share/postgresql/timezone/Africa/Banjul +share/postgresql/timezone/Africa/Bissau +share/postgresql/timezone/Africa/Blantyre +share/postgresql/timezone/Africa/Brazzaville +share/postgresql/timezone/Africa/Bujumbura +share/postgresql/timezone/Africa/Cairo +share/postgresql/timezone/Africa/Casablanca +share/postgresql/timezone/Africa/Ceuta +share/postgresql/timezone/Africa/Conakry +share/postgresql/timezone/Africa/Dakar +share/postgresql/timezone/Africa/Dar_es_Salaam +share/postgresql/timezone/Africa/Djibouti +share/postgresql/timezone/Africa/Douala +share/postgresql/timezone/Africa/El_Aaiun +share/postgresql/timezone/Africa/Freetown +share/postgresql/timezone/Africa/Gaborone +share/postgresql/timezone/Africa/Harare +share/postgresql/timezone/Africa/Johannesburg +share/postgresql/timezone/Africa/Juba +share/postgresql/timezone/Africa/Kampala +share/postgresql/timezone/Africa/Khartoum +share/postgresql/timezone/Africa/Kigali +share/postgresql/timezone/Africa/Kinshasa +share/postgresql/timezone/Africa/Lagos +share/postgresql/timezone/Africa/Libreville +share/postgresql/timezone/Africa/Lome +share/postgresql/timezone/Africa/Luanda +share/postgresql/timezone/Africa/Lubumbashi +share/postgresql/timezone/Africa/Lusaka +share/postgresql/timezone/Africa/Malabo +share/postgresql/timezone/Africa/Maputo +share/postgresql/timezone/Africa/Maseru +share/postgresql/timezone/Africa/Mbabane +share/postgresql/timezone/Africa/Mogadishu +share/postgresql/timezone/Africa/Monrovia +share/postgresql/timezone/Africa/Nairobi +share/postgresql/timezone/Africa/Ndjamena +share/postgresql/timezone/Africa/Niamey +share/postgresql/timezone/Africa/Nouakchott +share/postgresql/timezone/Africa/Ouagadougou +share/postgresql/timezone/Africa/Porto-Novo +share/postgresql/timezone/Africa/Sao_Tome +share/postgresql/timezone/Africa/Timbuktu +share/postgresql/timezone/Africa/Tripoli +share/postgresql/timezone/Africa/Tunis +share/postgresql/timezone/Africa/Windhoek +share/postgresql/timezone/America/Adak +share/postgresql/timezone/America/Anchorage +share/postgresql/timezone/America/Anguilla +share/postgresql/timezone/America/Antigua +share/postgresql/timezone/America/Araguaina +share/postgresql/timezone/America/Argentina/Buenos_Aires +share/postgresql/timezone/America/Argentina/Catamarca +share/postgresql/timezone/America/Argentina/ComodRivadavia +share/postgresql/timezone/America/Argentina/Cordoba +share/postgresql/timezone/America/Argentina/Jujuy +share/postgresql/timezone/America/Argentina/La_Rioja +share/postgresql/timezone/America/Argentina/Mendoza +share/postgresql/timezone/America/Argentina/Rio_Gallegos +share/postgresql/timezone/America/Argentina/Salta +share/postgresql/timezone/America/Argentina/San_Juan +share/postgresql/timezone/America/Argentina/San_Luis +share/postgresql/timezone/America/Argentina/Tucuman +share/postgresql/timezone/America/Argentina/Ushuaia +share/postgresql/timezone/America/Aruba +share/postgresql/timezone/America/Asuncion +share/postgresql/timezone/America/Atikokan +share/postgresql/timezone/America/Atka +share/postgresql/timezone/America/Bahia +share/postgresql/timezone/America/Bahia_Banderas +share/postgresql/timezone/America/Barbados +share/postgresql/timezone/America/Belem +share/postgresql/timezone/America/Belize +share/postgresql/timezone/America/Blanc-Sablon +share/postgresql/timezone/America/Boa_Vista +share/postgresql/timezone/America/Bogota +share/postgresql/timezone/America/Boise +share/postgresql/timezone/America/Buenos_Aires +share/postgresql/timezone/America/Cambridge_Bay +share/postgresql/timezone/America/Campo_Grande +share/postgresql/timezone/America/Cancun +share/postgresql/timezone/America/Caracas +share/postgresql/timezone/America/Catamarca +share/postgresql/timezone/America/Cayenne +share/postgresql/timezone/America/Cayman +share/postgresql/timezone/America/Chicago +share/postgresql/timezone/America/Chihuahua +share/postgresql/timezone/America/Coral_Harbour +share/postgresql/timezone/America/Cordoba +share/postgresql/timezone/America/Costa_Rica +share/postgresql/timezone/America/Cuiaba +share/postgresql/timezone/America/Curacao +share/postgresql/timezone/America/Danmarkshavn +share/postgresql/timezone/America/Dawson +share/postgresql/timezone/America/Dawson_Creek +share/postgresql/timezone/America/Denver +share/postgresql/timezone/America/Detroit +share/postgresql/timezone/America/Dominica +share/postgresql/timezone/America/Edmonton +share/postgresql/timezone/America/Eirunepe +share/postgresql/timezone/America/El_Salvador +share/postgresql/timezone/America/Ensenada +share/postgresql/timezone/America/Fort_Wayne +share/postgresql/timezone/America/Fortaleza +share/postgresql/timezone/America/Glace_Bay +share/postgresql/timezone/America/Godthab +share/postgresql/timezone/America/Goose_Bay +share/postgresql/timezone/America/Grand_Turk +share/postgresql/timezone/America/Grenada +share/postgresql/timezone/America/Guadeloupe +share/postgresql/timezone/America/Guatemala +share/postgresql/timezone/America/Guayaquil +share/postgresql/timezone/America/Guyana +share/postgresql/timezone/America/Halifax +share/postgresql/timezone/America/Havana +share/postgresql/timezone/America/Hermosillo +share/postgresql/timezone/America/Indiana/Indianapolis +share/postgresql/timezone/America/Indiana/Knox +share/postgresql/timezone/America/Indiana/Marengo +share/postgresql/timezone/America/Indiana/Petersburg +share/postgresql/timezone/America/Indiana/Tell_City +share/postgresql/timezone/America/Indiana/Vevay +share/postgresql/timezone/America/Indiana/Vincennes +share/postgresql/timezone/America/Indiana/Winamac +share/postgresql/timezone/America/Indianapolis +share/postgresql/timezone/America/Inuvik +share/postgresql/timezone/America/Iqaluit +share/postgresql/timezone/America/Jamaica +share/postgresql/timezone/America/Jujuy +share/postgresql/timezone/America/Juneau +share/postgresql/timezone/America/Kentucky/Louisville +share/postgresql/timezone/America/Kentucky/Monticello +share/postgresql/timezone/America/Knox_IN +share/postgresql/timezone/America/Kralendijk +share/postgresql/timezone/America/La_Paz +share/postgresql/timezone/America/Lima +share/postgresql/timezone/America/Los_Angeles +share/postgresql/timezone/America/Louisville +share/postgresql/timezone/America/Lower_Princes +share/postgresql/timezone/America/Maceio +share/postgresql/timezone/America/Managua +share/postgresql/timezone/America/Manaus +share/postgresql/timezone/America/Marigot +share/postgresql/timezone/America/Martinique +share/postgresql/timezone/America/Matamoros +share/postgresql/timezone/America/Mazatlan +share/postgresql/timezone/America/Mendoza +share/postgresql/timezone/America/Menominee +share/postgresql/timezone/America/Merida +share/postgresql/timezone/America/Metlakatla +share/postgresql/timezone/America/Mexico_City +share/postgresql/timezone/America/Miquelon +share/postgresql/timezone/America/Moncton +share/postgresql/timezone/America/Monterrey +share/postgresql/timezone/America/Montevideo +share/postgresql/timezone/America/Montreal +share/postgresql/timezone/America/Montserrat +share/postgresql/timezone/America/Nassau +share/postgresql/timezone/America/New_York +share/postgresql/timezone/America/Nipigon +share/postgresql/timezone/America/Nome +share/postgresql/timezone/America/Noronha +share/postgresql/timezone/America/North_Dakota/Beulah +share/postgresql/timezone/America/North_Dakota/Center +share/postgresql/timezone/America/North_Dakota/New_Salem +share/postgresql/timezone/America/Ojinaga +share/postgresql/timezone/America/Panama +share/postgresql/timezone/America/Pangnirtung +share/postgresql/timezone/America/Paramaribo +share/postgresql/timezone/America/Phoenix +share/postgresql/timezone/America/Port-au-Prince +share/postgresql/timezone/America/Port_of_Spain +share/postgresql/timezone/America/Porto_Acre +share/postgresql/timezone/America/Porto_Velho +share/postgresql/timezone/America/Puerto_Rico +share/postgresql/timezone/America/Rainy_River +share/postgresql/timezone/America/Rankin_Inlet +share/postgresql/timezone/America/Recife +share/postgresql/timezone/America/Regina +share/postgresql/timezone/America/Resolute +share/postgresql/timezone/America/Rio_Branco +share/postgresql/timezone/America/Rosario +share/postgresql/timezone/America/Santa_Isabel +share/postgresql/timezone/America/Santarem +share/postgresql/timezone/America/Santiago +share/postgresql/timezone/America/Santo_Domingo +share/postgresql/timezone/America/Sao_Paulo +share/postgresql/timezone/America/Scoresbysund +share/postgresql/timezone/America/Shiprock +share/postgresql/timezone/America/Sitka +share/postgresql/timezone/America/St_Barthelemy +share/postgresql/timezone/America/St_Johns +share/postgresql/timezone/America/St_Kitts +share/postgresql/timezone/America/St_Lucia +share/postgresql/timezone/America/St_Thomas +share/postgresql/timezone/America/St_Vincent +share/postgresql/timezone/America/Swift_Current +share/postgresql/timezone/America/Tegucigalpa +share/postgresql/timezone/America/Thule +share/postgresql/timezone/America/Thunder_Bay +share/postgresql/timezone/America/Tijuana +share/postgresql/timezone/America/Toronto +share/postgresql/timezone/America/Tortola +share/postgresql/timezone/America/Vancouver +share/postgresql/timezone/America/Virgin +share/postgresql/timezone/America/Whitehorse +share/postgresql/timezone/America/Winnipeg +share/postgresql/timezone/America/Yakutat +share/postgresql/timezone/America/Yellowknife +share/postgresql/timezone/Antarctica/Casey +share/postgresql/timezone/Antarctica/Davis +share/postgresql/timezone/Antarctica/DumontDUrville +share/postgresql/timezone/Antarctica/Macquarie +share/postgresql/timezone/Antarctica/Mawson +share/postgresql/timezone/Antarctica/McMurdo +share/postgresql/timezone/Antarctica/Palmer +share/postgresql/timezone/Antarctica/Rothera +share/postgresql/timezone/Antarctica/South_Pole +share/postgresql/timezone/Antarctica/Syowa +share/postgresql/timezone/Antarctica/Vostok +share/postgresql/timezone/Arctic/Longyearbyen +share/postgresql/timezone/Asia/Aden +share/postgresql/timezone/Asia/Almaty +share/postgresql/timezone/Asia/Amman +share/postgresql/timezone/Asia/Anadyr +share/postgresql/timezone/Asia/Aqtau +share/postgresql/timezone/Asia/Aqtobe +share/postgresql/timezone/Asia/Ashgabat +share/postgresql/timezone/Asia/Ashkhabad +share/postgresql/timezone/Asia/Baghdad +share/postgresql/timezone/Asia/Bahrain +share/postgresql/timezone/Asia/Baku +share/postgresql/timezone/Asia/Bangkok +share/postgresql/timezone/Asia/Beirut +share/postgresql/timezone/Asia/Bishkek +share/postgresql/timezone/Asia/Brunei +share/postgresql/timezone/Asia/Calcutta +share/postgresql/timezone/Asia/Choibalsan +share/postgresql/timezone/Asia/Chongqing +share/postgresql/timezone/Asia/Chungking +share/postgresql/timezone/Asia/Colombo +share/postgresql/timezone/Asia/Dacca +share/postgresql/timezone/Asia/Damascus +share/postgresql/timezone/Asia/Dhaka +share/postgresql/timezone/Asia/Dili +share/postgresql/timezone/Asia/Dubai +share/postgresql/timezone/Asia/Dushanbe +share/postgresql/timezone/Asia/Gaza +share/postgresql/timezone/Asia/Harbin +share/postgresql/timezone/Asia/Ho_Chi_Minh +share/postgresql/timezone/Asia/Hong_Kong +share/postgresql/timezone/Asia/Hovd +share/postgresql/timezone/Asia/Irkutsk +share/postgresql/timezone/Asia/Istanbul +share/postgresql/timezone/Asia/Jakarta +share/postgresql/timezone/Asia/Jayapura +share/postgresql/timezone/Asia/Jerusalem +share/postgresql/timezone/Asia/Kabul +share/postgresql/timezone/Asia/Kamchatka +share/postgresql/timezone/Asia/Karachi +share/postgresql/timezone/Asia/Kashgar +share/postgresql/timezone/Asia/Kathmandu +share/postgresql/timezone/Asia/Katmandu +share/postgresql/timezone/Asia/Kolkata +share/postgresql/timezone/Asia/Krasnoyarsk +share/postgresql/timezone/Asia/Kuala_Lumpur +share/postgresql/timezone/Asia/Kuching +share/postgresql/timezone/Asia/Kuwait +share/postgresql/timezone/Asia/Macao +share/postgresql/timezone/Asia/Macau +share/postgresql/timezone/Asia/Magadan +share/postgresql/timezone/Asia/Makassar +share/postgresql/timezone/Asia/Manila +share/postgresql/timezone/Asia/Muscat +share/postgresql/timezone/Asia/Nicosia +share/postgresql/timezone/Asia/Novokuznetsk +share/postgresql/timezone/Asia/Novosibirsk +share/postgresql/timezone/Asia/Omsk +share/postgresql/timezone/Asia/Oral +share/postgresql/timezone/Asia/Phnom_Penh +share/postgresql/timezone/Asia/Pontianak +share/postgresql/timezone/Asia/Pyongyang +share/postgresql/timezone/Asia/Qatar +share/postgresql/timezone/Asia/Qyzylorda +share/postgresql/timezone/Asia/Rangoon +share/postgresql/timezone/Asia/Riyadh +share/postgresql/timezone/Asia/Riyadh87 +share/postgresql/timezone/Asia/Riyadh88 +share/postgresql/timezone/Asia/Riyadh89 +share/postgresql/timezone/Asia/Saigon +share/postgresql/timezone/Asia/Sakhalin +share/postgresql/timezone/Asia/Samarkand +share/postgresql/timezone/Asia/Seoul +share/postgresql/timezone/Asia/Shanghai +share/postgresql/timezone/Asia/Singapore +share/postgresql/timezone/Asia/Taipei +share/postgresql/timezone/Asia/Tashkent +share/postgresql/timezone/Asia/Tbilisi +share/postgresql/timezone/Asia/Tehran +share/postgresql/timezone/Asia/Tel_Aviv +share/postgresql/timezone/Asia/Thimbu +share/postgresql/timezone/Asia/Thimphu +share/postgresql/timezone/Asia/Tokyo +share/postgresql/timezone/Asia/Ujung_Pandang +share/postgresql/timezone/Asia/Ulaanbaatar +share/postgresql/timezone/Asia/Ulan_Bator +share/postgresql/timezone/Asia/Urumqi +share/postgresql/timezone/Asia/Vientiane +share/postgresql/timezone/Asia/Vladivostok +share/postgresql/timezone/Asia/Yakutsk +share/postgresql/timezone/Asia/Yekaterinburg +share/postgresql/timezone/Asia/Yerevan +share/postgresql/timezone/Atlantic/Azores +share/postgresql/timezone/Atlantic/Bermuda +share/postgresql/timezone/Atlantic/Canary +share/postgresql/timezone/Atlantic/Cape_Verde +share/postgresql/timezone/Atlantic/Faeroe +share/postgresql/timezone/Atlantic/Faroe +share/postgresql/timezone/Atlantic/Jan_Mayen +share/postgresql/timezone/Atlantic/Madeira +share/postgresql/timezone/Atlantic/Reykjavik +share/postgresql/timezone/Atlantic/South_Georgia +share/postgresql/timezone/Atlantic/St_Helena +share/postgresql/timezone/Atlantic/Stanley +share/postgresql/timezone/Australia/ACT +share/postgresql/timezone/Australia/Adelaide +share/postgresql/timezone/Australia/Brisbane +share/postgresql/timezone/Australia/Broken_Hill +share/postgresql/timezone/Australia/Canberra +share/postgresql/timezone/Australia/Currie +share/postgresql/timezone/Australia/Darwin +share/postgresql/timezone/Australia/Eucla +share/postgresql/timezone/Australia/Hobart +share/postgresql/timezone/Australia/LHI +share/postgresql/timezone/Australia/Lindeman +share/postgresql/timezone/Australia/Lord_Howe +share/postgresql/timezone/Australia/Melbourne +share/postgresql/timezone/Australia/NSW +share/postgresql/timezone/Australia/North +share/postgresql/timezone/Australia/Perth +share/postgresql/timezone/Australia/Queensland +share/postgresql/timezone/Australia/South +share/postgresql/timezone/Australia/Sydney +share/postgresql/timezone/Australia/Tasmania +share/postgresql/timezone/Australia/Victoria +share/postgresql/timezone/Australia/West +share/postgresql/timezone/Australia/Yancowinna +share/postgresql/timezone/Brazil/Acre +share/postgresql/timezone/Brazil/DeNoronha +share/postgresql/timezone/Brazil/East +share/postgresql/timezone/Brazil/West +share/postgresql/timezone/CET +share/postgresql/timezone/CST6CDT +share/postgresql/timezone/Canada/Atlantic +share/postgresql/timezone/Canada/Central +share/postgresql/timezone/Canada/East-Saskatchewan +share/postgresql/timezone/Canada/Eastern +share/postgresql/timezone/Canada/Mountain +share/postgresql/timezone/Canada/Newfoundland +share/postgresql/timezone/Canada/Pacific +share/postgresql/timezone/Canada/Saskatchewan +share/postgresql/timezone/Canada/Yukon +share/postgresql/timezone/Chile/Continental +share/postgresql/timezone/Chile/EasterIsland +share/postgresql/timezone/Cuba +share/postgresql/timezone/EET +share/postgresql/timezone/EST +share/postgresql/timezone/EST5EDT +share/postgresql/timezone/Egypt +share/postgresql/timezone/Eire +share/postgresql/timezone/Etc/GMT +share/postgresql/timezone/Etc/GMT+0 +share/postgresql/timezone/Etc/GMT+1 +share/postgresql/timezone/Etc/GMT+10 +share/postgresql/timezone/Etc/GMT+11 +share/postgresql/timezone/Etc/GMT+12 +share/postgresql/timezone/Etc/GMT+2 +share/postgresql/timezone/Etc/GMT+3 +share/postgresql/timezone/Etc/GMT+4 +share/postgresql/timezone/Etc/GMT+5 +share/postgresql/timezone/Etc/GMT+6 +share/postgresql/timezone/Etc/GMT+7 +share/postgresql/timezone/Etc/GMT+8 +share/postgresql/timezone/Etc/GMT+9 +share/postgresql/timezone/Etc/GMT-0 +share/postgresql/timezone/Etc/GMT-1 +share/postgresql/timezone/Etc/GMT-10 +share/postgresql/timezone/Etc/GMT-11 +share/postgresql/timezone/Etc/GMT-12 +share/postgresql/timezone/Etc/GMT-13 +share/postgresql/timezone/Etc/GMT-14 +share/postgresql/timezone/Etc/GMT-2 +share/postgresql/timezone/Etc/GMT-3 +share/postgresql/timezone/Etc/GMT-4 +share/postgresql/timezone/Etc/GMT-5 +share/postgresql/timezone/Etc/GMT-6 +share/postgresql/timezone/Etc/GMT-7 +share/postgresql/timezone/Etc/GMT-8 +share/postgresql/timezone/Etc/GMT-9 +share/postgresql/timezone/Etc/GMT0 +share/postgresql/timezone/Etc/Greenwich +share/postgresql/timezone/Etc/UCT +share/postgresql/timezone/Etc/UTC +share/postgresql/timezone/Etc/Universal +share/postgresql/timezone/Etc/Zulu +share/postgresql/timezone/Europe/Amsterdam +share/postgresql/timezone/Europe/Andorra +share/postgresql/timezone/Europe/Athens +share/postgresql/timezone/Europe/Belfast +share/postgresql/timezone/Europe/Belgrade +share/postgresql/timezone/Europe/Berlin +share/postgresql/timezone/Europe/Bratislava +share/postgresql/timezone/Europe/Brussels +share/postgresql/timezone/Europe/Bucharest +share/postgresql/timezone/Europe/Budapest +share/postgresql/timezone/Europe/Chisinau +share/postgresql/timezone/Europe/Copenhagen +share/postgresql/timezone/Europe/Dublin +share/postgresql/timezone/Europe/Gibraltar +share/postgresql/timezone/Europe/Guernsey +share/postgresql/timezone/Europe/Helsinki +share/postgresql/timezone/Europe/Isle_of_Man +share/postgresql/timezone/Europe/Istanbul +share/postgresql/timezone/Europe/Jersey +share/postgresql/timezone/Europe/Kaliningrad +share/postgresql/timezone/Europe/Kiev +share/postgresql/timezone/Europe/Lisbon +share/postgresql/timezone/Europe/Ljubljana +share/postgresql/timezone/Europe/London +share/postgresql/timezone/Europe/Luxembourg +share/postgresql/timezone/Europe/Madrid +share/postgresql/timezone/Europe/Malta +share/postgresql/timezone/Europe/Mariehamn +share/postgresql/timezone/Europe/Minsk +share/postgresql/timezone/Europe/Monaco +share/postgresql/timezone/Europe/Moscow +share/postgresql/timezone/Europe/Nicosia +share/postgresql/timezone/Europe/Oslo +share/postgresql/timezone/Europe/Paris +share/postgresql/timezone/Europe/Podgorica +share/postgresql/timezone/Europe/Prague +share/postgresql/timezone/Europe/Riga +share/postgresql/timezone/Europe/Rome +share/postgresql/timezone/Europe/Samara +share/postgresql/timezone/Europe/San_Marino +share/postgresql/timezone/Europe/Sarajevo +share/postgresql/timezone/Europe/Simferopol +share/postgresql/timezone/Europe/Skopje +share/postgresql/timezone/Europe/Sofia +share/postgresql/timezone/Europe/Stockholm +share/postgresql/timezone/Europe/Tallinn +share/postgresql/timezone/Europe/Tirane +share/postgresql/timezone/Europe/Tiraspol +share/postgresql/timezone/Europe/Uzhgorod +share/postgresql/timezone/Europe/Vaduz +share/postgresql/timezone/Europe/Vatican +share/postgresql/timezone/Europe/Vienna +share/postgresql/timezone/Europe/Vilnius +share/postgresql/timezone/Europe/Volgograd +share/postgresql/timezone/Europe/Warsaw +share/postgresql/timezone/Europe/Zagreb +share/postgresql/timezone/Europe/Zaporozhye +share/postgresql/timezone/Europe/Zurich +share/postgresql/timezone/Factory +share/postgresql/timezone/GB +share/postgresql/timezone/GB-Eire +share/postgresql/timezone/GMT +share/postgresql/timezone/GMT+0 +share/postgresql/timezone/GMT-0 +share/postgresql/timezone/GMT0 +share/postgresql/timezone/Greenwich +share/postgresql/timezone/HST +share/postgresql/timezone/Hongkong +share/postgresql/timezone/Iceland +share/postgresql/timezone/Indian/Antananarivo +share/postgresql/timezone/Indian/Chagos +share/postgresql/timezone/Indian/Christmas +share/postgresql/timezone/Indian/Cocos +share/postgresql/timezone/Indian/Comoro +share/postgresql/timezone/Indian/Kerguelen +share/postgresql/timezone/Indian/Mahe +share/postgresql/timezone/Indian/Maldives +share/postgresql/timezone/Indian/Mauritius +share/postgresql/timezone/Indian/Mayotte +share/postgresql/timezone/Indian/Reunion +share/postgresql/timezone/Iran +share/postgresql/timezone/Israel +share/postgresql/timezone/Jamaica +share/postgresql/timezone/Japan +share/postgresql/timezone/Kwajalein +share/postgresql/timezone/Libya +share/postgresql/timezone/MET +share/postgresql/timezone/MST +share/postgresql/timezone/MST7MDT +share/postgresql/timezone/Mexico/BajaNorte +share/postgresql/timezone/Mexico/BajaSur +share/postgresql/timezone/Mexico/General +share/postgresql/timezone/Mideast/Riyadh87 +share/postgresql/timezone/Mideast/Riyadh88 +share/postgresql/timezone/Mideast/Riyadh89 +share/postgresql/timezone/NZ +share/postgresql/timezone/NZ-CHAT +share/postgresql/timezone/Navajo +share/postgresql/timezone/PRC +share/postgresql/timezone/PST8PDT +share/postgresql/timezone/Pacific/Apia +share/postgresql/timezone/Pacific/Auckland +share/postgresql/timezone/Pacific/Chatham +share/postgresql/timezone/Pacific/Chuuk +share/postgresql/timezone/Pacific/Easter +share/postgresql/timezone/Pacific/Efate +share/postgresql/timezone/Pacific/Enderbury +share/postgresql/timezone/Pacific/Fakaofo +share/postgresql/timezone/Pacific/Fiji +share/postgresql/timezone/Pacific/Funafuti +share/postgresql/timezone/Pacific/Galapagos +share/postgresql/timezone/Pacific/Gambier +share/postgresql/timezone/Pacific/Guadalcanal +share/postgresql/timezone/Pacific/Guam +share/postgresql/timezone/Pacific/Honolulu +share/postgresql/timezone/Pacific/Johnston +share/postgresql/timezone/Pacific/Kiritimati +share/postgresql/timezone/Pacific/Kosrae +share/postgresql/timezone/Pacific/Kwajalein +share/postgresql/timezone/Pacific/Majuro +share/postgresql/timezone/Pacific/Marquesas +share/postgresql/timezone/Pacific/Midway +share/postgresql/timezone/Pacific/Nauru +share/postgresql/timezone/Pacific/Niue +share/postgresql/timezone/Pacific/Norfolk +share/postgresql/timezone/Pacific/Noumea +share/postgresql/timezone/Pacific/Pago_Pago +share/postgresql/timezone/Pacific/Palau +share/postgresql/timezone/Pacific/Pitcairn +share/postgresql/timezone/Pacific/Pohnpei +share/postgresql/timezone/Pacific/Ponape +share/postgresql/timezone/Pacific/Port_Moresby +share/postgresql/timezone/Pacific/Rarotonga +share/postgresql/timezone/Pacific/Saipan +share/postgresql/timezone/Pacific/Samoa +share/postgresql/timezone/Pacific/Tahiti +share/postgresql/timezone/Pacific/Tarawa +share/postgresql/timezone/Pacific/Tongatapu +share/postgresql/timezone/Pacific/Truk +share/postgresql/timezone/Pacific/Wake +share/postgresql/timezone/Pacific/Wallis +share/postgresql/timezone/Pacific/Yap +share/postgresql/timezone/Poland +share/postgresql/timezone/Portugal +share/postgresql/timezone/ROC +share/postgresql/timezone/ROK +share/postgresql/timezone/Singapore +share/postgresql/timezone/Turkey +share/postgresql/timezone/UCT +share/postgresql/timezone/US/Alaska +share/postgresql/timezone/US/Aleutian +share/postgresql/timezone/US/Arizona +share/postgresql/timezone/US/Central +share/postgresql/timezone/US/East-Indiana +share/postgresql/timezone/US/Eastern +share/postgresql/timezone/US/Hawaii +share/postgresql/timezone/US/Indiana-Starke +share/postgresql/timezone/US/Michigan +share/postgresql/timezone/US/Mountain +share/postgresql/timezone/US/Pacific +share/postgresql/timezone/US/Pacific-New +share/postgresql/timezone/US/Samoa +share/postgresql/timezone/UTC +share/postgresql/timezone/Universal +share/postgresql/timezone/W-SU +share/postgresql/timezone/WET +share/postgresql/timezone/Zulu +share/postgresql/timezone/posixrules +share/postgresql/timezonesets/Africa.txt +share/postgresql/timezonesets/America.txt +share/postgresql/timezonesets/Antarctica.txt +share/postgresql/timezonesets/Asia.txt +share/postgresql/timezonesets/Atlantic.txt +share/postgresql/timezonesets/Australia +share/postgresql/timezonesets/Australia.txt +share/postgresql/timezonesets/Default +share/postgresql/timezonesets/Etc.txt +share/postgresql/timezonesets/Europe.txt +share/postgresql/timezonesets/India +share/postgresql/timezonesets/Indian.txt +share/postgresql/timezonesets/Pacific.txt +share/postgresql/tsearch_data/danish.stop +share/postgresql/tsearch_data/dutch.stop +share/postgresql/tsearch_data/english.stop +share/postgresql/tsearch_data/finnish.stop +share/postgresql/tsearch_data/french.stop +share/postgresql/tsearch_data/german.stop +share/postgresql/tsearch_data/hungarian.stop +share/postgresql/tsearch_data/hunspell_sample.affix +share/postgresql/tsearch_data/ispell_sample.affix +share/postgresql/tsearch_data/ispell_sample.dict +share/postgresql/tsearch_data/italian.stop +share/postgresql/tsearch_data/norwegian.stop +share/postgresql/tsearch_data/portuguese.stop +share/postgresql/tsearch_data/russian.stop +share/postgresql/tsearch_data/spanish.stop +share/postgresql/tsearch_data/swedish.stop +share/postgresql/tsearch_data/synonym_sample.syn +share/postgresql/tsearch_data/thesaurus_sample.ths +share/postgresql/tsearch_data/turkish.stop diff --git a/databases/postgresql91-server/files/pgsql.sh b/databases/postgresql91-server/files/pgsql.sh new file mode 100644 index 00000000000..ec81e335dd7 --- /dev/null +++ b/databases/postgresql91-server/files/pgsql.sh @@ -0,0 +1,130 @@ +#!@RCD_SCRIPTS_SHELL@ +# +# $NetBSD: pgsql.sh,v 1.1.1.1 2011/09/15 08:28:29 adam 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 +# +# Optionally, "pgsql_flags" contains options for the PostgreSQL postmaster, e.g. +# pgsql_flags="-i" # allows TCP/IP connections +# pgsql_flags="-i -l" # enables SSL connections +# pgsql_home="/path/to/home" # path to pgsql database directory +# See postmaster(1) for possible options. + +if [ -f /etc/rc.subr ]; then + . /etc/rc.subr +fi + +name="pgsql" +rcvar=${name} +command="@PREFIX@/bin/pg_ctl" +procname="@PREFIX@/bin/postgres" +pgsql_user="@PGUSER@" +pgsql_group="@PGGROUP@" +pgsql_home="@PGHOME@" + +extra_commands="initdb reload" +initdb_cmd="pgsql_initdb" +start_precmd="pgsql_precmd" +start_cmd="pgsql_start" +restart_precmd="pgsql_precmd" +restart_cmd="pgsql_restart" +stop_cmd="pgsql_stop" +reload_cmd="pgsql_reload" + +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 + +command_args="-w -s -D ${pgsql_home}/data -m fast -l ${pgsql_home}/errlog" +if [ -n "${pgsql_flags}" ]; then + command_args="${command_args} -o \\\"${pgsql_flags}\\\"" +fi + +pgsql_precmd() +{ + ulimit -n 4096 + if [ ! -d ${pgsql_home}/data/base ]; then + pgsql_initdb + fi +} + +pgsql_initdb() +{ + 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@ 0700 ${pgsql_home} + doit="@SU@ -m ${pgsql_user} -c '${command} init ${command_args}'" + eval $doit + fi +} + +pgsql_start() +{ + @ECHO@ "Starting ${name}." + doit="@SU@ -m ${pgsql_user} -c '${command} start ${command_args}'" + eval $doit +} + +pgsql_restart() +{ + @ECHO@ "Restarting ${name}." + doit="@SU@ -m ${pgsql_user} -c '${command} restart ${command_args}'" + eval $doit +} + +pgsql_stop() +{ + @ECHO@ "Stopping ${name}." + doit="@SU@ -m ${pgsql_user} -c '${command} stop ${command_args}'" + eval $doit +} + +pgsql_reload() +{ + @ECHO@ "Reloading ${name}." + doit="@SU@ -m ${pgsql_user} -c '${command} reload ${command_args}'" + eval $doit +} + +if [ -f /etc/rc.subr -a -d /etc/rc.d -a -f /etc/rc.d/DAEMON ]; then + run_rc_command "$1" +else + pidfile="${pgsql_home}/data/postmaster.pid" + case "$1" in + initdb) + eval ${initdb_cmd} + ;; + restart) + eval ${restart_precmd} + eval ${restart_cmd} + ;; + stop) + if [ -r "${pidfile}" ]; then + eval ${stop_cmd} + fi + ;; + reload) + eval ${reload_cmd} + ;; + *) + eval ${start_precmd} + eval ${start_cmd} + ;; + esac +fi diff --git a/databases/postgresql91-upgrade/DESCR b/databases/postgresql91-upgrade/DESCR new file mode 100644 index 00000000000..18267e4ba9a --- /dev/null +++ b/databases/postgresql91-upgrade/DESCR @@ -0,0 +1,14 @@ +pg_upgrade (formerly called pg_migrator) allows data stored +in PostgreSQL data files to be migrated to a later PostgreSQL +major version without the data dump/reload typically required +for major version upgrades, e.g. from 8.4.7 to the current +major release of PostgreSQL. It is not required for minor +version upgrades, e.g. from 9.0.1 to 9.0.4. + +pg_upgrade works because, though new features are regularly +added to PostgreSQL major releases, the internal data storage +format rarely changes. pg_upgrade does its best to make sure the +old and new clusters are binary-compatible, e.g. by checking for +compatible compile-time settings, including 32/64-bit binaries. +It is important that any external modules are also binary +compatible, though this cannot be checked by pg_upgrade. diff --git a/databases/postgresql91-upgrade/Makefile b/databases/postgresql91-upgrade/Makefile new file mode 100644 index 00000000000..27dfd72f6b2 --- /dev/null +++ b/databases/postgresql91-upgrade/Makefile @@ -0,0 +1,21 @@ +# $NetBSD: Makefile,v 1.1.1.1 2011/09/15 08:32:40 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/91-upgrade-/} +COMMENT= PostgreSQL binary upgrade tool +MAINTAINER= pkgsrc-users@NetBSD.org + +PKG_DESTDIR_SUPPORT= user-destdir + +DEPENDS+= postgresql91-server>=${PKGVERSION_NOREV}:../../databases/postgresql91-server + +.include "../../databases/postgresql91/Makefile.common" + +BUILD_MAKE_FLAGS= PGXS=1 + +BUILD_DIRS+= contrib/pg_upgrade +BUILD_DIRS+= contrib/pg_upgrade_support + +LIBS.SunOS+= -lintl + +.include "../../databases/postgresql91-client/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql91-upgrade/PLIST b/databases/postgresql91-upgrade/PLIST new file mode 100644 index 00000000000..8bd3dcf5233 --- /dev/null +++ b/databases/postgresql91-upgrade/PLIST @@ -0,0 +1,3 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2011/09/15 08:32:40 adam Exp $ +bin/pg_upgrade +lib/postgresql/pg_upgrade_support.so diff --git a/databases/postgresql91/DESCR b/databases/postgresql91/DESCR new file mode 100644 index 00000000000..9f6b5b5b0f9 --- /dev/null +++ b/databases/postgresql91/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/postgresql91/Makefile b/databases/postgresql91/Makefile new file mode 100644 index 00000000000..adc898207ac --- /dev/null +++ b/databases/postgresql91/Makefile @@ -0,0 +1,14 @@ +# $NetBSD: Makefile,v 1.1.1.1 2011/09/15 08:27:38 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/91-/} +COMMENT= Robust, next generation, object-relational DBMS + +DEPENDS+= postgresql91-client>=${PKGVERSION_NOREV}:../../databases/postgresql91-client +DEPENDS+= postgresql91-docs>=${PKGVERSION_NOREV}:../../databases/postgresql91-docs +DEPENDS+= postgresql91-server>=${PKGVERSION_NOREV}:../../databases/postgresql91-server + +META_PACKAGE= yes + +.include "Makefile.common" + +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql91/Makefile.common b/databases/postgresql91/Makefile.common new file mode 100644 index 00000000000..e23afc24353 --- /dev/null +++ b/databases/postgresql91/Makefile.common @@ -0,0 +1,113 @@ +# $NetBSD: Makefile.common,v 1.1.1.1 2011/09/15 08:27:38 adam Exp $ +# +# used by databases/postgresql91-adminpack/Makefile +# used by databases/postgresql91-client/Makefile +# used by databases/postgresql91-datatypes/Makefile +# used by databases/postgresql91-dblink/Makefile +# used by databases/postgresql91-docs/Makefile +# used by databases/postgresql91-fuzzystrmatch/Makefile +# used by databases/postgresql91-pgcrypto/Makefile +# used by databases/postgresql91-plperl/Makefile +# used by databases/postgresql91-plpython/Makefile +# used by databases/postgresql91-pltcl/Makefile +# used by databases/postgresql91-server/Makefile +# used by databases/postgresql91-upgrade/Makefile +# +# 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 + +.include "../../databases/postgresql91/Makefile.mirrors" + +DISTNAME= postgresql-9.1.0 +CATEGORIES= databases +MASTER_SITES= ${PGSQL_MIRRORS:=source/v${PKGVERSION_NOREV}/} +EXTRACT_SUFX= .tar.bz2 + +MAINTAINER?= adam@NetBSD.org +HOMEPAGE= http://www.postgresql.org/ +LICENSE= postgresql-license + +CONFLICTS+= postgresql-[0-9]* +CONFLICTS+= postgresql[0-8][0-9]-* + +DISTINFO_FILE?= ${.CURDIR}/../../databases/postgresql91/distinfo +COMMON_FILESDIR?= ${.CURDIR}/../../databases/postgresql91/files +PATCHDIR?= ${.CURDIR}/../../databases/postgresql91/patches + +USE_PKGLOCALEDIR= yes +USE_TOOLS+= bison gmake lex msgfmt +PKG_SYSCONFSUBDIR= postgresql + +.include "../../mk/bsd.prefs.mk" + +PG_TEMPLATE.SunOS= solaris +PG_TEMPLATE.IRIX= irix5 +.if !defined(PG_TEMPLATE.${OPSYS}) +PG_TEMPLATE.${OPSYS}= ${LOWER_OPSYS} +.endif + +PG_DATA_DIR= ${PREFIX}/share/postgresql +PG_DOC_DIR= ${PREFIX}/share/doc/postgresql +PG_LOCALE_DIR= ${PREFIX}/${PKGLOCALEDIR}/locale +PG_ETC_DIR= ${PKG_SYSCONFDIR} + +GNU_CONFIGURE= yes +CONFIGURE_ARGS+= --sysconfdir=${PG_ETC_DIR} +CONFIGURE_ARGS+= --datadir=${PG_DATA_DIR} +CONFIGURE_ARGS+= --localedir=${PG_LOCALE_DIR} +CONFIGURE_ARGS+= --with-docdir=${PG_DOC_DIR} +CONFIGURE_ARGS+= --with-template=${PG_TEMPLATE.${OPSYS}} + +CONFIGURE_ARGS+= --enable-nls +CONFIGURE_ARGS+= --without-perl +CONFIGURE_ARGS+= --without-python +CONFIGURE_ARGS+= --without-readline +CONFIGURE_ARGS+= --without-tcl +CONFIGURE_ARGS+= --without-zlib + +# PGSQL_BLCKSZ is the size in bytes of a PostgreSQL disk page or block. +# This also limits the size of a tuple. The valid values are powers +# of 2 up to 32768, and the default size is 8196. Please don't change +# this value unless you know what you are doing. +BUILD_DEFS+= PGSQL_BLCKSZ +.if defined(PGSQL_BLCKSZ) +CONFIGURE_ARGS+= --with-blocksize=${PGSQL_BLCKSZ} +.endif + +# PostgreSQL explicitly forbids any use of -ffast-math +BUILDLINK_TRANSFORM+= rm:-ffast-math + +# USE_LIBLTDL is "yes" or "no" depending on whether we're using libltdl +# to provide "dlopen" functionality for the PostgreSQL backend. +.if ${OPSYS} == "Interix" +USE_LIBLTDL?= yes +.endif +USE_LIBLTDL?= no + +.include "../../devel/gettext-lib/buildlink3.mk" + +.if !defined(META_PACKAGE) +post-extract: +. if !empty(USE_LIBLTDL:M[yY][eE][sS]) + cp -f ${COMMON_FILESDIR}/dynloader-ltdl.h \ + ${WRKSRC}/src/backend/port/dynloader/${PG_TEMPLATE.${OPSYS}:Q}.h + ${ECHO} "static int dummy = 0;" \ + > ${WRKSRC}/src/backend/port/dynloader/${PG_TEMPLATE.${OPSYS}:Q}.c +. endif + touch ${WRKSRC}/src/template/dragonfly + cp ${WRKSRC}/src/backend/port/dynloader/freebsd.c \ + ${WRKSRC}/src/backend/port/dynloader/dragonfly.c + cp ${WRKSRC}/src/backend/port/dynloader/freebsd.h \ + ${WRKSRC}/src/backend/port/dynloader/dragonfly.h + cp ${WRKSRC}/src/include/port/freebsd.h \ + ${WRKSRC}/src/include/port/dragonfly.h + cp ${WRKSRC}/src/makefiles/Makefile.freebsd \ + ${WRKSRC}/src/makefiles/Makefile.dragonfly +.endif + +.include "../../databases/postgresql91/options.mk" diff --git a/databases/postgresql91/Makefile.mirrors b/databases/postgresql91/Makefile.mirrors new file mode 100644 index 00000000000..19e0e7972fc --- /dev/null +++ b/databases/postgresql91/Makefile.mirrors @@ -0,0 +1,85 @@ +# $NetBSD: Makefile.mirrors,v 1.1.1.1 2011/09/15 08:27:38 adam Exp $ +# +# This Makefile fragment contains the mirror sites for fetching PostgreSQL. +# +# To fetch from the nearest mirror, you may need to set +# PGSQL_MIRRORS_SORT appropriately, e.g.: +# +# PGSQL_MIRRORS_SORT= .at .de +# + +### +### This list was last updated on 20100328. +### +PGSQL_MIRRORS= \ + ftp://ftp5.ca.postgresql.org/mirrors/postgresql/ \ + http://ftp2.cz.postgresql.org/pub/postgresql/ \ + ftp://ftp2.cz.postgresql.org/pub/postgresql/ \ + http://ftp.dk.postgresql.org/postgresql/ \ + ftp://ftp.dk.postgresql.org/postgresql/ \ + http://ftp.ee.postgresql.org/pub/postgresql/ \ + ftp://ftp.fi.postgresql.org/pub/postgresql/ \ + http://ftp4.fr.postgresql.org/pub/mirrors/postgresql/ \ + ftp://ftp4.fr.postgresql.org/pub/mirrors/postgresql/ \ + http://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org/ \ + ftp://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org/ \ + http://ftp8.de.postgresql.org/pub/misc/pgsql/ \ + ftp://ftp8.de.postgresql.org/pub/misc/pgsql/ \ + ftp://ftp7.de.postgresql.org/pub/ftp.postgresql.org/ \ + ftp://ftp9.de.postgresql.org/unix/databases/postgresql/ \ + ftp://ftp10.de.postgresql.org/pub/mirror/postgresql/ \ + http://ftp.gr.postgresql.org/pub/databases/postgresql/ \ + ftp://ftp.gr.postgresql.org/pub/databases/postgresql/ \ + http://ftp3.gr.postgresql.org/ \ + ftp://ftp3.gr.postgresql.org/mirrors/postgresql/ \ + http://ftp.ie.postgresql.org/mirrors/ftp.postgresql.org/pub/ \ + ftp://ftp.ie.postgresql.org/mirrors/ftp.postgresql.org/pub/ \ + http://ftp2.ie.postgresql.org/mirrors/ftp.postgresql.org/ \ + ftp://ftp2.ie.postgresql.org/mirrors/ftp.postgresql.org/ \ + http://ftp2.it.postgresql.org/mirrors/postgres/ \ + ftp://ftp2.it.postgresql.org/mirrors/postgres/ \ + ftp://ftp3.jp.postgresql.org/pub/db/postgresql/ \ + ftp://ftp2.kr.postgresql.org/pub/postgresql/ \ + ftp://ftp.lv.postgresql.org/mirrors/ftp.postgresql.org/ \ + http://ftp2.nl.postgresql.org/ \ + ftp://ftp2.nl.postgresql.org/mirror/postgresql/ \ + ftp://ftp.nl.postgresql.org:21/pub/mirror/postgresql/ \ + ftp://ftp.nz.postgresql.org/postgresql/ \ + http://ftp6.pl.postgresql.org/pub/postgresql/ \ + ftp://ftp6.pl.postgresql.org/pub/postgresql/ \ + http://ftp8.pl.postgresql.org/pub/postgresql/ \ + ftp://ftp8.pl.postgresql.org/pub/postgresql/ \ + http://ftp9.pl.postgresql.org/pub/mirrors/ftp.postgresql.org/ \ + ftp://ftp9.pl.postgresql.org/pub/mirrors/ftp.postgresql.org/ \ + ftp://ftp7.pl.postgresql.org/pub/mirror/ftp.postgresql.org/ \ + http://ftp.pt.postgresql.org/pub/postgresql/ \ + ftp://ftp.pt.postgresql.org/pub/postgresql/ \ + ftp://ftp6.ro.postgresql.org/pub/mirrors/ftp.postgresql.org/ \ + ftp://ftp2.ru.postgresql.org/pub/databases/postgresql/ \ + ftp://ftp3.ru.postgresql.org/pub/mirror/postgresql/pub/ \ + ftp://ftp.si.postgresql.org/pub/mirrors/postgresql/ \ + ftp://ftp.za.postgresql.org/mirror/ftp.postgresql.org/ \ + http://ftp.se.postgresql.org/pub/databases/relational/postgresql/ \ + ftp://ftp.se.postgresql.org/pub/databases/relational/postgresql/ \ + http://ftp2.ch.postgresql.org/pub/mirrors/postgresql/ \ + ftp://ftp2.ch.postgresql.org/pub/mirrors/postgresql/ \ + ftp://ftp.ch.postgresql.org/mirror/postgresql/ \ + http://ftp3.tw.postgresql.org/postgresql/ \ + ftp://ftp3.tw.postgresql.org/postgresql/ \ + http://ftp9.us.postgresql.org/pub/mirrors/postgresql/ \ + ftp://ftp9.us.postgresql.org/pub/mirrors/postgresql/ \ + ftp://ftp5.us.postgresql.org/pub/PostgreSQL/ \ + ftp://ftp10.us.postgresql.org/pub/postgresql/ \ + ftp://ftp3.ua.postgresql.org/pub/mirrors/postgresql/ \ + http://ftp2.uk.postgresql.org/sites/ftp.postgresql.org/ \ + ftp://ftp2.uk.postgresql.org/sites/ftp.postgresql.org/ + +# Default to fetching from a .us mirror for the sake of the main NetBSD +# ftp server. +# +PGSQL_MIRRORS_SORT?= .de + +# Craft a MASTER_SORT_REGEX that understands the location of the country +# code in the FTP server name for the PostgreSQL mirror sites. +# +MASTER_SORT_REGEX+= ${PGSQL_MIRRORS_SORT:S/./\\./g:C/.*/:\/\/[^[\/]*&\/ :\/\/[^\/]*&\\./} diff --git a/databases/postgresql91/PLIST b/databases/postgresql91/PLIST new file mode 100644 index 00000000000..6e3b260bf00 --- /dev/null +++ b/databases/postgresql91/PLIST @@ -0,0 +1,2 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2011/09/15 08:27:39 adam Exp $ +@comment this plist intentionally left empty diff --git a/databases/postgresql91/distinfo b/databases/postgresql91/distinfo new file mode 100644 index 00000000000..c685fffe6c9 --- /dev/null +++ b/databases/postgresql91/distinfo @@ -0,0 +1,16 @@ +$NetBSD: distinfo,v 1.1.1.1 2011/09/15 08:27:38 adam Exp $ + +SHA1 (postgresql-9.1.0.tar.bz2) = 25d4999b587fb4e85ed4b541967c5c2d52354ba1 +RMD160 (postgresql-9.1.0.tar.bz2) = c943430b98b5dac8296fa5b937ef85e03dee08c5 +Size (postgresql-9.1.0.tar.bz2) = 14788869 bytes +SHA1 (patch-config_perl.m4) = c7e5aaff1c47d2e33df7692a412ef984c77ffcc0 +SHA1 (patch-configure) = dab79533dac06a79a5aa8439d6b15830d8d2fba7 +SHA1 (patch-contrib_dblink_Makefile) = 4960ad57d42465fae203870548e4c53f8a32ce04 +SHA1 (patch-contrib_dblink_dblink.c) = 4d7c40d107d4c13c63ef2908d9a02be319863657 +SHA1 (patch-src_Makefile.shlib) = 39c9d8fa983658fd609a7879cbe46c95aabb8011 +SHA1 (patch-src_backend_Makefile) = 76ddd3015d93b19cdd6000eaffc4f53cbd4965b5 +SHA1 (patch-src_pl_plperl_GNUmakefile) = 6f8b7842f9e3016932f47b90ba6011a2015b8a05 +SHA1 (patch-src_timezone_localtime.c) = a73769cf05223d2ee06249c9e69c85038c2cd936 +SHA1 (patch-src_timezone_private.h) = 85dac95e40efc16270885087f868aeb76e1b9214 +SHA1 (patch-src_timezone_strftime.c) = 25102dce1b9b22385353af23500636fb18e3bf64 +SHA1 (patch-src_timezone_zic.c) = 0d6f536f7593e362ec216eafa73c718ad6bed8fc diff --git a/databases/postgresql91/files/GNUmakefile.libpq b/databases/postgresql91/files/GNUmakefile.libpq new file mode 100644 index 00000000000..be6504adaf4 --- /dev/null +++ b/databases/postgresql91/files/GNUmakefile.libpq @@ -0,0 +1,20 @@ +# $NetBSD: GNUmakefile.libpq,v 1.1.1.1 2011/09/15 08:27:39 adam 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/postgresql91/files/dynloader-ltdl.h b/databases/postgresql91/files/dynloader-ltdl.h new file mode 100644 index 00000000000..8a0ea5002df --- /dev/null +++ b/databases/postgresql91/files/dynloader-ltdl.h @@ -0,0 +1,17 @@ +/* $NetBSD: dynloader-ltdl.h,v 1.1.1.1 2011/09/15 08:27:39 adam Exp $ */ + +/* + * dynamic loader based on libltdl + */ +#ifndef PORT_PROTOS_H +#define PORT_PROTOS_H + +#include <ltdl.h> +#include "utils/dynamic_loader.h" + +#define pg_dlopen(a) ((void *)lt_dlopen(a)) +#define pg_dlsym(a,b) lt_dlsym((lt_dlhandle)(a), (b)) +#define pg_dlclose(a) lt_dlclose((lt_dlhandle)(a)) +#define pg_dlerror lt_dlerror + +#endif /* PORT_PROTOS_H */ diff --git a/databases/postgresql91/options.mk b/databases/postgresql91/options.mk new file mode 100644 index 00000000000..d06b7cfb1cc --- /dev/null +++ b/databases/postgresql91/options.mk @@ -0,0 +1,56 @@ +# $NetBSD: options.mk,v 1.1.1.1 2011/09/15 08:27:39 adam Exp $ + +PKG_OPTIONS_VAR= PKG_OPTIONS.postgresql91 +PKG_SUPPORTED_OPTIONS= bonjour gssapi kerberos ldap pam xml + +.include "../../mk/bsd.options.mk" + +### +### Bonjour support. +### +.if !empty(PKG_OPTIONS:Mbonjour) +CONFIGURE_ARGS+= --with-bonjour +. if ${OPSYS} != "Darwin" +LIBS+= -ldns_sd +. endif +. include "../../net/mDNSResponder/buildlink3.mk" +.endif + +### +### GSSAPI authentication for the PostgreSQL backend. +### +.if !empty(PKG_OPTIONS:Mgssapi) +CONFIGURE_ARGS+= --with-gssapi +.endif + +### +### Kerberos5 authentication for the PostgreSQL backend. +### +.if !empty(PKG_OPTIONS:Mkerberos) +. include "../../mk/krb5.buildlink3.mk" +CONFIGURE_ARGS+= --with-krb5 +.endif + +### +### LDAP authentication for the PostgreSQL backend. +### +.if !empty(PKG_OPTIONS:Mldap) +. include "../../databases/openldap-client/buildlink3.mk" +CONFIGURE_ARGS+= --with-ldap +.endif + +### +### PAM authentication for the PostgreSQL backend. +### +.if !empty(PKG_OPTIONS:Mpam) +. include "../../mk/pam.buildlink3.mk" +CONFIGURE_ARGS+= --with-pam +.endif + +### +### XML support for the PostgreSQL backend. +### +.if !empty(PKG_OPTIONS:Mxml) +. include "../../textproc/libxml2/buildlink3.mk" +CONFIGURE_ARGS+= --with-libxml +.endif diff --git a/databases/postgresql91/patches/patch-config_perl.m4 b/databases/postgresql91/patches/patch-config_perl.m4 new file mode 100644 index 00000000000..08b82f94132 --- /dev/null +++ b/databases/postgresql91/patches/patch-config_perl.m4 @@ -0,0 +1,15 @@ +$NetBSD: patch-config_perl.m4,v 1.1.1.1 2011/09/15 08:27:39 adam Exp $ + +--- config/perl.m4.orig 2010-02-23 18:35:06.000000000 +0000 ++++ config/perl.m4 +@@ -57,9 +57,7 @@ AC_DEFUN([PGAC_CHECK_PERL_CONFIGS], + AC_DEFUN([PGAC_CHECK_PERL_EMBED_LDFLAGS], + [AC_REQUIRE([PGAC_PATH_PERL]) + AC_MSG_CHECKING(for flags to link embedded Perl) +-pgac_tmp1=`$PERL -MExtUtils::Embed -e ldopts` +-pgac_tmp2=`$PERL -MConfig -e 'print $Config{ccdlflags}'` +-perl_embed_ldflags=`echo X"$pgac_tmp1" | sed -e "s/^X//" -e "s%$pgac_tmp2%%" -e ["s/ -arch [-a-zA-Z0-9_]*//g"]` ++perl_embed_ldflags=`$PERL -MExtUtils::Embed -e ldopts` + AC_SUBST(perl_embed_ldflags)dnl + if test -z "$perl_embed_ldflags" ; then + AC_MSG_RESULT(no) diff --git a/databases/postgresql91/patches/patch-configure b/databases/postgresql91/patches/patch-configure new file mode 100644 index 00000000000..6041d94d29a --- /dev/null +++ b/databases/postgresql91/patches/patch-configure @@ -0,0 +1,23 @@ +$NetBSD: patch-configure,v 1.1.1.1 2011/09/15 08:27:39 adam Exp $ + +--- configure.orig 2011-06-09 23:40:42.000000000 +0000 ++++ configure +@@ -2196,6 +2196,7 @@ case $host_os in + dragonfly*) template=netbsd ;; + dgux*) template=dgux ;; + freebsd*) template=freebsd ;; ++ dragonfly*) template=dragonfly ;; + hpux*) template=hpux ;; + irix*) template=irix ;; + linux*|gnu*|k*bsd*-gnu) +@@ -7157,9 +7158,7 @@ $as_echo "$perl_useshrplib" >&6; } + + { $as_echo "$as_me:$LINENO: checking for flags to link embedded Perl" >&5 + $as_echo_n "checking for flags to link embedded Perl... " >&6; } +-pgac_tmp1=`$PERL -MExtUtils::Embed -e ldopts` +-pgac_tmp2=`$PERL -MConfig -e 'print $Config{ccdlflags}'` +-perl_embed_ldflags=`echo X"$pgac_tmp1" | sed -e "s/^X//" -e "s%$pgac_tmp2%%" -e "s/ -arch [-a-zA-Z0-9_]*//g"` ++perl_embed_ldflags=`$PERL -MExtUtils::Embed -e ldopts` + if test -z "$perl_embed_ldflags" ; then + { $as_echo "$as_me:$LINENO: result: no" >&5 + $as_echo "no" >&6; } diff --git a/databases/postgresql91/patches/patch-contrib_dblink_Makefile b/databases/postgresql91/patches/patch-contrib_dblink_Makefile new file mode 100644 index 00000000000..b20d4c0dc9b --- /dev/null +++ b/databases/postgresql91/patches/patch-contrib_dblink_Makefile @@ -0,0 +1,12 @@ +$NetBSD: patch-contrib_dblink_Makefile,v 1.1.1.1 2011/09/15 08:27:39 adam Exp $ + +--- contrib/dblink/Makefile.orig 2011-09-15 06:35:28.000000000 +0000 ++++ contrib/dblink/Makefile +@@ -4,7 +4,6 @@ MODULE_big = dblink + OBJS = dblink.o + PG_CPPFLAGS = -I$(libpq_srcdir) + SHLIB_LINK = $(libpq) +-SHLIB_PREREQS = submake-libpq + + EXTENSION = dblink + DATA = dblink--1.0.sql dblink--unpackaged--1.0.sql diff --git a/databases/postgresql91/patches/patch-contrib_dblink_dblink.c b/databases/postgresql91/patches/patch-contrib_dblink_dblink.c new file mode 100644 index 00000000000..778be34520c --- /dev/null +++ b/databases/postgresql91/patches/patch-contrib_dblink_dblink.c @@ -0,0 +1,13 @@ +$NetBSD: patch-contrib_dblink_dblink.c,v 1.1.1.1 2011/09/15 08:27:39 adam Exp $ + +--- contrib/dblink/dblink.c.orig 2010-07-06 19:18:54.000000000 +0000 ++++ contrib/dblink/dblink.c +@@ -59,7 +59,7 @@ + #include "utils/array.h" + #include "utils/builtins.h" + #include "utils/dynahash.h" +-#include "utils/fmgroids.h" ++#include "postgresql/server/utils/fmgroids.h" + #include "utils/hsearch.h" + #include "utils/lsyscache.h" + #include "utils/memutils.h" diff --git a/databases/postgresql91/patches/patch-src_Makefile.shlib b/databases/postgresql91/patches/patch-src_Makefile.shlib new file mode 100644 index 00000000000..832399e0aeb --- /dev/null +++ b/databases/postgresql91/patches/patch-src_Makefile.shlib @@ -0,0 +1,24 @@ +$NetBSD: patch-src_Makefile.shlib,v 1.1.1.1 2011/09/15 08:27:39 adam Exp $ + +Properly define the linker on DragonFly BSD. + +--- src/Makefile.shlib.orig 2011-01-28 02:21:31 +0000 ++++ src/Makefile.shlib +@@ -198,6 +198,17 @@ ifeq ($(PORTNAME), netbsd) + endif + endif + ++ifeq ($(PORTNAME), dragonfly) ++ ifdef ELF_SYSTEM ++ LINK.shared = $(COMPILER) -shared ++ ifdef soname ++ LINK.shared += -Wl,-x,-soname,$(soname) ++ endif ++ else ++ LINK.shared = $(LD) -x -Bshareable -Bforcearchive ++ endif ++endif ++ + ifeq ($(PORTNAME), hpux) + ifdef SO_MAJOR_VERSION + shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION) diff --git a/databases/postgresql91/patches/patch-src_backend_Makefile b/databases/postgresql91/patches/patch-src_backend_Makefile new file mode 100644 index 00000000000..6aa393d9baa --- /dev/null +++ b/databases/postgresql91/patches/patch-src_backend_Makefile @@ -0,0 +1,15 @@ +$NetBSD: patch-src_backend_Makefile,v 1.1.1.1 2011/09/15 08:27:39 adam Exp $ + +--- src/backend/Makefile.orig 2010-07-05 18:54:37.000000000 +0000 ++++ src/backend/Makefile +@@ -17,6 +17,10 @@ subdir = src/backend + top_builddir = ../.. + include $(top_builddir)/src/Makefile.global + ++CFLAGS+= $(DL_CFLAGS) ++LDFLAGS+= $(DL_LDFLAGS) ++LIBS+= $(DL_LIBS) ++ + SUBDIRS = access bootstrap catalog parser commands executor foreign lib libpq \ + main nodes optimizer port postmaster regex replication rewrite \ + storage tcop tsearch utils $(top_builddir)/src/timezone diff --git a/databases/postgresql91/patches/patch-src_pl_plperl_GNUmakefile b/databases/postgresql91/patches/patch-src_pl_plperl_GNUmakefile new file mode 100644 index 00000000000..f3c618b496a --- /dev/null +++ b/databases/postgresql91/patches/patch-src_pl_plperl_GNUmakefile @@ -0,0 +1,21 @@ +$NetBSD: patch-src_pl_plperl_GNUmakefile,v 1.1.1.1 2011/09/15 08:27:39 adam Exp $ + +--- src/pl/plperl/GNUmakefile.orig 2011-09-08 21:13:27.000000000 +0000 ++++ src/pl/plperl/GNUmakefile +@@ -57,7 +57,6 @@ PSQLDIR = $(bindir) + + include $(top_srcdir)/src/Makefile.shlib + +-plperl.o: perlchunks.h plperl_opmask.h + + plperl_opmask.h: plperl_opmask.pl + @if [ x"$(perl_privlibexp)" = x"" ]; then echo "configure switch --with-perl was not specified."; exit 1; fi +@@ -67,7 +66,7 @@ perlchunks.h: $(PERLCHUNKS) + @if [ x"$(perl_privlibexp)" = x"" ]; then echo "configure switch --with-perl was not specified."; exit 1; fi + $(PERL) $(srcdir)/text2macro.pl --strip='^(\#.*|\s*)$$' $^ > $@ + +-all: all-lib ++all: perlchunks.h plperl_opmask.h all-lib + + SPI.c: SPI.xs + @if [ x"$(perl_privlibexp)" = x"" ]; then echo "configure switch --with-perl was not specified."; exit 1; fi diff --git a/databases/postgresql91/patches/patch-src_timezone_localtime.c b/databases/postgresql91/patches/patch-src_timezone_localtime.c new file mode 100644 index 00000000000..eea6dc38c3b --- /dev/null +++ b/databases/postgresql91/patches/patch-src_timezone_localtime.c @@ -0,0 +1,31 @@ +$NetBSD: patch-src_timezone_localtime.c,v 1.1.1.1 2011/09/15 08:27:39 adam Exp $ + +--- src/timezone/localtime.c.orig 2009-06-11 16:49:15.000000000 +0200 ++++ src/timezone/localtime.c +@@ -80,20 +80,20 @@ static pg_time_t detzcode64(const char * + static int differ_by_repeat(pg_time_t t1, pg_time_t t0); + static const char *getzname(const char *strp); + static const char *getqzname(const char *strp, int delim); +-static const char *getnum(const char *strp, int *nump, int min, int max); ++static const char *getnum(const char *strp, int *nump, const int min, const int max); + static const char *getsecs(const char *strp, long *secsp); + static const char *getoffset(const char *strp, long *offsetp); + static const char *getrule(const char *strp, struct rule * rulep); + static void gmtload(struct state * sp); +-static struct pg_tm *gmtsub(const pg_time_t *timep, long offset, ++static struct pg_tm *gmtsub(const pg_time_t *timep, const long offset, + struct pg_tm * tmp); +-static struct pg_tm *localsub(const pg_time_t *timep, long offset, ++static struct pg_tm *localsub(const pg_time_t *timep, const long offset, + struct pg_tm * tmp, const pg_tz *tz); + static int increment_overflow(int *number, int delta); +-static pg_time_t transtime(pg_time_t janfirst, int year, +- const struct rule * rulep, long offset); ++static pg_time_t transtime(pg_time_t janfirst, const int year, ++ const struct rule * rulep, const long offset); + static int typesequiv(const struct state * sp, int a, int b); +-static struct pg_tm *timesub(const pg_time_t *timep, long offset, ++static struct pg_tm *timesub(const pg_time_t *timep, const long offset, + const struct state * sp, struct pg_tm * tmp); + + /* GMT timezone */ diff --git a/databases/postgresql91/patches/patch-src_timezone_private.h b/databases/postgresql91/patches/patch-src_timezone_private.h new file mode 100644 index 00000000000..45f458b5afb --- /dev/null +++ b/databases/postgresql91/patches/patch-src_timezone_private.h @@ -0,0 +1,15 @@ +$NetBSD: patch-src_timezone_private.h,v 1.1.1.1 2011/09/15 08:27:39 adam Exp $ + +--- src/timezone/private.h.orig 2009-06-11 16:49:15.000000000 +0200 ++++ src/timezone/private.h +@@ -51,8 +51,8 @@ extern int unlink(const char *filename); + extern char *icalloc(int nelem, int elsize); + extern char *icatalloc(char *old, const char *new); + extern char *icpyalloc(const char *string); +-extern char *imalloc(int n); +-extern void *irealloc(void *pointer, int size); ++extern char *imalloc(const int n); ++extern void *irealloc(void *pointer, const int size); + extern void icfree(char *pointer); + extern void ifree(char *pointer); + extern const char *scheck(const char *string, const char *format); diff --git a/databases/postgresql91/patches/patch-src_timezone_strftime.c b/databases/postgresql91/patches/patch-src_timezone_strftime.c new file mode 100644 index 00000000000..11cbbca0070 --- /dev/null +++ b/databases/postgresql91/patches/patch-src_timezone_strftime.c @@ -0,0 +1,13 @@ +$NetBSD: patch-src_timezone_strftime.c,v 1.1.1.1 2011/09/15 08:27:39 adam Exp $ + +--- src/timezone/strftime.c.orig 2009-06-11 16:49:15.000000000 +0200 ++++ src/timezone/strftime.c +@@ -89,7 +89,7 @@ static const struct lc_time_T C_time_loc + }; + + static char *_add(const char *, char *, const char *); +-static char *_conv(int, const char *, char *, const char *); ++static char *_conv(const int, const char *, char *, const char *); + static char *_fmt(const char *, const struct pg_tm *, char *, + const char *, int *); + static char *_yconv(const int, const int, const int, const int, diff --git a/databases/postgresql91/patches/patch-src_timezone_zic.c b/databases/postgresql91/patches/patch-src_timezone_zic.c new file mode 100644 index 00000000000..5a5286d1397 --- /dev/null +++ b/databases/postgresql91/patches/patch-src_timezone_zic.c @@ -0,0 +1,78 @@ +$NetBSD: patch-src_timezone_zic.c,v 1.1.1.1 2011/09/15 08:27:39 adam Exp $ + +--- src/timezone/zic.c.orig 2010-03-16 07:17:04.000000000 +0000 ++++ src/timezone/zic.c +@@ -120,51 +120,51 @@ struct zone + + extern int link(const char *fromname, const char *toname); + static void addtt(const pg_time_t starttime, int type); +-static int addtype(long gmtoff, const char *abbr, int isdst, +- int ttisstd, int ttisgmt); +-static void leapadd(const pg_time_t t, int positive, int rolling, int count); ++static int addtype(const long gmtoff, const char *abbr, const int isdst, ++ const int ttisstd, const int ttisgmt); ++static void leapadd(const pg_time_t t, const int positive, const int rolling, int count); + static void adjleap(void); + static void associate(void); + static int ciequal(const char *ap, const char *bp); +-static void convert(long val, char *buf); ++static void convert(const long val, char *buf); + static void dolink(const char *fromfile, const char *tofile); + static void doabbr(char *abbr, const char *format, +- const char *letters, int isdst, int doquotes); +-static void eat(const char *name, int num); +-static void eats(const char *name, int num, +- const char *rname, int rnum); +-static long eitol(int i); ++ const char *letters, const int isdst, int doquotes); ++static void eat(const char *name, const int num); ++static void eats(const char *name, const int num, ++ const char *rname, const int rnum); ++static long eitol(const int i); + static void error(const char *message); + static char **getfields(char *buf); + static long gethms(const char *string, const char *errstrng, +- int signable); ++ const int signable); + static void infile(const char *filename); +-static void inleap(char **fields, int nfields); +-static void inlink(char **fields, int nfields); +-static void inrule(char **fields, int nfields); +-static int inzcont(char **fields, int nfields); +-static int inzone(char **fields, int nfields); +-static int inzsub(char **fields, int nfields, int iscont); ++static void inleap(char **fields, const int nfields); ++static void inlink(char **fields, const int nfields); ++static void inrule(char **fields, const int nfields); ++static int inzcont(char **fields, const int nfields); ++static int inzone(char **fields, const int nfields); ++static int inzsub(char **fields, const int nfields, const int iscont); + static int itsabbr(const char *abbr, const char *word); + static int itsdir(const char *name); + static int lowerit(int c); + static char *memcheck(char *tocheck); + static int mkdirs(char *filename); + static void newabbr(const char *abbr); +-static long oadd(long t1, long t2); +-static void outzone(const struct zone * zp, int ntzones); +-static void puttzcode(long code, FILE *fp); ++static long oadd(const long t1, const long t2); ++static void outzone(const struct zone * zp, const int ntzones); ++static void puttzcode(const long code, FILE *fp); + static int rcomp(const void *leftp, const void *rightp); +-static pg_time_t rpytime(const struct rule * rp, int wantedy); ++static pg_time_t rpytime(const struct rule * rp, const int wantedy); + static void rulesub(struct rule * rp, + const char *loyearp, const char *hiyearp, + const char *typep, const char *monthp, + const char *dayp, const char *timep); + static void setboundaries(void); +-static pg_time_t tadd(const pg_time_t t1, long t2); ++static pg_time_t tadd(const pg_time_t t1, const long t2); + static void usage(FILE *stream, int status); + static void writezone(const char *name, const char *string); +-static int yearistype(int year, const char *type); ++static int yearistype(const int year, const char *type); + + static int charcnt; + static int errors; |