Bonjour,

Je suis en train de suivre le tuto de Serge Tahé et j'en suis arrivé au chapitre de l'utilisation de PostGres.
Mais j'ai une erreur sur l'installation de psycopg2 et je ne parviens pas à m'en sortir.

Dans PyCharm, la ligne de de commande "pip install psycopg2" provoque l'affichage de message d'erreur
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
Collecting psycopg2
  Using cached psycopg2-2.9.1.tar.gz (379 kB)
  Preparing metadata (setup.py) ... error
  ERROR: Command errored out with exit status 1:
   command: 'c:\users\popo\onedrive - popo\documents\python\projects\cours-2020\python3-flask-2020\venv\scripts\python.exe' -c 'import io, os, sys, setuptools, tokenize; sys.argv[0] = '"'"'C:\\Users\\popo\\AppData\\Local\\Te
mp\\pip-install-4jlt0rz8\\psycopg2_a07d494c818541c38318dbe6df216228\\setup.py'"'"'; __file__='"'"'C:\\Users\\popo\\AppData\\Local\\Temp\\pip-install-4jlt0rz8\\psycopg2_a07d494c818541c38318dbe6df216228\\setup.py'"'"';f = getattr(to
kenize, '"'"'open'"'"', open)(__file__) if os.path.exists(__file__) else io.StringIO('"'"'from setuptools import setup; setup()'"'"');code = f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exe
c'"'"'))' egg_info --egg-base 'C:\Users\popo\AppData\Local\Temp\pip-pip-egg-info-n3f2kc5m'
       cwd: C:\Users\popo\AppData\Local\Temp\pip-install-4jlt0rz8\psycopg2_a07d494c818541c38318dbe6df216228\
  Complete output (39 lines):
  running egg_info
  creating C:\Users\popo\AppData\Local\Temp\pip-pip-egg-info-n3f2kc5m\psycopg2.egg-info
  writing C:\Users\popo\AppData\Local\Temp\pip-pip-egg-info-n3f2kc5m\psycopg2.egg-info\PKG-INFO
  writing dependency_links to C:\Users\popo\AppData\Local\Temp\pip-pip-egg-info-n3f2kc5m\psycopg2.egg-info\dependency_links.txt
  writing top-level names to C:\Users\popo\AppData\Local\Temp\pip-pip-egg-info-n3f2kc5m\psycopg2.egg-info\top_level.txt
  writing manifest file 'C:\Users\popo\AppData\Local\Temp\pip-pip-egg-info-n3f2kc5m\psycopg2.egg-info\SOURCES.txt'
  Traceback (most recent call last):
    File "<string>", line 1, in <module>
    File "C:\Users\popo\AppData\Local\Temp\pip-install-4jlt0rz8\psycopg2_a07d494c818541c38318dbe6df216228\setup.py", line 548, in <module>
      setup(name="psycopg2",
    File "c:\users\popo\onedrive - popo\documents\python\projects\cours-2020\python3-flask-2020\venv\lib\site-packages\setuptools\__init__.py", line 153, in setup
      return distutils.core.setup(**attrs)
    File "C:\Users\popo\AppData\Local\Programs\Python\Python310\lib\distutils\core.py", line 148, in setup
      dist.run_commands()
    File "C:\Users\popo\AppData\Local\Programs\Python\Python310\lib\distutils\dist.py", line 966, in run_commands
      self.run_command(cmd)
    File "C:\Users\popo\AppData\Local\Programs\Python\Python310\lib\distutils\dist.py", line 985, in run_command
      cmd_obj.run()
    File "c:\users\popo\onedrive - popo\documents\python\projects\cours-2020\python3-flask-2020\venv\lib\site-packages\setuptools\command\egg_info.py", line 299, in run
      self.find_sources()
    File "c:\users\popo\onedrive - popo\documents\python\projects\cours-2020\python3-flask-2020\venv\lib\site-packages\setuptools\command\egg_info.py", line 306, in find_sources
      mm.run()
    File "c:\users\popo\onedrive - popo\documents\python\projects\cours-2020\python3-flask-2020\venv\lib\site-packages\setuptools\command\egg_info.py", line 541, in run
      self.add_defaults()
    File "c:\users\popo\onedrive - popo\documents\python\projects\cours-2020\python3-flask-2020\venv\lib\site-packages\setuptools\command\egg_info.py", line 578, in add_defaults
      sdist.add_defaults(self)
    File "C:\Users\popo\AppData\Local\Programs\Python\Python310\lib\distutils\command\sdist.py", line 228, in add_defaults
      self._add_defaults_ext()
    File "C:\Users\popo\AppData\Local\Programs\Python\Python310\lib\distutils\command\sdist.py", line 311, in _add_defaults_ext
      build_ext = self.get_finalized_command('build_ext')
    File "C:\Users\popo\AppData\Local\Programs\Python\Python310\lib\distutils\cmd.py", line 299, in get_finalized_command
      cmd_obj.ensure_finalized()
    File "C:\Users\popo\AppData\Local\Programs\Python\Python310\lib\distutils\cmd.py", line 107, in ensure_finalized
      self.finalize_options()
    File "C:\Users\popo\AppData\Local\Temp\pip-install-4jlt0rz8\psycopg2_a07d494c818541c38318dbe6df216228\setup.py", line 380, in finalize_options
      for token in pg_config_helper.query("ldflags").split():
    File "C:\Users\popo\AppData\Local\Temp\pip-install-4jlt0rz8\psycopg2_a07d494c818541c38318dbe6df216228\setup.py", line 123, in query
      result = result.decode('ascii')
  UnicodeDecodeError: 'ascii' codec can't decode byte 0xe9 in position 13: ordinal not in range(128)
Alors que si je tape la même ligne directement dans l'invite de commande windows ça fonctionne.
C:\Users\popo>pip install psycopg2
Collecting psycopg2
Downloading psycopg2-2.9.1-cp39-cp39-win_amd64.whl (1.2 MB)
|████████████████████████████████| 1.2 MB 3.3 MB/s
Installing collected packages: psycopg2
Successfully installed psycopg2-2.9.1


Mais le package n'apparait pas dans PyCharm.
Que dois-je faire ?

Merci.