PostgreSQL Credentials Password file

ID

postgres_pgpass

Severity

high

Vendor

PostgreSQL

Family

Data Storage Secret

Description

PostgresSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance.

Security

Any hardcoded PostgresSQL Credential in a Password File (pgpass) is a potential secret reported by this detector.

Accidentally checking-in the key to source control repositories could compromise your PostgresSQL resource.

Examples

localhost:5432:postgres:postgres:postgres1

Mitigation / Fix

  1. Remove the credentials from the source code or committed configuration file.

  2. Follow your policy for handling leaked secrets, which typically require revoking the secret in the target system(s).

  3. If under a git repository, you may remove unwanted files from the repository history using tools like git filter-repo or BFG Repo-Cleaner. You may follow the procedure listed here for GitHub.

You should consider any sensitive data in commits with secrets as compromised.

Remember that secrets may be removed from history in your projects, but not in other users' cloned or forked repositories.