Postgres.app is the easiest way to get started with PostgreSQL on the Mac. Open the app, and you have a PostgreSQL server ready and awaiting new connections. Close the app, and the server shuts down.
The latest version is available from the Postgres.app website.
Older versions and pre-releases are available in the releases section on github.
Documentation is available at http://postgresapp.com/documentation, as well as from the "Open Documentation" menu item in Postgres.app.
How To Build
Make sure you have
automake installed. The quickest way to install them is using MacPorts:
sudo port install autoconf automake
Then just open
Postgres.xcodeproj in Xcode, select the
Postgres scheme, and click "Build"
XCode will download and build PostgreSQL, PostGIS, and PLV8. Several hundred megabytes of sources will be downloaded and built. This can take an hour or longer, depending on your Internet connection and processor speed.
You can also build the PostgreSQL binaries from the command line.
To do so, open a Terminal, change to the
src directory, and type
When the build is complete, switch to XCode and build Postgres.app with XCode.
This makes debugging a lot easier!
Under the Hood
Postgres.app bundles the PostgreSQL binaries as auxiliary executables. An XPC service manages
postgres processes, which are terminated when the app is quit.
The database data directory is located in the
/var directory of the Postgres.app Container's Application Support directory. When the app is launched, it checks for "PG_VERSION" in the directory. If it does not exist,
initdb is run, and later,
createdb to create a default database for the current user.
Command Line Utilities
Postgres.app also includes useful command line utilities:
See the documentation for more info.
If you find a bug, please open an issue.
Postgres.app was created by Mattt Thompson.
Postgres.app is released under the PostgreSQL License. See LICENSE for additional information.