PostgreSQL for Mac
SQL database server.
Free
In English
Version 18.3When you purchase through links on our site, we may earn an affiliate commission
PostgreSQL overview
PostgreSQL for Mac is a collection of graphical tools for using and managing PostgreSQL servers, as well as the server itself installable on any Mac running OS X version 10.5.x.
Also included as part of the package is the PGSQLKit framework, an open source framework for developers to leverage the power of PostgreSQL in their own applications.
After many years of development, PostgreSQL has become feature-complete in many areas. This release shows a targeted approach to adding features (e.g., authentication, monitoring, space reuse), and adds capabilities defined in the later SQL standards.
What’s new in version 18.3
- Fix failure after replaying a multixid truncation record from Wal that was generated by an older minor version (Heikki Linnakangas) § Errôneous logic for coping with the way that previous versions handled multixid wraparound led to replay failure, with messages like “could not access status of transaction”. A typical scenario in which this could occur is a standby server of the latest minor version consuming Wal from a primary server of an older version.
- Avoid incorrect complaint of invalid encoding when substring() is applied to “toasted” data (Noah Misch) § § § The fix for Cve-2026-2006 was too aggressive and could raise an error about an incomplete character in cases that are actually valid.
- Fix oversight in the fix for Cve-2026-2007 (Zsolt Parragi) § If the “bounds” array needed to be expanded, because the input contained more trigrams than the initial guess, generate_trgm_only didn't return the modified array pointer to its caller. That would lead to incorrect output from strict_word_similarity() and related functions, or in rare cases a crash. The faulty code is reached if the input string becomes longer when it's converted to lower case. The only known instances of that occur when an Icu locale is used with certain single-byte encodings.
- Fix the volatility marking of json_strip_nulls() and jsonb_strip_nulls() (Andrew Dunstan) § These functions have always been considered immutable, but refactoring in version 18 accidentally marked them stable instead. That prevents their use in index expressions and could cause unnecessary repeat evaluations in queries. This fix corrects the marking in newly-initialized database clusters (including clusters that are pg_upgrade'd to 18.3 or later). However it will not help existing clusters made using 18.0 through 18.2. If this mistake affects your usage of these functions, the recommended fix for an existing cluster is a manual catalog update. As superuser, perform Update pg_catalog.pg_proc Set provolatile = 'i' Where oid In ('3261','3262'); in each affected database. Update template0 and template1 as well, so that databases made in future will have the fix.
- Fix computation of the set of potentially-nulling outer joins for the output of a Lateral union all subquery (Richard Guo) § This error could lead to skipping Null tests in the mistaken belief that they were unnecessary, resulting in wrong query output.
- Avoid name collisions between user-written constraints and automatically-named Not null constraints (Laurenz Albe) § As of version 18, Not null constraints have full-fledged pg_constraint entries, and therefore require names. The logic for choosing a name for an unnamed Not null constraint failed to avoid conflicts with user-written constraints elsewhere in the same Create table statement.
- Fix pg_stat_get_backend_wait_event() and pg_stat_get_backend_wait_event_type() to report values for auxiliary processes (Heikki Linnakangas) § Previously these functions returned Null for auxiliary processes, but that's inconsistent with the pg_stat_activity view.
- Fix casting a composite-type variable to a domain type when returning its value from a PL/pgSQL function (Tom Lane) § If the variable's value is Null, a “cache lookup failed for type 0” error resulted.
- Fix potential null pointer dereference in contrib/hstore's binary input function (Michael Paquier) § hstore's receive function crashed on input containing duplicate keys. hstore values generated by Postgres would never contain duplicate keys, so this mistake has gone unnoticed. The crash could be provoked by malicious or corrupted data.
PostgreSQL for Mac
Free
In English
Version 18.3
Write a detailed review about PostgreSQL
(10 Reviews of PostgreSQL)
Comments
User Ratings
Oct 29 2018
Version: 11.0
Support for version 11 includes 10.12 to 10.14 only. For version 10, it goes from 10.10 to 10.12. At least in the primary installers, the offers by EnterpriseDB. Is this due to the included extras, or directly by PostgresSQL?
Oct 7 2010
Version: 9.0.1
The download link points to the 9.0.0 version not 9.0.1. You have to go to the developer's site to download the current version.
Sep 24 2010
Version: 9.0.0
1. The title of this entry should specifically say "PostgreSQL for Mac" in order to distiguish it from any official PostgreSQL listing.
2. If you're going to download or link to this, it's better to do it from their SourceForge page because their web site isn't as speedy:
http://sourceforge.net/projects/pgsqlformac/
Mar 15 2010
Version: 8.4.2
Indeed the easiest way to install Postgres on a Mac. And it has a proper control panel to start/stop the database.
Mar 20 2009
Version: 8.3.5
By far the easiest way to have an postgreSQL server running in no time... And I am using mine intensively since then ;-)
Great job
