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

From: Hotmail <crajac66(at)hotmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Is there anyway for non-superuser to log all sql statements at the session level?
Date: 2021-09-09 23:30:55
Message-ID: SJ0PR06MB76469C5B646B4551B6292DBFD7D59@SJ0PR06MB7646.namprd06.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Paquier 2021-09-10 02:03:05 Re: Estimating HugePages Requirements?
Previous Message Bossart, Nathan 2021-09-09 21:53:22 Re: Estimating HugePages Requirements?