Re: Where is located pgAgent log on Linux ?

Sabin Coanda wrote:
> "Dave Page" <dpage(at)postgresql(dot)org> wrote in message
> news:45F7B29D(dot)1020408(at)postgresql(dot)org(dot)(dot)(dot)
>> 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