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.varrazzo@xxxxxxxxx> wrote:
On Tue, 5 Oct 2021 at 00:30, Dan Davis <dansmood@xxxxxxxxx> 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 psycopg@xxxxxxxxxxxx for further questions.
-- Daniele
