Problem
My Postgres password is fetched from secrets dynamically (into ~/.pgpass), I don't know what it is.
TablePro doesn't seem to honor that file (the Postgress driver used by DBeaver does).
Proposed solution
- honor the standard
~/.pgpass file, which contains a list of $DB_HOST:$DB_PORT:$DB_DATABASE:$DB_USER:$DB_PASSWORD lines, and find the matching password for the current config
- (optional) add a pre-connect hook (a simple bash script that can be executed before connecting) -> I use this to refresh the password based on secrets
Alternatives considered
No response
Related database type
PostgreSQL
Problem
My Postgres password is fetched from secrets dynamically (into
~/.pgpass), I don't know what it is.TablePro doesn't seem to honor that file (the Postgress driver used by DBeaver does).
Proposed solution
~/.pgpassfile, which contains a list of$DB_HOST:$DB_PORT:$DB_DATABASE:$DB_USER:$DB_PASSWORDlines, and find the matching password for the current configAlternatives considered
No response
Related database type
PostgreSQL