Re: pgAgent - Log error when running - Mailing list pgadmin-support

From Dave Page
Subject Re: pgAgent - Log error when running
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E40154C3AC@ratbert.vale-housing.co.uk
Whole thread Raw
In response to Re: pgAgent - Log error when running  ("Chuck" <watsocd@gmail.com>)
List pgadmin-support

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Chuck
> Sent: 02 August 2006 12:49
> To: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] pgAgent - Log error when running
>
> I assume you are thinking there is a space in the IP address. There is
> not a typo in the command line that I can see.

No, there's a missing = sign. The format of the connection string is

param1=value1 param2=value2

So you need to change:

/usr/bin/pgagent hostaddr=127.0.0.1 dbname=postgres user postgres

To

/usr/bin/pgagent hostaddr=127.0.0.1 dbname=postgres user=postgres

> I have enabled connection logging and this is what I now find in the
> log.
>
> Notice the port number keeps increasing by one each time. I have run
> both the pgAgent startup commands so they are both trying to
> access the
> server.

That looks like it's just libpq opening the next free source socket.

Regards, Dave.


pgadmin-support by date:

Previous
From: "Chuck"
Date:
Subject: Re: pgAgent - Log error when running
Next
From: "Chuck"
Date:
Subject: Re: pgAgent - Log error when running