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.
PgAdmin is a free, open-source PostgreSQL database administration GUI for Microsoft Windows, Apple Mac OS X and Linux systems. It offers excellent capabilities with regard to database server information retrieval, development, testing, and ongoing maintenance. PgAdmin 4 is a ground-up rewrite of pgAdmin 3. Rather than being a native application it's primarily a web application that's also packaged as desktop web shell. At the time of writing it's considered inferior to pgAdmin 3 both in terms of functionality and stability. PgAdmin3 1.20.0 - Administration and development for PostgreSQL database. Download the latest versions of the best Mac apps at safe and trusted MacUpdate Download, install, or update pgAdmin3 for Mac from MacUpdate.
Ftp Client For Mac
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.
Interactive installer by EnterpriseDB
Download the installercertified by EnterpriseDB 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.
The installers are tested by EnterpriseDB on the following platforms. They will generally work on newer versions of macOS as well:
|PostgreSQL Version||64-bit macOS Platforms|
|11||10.12 - 10.14|
|10||10.10 - 10.12|
|9.6||10.10 - 10.12|
|9.5||10.8 - 10.10|
|9.4||10.6 - 10.9|
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.
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.
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.
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.