-
The PostgreSQL contrib tree
---------------------------
-This subtree contains tools, modules, and examples that are not
-maintained as part of the core PostgreSQL system, mainly because
-they only address a limited audience or are too inelegant to be
-sold as an official feature. That, however, does not preclude
-their usefulness.
-
-Each subdirectory contains a README file with information about the
-module. Most items can be built with `gmake all' and installed
-with `gmake install' in the usual fashion, after you have run the
-`configure' script in the top-level directory. Some directories
-supply new user-defined functions, operators, or types. After you
-have installed the files you need to register the new entities in
-the database system by running the commands in the supplied .sql
-file. For example,
+This subtree contains porting tools, analysis utilities, and plug-in
+features that are not part of the core PostgreSQL system, mainly because
+they address a limited audience or are too experimental to be part of
+the main source tree. This does not preclude their usefulness.
+
+User documentation for each module appears in the main SGML documentation.
+
+Most items can be built with `gmake all' and installed with
+`gmake install' in the usual fashion, after you have run the `configure'
+script in the top-level directory. Some directories supply new
+user-defined functions, operators, or types. In these cases, after you have
+installed the files you need to register the new entities in the database
+system by running the commands in the supplied .sql file. For example,
$ psql -d dbname -f module.sql
Index:
------
-array -
- Array iterator functions
- by Massimo Dal Zotto <dz@cs.unitn.it>
+adminpack -
+ File and log manipulation routines, used by pgAdmin
+ by Dave Page <dpage@vale-housing.co.uk>
+
+auth_delay
+ Add a short delay after a failed authentication attempt, to make
+ brute-force attacks on database passwords a bit harder.
+ by KaiGai Kohei <kaigai@ak.jp.nec.com>
+
+auto_explain -
+ Log EXPLAIN output for long-running queries
+ by Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
+
+btree_gin -
+ Support for emulating BTREE indexing in GIN
+ by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@sigaev.ru>
btree_gist -
Support for emulating BTREE indexing in GiST
- by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@stack.net>
+ by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@sigaev.ru>
chkpass -
An auto-encrypted password datatype
by D'Arcy J.M. Cain <darcy@druid.net>
+citext -
+ A case-insensitive character string datatype
+ by David E. Wheeler <david@kineticode.com>
+
cube -
Multidimensional-cube datatype (GiST indexing example)
by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
-dbase -
- Converts from dbase/xbase to PostgreSQL
- by Maarten.Boekhold <Maarten.Boekhold@reuters.com>,
- Frank Koormann <fkoorman@usf.uni-osnabrueck.de>,
- Ivan Baldo <lubaldo@adinet.com.uy>
-
dblink -
Allows remote query execution
- by Joe Conway, joe.conway@mail.com
+ by Joe Conway <mail@joeconway.com>
-earthdistance -
- Operator for computing earth distance for two points
- by Hal Snyder <hal@vailsys.com>
+dict_int -
+ Text search dictionary template for integers
+ by Sergey Karpov <karpov@sao.ru>
-findoidjoins -
- Finds the joins used by oid columns by examining the actual
- values in the oid columns and row oids.
- by Bruce Momjian <pgman@candle.pha.pa.us>
+dict_xsyn -
+ Text search dictionary template for extended synonym processing
+ by Sergey Karpov <karpov@sao.ru>
-fulltextindex -
- Full text indexing using triggers
- by Maarten Boekhold <maartenb@dutepp0.et.tudelft.nl>
+earthdistance -
+ Functions for computing distances between two points on Earth
+ by Bruno Wolff III <bruno@wolff.to> and Hal Snyder <hal@vailsys.com>
+
+file_fdw
+ Foreign-data wrapper for server-side CSV/TEXT files
+ by Shigeru Hanada <hanada@metrosystems.co.jp>
fuzzystrmatch -
Levenshtein, metaphone, and soundex fuzzy string matching
- by Joe Conway <joseph.conway@home.com>, Joel Burton <jburton@scw.org>
+ by Joe Conway <mail@joeconway.com> and Joel Burton <jburton@scw.org>
+
+hstore -
+ Module for storing (key, value) pairs
+ by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@sigaev.ru>
+
+intagg -
+ Integer aggregator
+ by mlw <markw@mohawksoft.com>
intarray -
Index support for arrays of int4, using GiST
- by Teodor Sigaev <teodor@stack.net> and Oleg Bartunov
- <oleg@sai.msu.su>.
-
-ipc_check -
- Simple test script to help in configuring IPC.
- FreeBSD only, for now.
+ by Teodor Sigaev <teodor@sigaev.ru> and Oleg Bartunov <oleg@sai.msu.su>
-isbn_issn -
- PostgreSQL type extensions for ISBN (books) and ISSN (serials)
- by Garrett A. Wollman <wollman@khavrinen.lcs.mit.edu>
+isn -
+ PostgreSQL type extensions for ISBN, ISSN, ISMN, EAN13 product numbers
+ by Germán Méndez Bravo (Kronuz) <kronuz@hotmail.com>
lo -
Large Object maintenance
- by Peter Mount <peter@retep.org.uk>
+ by Peter Mount <peter@retep.org.uk>
-mSQL-interface -
- mSQL API translation library
- by Aldrin Leal <aldrin@americasnet.com>
+ltree -
+ Tree-like data structures
+ by Teodor Sigaev <teodor@sigaev.ru> and Oleg Bartunov <oleg@sai.msu.su>
-mac -
- Support functions for MAC address types
- by Lawrence E. Rosenman <ler@lerctr.org>
+oid2name -
+ Maps numeric files to table names
+ by B Palmer <bpalmer@crimelabs.net>
-miscutil -
- PostgreSQL assert checking and various utility functions
- by Massimo Dal Zotto <dz@cs.unitn.it>
+pageinspect -
+ Allows inspection of database pages
+ Heikki Linnakangas <heikki@enterprisedb.com>
-mysql -
- utility to convert MySQL schema dumps to SQL92 and PostgreSQL
- by Thomas Lockhart <lockhart@alumni.caltech.edu>
- Max Rudensky <fonin@ziet.zhitomir.ua>
- Valentine Danilchuk <valdan@ziet.zhitomir.ua>
+passwordcheck -
+ Simple password strength checker
+ Laurenz Albe <laurenz.albe@wien.gv.at>
-noupdate -
- trigger to prevent updates on single columns
+pg_buffercache -
+ Real time queries on the shared buffer cache
+ by Mark Kirkwood <markir@paradise.net.nz>
-oid2name -
- maps numeric files to table names
- by B Palmer <bpalmer@crimelabs.net>
+pg_freespacemap -
+ Displays the contents of the free space map (FSM)
+ by Mark Kirkwood <markir@paradise.net.nz>
-oracle -
- converts Oracle database schema to PostgreSQL
- by Gilles Darold <gilles@darold.net>
+pg_standby -
+ Sample archive_command for warm standby operation
+ by Simon Riggs <simon@2ndquadrant.com>
-pg_controldata -
- Dump contents of pg_control (database master file)
- by Oliver Elphick <olly@lfix.co.uk>
+pg_stat_statements -
+ Track statement execution times across a whole database cluster
+ by Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
-pg_dumplo -
- Dump large objects
- by Karel Zak <zakkr@zf.jcu.cz>
+pg_test_fsync -
+ Test different wal_sync_method settings
+ by Bruce Momjian <bruce@momjian.us>
-pg_logger -
- Stdin-to-syslog gateway for PostgreSQL
- by Nathan Myers <ncm@nospam.cantrip.org>
+pg_trgm -
+ Functions for determining the similarity of text based on trigram
+ matching.
+ by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@sigaev.ru>
-pg_resetxlog -
- Reset the WAL log (pg_xlog) to recover from crash or format change
- by Tom Lane <tgl@sss.pgh.pa.us>
+pg_upgrade -
+ Support for in-place upgrade between major releases of PostgreSQL
+ Bruce Momjian <bruce@momjian.us> and others
pgbench -
TPC-B like benchmarking tool
- by Tatsuo Ishii <t-ishii@sra.co.jp>
+ by Tatsuo Ishii <ishii@sraoss.co.jp>
pgcrypto -
Cryptographic functions
by Marko Kreen <marko@l-t.ee>
-pgstattuple -
- A function returns the percentage of "dead" tuples in a table
- by Tatsuo Ishii <t-ishii@sra.co.jp>
-
-retep -
- tools to build retep tools packages
- by Peter T Mount <peter@retep.org.uk>
-
-rserv -
- replication server
- by Vadim B. Mikheev <vadim4o@email.com>
+pgrowlocks -
+ A function to return row locking information
+ by Tatsuo Ishii <ishii@sraoss.co.jp>
-rtree_gist -
- Support for emulating RTREE indexing in GiST
- by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@stack.net>
+pgstattuple -
+ Functions to return statistics about "dead" tuples and free
+ space within a table
+ by Tatsuo Ishii <ishii@sraoss.co.jp>
seg -
Confidence-interval datatype (GiST indexing example)
by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
+sepgsql -
+ External security provider using SELinux
+ by KaiGai Kohei <kaigai@ak.jp.nec.com>
+
spi -
Various trigger functions, examples for using SPI.
-start-scripts -
- Scripts for starting the server at boot time.
-
-string -
- C-like input/output conversion routines for strings
- by Massimo Dal Zotto <dz@cs.unitn.it>
+sslinfo -
+ Functions to get information about SSL certificates
+ by Victor Wagner <vitus@cryptocom.ru>
+
+start-scripts -
+ Scripts for starting the server at boot time on various platforms.
+
+tablefunc -
+ Examples of functions returning tables
+ by Joe Conway <mail@joeconway.com>
-tips/apache_logging -
- Getting Apache to log to PostgreSQL
- by Terry Mackintosh <terry@terrym.com>
+test_parser -
+ Sample text search parser
+ by Sergey Karpov <karpov@sao.ru>
-tools -
- Assorted developer tools
- by Massimo Dal Zotto <dz@cs.unitn.it>
+tsearch2 -
+ Compatibility package for the pre-8.3 implementation of text search.
+ Pavel Stehule <pavel.stehule@gmail.com>, based on code originally by
+ Teodor Sigaev <teodor@sigaev.ru> and Oleg Bartunov <oleg@sai.msu.su>.
-tsearch -
- Full-text-index support using GiST
- by Teodor Sigaev <teodor@stack.net> and Oleg Bartunov
- <oleg@sai.msu.su>.
+unaccent -
+ Unaccent dictionary for text search
+ Teodor Sigaev <teodor@sigaev.ru> and Oleg Bartunov <oleg@sai.msu.su>.
-userlock -
- User locks
- by Massimo Dal Zotto <dz@cs.unitn.it>
+uuid-ossp -
+ UUID generation functions
+ by Peter Eisentraut <peter_e@gmx.net>
vacuumlo -
Remove orphaned large objects
by Peter T Mount <peter@retep.org.uk>
-xml -
+xml2 -
Storing XML in PostgreSQL
by John Gray <jgray@azuli.co.uk>