Package
Postgresql
postgresql-9.5.5
Module
Version
Previous versions
Next 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.

Drupal

A free and open source content-management system and framework written in PHP and using relational database management system as a storage.

Joomla

A free and open-source content management system (CMS) for publishing web content, based on on PHP and JavaScript. It is built on a model–view–controller web application framework that can be used independently of the CMS.

 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.