A powerful, open source relational database system

PostgreSQL for Mac
Report    Share

Browse by Company

Adobe, Apowersoft, Autodesk, Avast, Corel, Cyberlink, Google, iMyFone, iTop, Movavi, PassFab, Passper, Tenorshare, Wargaming, Wondershare

PostgreSQL for Mac

  -  342 MB  -  Freeware
Free Download

Safe & Secure

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).

Features and Highlights

Data Types
  • Primitives: Integer, Numeric, String, Boolean
  • Structured: Date/Time, Array, Range, UUID
  • Document: JSON/JSONB, XML, Key-value (Hstore)
  • Geometry: Point, Line, Circle, Polygon
  • Customizations: Composite, Custom Types
Data Integrity
  • UNIQUE, NOT NULL
  • Primary Keys
  • Foreign Keys
  • Exclusion Constraints
  • Explicit Locks, Advisory Locks
Concurrency, Performance
  • Indexing: B-tree, Multicolumn, Expressions, Partial
  • Advanced Indexing: GiST, SP-Gist, KNN Gist, GIN, BRIN, Covering indexes, Bloom filters
  • Sophisticated query planner/optimizer, index-only scans, multicolumn statistics
  • Transactions, Nested Transactions (via savepoints)
  • Multi-Version Concurrency Control (MVCC)
  • Parallelization of reading queries and building B-tree indexes
  • Table partitioning
  • All transaction isolation levels defined in the SQL standard, including Serializable
  • Just-in-time (JIT) compilation of expressions
Reliability, Disaster Recovery
  • Write-ahead Logging (WAL)
  • Replication: Asynchronous, Synchronous, Logical
  • Point-in-time-recovery (PITR), active standbys
  • Tablespaces
Security
  • Authentication: GSSAPI, SSPI, LDAP, SCRAM-SHA-256, Certificate, and more
  • Robust access-control system
  • Column and row-level security
Extensibility
  • Stored functions and procedures
  • Procedural Languages: PL/PGSQL, Perl, Python (and many more)
  • Foreign data wrappers: connect to other databases or streams with a standard SQL interface
  • Many extensions that provide additional functionality, including PostGIS
Internationalization, Text Search
  • Support for international character sets, e.g. through ICU collations
  • Full-text search
How to Use

Run the installer package and follow prompts

Use pgAdmin or Terminal to manage databases

Start the PostgreSQL server via System Preferences

Connect using psql or third-party tools

Create databases and roles as needed

Manage schema using SQL commands

Backup and restore using pg_dump and pg_restore

Secure your setup with user roles and permissions

Update PostgreSQL via Homebrew or official site

System Requirements
  • macOS 10.12 or later
  • 64-bit Intel or Apple Silicon processor
  • Minimum 2 GB RAM
  • At least 150 MB free disk space
  • Administrator privileges for installation
PROS
  • Powerful open-source relational database
  • Full SQL compliance and advanced features
  • Cross-platform and highly extensible
  • Excellent performance and scalability
  • Strong security and role management
CONS
  • GUI tools not included by default
  • Resource heavy for simple projects
  • Fewer visual design tools than rivals
  • Manual tuning needed for best speed
Also Available: Download PostgreSQL for Windows

Download PostgreSQL for Mac Latest Version
Why is this app published on FileHorse? (More info)

  • PostgreSQL 18.3 Screenshots

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

    PostgreSQL 18.3 Screenshot 1
  • PostgreSQL 18.3 Screenshot 2
  • PostgreSQL 18.3 Screenshot 3

What's new in this version:

Fixes and Improvements:
- This update fixes several bugs that were reported since the previous release. The issues listed below affect PostgreSQL 18. Some of these issues may also affect other supported versions of PostgreSQL.
- Fix issue where a standby would halt and return an error "could not access status of transaction".
- Fix error where the substring() function would raise an error "invalid byte sequence for encoding" on non-ASCII text values if the source of that value is a database column
- Fix for the strict_word_similarity function in pg_trgm that could lead to incorrect output or crashes
- Fix function volatility for json_strip_nulls() and jsonb_strip_nulls() to be immutable, like previous releases, allowing for them to be used in indexes. If you previously upgraded to PostgreSQL 18.0 through 18.2, see the additional steps in the "Updating" section.
- Fix for NOT NULL tests in LATERAL UNION ALL subquery that could lead to wrong query output
- Avoid NOT NULL constraints from generating name conflicts with user-written constraints
- Fix pg_stat_get_backend_wait_event() and pg_stat_get_backend_wait_event_type() to report values for auxiliary processes, similar to pg_stat_activity
- Fix casting a composite-type variable to a domain type when returning its value from a PL/pgSQL function
- Fix the hstore binary input function to avoid crashes on input with duplicate keys

Top Downloads

More Popular Software »