user=postgres port=5432
On Mon, Jun 4, 2018 at 7:36 PM, Adrian Klaver
wrote:
> On 06/04/2018 03:31 PM, nageswara Bandla wrote:
>
>> I have figured out the issue with pgAgent both in Windows and Linux.
>>
>> PgAgent seems to ignore pgpass.conf/.pgpass whenever it has
host address
parameter. I have raised this concern with pgagent github where exactly
they need to change
the code in order for pgagent to be in line with psql program.
https://github.com/postgres/pgagent/issues/14
On Fri, Jun 1, 2018 at 9:43 AM, nageswara Bandla
wrote:
>
>
> On Thu, M
On Thu, May 31, 2018 at 5:16 PM, George Neuner wrote:
> On Thu, 31 May 2018 15:40:21 -0500, nageswara Bandla
> wrote:
>
> >On Thu, May 31, 2018 at 12:57 PM, George Neuner
> >wrote:
> >
> >> It just occurred to me that you said PGPASSFILE was set t
On Thu, May 31, 2018 at 12:57 PM, George Neuner
wrote:
> On Thu, 31 May 2018 11:24:18 -0500, nageswara Bandla
> wrote:
>
> >On Wed, May 30, 2018 at 7:45 PM, George Neuner
> wrote:
> >
> >> LocalSystem has administrator permissions to virtually everything.
>
On Wed, May 30, 2018 at 7:45 PM, George Neuner wrote:
> On Tue, 29 May 2018 13:32:46 -0700, Adrian Klaver
> 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.
On Wed, May 30, 2018 at 5:11 AM, Stéphane Dunand wrote:
>
> Le 29/05/2018 à 21:14, nageswara Bandla a écrit :
>
>
>
> The intention of this post is to find out ways to run pgagent without
> passing password in its connection string.
>
>
>
> *Windows:*
>
>
On Tue, May 29, 2018 at 6:15 PM, Adrian Klaver
wrote:
> On 05/29/2018 03:57 PM, nageswara Bandla wrote:
>
>> #1. Windows:
>>
>> My guess because the LocalSystem user does not have permissions on your:
>> %APPDATA%/postgresql/pgpass.co <http://pgpass.co>nf
&g
8.4.20, server 9.6.6)
WARNING: psql version 8.4, server version 9.6.
Some psql features might not work.
Type "help" for help.
linuxpostgresdb=#
On Tue, May 29, 2018 at 3:32 PM, Adrian Klaver
wrote:
> On 05/29/2018 12:14 PM, nageswara Bandla wrote:
>
>> The intentio
The intention of this post is to find out ways to run pgagent without
passing password in its connection string.
*Windows:*
I have installed pgagent on windows and configured to run under Local
System account.
Command:-
C:\PostgreSQL\bigsql\pgagent\bin\pgagent.exe INSTALL pgagent -l 2 -u
L
