Postgres 9.6.6 Mac Download Updated

Rinaldi Thespery – April 24, 2022

Postgres 9.6.6 Mac Download

How to install PostgreSQL 9.half-dozen on Mac Bone X (ten.vii or afterwards)

PostgreSQL is an open up source relational database organisation that has been effectually for well over a decade and has proven to be a great all around storage choice when developing a web application.

In this guide we are going to walk through installing PostgreSQL 9.6 on Mac OS X (10.vii or later) so that we can eventually beginning using it with a Go application, but y'all can follow along with this guide to set upwardly Postgres for apply with pretty much anything, including Rails, Django, or Go.

Once we have Postgres setup we will also wait at adding all of the executables to our path so that we tin type things similar psql in the terminal in order to access Postgres. It is important to annotation that this step IS Non required to employ postgres, but it is nice to accept and so I propose doing information technology.

Installation

The showtime thing we want to practise is install PostgreSQL using Postgres.app. You can find that here: http://postgresapp.com/.

Postgres.app is almost 50mb, and is by far the easiest way to setup Postgres on a Mac. It runs like any other you would download, tin automatically starting time up with your Mac, and allows us to skip a lot of command line steps that used to be required to ready up Postgres on a Mac. Yay for progress!

You can take hold of any version you need at the "Other versions" section of the page, but I will be using th emost recent version which currently uses PostgreSQL ix.6.0.

One time you have unzipped the download you volition want to copy the Postgres app to your Applications folder and then open it. Y'all might be asked if you want to open this application considering it was downloaded from the cyberspace. Click open.

Yous should now accept Postgres running locally, and you should see a footling elephant icon on the pinnacle right section of your menu bar. Click on it then click the "Open psql" option.

Opening psql via the elephant icon.

If you don't encounter whatever errors that means everything is working! Congrats!

Now lets get ahead and add together Postgres to our path.

Enabling Postgres command line tools

If you are using the default terminal, you are going to want to modify the file at ~/.bash_profile. If you are using something like Oh My Zsh you are going to want to modify the file ~/.zshrc.

To edit this file you probable demand to open up information technology via the terminal, and so open up your terminal and type open up ~/.bash_profile. You tin replace the discussion open with subl or whatever text editor yous prefer.

One time your zbash_profile or .zshrc file is open up, add the post-obit line to the finish of the file:

                                      export              PATH              =$              PATH              :              /              Applications              /              Postgres              .              app              /              Contents              /              Versions              /              latest              /              bin

After that you will demand to quit and restart your terminal This is to make sure it reloads with the changes you just made.

Once you lot accept restarted your concluding, try running psql.

You should become the following output.

                                      psql              (              ix              .              half dozen              .              0              )                                      Blazon              "help"              for              help              .                                                              postgres              =#

You accept now successfully connected to Postgres using the postgres role. This office doesn't require a countersign considering Postgres is but accessible locally, so information technology is unlikely to nowadays any security issues.

Up Adjacent…

Now that yous accept PostgreSQL 9.6 installed you lot are ready to start using it! Check out the adjacent article in this series to learn how to do that - Creating PostgreSQL databases and tables with raw SQL

You can likewise check out an overview of the unabridged serial, along with links to each article in the series, by going here - Using PostgreSQL with Golang.

Learn Spider web Development with Go!

Sign up for my mailing list and I'll transport yous a FREE sample from my course - Web Development with Become. The sample includes 19 screencasts and the first few chapters from the book.

You lot will also receive emails from me about Go coding techniques, upcoming courses (including Complimentary ones), and course discounts.