When I was running the flask app with psycopg2, I got the following error.
OperationalError: (psycopg2.OperationalError) server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
from flask_sqlalchemy import SQLAlchemy as _BaseSQLAlchemy
class SQLAlchemy(_BaseSQLAlchemy):
def apply_pool_defaults(self, app, options):
super(SQLAlchemy, self).apply_pool_defaults(self, app, options)
options["pool_pre_ping"] = True
db = SQLAlchemy(app)
It was solved by putting the above program. The reference URL below also lists other solutions, so if you are good at English, please take a look.
Reference URL
https://stackoverflow.com/questions/55457069/how-to-fix-operationalerror-psycopg2-operationalerror-server-closed-the-conn
https://github.com/pallets/flask-sqlalchemy/issues/589#issuecomment-361075700