> -----Original Message-----
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] 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.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to