I've a problem but I search all the help file and can't find the solution.
I want to track all action of a specify role on all or one schema in database.
Can you help me?
Thanks a lot and Best Regard,
Setup your log_line_prefix and log_statement setting properly in postgresql.conf so that you get the user info and other appropriate details. After that you can tail the DB server log file and grep for that specific user to get what sort of SQL is been executed.