How do I set a postgresql password in pgpass.conf for the Administrator account on Windows Server 2008?

I have a pgpass.conf file that works well for my default user. It is in C:/Users/myuser/AppData/Roaming/postgresql/pgpass.conf. It reads like so;

localhost:5432:*:postgres:password1

I have a process that runs under the Administrator account. When I run whoami under this process I get nt authority/system. I want to be able to access the database from this process but it gets stuck because it needs a password. I have tried putting the above pgpass.conf into C:/Users/Administrator/AppData/postgresql/pgpass.conf and C:/Users/Administrator/AppData/Roaming/postgresql/pgpass.conf but it does not work. Is this the correct place for this file? Am I even able to do this as the Administrator. Unfortunately I cannot change the user that this process runs under.


See what echo %APPDATA% outputs when you're logged with this account.

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 itself to avoid that file altogether.

The Environment Variables and The Password File sections from the doc give the details.