PGAudit with managed postgres

[tornike]

I’m trying to configure pgaudit extension for a managed postgres instance.

Ran command to activate the extension

CREATE EXTENSION IF NOT EXISTS pgaudit;

If I want to change log level, I get permission error:

set pgaudit.log = 'write, ddl'
ERROR:  permission denied to set parameter "pgaudit.log"

I understand that managed service does not give access to superuser and at the same time pgaudit does not allow non-superuser to change settings:

Quote from pgaudit README

“Settings may be modified only by a superuser. Allowing normal users to change their settings would defeat the point of an audit log.”

So how should I approach the problem and at the end how to read pgaudit logs properly.

[jeremy-render]

Hey,

Please reach out to us through the dashboard or by emailing support@render.com, and we’ll look into this further. You’re right that pgaudit requires superuser privileges to make those changes, and those permissions aren’t something you have access to on your end.

Jérémy.
Render Support, UTC+3