blocks|key|307554|text|我通过安装命令行工具修复了这个问题|type|unstyled|depth|inlineStyleRanges|entityRanges|data|307555|xcode-select+--install|code-block|syntax|javascript|307556|然后通过Homebrew安装openssl，并手动将我安装的openssl链接到pip：|307557|env+LDFLAGS="-I/usr/local/opt/openssl/include+-L/usr/local/opt/openssl/lib"+pip+install+psycopg2|307558|关于macOS+Sierra+10.12.1|307559|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I fixed this by installing Command Line Tools

<pre><code>xcode-select --install
</code></pre>

then installing openssl via Homebrew and manually linking my homebrew-installed openssl to pip:

<pre><code>env LDFLAGS="-I/usr/local/opt/openssl/include -L/usr/local/opt/openssl/lib" pip install psycopg2
</code></pre>

on macOS Sierra 10.12.1

blocks|key|2035112|text|试着用以下方式安装：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2035113|pip+install+psycopg2-binary|code-block|syntax|javascript|2035114|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try installing it with:

<pre><code>pip install psycopg2-binary
</code></pre>

blocks|key|115203|text|brew+install+postgresql|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|115204|如果postgresql存在，那么运行：|unstyled|115205|brew+upgrade+postgresql
sudo+pip+install+psycopg2|115206|在文中：|115207|env+LDFLAGS='-L/usr/local/lib+-L/usr/local/opt/openssl/lib+-L/usr/local/opt/readline/lib'+pip+install+psycopg2==2.8.4|115208|如果只需要使用命令pip+install+psycopg2导出macOSX中的路径：|offset|length|style|CODE|115209|export+LDFLAGS="-I/usr/local/opt/openssl/include+-L/usr/local/opt/openssl/lib"|115210|entityMap^0|0|0|0|0|0|9|K|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|X|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$B|C]]|$1|I|3|J|5|F|7|Z|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|10|8|@]|9|@]|A|$B|C]]|$1|M|3|N|5|F|7|11|8|@$O|12|P|13|Q|R]]|9|@]|A|$]]|$1|S|3|T|5|6|7|14|8|@]|9|@]|A|$B|C]]|$1|U|3|-4|5|F|7|15|8|@]|9|@]|A|$]]]|V|$]]

<pre><code>brew install postgresql
</code></pre>

If postgresql exist then run:

<pre><code>brew upgrade postgresql
sudo pip install psycopg2
</code></pre>

In venv:

<pre><code>env LDFLAGS='-L/usr/local/lib -L/usr/local/opt/openssl/lib -L/usr/local/opt/readline/lib' pip install psycopg2==2.8.4
</code></pre>

If you need use only the command <code>pip install psycopg2</code> export the path in macOSX:

<pre><code>export LDFLAGS="-I/usr/local/opt/openssl/include -L/usr/local/opt/openssl/lib"
</code></pre>

blocks|key|115248|text|我用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|115249|brew+reinstall+openssl|code-block|syntax|javascript|115250|export+LIBRARY_PATH=$LIBRARY_PATH:/usr/local/opt/openssl/lib/|115251|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|D|7|M|8|@]|9|@]|A|$E|F]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I fixed it with:

<pre><code>brew reinstall openssl
</code></pre>

<pre><code>export LIBRARY_PATH=$LIBRARY_PATH:/usr/local/opt/openssl/lib/
</code></pre>

blocks|key|115221|text|使用pipenv安装psycopg2遇到类似的问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|115222|ld:库未找到-lssl'，‘clang:错误:链接器命令与退出代码1(使用-v查看调用)’，“错误:命令'clang‘失败与退出状态1"，’|blockquote|115223|我尝试了以上所有的建议，但没有一条有效。几个月前，我在另一个虚拟主机上遇到了这个问题，还记得我读过一些关于这是一个psycopg2版本问题的文章。所以我试着用2.7.1和2.8.3安装，但都失败了。不知何故，2.7.7版起了作用：|offset|length|115224|pipenv+install+psycopg2==2.7.7|code-block|syntax|javascript|115225|希望我能有时间进一步了解一下到底发生了什么。但现在我不知道这件事起作用了。|115226|entityMap|0|LINK|mutability|MUTABLE|url|https://www.reddit.com/r/learnpython/comments/aah5da/pipenv_install_psycopg2_installs_package_but_cant/^0|0|0|1L|C|0|0|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Y|8|@]|9|@]|A|$]]|$1|E|3|F|5|6|7|Z|8|@]|9|@$G|10|H|11|1|12]]|A|$]]|$1|I|3|J|5|K|7|13|8|@]|9|@]|A|$L|M]]|$1|N|3|O|5|6|7|14|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|Q|$R|$5|S|T|U|A|$V|W]]]]

Running into a similar problem using pipenv install psycopg2:

<blockquote>
 ld: library not found for -lssl', ' clang: error: linker command
 failed with exit code 1 (use -v to see invocation)', " error:
 command 'clang' failed with exit status 1", ' 
 ----------------------------------------',
</blockquote>

I tried all of the recommendations above and none of them worked. I'd faced this problem in another virtualenv a few months ago and remembered reading something about this being a <a href="https://www.reddit.com/r/learnpython/comments/aah5da/pipenv_install_psycopg2_installs_package_but_cant/" rel="noreferrer">psycopg2 version issue</a>. So I tried installing with 2.7.1 and 2.8.3 and both still failed. Somehow version 2.7.7 worked:

<pre><code>pipenv install psycopg2==2.7.7
</code></pre>

Wish I had time to look into this further to understand what's really happening. But for now I don't and this worked.

blocks|key|2035520|text|对于MacOS11.06+BigSur+M1+ship，安装在pyenv下面|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2035521|brew+reinstall+libpq
brew+reinstall+openssl|code-block|syntax|javascript|2035522|如果情况还不是这样，也可以安装|2035523|brew+info+libpq
brew+info+openssl|2035524|将2导出的输出逻辑地组合在一起|2035525|要让编译器找到openssl@3，您可能需要设置：
导出LDFLAGS="-L/opt/homebrew/opt/openssl@3/lib“
出口CPPFLAGS="-I/opt/homebrew/opt/openssl@3/include“..。出口LDFLAGS="-L/opt/homebrew/opt/libpq/lib“CPPFLAGS=”导出“-I/opt/homebrew/opt/libpq/include”|blockquote|2035526|转到|2035527|export+LDFLAGS="-L/opt/homebrew/opt/libpq/lib+-L/opt/homebrew/opt/openssl@3/lib"
export+CPPFLAGS="-I/opt/homebrew/opt/libpq/include+-I/opt/homebrew/opt/openssl@3/include"|2035528|然后可以重新安装psycopg2，强制重新编译，否则就会有这个问题在运行时。|offset|length|2035529|pip+uninstall+psycopg2+
pip+install+psycopg2+--no-cache-dir|2035530|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/psycopg/psycopg2/issues/1208^0|0|0|0|0|0|0|0|0|T|8|0|0|0^^$0|@$1|2|3|4|5|6|7|17|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|18|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|19|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|1A|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|1B|8|@]|9|@]|A|$]]|$1|M|3|N|5|O|7|1C|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1D|8|@]|9|@]|A|$]]|$1|R|3|S|5|D|7|1E|8|@]|9|@]|A|$E|F]]|$1|T|3|U|5|6|7|1F|8|@]|9|@$V|1G|W|1H|1|1I]]|A|$]]|$1|X|3|Y|5|D|7|1J|8|@]|9|@]|A|$E|F]]|$1|Z|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]]|10|$11|$5|12|13|14|A|$15|16]]]]

For Mac OS 11.06 BigSur M1 ship, installing under a pyenv
<pre><code>brew reinstall libpq
brew reinstall openssl
</code></pre>
Or install if its not already the case
<pre><code>brew info libpq
brew info openssl
</code></pre>
Combine the 2 exported output logically, from
<blockquote>
For compilers to find openssl@3 you may need to set:
export LDFLAGS=&quot;-L/opt/homebrew/opt/openssl@3/lib&quot;
export CPPFLAGS=&quot;-I/opt/homebrew/opt/openssl@3/include&quot;
</blockquote>
<blockquote>
...
export LDFLAGS=&quot;-L/opt/homebrew/opt/libpq/lib&quot;
</blockquote>
<blockquote>
export CPPFLAGS=&quot;-I/opt/homebrew/opt/libpq/include&quot;
</blockquote>
into
<pre><code>export LDFLAGS=&quot;-L/opt/homebrew/opt/libpq/lib -L/opt/homebrew/opt/openssl@3/lib&quot;
export CPPFLAGS=&quot;-I/opt/homebrew/opt/libpq/include -I/opt/homebrew/opt/openssl@3/include&quot;
</code></pre>
Then you can reinstall psycopg2, forcing the recompile, otherwise you will have <a href="https://github.com/psycopg/psycopg2/issues/1208" rel="noreferrer">this problem at runtime</a>
<pre><code>pip uninstall psycopg2 
pip install psycopg2 --no-cache-dir
</code></pre>

blocks|key|307590|text|安装/更新Xcode开发者工具Xcode-选择--安装|type|ordered-list-item|depth|inlineStyleRanges|entityRanges|data|307591|查询postgres路径
查找/+-name+pg_config+2>/dev/null|307592|安装psycopg2，使用您在步骤2中获得的路径。我的是'/usr/local/Cellar/postgresql/9.5.0/bin/pg_config‘
PATH=$PATH:/usr/local/Cellar/postgresql/9.5.0/bin/+pip安装psycopg2|offset|length|style|BOLD|307593|unstyled|entityMap^0|0|0|F|3|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|O|8|@$F|P|G|Q|H|I]]|9|@]|A|$]]|$1|J|3|-4|5|K|7|R|8|@]|9|@]|A|$]]]|L|$]]

<ol>
<li>Install/update Xcode developer tools 

<pre><code>xcode-select --install
</code></pre></li>
<li>Query postgres path

<pre><code>find / -name pg_config 2&gt;/dev/null
</code></pre></li>
<li>Install psycopg2, use the path you got in step 2. Mine was '/usr/local/Cellar/postgresql/9.5.0/bin/pg_config'

<pre><code>PATH=$PATH:/usr/local/Cellar/postgresql/9.5.0/bin/ pip install psycopg2
</code></pre></li>
</ol>

blocks|key|115403|text|嗯，很多不同的选择对我没有用，但最终还是成功了！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|115404|首先，尝试如下：|115405|brew+reinstall+openssl|code-block|syntax|javascript|115406|在重新安装过程结束时，您将得到警告部分中的基本行，因为我使用了macOS+Big+(Version11.1)和zsh终端，因此我已经将这些行放在了zshrc文件中。|offset|length|style|BOLD|115407|打开特定于您的系统的zshrc或其他配置文件：|115408|nano+~/.zshrc|115409|将下面的行粘贴到末尾(或者将这些命令相应地更改为警告)，请记住，Homebrew提供的OpenSSL可能与系统的OpenSSL相冲突(我收到了macOS提供LibreSSL的警告)，但它还是运行得很好：|115410|export+PATH="/opt/homebrew/opt/openssl@1.1/bin:$PATH"
export+LDFLAGS="-L/opt/homebrew/opt/openssl@1.1/lib"
export+CPPFLAGS="-I/opt/homebrew/opt/openssl@1.1/include"|115411|保存文件并通过按%5EX并使用Yes确认退出。|115412|希望您现在可以安装psycopg2：|115413|pip3+install+psycopg2-binary|115414|我仍然不知道问题的根本原因是什么，当我试图为我的项目重新安装pipenv+(可能是最近的一些系统更新)时，它突然出现了。|115415|entityMap^0|0|0|0|F|2|0|0|0|O|2|0|0|8|2|D|3|0|0|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|17|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|18|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|19|8|@$K|1A|L|1B|M|N]]|9|@]|A|$]]|$1|O|3|P|5|6|7|1C|8|@]|9|@]|A|$]]|$1|Q|3|R|5|F|7|1D|8|@]|9|@]|A|$G|H]]|$1|S|3|T|5|6|7|1E|8|@$K|1F|L|1G|M|N]]|9|@]|A|$]]|$1|U|3|V|5|F|7|1H|8|@]|9|@]|A|$G|H]]|$1|W|3|X|5|6|7|1I|8|@$K|1J|L|1K|M|N]|$K|1L|L|1M|M|N]]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1N|8|@]|9|@]|A|$]]|$1|10|3|11|5|F|7|1O|8|@]|9|@]|A|$G|H]]|$1|12|3|13|5|6|7|1P|8|@]|9|@]|A|$]]|$1|14|3|-4|5|6|7|1Q|8|@]|9|@]|A|$]]]|15|$]]

Well, tons of different options didn't work for me, but finally!
First, try this:
<pre><code>brew reinstall openssl
</code></pre>
At the end of the reinstallation process you will get basically the following lines within Caveats section, which I've put in the zshrc config file since I use macOS Big Sur (version 11.1) and zsh terminal.
Open zshrc or other config file specific to your system:
<pre><code>nano ~/.zshrc
</code></pre>
Paste the following lines at the end (or change these commands accordingly to the Caveats you've got), just keep in mind that OpenSSL provided by Homebrew might conflict with the system's one (I've got a warning that macOS provides LibreSSL) but it worked well anyway:
<pre><code>export PATH=&quot;/opt/homebrew/opt/openssl@1.1/bin:$PATH&quot;
export LDFLAGS=&quot;-L/opt/homebrew/opt/openssl@1.1/lib&quot;
export CPPFLAGS=&quot;-I/opt/homebrew/opt/openssl@1.1/include&quot;
</code></pre>
Save the file and exit by pressing ^X and confirming with Yes.
Hopefully you can now install psycopg2:
<pre><code>pip3 install psycopg2-binary
</code></pre>
I'm still not sure what was the root cause of the problem, it just appeared suddenly when I tried to reinstall pipenv for my project (maybe some recent system updates).

blocks|key|2035008|text|看起来openssl包没有安装。试着重新安装它和pip+install。我不是macos用户，但我相信brew简化了该平台上的包管理。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2035009|您还可能需要安装Python开发和postgresql开发包。|2035010|entityMap|0|LINK|mutability|MUTABLE|url|http://brew.sh/^0|O|B|1F|4|1F|4|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]|$9|S|A|T|B|C]]|D|@$9|U|A|V|1|W]]|E|$]]|$1|F|3|G|5|6|7|X|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]]]

It looks like the openssl package is not installed. Try installing it and <code>pip install</code> again. I'm not a macos user, but I believe that <a href="http://brew.sh/" rel="nofollow"><code>brew</code></a> simplifies package management on that platform.

You might also need to install the Python development and postgresql development packages.

blocks|key|115112|text|这对我(在终端上)是可行的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|115113|find+/+-name+pg_config++2>/dev/null|code-block|syntax|javascript|115114|然后添加路径：|115115|export+PATH=$PATH:/Applications/Postgres.app/Contents/Versions/9.5/bin/|115116|操作系统版本:+MacOs塞拉利昂|115117|我希望这能帮到你。|115118|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

This works for me (on a terminal):

<pre><code>find / -name pg_config 2&gt;/dev/null
</code></pre>

then add the path:

<pre><code>export PATH=$PATH:/Applications/Postgres.app/Contents/Versions/9.5/bin/
</code></pre>

os version: MacOs Sierra 

I hope this helps.

blocks|key|2035168|text|以前，但是对于使用pipenv的人来说，我通过查看我的依赖关系图pipenv+graph+--reverse并注意到它需要psycopg2-binary==2.8.2来解决这个问题。运行pipenv+install+psycopg2-binary解决了这个问题。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2035169|entityMap^0|W|M|1P|M|2L|U|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|O|8|@]|D|@]|E|$]]]|G|$]]

Old, but for folks using pipenv, I resolved this issue by looking at my dependency graph <code>pipenv graph --reverse</code> and noticing it required <code>psycopg2-binary==2.8.2</code>. Running <code>pipenv install psycopg2-binary</code> resolved the issue.

blocks|key|307680|text|env+LDFLAGS="-I/usr/local/opt/openssl/include+-L/usr/local/opt/openssl/lib"+\
brew+upgrade+openssl|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|307681|然后我就可以安装psycopg2了|unstyled|offset|length|style|CODE|307682|entityMap^0|0|8|8|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|N|8|@$G|O|H|P|I|J]]|9|@]|A|$]]|$1|K|3|-4|5|F|7|Q|8|@]|9|@]|A|$]]]|L|$]]

<pre><code>env LDFLAGS="-I/usr/local/opt/openssl/include -L/usr/local/opt/openssl/lib" \
brew upgrade openssl
</code></pre>

Then I could install <code>psycopg2</code>

blocks|key|115310|text|试试这个->pip安装心理学2-二进制|type|unstyled|depth|inlineStyleRanges|entityRanges|data|115311|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

try this --&gt;pip install psycopg2-binary

blocks|key|307721|text|如果您不想使用brew，下面是“MacOS专用解决方案”：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|307722|sudo+installer+-pkg+/Library/Developer/CommandLineTools/Packages/macOS_SDK_headers_for_macOS_10.14.pkg+-target+/|code-block|syntax|javascript|307723|之后，pip将很高兴地从源代码中安装psycopg2。与"Mojave“一起工作(macOS+10.14)。|307724|entityMap^0|7|4|0|0|3|3|I|8|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|X|8|@]|D|@]|E|$]]]|N|$]]

In case you don't want to faff around with <code>brew</code>, here's the "MacOS-only solution":

<pre><code>sudo installer -pkg /Library/Developer/CommandLineTools/Packages/macOS_SDK_headers_for_macOS_10.14.pkg -target /
</code></pre>

After this, <code>pip</code> will gladly install <code>psycopg2</code> from the source. Works with "Mojave" (macOS 10.14).

blocks|key|307793|text|唯一对我有用的是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|307794|pip+install+psycopg2==2.7.7|code-block|syntax|javascript|307795|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

The only thing that worked for me was:
<pre><code>pip install psycopg2==2.7.7
</code></pre>

blocks|key|115450|text|试着安装：pip+install+psycopg2-binary它可以工作|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|115451|entityMap^0|5|R|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Try installing:
<code>pip install psycopg2-binary</code>
it works

blocks|key|2035438|text|我在macOS、Big+(11.5.1)和Python3.9.6上也遇到了同样的错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2035439|事实证明，我使用的psycopg2+(以及熊猫)版本太老了。错误消失了，pip+install在升级了上面的软件包后就开始正常工作了。|offset|length|style|CODE|2035440|参考文献：https://github.com/Azure/azure-cli/issues/12854#issuecomment-619213863|2035441|通常，如果其他人在这里提出的解决方案没有帮助，请尝试升级麻烦的python包。|2035442|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/Azure/azure-cli/issues/12854#issuecomment-619213863^0|0|10|B|0|5|1Y|0|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@$D|V|E|W|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@$D|Y|E|Z|1|10]]|A|$]]|$1|J|3|K|5|6|7|11|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S]]]]

I ran into the same error on macOS Big Sur (11.5.1) and Python 3.9.6.
It turned out, the psycopg2 (as well as pandas) versions I was using were too old. The error disappeared and <code>pip install</code> started working fine after upgrading the above packages.
Ref: <a href="https://github.com/Azure/azure-cli/issues/12854#issuecomment-619213863" rel="nofollow noreferrer">https://github.com/Azure/azure-cli/issues/12854#issuecomment-619213863</a>
In general, if the solutions suggested here by others don't help, try upgrading the troubling python package.

blocks|key|2035537|text|在我的场景中，它是在以下方面执行的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2035538|ProductName:++++macOS
ProductVersion:+12.1
BuildVersion:+++21C52|code-block|syntax|javascript|2035539|我继续通过brew命令安装以下库：|unordered-list-item|offset|length|style|CODE|2035540|brew+install+openssl+libpq|2035541|设置特定变量：|2035542|export+LDFLAGS="-L/opt/homebrew/opt/libpq/lib+-L/opt/homebrew/opt/openssl@3/lib"
export+CPPFLAGS="-I/opt/homebrew/opt/libpq/include+-I/opt/homebrew/opt/openssl@3/include"|2035543|继续通过psycopg2-binary安装python包pip3|2035544|pip3+install+psycopg2-binary|2035545|如果您想知道为什么需要设置这些特定变量，请通过brew+info命令查看包的文档：|2035546|brew+info+openssl
brew+info+libpq|2035547|当显示结果时，请查找以下句子：|2035548|...
For+compilers+to+find+libpq+you+may+need+to+set:
++export+LDFLAGS="-L/opt/homebrew/opt/libpq/lib"
++export+CPPFLAGS="-I/opt/homebrew/opt/libpq/include"
...
For+compilers+to+find+openssl@3+you+may+need+to+set:
++export+LDFLAGS="-L/opt/homebrew/opt/openssl@3/lib"
++export+CPPFLAGS="-I/opt/homebrew/opt/openssl@3/include"
...|2035549|这就是为什么当pip正在安装一个包时，需要一个参考来查找库/编译器。|2035550|设置此变量的最佳位置是~/.bashrc，用于未来有关postgres和ssl的安装|2035551|export+LDFLAGS="-L/opt/homebrew/opt/libpq/lib+-L/opt/homebrew/opt/openssl@3/lib"
export+CPPFLAGS="-I/opt/homebrew/opt/libpq/include+-I/opt/homebrew/opt/openssl@3/include"|2035552|entityMap^0|0|0|5|4|0|0|0|0|4|F|S|4|0|0|N|9|0|0|0|0|7|3|0|B|9|R|8|10|3|0|0^^$0|@$1|2|3|4|5|6|7|1D|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1E|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|I|7|1F|8|@$J|1G|K|1H|L|M]]|9|@]|A|$]]|$1|N|3|O|5|D|7|1I|8|@]|9|@]|A|$E|F]]|$1|P|3|Q|5|I|7|1J|8|@]|9|@]|A|$]]|$1|R|3|S|5|D|7|1K|8|@]|9|@]|A|$E|F]]|$1|T|3|U|5|I|7|1L|8|@$J|1M|K|1N|L|M]|$J|1O|K|1P|L|M]]|9|@]|A|$]]|$1|V|3|W|5|D|7|1Q|8|@]|9|@]|A|$E|F]]|$1|X|3|Y|5|6|7|1R|8|@$J|1S|K|1T|L|M]]|9|@]|A|$]]|$1|Z|3|10|5|D|7|1U|8|@]|9|@]|A|$E|F]]|$1|11|3|12|5|6|7|1V|8|@]|9|@]|A|$]]|$1|13|3|14|5|D|7|1W|8|@]|9|@]|A|$E|F]]|$1|15|3|16|5|6|7|1X|8|@$J|1Y|K|1Z|L|M]]|9|@]|A|$]]|$1|17|3|18|5|6|7|20|8|@$J|21|K|22|L|M]|$J|23|K|24|L|M]|$J|25|K|26|L|M]]|9|@]|A|$]]|$1|19|3|1A|5|D|7|27|8|@]|9|@]|A|$E|F]]|$1|1B|3|-4|5|6|7|28|8|@]|9|@]|A|$]]]|1C|$]]

On my scenario, it was performed on:
<pre><code>ProductName: macOS
ProductVersion: 12.1
BuildVersion: 21C52
</code></pre>
<ul>
<li>I proceed to install the following libraries by <code>brew</code>command:</li>
</ul>
<pre class="lang-bash prettyprint-override"><code>brew install openssl libpq
</code></pre>
<ul>
<li>Set specific variables:</li>
</ul>
<pre class="lang-bash prettyprint-override"><code>export LDFLAGS=&quot;-L/opt/homebrew/opt/libpq/lib -L/opt/homebrew/opt/openssl@3/lib&quot;
export CPPFLAGS=&quot;-I/opt/homebrew/opt/libpq/include -I/opt/homebrew/opt/openssl@3/include&quot;
</code></pre>
<ul>
<li>Proceed to install the python package <code>psycopg2-binary</code> via <code>pip3</code>:</li>
</ul>
<pre class="lang-bash prettyprint-override"><code>pip3 install psycopg2-binary
</code></pre>
If you are wondering why it is necessary to set those specific variables, take a look in the docs of the package via <code>brew info</code> command:
<pre class="lang-bash prettyprint-override"><code>brew info openssl
brew info libpq
</code></pre>
When the outcome is displayed, look for this sentence:
<pre><code>...
For compilers to find libpq you may need to set:
 export LDFLAGS=&quot;-L/opt/homebrew/opt/libpq/lib&quot;
 export CPPFLAGS=&quot;-I/opt/homebrew/opt/libpq/include&quot;
...
For compilers to find openssl@3 you may need to set:
 export LDFLAGS=&quot;-L/opt/homebrew/opt/openssl@3/lib&quot;
 export CPPFLAGS=&quot;-I/opt/homebrew/opt/openssl@3/include&quot;
...
</code></pre>
Thats why, when <code>pip</code> is installing a package, needs a reference where to look for the libraries/compilers.
A perfect place to set this variables would be <code>~/.bashrc</code>, for future installations regarding <code>postgres</code> and <code>ssl</code>:
<pre class="lang-bash prettyprint-override"><code>export LDFLAGS=&quot;-L/opt/homebrew/opt/libpq/lib -L/opt/homebrew/opt/openssl@3/lib&quot;
export CPPFLAGS=&quot;-I/opt/homebrew/opt/libpq/include -I/opt/homebrew/opt/openssl@3/include&quot;
</code></pre>

blocks|key|2035279|text|按照当前/todey条件解决方案，这是-卸载您的python+3.8或3.9左右，并安装ptyhon3.7.4|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2035280|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

As per current/todey condition -
only solution for this is -
uninstall your python 3.8 or 3.9 or so on
and install ptyhon 3.7.4

I am working on a project for one of my lectures and I need to download the package psycopg2 in order to work with the postgresql database in use. Unfortunately, when I try to pip install psycopg2 the following error pops up:
<pre><code>ld: library not found for -lssl
clang: error: linker command failed with exit code 1 (use -v to see invocation)
error: command '/usr/bin/clang' failed with exit status 1
ld: library not found for -lssl
clang: error: linker command failed with exit code 1 (use -v to see invocation)
error: command '/usr/bin/clang' failed with exit status 1
</code></pre>
Does anyone know why this is happening? Thanks in advance!

Can't install psycopg2 package through pip install on MacOS

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在为我的一个讲座做一个项目，我需要下载软件包psycopg2，以便使用postgresql数据库。不幸的是，当我试图安装psycopg2时，会弹出以下错误：ld: library not found for -lsslclang: error: linker command failed with exit code 1 (use -v to see invocation)error: com

问无法通过pip安装在psycopg2上安装MacOS包
EN

回答 19

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法通过pip安装在psycopg2上安装MacOS包EN

回答 19

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法通过pip安装在psycopg2上安装MacOS包
EN