PostgreSQL is an object-relational database management system designed for applications requiring transactional integrity, sophisticated queries and extensible data management.
The database implements a substantial portion of the SQL standard while providing additional features for complex data types, procedural programming and custom database functionality. It supports both conventional relational structures and semi-structured information.
PostgreSQL uses multi-version concurrency control to allow readers and writers to operate concurrently without unnecessary blocking. Its extensibility allows additional functions, operators, index methods and data types to be incorporated into the database engine.
This is free and open source software.
Key Features
- ACID transactions with multiple isolation levels, savepoints and two-phase commit.
- Supports foreign keys, constraints, triggers, views and materialized views.
- Provides JSON and JSONB data types with indexing and query operators.
- Offers B-tree, hash, GiST, SP-GiST, GIN and BRIN indexes.
- Supports common table expressions, recursive queries, window functions and lateral joins.
- Includes built-in full-text search and advanced regular expression support.
- Provides table partitioning, parallel query execution and sophisticated query planning.
- Supports logical and physical replication, streaming replication and point-in-time recovery.
- Offers row-level security, granular privileges and multiple authentication mechanisms.
- Extensible through custom types, functions, operators and extensions.
- Supports procedural functions, including PL/pgSQL.
- Cross-platform support – runs on Linux, macOS, and Windows.
Website: postgresql.org
Support:
Developer: PostgreSQL Global Development Group
License: PostgreSQL License
PostgreSQL is written in C. Learn C with our recommended free books and free tutorials.
Related Software
| Relational Databases | |
|---|---|
| MariaDB | High compatibility with MySQL, ensuring drop-in replacement capability |
| PostgreSQL | Award winning Object-relational database management system |
| MySQL | Multithreaded, multi-user SQL database management system |
| SQLite | Embeddable SQL Database Engine |
| TiDB | Cloud-native, distributed SQL database |
| DuckDB | In-process SQL OLAP database management system |
| Turso | In-process relational database engine |
| YugabyteDB | PostgreSQL-compatible distributed SQL database |
| rqlite | Distributed database built on SQLite |
| MonetDB | High performance relational database system for analytics |
| Dolt | Version-controlled SQL database |
| Firebird | Relational database offering many ANSI SQL features |
| H2 | Relational database management system written in Java |
| HSQLDB | JDBC interface, client-server version, query tool, grid and more |
| CUBRID | Database engine with built-in enterprise grade features |
| Apache Cloudberry | Massively parallel processing database |
| Virtuoso | Data Management with Web Application Server and Web Services |
| Apache Derby | Full-featured relational database implemented entirely in Java |
Read our verdict in the software roundup.
LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |


Please read our Comment Policy before commenting.
I read “Hot standby” two times from the list, a duplicate.
Thanks, the duplicate entry is removed.