无法在Windows上安装psycopg2 2.8.6

Question

我无法在Windows上安装psycopg2.8.6或psycopg2二进制文件。 安装时，我得到下面的错误

PS C:\Users\UserName\Desktop\pythonunitestfw>；pip安装psycopg2二进制文件 收集psycopg2二进制文件 使用缓存的psycopg2-binary-2.8.6.tar.gz（384KB） 错误：命令出错，退出状态为1: 命令：“c:\python39\python.exe'-c”import sys，setuptools，tokenize；sys.argv[0]=“C:\Users\UserName\AppData\Local\Temp\pip-install-e12d1gsx\psycopg2 binary\setup.py”“”文件='''''''''''C:\Users\UserName\AppData\Local\Temp\pip-install-e12d1gsx\psycopg2 binary\setup.py''''；f=getattr（标记化，“‘打开’”，打开）（文件）；code=f.read（）.replace（“\r\n”“”、“\n”“”）；f、 close（）；exec（编译（代码，文件，，“'exec'”）“鸡蛋信息——鸡蛋库”C:\Users\UserName\AppData\Local\Temp\pip-pip-egg-info-bs6x9b8l” cwd:C:\Users\UserName\AppData\Local\Temp\pip-install-e12d1gsx\psycopg2 binary
完整输出（23行）： 运行蛋_信息 正在创建C:\Users\UserName\AppData\Local\Temp\pip-pip-egg-info-bs6x9b8l\psycopg2\u binary.egg-info 正在写入C:\Users\UserName\AppData\Local\Temp\pip-pip-egg-info-bs6x9b8l\psycopg2\u binary.egg-info\PKG-info 正在将依赖项链接写入C:\Users\UserName\AppData\Local\Temp\pip-pip-egg-info-bs6x9b8l\psycopg2\u binary.egg info\dependency\u links.txt
将顶级名称写入C:\Users\UserName\AppData\Local\Temp\pip-pip-egg-info-bs6x9b8l\psycopg2\u binary.egg info\top\u level.txt 正在写入清单文件“C:\Users\UserName\AppData\Local\Temp\pip-pip-egg-info-bs6x9b8l\psycopg2\u binary.egg info\SOURCES.txt”

Error: pg_config executable not found.

pg_config is required to build psycopg2 from source.  Please add the directory
containing pg_config to the $PATH or specify the full executable path with the
option:

    python setup.py build_ext --pg-config /path/to/pg_config build ...

or with the pg_config option in 'setup.cfg'.

If you prefer to avoid building psycopg2 from source, please install the PyPI
'psycopg2-binary' package instead.

For further information please check the 'doc/src/install.rst' file (also at
<https://www.psycopg.org/docs/install.html>).

----------------------------------------

错误：命令出错，退出状态为1:python setup.py egg_info检查日志以获得完整的命令输出