1. 安装依赖

yum install -y postgresql-devel python38-devel

pip install psycopg2 sqlalchemy

2. 连接 postgresql

import sqlalchemy
from sqlalchemy import func, orm


def get_session(url=None):
    engine = sqlalchemy.create_engine(url)
    metadata = sqlalchemy.schema.MetaData(bind=engine)
    #models.Base.metadata.create_all(engine)
    Sess = orm.sessionmaker(bind=engine)
    session = Sess()
    return session

session = get_session("postgresql://username:password@172.17.0.1:63832/catdb")