Menu
You can get macOS PostgreSQL packages from several different sources.
Interactive installer by EDB
Download the installercertified by EDB for all supported PostgreSQL versions.
Now PostgreSQL server starts running in your MAC OS X and you will see PostgreSQL icon in Top Menu bar. Current default setting is given below Connect directly from command line, type ‘psql’. 2020-09-24 - PostgreSQL 13 Released! The PostgreSQL Global Development Group today announced the release of PostgreSQL 13, the latest version of the world’s most advanced open source database. PostgreSQL 13 includes significant improvements to its indexing and lookup system that benefit large databases, including space savings and performance gains for indexes, faster response times for.
- It includes PostgreSQL, pgAdmin, PL/Java and the PL/pgSQL debugger plugin. Note that this creates a new postgresql user on your system – you may or may not like that. To install, simply download and double click, from here. Homebrew – the much loved “missing package manager for OS X”. In terminal: brew install postgresql.
- Mac OS packages. PostgreSQL is the default database on macOS Server as of OS X Server version 10.7. MacOS without the macOS Server add-on installed includes only the PostgreSQL libpq shared library. Download the latest version of Mac OS X. Launching the installation.
- PATCHING THE SOURCE CODE 10.1 AND LATER USERS ONLY PostgreSQL won't work on Mac OS 10.1 due to changes in the linker and other improvements. So we need to replace 3 of the files that come with the postgreSQL download: Makefile.shlib, ipc.c, and Makefile.darwin.
This installer includes the PostgreSQL server, pgAdmin; a graphical tool for managing and developingyour databases, and StackBuilder; a package manager that can be used to download and installadditional PostgreSQL tools and drivers. Stackbuilder includes management,integration, migration, replication, geospatial, connectors and other tools.
This installer can run in graphical, command line, or silent install modes.
The installer is designed to be a straightforward, fast way to get up and running withPostgreSQL on macOS.
Advanced users can also download azip archiveof the binaries, without the installer.This download is intended for users who wish to include PostgreSQL as part of another application installer.
Platform support
The installers are tested by EDB on the following platforms. They will generally work on newer versions of macOS as well:
PostgreSQL Version | 64-bit macOS Platforms |
---|---|
13 | 10.13 - 10.15 |
12 | 10.12 - 10.14 |
11 | 10.12 - 10.14 |
10 | 10.10 - 10.12 |
9.6 | 10.10 - 10.12 |
9.5 | 10.8 - 10.10 |
Postgres.app
Postgres.app is a simple, native macOS app that runs in the menubar without the need of an installer. Open the app, and you have a PostgreSQL serverready and awaiting new connections. Close the app, and the server shuts down.
Homebrew
PostgreSQL can also be installed on macOSusing Homebrew. Please see the Homebrewdocumentation for information on how to install packages.
A listof PostgreSQLpackages can be found using the Braumeister search tool.
MacPorts
Postgresql Download Mac Os 10.13
PostgreSQL packages are also available for macOS from theMacPorts Project. Please see theMacPorts documentation for information on how to install ports.
A list ofPostgreSQL packagescan be found using the portfiles search tool on the MacPorts website.
Fink
PostgreSQL packages are available for macOS from theFink Project.Please see the Fink documentation for information on how to install packages.
Postgresql Download Mac Os Recovery Tool
A list ofPostgreSQL packagescan be found using the package search tool on the Fink website.
FAQ
Why yet another PostgreSQL GUI client? Why not just pgAdmin?
Well, pgAdmin is great for its feature-richness. However, I found its UI is clumsy and complicated. I know there is a list of PostgreSQL GUI Tools. However, they are either web-based, Java-based* or don't support the features I want. In the good old MySQL world, my favorite client is Sequel Pro, but its support for PostgreSQL doesn't seem to be happening. So, I decided to make one myself.
* No offense to the Java community. I am a Java developer myself and I like JVM a lot. I just dislike Java desktop apps personally.
Is PSequel open source?
No. There is no plan to open source it at this moment.
Is PSequel a forked version of Sequel Pro?
No, PSequel is written from scratch in Swift 2, although PSequel's UI is highly inspired by Sequel Pro.
Why macOS 10.10+ only?
I am developing PSequel in my spare time. By supporting macOS 10.10+ only, I can keep the codebase simpler and save time by not testing it in older versions of macOS. And, less code, less bugs.
What's the current status of PSequel?
PSequel is still in its early stage. My plan to implement most features in Sequel Pro. If you think a feature is important, please let me know and I'll adjust its priority based on its popularity.
How do I report bugs or suggest new features?
Use Github issue tracker. Please try not to create duplicate issues. If you are reporting multiple bugs or suggesting multiple features, please create separate issues for each bug/feature. Please include your macOS, PostgreSQL and PSequel versions when reporting a bug. If you don't have a Github account, you could report bugs here.
How do I support the development of PSequel?
If you like PSequel, please report bugs and/or help spread the word.