Re: [GENERAL] How to get login user name and host name in pgaudit

2017-10-22 Thread Arthur Zakirov
On Sun, Oct 22, 2017 at 05:32:56AM -0700, rakeshkumar464 wrote: > I installed latest pgaudit (1.2) with pg10. I am testing it and I see that > it does not log the login user name and host name. > > For example, if user mary is running select * from sensitive_table, I want > Mary and the machine

[GENERAL] How to get login user name and host name in pgaudit

2017-10-22 Thread rakeshkumar464
I installed latest pgaudit (1.2) with pg10. I am testing it and I see that it does not log the login user name and host name. For example, if user mary is running select * from sensitive_table, I want Mary and the machine from where she ran in the log. It seems to log the ids which needs to be