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

Поиск
Список
Период
Сортировка
От Hotmail
Тема Is there anyway for non-superuser to log all sql statements at the session level?
Дата
Msg-id SJ0PR06MB76469C5B646B4551B6292DBFD7D59@SJ0PR06MB7646.namprd06.prod.outlook.com
обсуждение исходный текст
Ответы Re: Is there anyway for non-superuser to log all sql statements at the session level?  (Dan Smith <j.daniel.smith1@gmail.com>)
Re: Is there anyway for non-superuser to log all sql statements at the session level?  (hubert depesz lubaczewski <depesz@depesz.com>)
Список 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 по дате отправления:

Предыдущее
От: איגוד המתווכים בישראל
Дата:
Сообщение: Re: Blank page
Следующее
От: Dan Smith
Дата:
Сообщение: Re: Is there anyway for non-superuser to log all sql statements at the session level?