Unable to find pgpass file

It can only perform this match if you give it a username and host to match with, — JHixson. JHixson - I like your explanation, but this is the first time I've seen the. JohnPrior sure, the documentation for the Pgpass file: postgresql.

Note how it only mentions being able to supply passwords. The things that you put in the file with the password are documented as "match criteria" for purposes of looking up a password. JohnPrior a line from the documentation that better illustrates the functionality: The password field from the first line that matches the current connection parameters will be used.

Show 3 more comments. Shrinivas Shrinivas 1, 15 15 silver badges 12 12 bronze badges. Nacho Mezzadra Nacho Mezzadra 2 2 gold badges 9 9 silver badges 13 13 bronze badges. Otherwise, the pgpass file will not be used. Make sure the passfile is a file not a symlink ; otherwise psql will print a warning.

Make sure the passfile is readable by the psql user e. Make sure that it is owned by the user, and that all its ancestor directories are executable by the user. Make sure that the pgpass file has the correct format hostname:port:database:username:password The Password File , passwordFromFile. Otherwise, the line will be ignored without warning. Thank you so much. So if you are trying t ouse wildcards in the pgpass file, I recommend against it. PoS code. Thank you so so much, I spent 2 days setting this file and getting password error, you saved me.

Noumenon 3, 4 4 gold badges 42 42 silver badges 60 60 bronze badges. Sign up or log in Sign up using Google. The database field is of limited usefulness otherwise, because users have the same password for all databases in the same cluster. If the permissions are less strict than this, the file will be ignored.

On Microsoft Windows, it is assumed that the file is stored in a directory that is secure, so no special permissions check is made. If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue. Development Versions: devel. Unsupported versions: 9. Resolved my issue. Clear instructions. Easy to follow.

No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Not enough pictures.