"Dave Page" <dpage@postgresql.org> wrote in message
news:45F90E98.90500@postgresql.org...
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
I relaunched it: pgagent -l 1 -s /var/log/pgagent/pgagent.log hostaddr=127.0.0.1
dbname=postgres user=postgres
Unfortunatelly I got the same message: WARNING: Couldn't create connection: missing "=" after
"/var/log/pgagent/pgagent.log" in connection info string
:((
Regards, Sabin
