MIME-Version: 1.0
From: Gil Sousa <gilsousa@gmail.com>
Date: Tue, 6 Sep 2022 17:06:28 +0100
Message-ID: 
 <CAOUL5-rK5Z8TfztbFo-uPOb37kjb9kcNiGUGZ7RKPSwny4X+Kg@mail.gmail.com>
Subject: ImportError: symbol not found in flat namespace '_PQbackendPID'
To: psycopg@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000a66c4a05e8046124"
Archived-At: 
 <https://www.postgresql.org/message-id/CAOUL5-rK5Z8TfztbFo-uPOb37kjb9kcNiGUGZ7RKPSwny4X%2BKg%40mail.gmail.com>
Precedence: bulk

--000000000000a66c4a05e8046124
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi all,

I am trying to use psycopg2 for the very first time, though I am stumbling
with an error when trying to import the module:

=E2=9C=97 python3.9 radars_import.py
Traceback (most recent call last):
  File "/Users/gilsousa/Documents/git Projects/ReportGen/radars_import.py",
line 2, in <module>
    import psycopg2
  File
"/Users/gilsousa/Library/Python/3.9/lib/python/site-packages/psycopg2/__ini=
t__.py",
line 51, in <module>
    from psycopg2._psycopg import (                     # noqa
ImportError:
dlopen(/Users/gilsousa/Library/Python/3.9/lib/python/site-packages/psycopg2=
/_
psycopg.cpython-39-darwin.so, 0x0002): symbol not found in flat namespace
'_PQbackendPID'

I made sure that I have the packages installed, both psycopg2
and psycopg2-binary. I even tried to uninstall both and just try one at a
time, also didn't work.

How can I fix this problem?

Thank you,

Gil Sousa
www.gilsousa.eu

--000000000000a66c4a05e8046124
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi all,</div><div><br></div><div>I am trying to use p=
sycopg2 for the very first time, though I am stumbling with an error when t=
rying to import the module:</div><div><br></div><div>=E2=9C=97 python3.9 ra=
dars_import.py =C2=A0 =C2=A0<br>Traceback (most recent call last):<br>=C2=
=A0 File &quot;/Users/gilsousa/Documents/git Projects/ReportGen/radars_impo=
rt.py&quot;, line 2, in &lt;module&gt;<br>=C2=A0 =C2=A0 import psycopg2<br>=
=C2=A0 File &quot;/Users/gilsousa/Library/Python/3.9/lib/python/site-packag=
es/psycopg2/__init__.py&quot;, line 51, in &lt;module&gt;<br>=C2=A0 =C2=A0 =
from psycopg2._psycopg import ( =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 # noqa<br>ImportError: dlopen(/Users/gilsousa/L=
ibrary/Python/3.9/lib/python/site-packages/psycopg2/_<a href=3D"http://psyc=
opg.cpython-39-darwin.so">psycopg.cpython-39-darwin.so</a>, 0x0002): symbol=
 not found in flat namespace &#39;_PQbackendPID&#39;<br><br></div><div>I ma=
de sure that I have the packages installed, both=C2=A0psycopg2 and=C2=A0psy=
copg2-binary. I even tried to uninstall both and just try one at a time, al=
so didn&#39;t work.</div><div><br></div><div>How can I fix this=C2=A0proble=
m?</div><div><br></div><div>Thank you,</div><br clear=3D"all"><div><div dir=
=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div =
dir=3D"ltr"><div><div dir=3D"ltr"><div>Gil Sousa</div><div><a href=3D"http:=
//www.gilsousa.eu" target=3D"_blank">www.gilsousa.eu</a></div></div></div><=
/div></div></div></div>

--000000000000a66c4a05e8046124--