Re: How to build psycopg2 for Windows

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(dot)varrazzo(at)gmail(dot)com>
wrote:

> On Tue, 5 Oct 2021 at 00:30, Dan Davis <dansmood(at)gmail(dot)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 psycopg(at)postgres(dot)org for further questions.
>
> -- Daniele
>