Daniele (namesake), Thanks for the quick response. I tried that, it looks like https://github.com/psycopg/psycopg2/blob/master/scripts/build/appveyor.py#L291 shows the build step:
python setup.py build_ext -l "libpgcommon libpgport" After that, I still get a binary that depends on libpq.dll - but when I install psycopg2-binary, the DLL installed (the PYD file) does not depend on libpq.dll - it is statically built. On Mon, Oct 4, 2021 at 6:41 PM Daniele Varrazzo <daniele.varra...@gmail.com> wrote: > On Tue, 5 Oct 2021 at 00:30, Dan Davis <dansm...@gmail.com> wrote: > > > > Can anyone give me a solution to build psycopg2 statically on Windows? > > You can follow what Appveyor does, which is the CI that builds > psycopg2 packages. > > - this is the setup > https://github.com/psycopg/psycopg2/blob/master/.appveyor/packages.yml > - this is the script it calls into: > https://github.com/psycopg/psycopg2/blob/master/scripts/build/appveyor.py > > You can use the ML at psyc...@postgres.org for further questions. > > -- Daniele >
