psycopg2 pip install error

Created on 19 Jan 2016  路  18Comments  路  Source: psycopg/psycopg2

Python version 3.5.1

How to reproduce :

  • Create requirements.txt file with content :

Django==1.9.1
psycopg2==2.6

  • run pip install -r requirements.txt
  • you should get error :

.\psycopg/config.h(150): error C2941: 'round' : definition of dllimport function not allowed

windows
Source
picture bysreg

Most helpful comment

Same issue here:
Windows 10
Python 3.5.1
Postgresql 9.5
Visual Studio Community 2015

When installing psycopg2 via pip I got the following error:

. . .
    psycopgmodule.c
    .\psycopg/config.h(134): warning C4005: 'isnan': macro redefinition
    C:\Program Files (x86)\Windows Kits\10\include\10.0.10586.0\ucrt\math.h(277): note: see previous definition of 'isnan'
    .\psycopg/config.h(138): warning C4005: 'isinf': macro redefinition
    C:\Program Files (x86)\Windows Kits\10\include\10.0.10586.0\ucrt\math.h(276): note: see previous definition of 'isinf'
    .\psycopg/config.h(150): error C2491: 'round': definition of dllimport function not allowed
    error: command 'C:\\Program Files (x86)\\Microsoft Visual Studio 14.0\\VC\\BIN\\cl.exe' failed with exit status 2
. . .
picture echiesse on 1 Mar 2016
👍9

All 18 comments

+1, but if I use setup from archive: https://github.com/psycopg/psycopg2/issues/399

SowingSadness picture SowingSadness on 27 Jan 2016

This report is too incomplete to be considered. Surely "pip install" is not enough to make psycopg fail.

We should know at least what your system is. I've never seen that error. It seems windows though: please install Windows from binaries, unless you have a really good reason.

dvarrazzo picture dvarrazzo on 29 Jan 2016

@dvarrazzo yes, it was windows. So, pip install is not officially supported on windows?

bysreg picture bysreg on 29 Jan 2016

Future versions will be installed ok via wheels. For the moment I'd say "undefined". However, missing 'round' sounds strange. I don't know if @jerickso knows anything more.

dvarrazzo picture dvarrazzo on 29 Jan 2016

@bysreg
Just used re-installed python3.4.4, and then used the latest wheel to install psycopg2 successfully.
You can download the wheel from https://pypi.python.org/pypi/psycopg2.

mqslove17 picture mqslove17 on 27 Feb 2016

Same issue here:
Windows 10
Python 3.5.1
Postgresql 9.5
Visual Studio Community 2015

When installing psycopg2 via pip I got the following error:

. . .
    psycopgmodule.c
    .\psycopg/config.h(134): warning C4005: 'isnan': macro redefinition
    C:\Program Files (x86)\Windows Kits\10\include\10.0.10586.0\ucrt\math.h(277): note: see previous definition of 'isnan'
    .\psycopg/config.h(138): warning C4005: 'isinf': macro redefinition
    C:\Program Files (x86)\Windows Kits\10\include\10.0.10586.0\ucrt\math.h(276): note: see previous definition of 'isinf'
    .\psycopg/config.h(150): error C2491: 'round': definition of dllimport function not allowed
    error: command 'C:\\Program Files (x86)\\Microsoft Visual Studio 14.0\\VC\\BIN\\cl.exe' failed with exit status 2
. . .
echiesse picture echiesse on 1 Mar 2016
👍9

Visual Studio 2015 now has their own round/isinf/isnan functions/macros causing the conflicts. @Photonios created a patch last fall for the build to be compatible with Visual Studio 2015 and it was merged into the master branch around Sept.

I believe one can install psycopg2 on Python 3.5/windows via pip the following way (I'm not a pip user, so corrections welcomed):
pip install git+https://github.com/psycopg2/psycopg2.git@master

Note that this is installing the current state of the pyscopg2 master branch, so it may not be ideal for your situation.

@dvarrazzo, since we are seeing more Python 3.5 usage, is it time for us to look into doing another release?

jerickso picture jerickso on 4 Mar 2016

Yes I was thinking about that. We should make 3.5 well supported into 2.6.2. @jerickso, are all the patches required for 3.5 windows build into the maint_2_6 branch too?

dvarrazzo picture dvarrazzo on 5 Mar 2016

@jerickso these issues probably all refer to the same build problem. Can you please check that your state of your maint_2_6 branch has everything in so I can merge it?

This specific issue can be fixed as duplicated of issue #350.

dvarrazzo picture dvarrazzo on 5 Mar 2016

@dvarrazzo,

The only thing I don't see in the maint_2_6 branch is the pull request I have out there, #370. I probably didn't ping you after I created it. I also have it in my maint_2_6 branch.

jerickso picture jerickso on 5 Mar 2016

Yeah, that's the thing that actually I didn't want to push in a maintenance release. But I think I'll just bite the bullet because 2.7 is not behind the corner, given the scarce time I can find for the project in this period.

dvarrazzo picture dvarrazzo on 7 Mar 2016

Requirement already satisfied (use --upgrade to upgrade): django<2,>=1.9 in c:\python_worskpace\djangowebproject1\djangowebproject1\env\lib\site-packages (from -r C:\python_worskpace\DjangoWebProject1\DjangoWebProject1\requirements.txt (line 1))
Collecting psycopg2 (from -r C:\python_worskpace\DjangoWebProject1\DjangoWebProject1\requirements.txt (line 2))
Using cached psycopg2-2.6.1.tar.gz
Building wheels for collected packages: psycopg2
Running setup.py bdist_wheel for psycopg2: started
Running setup.py bdist_wheel for psycopg2: finished with status 'error'
Complete output from command C:\python_worskpace\DjangoWebProject1\DjangoWebProject1\env\Scripts\python.exe -u -c "import setuptools, tokenize;file='C:\Users\altieris\AppData\Local\Temp\pip-build-gy9ftu60\psycopg2\setup.py';exec(compile(getattr(tokenize, 'open', open)(file).read().replace('\r\n', '\n'), file, 'exec'))" bdist_wheel -d C:\Users\altieris\AppData\Local\Temp\tmpqxh6ty7cpip-wheel- --python-tag cp35:
running bdist_wheel
running build
Failed building wheel for psycopg2
running build_py
creating build
creating build\lib.win32-3.5
creating build\lib.win32-3.5\psycopg2
copying lib\errorcodes.py -> build\lib.win32-3.5\psycopg2
copying lib\extensions.py -> build\lib.win32-3.5\psycopg2
copying lib\extras.py -> build\lib.win32-3.5\psycopg2
copying lib\pool.py -> build\lib.win32-3.5\psycopg2
copying lib\psycopg1.py -> build\lib.win32-3.5\psycopg2
copying lib\tz.py -> build\lib.win32-3.5\psycopg2
copying lib_json.py -> build\lib.win32-3.5\psycopg2
copying lib_range.py -> build\lib.win32-3.5\psycopg2
copying lib__init__.py -> build\lib.win32-3.5\psycopg2
creating build\lib.win32-3.5\psycopg2\tests
copying tests\dbapi20.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\dbapi20_tpc.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\testconfig.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\testutils.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\test_async.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\test_bugX000.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\test_bug_gc.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\test_cancel.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\test_connection.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\test_copy.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\test_cursor.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\test_dates.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\test_extras_dictcursor.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\test_green.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\test_lobject.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\test_module.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\test_notify.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\test_psycopg2_dbapi20.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\test_quote.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\test_transaction.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\test_types_basic.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\test_types_extras.py -> build\lib.win32-3.5\psycopg2\tests
copying tests\test_with.py -> build\lib.win32-3.5\psycopg2\tests
copying tests__init__.py -> build\lib.win32-3.5\psycopg2\tests
Skipping optional fixer: buffer
Skipping optional fixer: idioms
Skipping optional fixer: set_literal
Skipping optional fixer: ws_comma
running build_ext
building 'psycopg2._psycopg' extension
creating build\temp.win32-3.5
creating build\temp.win32-3.5\Release
creating build\temp.win32-3.5\Release\psycopg
C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\cl.exe /c /nologo /Ox /W3 /GL /DNDEBUG /MD -DPSYCOPG_DEFAULT_PYDATETIME=1 "-DPSYCOPG_VERSION=\"2.6.1 (dt dec pq3 ext)\"" -DPG_VERSION_HEX=0x090503 -IC:\Python\Python35-32include -IC:\Python\Python35-32include -I. -IC:/PROGRA~1/POSTGR~1/9.5/include -IC:/PROGRA~1/POSTGR~1/9.5/include/server "-IC:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE" "-IC:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\ATLMFC\INCLUDE" "-IC:\Program Files (x86)\Windows Kits\10include\10.0.10240.0\ucrt" "-IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.6.1include\um" "-IC:\Program Files (x86)\Windows Kits\8.1include\shared" "-IC:\Program Files (x86)\Windows Kits\8.1include\um" "-IC:\Program Files (x86)\Windows Kits\8.1include\winrt" /Tcpsycopg\psycopgmodule.c /Fobuild\temp.win32-3.5\Release\psycopg\psycopgmodule.obj
psycopgmodule.c
.\psycopg/config.h(134): warning C4005: 'isnan': macro redefinition
C:\Program Files (x86)\Windows Kits\10include\10.0.10240.0\ucrt\math.h(264): note: see previous definition of 'isnan'
.\psycopg/config.h(138): warning C4005: 'isinf': macro redefinition
C:\Program Files (x86)\Windows Kits\10include\10.0.10240.0\ucrt\math.h(263): note: see previous definition of 'isinf'
.\psycopg/config.h(150): error C2491: 'round': definition of dllimport function not allowed
error: command 'C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\cl.exe' failed with exit status 2

altierispeixoto picture altierispeixoto on 2 Jun 2016

I'm having the same issue with the same setup but as echiesse.

hoelter picture hoelter on 19 Jun 2016

Same issue here. Any news about this? Maybe how to workaround this issue?

ailjushkin picture ailjushkin on 5 Aug 2017

@PositiveAlex update your pip and you will get a binary version installed. This issue was referred to when there weren't wheel packages on pip so you had to compile it yourself and on windows it is a pain in the neck.

dvarrazzo picture dvarrazzo on 7 Aug 2017
👍1

You may receive this message if you have pinned an old version of psycopg2 in requirements.txt. If you set the version to at least psycopg2==2.7.3.2 and upgrade pip with pip install --upgrade pip, it should work on Windows.

shuckc picture shuckc on 31 Jan 2018

when I am Running setup.py install for psycopg2 by pip install -r requirement.txt, I get it from my terminal and I don't know what I should do, can any body help me??

ERROR: Complete output from command /Users/hadi/.virtualenvs/myvenv/bin/python3 -u -c 'import setuptools, tokenize;__file__='"'"'/private/var/folders/0w/87fdgwgx0w7b7c3zj2y_01sh0000gn/T/pip-install-lt4288vh/psycopg2/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record /private/var/folders/0w/87fdgwgx0w7b7c3zj2y_01sh0000gn/T/pip-record-ips11cam/install-record.txt --single-version-externally-managed --compile --install-headers /Users/hadi/.virtualenvs/myvenv/include/site/python3.7/psycopg2:
    ERROR: running install
    running build
    running build_py
    creating build
    creating build/lib.macosx-10.14-x86_64-3.7
    creating build/lib.macosx-10.14-x86_64-3.7/psycopg2
    copying lib/_json.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2
    copying lib/extras.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2
    copying lib/errorcodes.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2
    copying lib/tz.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2
    copying lib/_range.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2
    copying lib/_ipaddress.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2
    copying lib/__init__.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2
    copying lib/psycopg1.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2
    copying lib/extensions.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2
    copying lib/sql.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2
    copying lib/pool.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2
    creating build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_transaction.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/dbapi20.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_extras_dictcursor.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_with.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_types_basic.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_bug_gc.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_module.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_psycopg2_dbapi20.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_async.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_dates.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_async_keyword.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/testutils.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_connection.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_copy.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_bugX000.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/__init__.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_cursor.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_types_extras.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_sql.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_fast_executemany.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_green.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_ipaddress.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_cancel.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_quote.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/testconfig.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_errcodes.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_replication.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_lobject.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/test_notify.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    copying tests/dbapi20_tpc.py -> build/lib.macosx-10.14-x86_64-3.7/psycopg2/tests
    Skipping optional fixer: buffer
    Skipping optional fixer: idioms
    Skipping optional fixer: set_literal
    Skipping optional fixer: ws_comma
    running build_ext
    building 'psycopg2._psycopg' extension
    creating build/temp.macosx-10.14-x86_64-3.7
    creating build/temp.macosx-10.14-x86_64-3.7/psycopg
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/psycopgmodule.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/psycopgmodule.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/green.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/green.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/pqpath.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/pqpath.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    psycopg/pqpath.c:214:17: warning: implicit conversion from enumeration type 'ConnStatusType' to different enumeration type 'ExecStatusType' [-Wenum-conversion]
                    PQstatus(conn->pgconn) : PQresultStatus(*pgres)));
                    ^~~~~~~~~~~~~~~~~~~~~~
    psycopg/pqpath.c:1985:17: warning: implicit conversion from enumeration type 'ConnStatusType' to different enumeration type 'ExecStatusType' [-Wenum-conversion]
                    PQstatus(curs->conn->pgconn) : PQresultStatus(curs->pgres)));
                    ^~~~~~~~~~~~~~~~~~~~~~~~~~~~
    2 warnings generated.
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/utils.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/utils.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/bytes_format.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/bytes_format.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    In file included from psycopg/bytes_format.c:81:
    In file included from ./psycopg/psycopg.h:37:
    ./psycopg/config.h:71:13: warning: unused function 'Dprintf' [-Wunused-function]
    static void Dprintf(const char *fmt, ...) {}
                ^
    1 warning generated.
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/libpq_support.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/libpq_support.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    In file included from psycopg/libpq_support.c:29:
    In file included from ./psycopg/psycopg.h:37:
    ./psycopg/config.h:71:13: warning: unused function 'Dprintf' [-Wunused-function]
    static void Dprintf(const char *fmt, ...) {}
                ^
    1 warning generated.
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/win32_support.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/win32_support.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    In file included from psycopg/win32_support.c:27:
    In file included from ./psycopg/psycopg.h:37:
    ./psycopg/config.h:71:13: warning: unused function 'Dprintf' [-Wunused-function]
    static void Dprintf(const char *fmt, ...) {}
                ^
    1 warning generated.
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/solaris_support.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/solaris_support.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    In file included from psycopg/solaris_support.c:27:
    In file included from ./psycopg/psycopg.h:37:
    ./psycopg/config.h:71:13: warning: unused function 'Dprintf' [-Wunused-function]
    static void Dprintf(const char *fmt, ...) {}
                ^
    1 warning generated.
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/connection_int.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/connection_int.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/connection_type.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/connection_type.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/cursor_int.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/cursor_int.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/cursor_type.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/cursor_type.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/replication_connection_type.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/replication_connection_type.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    In file included from psycopg/replication_connection_type.c:27:
    In file included from ./psycopg/psycopg.h:37:
    ./psycopg/config.h:71:13: warning: unused function 'Dprintf' [-Wunused-function]
    static void Dprintf(const char *fmt, ...) {}
                ^
    1 warning generated.
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/replication_cursor_type.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/replication_cursor_type.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/replication_message_type.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/replication_message_type.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/diagnostics_type.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/diagnostics_type.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    In file included from psycopg/diagnostics_type.c:27:
    In file included from ./psycopg/psycopg.h:37:
    ./psycopg/config.h:71:13: warning: unused function 'Dprintf' [-Wunused-function]
    static void Dprintf(const char *fmt, ...) {}
                ^
    1 warning generated.
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/error_type.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/error_type.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    In file included from psycopg/error_type.c:27:
    In file included from ./psycopg/psycopg.h:37:
    ./psycopg/config.h:71:13: warning: unused function 'Dprintf' [-Wunused-function]
    static void Dprintf(const char *fmt, ...) {}
                ^
    1 warning generated.
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/lobject_int.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/lobject_int.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/lobject_type.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/lobject_type.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/notify_type.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/notify_type.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    In file included from psycopg/notify_type.c:27:
    In file included from ./psycopg/psycopg.h:37:
    ./psycopg/config.h:71:13: warning: unused function 'Dprintf' [-Wunused-function]
    static void Dprintf(const char *fmt, ...) {}
                ^
    1 warning generated.
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/xid_type.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/xid_type.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/adapter_asis.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/adapter_asis.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/adapter_binary.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/adapter_binary.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/adapter_datetime.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/adapter_datetime.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/adapter_list.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/adapter_list.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/adapter_pboolean.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/adapter_pboolean.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/adapter_pdecimal.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/adapter_pdecimal.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/adapter_pint.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/adapter_pint.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/adapter_pfloat.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/adapter_pfloat.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/adapter_qstring.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/adapter_qstring.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/microprotocols.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/microprotocols.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/microprotocols_proto.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/microprotocols_proto.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    In file included from psycopg/microprotocols_proto.c:27:
    In file included from ./psycopg/psycopg.h:37:
    ./psycopg/config.h:71:13: warning: unused function 'Dprintf' [-Wunused-function]
    static void Dprintf(const char *fmt, ...) {}
                ^
    1 warning generated.
    clang -DNDEBUG -g -fwrapv -O3 -Wall -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.7.4 (dt dec pq3 ext lo64)" -DPG_VERSION_NUM=110002 -DHAVE_LO64=1 -I/Users/hadi/.virtualenvs/myvenv/include -I/usr/local/Cellar/python/3.7.3/Frameworks/Python.framework/Versions/3.7/include/python3.7m -I. -I/usr/local/Cellar/postgresql/11.2_1/include -I/usr/local/Cellar/postgresql/11.2_1/include/server -c psycopg/typecast.c -o build/temp.macosx-10.14-x86_64-3.7/psycopg/typecast.o
    clang: warning: argument unused during compilation: '-L/usr/local/lib' [-Wunused-command-line-argument]
    clang -bundle -undefined dynamic_lookup -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.14.sdk -L/usr/local/opt/zlib/lib -I/usr/local/include -L/usr/local/lib -I/usr/local/opt/zlib/include build/temp.macosx-10.14-x86_64-3.7/psycopg/psycopgmodule.o build/temp.macosx-10.14-x86_64-3.7/psycopg/green.o build/temp.macosx-10.14-x86_64-3.7/psycopg/pqpath.o build/temp.macosx-10.14-x86_64-3.7/psycopg/utils.o build/temp.macosx-10.14-x86_64-3.7/psycopg/bytes_format.o build/temp.macosx-10.14-x86_64-3.7/psycopg/libpq_support.o build/temp.macosx-10.14-x86_64-3.7/psycopg/win32_support.o build/temp.macosx-10.14-x86_64-3.7/psycopg/solaris_support.o build/temp.macosx-10.14-x86_64-3.7/psycopg/connection_int.o build/temp.macosx-10.14-x86_64-3.7/psycopg/connection_type.o build/temp.macosx-10.14-x86_64-3.7/psycopg/cursor_int.o build/temp.macosx-10.14-x86_64-3.7/psycopg/cursor_type.o build/temp.macosx-10.14-x86_64-3.7/psycopg/replication_connection_type.o build/temp.macosx-10.14-x86_64-3.7/psycopg/replication_cursor_type.o build/temp.macosx-10.14-x86_64-3.7/psycopg/replication_message_type.o build/temp.macosx-10.14-x86_64-3.7/psycopg/diagnostics_type.o build/temp.macosx-10.14-x86_64-3.7/psycopg/error_type.o build/temp.macosx-10.14-x86_64-3.7/psycopg/lobject_int.o build/temp.macosx-10.14-x86_64-3.7/psycopg/lobject_type.o build/temp.macosx-10.14-x86_64-3.7/psycopg/notify_type.o build/temp.macosx-10.14-x86_64-3.7/psycopg/xid_type.o build/temp.macosx-10.14-x86_64-3.7/psycopg/adapter_asis.o build/temp.macosx-10.14-x86_64-3.7/psycopg/adapter_binary.o build/temp.macosx-10.14-x86_64-3.7/psycopg/adapter_datetime.o build/temp.macosx-10.14-x86_64-3.7/psycopg/adapter_list.o build/temp.macosx-10.14-x86_64-3.7/psycopg/adapter_pboolean.o build/temp.macosx-10.14-x86_64-3.7/psycopg/adapter_pdecimal.o build/temp.macosx-10.14-x86_64-3.7/psycopg/adapter_pint.o build/temp.macosx-10.14-x86_64-3.7/psycopg/adapter_pfloat.o build/temp.macosx-10.14-x86_64-3.7/psycopg/adapter_qstring.o build/temp.macosx-10.14-x86_64-3.7/psycopg/microprotocols.o build/temp.macosx-10.14-x86_64-3.7/psycopg/microprotocols_proto.o build/temp.macosx-10.14-x86_64-3.7/psycopg/typecast.o -L/usr/local/lib -lpq -lssl -lcrypto -o build/lib.macosx-10.14-x86_64-3.7/psycopg2/_psycopg.cpython-37m-darwin.so
    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
    ----------------------------------------
  Rolling back uninstall of psycopg2
  Moving to /Users/hadi/.virtualenvs/myvenv/lib/python3.7/site-packages/psycopg2-2.8.2-py3.7.egg-info
   from /Users/hadi/.virtualenvs/myvenv/lib/python3.7/site-packages/~sycopg2-2.8.2-py3.7.egg-info
  Moving to /Users/hadi/.virtualenvs/myvenv/lib/python3.7/site-packages/psycopg2/
   from /Users/hadi/.virtualenvs/myvenv/lib/python3.7/site-packages/~sycopg2
ERROR: Command "/Users/hadi/.virtualenvs/myvenv/bin/python3 -u -c 'import setuptools, tokenize;__file__='"'"'/private/var/folders/0w/87fdgwgx0w7b7c3zj2y_01sh0000gn/T/pip-install-lt4288vh/psycopg2/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record /private/var/folders/0w/87fdgwgx0w7b7c3zj2y_01sh0000gn/T/pip-record-ips11cam/install-record.txt --single-version-externally-managed --compile --install-headers /Users/hadi/.virtualenvs/myvenv/include/site/python3.7/psycopg2" failed with error code 1 in /private/var/folders/0w/87fdgwgx0w7b7c3zj2y_01sh0000gn/T/pip-install-lt4288vh/psycopg2/
mhomidi picture mhomidi on 4 May 2019

psycopg2==2.7.3.2

This worked to me.
Thanks.

DiogoMajela picture DiogoMajela on 7 Sep 2019
Was this page helpful?
0 / 5 - 0 ratings

Related issues

anarazel picture anarazel  路  3Comments
dvlhntr picture dvlhntr  路  6Comments
rofi93 picture rofi93  路  4Comments
jasonrubenstein picture jasonrubenstein  路  5Comments
thedrow picture thedrow  路  4Comments