Libssl and libcrypto causing dyld: Library not loaded: /usr/lib/libpq.5.dylib

Question

I recently uninstalled postgresql and installed pyscopg2 via pip.

I know there's some trickery involved with libcrypto and libssl

Currently i have them symlinked to:

$ ls -lah libssl.*
-rwxr-xr-x  1 root  wheel   402K Aug 28 11:06 libssl.0.9.7.dylib
-rwxr-xr-x  1 root  wheel   589K Aug 28 11:06 libssl.0.9.8.dylib
lrwxr-xr-x  1 root  wheel    55B Nov 29 23:38 libssl.1.0.0.dylib -> /usr/local/Cellar/openssl/1.0.1c/lib/libssl.1.0.0.dylib
lrwxr-xr-x  1 root  wheel    55B Nov 30 02:25 libssl.dylib -> /usr/local/Cellar/openssl/1.0.1c/lib/libssl.1.0.0.dylib

/usr/lib
$ ls -lah libcrypto.*
-rwxr-xr-x  1 root  wheel   2.1M Aug 28 11:06 libcrypto.0.9.7.dylib
-rwxr-xr-x  1 root  wheel   2.6M Aug 28 11:06 libcrypto.0.9.8.dylib
-r-xr-xr-x  1 root  wheel   1.6M Oct 31 22:12 libcrypto.1.0.0.dylib
lrwxr-xr-x  1 root  wheel    58B Nov 30 02:27 libcrypto.dylib -> /usr/local/Cellar/openssl/1.0.1c/lib/libcrypto.1.0.0.dylib

whereby I installed openssl via ports

Now when I run arc diff, I am getting the infamous

$ arc diff
dyld: Library not loaded: /usr/lib/libpq.5.dylib
  Referenced from: /usr/bin/php
  Reason: image not found
Trace/BPT trap: 5

There are a few answers here in SO which talks about symlinking these libs to the postgresql install directory. Obviously, this won't work for me.

What should I do?

What's `arc`? Also, I see `/usr/bin/php`; that doesn't look very Python to me. And if you *un*installed postgresql, I'm not so sure that `pip` will install postgresql for you if you install `psycopg2` (though, if it doesn't, it should probably fail). Do you have a libpq (any) on your system? — , Nov 30 '12 at 12:49
Related?: [Library not loaded: /usr/local/lib/libpq.5.4.dylib while running rake db:create](http://stackoverflow.com/q/9023482/456814). — , May 20 '14 at 23:06

score 16 · Accepted Answer · edited Nov 30 '12 at 20:08

16

Turns out /usr/lib/libpq.5.dylib was absent but /usr/lib/libpq.5.4.dylib was not.

sudo ln -s /usr/lib/libpq.5.4.dylib /usr/lib/libpq.5.dylib

fixed the issue.

edited Nov 30 '12 at 20:08

Alex Reynolds

95,983
54
240
345

answered Nov 30 '12 at 20:05

xjq233p_1

7,810
11
61
107

5

In my case, the library was in /Library/PostgreSQL/9.3/lib. To solve the issue, I ran `export DYLD_LIBRARY_PATH=/Library/PostgreSQL/9.3/lib:$DYLD_LIBRARY_PATH` – Pablo Marambio Nov 09 '13 at 02:27
other way around for for me..! sudo ln -s /usr/lib/libpq.5.dylib /usr/lib/libpq.5.6.dylib – Ammar Akhtar Jan 27 '15 at 23:43
1

For macos big sur i do symlink for /usr/local/lib/libpq.5.dylib – A K Dec 03 '21 at 14:39

Akshay-stori · Answer 2 · 2022-09-20T14:32:56.587

14

just use the below commands in your terminal (use the proper postgresql version) $ brew unlink postgresql@14

$ brew link libpq --force

https://github.com/opentable/otj-pg-embedded/issues/152#issuecomment-954348544

edited Sep 20 '22 at 14:32

answered Sep 20 '22 at 14:31

Akshay-stori

141
1
3

This did work for me but then another project broke because it needed `postgresql@14` linked. Instead I reinstalled all my python project modules including psycopg2 by setting `export LDFLAGS="-L/usr/local/opt/libpq/lib"` first. – mochatiger Oct 27 '22 at 22:54

score 9 · Answer 3 · answered Oct 20 '22 at 21:17

I got the error

Library not loaded: '/usr/local/opt/postgresql/lib/libpq.5.dylib'

Reason: tried: '/usr/local/opt/postgresql/lib/libpq.5.dylib' (no such file), '/usr/local/lib/libpq.5.dylib' (no such file), '/usr/lib/libpq.5.dylib' (no such file)

when running a Django project and to fix it I had to uninstall the pip packages:

pip uninstall psycopg2 
pip uninstall psycopg2-binary

and then install them again:

pip install psycopg2 
pip install psycopg2-binary

And this made the project run without the error.

Using the `--no-cache-dir` option for pip solved this for me. — YPCrumble, Dec 08 '22 at 00:59

score 3 · Answer 4 · answered Sep 25 '14 at 18:49

3

Not unlike @Pablo Marambio, I fixed this issue by adding the following line to ~/.profile:

export DYLD_LIBRARY_PATH=/Library/PostgreSQL/9.3/lib:$DYLD_LIBRARY_PATH

For Postgres.app v9.3.5.0 (presumably others too) I added the following line instead:

export DYLD_LIBRARY_PATH=/Applications/Postgres.app/Contents/Versions/9.3/lib:$DYLD_LIBRARY_PATH

Then, of course, run source ~/.profile

answered Sep 25 '14 at 18:49

metasequoia

7,014
5
41
54

1

I like this exporting environment variable better than copying or symlinking libraries on my system. – Sam Texas Dec 25 '14 at 20:48
This breaks running "psql DBNAME" in the command line for me. Running Postgres.app v9.5.0.0 and the error returned says "dyld: Symbol not found: __cg_jpeg_resync_to_restart" – Raymond26 Jun 06 '16 at 23:39

score 2 · Answer 5 · answered Mar 10 '20 at 05:30

2

To resolve this, I had to uninstall postgresql and then install again.

$ brew uninstall postgresql

$ brew update

$ brew install postgres

answered Mar 10 '20 at 05:30

SuperNova

25,512
7
93
64

This solution was almost mine too but in addition, since I'm using a specific version of postgresql, I also needed a `brew link`: `$ brew uninstall postgresql@11 && brew update && brew install postgresql@11 && brew link --force postgresql@11` – pierroz Feb 10 '21 at 08:25
It is not working for me – thedevd Mar 03 '22 at 06:31
brew link --force postgresql@11 did the magic here – Marlon Abeykoon May 17 '22 at 11:49

score 1 · Answer 6 · answered Nov 26 '22 at 06:05

1

I had to do this for postgresql 14 + brew

sudo ln -s /opt/homebrew/opt/postgresql@14/lib/postgresql@14/libpq.5.dylib /opt/homebrew/opt/postgresql/lib/libpq.5.dylib

answered Nov 26 '22 at 06:05

Frexuz

4,732
2
37
54

score 0 · Answer 7 · answered Dec 07 '22 at 01:07

0

I'm using poetry so to solve it on my fastapi project, I had to do this to fix it:

poetry remove psycopg2
poetry add psycopg2

answered Dec 07 '22 at 01:07

zekromWex

280
1
4
17

score 0 · Answer 8 · answered Feb 14 '23 at 14:09

It try to load libpq.5.dylib from the symlink /opt/homebrew/opt/postgresql/lib/libpq.5.dylib but found not file, so you need to update it:

# TODO: get this from the error, after "Library not loaded:"
SYMLINK_PATH="/usr/lib/libpq.5.dylib"

# TODO: find this in your machine. The version maybe different than mine
DESTINATION_PATH="/opt/homebrew/opt/postgresql/lib/postgresql@14/libpq.5.dylib"

sudo mv $SYMLINK_PATH $SYMLINK_PATH.old
sudo ln -s $DESTINATION_PATH $SYMLINK_PATH

Libssl and libcrypto causing dyld: Library not loaded: /usr/lib/libpq.5.dylib

8 Answers8

Linked