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