Is there anyway for non-superuser to log all sql statements at the session level? - Mailing list pgsql-admin

From Hotmail
Subject Is there anyway for non-superuser to log all sql statements at the session level?
Date
Msg-id SJ0PR06MB76469C5B646B4551B6292DBFD7D59@SJ0PR06MB7646.namprd06.prod.outlook.com
Whole thread Raw
Responses Re: Is there anyway for non-superuser to log all sql statements at the session level?
Re: Is there anyway for non-superuser to log all sql statements at the session level?
List pgsql-admin
Hi All,

We use liquibase to run migrations against our postgres 11 database. We run the migrations as an application user that does not have superuser permissions. Is there any workaround we could use that would allow us to capture the migration sql that is run by our application user? We want to capture all of the ddl as well as the dml run by the migration user. Since setting log_statement=all  at the session level isn’t possible unless the user is a superuser is there any other way to accomplish this task? 

Thanks,


Craig Jackson

pgsql-admin by date:

Previous
From: איגוד המתווכים בישראל
Date:
Subject: Re: Blank page
Next
From: Dan Smith
Date:
Subject: Re: Is there anyway for non-superuser to log all sql statements at the session level?