Managing multiple PostgreSQL installs via Homebrew

Reading time ~1 minute

Following on from this post, you probably have multiple versions of PostgreSQL installed on your Mac. In that post, I added an example function to help you manage all these concurrent installs. Today, I’m back with a full-fledged shell script to help manage all this. Without further ado, the script:

But what does it do? It’s pretty simple actually. When you call this script, you tell it what version of PostgreSQL you want:

doug@Douglass-MacBook-Pro ~ » pg 9.6

and then the script does the following:

  • checks if the requested version is installed, and installs it if not
  • checks if another version of PostgreSQL is running, and stops it
  • checks if another version is linked as the active version, and unlinks it
  • links the requested version as the active version
  • sets PGDATA to point to the requested version’s data cluster
  • does an initdb for the requested version if needed
  • starts the requested version’s cluster

I’ll be the first to admit that the script could use additional work, but it’s functional enough to start using today. As I continue to improve the script, I’ll update the gist with those changes, so check back every so often.

Enjoy.

updated PostgreSQL homebrew script

With the release of PostgreSQL 10, I've updated my `pg` script. You might recall from previous posts that this script is for Homebrew use...… Continue reading

When you cannot get there from here

Published on July 25, 2017

Installing pgBackRest on OSX

Published on June 14, 2017