We would like to identify which IAM user executes a Cloud SQL Proxy connection in the logs. However, we can see this message:
"textPayload": "2022-11-14 10:41:29.849 UTC [358324]: [1-1] db=[unknown],user=[unknown] LOG: connection received: host=[local]",
We have the following flags enabled in the Postgres database:
- cloudsql.enable_pgaudit = ON
- pgaudit.log = all
- log_connections = On
- log_disconnections = On
We would like to know what other missing properties we need to set to have that "db" and "user" fields populated properly.
Thanks.