FeatureFuel
12

Allow configuring `pgaudit.log_parameter`

Source: supabase/supabase#20183 · opened by @xEverth
pgaudit is the recommended method to log according to the docs:
It's possible to enable logging (for a session, or for specific roles) and to choose the log level:

I'd like to verify the call parameters of the RPCs called via postgREST, but I am not able to alter pgaudit.log_parameter due to a permission error:

> ERROR: permission denied to set parameter "pgaudit.log_parameter"

To Reproduce


Connect to the database as postgres or use the SQL Editor from the dashboard and run either of the following:
set pgaudit.log_parameter to 'on';
alter role authenticator set pgaudit.log_parameter to 'on';

Expected behavior


I expect to be able to set log_parameter and audit the parameters sent to the RPC.


Screenshots

![image](
![image](
![image](

System information


Additional context

Postgres version: 15.1.0.113
PostgREST version: 11.2.0

No pledges yet. Be the first to back this.

Make a pledge

Pledge your monetary support if this feature is added.

$

Comments

No comments yet.

Replying to

Add a comment

What do you think about this feature request?


Similar requests