Re: Pgagent is not reading pgpass file either in Windows or Linux.

On Thu, 31 May 2018 11:24:18 -0500, nageswara Bandla
<nag(dot)bandla(at)gmail(dot)com> wrote:

>On Wed, May 30, 2018 at 7:45 PM, George Neuner <gneuner2(at)comcast(dot)net> wrote:
>
>> LocalSystem has administrator permissions to virtually everything.
>> https://msdn.microsoft.com/en-us/library/windows/desktop/
>> ms684190(v=vs.85).aspx
>>
>> It should be able to read files belonging to any user.
>>
>> But the LocalSystem account can see only *global* environment
>> variables ... it can't see any user specific ones. I would check if
>> the PGPASSFILE variable is set globally or only in the user account.
>>
>>
>> I don't know anything specifically about running pgagent on Windows,
>> so I can't say why it is giving an error if the docs say it should
>> not.
>>
>
>
>I am setting the PGPASSFILE in system environment variables. I am not
>setting it in user specific environmental variables.

It just occurred to me that you said PGPASSFILE was set to

%APPDATA%/postgresql/pgpass.conf

The problem may be that when LocalSystem expands %APPDATA%, it is
finding its own directory, which might be any of:

C:\Windows\ServiceProfiles\LocalService\appdata
C:\Windows\System32\config\systemprofile\AppData
C:\Windows\SysWOW64\config\systemprofile\AppData

depending on your Windows version, policies (if any), and whether the
executable is 32 or 64 bit.

I wouldn't try messing with any of these directories. Instead try
setting PGPASSFILE to the full path to your file.

George