A powerful, open source relational database system

PostgreSQL for Mac

PostgreSQL for Mac

  -  363 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.2 Screenshots

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

    PostgreSQL 17.2 Screenshot 1
  • PostgreSQL 17.2 Screenshot 2
  • PostgreSQL 17.2 Screenshot 3

What's new in this version:

The issues listed below affect PostgreSQL 17. Some of these issues may also affect other supported versions of PostgreSQL:
- Restore functionality of ALTER ROLE .. SET ROLE and ALTER DATABASE .. SET ROLE. The fix for CVE-2024-10978 accidentally caused settings for role to not be applied if they came from non-interactive sources, including previous ALTER {ROLE|DATABASE} commands and the PGOPTIONS environment variable.
- Restore compatibility for the timescaledb and other PostgreSQL extensions built using PostgreSQL prior to the 2024-11-14 release (17.0, 16.4, 15.8, 14.13, 13.16, 12.20, and earlier). This fix restores struct ResultRelInfo to its previous size, so that affected extensions don't need to be rebuilt.
- Fix cases where a logical replication slot's restart_lsn could go backwards
- Avoid deleting still-needed WAL files during pg_rewind
- Fix race conditions associated with dropping shared statistics entries, which could lead to loss of statistics data
- Fix crash with ALTER TABLE when checking to see if an index's opclass options have changed if the table has an index with a non-default operator class