Re: pgAgent - Log error when running

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