PostgreSQL
postgresql.org
- Free plan
- Windows
- macOS
- Linux
- Self-hosted
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
Plans
Every plan and pricePostgreSQL
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.