How can I remove Postgres completely from my Mac?-Collection of common programming errors

11 years ago
admin
2 minutes

I have been experiencing spooky behavior with Postgres after using the Mac installer for Postgres. 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. 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. 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
dyld: Library not loaded: /usr/lib/libpq.5.dylib
  Referenced from: /usr/bin/psql
  Reason: image not found
Trace/BPT trap: 5
$

I have not used MacPorts, Fink, or other Unix installers other than Homebrew in the life of this Mac. Homebrew disclaims ownership of a Postgres installation:

# ls /usr/local/Cellar | grep -i postgres
#

So however installed, I have a broken Postgres installation that I would like to wipe completely.

How can I completely wipe Postgres from my system so I can install it with the installer and have one Postgres installation, instead of a spooky one and a half installations?

  1. It looks like you just deleted a few files in Finder.

    Assuming you used the installer from here, you need to follow the instructions in the guide about uninstalling:

    If you need to uninstall PostgreSQL, you can run the uninstaller that is created during the installation process at any time. Note that the uninstaller will never remove your data directory, or the service user account. You can find the uninstaller in the installation directory, and can run it as you ran the installer. No command line options are generally required. On Windows, you can also run the uninstaller from the Add/Remove Programs control panel applet.

    In other words, just run the uninstaller installed with the rest of the program.