PostgreSQL

An advanced open-source relational database.

PostgreSQL is a SQL database system known for strict standards compliance, mature transaction handling, an extensible type system, and a rich set of built-in features such as JSON support, full-text search, geographic data via PostGIS, logical replication, partitioning, and parallel query execution. The extensibility — user-defined types, operators, and aggregate functions — has produced a substantial ecosystem of specialised extensions for time-series data (TimescaleDB), columnar storage (Citus), and geospatial work (PostGIS).

PostgreSQL traces back to the POSTGRES research project at UC Berkeley led by Michael Stonebraker in the 1980s. The project was open-sourced in 1996 with SQL replacing the original POSTQUEL query language, and the PostgreSQL Global Development Group has maintained it ever since through major-version releases roughly annually with five years of support per release.

PostgreSQL has become the default choice for new production-grade relational database workloads. AWS RDS, Google Cloud SQL, Azure Database, and most other cloud providers offer managed PostgreSQL. The licence (PostgreSQL Licence, similar to BSD/MIT) is permissive enough to encourage commercial use, and the database is widely deployed both in small projects and in massive enterprise deployments.

License: PostgreSQL License (similar to BSD/MIT)

Category: Data

Website: https://www.postgresql.org/

Install

Debian/Ubuntu: sudo apt install postgresql
Fedora/RHEL:   sudo dnf install postgresql-server
Arch:          sudo pacman -S postgresql
macOS:         brew install postgresql

Authors

Michael Stonebraker (POSTGRES project at UC Berkeley)
PostgreSQL Global Development Group

PreviousPostfix NextPrettier