RDS Postgres - How to avoid 'password' statement into log file

Viewed 162

Currently, we are using 'DDL' log model for Postgres RDS. However, this log does capture the password management statement. For example, if using the statement create user user1 with password 'some_secret_password', this password will be saved into a log file.

Is there any way we can avoid to save any password related information into the log? Can anyone please advise what parameter should be changed in order to not capture any password information?

1 Answers

Use a different method to set the password. Neither psql's \password nor pgAdmin's "change password" dialog have this problem.

Related