Information
When a command is executed on the command line, for example
- psql postgresql://postgres:PASSWORD@host
the password may be visible in the user's shell/command history or in the process list, thus exposing the password to other entities on the server.
If the password is visible in the process list or user's shell/command history, an attacker will be able to access the PostgreSQL database using the stolen credentials.
NOTE: Nessus has not performed this check. Please review the benchmark to ensure target compliance.
Solution
-
Use the --password or -W terminal parameter without directly specifying the password and then enter the password when prompted.
Substitute <user> with your username, e.g., root:
psql -u <user> --password
-
Do not use a Connection URI https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING with password included, e.g. psql postgresql://postgres:PASSWORD@host
-
If desired, configure apgpass file with the proper credentials and secure the file appropriately.