PostgreSQL
PostgreSQL
12

5.0

PostgreSQL free download for Mac

PostgreSQL12

04 March 2020

SQL database server.

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 PostgreSQL

Version 12:

Note: Although Finder indicates that this is version 12, the developer states that this is version 12.2.1.

  • Add missing permissions checks for ALTER ... DEPENDS ON EXTENSION (Álvaro Herrera)

    Marking an object as dependent on an extension did not have any privilege check whatsoever. This oversight allowed any user to mark routines, triggers, materialized views, or indexes as droppable by anyone able to drop an extension. Require that the calling user own the specified object (and hence have privilege to drop it). (CVE-2020-1720)

  • Fix TRUNCATE ... CASCADE to ensure all relevant partitions are truncated (Jehan-Guillaume de Rorthais)

    If a partition of a partitioned table is truncated with the CASCADE option, and the partitioned table has a foreign-key reference from another table, that table must also be truncated. The need to check this was missed if the referencing table was itself partitioned, possibly allowing rows to survive that violate the foreign-key constraint.

    Hence, if you have foreign key constraints between partitioned tables, and you have done any partition-level TRUNCATE on the referenced table, you should check to see if any foreign key violations exist. The simplest way is to add a new instance of the foreign key constraint (and, once that succeeds, drop it or the original constraint). That may be prohibitive from a locking standpoint, however, in which case you might prefer to manually query for unmatched rows.

  • Fix failure to attach foreign key constraints to sub-partitions (Jehan-Guillaume de Rorthais)

    When adding a partition to a level below the first level of a multi-level partitioned table, foreign key constraints referencing the top partitioned table were not cloned to the new partition, leading to possible constraint violations later. Detaching and re-attaching the new partition is the cheapest way to fix this. However, if there are many partitions to be fixed, adding a new instance of the foreign key constraint might be preferable.

  • Fix possible crash during concurrent update on a partitioned table or inheritance tree (Tom Lane)

  • Ensure that row triggers on partitioned tables are correctly cloned to sub-partitions when appropriate (Álvaro Herrera)

    User-defined triggers (but not triggers for foreign key or deferred unique constraints) might be missed when creating or attaching a partition.

  • Fix logical replication subscriber code to execute per-column UPDATE triggers when appropriate (Peter Eisentraut)

  • Avoid failure in logical decoding when a large transaction must be spilled into many separate temporary files (Amit Khandekar)

  • Fix possible crash or data corruption when a logical replication subscriber processes a row update (Tom Lane, Tomas Vondra)

    This bug caused visible problems only if the subscriber's table contained columns that were not being copied from the publisher and had pass-by-reference data types.

  • Fix crash in logical replication subscriber after DDL changes on a subscribed relation (Jehan-Guillaume de Rorthais, Vignesh C)

  • Fix failure in logical replication publisher after a database crash and restart (Vignesh C)

  • Ensure that the effect of pg_replication_slot_advance() on a physical replication slot will persist across restarts (Alexey Kondratov, Michael Paquier)

  • Improve efficiency of logical replication with REPLICA IDENTITY FULL (Konstantin Knizhnik)

    When searching for an existing tuple during an update or delete operation, return the first matching tuple not the last one.

  • Fix base backup to handle database OIDs larger than INT32_MAX (Peter Eisentraut)

  • Ensure parallel plans are always shut down at the correct time (Kyotaro Horiguchi)

    This oversight is known to result in temporary file leak warnings from multi-batch parallel hash joins.

  • Prevent premature shutdown of a Gather or GatherMerge plan node that is underneath a Limit node (Amit Kapila)

    This avoids failure if such a plan node needs to be scanned more than once, as for instance if it is on the inside of a nestloop.

  • Improve efficiency of parallel hash join on CPUs with many cores (Gang Deng, Thomas Munro)

  • Avoid crash in parallel CREATE INDEX when there are no free dynamic shared memory slots (Thomas Munro)

    Fall back to a non-parallel index build, instead.

  • Avoid memory leak when there are no free dynamic shared memory slots (Thomas Munro)

  • Ignore the CONCURRENTLY option when performing an index creation, drop, or rebuild on a temporary table (Michael Paquier, Heikki Linnakangas, Andres Freund)

    This avoids strange failures if the temporary table has an CONCURRENTLY for a temporary table anyway, since other sessions cannot access the table, making the extra processing pointless.

  • Fix possible failure when resetting expression indexes on temporary tables that are marked ON COMMIT DELETE ROWS (Tom Lane)

  • Fix possible crash in BRIN index operations with inet data types (Heikki Linnakangas)

  • Fix crash during recursive page split in GiST index build (Heikki Linnakangas)

  • Fix handling of deleted pages in GIN indexes (Alexander Korotkov)

    Avoid possible deadlocks, incorrect updates of a deleted page's state, and failure to traverse through a recently-deleted page.

  • Fix possible crash with a SubPlan (sub- VALUES list (Tom Lane)

  • Fix failure in ALTER TABLE when a column referenced in a GENERATED expression has been added or changed in type earlier in the same ALTER command (Tom Lane)

  • Fix failure to insert default values for missing attributes during tuple conversion (Vik Fearing, Andrew Gierth)

    This could result in values incorrectly reading as NULL, when they come from columns that had been added by ALTER TABLE ADD COLUMN with a constant default.

  • Fix unlikely panic in the checkpointer process, caused by opening relation segments that might already have been removed (Thomas Munro)

  • Fix crash after FileClose() failure (Noah Misch)

    This issue could only be observed with data_sync_retry enabled, since otherwise FileClose() failure would be reported as a PANIC.

  • Fix handling of multiple AFTER ROW triggers on a foreign table (Etsuro Fujita)

  • Fix unlikely crash with pass-by-reference aggregate transition states (Andres Freund, Teodor Sigaev)

  • Improve error reporting in to_timestamp() (Tom Lane, Álvaro Herrera)

    Reports about incorrect month or day names in input strings could truncate the input in the middle of a multi-byte character, leading to an improperly encoded error message that could cause follow-on failures. Truncate at the next whitespace instead.

  • Fix off-by-one result for timestamp ) for BC dates (Tom Lane)

  • Ensure that the cache lookup failed for collation 0 ” (Tom Lane)

    undefined
  • undefined
  • Avoid treating TID scans as sequential scans (Tatsuhito Kasahara)

    A refactoring oversight caused TID scans (selection by CTID) to be counted as sequential scans in the statistics views, and to take whole-table predicate locks as sequential scans do. The latter behavior could cause unnecessary serialization errors in serializable transaction mode.

    undefined
  • undefined
  • Avoid stack overflow in information_schema views when a self-referential view exists in the system catalogs (Tom Lane)

    A self-referential view can't work; it will always result in infinite recursion. We handled that situation correctly when trying to execute the view, but not when inquiring whether it is automatically updatable.

    undefined
  • undefined
  • Ensure that walsender processes always show NULL for transaction start time in pg_stat_activity (Álvaro Herrera)

    Previously, the xact_start column would sometimes show the process start time.

    undefined
  • undefined
  • Improve performance of hash joins with very large inner relations (Thomas Munro)

    undefined
  • undefined
  • Reduce spinlock contention when there are many active walsender processes (Pierre Ducroquet)

    undefined
  • undefined
  • Fix placement of Subplans Removed field in EXPLAIN output (Daniel Gustafsson, Tom Lane)

    In non-text output formats, this field was emitted inside the Plans sub-group, resulting in syntactically invalid output. Attach it to the parent Append or MergeAppend plan node as intended. This causes the field to change position in text output format too: if there are any InitPlans attached to the same plan node, Subplans Removed will now appear before those.

    undefined
  • undefined
  • Fix EXPLAIN's SETTINGS option to print as empty in non-text output formats (Tom Lane)

    In the non-text output formats, fields are supposed to appear when requested, even if they have empty or zero values.

    undefined
  • undefined
  • Allow the planner to apply potentially-leaky tests to child-table statistics, if the user can read the corresponding column of the table that's actually named in the query (Dilip Kumar, Amit Langote)

    This change fixes a performance problem for partitioned tables that was created by the fix for CVE-2017-7484. That security fix disallowed applying leaky operators to statistics for columns that the current user doesn't have permission to read directly. However, it's somewhat common to grant permissions only on the parent partitioned table and not bother to do so on individual partitions. In such cases, the user can read the column via the parent, so there's no point in this security restriction; it only results in poorer planner estimates than necessary.

    undefined
  • undefined
  • Fix planner errors induced by overly-aggressive collapsing of joins to single-row subqueries (Tom Lane)

    This mistake led to errors such as failed to construct the join relation.

    undefined
  • undefined
  • Fix no = operator for opfamily NNNN planner error when trying to match a LIKE or regex pattern-match operator to a binary-compatible index opclass (Tom Lane)

    undefined
  • undefined
  • Fix edge-case crashes and misestimations in selectivity calculations for the @> range operators (Michael Paquier, Andrey Borodin, Tom Lane)

    undefined
  • undefined
  • Fix incorrect estimation for OR clauses when using most-common-value extended statistics (Tomas Vondra)

    undefined
  • undefined
  • Ignore system columns when applying most-common-value extended statistics (Tomas Vondra)

    This prevents negative bitmapset member not allowed planner errors for affected queries.

    undefined
  • undefined
  • Fix BRIN index logic to support hypothetical BRIN indexes (Julien Rouhaud, Heikki Linnakangas)

    Previously, if an index adviser extension tried to get the planner to produce a plan involving a hypothetical BRIN index, that would fail, because the BRIN cost estimation code would always try to physically access the index's metapage. Now it checks to see if the index is only hypothetical, and uses default assumptions about the index parameters if so.

    undefined
  • undefined
  • Improve error reporting for attempts to use automatic updating of views with conditional INSTEAD rules (Dean Rasheed)

    This has never been supported, but previously the error was thrown only at execution time, so that it could be masked by planner errors.

    undefined
  • undefined
  • Prevent a composite type from being included in itself indirectly via a range type (Tom Lane, Julien Rouhaud)

    undefined
  • undefined
  • Disallow partition key expressions that return pseudo-types, such as record (Tom Lane)

    undefined
  • undefined
  • Fix error reporting for index expressions of prohibited types (Amit Langote)

    undefined
  • undefined
  • Fix dumping of views that contain only a VALUES list to handle cases where a view output column has been renamed (Tom Lane)

    undefined
  • undefined
  • Ensure that data types and collations used in XMLTABLE constructs are accounted for when computing dependencies of a view or rule (Tom Lane)

    Previously it was possible to break a view using XMLTABLE by dropping a type, if the type was not otherwise referenced in the view. This fix does not correct the dependencies already recorded for existing views, only for newly-created ones.

    undefined
  • undefined
  • Prevent unwanted downcasing and truncation of RADIUS authentication parameters (Marcos David)

    The pg_hba.conf parser mistakenly treated these fields as SQL identifiers, which in general they aren't.

    undefined
  • undefined
  • Transmit incoming NOTIFY messages to the client before sending ReadyForQuery, rather than after (Tom Lane)

    This change ensures that, with libpq and other client libraries that act similarly to it, any notifications received during a transaction will be available by the time the client thinks the transaction is complete. This probably makes no difference in practical applications (which would need to cope with asynchronous notifications in any case); but it makes it easier to build test cases with reproducible behavior.

    undefined
  • undefined
  • Fix bugs in handling of non-blocking I/O when using GSSAPI encryption (Tom Lane)

    These errors could result in dropping data (usually leading to subsequent wire-protocol-violation errors) or in a livelock situation where a sending process goes to sleep although not all its data has been sent. Moreover, libpq failed to keep separate encryption state for each connection, creating the possibility for failures in applications using multiple encrypted database connections.

    undefined
  • undefined
  • Allow libpq to parse all GSS-related connection parameters even when the GSSAPI code hasn't been compiled in (Tom Lane)

    This makes the behavior similar to our SSL support, where it was long ago deemed to be a good idea to always accept all the related parameters, even if some are ignored or restricted due to lack of the feature in a particular build.

    undefined
  • undefined
  • Fix incorrect handling of PGTYPEStimestamp_fmt_asc() function (Tomas Vondra)

    Due to an off-by-one error, these codes would print the wrong month name, or possibly crash.

    undefined
  • undefined
  • Avoid crash after an out-of-memory failure in ecpglib (Tom Lane)

    undefined
  • undefined
  • Fix parallel pg_dump/ pg_restore to more gracefully handle failure to create worker processes (Tom Lane)

    undefined
  • undefined
  • Prevent possible crash or lockup when attempting to terminate a parallel pg_dump/ pg_restore run via a signal (Tom Lane)

    undefined
  • undefined
  • In pg_upgrade, look inside arrays and ranges while searching for non-upgradable data types in tables (Tom Lane)

    undefined
  • undefined
  • Apply more thorough syntax checking to createuser's --connection-limit option (Álvaro Herrera)

    undefined
  • undefined
  • Cope with changes of the specific type referenced by a PL/pgSQL composite-type variable in more cases (Ashutosh Sharma, Tom Lane)

    Dropping and re-creating the composite type referenced by a PL/pgSQL variable could lead to could not open relation with OID NNNN errors.

    undefined
  • undefined
  • Avoid crash in UPDATE remote_tab SET (x,y) = (SELECT ...) to the remote server (Tom Lane)

    undefined
  • undefined
  • In maxlen settings less than one (Tomas Vondra)

    This prevents a possible crash with silly settings for that parameter.

    undefined
  • undefined
  • Disallow NULL category values in crosstab() function (Joe Conway)

    This case never worked usefully, and it would crash on some platforms.

    undefined
  • undefined
  • Fix configure's probe for OpenSSL's SSL_clear_options() function so that it works with OpenSSL versions before 1.1.0 (Michael Paquier, Daniel Gustafsson)

    This problem could lead to failure to set the SSL compression option as desired, when PostgreSQL is built against an old version of OpenSSL.

    undefined
  • undefined
  • Avoid memory leak in sanity checks for slab memory contexts (Tomas Vondra)

    This isn't an issue for production builds, since they wouldn't ordinarily have memory context checking enabled; but the leak could be quite severe in a debug build.

    undefined
  • undefined
  • Fix multiple statistics entries reported by the LWLock statistics mechanism (Fujii Masao)

    The LWLock statistics code (which is not built by default; it requires compiling with -DLWLOCK_STATS) could report multiple entries for the same LWLock and backend process, as a result of faulty hashtable key creation.

    undefined
  • undefined

Related articles

Join over 500,000 subscribers.

Subscribe for our newsletter with best Mac offers from MacUpdate.

How would you rate PostgreSQL app?

10 Reviews of PostgreSQL

2
Joseluismen
29 October 2018
Version: 11.0

Most helpful

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?
(1)
2
Joseluismen
29 October 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?
(1)
Nosuchname
07 October 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.
(0)
Show comment (1)
SickTeddyBear
24 September 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/
(3)
Show comments (2)
5
Cascalheira
14 March 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.
(1)
Thigre
19 March 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
(2)
Teksestro
16 November 2008
Version: 8.3.5
Developer, please note: 1) uninstaller is missing 2) query tool installed by default (during the server install) is BAD - it seems to have been compiled as a PPC only, and not as a universal binary, so it won't run on my Intel machine. 3) documentation provided needs urgent updating, including: instructions for manual uninstall (in case the uninstaller goes missing again, or user is unable to run it), instructions for drag-install of client tools, and a basic troubleshooting guide (telling users what to do if the server does not seem to launch) Your efforts to bring PostgreSQL to the Mac are certainly appreciated. Please, keep up the good work.
(2)
Imre-Fazekas
14 November 2008
Version: 8.3.5
I don't find a proper uninstaller for this package. How can i achieve this?
(1)
Sjf
07 November 2007
Version: 8.2.5
On my system, Query Tool for Postgres, and Create User both crash immediately. The other three tools (Create & Backup Database and Service Manager) seem to work ok. Crash log follows... 11/7/07 3:25:53 PM com.apple.launchd[211] ([0x0-0x44044].com.druware.postgresql.CreateUser[2005]) Exited abnormally: Trace/BPT trap 11/7/07 3:29:10 PM [0x0-0x47047].com.druware.postgres.QueryTool[2019] dyld: Library not loaded: @executable_path/../Frameworks/pgCocoaDB.framework/Versions/A/pgCocoaDB 11/7/07 3:29:10 PM [0x0-0x47047].com.druware.postgres.QueryTool[2019] Referenced from: /Applications/PostgreSQL/Query Tool for Postgres.app/Contents/MacOS/Query Tool for Postgres 11/7/07 3:29:10 PM [0x0-0x47047].com.druware.postgres.QueryTool[2019] Reason: image not found 11/7/07 3:29:10 PM com.apple.launchd[211] ([0x0-0x47047].com.druware.postgres.QueryTool[2019]) Exited abnormally: Trace/BPT trap 11/7/07 3:29:29 PM [0x0-0x4a04a].com.druware.postgresql.CreateUser[2026] dyld: Library not loaded: @executable_path/../Frameworks/pgCocoaDB.framework/Versions/A/pgCocoaDB 11/7/07 3:29:29 PM [0x0-0x4a04a].com.druware.postgresql.CreateUser[2026] Referenced from: /Applications/PostgreSQL/Create User.app/Contents/MacOS/Create User 11/7/07 3:29:29 PM [0x0-0x4a04a].com.druware.postgresql.CreateUser[2026] Reason: image not found
(0)
Dru-satori
11 October 2007
Version: 8.2.5
Both downloads on both download locations have been updated to fix this (boneheaded) issue. The problem was twofold. The build machine had an errant copy of the binaries that included a bad build, and the final copy phase had an issue on several of the GUI tools. Both problems have been resolved. Sorry for the confusion.
(0)
Dogbert1
11 October 2007
Version: 8.2.5
This version does not install as "universal" , it installs as intel only.
(0)
Show comments (4)