Postgresql flask-sqlalchemy permission denied to set parameter > "log_statement_stats"

Question

I'm attempting to initialise my database for a flask app using flask-sqlalchemy.

I've received the following fatal error.

sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) connection to server at "occ-appdc1001" (172.25.208.1), port 5432 failed: FATAL: permission denied to set parameter "log_statement_stats"

My connection string is:

app.config['SQLALCHEMY_DATABASE_URI'] = "postgresql://prodcent_user:XXXXX@SERVER:5432/appdata?options=-search_path=datamanager"

I've tried adding permissions as follows:

GRANT USAGE ON SCHEMA datamanager TO prodcent_user ;
GRANT USAGE ON SCHEMA datamanager TO prodcent_user ;

GRANT SELECT ON ALL TABLES IN SCHEMA datamanager TO prodcent_user ;
GRANT SELECT ON ALL SEQUENCES IN SCHEMA datamanager TO prodcent_user ;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA datamanager TO prodcent_user ;

GRANT ALL ON ALL TABLES IN SCHEMA datamanager TO prodcent_user ;
GRANT ALL ON ALL SEQUENCES IN SCHEMA datamanager TO prodcent_user ;
GRANT ALL ON ALL FUNCTIONS IN SCHEMA datamanager TO prodcent_user ;

But still have the same error.

richyen · Accepted Answer · 2022-09-13 23:41:34Z

1

Only the superuser can change log_statement_stats. It appears you are using prodcent_user, which probably doesn't have superuser privileges.

You can try either using a superuser or find a way to grant superuser privileges to prodcent_user

answered Sep 13, 2022 at 23:41

richyen

10.3k4 gold badges18 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql flask-sqlalchemy permission denied to set parameter > "log_statement_stats"

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related