postgresql m1出现pgtool错误,我无法在命令行上运行pgtool,但出现错误

kse8i1jr  于 2024-01-07  发布在  PostgreSQL
关注(0)|答案(1)|浏览(155)

在我得到这个错误之前。我尝试在我的m1上安装pgspool包,并在运行docker后运行它,然后按照以下命令运行pgspool

docker run -it \
  -e POSTGRES_USER="root" \
  -e POSTGRES_PASSWORD="root" \
  -e POSTGRES_DB="ny_taxi" \
  -v $(pwd)/ny_taxi_postgres_data:/var/lib/postgresql/pg_data \
  -p 5001:5002 \
  postgres:13

个字符
并运行

pgcli


在命令行上,请帮助。

Traceback (most recent call last):
  File "/opt/homebrew/bin/pgcli", line 5, in <module>
    from pgcli.main import cli
  File "/opt/homebrew/lib/python3.10/site-packages/pgcli/main.py", line 2, in <module>
    from pgspecial.namedqueries import NamedQueries
  File "/opt/homebrew/lib/python3.10/site-packages/pgspecial/__init__.py", line 13, in <module>
    from . import iocommands
  File "/opt/homebrew/lib/python3.10/site-packages/pgspecial/iocommands.py", line 9, in <module>
    import psycopg
  File "/opt/homebrew/lib/python3.10/site-packages/psycopg/__init__.py", line 9, in <module>
    from . import pq  # noqa: F401 import early to stabilize side effects
  File "/opt/homebrew/lib/python3.10/site-packages/psycopg/pq/__init__.py", line 114, in <module>
    import_from_libpq()
  File "/opt/homebrew/lib/python3.10/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```

I try to run pgcli on mac m1 , after i run pgcli i should got this comment


alexay密码

follow this tutorial 
[data-engineer-zoomcamp](https://youtu.be/2JM-ziJt0WI?list=PL3MmuxUbc_hJed7dXYoJw8DoCuVHhGEQb&t=457)

zlwx9yxi

zlwx9yxi1#

这对我来说很有效(苹果M1 Pro,macOD Venturs 13.6.3)

pip install "psycopg[binary,pool]"

字符串

相关问题