How do I fix "Library not loaded: libssl.1.0.0.dylib" with PostgreSQL?

After deleting Macports, I've had some strange behaviour. When I try to run PostgreSQL via CLI, I get:

pawel:~ pawel$ psql
dyld: Library not loaded: /opt/local/lib/libssl.1.0.0.dylib
  Referenced from: /usr/local/bin/psql
  Reason: image not found
Trace/BPT trap

This is strange because I've installed Postgresql through Homebrew and running brew list confirms that it's there. How would I get psql to work again?

Additionally, trying to install the pg gem fails due to an file not found: /opt/local/lib/libssl.1.0.0.dylib error. I need to make Postgres not look in the /opt/local/ directory for this file.

Solution 1:

The solution is to uninstall postgresql then install it again. The reason it wasn't working was that the Macports install messed with some of the configs.

brew reinstall postgresql