Installation Error Windows 10 (pip install pgcli)

[umitseric]

Description

I installed the following: cmder python 3.8.5 pip 20.2.1 psycopg2 (2.8.5)

The following error occurs when I run pip install pgcli

pip install pgcli
Collecting pgcli
  Using cached pgcli-3.0.0-py3-none-any.whl (70 kB)
Requirement already satisfied: psycopg2>=2.8 in c:\users\eric\appdata\local\packages\pythonsoftwarefoundation.python.3.8_qbz5n2kfra8p0\localcache\local-packages\python38\site-packages (from pgcli) (2.8.5)
Requirement already satisfied: prompt-toolkit<4.0.0,>=3.0.0 in c:\users\eric\appdata\local\packages\pythonsoftwarefoundation.python.3.8_qbz5n2kfra8p0\localcache\local-packages\python38\site-packages (from pgcli) (3.0.5)
Requirement already satisfied: Pygments>=2.0 in c:\users\eric\appdata\local\packages\pythonsoftwarefoundation.python.3.8_qbz5n2kfra8p0\localcache\local-packages\python38\site-packages (from pgcli) (2.6.1)
Collecting setproctitle>=1.1.9
  Using cached setproctitle-1.1.10.tar.gz (24 kB)
Requirement already satisfied: sqlparse<0.4,>=0.3.0 in c:\users\eric\appdata\local\packages\pythonsoftwarefoundation.python.3.8_qbz5n2kfra8p0\localcache\local-packages\python38\site-packages (from pgcli) (0.3.1)
Requirement already satisfied: configobj>=5.0.6 in c:\users\eric\appdata\local\packages\pythonsoftwarefoundation.python.3.8_qbz5n2kfra8p0\localcache\local-packages\python38\site-packages (from pgcli) (5.0.6)
Requirement already satisfied: cli-helpers[styles]>=1.2.0 in c:\users\eric\appdata\local\packages\pythonsoftwarefoundation.python.3.8_qbz5n2kfra8p0\localcache\local-packages\python38\site-packages (from pgcli) (2.1.0)
Requirement already satisfied: pgspecial>=1.11.8 in c:\users\eric\appdata\local\packages\pythonsoftwarefoundation.python.3.8_qbz5n2kfra8p0\localcache\local-packages\python38\site-packages (from pgcli) (1.11.10)
Requirement already satisfied: humanize>=0.5.1 in c:\users\eric\appdata\local\packages\pythonsoftwarefoundation.python.3.8_qbz5n2kfra8p0\localcache\local-packages\python38\site-packages (from pgcli) (2.5.0)
Requirement already satisfied: click>=4.1 in c:\users\eric\appdata\local\packages\pythonsoftwarefoundation.python.3.8_qbz5n2kfra8p0\localcache\local-packages\python38\site-packages (from pgcli) (7.1.2)
Requirement already satisfied: wcwidth in c:\users\eric\appdata\local\packages\pythonsoftwarefoundation.python.3.8_qbz5n2kfra8p0\localcache\local-packages\python38\site-packages (from prompt-toolkit<4.0.0,>=3.0.0->pgcli) (0.2.5)
Requirement already satisfied: six in c:\users\eric\appdata\local\packages\pythonsoftwarefoundation.python.3.8_qbz5n2kfra8p0\localcache\local-packages\python38\site-packages (from configobj>=5.0.6->pgcli) (1.15.0)
Requirement already satisfied: tabulate[widechars]>=0.8.2 in c:\users\eric\appdata\local\packages\pythonsoftwarefoundation.python.3.8_qbz5n2kfra8p0\localcache\local-packages\python38\site-packages (from cli-helpers[styles]>=1.2.0->pgcli) (0.8.7)
Requirement already satisfied: terminaltables>=3.0.0 in c:\users\eric\appdata\local\packages\pythonsoftwarefoundation.python.3.8_qbz5n2kfra8p0\localcache\local-packages\python38\site-packages (from cli-helpers[styles]>=1.2.0->pgcli) (3.1.0)
Building wheels for collected packages: setproctitle
  Building wheel for setproctitle (setup.py) ... error
  ERROR: Command errored out with exit status 1:
   command: 'C:\Users\Eric\AppData\Local\Microsoft\WindowsApps\PythonSoftwareFoundation.Python.3.8_qbz5n2kfra8p0\python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'C:\\Users\\Eric\\AppData\\Local\\Temp\\pip-install-6atjyko3\\setproctitle\\setup.py'"'"'; __file__='"'"'C:\\Users\\Eric\\AppData\\Local\\Temp\\pip-install-6atjyko3\\setproctitle\\setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' bdist_wheel -d 'C:\Users\Eric\AppData\Local\Temp\pip-wheel-a210_mqr'
       cwd: C:\Users\Eric\AppData\Local\Temp\pip-install-6atjyko3\setproctitle\
  Complete output (5 lines):
  running bdist_wheel
  running build
  running build_ext
  building 'setproctitle' extension
  error: Microsoft Visual C++ 14.0 is required. Get it with "Build Tools for Visual Studio": https://visualstudio.microsoft.com/downloads/
  ----------------------------------------
  ERROR: Failed building wheel for setproctitle
  Running setup.py clean for setproctitle
Failed to build setproctitle
DEPRECATION: Could not build wheels for setproctitle which do not use PEP 517. pip will fall back to legacy 'setup.py install' for these. pip 21.0 will remove support for this functionality. A possible replacement is to fix the wheel build issue reported above. You can find discussion regarding this at https://github.com/pypa/pip/issues/8368.
Installing collected packages: setproctitle, pgcli
    Running setup.py install for setproctitle ... error
    ERROR: Command errored out with exit status 1:
     command: 'C:\Users\Eric\AppData\Local\Microsoft\WindowsApps\PythonSoftwareFoundation.Python.3.8_qbz5n2kfra8p0\python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'C:\\Users\\Eric\\AppData\\Local\\Temp\\pip-install-6atjyko3\\setproctitle\\setup.py'"'"'; __file__='"'"'C:\\Users\\Eric\\AppData\\Local\\Temp\\pip-install-6atjyko3\\setproctitle\\setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record 'C:\Users\Eric\AppData\Local\Temp\pip-record-u5k85dwd\install-record.txt' --single-version-externally-managed --user --prefix= --compile --install-headers 'C:\Users\Eric\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.8_qbz5n2kfra8p0\LocalCache\local-packages\Python38\Include\setproctitle'
         cwd: C:\Users\Eric\AppData\Local\Temp\pip-install-6atjyko3\setproctitle\
    Complete output (5 lines):
    running install
    running build
    running build_ext
    building 'setproctitle' extension
    error: Microsoft Visual C++ 14.0 is required. Get it with "Build Tools for Visual Studio": https://visualstudio.microsoft.com/downloads/
    ----------------------------------------
ERROR: Command errored out with exit status 1: 'C:\Users\Eric\AppData\Local\Microsoft\WindowsApps\PythonSoftwareFoundation.Python.3.8_qbz5n2kfra8p0\python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'C:\\Users\\Eric\\AppData\\Local\\Temp\\pip-install-6atjyko3\\setproctitle\\setup.py'"'"'; __file__='"'"'C:\\Users\\Eric\\AppData\\Local\\Temp\\pip-install-6atjyko3\\setproctitle\\setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record 'C:\Users\Eric\AppData\Local\Temp\pip-record-u5k85dwd\install-record.txt' --single-version-externally-managed --user --prefix= --compile --install-headers 'C:\Users\Eric\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.8_qbz5n2kfra8p0\LocalCache\local-packages\Python38\Include\setproctitle' Check the logs for full command output.

Your environment

• Windows 10
• pip freeze: cli-helpers==2.1.0 click==7.1.2 configobj==5.0.6 humanize==2.5.0 pgspecial==1.11.10 prompt-toolkit==3.0.5 psycopg2==2.8.5 Pygments==2.6.1 six==1.15.0 sqlparse==0.3.1 tabulate==0.8.7 terminaltables==3.1.0 wcwidth==0.2.5

[anyfactor]

Same error here. The simple solution is to install the C++ Build Tool but it is literally 6 GB. So instead of that I have tried updating setuptools, pipwin, installing binary etc. Nothing works. I think the 6gb bloat is the only way IF you want to use pgCLI in the Windows environment.

Or you can use the WSL where pgCLI installs without any problem.

[dbaty]

I don't think that installing build tools is necessary anymore. When this issue was reported (in February 2022), the version of setproctitle was 1.1.10 and PyPI did not have wheels for it (see here). But the latest version (1.3.3) does have wheels (see here), which should make the installation much simpler (especially on Windows).

If you are still having this issue, I suggest to pip install --upgrade setproctitle pgcli (or just pip install pgcli in a brand new virtual environment, which should automatically fetch the latest version of setproctitle that has wheels).

Since this issue has been opened for more than 18 months, I am closing it. Feel free to reopen if you still have the issue and the suggestion above does not work.