Thread: pgaudit.log_parameter
Hello, I'm a little confused about the setting pgaudit.log_parameter of the pgaudit extension (https://github.com/pgaudit/pgaudit/blob/master/README.md). What's the purpose of this? AN example of query that will trigger such parameter logging? Apparently I cannot get it providing me more information than '<none>'. Thanks, Luca
Hello, On 31.07.2019 14:21, Luca Ferrari wrote: > Hello, > I'm a little confused about the setting pgaudit.log_parameter of the > pgaudit extension > (https://github.com/pgaudit/pgaudit/blob/master/README.md). > What's the purpose of this? AN example of query that will trigger such > parameter logging? Apparently I cannot get it providing me more > information than '<none>'. pgaudit.log_parameter allows to log parameters of prepared statements. See the documentation: https://www.postgresql.org/docs/current/sql-prepare.html The following example logs parameters if pgaudit.log_parameter is on: EXECUTE fooplan(1, 'Hunter Valley', 't', 200.00); It should log parameters: 1, 'Hunter Valley', 't', 200.00 -- Artur
Hello, On 31.07.2019 14:21, Luca Ferrari wrote: > Hello, > I'm a little confused about the setting pgaudit.log_parameter of the > pgaudit extension > (https://github.com/pgaudit/pgaudit/blob/master/README.md). > What's the purpose of this? AN example of query that will trigger such > parameter logging? Apparently I cannot get it providing me more > information than '<none>'. pgaudit.log_parameter allows to log parameters of prepared statements. See the documentation: https://www.postgresql.org/docs/current/sql-prepare.html The following example logs parameters if pgaudit.log_parameter is on: EXECUTE fooplan(1, 'Hunter Valley', 't', 200.00); It should log parameters: 1, 'Hunter Valley', 't', 200.00 -- Arthur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company