The easiest way to get started with PostgreSQL on the Mac

Updating 2 2.0 or later has an automatic update function. Just open the app, and select “Check For Updates…” from the “Postgres” menu.

If you want to convert a data directory to a new major version (eg. 9.5 to 9.6), see migrating data.

From 9.5.x.x or 9.6.x.x

You can upgrade to 2 just by replacing the the app in your applications folder.

  1. Quit the old version of
  2. Download the new version of
  3. Replace the old version in /Applications with the new version
  4. Double click. 2 will automatically detect the existing data directories if they are in the standard location. If you are using a different location, add them manually by opening the sidebar and clicking the plus button.

From earlier versions of

If you want to upgrade from earlier versions of, you will need to migrate your data.

Alternatively, you can make a custom version of 2 that supports the older server versions. See this page for details.