February 2, 2019

Duplicate Databases

I seem to have the unfortunate luck of having constant database installation problems.

To date, my personal mac suffers from constant MySQL problems because I've installed it different ways and now my mac is permanently confused which instance to use. I've tired multiple ways to uninstall and delete it all, and had no success. It's to the point where I exclusively use postgres because of database problems.

Most recently, I've installed postgres on my work laptop and, once again, encountered database problems. I installed postgres manually from the website and with postgresapp. When I tried to run postgresapp it told me that the port is already in use.

I solved the problem by running:

ps auxw | grep post

It locates where the other postgres was installed and I was able to successfully uninstall it.

Whew.