-
Latest Version
PostgreSQL 17.4 LATEST
-
Review by
-
Operating System
macOS 10.13 High Sierra or later
-
User Rating
Click to vote -
Author / Product
-
Filename
postgresql-17.4-1-osx.dmg
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
- UNIQUE, NOT NULL
- Primary Keys
- Foreign Keys
- Exclusion Constraints
- Explicit Locks, Advisory Locks
- 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
- Write-ahead Logging (WAL)
- Replication: Asynchronous, Synchronous, Logical
- Point-in-time-recovery (PITR), active standbys
- Tablespaces
- Authentication: GSSAPI, SSPI, LDAP, SCRAM-SHA-256, Certificate, and more
- Robust access-control system
- Column and row-level security
- 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
- Support for international character sets, e.g. through ICU collations
- Full-text search
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
- 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
- GUI tools not included by default
- Resource heavy for simple projects
- Fewer visual design tools than rivals
- Manual tuning needed for best speed
What's new in this version:
- Improve behavior of libpq's quoting functions
- The changes made for CVE-2025-1094 had one serious oversight: PQescapeLiteral() and PQescapeIdentifier() failed to honor their string length parameter, instead always reading to the input string's trailing null. This resulted in including unwanted text in the output, if the caller intended to truncate the string via the length parameter. With very bad luck it could cause a crash due to reading off the end of memory.
- In addition, modify all these quoting functions so that when invalid encoding is detected, an invalid sequence is substituted for just the first byte of the presumed character, not all of it. This reduces the risk of problems if a calling application performs additional processing on the quoted string.
- Fix small memory leak in pg_createsubscriber
- Fix meson build system to correctly detect availability of the bsd_auth.h system header
OperaOpera 118.0 Build 5461.41
PhotoshopAdobe Photoshop CC 2024 25.12
OKXOKX - Buy Bitcoin or Ethereum
BlueStacksBlueStacks Air 5.21.650
Adobe AcrobatAdobe Acrobat Pro 2025.001.20458
Hero WarsHero Wars - Online Action Game
ParallelsParallels Desktop 20.2.2
SemrushSemrush - Keyword Research Tool
CleanMyMacCleanMyMac X 5.0.6
4DDiG4DDiG Mac Data Recovery 5.2.2
Comments and User Reviews