We stand with Ukraine to help keep people safe. Join us
PostgreSQL
PostgreSQL
4.0
0.0
PostgreSQL free download for Mac

PostgreSQL

Version 15.1

SQL database server.

4.0
Based on 3 user ratesRead reviews & comments
Free
Absolutely Free

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 15.1

Updated on Jan 03 2023

  • Fix handling of DEFAULT tokens that appear in a multi-row VALUES clause of an INSERT on an updatable view (Tom Lane)
  • This oversight could lead to “cache lookup failed for type” errors, or in older branches even to crashes.
  • Disallow rules named _RETURN that are not ON SELECT (Tom Lane)
  • This avoids confusion between a view's ON SELECT rule and any other rules it may have.
  • Avoid failure in EXPLAIN VERBOSE for a query using SEARCH BREADTH FIRST with constant initial values (Tom Lane)
  • Prevent use of MERGE on a partitioned table with foreign-table partitions (Álvaro Herrera)
  • The case isn't supported, and previously threw an incomprehensible error.
  • Fix construction of per-partition foreign key constraints while doing ALTER TABLE ATTACH PARTITION (Jehan-Guillaume de Rorthais, Álvaro Herrera)
  • Previously, incorrect or duplicate constraints could be constructed for the newly-added partition.
  • Fix planner failure with extended statistics on partitioned or inherited tables (Richard Guo, Justin Pryzby)
  • Some cases failed with “cache lookup failed for statistics object”.
  • Fix mis-ordering of WAL operations in fast insert path for GIN indexes (Matthias van de Meent, Zhang Mingli)
  • This mistake is not known to have any negative consequences within core PostgreSQL, but it did cause issues for some extensions.

Full list of changes available here

Information

License

Free

Size

313.8 MB

Developer’s website

https://www.postgresql.org/

Downloads

18234

App requirements

  • Intel 64
  • macOS 10.14 or later
Try our new feature and write a detailed review about PostgreSQL. All reviews will be posted soon.
Write your thoughts in our old-fashioned comment
MacUpdate Comment Policy. We strongly recommend leaving comments, however comments with abusive words, bullying, personal attacks of any type will be moderated.
0.0
(0 Reviews of )
There are no reviews yet
Joseluismen
Joseluismen
Oct 29 2018
11.0
2.0
Oct 29 2018
2.0
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?
Nosuchname
Nosuchname
Oct 7 2010
9.0.1
0.0
Oct 7 2010
0.0
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.
SickTeddyBear
SickTeddyBear
Sep 24 2010
9.0.0
0.0
Sep 24 2010
0.0
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/
Cascalheira
Cascalheira
Mar 14 2010
8.4.2
5.0
Mar 14 2010
5.0
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.
Thigre
Thigre
Mar 19 2009
8.3.5
0.0
Mar 19 2009
0.0
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
Teksestro
Teksestro
Nov 16 2008
8.3.5
0.0
Nov 16 2008
0.0
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.
Imre-Fazekas
Imre-Fazekas
Nov 14 2008
8.3.5
0.0
Nov 14 2008
0.0
Version: 8.3.5
I don't find a proper uninstaller for this package. How can i achieve this?
Sjf
Sjf
Nov 7 2007
8.2.5
0.0
Nov 7 2007
0.0
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
Dru-satori
Dru-satori
Oct 11 2007
8.2.5
0.0
Oct 11 2007
0.0
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.
Dogbert1
Dogbert1
Oct 11 2007
8.2.5
0.0
Oct 11 2007
0.0
Version: 8.2.5
This version does not install as "universal" , it installs as intel only.
Free
Absolutely Free
How would you rate PostgreSQL?
Similar apps
TablePlus
Modern, native tool for relational databases.
Is this app is similar to TablePlus? Vote to improve the quality of this list.
Vote results
1
Upvotes
1
Total score
0
Downvotes
MySQL
Industry-leading open-source SQL database.
Is this app is similar to MySQL? Vote to improve the quality of this list.
Vote results
1
Upvotes
1
Total score
0
Downvotes
Panorama X
Modern database solution.
Is this app is similar to Panorama X? Vote to improve the quality of this list.
Vote results
0
Upvotes
1
Total score
0
Downvotes
SQLPro for Postgres
Database management studio for Postgres.
Is this app is similar to SQLPro for Postgres? Vote to improve the quality of this list.
Vote results
1
Upvotes
1
Total score
0
Downvotes
Postico
A modern PostgreSQL client.
Is this app is similar to Postico? Vote to improve the quality of this list.
Vote results
0
Upvotes
1
Total score
0
Downvotes