Search code examples
windowspostgresql

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

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!

Solution

  • There are two ways:

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

    Within password file (my location is C:\Users\Grzesiek\AppData\Roaming\postgresql\pgpass.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).