Softwr
PostgreSQL logo

PostgreSQL

Open source relational database

As of 17 November 2026, PostgreSQL is free to use. PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development. Softwr lists it under Databases. PostgreSQL is made by PostgreSQL Global Development Group, launched in 1996, available on Linux, Windows, macOS.

Overview

What is PostgreSQL?

PostgreSQL is a free and open source relational database system. Its origins date to 1986 as the POSTGRES project at the University of California, Berkeley, and the project describes itself as having nearly 40 years of active development. It has been ACID compliant since 2001, and version 18 was released in September 2025. It supports a wide range of data types, including integers, text, dates, arrays, ranges, UUIDs, JSON and JSONB, XML, geometric types and custom types. For integrity and concurrency it offers primary and foreign keys, exclusion constraints, MVCC, all SQL-standard isolation levels including Serializable, parallel query and table partitioning. Reliability features include write-ahead logging, asynchronous, synchronous and logical replication, and point-in-time recovery. Security options include SCRAM-SHA-256, LDAP, certificate and OAuth 2.0 authentication, plus row and column level security. It is extensible through stored functions in PL/pgSQL, Perl, Python and Tcl, foreign data wrappers and extensions such as PostGIS. There is no licence fee, and costs come from the hardware or hosting and the staff who run it. It suits developers and organisations that want a standards-focused database they can run themselves or buy as a managed service from other vendors. The project itself is a database server and not a hosted service, and it does not ship a vendor-backed support plan.

What people use it for

  • Transaction processing
  • Data storage
  • Application backend
  • Reporting
  • Data analytics

The honest half

Where does PostgreSQL fall short?

The limits buyers hit most with PostgreSQL: requires manual scaling across multiple machines for very large deployments; and performance tuning requires deep knowledge of database internals. Each is concrete and checkable: the half of a review a vendor will not write.

  • Requires manual scaling across multiple machines for very large deployments
  • Performance tuning requires deep knowledge of database internals
  • No built-in graphical admin interface; command-line tools are primary method

Cross-shopped

What are the alternatives to PostgreSQL?

The closest alternatives to PostgreSQL are MariaDB, MySQL and Cockroach Labs. Each is a tool buyers genuinely weigh against it, with the reason why.

Pricing

How much does PostgreSQL cost?

PostgreSQL is free to use. Taken from the vendor's own pricing page; prices move, so check before you buy.

PostgreSQL

Free

Capabilities

What can PostgreSQL do?

PostgreSQL lists 16 features, including ACID Compliance, JSON/JSONB Support and full-text Search.

  • ACID Compliance

  • JSON/JSONB Support

  • Full-text Search

  • Extensibility

  • Advanced Indexing

  • Partitioning

  • Replication

  • pgAdmin

    Integration with pgAdmin

  • DBeaver

    Integration with DBeaver

  • Prisma

    Integration with Prisma

  • Sequelize

    Integration with Sequelize

  • TypeORM

    Integration with TypeORM

Answered, with sources

Questions people ask

Each answer names the page it came from, so you can check it rather than take our word for it.

Is PostgreSQL completely free?

Yes. PostgreSQL is completely free and open source with no licensing fees or restrictions on use.

Source
What platforms does PostgreSQL run on?

PostgreSQL runs on all major operating systems including Linux, Windows, macOS, BSD, and commercial Unix variants, and has been proven highly scalable managing terabytes to petabytes of data.

Source
What procedural languages are supported?

PostgreSQL supports stored functions and procedures in multiple languages including PL/pgSQL, Perl, Python, Tcl, Java, JavaScript, R, and Rust.

Source
What is ACID compliance in PostgreSQL?

PostgreSQL has been ACID-compliant since 2001, ensuring data integrity through atomicity, consistency, isolation, and durability guarantees for all transactions.

Source
Does PostgreSQL support JSON data?

Yes. PostgreSQL supports JSON and JSONB data types for storing and querying JSON documents, along with XML and other document formats.

Source

Behind it

Who makes PostgreSQL?

PostgreSQL is made by PostgreSQL Global Development Group, founded in 1996 and based in Global Open Source Community.

Company
PostgreSQL Global Development Group
Based in
Global Open Source Community
Founders
Michael Stonebraker

Timeline

PostgreSQL over time

  1. Renamed1996-01-01

    Name changed from Postgres95 to PostgreSQL, version reset to 6.0

    Source
  2. Milestone1994-01-01

    Andrew Yu and Jolly Chen added SQL interpreter, creating Postgres95

    Source
  3. Launch1989-06-01

    Version 1 released to external users

    Source
  4. Milestone1987-01-01

    First demoware system became operational

    Source
  5. Founded1986-01-01

    POSTGRES implementation began at UC Berkeley, led by Professor Michael Stonebraker

    Source

Checked against

Sources

The pages the facts above were read from. Prices and limits change, so the vendor's own page is the final word.

Share

Keep looking

Where to go from PostgreSQL

Best Databases software for

Compare PostgreSQL with

Other Databases software

  • The open source relational database for the enterprise

    Free plan16 researched notes
  • Enterprise-grade relational database management system

    Free plan15 researched notes
  • The AI-powered database built for demanding enterprise workloads

    Free, then $99/mo14 researched notes
  • The cloud-native distributed SQL database

    Free plan12 researched notes
  • Fully managed open source data infrastructure cloud

    Free plan13 researched notes
  • Small, fast, self-contained SQL database engine

    Free plan10 researched notes
  • Document-relational database whose hosted service closed in 2025 and whose core is now unmaintained Apache 2.0 code.

    Free plan12 researched notes
  • The MySQL-compatible serverless database

    Free, then $15/mo11 researched notes
  • Apache 2.0 platform for running many Postgres instances on Kubernetes, with copy-on-write branching and scale-to-zero.

    Free plan12 researched notes
  • Enterprise search platform built on Apache Lucene

    Open source10 researched notes
  • Fully managed relational database service for MySQL, PostgreSQL, and SQL Server

    Free plan9 researched notes
  • The modern database for enterprise applications

    Free plan8 researched notes
  • MIT-licensed analytical SQL database that runs inside your process, with no server, no dependencies and one writer at a time.

    Free plan10 researched notes
  • AWS-only managed key-value and document database with fixed per-partition throughput limits and no ad hoc queries.

    Free, then $0.625/million writes10 researched notes
  • Real-time data integration combining streaming, CDC, and batch

    Free, then $0.5/GB12 researched notes
  • Intelligent, scalable cloud database service from Microsoft

    Free plan14 researched notes
  • Stateful stream processing at scale

    Open source8 researched notes

Softwr does not host reviews and shows no star rating for PostgreSQL, because a rating we did not collect is not ours to publish. What is here is the pricing and platform detail from the vendor’s own pages, limitations we could state concretely, and alternatives a reviewer confirmed people weigh against it. Tell us if any of it is wrong.

More on PostgreSQL

Best Databases software alternatives

Industrial process historian with published per-tag pricing and no client licence fees

Per tag band per year

NetApp-owned managed service for Cassandra, Kafka, OpenSearch, PostgreSQL and Cadence with a bring-your-own-cloud model

quote

Erlang MQTT broker for large IoT fleets, relicensed to BSL with production free use limited to one node

Per month by connection and session volume

Attribute-based access control and masking applied inside Snowflake, Databricks and BigQuery

quote

MPP analytical database with a MySQL wire protocol and sub-second aggregation on wide tables

Open source, no licence fee

Streaming database that maintains incremental materialised views in SQL instead of Flink jobs

Per RisingWave Unit hour

Centralised data access governance from the creators of Apache Ranger, now rebranding as Trust3 AI

quote

The Meta-lineage distributed SQL query engine, distinct from the Trino fork

Open source, no licence fee

Compare PostgreSQL with alternatives