Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

PostgreSQL

postgresql.org

  • Free plan
  • Windows
  • macOS
  • Linux
  • Self-hosted
7.6 Club score Visit postgresql.org

What PostgreSQL is

PostgreSQL is a free, open-source object-relational database system for storing and scaling complex workloads. It uses SQL and supports primitive, structured, document, geometric and custom data types, including JSON/JSONB, XML, arrays, ranges and UUIDs. Data integrity tools include keys, constraints, locks, transactions, savepoints and SQL-standard isolation levels. Performance features include multiple index types, query planning, parallel processing, partitioning, just-in-time expression compilation and asynchronous I/O. PostgreSQL supports write-ahead logging, asynchronous, synchronous and logical replication, point-in-time recovery and active standbys. Security options include GSSAPI, LDAP, SCRAM-SHA-256, certificate and OAuth 2.0 authentication, access controls, row- and column-level security and multi-factor authentication. Extensions, procedural languages and foreign data wrappers add capabilities and connections. It is self-hosted, with no managed service listed. The project recommends the latest minor version; PostgreSQL 14 is scheduled to stop receiving fixes on November 12, 2026.

Who it suits

It suits developers building applications and administrators responsible for data integrity, replication, security and fault-tolerant environments. Teams must operate their own deployment.

Good to know, and what to watch

  • Free license permits use, modification and distribution
  • Supports JSON/JSONB and many other data types
  • Offers replication and point-in-time recovery
  • Includes row- and column-level security
  • Extensible through extensions and foreign data wrappers
  • Self-hosted; no managed service is listed
  • PostgreSQL 14 has a scheduled fixes end date
  • No bug bounty program is offered

PostgreSQL

Free

Free plan

The verdict

PostgreSQL combines broad SQL data support with transaction, replication, security and extension features. It is a strong fit where teams can manage a self-hosted database and its update cycle.

What the maker publishes

Data types
It supports primitive, structured, document, geometric, and custom data types, including JSON/JSONB, XML, arrays, ranges, and UUIDs. source
Extensions and integrations
PostgreSQL supports extensions such as PostGIS, procedural languages, and foreign data wrappers that connect to other databases or streams through SQL. source
Free plan
Yes source
Integrity and transactions
Features include primary and foreign keys, constraints, explicit and advisory locks, transactions, savepoints, and all SQL-standard transaction isolation levels. source
License
The PostgreSQL License permits use, copying, modification, and distribution for any purpose without a fee or written agreement, subject to its conditions. source
Performance
PostgreSQL includes multiple index types, a query planner and optimizer, parallel query processing, table partitioning, just-in-time expression compilation, and asynchronous I/O. source
Platforms
The project says PostgreSQL runs on all major operating systems and provides downloads for Linux, macOS, Windows, BSD, and Solaris. source
Recovery and replication
It supports write-ahead logging, asynchronous, synchronous, and logical replication, point-in-time recovery, and active standbys. source
Release lifecycle
PostgreSQL 14 is scheduled to stop receiving fixes on November 12, 2026, according to the project homepage. source
Security
Listed security features include GSSAPI, LDAP, SCRAM-SHA-256, certificate and OAuth 2.0 authentication, access controls, row- and column-level security, and multi-factor authentication. source
Security process
The project says it releases security fixes in minor-version updates and advises users to use the latest available minor version. source
Security reporting
The PostgreSQL Project is a CVE Numbering Authority and accepts vulnerability reports at [email protected]; it does not offer bug bounties. source
Support
Community support options include documentation, community resources, mailing lists, and IRC, while commercial support and PostgreSQL-specific hosting are available from listed providers. source
What it does
PostgreSQL is an open source object-relational database system that uses and extends SQL to store and scale complex data workloads. source
Who it is for
The project describes features for developers building applications and administrators protecting data integrity and building fault-tolerant environments. source

Checked against the maker's pages on 29 Sept 2026.