1.6 Verify That 'PGPASSWORD' is Not Set in Users' Profiles

Warning! Audit Deprecated

This audit has been deprecated and will be removed in a future update.

View Next Audit Version

Information

PostgreSQL can read a default database password from an environment variable called PGPASSWORD.

Rationale:

Use of the PGPASSWORD environment variable implies PostgreSQL credentials are stored as clear text. Avoiding this may increase assurance that the confidentiality of PostgreSQL credentials is preserved.

Solution

Check which users and/or scripts are setting PGPASSWORD and change them to use a more secure method.

See Also

https://workbench.cisecurity.org/benchmarks/17004