In a recent post, I spoke about how the OSX Migration Assistant created a new user from my postgreSQL install on my new laptop. Subsequently I talked about uninstalling postgreSQL installed via the postgreSQL GUI and reinstalling directly into my administrator account via Homebrew.
I mentioned my moves to my teacher, and he said that if I was working on shared code with others using postgreSQL databases, that I should create another account because of security reasons. A light bulb went on in my head, and I decided to use my new postgreSQL user account for just that kind of purpose. I had uninstalled the postgreSQL install located in administrator account, thankfully not the new user account. Going forward, I will be dedicating that account to development projects related to postgreSQL or other similar team development scenarios.
It will mean setting up a separate Github repo with a separate public/private ssh key pair, for example, but anyextra step is well worth the effort. Sometimes “mistakes” can result in brilliant moves!