Psycopg2 install error on windows (pip or wheel) (UnicodeDecodeError)

Question

I am currently trying to make use of pypy to try and see with a profiler if I will get better results than now, currently using only python 3.8

I have installed pypy 3.9 for windows 10 (64 bits) and been upgrading pip, setuptools, as well as wheels before installing anything, most of packages have been working fine (websockets, google-auth, ...) but when installing aiopg (built on psycopg2) I get this error:

pip install psycopg2
Collecting psycopg2
  Using cached psycopg2-2.9.3.tar.gz (380 kB)
  Preparing metadata (setup.py) ... error
  error: subprocess-exited-with-error

  × python setup.py egg_info did not run successfully.
  Ôöé exit code: 1
  Ôò░ÔöÇ> [46 lines of output]
      running egg_info
      creating C:\Users\charl\AppData\Local\Temp\pip-pip-egg-info-slfqnpdw\psycopg2.egg-info
      writing C:\Users\charl\AppData\Local\Temp\pip-pip-egg-info-slfqnpdw\psycopg2.egg-info\PKG-INFO
      writing dependency_links to C:\Users\charl\AppData\Local\Temp\pip-pip-egg-info-slfqnpdw\psycopg2.egg-info\dependency_links.txt
      writing top-level names to C:\Users\charl\AppData\Local\Temp\pip-pip-egg-info-slfqnpdw\psycopg2.egg-info\top_level.txt
      writing manifest file 'C:\Users\charl\AppData\Local\Temp\pip-pip-egg-info-slfqnpdw\psycopg2.egg-info\SOURCES.txt'
      c:\pypy3.8-v7.3.8-win64\lib\site-packages\setuptools\config\setupcfg.py:459: SetuptoolsDeprecationWarning: The license_file parameter is deprecated, use license_files instead.
        warnings.warn(msg, warning_class)
      Traceback (most recent call last):
        File "<string>", line 36, in <module>
        File "<pip-setuptools-caller>", line 34, in <module>
        File "C:\Users\charl\AppData\Local\Temp\pip-install-_oajyk5x\psycopg2_8ddd8ed44adb43868bba1fd17520cb9c\setup.py", line 572, in <module>
          'Download': 'https://pypi.org/project/psycopg2/',
        File "c:\pypy3.8-v7.3.8-win64\lib\site-packages\setuptools\__init__.py", line 87, in setup
          return distutils.core.setup(**attrs)
        File "c:\pypy3.8-v7.3.8-win64\lib\site-packages\setuptools\_distutils\core.py", line 177, in setup
          return run_commands(dist)
        File "c:\pypy3.8-v7.3.8-win64\lib\site-packages\setuptools\_distutils\core.py", line 193, in run_commands
          dist.run_commands()
        File "c:\pypy3.8-v7.3.8-win64\lib\site-packages\setuptools\_distutils\dist.py", line 968, in run_commands
          self.run_command(cmd)
        File "c:\pypy3.8-v7.3.8-win64\lib\site-packages\setuptools\dist.py", line 1229, in run_command
          super().run_command(command)
        File "c:\pypy3.8-v7.3.8-win64\lib\site-packages\setuptools\_distutils\dist.py", line 987, in run_command
          cmd_obj.run()
        File "c:\pypy3.8-v7.3.8-win64\lib\site-packages\setuptools\command\egg_info.py", line 308, in run
          self.find_sources()
        File "c:\pypy3.8-v7.3.8-win64\lib\site-packages\setuptools\command\egg_info.py", line 315, in find_sources
          mm.run()
        File "c:\pypy3.8-v7.3.8-win64\lib\site-packages\setuptools\command\egg_info.py", line 550, in run
          self.add_defaults()
        File "c:\pypy3.8-v7.3.8-win64\lib\site-packages\setuptools\command\egg_info.py", line 587, in add_defaults
          sdist.add_defaults(self)
        File "c:\pypy3.8-v7.3.8-win64\lib\site-packages\setuptools\_distutils\command\sdist.py", line 252, in add_defaults
          self._add_defaults_ext()
        File "c:\pypy3.8-v7.3.8-win64\lib\site-packages\setuptools\_distutils\command\sdist.py", line 336, in _add_defaults_ext
          build_ext = self.get_finalized_command('build_ext')
        File "c:\pypy3.8-v7.3.8-win64\lib\site-packages\setuptools\_distutils\cmd.py", line 304, in get_finalized_command
          cmd_obj.ensure_finalized()
        File "c:\pypy3.8-v7.3.8-win64\lib\site-packages\setuptools\_distutils\cmd.py", line 107, in ensure_finalized
          self.finalize_options()
        File "C:\Users\charl\AppData\Local\Temp\pip-install-_oajyk5x\psycopg2_8ddd8ed44adb43868bba1fd17520cb9c\setup.py", line 381, in finalize_options
          for token in pg_config_helper.query("ldflags").split():
        File "C:\Users\charl\AppData\Local\Temp\pip-install-_oajyk5x\psycopg2_8ddd8ed44adb43868bba1fd17520cb9c\setup.py", line 124, in query
          result = result.decode('ascii')
      UnicodeDecodeError: 'ascii' codec can't decode byte 0xe9 in position 13: 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.

I have been trying the following:

• Pypy 3.8 with python 3.8 : same error despite clearing pip cache
• "pip install psycopg2-binary" : same error
• downgrading psycopg2 version : same error until the version is too low : another error due to the fact that the package doesnt exist for my python version
• downloading the whl and installing "manually" : not working for different reason : "psycopg2-2.9.3-cp38-cp38-win_amd64.whl is not a supported wheel on this platform." despite using python x64 3.8 :

pip -V
pip 22.1.2 from c:\pypy3.8-v7.3.8-win64\lib\site-packages\pip (python 3.8)

I've tried using asyncpg since it seems like a really fast postgresql library and my server is mostly made of sql requests and I got :

asyncpg/protocol/record/recordobj.c(549): warning C4013: '_PyUnicodeWriter_Dealloc' non d\x82fini(e)\xff; extern retournant int pris par d\x82faut
     asyncpg/protocol/record/recordobj.c(549): error C2065: 'writer'\xff: identificateur non d\x82clar\x82
     C:\Users\charl\AppData\Local\Temp\pip-build-env-goboqejq\overlay\Lib\site-packages\setuptools\config\pyprojecttoml.py:123: _InvalidFile: The given `pyproject.toml` file is invalid and would be ignored.
         !!


         ############################
         # Invalid `pyproject.toml` #
         ############################

         Any configurations in `pyproject.toml` will be ignored.
         Please note that future releases of setuptools will halt the build process
         if an invalid file is given.

         To prevent setuptools from considering `pyproject.toml` please
         DO NOT include the `[project]` or `[tool.setuptools]` tables in your file.


     !!

       if _skip_bad_config(project_table, orig_setuptools_table, dist):
     error: command 'C:\\Program Files (x86)\\Microsoft Visual Studio\\2019\\Community\\VC\\Tools\\MSVC\\14.29.30133\\bin\\HostX86\\x64\\cl.exe' failed with exit code 2
     [end of output]

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

psycopg on the other hand worked, but I don't want to use it.

Any fellow windows friend having similar problems?