0

Is there any way to set log_statement for specific user in Azure PostgreSQL Flexible Server?

Normally it should be like: ALTER ROLE user_login SET log_statement TO 'all'; but due to access restriction on flexible server I got: ERROR: permission denied to set parameter "log_statement".

Improve this question
1
  • Who were you logged in as at the time? Commented Jul 18, 2024 at 18:13

1 Answer 1

Reset to default
0

enter image description here

According to this

Only superusers can change this setting.

If you try with any other instead of superuser then you may get above error. But According to the MS document super user is not accessible is not accessible in azure PostgreSQL - Flexible Server. You can enable log_statement server parameter by following below procedure: Go to Server parameters search for log_statement select the required value as shown below:

enter image description here

After Selecting the value save the changes by clicking on Save. Then you can view the logs in monitoring section. For more information you can refer to the MS document.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.