Re: Where is located pgAgent log on Linux ?

Sabin Coanda wrote:
> "Dave Page" <dpage@postgresql.org> wrote in message 
> news:45F7B29D.1020408@postgresql.org...
>> Sabin Coanda wrote:
>>> Hi,
>>>  Do you know where is located pgAgent log on Linux, please ?
>> stderr, or you can use the -s option to specify a file.
>>
>> I noticed this is missing from the docs which I've now corrected.
>>
>> Regards, Dave.
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 7: You can help support the PostgreSQL project by donating at
>>
>>                http://www.postgresql.org/about/donate
>>
> 
> Hi Dave,
> 
> I start pgagent on linux with the following command:
> 
>         pgagent hostaddr=127.0.0.1 dbname=postgres user=postgres -l 1
> 
> It works well and send the message logs to console.
> But when I wish to log to a file, and I start it with the command:
> 
>         pgagent hostaddr=127.0.0.1 dbname=postgres user=postgres -l 1 -s 
> /var/log/pgagent/pgagent.log
> 
> It logs the following error:
> 
>         Couldn't create connection: missing "=" after 
> "/var/log/pgagent/pgagent.log" in connection info string
> 
> What's happen ?

The connection string options must always be last - try:

pgagent -l 1 -s /var/log/pgagent/pgagent.log hostaddr=127.0.0.1 
dbname=postgres user=postgres

Regards, Dave