![]() ![]() ![]() So however installed, I have a broken Postgres installation that I would like to wipe completely. WARNING: the process below will destroy any existing postgres databases you may have run install brew install postgresql -force stop the running postgres server (if any) pgctl -D /usr/local/var/postgres stop destroy your postgres data directory (you will have to supply root password to do this) sudo rm -rf /usr/local/var/postgres recreate a postgres data dir initdb /usr/local/var. Homebrew disclaims ownership of a Postgres installation: # ls /usr/local/Cellar | grep -i postgres I have not used MacPorts, Fink, or other Unix installers other than Homebrew in the life of this Mac. Now that that version is uninstalled, I have a number of Postgres binaries that crash or give errors if I try to use them: $ psqlĭyld: Library not loaded: /usr/lib/libpq.5.dylib This will show you how to completely remove PostgreSQL with Homebrew. We can check the version of PostgreSQL using the psql command. Is the account visible in System Preferences > Users & Groups If it is, you can delete it by selecting it and pressing the minus button. Sometimes the fastest way to solve the problem by uninstalling PostgreSQL entirely, and reinstalling a fresh version. Part of the spooky behavior included being unable after repeated poking and prodding to get a particular user to authenticate with its behavior-but this makes sense if I had two parallel Postgres databases, one for which I was (successfully) setting the user with a particular password, and one which did not have this database set. In Terminal run the following command to install PostgreSQL on Mac using Homebrew. There seems to be an existing half-baked Postgres installation that was already there and remains there after I deleted the Mac GUI installer version from /Applications and /Library. You can install and uninstall them with brew uninstall, and the formulae. I have been experiencing spooky behavior with Postgres after using the Mac installer for Postgres. Uninstalling Postgres.app Quit Postgres.app & drag it to the Trash (Optional) Delete the data directories (default location: /Library/Application Support/. brew tap homebrew/cask homebrew/core petere/postgresql.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |