使用pd.read_sql读取postgresql数据报sqlalchemy.exc.OperationalError: (psycopg2.OperationalError)

最新推荐文章于 2024-05-28 09:34:20 发布

原创

最新推荐文章于 2024-05-28 09:34:20 发布 · 2.6k 阅读

1 ·

CC 4.0 BY-SA版权

在尝试使用Python3.8读取PostgreSQL数据库中的数据时遇到错误。错误信息显示为OperationalError，可能与psycopg2库或sqlalchemy版本不兼容有关。已尝试搜索解决方案但未果，目前考虑回退到Python3.7版本解决。

使用

# 环境python3.8
import pandas as pd
df = pd.read_sql(sql='select * from table', con='postgresql://postgres:***@localhost:5432/db')

读取postgresql中数据
报错

D:\Anaconda\envs\pan38\python.exe "C:\Users\201\PyCharm 2020.2\plugins\python\helpers\pydev\pydevconsole.py" --mode=client --port=56151
import sys; print('Python %s on %s' % (sys.version, sys.platform))
sys.path.extend(['E:\\PychramProject\\pan20', 'E:/PychramProject/pan20'])
PyDev console: starting.
Python 3.8.10 (default, May 19 2021, 13:12:57) [MSC v.1916 64 bit (AMD64)] on win32
runfile('E:/PychramProject/pan20/test_onlineAPI.py', wdir='E:/PychramProject/pan20')
Traceback (most recent call last):
  File "D:\Anaconda\envs\pan38\lib\site-packages\sqlalchemy\engine\base.py", line 2336, in _wrap_pool_connect
    return fn()
  File "D:\Anaconda\envs\pan38\lib\site-packages\sqlalchemy\pool\base.py", line 364, in connect
    return _ConnectionFairy._checkout(self)
  File "D:\Anaconda\envs\pan38\lib\site-packages\sqlalchemy\pool\base.py", line 778, in _checkout
    fairy = _ConnectionRecord.checkout(poo