Homebrew is a package manager for Mac OS X that builds software from its source code. It includes a version of PostgreSQL packaged by what it refers to as a formula. This type of installation might be preferred by people who are comfortable using the command line to install programs, such as software developers.

• Brew Start Postgresql
• Homebrew Install Postgres

Upgrading PostgreSQL 9.2 to 9.3 with Homebrew. What to do when PostgreSQL fails to start after a brew upgrade. Published September 23, 2013 Revised December 27, 2014: These instructions have also been tested for 9.3→9.4!

Typical use looks like

• As of writing (1.6.1), doing brew install postgresql@9.6 seems to work, but if you attempt brew info postgresql still points to 10.3 (current stable). Doing brew info postgresql@9.6 looks like it works, but one cannot brew switch to it. Still not sure yet how one resolves that. – Scott Corscadden Apr 23 '18 at 20:05.
• Start the server: brew services start postgresql Open the PostgreSQL prompt. Psql If psql complains that there's no corresponding database for your user, run createdb. Installation on GNU+Linux. On most GNU+Linux operating systems, PostgreSQL can easily be installed using the operating system package manager.

This install the command line console (psql) as well as the server, if you'd like to create your own databases locally.Run the following to start the server and login to it (it basically sets up a single 'admin' user with your username, so that's who you'll be logged in as.

You can see what other versions are available by running

You can see which version the current latest will be by running

Notes on Homebrew:

Brew Start Postgresql

• Brew Install Postgresql on OS X Lion - Resolving conflicts with the built-in PostgreSQL libraries shipping with OS X 10.7 'Lion'
• petere/postgresql tap for installing multiple PostgreSQL versions in parallel

Homebrew Install Postgres