Here are the top 5 tools from the Which is the Best PostgreSQL GUI post, all of which support Mac OS X: 1. PgAdmin (free, open source) 2. DBeaver (free community, $149 standard license) 3. Navicat ($89 up to $239 per license) 4. DataGrip ($89 to $. Stack Exchange network consists of 177 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share.
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 PostgreSQLlibpq shared library.
macOS Server 10.12 ships with PostgreSQL 9.4. Minor updates are providedby Apple, but not necessarily right after a new PostgreSQL minor release.
There are several other installers available for PostgreSQL on macOS,which is the recommended way to install.
Best Mac Os X Software
Interactive installer by EDB
Download the installercertified by EDB for all supported PostgreSQL versions.
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 |
|---|---|
| 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.
Fink
PostgreSQL packages are available for macOS from theFink Project.Please see the Fink documentation for information on how to install packages.
A list ofPostgreSQL packagescan be found using the package search tool on the Fink website.
MacPorts
PostgreSQL packages are also available for macOS from theMacPorts Project. Please see theMacPorts documentation for information on how to install ports.
What Are The Best Mac Os X Guis For Postgresql 10
A list ofPostgreSQL packagescan be found using the portfiles search tool on the MacPorts website.
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.