dev-db/postgresql

PostgreSQL is a powerful, open source relational database system.

Versions

Slot Version Repository Platforms
0 9.3.4-r1 arbor ~amd64 arm? ~x86
9.2.8-r1 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? (
        dev-libs/openssl
    )
    tcl? (
        dev-lang/tcl:=
    )
    xml? (
        dev-libs/libxml2:=[>=2.6.23]
        dev-libs/libxslt
    )
)
Downloads mirror://postgresql/source/v9.3.4/postgresql-9.3.4.tar.bz2
Licences PostgreSQL

Choices

OPTIONS

fuzzystrmatch Extension with distance functions on text (mostly for phonetic comparisons)
hstore Extension with the hstore data type
intarray Extension with additional functions and indices for int arrays and int sets
ldap Adds LDAP support (Lightweight Directory Access Protocol)
lo Extension with the large object support functions and the vacuumlo command line utility
ltree Extension with the ltree data type for hierarquical categorization
pam Adds support PAM (Pluggable Authentication Modules)
perl Support for both PL/Perl and Pl/PerlU server-side programming languages
pg_trgm Extension with trigram support for Full-Text Search
pg_upgrade Command line utility to upgrade clusters between major versions
pgcrypto Extension with cryptographic (hashing, {de,en}cryption, (de)compression etc) functions
postgres_fdw Extension with the Foreign Data Wrapper to access other PostgreSQL servers
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)).
tablefunc Extension with some set returning functions (normal_rand, crosstab variations and connectby)
tcl Support for both PL/Tcl and PL/TclU server-side programming languages
xml Add core support for XML data type