MIME-Version: 1.0
From: Dan Davis <dansmood@gmail.com>
Date: Mon, 4 Oct 2021 19:01:04 -0400
Message-ID: 
 <CAFzonYY=gW5cG9oJNGkF-6vzYvNvg9BB1CCfVkeqYGCKzH=9PQ@mail.gmail.com>
Subject: How to build statically on Windows
To: psycopg@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000dc8c1505cd8ee301"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFzonYY%3DgW5cG9oJNGkF-6vzYvNvg9BB1CCfVkeqYGCKzH%3D9PQ%40mail.gmail.com>
Precedence: bulk

--000000000000dc8c1505cd8ee301
Content-Type: text/plain; charset="UTF-8"

Can anyone give me a solution to build psycopg2 statically on Windows?

I have succeeded in building it, but when I run dumpbin /dependents on the
generated file (the PYD file), it still depends on libpq.dll even when I
pass --static-libpq.

*Environment*

- OS: Windows 10
- Psycopg version: psycopg2-2.8.5
- Python version: 3.9
- PostgreSQL version: 14.0 (from ZIP)
- pip version: 21.2.4
- Visual C++ version: 2019

*Procedure*

- Make sure pg_config and psql are in the path
- Download as follows - pip download psycopg2==2.8.5 --no-binary :all:
- Expand the tarball
- Build in that directory as follows (following appveyor.py
<https://github.com/psycopg/psycopg2/blob/master/scripts/build/appveyor.py#L291>
)

      python setup.py build_ext -l "libpgcommon libpgport"

- Try to verify it is indeed static

      dumpbin /dependents
build\lib.win-amd64-3.9\psycopg2\_psycopg.cp39-win_amd64.pyd


*Background*
The purpose here is 2 fold:

* Backfill support for Python 3.9 and psycopg2 to versions that may have
come out before 3.9 was available.
* Make sure our psycopg2 is built against a more recent version of the
PostgreSQL client libraries than 9.x

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

<div dir=3D"ltr">Can anyone give me a solution to build psycopg2 statically=
 on Windows?<div><br></div><div>I have succeeded=C2=A0in building it, but w=
hen I run dumpbin /dependents on the generated file (the PYD file), it stil=
l depends on libpq.dll even when I pass --static-libpq.</div><div><br></div=
><div><b>Environment</b></div><div><br></div><div>- OS: Windows 10<br>- Psy=
copg version: psycopg2-2.8.5<br>- Python version: 3.9<br>- PostgreSQL versi=
on: 14.0 (from ZIP)<br>- pip version: 21.2.4<br>- Visual C++ version: 2019<=
/div><div><br></div><div><b>Procedure</b></div><div><br></div><div>- Make s=
ure pg_config and psql are in the path</div><div>- Download as follows - pi=
p download psycopg2=3D=3D2.8.5 --no-binary :all:</div><div>- Expand the tar=
ball</div><div>- Build in that directory as follows (following <a href=3D"h=
ttps://github.com/psycopg/psycopg2/blob/master/scripts/build/appveyor.py#L2=
91">appveyor.py</a>)</div><div><br></div><div>=C2=A0 =C2=A0 =C2=A0 python s=
etup.py build_ext -l &quot;libpgcommon libpgport&quot;</div><div><br></div>=
<div>- Try to verify it is indeed static</div><div><br></div><div>=C2=A0 =
=C2=A0 =C2=A0 dumpbin /dependents build\lib.win-amd64-3.9\psycopg2\_psycopg=
.cp39-win_amd64.pyd</div><div><br></div><div><br></div><div><b>Background</=
b></div><div>The purpose here is 2 fold:</div><div><br></div><div>* Backfil=
l support for Python 3.9 and psycopg2 to versions that may have come out be=
fore 3.9 was available.</div><div>* Make sure our psycopg2 is built against=
 a more recent version of the PostgreSQL client libraries than 9.x</div></d=
iv>

--000000000000dc8c1505cd8ee301--