dev-db/postgresql

PostgreSQL is a powerful, open source relational database system.

Versions

Slot Version Repository Platforms
0 9.3.5 arbor ~amd64 arm? ~x86
9.2.9 arbor ~amd64 arm? ~x86

Metadata

Homepage http://www.postgresql.org
Summary PostgreSQL is a powerful, open source relational database system
Bugs to ingmar@exherbo.org
Description PostgreSQL is a powerful, open source relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL92 and SQL99 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.
Upstream documentation (
    http://www.postgresql.org/docs/manuals/
    http://www.postgresql.org/docs/faq/
    http://www.postgresql.org/support/security.html
)
Upstream release notes (
    http://wiki.postgresql.org/wiki/WhatsNew93
    http://www.postgresql.org/docs/9.3/static/release-9-3.html
)
Dependencies (
    build:
    sys-devel/gettext
    sys-devel/flex
    build+run:
    group/postgres
    user/postgres
    ldap? (
        net-directory/openldap
    )
    pam? (
        sys-libs/pam
    )
    perl? (
        dev-lang/perl:=
    )
    python? (
        dev-lang/python:=
    )
    readline? (
        sys-libs/readline
    )
    ssl? (
        virtual/libssl
    )
    tcl? (
        dev-lang/tcl:=
    )
    xml? (
        dev-libs/libxml2:=[>=2.6.23]
        dev-libs/libxslt
    )
    build+run:
    postgresql_extensions:uuid-ossp? (
        dev-libs/ossp-uuid
    )
)
Downloads mirror://postgresql/source/v9.3.5/postgresql-9.3.5.tar.bz2
Licences PostgreSQL

Choices

OPTIONS

ldap Adds LDAP support (Lightweight Directory Access Protocol)
pam Adds support PAM (Pluggable Authentication Modules)
perl Support for both PL/Perl and Pl/PerlU server-side programming languages
python Support for PL/Python (only the "untrusted" version) server-side programming language
readline Used only by the client psql for history control and autocomplete funcionality
ssl Adds support for Secure Socket Layer connections
systemd Add support for the systemd init daemon (usually by installing units (configuration files)).
tcl Support for both PL/Tcl and PL/TclU server-side programming languages
xml Add core support for XML data type

postgresql_extensions

btree_gin GIN operator classes that implement B-tree equivalent behavior for several data types
btree_gist GiST index operator classes that imlement B-tree equivalent behavior for several data types
chkpass The chkpass data type for storing encrypted passwords
citext The citext data type, a case-insensitive character string type
cube The cube data type for representing multidimensional cubes
dblink Connect to other PostgreSQL databases from within a database session
dict_int An example dictionnary for indexing integers
dict_xsyn An example dictionnary for replacing words with their synonyms for full-text search
earthdistance Two methods for calculating great circle distances on the surface of the Earth
file_fdw A foreign-data wrapper for accessing files on the servers's file system
fuzzystrmatch Distance functions on text (mostly for phonetic comparisons)
hstore The hstore data type
intagg An integer aggregator and an enumerator (obsolete)
intarray Additional functions and indices for int arrays and int sets
isn Data types for international product numbering standards
lo The large object support functions and the vacuumlo command line utility
ltree The ltree data type for hierarquical categorization
pageinspect Low-level functions to inspect pages (for debugging)
pg_buffercache Analyze what's happening in the shared buffer cache
pg_freespacemap Analyze the free space map
pg_trgm Trigram support for Full-Text Search
pg_upgrade Command line utility to upgrade clusters between major versions
pgcrypto Cryptographic (hashing, {de,en}cryption, (de)compression etc) functions
pgstattuple Functions for tuple-level statistics
postgres_fdw Extension with the Foreign Data Wrapper to access other PostgreSQL servers
seg The seg data type for representing line segments or floating point intervals
spi Package of autoinc, insert_username, moddatetime, refint and timetravel extensions
sslinfo Functions for retrieving informations about the client SSL certificate
tablefunc Some set returning functions (normal_rand, crosstab variations and connectby)
tcn A trigger function to notify listeners of changes
test_parser An example parser for full-text search
tsearch2 Backward-compatible text-search function for tsearch2-compatible applications
unaccent A text-search dictionnary which removes accents from lexemes
uuid-ossp Functions for generating UUIDs
xml2 XPath querying and XSLT functionality