PostgreSQL
The open-source relational database with 35 years behind it, known for correctness, extensibility and a long feature list.
These buttons open the developer's own site, repository or store listing in a new tab. wares.gg does not host downloads.
3 more ways to get PostgreSQL
Package managers
- winget
winget install --id PostgreSQL.PostgreSQL - Chocolatey
choco install postgresql - Snap Store
snap install postgresql
About PostgreSQL
PostgreSQL is an object-relational database with an unusually strong reputation for getting things right: strict standards compliance, real transactional DDL, proper constraint enforcement, and a planner that handles complicated queries well. It has been in active development for over 35 years.
The extensibility is a large part of why it has spread. Custom types, operators, index methods and procedural languages are all supported, and extensions such as PostGIS for geospatial work and pgvector for embeddings are the standard tools in their fields. Supported versions get regular security and bug-fix releases across five major branches at once.
Strengths
- Over 35 years of development with a strong reputation for reliability and correctness
- Extensible with custom types, index methods and procedural languages; PostGIS and pgvector are built on that
- Five major versions supported at once with regular security and bug-fix releases
- A permissive licence with no commercial restrictions
Limitations
- Default configuration is conservative and needs tuning for real workloads
- Built-in replication and failover require third-party tooling to become a full HA setup
- Connection handling benefits from a pooler such as PgBouncer under load
- Upgrading between major versions requires planning, not just a package update
Details
- Pricing
- Free · Free and open source under the PostgreSQL Licence, a permissive licence similar to BSD and MIT.
- License
- PostgreSQL
- Developer
- PostgreSQL Global Development Group
- Platforms
- Windows, macOS, Linux, Self-hosted
- How it runs
- Downloadable app, Self-hosted
- Account
- Not required
- Works offline
- Yes
- Best suited for
- The relational database to reach for when you do not have a specific reason to use another
- Categories
- Database tools
- Last verified
- Added
- Provenance
- Selected from the TechWalrus downloads catalog (Dev Tools); facts checked against the developer's own pages, 2 sources on file.