PostgreSQL

2019 - 07 - 21

I have a habit of doing brew update every week. It’s a been a while since I’ve used PostgreSQL, last I remember it was version 9, now it’s 11 and I can’t connect to it because of some migration issues.

psql: could not connect to server: No such file or directory

Since I installed it using homebrew, the easy way to fix it is to use the included upgrade script.

brew postgresql-upgrade-database

Quick memory refresher

Use a GUI

brew cask install pg4admin

Then go make some tea. This takes a while.

Previous Planned Projects
Home
Next Remove Git Submodule