Задать вопрос
@Lionua

Как устранить ошибки при установке psycopg2-binary на Windows?

При установке библиотеки psycopg2-binary на Windows Server возникает следующая ошибка:

PS C:\Users\Administrator> pip install psycopg2-binary
Collecting psycopg2-binary
Using cached psycopg2-binary-2.9.5.tar.gz (384 kB)
Preparing metadata (setup.py) ... error
error: subprocess-exited-with-error

× python setup.py egg_info did not run successfully.
│ exit code: 1
╰─> [53 lines of output]
C:\Program Files\Python311\Lib\site-packages\setuptools\config\setupcfg.py:508: SetuptoolsDeprecationWarning: The
license_file parameter is deprecated, use license_files instead.
warnings.warn(msg, warning_class)
running egg_info
creating C:\Users\Administrator\AppData\Local\Temp\2\pip-pip-egg-info-nncb05me\psycopg2_binary.egg-info
writing C:\Users\Administrator\AppData\Local\Temp\2\pip-pip-egg-info-nncb05me\psycopg2_binary.egg-info\PKG-INFO
writing dependency_links to C:\Users\Administrator\AppData\Local\Temp\2\pip-pip-egg-info-nncb05me\psycopg2_binary.
egg-info\dependency_links.txt
writing top-level names to C:\Users\Administrator\AppData\Local\Temp\2\pip-pip-egg-info-nncb05me\psycopg2_binary.e
gg-info\top_level.txt
writing manifest file 'C:\Users\Administrator\AppData\Local\Temp\2\pip-pip-egg-info-nncb05me\psycopg2_binary.egg-i
nfo\SOURCES.txt'
Traceback (most recent call last):
File "", line 2, in
File "", line 34, in
File "C:\Users\Administrator\AppData\Local\Temp\2\pip-install-uqul28l8\psycopg2-binary_607e67f7b17746ffa6fc3b5a0
adee5bd\setup.py", line 550, in
setup(name="psycopg2-binary",
File "C:\Program Files\Python311\Lib\site-packages\setuptools\__init__.py", line 87, in setup
return distutils.core.setup(**attrs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Program Files\Python311\Lib\site-packages\setuptools\_distutils\core.py", line 185, in setup
return run_commands(dist)
^^^^^^^^^^^^^^^^^^
File "C:\Program Files\Python311\Lib\site-packages\setuptools\_distutils\core.py", line 201, in run_commands
dist.run_commands()
File "C:\Program Files\Python311\Lib\site-packages\setuptools\_distutils\dist.py", line 968, in run_commands
self.run_command(cmd)
File "C:\Program Files\Python311\Lib\site-packages\setuptools\dist.py", line 1217, in run_command
super().run_command(command)
File "C:\Program Files\Python311\Lib\site-packages\setuptools\_distutils\dist.py", line 987, in run_command
cmd_obj.run()
File "C:\Program Files\Python311\Lib\site-packages\setuptools\command\egg_info.py", line 308, in run
self.find_sources()
File "C:\Program Files\Python311\Lib\site-packages\setuptools\command\egg_info.py", line 316, in find_sources
mm.run()
File "C:\Program Files\Python311\Lib\site-packages\setuptools\command\egg_info.py", line 560, in run
self.add_defaults()
File "C:\Program Files\Python311\Lib\site-packages\setuptools\command\egg_info.py", line 597, in add_defaults
sdist.add_defaults(self)
File "C:\Program Files\Python311\Lib\site-packages\setuptools\command\sdist.py", line 106, in add_defaults
super().add_defaults()
File "C:\Program Files\Python311\Lib\site-packages\setuptools\_distutils\command\sdist.py", line 252, in add_def
aults
self._add_defaults_ext()
File "C:\Program Files\Python311\Lib\site-packages\setuptools\_distutils\command\sdist.py", line 336, in _add_de
faults_ext
build_ext = self.get_finalized_command('build_ext')
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Program Files\Python311\Lib\site-packages\setuptools\_distutils\cmd.py", line 306, in get_finalized_com
mand
cmd_obj.ensure_finalized()
File "C:\Program Files\Python311\Lib\site-packages\setuptools\_distutils\cmd.py", line 109, in ensure_finalized
self.finalize_options()
File "C:\Users\Administrator\AppData\Local\Temp\2\pip-install-uqul28l8\psycopg2-binary_607e67f7b17746ffa6fc3b5a0
adee5bd\setup.py", line 382, in finalize_options
for token in pg_config_helper.query("ldflags").split():
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Administrator\AppData\Local\Temp\2\pip-install-uqul28l8\psycopg2-binary_607e67f7b17746ffa6fc3b5a0
adee5bd\setup.py", line 125, in query
result = result.decode('ascii')
^^^^^^^^^^^^^^^^^^^^^^
UnicodeDecodeError: 'ascii' codec can't decode byte 0xed in position 0: ordinal not in range(128)
[end of output]

note: This error originates from a subprocess, and is likely not a problem with pip.
error: metadata-generation-failed

× Encountered error while generating package metadata.
╰─> See above for output.

note: This is an issue with the package mentioned above, not pip.
hint: See above for details.

В чём может быть проблема? PostgreSQL и Visual Studio установлены.
  • Вопрос задан
  • 1389 просмотров
Подписаться 1 Простой Комментировать
Пригласить эксперта
Ответы на вопрос 1
@altardoc
тоже намаялся с этим, но оказывается что для psycopg2 для винды необходимо использовать Python не выше версии 3.10
нашел тут
Ответ написан
Комментировать
Ваш ответ на вопрос

Войдите, чтобы написать ответ

Похожие вопросы
Greenway Global Новосибирск
от 150 000 ₽
SPA2099 Москва
До 100 000 ₽
HR Prime Москва
от 300 000 до 3 800 000 ₽