A powerful, open source relational database system

PostgreSQL for Mac

PostgreSQL for Mac

  -  367 MB  -  Freeware
PostgreSQL for Mac is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. PostgreSQL for macOS is the default database on Mac OS X Server as of version 10.7.

It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation (table sizes can go up to 32 TB).

Also Available: Download PostgreSQL for Windows

  • PostgreSQL 17.0 Screenshots

    The images below have been resized. Click on them to view the screenshots in full size.

    PostgreSQL 17.0 Screenshot 1
  • PostgreSQL 17.0 Screenshot 2
  • PostgreSQL 17.0 Screenshot 3

What's new in this version:

- New memory management system for VACUUM, which reduces memory consumption and can improve overall vacuuming performance
- New SQL/JSON capabilities, including constructors, identity functions, and the JSON_TABLE() function, which converts JSON data into a table representation
- Various query performance improvements, including for sequential reads using streaming I/O, write throughput under high concurrency, and searches over multiple values in a btree index
- New client-side connection option, sslnegotiation=direct, that performs a direct TLS handshake to avoid a round-trip negotiation
- pg_basebackup now supports incremental backup
- COPY adds a new option, ON_ERROR ignore, that allows a copy operation to continue in the event of an error

Logical replication enhancements, including:
- Failover control
- pg_createsubscriber, a utility that creates logical replicas from physical standbys
- pg_upgrade now preserves replication slots on both publishers and subscribers