Installing pgAdmin Only after installing PostgreSQL with Homebrew
June 15th, 2018
Update June 17, 2018: I revisited this issue just now and the set up really is easy. I will be writing a post on this and will link it to here. I much prefer using Homebrew, especially for local development, but I also like having the ability to use a GUI. This set set up just makes life so much easier if you want to push your local repo to remotes such as Github!
Note 6.16.18: I did find out after, however, that it can be very difficult
to set up without the graphical interface/server installed with it. I switched
over to the GUI install because I like to be able to go in there and take a
look around like I do with MongoDB and as I had done with PHPAdmin back
in the day. My only concern is that down the line I will have issues with the
Migration Assistant when I get a new computer. It was a hell when I got my
current computer recently. That’s why I then switched to Homebrew. We shall
see. I still might switch back after I get more familiar with the
I recently started to learn PostgreSQL, and installed it on my Mac High
Sierra with Homebrew. Today, I decided to delve much deeper into it and
found a couple of interesting courses on it on
Udemy. I hadn’t installed
pgAdmin with Homebrew previously because it is severely outdated,
but decided I should give it a try on the pgAdmin website. I
installed it and tried to log in. I received the message that the role
postgres was missing, and I could not log in. That is because I had
chosen to use my computer shortname instead. I decided to investigate the
After some searching, I came up with the following from Stackoverflow:
The part that worked for me, and should for anyone else in a similar situation, is the following in the thread:
@RogerLipscombe if you run brew link postgresql after the installation, there's no need to append the whole path to createuser, a simple createuser -s postgres will work great
It is a comment there, and it worked like a charm! I went back into pgAdmin,
the GUI recognized my new
postgres user, and I was able to log in.
For me, using Homebrew to manage my activity in
postgres was the way to
go, but I also wanted to be able to go into the pgAdmin GUI and get a
comprehensive overview of my database activity.
Hope this helps, and happy pgAdmining!