{"id":9212,"date":"2024-03-15T11:24:00","date_gmt":"2024-03-15T03:24:00","guid":{"rendered":"\/?p=9212"},"modified":"2024-03-15T11:25:35","modified_gmt":"2024-03-15T03:25:35","slug":"psycopg2%e6%8a%a5%e9%94%99%ef%bc%9aimporterror-libpq-so-5-cannot-open-shared-object-file-no-such-file-or-directory","status":"publish","type":"post","link":"\/?p=9212","title":{"rendered":"psycopg2\u62a5\u9519\uff1aImportError: libpq.so.5: cannot open shared object file: No such file or directory"},"content":{"rendered":"<h2>\u95ee\u9898\u63cf\u8ff0\uff1a<\/h2>\n<p>\u542f\u52a8fastapi\u670d\u52a1\u65f6\u63d0\u793apsycopg2\u7684\u9519\u8bef\uff1a<\/p>\n<pre><code>Traceback (most recent call last):\n  File &quot;ruiqi_qdp_verify_server.py&quot;, line 6, in &lt;module&gt;\n    from apps.query_qdp.interact_qdp import main as qdp_main\n  File &quot;\/home\/rhino\/lxc\/ruiqi_qdp_verify\/apps\/query_qdp\/interact_qdp.py&quot;, line 16, in &lt;module&gt;\n    from utils.pipeline_pgsql import ItemToPG\n  File &quot;\/home\/rhino\/lxc\/ruiqi_qdp_verify\/utils\/pipeline_pgsql.py&quot;, line 6, in &lt;module&gt;\n    import psycopg2\n  File &quot;\/home\/rhino\/envs\/python3_django\/lib\/python3.6\/site-packages\/psycopg2-2.8.6-py3.6-linux-x86_64.egg\/psycopg2\/__init__.py&quot;, line 5\n    from psycopg2._psycopg import (                     # noqa\nImportError: libpq.so.5: cannot open shared object file: No such file or directory<\/code><\/pre>\n<p>\u52a0\u8f7d\u5171\u4eab\u5e93\u65f6\u51fa\u9519: libpq.so.5:\u65e0\u6cd5\u6253\u5f00\u5171\u4eab\u5bf9\u8c61\u6587\u4ef6:\u6ca1\u6709\u8fd9\u6837\u7684\u6587\u4ef6\u6216\u76ee\u5f55<\/p>\n<h2>\u89e3\u51b3\uff1a<\/h2>\n<p>Stack Overflow\u7528\u6237<br \/>\n\u53d1\u5e03\u4e8e 2015-03-12 21:48:01<\/p>\n<p>\u8bd5\u8bd5\u8fd9\u4e2a\uff1a<\/p>\n<p>1:\u77e5\u9053libpq.so.5\u7684\u8def\u5f84<\/p>\n<pre><code>find \/ -name libpq.so.5<\/code><\/pre>\n<p>\u8f93\u51fa\u793a\u4f8b\uff1a<\/p>\n<pre><code>\/usr\/pgsql-9.4\/lib\/libpq.so.5<\/code><\/pre>\n<p>\u5982\u679c\u672a\u627e\u5230\u4efb\u4f55\u5185\u5bb9\uff0c\u8bf7\u68c0\u67e5\u662f\u5426\u5df2\u5b89\u88c5\u9002\u7528\u4e8e\u60a8\u7684postgresql\u7248\u672c\u548cOS\u5e73\u53f0\u7684postgresql-libs<\/p>\n<p>2:\u7b26\u53f7\u94fe\u63a5\u5e93\uff0c\u5c06\u5e93\u94fe\u63a5\u5230\u201c\u4f17\u6240\u5468\u77e5\u201d\u5e93\u8def\u5f84\u4e2d\uff0c\u5982\/usr\/lib<\/p>\n<pre><code>ln -s \/usr\/pgsql-9.4\/lib\/libpq.so.5 \/usr\/lib\/libpq.so.5<\/code><\/pre>\n<p>\u6ce8\u610f:\u5982\u679c\u60a8\u7684\u5e73\u53f0\u662f64\u4f4d\u7684\uff0c\u5219\u8fd8\u5fc5\u987b\u7b26\u53f7\u94fe\u63a5\u523064\u4f4d\u7684\u5e93\u8def\u5f84\uff1a<\/p>\n<pre><code>ln -s \/usr\/pgsql-9.4\/lib\/libpq.so.5 \/usr\/lib64\/libpq.so.5<\/code><\/pre>\n<p>PS:\u6211\u662f\u628a\u4e24\u4e2a\u4f4d\u7f6e\u90fd\u590d\u5236\u4e86,\u7528\u7684\u662froot<\/p>\n<pre><code>[root@localhost ~]# ln -s \/usr\/pgsql-11\/lib\/libpq.so.5 \/usr\/lib\/libpq.so.5\n[root@localhost ~]# ln -s \/usr\/pgsql-11\/lib\/libpq.so.5 \/usr\/lib64\/libpq.so.5<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u95ee\u9898\u63cf\u8ff0\uff1a \u542f\u52a8fastapi\u670d\u52a1\u65f6\u63d0\u793apsycopg2\u7684\u9519\u8bef\uff1a Traceback (most recent call last):    \u2026 &#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0},"categories":[1],"tags":[247,16],"_links":{"self":[{"href":"\/index.php?rest_route=\/wp\/v2\/posts\/9212"}],"collection":[{"href":"\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9212"}],"version-history":[{"count":2,"href":"\/index.php?rest_route=\/wp\/v2\/posts\/9212\/revisions"}],"predecessor-version":[{"id":9214,"href":"\/index.php?rest_route=\/wp\/v2\/posts\/9212\/revisions\/9214"}],"wp:attachment":[{"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9212"},{"taxonomy":"post_tag","embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}