From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Chuck" <watsocd(at)gmail(dot)com>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: pgAgent - Log error when running |
Date: | 2006-08-02 12:04:56 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E40154C3AC@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Chuck
> Sent: 02 August 2006 12:49
> To: pgadmin-support(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Chuck | 2006-08-02 12:19:10 | Re: pgAgent - Log error when running |
Previous Message | Chuck | 2006-08-02 11:49:02 | Re: pgAgent - Log error when running |