Re: Where is located pgAgent log on Linux ?

[Dave Page <dpage(at)postgresql(dot)org>]

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