OpenSUSE PostGIS 2.1 For OpenSUSE 13.1, 12.3, Tumbleweed, SUSE SLE-11 SP 3 Distributions targeting more than one OS (these include PostgreSQL and many other PostgreSQL extensions) EnterpriseDb PostgreSQL - Supports 32-bit/64-bit Linux, MacOSX, Windows Note that the MacOSX PostGIS package and EDB Windows PostGIS package have different. Free download pgAdmin3 pgAdmin3 for Mac OS X. PgAdmin3 - pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world. A macOS App Bundle containing the pgAdmin 4 Desktop Runtime and Web application is available for macOS 10.12 and above. PgAdmin 4 v4.25 (released Aug. 20, 2020) pgAdmin 4.
- App user interface, written in Swift. It did not work, with pgAdmin giving me: Unable to connect to server: could not connect to server: Connection refused Is the server running on host 'localhost' (::1) and accepting TCP/IP connections on port 5432? Could not connect to server: Connection refused Is the server running.
- Installing PostgreSQL on Mac OS is easy, and in this post we will review all the necessary steps to get it up and running. Note: The method we are using here to install PostgreSQL takes advantage of the installers EnterpriseDB provides.
You can get macOS PostgreSQL packages from several different sources.
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 |
---|---|
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.
Pgadmin 4
A listof PostgreSQLpackages can be found using the Braumeister search tool.
Pgadmin3
MacPorts
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.
A list ofPostgreSQL packagescan be found using the package search tool on the Fink website.