Postgres Pro
Downloads
Home   >   mailing lists

Re: How to build psycopg2 for Windows - Mailing list pgsql-general

From Dan Davis
Subject Re: How to build psycopg2 for Windows
Date
Msg-id CAFzonYYbuVyx_Qd2m=qcbdSOFe6febnTVeuEw_Jd-e9bO3v-AA@mail.gmail.com
Whole thread Raw
In response to Re: How to build psycopg2 for Windows  (Daniele Varrazzo <daniele.varrazzo@gmail.com>)
List pgsql-general
Tree view
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@gmail.com> wrote:
On Tue, 5 Oct 2021 at 00:30, Dan Davis <dansmood@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 psycopg@postgres.org for further questions.

-- Daniele

pgsql-general by date:

Previous
From: Daniele Varrazzo
Date:
Subject: Re: How to build psycopg2 for Windows
Next
From: Ryan Booz
Date:
Subject: Re: Growth planning