Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Wed, May 30, 2018 at 7:45 PM, George Neuner <gneuner2@xxxxxxxxxxx> wrote:
On Tue, 29 May 2018 13:32:46 -0700, Adrian Klaver
<adrian.klaver@xxxxxxxxxxx> wrote:

>On 05/29/2018 12:14 PM, nageswara Bandla wrote:
>
>> As per the link-
>> (https://www.postgresql.org/docs/9.6/static/libpq-pgpass.html) I set
>> PGPASSFILE environment variable to point to pgpass.conf location. Even
>> then, it’s throwing same above error message. I have found out that
>> pgagent is not reading pgpass.conf file when configured under
>> LocalSystem account.
>>
>> When I change the properties of the pgagent service to run under my
>> login user account. Then, it’s reading pgpass.conf file under
>> %APPDATA%/postgresql/pgpass.conf.
>>
>> I am clueless, why pgagent is not honoring PGPASSFILE env variable.
>
>My guess because the LocalSystem user does not have permissions on your:
>
>%APPDATA%/postgresql/pgpass.conf
>
>file. This seems to be confirmed by it working when you run pgagent as
>the login user.

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.



 

George


>passfile
>
>     Specifies the name of the file used to store passwords (see Section
>33.15). Defaults to ~/.pgpass, or %APPDATA%\postgresql\pgpass.conf on
>Microsoft Windows. (No error is reported if this file does not exist.)
>                     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux