Database
PostgreSQL: supported versions and end-of-life dates today
PostgreSQL 18, 17, 16, 15 and 14 are supported (14 until Nov 12, 2026); 13 reached end of life on Nov 13, 2025; the latest release is 18.6.
Last checked against endoflife.date and deps.dev.
- Latest release
- 18.6
- GitHub stars
- 22.4k
- OpenSSF Scorecard
- 6.1 / 10
Supported versions
Maintenance and supply chain
OpenSSF Scorecard 6.1 / 10 (scored )
The Scorecard rates the repository’s security practices, not known vulnerabilities. Recent activity: 30 commits and 0 issue updates found in the last 90 days.
Weakest checks
- Little code review (Code-Review 0/10)
- No branch protection (Branch-Protection 0/10)
- Unpinned build dependencies (Pinned-Dependencies 0/10)
Production checklist
PostgreSQL production checklist: 5 checks before launch
- Must do: Automated backups with point-in-time recovery, and a tested restore
- Should do: Put a connection pooler in front (e.g. PgBouncer)
- Should do: Require TLS for client connections
Alternatives
MySQL
Popular open-source relational database optimized for web applications
Strengths
- Widely adopted with extensive documentation
- Fast for read-heavy workloads
Trade-offs
- Less advanced features than PostgreSQL
- Some storage engines lack full ACID compliance
MariaDB
MySQL fork with enhanced features and better performance
Strengths
- Drop-in replacement for MySQL
- Better performance optimizations
Trade-offs
- Some compatibility issues with MySQL plugins
- Smaller community than MySQL/PostgreSQL
Amazon Aurora
AWS-managed MySQL/PostgreSQL-compatible database
Strengths
- MySQL/PostgreSQL compatibility
- 5x faster than standard MySQL
Trade-offs
- AWS vendor lock-in
- Limited to AWS regions
CockroachDB
Distributed SQL database designed for cloud-native applications
Strengths
- Horizontal scalability with no manual sharding
- Strong consistency with geo-replication
Trade-offs
- Higher latency than single-node databases
- More complex to operate than PostgreSQL
Example stacks with PostgreSQL
Docs and release notes
Check PostgreSQL in your own stack
This page checks PostgreSQL in general. Your repo pins specific versions: the free dependency check reads your manifests and lists what to fix first. Prism Agent runs the same live checks on your whole stack and turns them into a plan your coding agent can build.