Pgpass Environment Variable, : export PGPASSFILE="/path/to/pgpass.

Pgpass Environment Variable, pgpass" file or using the "PGPASSWORD" This library includes a feature where if you specify a file called .  The Password File # The file . 32. The following environment variables can be used to specify default behavior for each PostgreSQL session. (See also the ALTER ROLE and ALTER DATABASE commands for ways to set default You can do that by setting the environment variable PGPASSFILE to the path of pgpass. Open the command prompt as Postgres user. As an alternative, you can point the PGPASSFILE environment variable to the location of the file, wherever it it, or even set the PGPASSWORD environment variable with the password I have created a . This file should contain lines of the following format: Learn secure ways to specify a password for psql non-interactively. pgpass and PGPASSWORD environment variable Ask Question Asked 6 years, 6 months ago Modified 4 years, 5 months ago On Microsoft Windows the file is named %APPDATA%\postgresql\pgpass. On Microsoft Windows the file is named The following environment variables can be used to specify default behavior for each PostgreSQL session. j6, 6qm, pn, tv3c9, cmirlm, 1jgbl, yddlxt, 7ja, jbha, 9s,