Swiftpack.co - Package - PostgresApp/PostgresApp

Postgres.app Version 2

This is a complete rewrite of Postgres.app

  • Modern User Interface
  • Improved Error Messages & Status Reporting
  • Run Multiple Versions of PostgreSQL simultaneously
  • Written in Swift!

If you are looking for the current/old version of Postgres.app, please switch to the pg9X branches!

Most of this README is outdated and needs to be updated for the new version.

Download

You can download Postgres.app from the Postgres.app website.

Older versions and pre-releases are available in the releases section on GitHub.

Documentation

Documentation is available at http://postgresapp.com/documentation, as well as from the "Open Documentation" menu item in Postgres.app.

What's Included?

How To Build

Note: This section is outdated

If you want to tweak the GUI only, just make sure you have a compiled copy of Postgres.app in your applications folder. Open the XCode file and start hacking!

If you want to build your own versions of all the PostgreSQL binaries, you have a bit more work.

Make sure you have autoconf, automake installed. The quickest way to install them is using MacPorts:

sudo port install autoconf automake

For building PostgreSQL with docs, you also need a bunch of other tools:

sudo port install docbook-dsssl docbook-sgml-4.2 docbook-xml-4.2 docbook-xsl-nons libxslt openjade opensp

Then make sure you remove other versions of Postgres.app from your Applications folder.

Open the src directory and type make. This will download and build PostgreSQL, PostGIS, PLV8, and wal2json. 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. All the products will be installed in /Applications/Postgres.app/Contents/MacOS/.

Once this is done, you can just open Postgres.xcodeproj in Xcode, select the "Postgres" scheme, and click "Build".

To share your build, use the "Archive" command and then use the "Distribute" command in Organizer.

Under the Hood

Postgres.app bundles the PostgreSQL binaries inside the application package. When you first start Postgres.app, here's what it does:

  • Initialise a database cluster: initdb -D DATA_DIRECTORY -EUTF-8 --locale=XX_XX.UTF-8
  • Start the server: pg_ctl start -D DATA_DIRECTORY -w -l DATA_DIRECTORY/postgres-server.log
  • Create a user database: createdb USERNAME

On subsequent app launches, Postgres.app only starts the server.

The default DATA_DIRECTORY is /Users/USERNAME/Library/Application Support/Postgres/var-9.X

Note that Postgres.app runs the server as your user, unlike other installations which might create a separate user named postgres.

When you quit Postgres.app, it stops the server using the following command:

  • pg_ctl stop -w -D DATA_DIRECTORY

Command Line Utilities

Postgres.app also includes useful command line utilities:

  • PostgreSQL: clusterdb createdb createlang createuser dropdb droplang dropuser ecpg initdb oid2name pg_archivecleanup pg_basebackup pg_config pg_controldata pg_ctl pg_dump pg_dumpall pg_receivexlog pg_resetxlog pg_restore pg_standby pg_test_fsync pg_test_timing pg_upgrade pgbench postgres postmaster psql reindexdb vacuumdb vacuumlo
  • PROJ.4: cs2cs geod invgeod invproj nad2bin proj
  • GDAL: gdal_contour gdal_grid gdal_rasterize gdal_translate gdaladdo gdalbuildvrt gdaldem gdalenhance gdalinfo gdallocationinfo gdalmanage gdalserver gdalsrsinfo gdaltindex gdaltransform gdalwarp nearblack ogr2ogr ogrinfo ogrtindex testepsg
  • PostGIS: pgsql2shp raster2pgsql shp2pgsql

See the documentation for more info.

Contact

If you find a bug, please open an issue.

Postgres.app is maintained by Jakob Egger and Chris Pastl.

License

Postgres.app is released under the PostgreSQL License. See LICENSE for additional information.

Github

link
Stars: 5037
Help us keep the lights on

Dependencies

Used By

Total: 0

Releases

v2.3.2 - Nov 14, 2019

Quarterly PostgreSQL updates are here!

We offer downloads with the following versions of PostgreSQL:

  • PostgreSQL 12.1, PostGIS 3.0.0 and PL/v8 2.3.13
  • PostgreSQL 11.6, PostGIS 2.5.3 and PL/v8 2.3.13
  • PostgreSQL 10.11, PostGIS 2.4.8 and PL/v8 1.4.8
  • PostgreSQL 9.6.16, PostGIS 2.3.10 and PL/v8 1.4.8
  • PostgreSQL 9.5.20, PostGIS 2.2.8 and PL/v8 1.4.8
  • PostgreSQL 9.4.25, PostGIS 2.1.9 and PL/v8 1.4.8

Please pick a download that contains the versions of PostgreSQL that you need. For example, Postgres-2.3.2-12.dmg comes with PostgreSQL 12, while Postgres-2.3.2-10-11-12.dmg comes with PostgreSQL 10, 11 and 12.

These downloads all require macOS 10.12 or later. We no longer update builds for older versions of macOS.

v2.3.1 - Oct 17, 2019

In the previous release, PostGIS 3 was built without json-c support. This release fixes this problem. (#526)

Postgres-2.3.1-12.dmg includes just the latest and greatest version of PostgreSQL:

  • PostgreSQL 12.0, PostGIS 3.0.0rc2 and PL/v8 2.3.13

If you still have some older databases on your Mac that you don't want to upgrade just yet, we also offer a bigger bundle: Postgres-2.3-10-11-12.dmg comes with 3 versions of PostgreSQL included:

  • PostgreSQL 12.0, PostGIS 3.0.0rc2 and PL/v8 2.3.13
  • PostgreSQL 11.5, PostGIS 2.5.2 and PL/v8 2.3.12
  • PostgreSQL 10.10, PostGIS 2.4.7 and PL/v8 1.4.8

And if you still have PostgreSQL 9.5 or 9.6 databases running, we also offer the biggest bundle yet: Postgres-2.3.1-9.5-9.6-10-11-12.dmg with the following PostgreSQL versions included:

  • PostgreSQL 12.0, PostGIS 3.0.0rc2 and PL/v8 2.3.13
  • PostgreSQL 11.5, PostGIS 2.5.2 and PL/v8 2.3.12
  • PostgreSQL 10.10, PostGIS 2.4.7 and PL/v8 1.4.8
  • PostgreSQL 9.6.15, PostGIS 2.3.9 and PL/v8 1.4.8
  • PostgreSQL 9.5.19, PostGIS 2.2.8 and PL/v8 1.4.8

These builds run on all Macs with macOS 10.12 or later.

v2.3 - Oct 3, 2019

PostgreSQL 12 was released today!

We have two builds of Postgres.app available with the newest version of PostgreSQL.

Postgres-2.3-12.dmg includes just the latest and greatest version of PostgreSQL:

  • PostgreSQL 12.0, PostGIS 3.0.0beta1 and PL/v8 2.3.13

If you still have some older databases on your Mac that you don't want to upgrade just yet, we also offer a bigger bundle: Postgres-2.3-10-11-12.dmg comes with 3 versions of PostgreSQL included:

  • PostgreSQL 12.0, PostGIS 3.0.0beta1 and PL/v8 2.3.13
  • PostgreSQL 11.5, PostGIS 2.5.2 and PL/v8 2.3.12
  • PostgreSQL 10.10, PostGIS 2.4.7 and PL/v8 1.4.8

These builds run on all Macs with macOS 10.12 or later.

v2.2.5 - Aug 8, 2019

The quarterly PostgreSQL releases are here!

We have bugfix releases for PostgreSQL 9.4, 9.5, 9.6, 10 and 11, and a new beta version of PostgreSQL 12. The PostgreSQL 12 beta now includes PL/v8 again!

Here's a list of all the downloads included in this release:

The Beta bundle

In addition to PostgreSQL 12 beta 3, this download also includes the stable versions of PostgreSQL 10 and 11. So you can try PostgreSQL 12 while running your existing databases at the same time!

Postgres-2.3beta3.dmg comes with 3 versions of PostgreSQL:

  • PostgreSQL 12beta3, PostGIS 3.0.0alpha3 and PL/v8 2.3.12
  • PostgreSQL 11.5, PostGIS 2.5.2 and PL/v8 2.3.12
  • PostgreSQL 10.10, PostGIS 2.4.7 and PL/v8 1.4.8

Stable versions only for Macs running macOS 10.12 or later

The latest stable version is Postgres.app 2.2.5.

We offer two downloads:

  • Postgres-2.2.5-11.dmg comes with the latest version of PostgreSQL:
    • PostgreSQL 11.5, PostGIS 2.5.2 and PL/v8 2.3.12
  • Postgres-2.2.5-9.5-9.6-10-11.dmg comes with the 4 most recent versions of PostgreSQL:
    • PostgreSQL 11.5, PostGIS 2.5.2 and PL/v8 2.3.12
    • PostgreSQL 10.10, PostGIS 2.4.7 and PL/v8 1.4.8
    • PostgreSQL 9.6.15, PostGIS 2.3.9 and PL/v8 1.4.8
    • PostgreSQL 9.5.19, PostGIS 2.2.8 and PL/v8 1.4.8

Stable version for Macs running macOS 10.10 or later

Postgres-2.1.9.dmg comes with the following versions of PostgreSQL:

  • PostgreSQL 10.10, PostGIS 2.4.7 and PL/v8 1.4.8
  • PostgreSQL 9.6.15, PostGIS 2.3.9 and PL/v8 1.4.8
  • PostgreSQL 9.5.19, PostGIS 2.2.8 and PL/v8 1.4.8

For Macs running macOS 10.7 or later

For even older Macs, we offer the legacy version of Postgres.app with the old UI.

You can choose between these legacy versions:

  • PostgreSQL 10.10, PostGIS 2.4.7 and PL/v8 1.4.8
  • PostgreSQL 9.6.15, PostGIS 2.3.9 and PL/v8 1.4.8
  • PostgreSQL 9.5.19, PostGIS 2.2.8 and PL/v8 1.4.8
  • PostgreSQL 9.4.24, PostGIS 2.1.9 and PL/v8 1.4.8

v2.2.4 - Jun 20, 2019

This release fixes a security issue in PostgreSQL 10 and later. We recommend to update as soon as possible. For more details, see the PostgreSQL change log.

Also included in this release is the second beta version of PostgreSQL 12, and bugfixes for 9.x versions.

Here are all the downloads that are included in this release:

The Beta bundle

Postgres-2.3beta2.dmg comes with 3 versions of PostgreSQL:

  • PostgreSQL 12beta2, PostGIS 3.0.0alpha2
  • PostgreSQL 11.4, PostGIS 2.5.2 and PL/v8 2.3.11
  • PostgreSQL 10.9, PostGIS 2.4.7 and PL/v8 1.4.8

For Macs running macOS 10.12 or later

The newest version is Postgres.app 2.2.4.

We offer two downloads:

  • Postgres-2.2.4-11.dmg comes with the latest version of PostgreSQL:
    • PostgreSQL 11.4, PostGIS 2.5.2 and PL/v8 2.3.11
  • Postgres-2.2.4-9.5-9.6-10-11.dmg comes with the 4 most recent versions of PostgreSQL:
    • PostgreSQL 11.4, PostGIS 2.5.2 and PL/v8 2.3.11
    • PostgreSQL 10.9, PostGIS 2.4.7 and PL/v8 1.4.8
    • PostgreSQL 9.6.14, PostGIS 2.3.9 and PL/v8 1.4.8
    • PostgreSQL 9.5.18, PostGIS 2.2.8 and PL/v8 1.4.8

For Macs running macOS 10.10 or later

Postgres-2.1.8.dmg comes with the following versions of PostgreSQL:

  • PostgreSQL 10.9, PostGIS 2.4.7 and PL/v8 1.4.8
  • PostgreSQL 9.6.14, PostGIS 2.3.9 and PL/v8 1.4.8
  • PostgreSQL 9.5.18, PostGIS 2.2.8 and PL/v8 1.4.8

For Macs running macOS 10.7 or later

For even older Macs, we offer the legacy version of Postgres.app with the old UI.

You can choose between these legacy versions:

  • PostgreSQL 10.9, PostGIS 2.4.7 and PL/v8 1.4.8
  • PostgreSQL 9.6.14, PostGIS 2.3.9 and PL/v8 1.4.8
  • PostgreSQL 9.5.18, PostGIS 2.2.8 and PL/v8 1.4.8
  • PostgreSQL 9.4.23, PostGIS 2.1.9 and PL/v8 1.4.8