What permissions are required on the .pgpass file?

[will-e-yams]

I found this lib via brianc/node-postgres#455.

Can you clarify which permissions are required to read from the file?

From the postgres docs:

On Unix systems, the permissions on .pgpass must disallow any access to world or group; achieve this by the command chmod 0600 ~/.pgpass. If the permissions are less strict than this, the file will be ignored.

This is the way mine is set up and works in other scenarios. However the lib seems to not using the .pgpass file. Also, there is no error telling me of a permissions problem (graceful fallback?).

[hoegaarden]

If there is an issue with the file permissions, it should be logged to stderr, as you can e.g. see in the test output here.

If the pgpass does not moan about anything of that sorts and still the password is not used, you might check on the functions

• getFileName
• usePgPass

if you can find something obvious why the pgpass file is not used in your case. One of my guesses is: It's in the wrong path?