diff options
author | adam <adam@pkgsrc.org> | 2012-10-05 21:03:10 +0000 |
---|---|---|
committer | adam <adam@pkgsrc.org> | 2012-10-05 21:03:10 +0000 |
commit | 1eaecc91a6487eb01ff8834fabc93e1effa5c79c (patch) | |
tree | a69a2fb35b4ccb1bbdfd5c01ee1680b59a18ac99 /databases | |
parent | 9bab063ade445a4461fc908a988bfcc747aac47c (diff) | |
download | pkgsrc-1eaecc91a6487eb01ff8834fabc93e1effa5c79c.tar.gz |
The PostgreSQL Global Development Group announces PostgreSQL 9.2, the latest release of the leader in open source databases. Since the beta release was announced in May, developers and vendors have praised it as a leap forward in performance, scalability and flexibility. Users are expected to switch to this version in record numbers.
PostgreSQL 9.2 will ship with native JSON support, covering indexes, replication and performance improvements, and many more features. We are eagerly awaiting this release and will make it available in Early Access as soon as it’s released by the PostgreSQL community," said Ines Sombra, Lead Data Engineer, Engine Yard.
Diffstat (limited to 'databases')
72 files changed, 4273 insertions, 0 deletions
diff --git a/databases/postgresql92-adminpack/DESCR b/databases/postgresql92-adminpack/DESCR new file mode 100644 index 00000000000..69453f2b72c --- /dev/null +++ b/databases/postgresql92-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/postgresql92-adminpack/Makefile b/databases/postgresql92-adminpack/Makefile new file mode 100644 index 00000000000..c41c4efe3bd --- /dev/null +++ b/databases/postgresql92-adminpack/Makefile @@ -0,0 +1,15 @@ +# $NetBSD: Makefile,v 1.1 2012/10/05 21:03:10 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/92-adminpack-/} +COMMENT= Admin pack module for pgAdmin management + +DEPENDS+= postgresql92-server>=${PKGVERSION_NOREV}:../../databases/postgresql92-server + +.include "../../databases/postgresql92/Makefile.common" + +BUILD_MAKE_FLAGS= PGXS=1 + +BUILD_DIRS= contrib/adminpack + +.include "../../databases/postgresql92-client/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql92-adminpack/PLIST b/databases/postgresql92-adminpack/PLIST new file mode 100644 index 00000000000..e6e84c1cf7f --- /dev/null +++ b/databases/postgresql92-adminpack/PLIST @@ -0,0 +1,4 @@ +@comment $NetBSD: PLIST,v 1.1 2012/10/05 21:03:10 adam Exp $ +lib/postgresql/adminpack.so +share/postgresql/extension/adminpack--1.0.sql +share/postgresql/extension/adminpack.control diff --git a/databases/postgresql92-client/DESCR b/databases/postgresql92-client/DESCR new file mode 100644 index 00000000000..a485664e6f1 --- /dev/null +++ b/databases/postgresql92-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/postgresql92-client/Makefile b/databases/postgresql92-client/Makefile new file mode 100644 index 00000000000..88b273dd7bc --- /dev/null +++ b/databases/postgresql92-client/Makefile @@ -0,0 +1,83 @@ +# $NetBSD: Makefile,v 1.1 2012/10/05 21:03:10 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/92-client-/} +COMMENT= PostgreSQL database client programs + +.include "../../databases/postgresql92/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 + +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,${TOOLS_CMD.bison},${TOOLS_PATH.bison},' +SUBST_SED.pgxs+= -e 's,${TOOLS_CMD.lex},${TOOLS_PATH.lex},' +SUBST_SED.pgxs+= -e 's,${TOOLS_CMD.mkdir},${TOOLS_PATH.mkdir},' +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/postgresql92-client/PLIST b/databases/postgresql92-client/PLIST new file mode 100644 index 00000000000..ce72ca3a167 --- /dev/null +++ b/databases/postgresql92-client/PLIST @@ -0,0 +1,705 @@ +@comment $NetBSD: PLIST,v 1.1 2012/10/05 21:03:10 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_receivexlog +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/spgist.h +include/postgresql/server/access/spgist_private.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_range.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_shseclabel.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/createas.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/datatype/timestamp.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/nodeIndexonlyscan.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/cygwin.h +include/postgresql/server/port/darwin.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/openbsd.h +include/postgresql/server/port/osf.h +include/postgresql/server/port/sco.h +include/postgresql/server/port/solaris.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/startup.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/replication/walsender_private.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/barrier.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/json.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_crc_tables.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/rangetypes.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/reltrigger.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/sortsupport.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.a +lib/libecpg.so +lib/libecpg.so.6 +lib/libecpg.so.6.4 +lib/libecpg_compat.a +lib/libecpg_compat.so +lib/libecpg_compat.so.3 +lib/libecpg_compat.so.3.4 +lib/libpgport.a +lib/libpgtypes.a +lib/libpgtypes.so +lib/libpgtypes.so.3 +lib/libpgtypes.so.3.3 +lib/libpq.a +lib/libpq.so +lib/libpq.so.5 +lib/libpq.so.5.5 +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.2.mo +share/locale/cs/LC_MESSAGES/ecpglib6-9.2.mo +share/locale/cs/LC_MESSAGES/initdb-9.2.mo +share/locale/cs/LC_MESSAGES/libpq5-9.2.mo +share/locale/cs/LC_MESSAGES/pg_config-9.2.mo +share/locale/cs/LC_MESSAGES/pg_ctl-9.2.mo +share/locale/cs/LC_MESSAGES/pg_resetxlog-9.2.mo +share/locale/cs/LC_MESSAGES/pgscripts-9.2.mo +share/locale/cs/LC_MESSAGES/psql-9.2.mo +share/locale/de/LC_MESSAGES/ecpg-9.2.mo +share/locale/de/LC_MESSAGES/ecpglib6-9.2.mo +share/locale/de/LC_MESSAGES/initdb-9.2.mo +share/locale/de/LC_MESSAGES/libpq5-9.2.mo +share/locale/de/LC_MESSAGES/pg_basebackup-9.2.mo +share/locale/de/LC_MESSAGES/pg_config-9.2.mo +share/locale/de/LC_MESSAGES/pg_controldata-9.2.mo +share/locale/de/LC_MESSAGES/pg_ctl-9.2.mo +share/locale/de/LC_MESSAGES/pg_dump-9.2.mo +share/locale/de/LC_MESSAGES/pg_resetxlog-9.2.mo +share/locale/de/LC_MESSAGES/pgscripts-9.2.mo +share/locale/de/LC_MESSAGES/psql-9.2.mo +share/locale/es/LC_MESSAGES/ecpg-9.2.mo +share/locale/es/LC_MESSAGES/ecpglib6-9.2.mo +share/locale/es/LC_MESSAGES/initdb-9.2.mo +share/locale/es/LC_MESSAGES/libpq5-9.2.mo +share/locale/es/LC_MESSAGES/pg_basebackup-9.2.mo +share/locale/es/LC_MESSAGES/pg_config-9.2.mo +share/locale/es/LC_MESSAGES/pg_controldata-9.2.mo +share/locale/es/LC_MESSAGES/pg_ctl-9.2.mo +share/locale/es/LC_MESSAGES/pg_dump-9.2.mo +share/locale/es/LC_MESSAGES/pg_resetxlog-9.2.mo +share/locale/es/LC_MESSAGES/pgscripts-9.2.mo +share/locale/es/LC_MESSAGES/psql-9.2.mo +share/locale/fr/LC_MESSAGES/ecpg-9.2.mo +share/locale/fr/LC_MESSAGES/ecpglib6-9.2.mo +share/locale/fr/LC_MESSAGES/initdb-9.2.mo +share/locale/fr/LC_MESSAGES/libpq5-9.2.mo +share/locale/fr/LC_MESSAGES/pg_basebackup-9.2.mo +share/locale/fr/LC_MESSAGES/pg_config-9.2.mo +share/locale/fr/LC_MESSAGES/pg_controldata-9.2.mo +share/locale/fr/LC_MESSAGES/pg_ctl-9.2.mo +share/locale/fr/LC_MESSAGES/pg_dump-9.2.mo +share/locale/fr/LC_MESSAGES/pg_resetxlog-9.2.mo +share/locale/fr/LC_MESSAGES/pgscripts-9.2.mo +share/locale/fr/LC_MESSAGES/psql-9.2.mo +share/locale/it/LC_MESSAGES/ecpg-9.2.mo +share/locale/it/LC_MESSAGES/ecpglib6-9.2.mo +share/locale/it/LC_MESSAGES/initdb-9.2.mo +share/locale/it/LC_MESSAGES/pg_config-9.2.mo +share/locale/it/LC_MESSAGES/pg_resetxlog-9.2.mo +share/locale/it/LC_MESSAGES/pgscripts-9.2.mo +share/locale/it/LC_MESSAGES/psql-9.2.mo +share/locale/ja/LC_MESSAGES/ecpg-9.2.mo +share/locale/ja/LC_MESSAGES/ecpglib6-9.2.mo +share/locale/ja/LC_MESSAGES/initdb-9.2.mo +share/locale/ja/LC_MESSAGES/libpq5-9.2.mo +share/locale/ja/LC_MESSAGES/pg_basebackup-9.2.mo +share/locale/ja/LC_MESSAGES/pg_config-9.2.mo +share/locale/ja/LC_MESSAGES/pg_controldata-9.2.mo +share/locale/ja/LC_MESSAGES/pg_ctl-9.2.mo +share/locale/ja/LC_MESSAGES/pg_dump-9.2.mo +share/locale/ja/LC_MESSAGES/pg_resetxlog-9.2.mo +share/locale/ja/LC_MESSAGES/pgscripts-9.2.mo +share/locale/ja/LC_MESSAGES/psql-9.2.mo +share/locale/ko/LC_MESSAGES/ecpg-9.2.mo +share/locale/ko/LC_MESSAGES/initdb-9.2.mo +share/locale/ko/LC_MESSAGES/pg_config-9.2.mo +share/locale/ko/LC_MESSAGES/pg_resetxlog-9.2.mo +share/locale/ko/LC_MESSAGES/pgscripts-9.2.mo +share/locale/nb/LC_MESSAGES/pg_config-9.2.mo +share/locale/pl/LC_MESSAGES/ecpg-9.2.mo +share/locale/pl/LC_MESSAGES/ecpglib6-9.2.mo +share/locale/pl/LC_MESSAGES/initdb-9.2.mo +share/locale/pl/LC_MESSAGES/libpq5-9.2.mo +share/locale/pl/LC_MESSAGES/pg_config-9.2.mo +share/locale/pl/LC_MESSAGES/pg_controldata-9.2.mo +share/locale/pl/LC_MESSAGES/pg_ctl-9.2.mo +share/locale/pl/LC_MESSAGES/pg_resetxlog-9.2.mo +share/locale/pl/LC_MESSAGES/pgscripts-9.2.mo +share/locale/pl/LC_MESSAGES/psql-9.2.mo +share/locale/pt_BR/LC_MESSAGES/ecpg-9.2.mo +share/locale/pt_BR/LC_MESSAGES/ecpglib6-9.2.mo +share/locale/pt_BR/LC_MESSAGES/initdb-9.2.mo +share/locale/pt_BR/LC_MESSAGES/libpq5-9.2.mo +share/locale/pt_BR/LC_MESSAGES/pg_config-9.2.mo +share/locale/pt_BR/LC_MESSAGES/pg_controldata-9.2.mo +share/locale/pt_BR/LC_MESSAGES/pg_ctl-9.2.mo +share/locale/pt_BR/LC_MESSAGES/pg_resetxlog-9.2.mo +share/locale/pt_BR/LC_MESSAGES/pgscripts-9.2.mo +share/locale/pt_BR/LC_MESSAGES/psql-9.2.mo +share/locale/ro/LC_MESSAGES/initdb-9.2.mo +share/locale/ro/LC_MESSAGES/pg_config-9.2.mo +share/locale/ro/LC_MESSAGES/pg_controldata-9.2.mo +share/locale/ro/LC_MESSAGES/pg_resetxlog-9.2.mo +share/locale/ro/LC_MESSAGES/pgscripts-9.2.mo +share/locale/ru/LC_MESSAGES/ecpg-9.2.mo +share/locale/ru/LC_MESSAGES/ecpglib6-9.2.mo +share/locale/ru/LC_MESSAGES/initdb-9.2.mo +share/locale/ru/LC_MESSAGES/libpq5-9.2.mo +share/locale/ru/LC_MESSAGES/pg_basebackup-9.2.mo +share/locale/ru/LC_MESSAGES/pg_config-9.2.mo +share/locale/ru/LC_MESSAGES/pg_controldata-9.2.mo +share/locale/ru/LC_MESSAGES/pg_ctl-9.2.mo +share/locale/ru/LC_MESSAGES/pg_dump-9.2.mo +share/locale/ru/LC_MESSAGES/pg_resetxlog-9.2.mo +share/locale/ru/LC_MESSAGES/pgscripts-9.2.mo +share/locale/ru/LC_MESSAGES/psql-9.2.mo +share/locale/sv/LC_MESSAGES/initdb-9.2.mo +share/locale/sv/LC_MESSAGES/pg_config-9.2.mo +share/locale/sv/LC_MESSAGES/pgscripts-9.2.mo +share/locale/ta/LC_MESSAGES/pg_config-9.2.mo +share/locale/tr/LC_MESSAGES/ecpg-9.2.mo +share/locale/tr/LC_MESSAGES/ecpglib6-9.2.mo +share/locale/tr/LC_MESSAGES/initdb-9.2.mo +share/locale/tr/LC_MESSAGES/libpq5-9.2.mo +share/locale/tr/LC_MESSAGES/pg_config-9.2.mo +share/locale/tr/LC_MESSAGES/pg_controldata-9.2.mo +share/locale/tr/LC_MESSAGES/pg_resetxlog-9.2.mo +share/locale/tr/LC_MESSAGES/pgscripts-9.2.mo +share/locale/zh_CN/LC_MESSAGES/ecpg-9.2.mo +share/locale/zh_CN/LC_MESSAGES/ecpglib6-9.2.mo +share/locale/zh_CN/LC_MESSAGES/initdb-9.2.mo +share/locale/zh_CN/LC_MESSAGES/libpq5-9.2.mo +share/locale/zh_CN/LC_MESSAGES/pg_config-9.2.mo +share/locale/zh_CN/LC_MESSAGES/pg_controldata-9.2.mo +share/locale/zh_CN/LC_MESSAGES/pg_resetxlog-9.2.mo +share/locale/zh_CN/LC_MESSAGES/pgscripts-9.2.mo +share/locale/zh_CN/LC_MESSAGES/psql-9.2.mo +share/locale/zh_TW/LC_MESSAGES/ecpg-9.2.mo +share/locale/zh_TW/LC_MESSAGES/initdb-9.2.mo +share/locale/zh_TW/LC_MESSAGES/libpq5-9.2.mo +share/locale/zh_TW/LC_MESSAGES/pg_config-9.2.mo +share/locale/zh_TW/LC_MESSAGES/pg_controldata-9.2.mo +share/locale/zh_TW/LC_MESSAGES/pg_ctl-9.2.mo +share/locale/zh_TW/LC_MESSAGES/pg_resetxlog-9.2.mo +share/locale/zh_TW/LC_MESSAGES/pgscripts-9.2.mo +share/locale/zh_TW/LC_MESSAGES/psql-9.2.mo +share/postgresql/pg_service.conf.sample +share/postgresql/psqlrc.sample diff --git a/databases/postgresql92-client/buildlink3.mk b/databases/postgresql92-client/buildlink3.mk new file mode 100644 index 00000000000..7385513a837 --- /dev/null +++ b/databases/postgresql92-client/buildlink3.mk @@ -0,0 +1,21 @@ +# $NetBSD: buildlink3.mk,v 1.1 2012/10/05 21:03:10 adam Exp $ + +BUILDLINK_TREE+= postgresql92-client + +.if !defined(POSTGRESQL92_CLIENT_BUILDLINK3_MK) +POSTGRESQL92_CLIENT_BUILDLINK3_MK:= + +BUILDLINK_API_DEPENDS.postgresql92-client+= postgresql92-client>=9.2.0 +BUILDLINK_ABI_DEPENDS.postgresql92-client+= postgresql92-client>=9.2.0 +BUILDLINK_PKGSRCDIR.postgresql92-client?= ../../databases/postgresql92-client + +# This variable contains the libraries need to link most clients. +BUILDLINK_LDADD.postgresql92-client= -lpq ${BUILDLINK_LDADD.gettext} +BUILDLINK_FILES.postgresql92-client+= bin/pg_config + +.include "../../devel/gettext-lib/buildlink3.mk" +.include "../../devel/zlib/buildlink3.mk" +.include "../../security/openssl/buildlink3.mk" +.endif # POSTGRESQL92_CLIENT_BUILDLINK3_MK + +BUILDLINK_TREE+= -postgresql92-client diff --git a/databases/postgresql92-datatypes/DESCR b/databases/postgresql92-datatypes/DESCR new file mode 100644 index 00000000000..0fd1fb2d6cd --- /dev/null +++ b/databases/postgresql92-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/postgresql92-datatypes/Makefile b/databases/postgresql92-datatypes/Makefile new file mode 100644 index 00000000000..94d76673246 --- /dev/null +++ b/databases/postgresql92-datatypes/Makefile @@ -0,0 +1,26 @@ +# $NetBSD: Makefile,v 1.1 2012/10/05 21:03:10 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/92-datatypes-/} +COMMENT= PostgreSQL data types support modules + +DEPENDS+= postgresql92-server>=${PKGVERSION_NOREV}:../../databases/postgresql92-server + +.include "../../databases/postgresql92/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/postgresql92-client/buildlink3.mk" +.include "../../devel/ossp-uuid/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql92-datatypes/PLIST b/databases/postgresql92-datatypes/PLIST new file mode 100644 index 00000000000..98515c8cfda --- /dev/null +++ b/databases/postgresql92-datatypes/PLIST @@ -0,0 +1,35 @@ +@comment $NetBSD: PLIST,v 1.1 2012/10/05 21:03:10 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--1.1.sql +share/postgresql/extension/hstore--1.1.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/postgresql92-dblink/DESCR b/databases/postgresql92-dblink/DESCR new file mode 100644 index 00000000000..d6641c1971b --- /dev/null +++ b/databases/postgresql92-dblink/DESCR @@ -0,0 +1,2 @@ +The ``dblink'' PostgreSQL contrib module to connect to remote database +servers. diff --git a/databases/postgresql92-dblink/Makefile b/databases/postgresql92-dblink/Makefile new file mode 100644 index 00000000000..3ced27f4f26 --- /dev/null +++ b/databases/postgresql92-dblink/Makefile @@ -0,0 +1,16 @@ +# $NetBSD: Makefile,v 1.1 2012/10/05 21:03:11 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/92-dblink-/} +COMMENT= Dblink module for remote database connections + +DEPENDS+= postgresql92-server>=${PKGVERSION_NOREV}:../../databases/postgresql92-server + +.include "../../databases/postgresql92/Makefile.common" + +CONFIGURE_ARGS+= --with-openssl +BUILD_MAKE_FLAGS= PGXS=1 + +BUILD_DIRS= contrib/dblink + +.include "../../databases/postgresql92-client/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql92-dblink/PLIST b/databases/postgresql92-dblink/PLIST new file mode 100644 index 00000000000..225e762a738 --- /dev/null +++ b/databases/postgresql92-dblink/PLIST @@ -0,0 +1,5 @@ +@comment $NetBSD: PLIST,v 1.1 2012/10/05 21:03:11 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/postgresql92-docs/DESCR b/databases/postgresql92-docs/DESCR new file mode 100644 index 00000000000..89dd99e91c2 --- /dev/null +++ b/databases/postgresql92-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/postgresql92-docs/Makefile b/databases/postgresql92-docs/Makefile new file mode 100644 index 00000000000..532079b3510 --- /dev/null +++ b/databases/postgresql92-docs/Makefile @@ -0,0 +1,21 @@ +# $NetBSD: Makefile,v 1.1 2012/10/05 21:03:11 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/92-docs-/} +COMMENT= PostgreSQL database documentation + +.include "../../databases/postgresql92/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/postgresql92-docs/PLIST b/databases/postgresql92-docs/PLIST new file mode 100644 index 00000000000..7dcc90ef284 --- /dev/null +++ b/databases/postgresql92-docs/PLIST @@ -0,0 +1,1398 @@ +@comment $NetBSD: PLIST,v 1.1 2012/10/05 21:03:11 adam Exp $ +man/man1/clusterdb.1 +man/man1/createdb.1 +man/man1/createlang.1 +man/man1/createuser.1 +man/man1/dropdb.1 +man/man1/droplang.1 +man/man1/dropuser.1 +man/man1/ecpg.1 +man/man1/initdb.1 +man/man1/oid2name.1 +man/man1/pg_archivecleanup.1 +man/man1/pg_basebackup.1 +man/man1/pg_config.1 +man/man1/pg_controldata.1 +man/man1/pg_ctl.1 +man/man1/pg_dump.1 +man/man1/pg_dumpall.1 +man/man1/pg_receivexlog.1 +man/man1/pg_resetxlog.1 +man/man1/pg_restore.1 +man/man1/pg_standby.1 +man/man1/pg_test_fsync.1 +man/man1/pg_test_timing.1 +man/man1/pg_upgrade.1 +man/man1/pgbench.1 +man/man1/postgres.1 +man/man1/postmaster.1 +man/man1/psql.1 +man/man1/reindexdb.1 +man/man1/vacuumdb.1 +man/man1/vacuumlo.1 +man/man3/SPI_connect.3 +man/man3/SPI_copytuple.3 +man/man3/SPI_cursor_close.3 +man/man3/SPI_cursor_fetch.3 +man/man3/SPI_cursor_find.3 +man/man3/SPI_cursor_move.3 +man/man3/SPI_cursor_open.3 +man/man3/SPI_cursor_open_with_args.3 +man/man3/SPI_cursor_open_with_paramlist.3 +man/man3/SPI_exec.3 +man/man3/SPI_execp.3 +man/man3/SPI_execute.3 +man/man3/SPI_execute_plan.3 +man/man3/SPI_execute_plan_with_paramlist.3 +man/man3/SPI_execute_with_args.3 +man/man3/SPI_finish.3 +man/man3/SPI_fname.3 +man/man3/SPI_fnumber.3 +man/man3/SPI_freeplan.3 +man/man3/SPI_freetuple.3 +man/man3/SPI_freetuptable.3 +man/man3/SPI_getargcount.3 +man/man3/SPI_getargtypeid.3 +man/man3/SPI_getbinval.3 +man/man3/SPI_getnspname.3 +man/man3/SPI_getrelname.3 +man/man3/SPI_gettype.3 +man/man3/SPI_gettypeid.3 +man/man3/SPI_getvalue.3 +man/man3/SPI_is_cursor_plan.3 +man/man3/SPI_keepplan.3 +man/man3/SPI_modifytuple.3 +man/man3/SPI_palloc.3 +man/man3/SPI_pfree.3 +man/man3/SPI_pop.3 +man/man3/SPI_prepare.3 +man/man3/SPI_prepare_cursor.3 +man/man3/SPI_prepare_params.3 +man/man3/SPI_push.3 +man/man3/SPI_repalloc.3 +man/man3/SPI_returntuple.3 +man/man3/SPI_saveplan.3 +man/man3/SPI_scroll_cursor_fetch.3 +man/man3/SPI_scroll_cursor_move.3 +man/man3/dblink.3 +man/man3/dblink_build_sql_delete.3 +man/man3/dblink_build_sql_insert.3 +man/man3/dblink_build_sql_update.3 +man/man3/dblink_cancel_query.3 +man/man3/dblink_close.3 +man/man3/dblink_connect.3 +man/man3/dblink_connect_u.3 +man/man3/dblink_disconnect.3 +man/man3/dblink_error_message.3 +man/man3/dblink_exec.3 +man/man3/dblink_fetch.3 +man/man3/dblink_get_connections.3 +man/man3/dblink_get_notify.3 +man/man3/dblink_get_pkey.3 +man/man3/dblink_get_result.3 +man/man3/dblink_is_busy.3 +man/man3/dblink_open.3 +man/man3/dblink_send_query.3 +man/man7/ABORT.7 +man/man7/ALTER_AGGREGATE.7 +man/man7/ALTER_COLLATION.7 +man/man7/ALTER_CONVERSION.7 +man/man7/ALTER_DATABASE.7 +man/man7/ALTER_DEFAULT_PRIVILEGES.7 +man/man7/ALTER_DOMAIN.7 +man/man7/ALTER_EXTENSION.7 +man/man7/ALTER_FOREIGN_DATA_WRAPPER.7 +man/man7/ALTER_FOREIGN_TABLE.7 +man/man7/ALTER_FUNCTION.7 +man/man7/ALTER_GROUP.7 +man/man7/ALTER_INDEX.7 +man/man7/ALTER_LANGUAGE.7 +man/man7/ALTER_LARGE_OBJECT.7 +man/man7/ALTER_OPERATOR.7 +man/man7/ALTER_OPERATOR_CLASS.7 +man/man7/ALTER_OPERATOR_FAMILY.7 +man/man7/ALTER_ROLE.7 +man/man7/ALTER_SCHEMA.7 +man/man7/ALTER_SEQUENCE.7 +man/man7/ALTER_SERVER.7 +man/man7/ALTER_TABLE.7 +man/man7/ALTER_TABLESPACE.7 +man/man7/ALTER_TEXT_SEARCH_CONFIGURATION.7 +man/man7/ALTER_TEXT_SEARCH_DICTIONARY.7 +man/man7/ALTER_TEXT_SEARCH_PARSER.7 +man/man7/ALTER_TEXT_SEARCH_TEMPLATE.7 +man/man7/ALTER_TRIGGER.7 +man/man7/ALTER_TYPE.7 +man/man7/ALTER_USER.7 +man/man7/ALTER_USER_MAPPING.7 +man/man7/ALTER_VIEW.7 +man/man7/ANALYZE.7 +man/man7/BEGIN.7 +man/man7/CHECKPOINT.7 +man/man7/CLOSE.7 +man/man7/CLUSTER.7 +man/man7/COMMENT.7 +man/man7/COMMIT.7 +man/man7/COMMIT_PREPARED.7 +man/man7/COPY.7 +man/man7/CREATE_AGGREGATE.7 +man/man7/CREATE_CAST.7 +man/man7/CREATE_COLLATION.7 +man/man7/CREATE_CONVERSION.7 +man/man7/CREATE_DATABASE.7 +man/man7/CREATE_DOMAIN.7 +man/man7/CREATE_EXTENSION.7 +man/man7/CREATE_FOREIGN_DATA_WRAPPER.7 +man/man7/CREATE_FOREIGN_TABLE.7 +man/man7/CREATE_FUNCTION.7 +man/man7/CREATE_GROUP.7 +man/man7/CREATE_INDEX.7 +man/man7/CREATE_LANGUAGE.7 +man/man7/CREATE_OPERATOR.7 +man/man7/CREATE_OPERATOR_CLASS.7 +man/man7/CREATE_OPERATOR_FAMILY.7 +man/man7/CREATE_ROLE.7 +man/man7/CREATE_RULE.7 +man/man7/CREATE_SCHEMA.7 +man/man7/CREATE_SEQUENCE.7 +man/man7/CREATE_SERVER.7 +man/man7/CREATE_TABLE.7 +man/man7/CREATE_TABLESPACE.7 +man/man7/CREATE_TABLE_AS.7 +man/man7/CREATE_TEXT_SEARCH_CONFIGURATION.7 +man/man7/CREATE_TEXT_SEARCH_DICTIONARY.7 +man/man7/CREATE_TEXT_SEARCH_PARSER.7 +man/man7/CREATE_TEXT_SEARCH_TEMPLATE.7 +man/man7/CREATE_TRIGGER.7 +man/man7/CREATE_TYPE.7 +man/man7/CREATE_USER.7 +man/man7/CREATE_USER_MAPPING.7 +man/man7/CREATE_VIEW.7 +man/man7/DEALLOCATE.7 +man/man7/DECLARE.7 +man/man7/DELETE.7 +man/man7/DISCARD.7 +man/man7/DO.7 +man/man7/DROP_AGGREGATE.7 +man/man7/DROP_CAST.7 +man/man7/DROP_COLLATION.7 +man/man7/DROP_CONVERSION.7 +man/man7/DROP_DATABASE.7 +man/man7/DROP_DOMAIN.7 +man/man7/DROP_EXTENSION.7 +man/man7/DROP_FOREIGN_DATA_WRAPPER.7 +man/man7/DROP_FOREIGN_TABLE.7 +man/man7/DROP_FUNCTION.7 +man/man7/DROP_GROUP.7 +man/man7/DROP_INDEX.7 +man/man7/DROP_LANGUAGE.7 +man/man7/DROP_OPERATOR.7 +man/man7/DROP_OPERATOR_CLASS.7 +man/man7/DROP_OPERATOR_FAMILY.7 +man/man7/DROP_OWNED.7 +man/man7/DROP_ROLE.7 +man/man7/DROP_RULE.7 +man/man7/DROP_SCHEMA.7 +man/man7/DROP_SEQUENCE.7 +man/man7/DROP_SERVER.7 +man/man7/DROP_TABLE.7 +man/man7/DROP_TABLESPACE.7 +man/man7/DROP_TEXT_SEARCH_CONFIGURATION.7 +man/man7/DROP_TEXT_SEARCH_DICTIONARY.7 +man/man7/DROP_TEXT_SEARCH_PARSER.7 +man/man7/DROP_TEXT_SEARCH_TEMPLATE.7 +man/man7/DROP_TRIGGER.7 +man/man7/DROP_TYPE.7 +man/man7/DROP_USER.7 +man/man7/DROP_USER_MAPPING.7 +man/man7/DROP_VIEW.7 +man/man7/END.7 +man/man7/EXECUTE.7 +man/man7/EXPLAIN.7 +man/man7/FETCH.7 +man/man7/GRANT.7 +man/man7/INSERT.7 +man/man7/LISTEN.7 +man/man7/LOAD.7 +man/man7/LOCK.7 +man/man7/MOVE.7 +man/man7/NOTIFY.7 +man/man7/PREPARE.7 +man/man7/PREPARE_TRANSACTION.7 +man/man7/REASSIGN_OWNED.7 +man/man7/REINDEX.7 +man/man7/RELEASE_SAVEPOINT.7 +man/man7/RESET.7 +man/man7/REVOKE.7 +man/man7/ROLLBACK.7 +man/man7/ROLLBACK_PREPARED.7 +man/man7/ROLLBACK_TO_SAVEPOINT.7 +man/man7/SAVEPOINT.7 +man/man7/SECURITY_LABEL.7 +man/man7/SELECT.7 +man/man7/SELECT_INTO.7 +man/man7/SET.7 +man/man7/SET_CONSTRAINTS.7 +man/man7/SET_ROLE.7 +man/man7/SET_SESSION_AUTHORIZATION.7 +man/man7/SET_TRANSACTION.7 +man/man7/SHOW.7 +man/man7/START_TRANSACTION.7 +man/man7/TABLE.7 +man/man7/TRUNCATE.7 +man/man7/UNLISTEN.7 +man/man7/UPDATE.7 +man/man7/VACUUM.7 +man/man7/VALUES.7 +man/man7/WITH.7 +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-pgreceivexlog.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-range.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-shseclabel.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-prog-client.html +share/doc/postgresql/html/contrib-prog-server.html +share/doc/postgresql/html/contrib-prog.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-json.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/event-log-registration.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/fdw-helpers.html +share/doc/postgresql/html/fdw-planning.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-json.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-range.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-options.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-udt-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-udt-privileges.html +share/doc/postgresql/html/infoschema-usage-privileges.html +share/doc/postgresql/html/infoschema-user-defined-types.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-single-row-mode.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/pgtesttiming.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/rangetypes.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-22.html +share/doc/postgresql/html/release-8-2-23.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-16.html +share/doc/postgresql/html/release-8-3-17.html +share/doc/postgresql/html/release-8-3-18.html +share/doc/postgresql/html/release-8-3-19.html +share/doc/postgresql/html/release-8-3-2.html +share/doc/postgresql/html/release-8-3-20.html +share/doc/postgresql/html/release-8-3-21.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-10.html +share/doc/postgresql/html/release-8-4-11.html +share/doc/postgresql/html/release-8-4-12.html +share/doc/postgresql/html/release-8-4-13.html +share/doc/postgresql/html/release-8-4-14.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-9.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-10.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-5.html +share/doc/postgresql/html/release-9-0-6.html +share/doc/postgresql/html/release-9-0-7.html +share/doc/postgresql/html/release-9-0-8.html +share/doc/postgresql/html/release-9-0-9.html +share/doc/postgresql/html/release-9-0.html +share/doc/postgresql/html/release-9-1-1.html +share/doc/postgresql/html/release-9-1-2.html +share/doc/postgresql/html/release-9-1-3.html +share/doc/postgresql/html/release-9-1-4.html +share/doc/postgresql/html/release-9-1-5.html +share/doc/postgresql/html/release-9-1-6.html +share/doc/postgresql/html/release-9-1.html +share/doc/postgresql/html/release-9-2-1.html +share/doc/postgresql/html/release-9-2.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/spgist-examples.html +share/doc/postgresql/html/spgist-extensibility.html +share/doc/postgresql/html/spgist-implementation.html +share/doc/postgresql/html/spgist-intro.html +share/doc/postgresql/html/spgist.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-keepplan.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/tcn.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/postgresql92-fuzzystrmatch/DESCR b/databases/postgresql92-fuzzystrmatch/DESCR new file mode 100644 index 00000000000..98051db50c1 --- /dev/null +++ b/databases/postgresql92-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/postgresql92-fuzzystrmatch/MESSAGE b/databases/postgresql92-fuzzystrmatch/MESSAGE new file mode 100644 index 00000000000..ff4b897889c --- /dev/null +++ b/databases/postgresql92-fuzzystrmatch/MESSAGE @@ -0,0 +1,8 @@ +=========================================================================== +$NetBSD: MESSAGE,v 1.1 2012/10/05 21:03:11 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/postgresql92-fuzzystrmatch/Makefile b/databases/postgresql92-fuzzystrmatch/Makefile new file mode 100644 index 00000000000..f5b44d681d1 --- /dev/null +++ b/databases/postgresql92-fuzzystrmatch/Makefile @@ -0,0 +1,15 @@ +# $NetBSD: Makefile,v 1.1 2012/10/05 21:03:11 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/92-fuzzystrmatch-/} +COMMENT= PostgreSQL fuzzystrmatch contribution + +DEPENDS+= postgresql92-server>=${PKGVERSION_NOREV}:../../databases/postgresql92-server + +.include "../../databases/postgresql92/Makefile.common" + +BUILD_MAKE_FLAGS= USE_PGXS=1 + +BUILD_DIRS= contrib/fuzzystrmatch + +.include "../../databases/postgresql92-client/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql92-fuzzystrmatch/PLIST b/databases/postgresql92-fuzzystrmatch/PLIST new file mode 100644 index 00000000000..8bfc194d2fd --- /dev/null +++ b/databases/postgresql92-fuzzystrmatch/PLIST @@ -0,0 +1,5 @@ +@comment $NetBSD: PLIST,v 1.1 2012/10/05 21:03:11 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/postgresql92-monitoring/DESCR b/databases/postgresql92-monitoring/DESCR new file mode 100644 index 00000000000..a7d6d0fd016 --- /dev/null +++ b/databases/postgresql92-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/postgresql92-monitoring/Makefile b/databases/postgresql92-monitoring/Makefile new file mode 100644 index 00000000000..f738f26d8cf --- /dev/null +++ b/databases/postgresql92-monitoring/Makefile @@ -0,0 +1,18 @@ +# $NetBSD: Makefile,v 1.1 2012/10/05 21:03:11 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/92-monitoring-/} +COMMENT= PostgreSQL monitoring tools + +DEPENDS+= postgresql92-server>=${PKGVERSION_NOREV}:../../databases/postgresql92-server + +.include "../../databases/postgresql92/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/postgresql92-client/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql92-monitoring/PLIST b/databases/postgresql92-monitoring/PLIST new file mode 100644 index 00000000000..120e55812c1 --- /dev/null +++ b/databases/postgresql92-monitoring/PLIST @@ -0,0 +1,15 @@ +@comment $NetBSD: PLIST,v 1.1 2012/10/05 21:03:11 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--1.1.sql +share/postgresql/extension/pg_stat_statements--1.1.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/postgresql92-pgcrypto/DESCR b/databases/postgresql92-pgcrypto/DESCR new file mode 100644 index 00000000000..3ce89d05b9d --- /dev/null +++ b/databases/postgresql92-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/postgresql92-pgcrypto/Makefile b/databases/postgresql92-pgcrypto/Makefile new file mode 100644 index 00000000000..ff277756aa5 --- /dev/null +++ b/databases/postgresql92-pgcrypto/Makefile @@ -0,0 +1,16 @@ +# $NetBSD: Makefile,v 1.1 2012/10/05 21:03:11 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/92-pgcrypto-/} +COMMENT= Module providing cryptographic functions for PostgreSQL + +DEPENDS+= postgresql92-server>=${PKGVERSION_NOREV}:../../databases/postgresql92-server + +.include "../../databases/postgresql92/Makefile.common" + +CONFIGURE_ARGS+= --with-zlib +BUILD_MAKE_FLAGS= PGXS=1 + +BUILD_DIRS= contrib/pgcrypto + +.include "../../databases/postgresql92-client/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql92-pgcrypto/PLIST b/databases/postgresql92-pgcrypto/PLIST new file mode 100644 index 00000000000..d123c584cfd --- /dev/null +++ b/databases/postgresql92-pgcrypto/PLIST @@ -0,0 +1,5 @@ +@comment $NetBSD: PLIST,v 1.1 2012/10/05 21:03:11 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/postgresql92-plperl/DESCR b/databases/postgresql92-plperl/DESCR new file mode 100644 index 00000000000..9057591c0ba --- /dev/null +++ b/databases/postgresql92-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/postgresql92-plperl/MESSAGE b/databases/postgresql92-plperl/MESSAGE new file mode 100644 index 00000000000..3b44d194c0f --- /dev/null +++ b/databases/postgresql92-plperl/MESSAGE @@ -0,0 +1,7 @@ +=========================================================================== +$NetBSD: MESSAGE,v 1.1 2012/10/05 21:03:11 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/postgresql92-plperl/Makefile b/databases/postgresql92-plperl/Makefile new file mode 100644 index 00000000000..61645ef794f --- /dev/null +++ b/databases/postgresql92-plperl/Makefile @@ -0,0 +1,20 @@ +# $NetBSD: Makefile,v 1.1 2012/10/05 21:03:11 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/92-plperl-/} +COMMENT= PL/Perl procedural language for the PostgreSQL backend + +DEPENDS+= postgresql92-server>=${PKGVERSION_NOREV}:../../databases/postgresql92-server + +.include "../../databases/postgresql92/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/postgresql92-client/buildlink3.mk" +.include "../../lang/perl5/module.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql92-plperl/PLIST b/databases/postgresql92-plperl/PLIST new file mode 100644 index 00000000000..17322770bc4 --- /dev/null +++ b/databases/postgresql92-plperl/PLIST @@ -0,0 +1,20 @@ +@comment $NetBSD: PLIST,v 1.1 2012/10/05 21:03:11 adam Exp $ +lib/postgresql/plperl.so +share/locale/cs/LC_MESSAGES/plperl-9.2.mo +share/locale/de/LC_MESSAGES/plperl-9.2.mo +share/locale/es/LC_MESSAGES/plperl-9.2.mo +share/locale/fr/LC_MESSAGES/plperl-9.2.mo +share/locale/ja/LC_MESSAGES/plperl-9.2.mo +share/locale/pl/LC_MESSAGES/plperl-9.2.mo +share/locale/pt_BR/LC_MESSAGES/plperl-9.2.mo +share/locale/ro/LC_MESSAGES/plperl-9.2.mo +share/locale/ru/LC_MESSAGES/plperl-9.2.mo +share/locale/tr/LC_MESSAGES/plperl-9.2.mo +share/locale/zh_CN/LC_MESSAGES/plperl-9.2.mo +share/locale/zh_TW/LC_MESSAGES/plperl-9.2.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/postgresql92-plpython/DESCR b/databases/postgresql92-plpython/DESCR new file mode 100644 index 00000000000..142bb15309d --- /dev/null +++ b/databases/postgresql92-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/postgresql92-plpython/MESSAGE b/databases/postgresql92-plpython/MESSAGE new file mode 100644 index 00000000000..ef8b4134cc9 --- /dev/null +++ b/databases/postgresql92-plpython/MESSAGE @@ -0,0 +1,17 @@ +=========================================================================== +$NetBSD: MESSAGE,v 1.1 2012/10/05 21:03:11 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/postgresql92-plpython/Makefile b/databases/postgresql92-plpython/Makefile new file mode 100644 index 00000000000..ab34d6b4d8c --- /dev/null +++ b/databases/postgresql92-plpython/Makefile @@ -0,0 +1,18 @@ +# $NetBSD: Makefile,v 1.1 2012/10/05 21:03:11 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/92-plpython-/} +COMMENT= PL/Python procedural language for the PostgreSQL backend + +DEPENDS+= postgresql92-server>=${PKGVERSION_NOREV}:../../databases/postgresql92-server + +.include "../../databases/postgresql92/Makefile.common" + +CONFIGURE_ARGS+= --with-python +CONFIGURE_ENV+= PYTHON="${PYTHONBIN}" +BUILD_MAKE_FLAGS= PGXS=1 + +BUILD_DIRS= src/pl/plpython + +.include "../../databases/postgresql92-client/buildlink3.mk" +.include "../../lang/python/extension.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql92-plpython/PLIST b/databases/postgresql92-plpython/PLIST new file mode 100644 index 00000000000..5d9ae5e5518 --- /dev/null +++ b/databases/postgresql92-plpython/PLIST @@ -0,0 +1,17 @@ +@comment $NetBSD: PLIST,v 1.1 2012/10/05 21:03:11 adam Exp $ +lib/postgresql/plpython2.so +share/locale/cs/LC_MESSAGES/plpython-9.2.mo +share/locale/de/LC_MESSAGES/plpython-9.2.mo +share/locale/es/LC_MESSAGES/plpython-9.2.mo +share/locale/fr/LC_MESSAGES/plpython-9.2.mo +share/locale/ja/LC_MESSAGES/plpython-9.2.mo +share/locale/pl/LC_MESSAGES/plpython-9.2.mo +share/locale/pt_BR/LC_MESSAGES/plpython-9.2.mo +share/locale/ro/LC_MESSAGES/plpython-9.2.mo +share/locale/ru/LC_MESSAGES/plpython-9.2.mo +share/postgresql/extension/plpython2u--1.0.sql +share/postgresql/extension/plpython2u--unpackaged--1.0.sql +share/postgresql/extension/plpython2u.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/postgresql92-pltcl/DESCR b/databases/postgresql92-pltcl/DESCR new file mode 100644 index 00000000000..e1aca2980b9 --- /dev/null +++ b/databases/postgresql92-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/postgresql92-pltcl/MESSAGE b/databases/postgresql92-pltcl/MESSAGE new file mode 100644 index 00000000000..667eba377fa --- /dev/null +++ b/databases/postgresql92-pltcl/MESSAGE @@ -0,0 +1,7 @@ +=========================================================================== +$NetBSD: MESSAGE,v 1.1 2012/10/05 21:03:11 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/postgresql92-pltcl/Makefile b/databases/postgresql92-pltcl/Makefile new file mode 100644 index 00000000000..dcb7d9d8450 --- /dev/null +++ b/databases/postgresql92-pltcl/Makefile @@ -0,0 +1,20 @@ +# $NetBSD: Makefile,v 1.1 2012/10/05 21:03:11 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/92-pltcl-/} +COMMENT= PL/Tcl procedural language for the PostgreSQL backend + +DEPENDS+= postgresql92-server>=${PKGVERSION_NOREV}:../../databases/postgresql92-server + +.include "../../databases/postgresql92/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/postgresql92-client/buildlink3.mk" +.include "../../lang/tcl/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql92-pltcl/PLIST b/databases/postgresql92-pltcl/PLIST new file mode 100644 index 00000000000..55fc5ca7b24 --- /dev/null +++ b/databases/postgresql92-pltcl/PLIST @@ -0,0 +1,25 @@ +@comment $NetBSD: PLIST,v 1.1 2012/10/05 21:03:11 adam Exp $ +bin/pltcl_delmod +bin/pltcl_listmod +bin/pltcl_loadmod +lib/postgresql/pltcl.so +share/locale/cs/LC_MESSAGES/pltcl-9.2.mo +share/locale/de/LC_MESSAGES/pltcl-9.2.mo +share/locale/es/LC_MESSAGES/pltcl-9.2.mo +share/locale/fr/LC_MESSAGES/pltcl-9.2.mo +share/locale/it/LC_MESSAGES/pltcl-9.2.mo +share/locale/ja/LC_MESSAGES/pltcl-9.2.mo +share/locale/pl/LC_MESSAGES/pltcl-9.2.mo +share/locale/pt_BR/LC_MESSAGES/pltcl-9.2.mo +share/locale/ro/LC_MESSAGES/pltcl-9.2.mo +share/locale/ru/LC_MESSAGES/pltcl-9.2.mo +share/locale/tr/LC_MESSAGES/pltcl-9.2.mo +share/locale/zh_CN/LC_MESSAGES/pltcl-9.2.mo +share/locale/zh_TW/LC_MESSAGES/pltcl-9.2.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/postgresql92-replicationtools/DESCR b/databases/postgresql92-replicationtools/DESCR new file mode 100644 index 00000000000..781934b4da0 --- /dev/null +++ b/databases/postgresql92-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/postgresql92-replicationtools/Makefile b/databases/postgresql92-replicationtools/Makefile new file mode 100644 index 00000000000..71d6fe054c5 --- /dev/null +++ b/databases/postgresql92-replicationtools/Makefile @@ -0,0 +1,12 @@ +# $NetBSD: Makefile,v 1.1 2012/10/05 21:03:12 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/92-replicationtools-/} +COMMENT= PostgreSQL replication tools + +.include "../../databases/postgresql92/Makefile.common" + +BUILD_DIRS+= contrib/pg_archivecleanup +BUILD_DIRS+= contrib/pg_standby + +.include "../../databases/postgresql92-client/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql92-replicationtools/PLIST b/databases/postgresql92-replicationtools/PLIST new file mode 100644 index 00000000000..e189f7157d4 --- /dev/null +++ b/databases/postgresql92-replicationtools/PLIST @@ -0,0 +1,3 @@ +@comment $NetBSD: PLIST,v 1.1 2012/10/05 21:03:12 adam Exp $ +bin/pg_archivecleanup +bin/pg_standby diff --git a/databases/postgresql92-server/DEINSTALL b/databases/postgresql92-server/DEINSTALL new file mode 100644 index 00000000000..4d063930c19 --- /dev/null +++ b/databases/postgresql92-server/DEINSTALL @@ -0,0 +1,20 @@ +# $NetBSD: DEINSTALL,v 1.1 2012/10/05 21:03:12 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/postgresql92-server/DESCR b/databases/postgresql92-server/DESCR new file mode 100644 index 00000000000..68bb2b05748 --- /dev/null +++ b/databases/postgresql92-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/postgresql92-server/MESSAGE b/databases/postgresql92-server/MESSAGE new file mode 100644 index 00000000000..2068a1ab4c4 --- /dev/null +++ b/databases/postgresql92-server/MESSAGE @@ -0,0 +1,18 @@ +=========================================================================== +$NetBSD: MESSAGE,v 1.1 2012/10/05 21:03:12 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/postgresql92-server/Makefile b/databases/postgresql92-server/Makefile new file mode 100644 index 00000000000..71365f734b4 --- /dev/null +++ b/databases/postgresql92-server/Makefile @@ -0,0 +1,83 @@ +# $NetBSD: Makefile,v 1.1 2012/10/05 21:03:12 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/92-server-/} +COMMENT= PostgreSQL database server programs + +# mips has no TAS implementation +NOT_FOR_PLATFORM= *-*-mips + +.include "../../databases/postgresql92/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/postgresql92-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/postgresql92-server/PLIST b/databases/postgresql92-server/PLIST new file mode 100644 index 00000000000..39393fa0ef3 --- /dev/null +++ b/databases/postgresql92-server/PLIST @@ -0,0 +1,684 @@ +@comment $NetBSD: PLIST,v 1.1 2012/10/05 21:03:12 adam Exp $ +bin/postgres +bin/postmaster +include/postgresql/server/plpgsql.h +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.2.mo +share/locale/de/LC_MESSAGES/plpgsql-9.2.mo +share/locale/de/LC_MESSAGES/postgres-9.2.mo +share/locale/es/LC_MESSAGES/plpgsql-9.2.mo +share/locale/es/LC_MESSAGES/postgres-9.2.mo +share/locale/fr/LC_MESSAGES/plpgsql-9.2.mo +share/locale/fr/LC_MESSAGES/postgres-9.2.mo +share/locale/ja/LC_MESSAGES/plpgsql-9.2.mo +share/locale/ja/LC_MESSAGES/postgres-9.2.mo +share/locale/pl/LC_MESSAGES/plpgsql-9.2.mo +share/locale/pl/LC_MESSAGES/postgres-9.2.mo +share/locale/pt_BR/LC_MESSAGES/plpgsql-9.2.mo +share/locale/pt_BR/LC_MESSAGES/postgres-9.2.mo +share/locale/ro/LC_MESSAGES/plpgsql-9.2.mo +share/locale/ru/LC_MESSAGES/plpgsql-9.2.mo +share/locale/ru/LC_MESSAGES/postgres-9.2.mo +share/locale/zh_CN/LC_MESSAGES/plpgsql-9.2.mo +share/locale/zh_CN/LC_MESSAGES/postgres-9.2.mo +share/locale/zh_TW/LC_MESSAGES/plpgsql-9.2.mo +share/locale/zh_TW/LC_MESSAGES/postgres-9.2.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/Creston +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/Hebron +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/postgresql92-server/files/pgsql.sh b/databases/postgresql92-server/files/pgsql.sh new file mode 100644 index 00000000000..9a99f001e3a --- /dev/null +++ b/databases/postgresql92-server/files/pgsql.sh @@ -0,0 +1,130 @@ +#!@RCD_SCRIPTS_SHELL@ +# +# $NetBSD: pgsql.sh,v 1.1 2012/10/05 21:03:12 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/postgresql92-upgrade/DESCR b/databases/postgresql92-upgrade/DESCR new file mode 100644 index 00000000000..18267e4ba9a --- /dev/null +++ b/databases/postgresql92-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/postgresql92-upgrade/Makefile b/databases/postgresql92-upgrade/Makefile new file mode 100644 index 00000000000..7cc5529ab77 --- /dev/null +++ b/databases/postgresql92-upgrade/Makefile @@ -0,0 +1,19 @@ +# $NetBSD: Makefile,v 1.1 2012/10/05 21:03:12 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/92-upgrade-/} +COMMENT= PostgreSQL binary upgrade tool +MAINTAINER= pkgsrc-users@NetBSD.org + +DEPENDS+= postgresql92-server>=${PKGVERSION_NOREV}:../../databases/postgresql92-server + +.include "../../databases/postgresql92/Makefile.common" + +BUILD_MAKE_FLAGS= PGXS=1 + +BUILD_DIRS+= contrib/pg_upgrade +BUILD_DIRS+= contrib/pg_upgrade_support + +LIBS.SunOS+= -lintl + +.include "../../databases/postgresql92-client/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql92-upgrade/PLIST b/databases/postgresql92-upgrade/PLIST new file mode 100644 index 00000000000..f186b895d14 --- /dev/null +++ b/databases/postgresql92-upgrade/PLIST @@ -0,0 +1,3 @@ +@comment $NetBSD: PLIST,v 1.1 2012/10/05 21:03:12 adam Exp $ +bin/pg_upgrade +lib/postgresql/pg_upgrade_support.so diff --git a/databases/postgresql92/DESCR b/databases/postgresql92/DESCR new file mode 100644 index 00000000000..9f6b5b5b0f9 --- /dev/null +++ b/databases/postgresql92/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/postgresql92/Makefile b/databases/postgresql92/Makefile new file mode 100644 index 00000000000..778c03ebe90 --- /dev/null +++ b/databases/postgresql92/Makefile @@ -0,0 +1,14 @@ +# $NetBSD: Makefile,v 1.1 2012/10/05 21:03:10 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/92-/} +COMMENT= Robust, next generation, object-relational DBMS + +DEPENDS+= postgresql92-client>=${PKGVERSION_NOREV}:../../databases/postgresql92-client +DEPENDS+= postgresql92-docs>=${PKGVERSION_NOREV}:../../databases/postgresql92-docs +DEPENDS+= postgresql92-server>=${PKGVERSION_NOREV}:../../databases/postgresql92-server + +META_PACKAGE= yes + +.include "Makefile.common" + +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql92/Makefile.common b/databases/postgresql92/Makefile.common new file mode 100644 index 00000000000..71ca661df1e --- /dev/null +++ b/databases/postgresql92/Makefile.common @@ -0,0 +1,119 @@ +# $NetBSD: Makefile.common,v 1.1 2012/10/05 21:03:10 adam Exp $ +# +# used by databases/postgresql92-adminpack/Makefile +# used by databases/postgresql92-client/Makefile +# used by databases/postgresql92-datatypes/Makefile +# used by databases/postgresql92-dblink/Makefile +# used by databases/postgresql92-docs/Makefile +# used by databases/postgresql92-fuzzystrmatch/Makefile +# used by databases/postgresql92-pgcrypto/Makefile +# used by databases/postgresql92-plperl/Makefile +# used by databases/postgresql92-plpython/Makefile +# used by databases/postgresql92-pltcl/Makefile +# used by databases/postgresql92-server/Makefile +# used by databases/postgresql92-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 + +DISTNAME= postgresql-9.2.1 +CATEGORIES= databases +MASTER_SITES= ${MASTER_SITE_PGSQL:=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]-* +CONFLICTS+= postgresql9[013-9]-* + +DISTINFO_FILE?= ${.CURDIR}/../../databases/postgresql92/distinfo +COMMON_FILESDIR?= ${.CURDIR}/../../databases/postgresql92/files +PATCHDIR?= ${.CURDIR}/../../databases/postgresql92/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 + +# sys/ucred.h shouldn't be included on Solaris, causes conflicts between +# procfs and largefile. +.if ${OPSYS} == "SunOS" +CONFIGURE_ENV+= ac_cv_header_sys_ucred_h=no +.endif + +# 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" +LIBS.SunOS+= -lintl + +.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/postgresql92/options.mk" diff --git a/databases/postgresql92/PLIST b/databases/postgresql92/PLIST new file mode 100644 index 00000000000..615a190815b --- /dev/null +++ b/databases/postgresql92/PLIST @@ -0,0 +1,2 @@ +@comment $NetBSD: PLIST,v 1.1 2012/10/05 21:03:10 adam Exp $ +@comment this plist intentionally left empty diff --git a/databases/postgresql92/distinfo b/databases/postgresql92/distinfo new file mode 100644 index 00000000000..4e6168a4a9e --- /dev/null +++ b/databases/postgresql92/distinfo @@ -0,0 +1,19 @@ +$NetBSD: distinfo,v 1.1 2012/10/05 21:03:10 adam Exp $ + +SHA1 (postgresql-9.2.1.tar.bz2) = cea9601b3acd1484fd98441b49a15ea1c42057ec +RMD160 (postgresql-9.2.1.tar.bz2) = 8d80ca9dbf142f8f3b08d1c3a4cb03dd238fd9b3 +Size (postgresql-9.2.1.tar.bz2) = 16113737 bytes +SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813 +SHA1 (patch-config_perl.m4) = c7e5aaff1c47d2e33df7692a412ef984c77ffcc0 +SHA1 (patch-configure) = 21b27add570cff1a24c440201eb1ed49f8223747 +SHA1 (patch-contrib_dblink_Makefile) = 4960ad57d42465fae203870548e4c53f8a32ce04 +SHA1 (patch-contrib_dblink_dblink.c) = 0b867b256886765a6546c65e7e6a22795bd57218 +SHA1 (patch-src_Makefile.shlib) = fedf35f38439a724fa6522e1aaef110c9909866a +SHA1 (patch-src_backend_Makefile) = 76ddd3015d93b19cdd6000eaffc4f53cbd4965b5 +SHA1 (patch-src_makefiles_Makefile.solaris) = 0168f5bc105ffc89d5db40907a08966d8465f5a0 +SHA1 (patch-src_pl_plperl_GNUmakefile) = 2b7448d6dd8550e2ea61f40728a2780068b93d07 +SHA1 (patch-src_pl_plperl_plperl.h) = bd663fa80a47f7b82ce689060750fa6e631fbc61 +SHA1 (patch-src_timezone_localtime.c) = 622f57bc1d10f07ab73f86765cbf587eece57085 +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/postgresql92/files/GNUmakefile.libpq b/databases/postgresql92/files/GNUmakefile.libpq new file mode 100644 index 00000000000..328d0b313bf --- /dev/null +++ b/databases/postgresql92/files/GNUmakefile.libpq @@ -0,0 +1,20 @@ +# $NetBSD: GNUmakefile.libpq,v 1.1 2012/10/05 21:03:10 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/postgresql92/files/dynloader-ltdl.h b/databases/postgresql92/files/dynloader-ltdl.h new file mode 100644 index 00000000000..e8e46620033 --- /dev/null +++ b/databases/postgresql92/files/dynloader-ltdl.h @@ -0,0 +1,17 @@ +/* $NetBSD: dynloader-ltdl.h,v 1.1 2012/10/05 21:03:10 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/postgresql92/options.mk b/databases/postgresql92/options.mk new file mode 100644 index 00000000000..38a78d35905 --- /dev/null +++ b/databases/postgresql92/options.mk @@ -0,0 +1,63 @@ +# $NetBSD: options.mk,v 1.1 2012/10/05 21:03:10 adam Exp $ + +PKG_OPTIONS_VAR= PKG_OPTIONS.postgresql92 +PKG_SUPPORTED_OPTIONS= bonjour gssapi kerberos ldap pam xml dtrace + +.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 + +### +### Dtrace support +### +.if !empty(PKG_OPTIONS:Mdtrace) +CONFIGURE_ARGS+= --enable-dtrace +.endif diff --git a/databases/postgresql92/patches/patch-config_missing b/databases/postgresql92/patches/patch-config_missing new file mode 100644 index 00000000000..92c03021863 --- /dev/null +++ b/databases/postgresql92/patches/patch-config_missing @@ -0,0 +1,13 @@ +$NetBSD: patch-config_missing,v 1.1 2012/10/05 21:03:10 adam Exp $ + +--- config/missing.orig 2012-10-05 12:14:55.000000000 +0000 ++++ config/missing +@@ -40,7 +40,7 @@ pre-packaged $1 output. + ERROR: Perl is missing on your system. It is needed unless you are building + from an unmodified official distribution of PostgreSQL. + ***" >&2 +- exit 1 ++ exit 0 + ;; + + *) diff --git a/databases/postgresql92/patches/patch-config_perl.m4 b/databases/postgresql92/patches/patch-config_perl.m4 new file mode 100644 index 00000000000..107b37d1aba --- /dev/null +++ b/databases/postgresql92/patches/patch-config_perl.m4 @@ -0,0 +1,15 @@ +$NetBSD: patch-config_perl.m4,v 1.1 2012/10/05 21:03:10 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/postgresql92/patches/patch-configure b/databases/postgresql92/patches/patch-configure new file mode 100644 index 00000000000..36b4925d5f9 --- /dev/null +++ b/databases/postgresql92/patches/patch-configure @@ -0,0 +1,23 @@ +$NetBSD: patch-configure,v 1.1 2012/10/05 21:03:10 adam Exp $ + +--- configure.orig 2012-09-19 21:47:58.000000000 +0000 ++++ configure +@@ -2188,6 +2188,7 @@ case $host_os in + darwin*) template=darwin ;; + dragonfly*) template=netbsd ;; + freebsd*) template=freebsd ;; ++ dragonfly*) template=dragonfly ;; + hpux*) template=hpux ;; + irix*) template=irix ;; + linux*|gnu*|k*bsd*-gnu) +@@ -7251,9 +7252,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/postgresql92/patches/patch-contrib_dblink_Makefile b/databases/postgresql92/patches/patch-contrib_dblink_Makefile new file mode 100644 index 00000000000..1090bdecda0 --- /dev/null +++ b/databases/postgresql92/patches/patch-contrib_dblink_Makefile @@ -0,0 +1,12 @@ +$NetBSD: patch-contrib_dblink_Makefile,v 1.1 2012/10/05 21:03:10 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/postgresql92/patches/patch-contrib_dblink_dblink.c b/databases/postgresql92/patches/patch-contrib_dblink_dblink.c new file mode 100644 index 00000000000..e195e18b391 --- /dev/null +++ b/databases/postgresql92/patches/patch-contrib_dblink_dblink.c @@ -0,0 +1,13 @@ +$NetBSD: patch-contrib_dblink_dblink.c,v 1.1 2012/10/05 21:03:10 adam Exp $ + +--- contrib/dblink/dblink.c.orig 2012-09-19 21:47:58.000000000 +0000 ++++ contrib/dblink/dblink.c +@@ -46,7 +46,7 @@ + #include "parser/scansup.h" + #include "utils/acl.h" + #include "utils/builtins.h" +-#include "utils/fmgroids.h" ++#include "postgresql/server/utils/fmgroids.h" + #include "utils/lsyscache.h" + #include "utils/memutils.h" + #include "utils/rel.h" diff --git a/databases/postgresql92/patches/patch-src_Makefile.shlib b/databases/postgresql92/patches/patch-src_Makefile.shlib new file mode 100644 index 00000000000..32dd57397ce --- /dev/null +++ b/databases/postgresql92/patches/patch-src_Makefile.shlib @@ -0,0 +1,40 @@ +$NetBSD: patch-src_Makefile.shlib,v 1.1 2012/10/05 21:03:10 adam Exp $ + +--- src/Makefile.shlib.orig 2012-09-19 21:47:58.000000000 +0000 ++++ src/Makefile.shlib +@@ -159,17 +159,11 @@ endif + + ifeq ($(PORTNAME), freebsd) + ifdef ELF_SYSTEM +- ifdef SO_MAJOR_VERSION +- shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION) +- endif + LINK.shared = $(COMPILER) -shared + ifdef soname + LINK.shared += -Wl,-x,-soname,$(soname) + endif + else +- ifdef SO_MAJOR_VERSION +- shlib = lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION) +- endif + LINK.shared = $(LD) -x -Bshareable -Bforcearchive + endif + endif +@@ -185,6 +179,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/postgresql92/patches/patch-src_backend_Makefile b/databases/postgresql92/patches/patch-src_backend_Makefile new file mode 100644 index 00000000000..3b030a1cedc --- /dev/null +++ b/databases/postgresql92/patches/patch-src_backend_Makefile @@ -0,0 +1,15 @@ +$NetBSD: patch-src_backend_Makefile,v 1.1 2012/10/05 21:03:10 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/postgresql92/patches/patch-src_makefiles_Makefile.solaris b/databases/postgresql92/patches/patch-src_makefiles_Makefile.solaris new file mode 100644 index 00000000000..e4650311a18 --- /dev/null +++ b/databases/postgresql92/patches/patch-src_makefiles_Makefile.solaris @@ -0,0 +1,10 @@ +$NetBSD: patch-src_makefiles_Makefile.solaris,v 1.1 2012/10/05 21:03:10 adam Exp $ + +--- src/makefiles/Makefile.solaris.orig 2011-09-23 00:00:48.000000000 +0200 ++++ src/makefiles/Makefile.solaris 2011-10-11 11:53:51.948565783 +0200 +@@ -23,5 +23,3 @@ ifeq ($(GCC), yes) + else + $(CC) $(CFLAGS) $(LDFLAGS) $(LDFLAGS_SL) -G -o $@ $< + endif +- +-sqlmansect = 5sql diff --git a/databases/postgresql92/patches/patch-src_pl_plperl_GNUmakefile b/databases/postgresql92/patches/patch-src_pl_plperl_GNUmakefile new file mode 100644 index 00000000000..e32624814a8 --- /dev/null +++ b/databases/postgresql92/patches/patch-src_pl_plperl_GNUmakefile @@ -0,0 +1,21 @@ +$NetBSD: patch-src_pl_plperl_GNUmakefile,v 1.1 2012/10/05 21:03:10 adam Exp $ + +--- src/pl/plperl/GNUmakefile.orig 2012-02-23 22:53:36.000000000 +0000 ++++ src/pl/plperl/GNUmakefile +@@ -60,7 +60,6 @@ XSUBPPDIR = $(shell $(PERL) -e 'use List + + include $(top_srcdir)/src/Makefile.shlib + +-plperl.o: perlchunks.h plperl_opmask.h plperl_helpers.h + + plperl_opmask.h: plperl_opmask.pl + @if [ x"$(perl_privlibexp)" = x"" ]; then echo "configure switch --with-perl was not specified."; exit 1; fi +@@ -70,7 +69,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 plperl_helpers.h all-lib + + SPI.c: SPI.xs plperl_helpers.h + @if [ x"$(perl_privlibexp)" = x"" ]; then echo "configure switch --with-perl was not specified."; exit 1; fi diff --git a/databases/postgresql92/patches/patch-src_pl_plperl_plperl.h b/databases/postgresql92/patches/patch-src_pl_plperl_plperl.h new file mode 100644 index 00000000000..63d0749fc31 --- /dev/null +++ b/databases/postgresql92/patches/patch-src_pl_plperl_plperl.h @@ -0,0 +1,26 @@ +$NetBSD: patch-src_pl_plperl_plperl.h,v 1.1 2012/10/05 21:03:10 adam Exp $ + +--- src/pl/plperl/plperl.h.orig 2011-09-22 23:57:57.000000000 +0200 ++++ src/pl/plperl/plperl.h 2011-10-12 20:36:11.783264869 +0200 +@@ -44,12 +44,21 @@ + #undef vsnprintf + #endif + ++#ifdef __sun ++#define list_head sun_list_head ++#define list_tail sun_list_tail ++#endif + + /* required for perl API */ + #include "EXTERN.h" + #include "perl.h" + #include "XSUB.h" + ++#ifdef __sun ++#undef list_head ++#undef list_tail ++#endif ++ + /* put back our snprintf and vsnprintf */ + #ifdef USE_REPL_SNPRINTF + #ifdef snprintf diff --git a/databases/postgresql92/patches/patch-src_timezone_localtime.c b/databases/postgresql92/patches/patch-src_timezone_localtime.c new file mode 100644 index 00000000000..6a3f081484a --- /dev/null +++ b/databases/postgresql92/patches/patch-src_timezone_localtime.c @@ -0,0 +1,31 @@ +$NetBSD: patch-src_timezone_localtime.c,v 1.1 2012/10/05 21:03:10 adam Exp $ + +--- src/timezone/localtime.c.orig 2009-06-11 16:49:15.000000000 +0200 ++++ src/timezone/localtime.c +@@ -81,20 +81,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/postgresql92/patches/patch-src_timezone_private.h b/databases/postgresql92/patches/patch-src_timezone_private.h new file mode 100644 index 00000000000..84fe15d265c --- /dev/null +++ b/databases/postgresql92/patches/patch-src_timezone_private.h @@ -0,0 +1,15 @@ +$NetBSD: patch-src_timezone_private.h,v 1.1 2012/10/05 21:03:10 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/postgresql92/patches/patch-src_timezone_strftime.c b/databases/postgresql92/patches/patch-src_timezone_strftime.c new file mode 100644 index 00000000000..91eee8e1c43 --- /dev/null +++ b/databases/postgresql92/patches/patch-src_timezone_strftime.c @@ -0,0 +1,13 @@ +$NetBSD: patch-src_timezone_strftime.c,v 1.1 2012/10/05 21:03:10 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/postgresql92/patches/patch-src_timezone_zic.c b/databases/postgresql92/patches/patch-src_timezone_zic.c new file mode 100644 index 00000000000..1940fe22903 --- /dev/null +++ b/databases/postgresql92/patches/patch-src_timezone_zic.c @@ -0,0 +1,78 @@ +$NetBSD: patch-src_timezone_zic.c,v 1.1 2012/10/05 21:03:10 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; |