问题遇到的现象和发生背景
天天基金网获取基金数据来分析 数据库连接
用代码块功能插入代码,请勿粘贴截图
初始化数据库连接:
engine = create_engine(
"postgresql+psycopg2://username:'ncxcdb',passwd:'78265503_QQcom',@47.100.38.198:5433/dbf5d2d80675b44e41ac30430f974d0c0fncxcbd")
创建DBSession类型:
DBSession = sessionmaker(bind=engine)
创建表结构
Base.metadata.create_all(engine)
运行结果及报错内容
OperationalError: (psycopg2.OperationalError) connection to server at "47.100.38.198", port 5433 failed: FATAL: connection requires a valid client certificate
connection to server at "47.100.38.198", port 5433 failed: FATAL: no pg_hba.conf entry for host "172.29.4.12", user "username", database "dbf5d2d80675b44e41ac30430f974d0c0fncxcbd", SSL off
(Background on this error at: https://sqlalche.me/e/14/e3q8)
我的解答思路和尝试过的方法
仔细核对连接资料没有错呀
我想要达到的结果
数据库连接成功,下载的程序运行成功、