-
Latest Version
PostgreSQL 18.2 LATEST
-
Review by
-
Operating System
macOS 10.13 High Sierra or later
-
User Rating
Click to vote -
Author / Product
-
Filename
postgresql-18.2-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:
CVSS v3.1 Base Score: 4.3:
- Supported, Vulnerable Versions: 14 - 18
- Improper validation of type oidvector in PostgreSQL allows a database user to disclose a few bytes of server memory. We have not ruled out viability of attacks that arrange for presence of confidential information in disclosed bytes, but they seem unlikely. Versions before PostgreSQL 18.2, 17.8, 16.12, 15.16, and 14.21 are affected
- The PostgreSQL project thanks Altan Birler for reporting this problem
- CVE-2026-2004: PostgreSQL intarray missing validation of type of input to selectivity estimator executes arbitrary cod
CVSS v3.1 Base Score: 8.8:
- Supported, Vulnerable Versions: 14 - 18
- Missing validation of type of input in PostgreSQL intarray extension selectivity estimator function allows an object creator to execute arbitrary code as the operating system user running the database. Versions before PostgreSQL 18.2, 17.8, 16.12, 15.16, and 14.21 are affected
- The PostgreSQL project thanks Daniel Firer, as part of zeroday.cloud, for reporting this problem
- CVE-2026-2005: PostgreSQL pgcrypto heap buffer overflow executes arbitrary cod
CVSS v3.1 Base Score: 8.8:
- Supported, Vulnerable Versions: 14 - 18
- Heap buffer overflow in PostgreSQL pgcrypto allows a ciphertext provider to execute arbitrary code as the operating system user running the database. Versions before PostgreSQL 18.2, 17.8, 16.12, 15.16, and 14.21 are affected
- The PostgreSQL project thanks Team Xint Code, as part of zeroday.cloud, for reporting this problem
- CVE-2026-2006: PostgreSQL missing validation of multibyte character length executes arbitrary cod
CVSS v3.1 Base Score: 8.8:
- Supported, Vulnerable Versions: 14 - 18
- Missing validation of multibyte character length in PostgreSQL text manipulation allows a database user to issue crafted queries that achieve a buffer overrun. That suffices to execute arbitrary code as the operating system user running the database. Versions before PostgreSQL 18.2, 17.8, 16.12, 15.16, and 14.21 are affected
- The PostgreSQL project thanks Paul Gerste and Moritz Sanft, as part of zeroday.cloud, for reporting this problem
- CVE-2026-2007: PostgreSQL pg_trgm heap buffer overflow writes pattern onto server memor
CVSS v3.1 Base Score: 8.2:
- Supported, Vulnerable Versions: 18
- Heap buffer overflow in PostgreSQL pg_trgm allows a database user to achieve unknown impacts via a crafted input string. The attacker has limited control over the byte patterns to be written, but we have not ruled out the viability of attacks that lead to privilege escalation. PostgreSQL 18.1 and 18.0 are affected
- The PostgreSQL project thanks Heikki Linnakangas for reporting this problem
Bug Fixes and Improvements:
- This update fixes over 65 bugs that were reported in the last several months. The issues listed below affect PostgreSQL 18. Some of these issues may also affect other supported versions of PostgreSQL
- Fix inconsistent case-insensitive text matching in the ltree extension. If you use an index on an ltree column, in some cases you may need perform a reindex. See the "Updating" section for additional instructions
- Executing ALTER TABLE ... ADD CONSTRAINT to add a NOT NULL constraint on a column that already is marked as NOT NULL now requires the constraint name to match the existing constraint name
- Fix trigger behavior when MERGE is executed from a WITH query to include rows affected by the MERGE
- Several query planner fixes
- Fix for text substring search for non-deterministic collations
- Several fixes for NOTIFY error handling and reporting
- Use the correct ordering function in GIN index parallel builds
- Fix incorrect handling of incremental backups with tables larger than 1GB
- Fail recovery if WAL does not exist back to the redo point indicated by the checkpoint record
- Fix for ALTER PUBLICATION to ensure event triggers contain all set options
- Several fixes around replication slot initialization
- Don't advance replication slot after a logical replication parallel worker apply failure to prevent transaction loss on the subscriber
- Fix error reporting for SQL/JSON path type mismatches
- Fix JIT compilation function inlining when using LLVM 17 or later
- Add new server parameter file_extend_method to control use of posix_fallocate()
- Fix psql tab completion for the VACUUM command options
- Fix pg_dump to handle concurrent sequence drops gracefully and to fail if the calling user explicitly lacks privileges to read the sequence
- Several fixes for amcheck around btree inspection
- Avoid crash in pg_stat_statements when an IN list contains both constants and non-constant expressions
OperaOpera 127.0 Build 5778.76
PhotoshopAdobe Photoshop CC 2026 27.3.1
OKXOKX - Buy Bitcoin or Ethereum
WPS OfficeWPS Office
Adobe AcrobatAdobe Acrobat Pro 2025.001.21223
MacKeeperMacKeeper 7.4
MalwarebytesMalwarebytes 5.20.1
TradingViewTradingView - Track All Markets
CleanMyMacCleanMyMac X 5.2.10
AdGuard VPNAdGuard VPN for Mac 2.9.0



Comments and User Reviews