{"action":"created","issue":{"url":"https://api.github.com/repos/amjith/pgcli/issues/108","labels_url":"https://api.github.com/repos/amjith/pgcli/issues/108/labels{/name}","comments_url":"https://api.github.com/repos/amjith/pgcli/issues/108/comments","events_url":"https://api.github.com/repos/amjith/pgcli/issues/108/events","html_url":"https://github.com/amjith/pgcli/issues/108","id":54030818,"number":108,"title":"how to use pgcli on win7","user":{"login":"jerome-peng","id":3261472,"avatar_url":"https://avatars.githubusercontent.com/u/3261472?v=3","gravatar_id":"","url":"https://api.github.com/users/jerome-peng","html_url":"https://github.com/jerome-peng","followers_url":"https://api.github.com/users/jerome-peng/followers","following_url":"https://api.github.com/users/jerome-peng/following{/other_user}","gists_url":"https://api.github.com/users/jerome-peng/gists{/gist_id}","starred_url":"https://api.github.com/users/jerome-peng/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jerome-peng/subscriptions","organizations_url":"https://api.github.com/users/jerome-peng/orgs","repos_url":"https://api.github.com/users/jerome-peng/repos","events_url":"https://api.github.com/users/jerome-peng/events{/privacy}","received_events_url":"https://api.github.com/users/jerome-peng/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-01-12T08:47:57Z","updated_at":"2015-01-14T06:46:03Z","closed_at":null,"body":"my pc is win7 32bit system, i want to use pgcli, then i get some errors.\r\n\r\nmy operation is bellow:\r\n\r\n1 download python3.4.2 from https://www.python.org/downloads/release/python-342/\r\n installed in D:\\Python‍\r\n\r\n2 install python-pip\r\n   download get-pip.py from ‍https://bootstrap.pypa.io/get-pip.py to D:\\‍\r\n   run command: python d:\\get-pip.py‍\r\n\r\n3  pip install pgcli ‍\r\nD:\\Python\\Scripts>pip install pgcli\r\nCollecting pgcli\r\n  Downloading pgcli-0.11.0.tar.gz\r\nCollecting click>=3.2 (from pgcli)\r\n  Downloading click-3.3-py2.py3-none-any.whl (58kB)\r\n    100% |################################| 61kB 71kB/s ta 0:00:011\r\nCollecting Pygments>=2.0 (from pgcli)\r\n  Downloading Pygments-2.0.1-py3-none-any.whl (672kB)\r\n    100% |################################| 675kB 347kB/s ta 0:00:01\r\nCollecting jedi==0.8.1 (from pgcli)\r\n  Downloading jedi-0.8.1.tar.gz (304kB)\r\n    100% |################################| 307kB 196kB/s ta 0:00:01\r\nCollecting prompt-toolkit==0.25 (from pgcli)\r\n  Downloading prompt_toolkit-0.25.tar.gz (93kB)\r\n    100% |################################| 94kB 255kB/s ta 0:00:01\r\nCollecting psycopg2>=2.5.4 (from pgcli)\r\n  Downloading psycopg2-2.5.4.tar.gz (682kB)\r\n    100% |################################| 684kB 251kB/s ta 0:00:01\r\nCollecting sqlparse>=0.1.14 (from pgcli)\r\n  Downloading sqlparse-0.1.14.tar.gz (55kB)\r\n    100% |################################| 57kB 203kB/s ta 0:00:011\r\nCollecting docopt (from prompt-toolkit==0.25->pgcli)\r\n  Downloading docopt-0.6.2.tar.gz\r\nCollecting six>=1.8.0 (from prompt-toolkit==0.25->pgcli)\r\n  Downloading six-1.9.0-py2.py3-none-any.whl\r\nCollecting wcwidth (from prompt-toolkit==0.25->pgcli)\r\n  Downloading wcwidth-0.1.4-py2.py3-none-any.whl\r\nInstalling collected packages: wcwidth, six, docopt, sqlparse, psycopg2, prompt-\r\ntoolkit, jedi, Pygments, click, pgcli\r\n\r\n\r\n  Running setup.py install for docopt\r\n  Running setup.py install for sqlparse\r\n    Fixing build\\lib\\sqlparse\\exceptions.py build\\lib\\sqlparse\\filters.py build\\\r\nlib\\sqlparse\\formatter.py build\\lib\\sqlparse\\functions.py build\\lib\\sqlparse\\key\r\nwords.py build\\lib\\sqlparse\\lexer.py build\\lib\\sqlparse\\pipeline.py build\\lib\\sq\r\nlparse\\sql.py build\\lib\\sqlparse\\tokens.py build\\lib\\sqlparse\\utils.py build\\lib\r\n\\sqlparse\\__init__.py build\\lib\\sqlparse\\engine\\filter.py build\\lib\\sqlparse\\eng\r\nine\\grouping.py build\\lib\\sqlparse\\engine\\__init__.py\r\n    Fixing build\\lib\\sqlparse\\exceptions.py build\\lib\\sqlparse\\filters.py build\\\r\nlib\\sqlparse\\formatter.py build\\lib\\sqlparse\\functions.py build\\lib\\sqlparse\\key\r\nwords.py build\\lib\\sqlparse\\lexer.py build\\lib\\sqlparse\\pipeline.py build\\lib\\sq\r\nlparse\\sql.py build\\lib\\sqlparse\\tokens.py build\\lib\\sqlparse\\utils.py build\\lib\r\n\\sqlparse\\__init__.py build\\lib\\sqlparse\\engine\\filter.py build\\lib\\sqlparse\\eng\r\nine\\grouping.py build\\lib\\sqlparse\\engine\\__init__.py\r\n  Running setup.py install for psycopg2\r\n    building 'psycopg2._psycopg' extension\r\n    error: Unable to find vcvarsall.bat\r\n    Complete output from command D:\\Python\\python.exe -c \"import setuptools, tok\r\nenize;__file__='C:\\\\Users\\\\JEROME~1\\\\AppData\\\\Local\\\\Temp\\\\pip-build-iu4ck56w\\\\p\r\nsycopg2\\\\setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read()\r\n.replace('\\r\\n', '\\n'), __file__, 'exec'))\" install --record C:\\Users\\JEROME~1\\A\r\nppData\\Local\\Temp\\pip-t1lhcf2s-record\\install-record.txt --single-version-extern\r\nally-managed --compile:\r\n    running install\r\n\r\n    running build\r\n\r\n    running build_py\r\n\r\n    creating build\r\n\r\n    creating build\\lib.win32-3.4\r\n\r\n    creating build\\lib.win32-3.4\\psycopg2\r\n\r\n    copying lib\\errorcodes.py -> build\\lib.win32-3.4\\psycopg2\r\n\r\n    copying lib\\extensions.py -> build\\lib.win32-3.4\\psycopg2\r\n\r\n    copying lib\\extras.py -> build\\lib.win32-3.4\\psycopg2\r\n\r\n    copying lib\\pool.py -> build\\lib.win32-3.4\\psycopg2\r\n\r\n    copying lib\\psycopg1.py -> build\\lib.win32-3.4\\psycopg2\r\n\r\n    copying lib\\tz.py -> build\\lib.win32-3.4\\psycopg2\r\n\r\n    copying lib\\_json.py -> build\\lib.win32-3.4\\psycopg2\r\n\r\n    copying lib\\_range.py -> build\\lib.win32-3.4\\psycopg2\r\n\r\n    copying lib\\__init__.py -> build\\lib.win32-3.4\\psycopg2\r\n\r\n    creating build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\dbapi20.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\dbapi20_tpc.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\testconfig.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\testutils.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_async.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_bugX000.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_bug_gc.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_cancel.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_connection.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_copy.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_cursor.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_dates.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_extras_dictcursor.py -> build\\lib.win32-3.4\\psycopg2\\test\r\ns\r\n\r\n    copying tests\\test_green.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_lobject.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_module.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_notify.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_psycopg2_dbapi20.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n\r\n    copying tests\\test_quote.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_transaction.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_types_basic.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_types_extras.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_with.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\__init__.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    Skipping implicit fixer: buffer\r\n\r\n    Skipping implicit fixer: idioms\r\n\r\n    Skipping implicit fixer: set_literal\r\n\r\n    Skipping implicit fixer: ws_comma\r\n\r\n    running build_ext\r\n\r\n    building 'psycopg2._psycopg' extension\r\n\r\n    error: Unable to find vcvarsall.bat\r\n\r\n    ----------------------------------------\r\n    Command \"D:\\Python\\python.exe -c \"import setuptools, tokenize;__file__='C:\\\\\r\nUsers\\\\JEROME~1\\\\AppData\\\\Local\\\\Temp\\\\pip-build-iu4ck56w\\\\psycopg2\\\\setup.py';e\r\nxec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\\r\\n', '\\n\r\n'), __file__, 'exec'))\" install --record C:\\Users\\JEROME~1\\AppData\\Local\\Temp\\pi\r\np-t1lhcf2s-record\\install-record.txt --single-version-externally-managed --compi\r\nle\" failed with error code 1 in C:\\Users\\JEROME~1\\AppData\\Local\\Temp\\pip-build-i\r\nu4ck56w\\psycopg2\r\n\r\ni get some help from google: maybe i need install MinGW ,so i install MinGW\r\n\r\nthen i retry step 3\r\n\r\nD:\\>pip install pgcli\r\nCollecting pgcli\r\n  Using cached pgcli-0.11.0.tar.gz\r\nCollecting click>=3.2 (from pgcli)\r\n  Using cached click-3.3-py2.py3-none-any.whl\r\nCollecting Pygments>=2.0 (from pgcli)\r\n  Using cached Pygments-2.0.1-py3-none-any.whl\r\nCollecting jedi==0.8.1 (from pgcli)\r\n  Using cached jedi-0.8.1.tar.gz\r\nCollecting prompt-toolkit==0.25 (from pgcli)\r\n  Using cached prompt_toolkit-0.25.tar.gz\r\nCollecting psycopg2>=2.5.4 (from pgcli)\r\n  Using cached psycopg2-2.5.4.tar.gz\r\nRequirement already satisfied (use --upgrade to upgrade): sqlparse>=0.1.14 in d:\r\n\\python\\lib\\site-packages (from pgcli)\r\nRequirement already satisfied (use --upgrade to upgrade): docopt in d:\\python\\li\r\nb\\site-packages (from prompt-toolkit==0.25->pgcli)\r\nRequirement already satisfied (use --upgrade to upgrade): six>=1.8.0 in d:\\pytho\r\nn\\lib\\site-packages (from prompt-toolkit==0.25->pgcli)\r\nRequirement already satisfied (use --upgrade to upgrade): wcwidth in d:\\python\\l\r\nib\\site-packages (from prompt-toolkit==0.25->pgcli)\r\nInstalling collected packages: psycopg2, prompt-toolkit, jedi, Pygments, click,\r\npgcli\r\n  Running setup.py install for psycopg2\r\n    building 'psycopg2._psycopg' extension\r\n    error: Microsoft Visual C++ 10.0 is required (Unable to find vcvarsall.bat).\r\n\r\n    Complete output from command D:\\Python\\python.exe -c \"import setuptools, tok\r\nenize;__file__='C:\\\\Users\\\\JEROME~1\\\\AppData\\\\Local\\\\Temp\\\\pip-build-fj7njncs\\\\p\r\nsycopg2\\\\setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read()\r\n.replace('\\r\\n', '\\n'), __file__, 'exec'))\" install --record C:\\Users\\JEROME~1\\A\r\nppData\\Local\\Temp\\pip-8ay3ynz7-record\\install-record.txt --single-version-extern\r\nally-managed --compile:\r\n    running install\r\n\r\n    running build\r\n\r\n    running build_py\r\n\r\n    creating build\r\n\r\n    creating build\\lib.win32-3.4\r\n\r\n    creating build\\lib.win32-3.4\\psycopg2\r\n\r\n    copying lib\\errorcodes.py -> build\\lib.win32-3.4\\psycopg2\r\n\r\n    copying lib\\extensions.py -> build\\lib.win32-3.4\\psycopg2\r\n\r\n    copying lib\\extras.py -> build\\lib.win32-3.4\\psycopg2\r\n\r\n    copying lib\\pool.py -> build\\lib.win32-3.4\\psycopg2\r\n\r\n    copying lib\\psycopg1.py -> build\\lib.win32-3.4\\psycopg2\r\n\r\n    copying lib\\tz.py -> build\\lib.win32-3.4\\psycopg2\r\n\r\n    copying lib\\_json.py -> build\\lib.win32-3.4\\psycopg2\r\n\r\n    copying lib\\_range.py -> build\\lib.win32-3.4\\psycopg2\r\n\r\n    copying lib\\__init__.py -> build\\lib.win32-3.4\\psycopg2\r\n\r\n    creating build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\dbapi20.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\dbapi20_tpc.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\testconfig.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\testutils.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_async.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_bugX000.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_bug_gc.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_cancel.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_connection.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_copy.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_cursor.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_dates.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_extras_dictcursor.py -> build\\lib.win32-3.4\\psycopg2\\test\r\ns\r\n\r\n    copying tests\\test_green.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_lobject.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_module.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_notify.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_psycopg2_dbapi20.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n\r\n    copying tests\\test_quote.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_transaction.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_types_basic.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_types_extras.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\test_with.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    copying tests\\__init__.py -> build\\lib.win32-3.4\\psycopg2\\tests\r\n\r\n    Skipping implicit fixer: buffer\r\n\r\n    Skipping implicit fixer: idioms\r\n\r\n    Skipping implicit fixer: set_literal\r\n\r\n    Skipping implicit fixer: ws_comma\r\n\r\n    running build_ext\r\n\r\n    building 'psycopg2._psycopg' extension\r\n\r\n    error: Microsoft Visual C++ 10.0 is required (Unable to find vcvarsall.bat).\r\n\r\n\r\n    ----------------------------------------\r\n    Command \"D:\\Python\\python.exe -c \"import setuptools, tokenize;__file__='C:\\\\\r\nUsers\\\\JEROME~1\\\\AppData\\\\Local\\\\Temp\\\\pip-build-fj7njncs\\\\psycopg2\\\\setup.py';e\r\nxec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\\r\\n', '\\n\r\n'), __file__, 'exec'))\" install --record C:\\Users\\JEROME~1\\AppData\\Local\\Temp\\pi\r\np-8ay3ynz7-record\\install-record.txt --single-version-externally-managed --compi\r\nle\" failed with error code 1 in C:\\Users\\JEROME~1\\AppData\\Local\\Temp\\pip-build-f\r\nj7njncs\\psycopg2\r\n\r\nso i need to install Microsoft Visual C++ 10.0 ?\r\n\r\nso much to install!\r\n\r\nIs there a simple way to fix this problem,  i just want to use pgcli, the simple  the better."},"comment":{"url":"https://api.github.com/repos/amjith/pgcli/issues/comments/69875876","html_url":"https://github.com/amjith/pgcli/issues/108#issuecomment-69875876","issue_url":"https://api.github.com/repos/amjith/pgcli/issues/108","id":69875876,"user":{"login":"jerome-peng","id":3261472,"avatar_url":"https://avatars.githubusercontent.com/u/3261472?v=3","gravatar_id":"","url":"https://api.github.com/users/jerome-peng","html_url":"https://github.com/jerome-peng","followers_url":"https://api.github.com/users/jerome-peng/followers","following_url":"https://api.github.com/users/jerome-peng/following{/other_user}","gists_url":"https://api.github.com/users/jerome-peng/gists{/gist_id}","starred_url":"https://api.github.com/users/jerome-peng/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jerome-peng/subscriptions","organizations_url":"https://api.github.com/users/jerome-peng/orgs","repos_url":"https://api.github.com/users/jerome-peng/repos","events_url":"https://api.github.com/users/jerome-peng/events{/privacy}","received_events_url":"https://api.github.com/users/jerome-peng/received_events","type":"User","site_admin":false},"created_at":"2015-01-14T06:46:03Z","updated_at":"2015-01-14T06:46:03Z","body":"yes ,i use darikg's suggestion install psycopg2, then use pip install pgcli, the install process is normal.\r\nhere is log:\r\n\r\n  Running setup.py install for pgcli\r\n    Installing pgcli-script.py script to D:\\Python\\Scripts\r\n    Installing pgcli.exe script to D:\\Python\\Scripts\r\n    Installing pgcli.exe.manifest script to D:\\Python\\Scripts\r\nSuccessfully installed Pygments-2.0.1 click-3.3 jedi-0.8.1 pgcli-0.12.0 prompt-t\r\noolkit-0.26\r\n\r\nD:\\>pgcli -h 192.168.20.19 -U afc edb\r\n\r\nthen i lose of control, it out of response. Even i can't use \"Ctrl\" +\"C\" to disrupt it.\r\n\r\n\r\n\r\n"}}