ImportError: DLL load failed while importing _psycopg: The specified module could not be found.

[visch]

Describe the bug
ImportError: DLL load failed while importing _psycopg: The specified module could not be found.

To Reproduce
Steps to reproduce the behavior:

1. On windows install the target with pip
2. Run the target, you'll get this error

To fix this:

1. On the same venv as target-postgres install both psycopg2-binary psycopg2 (Not certain both are needed), everything works.

Python version 3.9.9

[visch]

The other way I ran it was without psycopg2-binary and only psycop2 because of this little bit I found in the documentation for psycop2.
The psycopg2-binary package is meant for beginners to start playing with Python and PostgreSQL without the need to meet the build requirements.
If you are the maintainer of a published package depending on psycopg2 you shouldn't use psycopg2-binary as a module dependency. For production use you are advised to use the source distribution.
https://www.psycopg.org/docs/install.html#psycopg-vs-psycopg-binary

From Dan Norman on Meltano slack