dbcli / dbcli/pgcli

Not working on windows 11

未关闭
#1,413 16 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看
主要语言
Python
星标
13.4k
派生
612
平均合并
6 天 14 小时
30 天内合并 PR
10

描述

## Description

```
> pgcli postgres://xxx:xxx@localhost:5432
Traceback (most recent call last):
File "", line 198, in _run_module_as_main
File "", line 88, in _run_code
File "C:\Users\admin\.local\bin\pgcli.exe\__main__.py", line 4, in
File "C:\Users\admin\.local\pipx\venvs\pgcli\Lib\site-packages\pgcli\main.py", line 2, in
from pgspecial.namedqueries import NamedQueries
File "C:\Users\admin\.local\pipx\venvs\pgcli\Lib\site-packages\pgspecial\__init__.py", line 12, in
from . import dbcommands
File "C:\Users\admin\.local\pipx\venvs\pgcli\Lib\site-packages\pgspecial\dbcommands.py", line 7, in
from psycopg.sql import SQL
File "C:\Users\admin\.local\pipx\venvs\pgcli\Lib\site-packages\psycopg\__init__.py", line 9, in
from . import pq # noqa: F401 import early to stabilize side effects
^^^^^^^^^^^^^^^^
File "C:\Users\admin\.local\pipx\venvs\pgcli\Lib\site-packages\psycopg\pq\__init__.py", line 114, in
import_from_libpq()
File "C:\Users\admin\.local\pipx\venvs\pgcli\Lib\site-packages\psycopg\pq\__init__.py", line 106, in import_from_libpq
raise ImportError(
ImportError: no pq wrapper available.
Attempts made:
- couldn't import psycopg 'c' implementation: No module named 'psycopg_c'
- couldn't import psycopg 'binary' implementation: No module named 'psycopg_binary'
- couldn't import psycopg 'python' implementation: libpq library not found
```

## Your environment

- [x] Please provide your OS and version information.
Window 11 with Python 3.11.4
- [x] Please provide your CLI version.
`pgcli` fails with all args, so I cannot see its version, but it should be the latest version.
- [x] What is the output of ``pip freeze`` command.
```
cli-helpers==2.3.0
click==8.1.6
colorama==0.4.6
configobj==5.0.8
pendulum==2.1.2
pgcli==3.5.0
pgspecial==2.1.0
prompt-toolkit==3.0.39
psycopg==3.1.9
Pygments==2.15.1
python-dateutil==2.8.2
pytzdata==2020.1
setproctitle==1.3.2
six==1.16.0
sqlparse==0.4.4
tabulate==0.9.0
typing_extensions==4.7.1
tzdata==2023.3
wcwidth==0.2.6
```

贡献指南

打开贡献指南

调研方向

运行 pgcli 复现 Windows 11 故障,然后通过 pgcli/main.py、pgspecial/dbcommands.py 和 psycopg/pq/__init__.py 跟踪启动时的导入。比较可用的 psycopg 实现和报告中缺失的 libpq 库;在指定的 Windows 和 Python 版本上 pgcli 成功启动即表示完成。

由索引模型根据 Issue 内容生成。

评估

技术栈
postgresql, python
领域
cli, databases, operating-systems
Issue 类型
缺陷
难度
4/5
预计耗时
3-5 天
活跃度
停滞
描述清晰度
需要澄清
新手友好度
35/100

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。