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;
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/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.