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