Passwords in Postgres logs - #postgresql #postgres

- Create role with password
- Sensitive passwords stored in postgres logs
- How to safely avoid this situation ?
- Different methods to create roles in Postgres

[ramsiddu]

00:05 Passwords may appear in Postgres logs when creating new roles or users.
00:34 Postgres logs can expose sensitive passwords.
01:06 Reset PG start statements and create a test role
01:46 Logging all or ddl statements can expose passwords in Postgres logs.
02:25 Sensitive passwords appearing in Postgres logs
03:00 Passwords appearing in PG statements is a security issue
03:30 Mitigate the risk of storing plain text passwords in Postgres logs
04:08 Postgres logs can store plain text passwords.