Package
Postgresql
postgresql-9.3.17
Module
Version
Previous versions
Other branches
Description

A powerful, enterprise class open source object-relational database system.

It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 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.

PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate.

Alternatives
Redmine

A flexible project management web application.

 default

Web application environment with Linux, Apache HTTPD, PostgreSQL SQL databases server and PHP. PHP works as the mod_php Apache module.

Optional components: Memcached, Redis, MongoDB, Tarantool.

 default

Web application environment with Linux, Nginx, PostgreSQL SQL databases server and PHP. PHP works in php-fpm mode.

Optional components: Memcached, Redis, MongoDB, Tarantool.

Databases

PostgreSQL family of the relational database management systems.