postgresql - Windows PSQL command line: is there a way to allow for passwordless login?

Question

My goal is to be able to fire off a command without having to be prompted for my password. Is there any way to achieve this from the windows command line? In Linux I feel I could send the password to standard in or something, but I am not sure if I could do this for windows.

Thanks!

Answer 1

There are two ways:

• Set environment variable PGPASSWORD e.g. set PGPASSWORD=yoursecretpassword
• Use password file %APPDATA%postgresqlpgpass.conf as described in documentation

Within password file (my location is C:UsersGrzesiekAppDataRoamingpostgresqlpgpass.conf) use specified in doc format. For example to connect database postgres as role postgres on local 5432 server add:

localhost:5432:postgres:postgres:12345

I checked this and it works well (for me), but don't use 127.0.0.1).