Re: PgAgent output

Eric Shuman wrote:
> Hello List,
>
> I need some help resolving an issue with PgAgent.
>
> Whenever a job runs I get a lot of output to the terminal. This can be
> quite disrupting when trying to do other work while it is running.
>
> I have upgraded to the recent 1.6.3 version and tried using the -s option
> but this has not stopped the output to stdout. The log file specified gets
> created, but is never populated with any data. How do I suppress the output
> from pgAgent????
>
> I am using this command to start pgagent:
> /usr/bin/pgagent -l 0 -s /GIS/pgagent.log hostaddr=127.0.0.1 dbname=postgres
> user=Postgres
>
> This is on a Debian Etch system and pgagent was installed via apt from one
> of the postgresql mirrors.

It works for me using SVN-trunk (and pgAgent hasn't really changed in a
long time):

dpage(at)developer:/usr/local/src/pgadmin3/xtra/pgagent# ./pgagent -l 2 -s
/tmp/pgagent.log hostaddr=127.0.0.1 dbname=postgres user=postgres
dpage(at)developer:/usr/local/src/pgadmin3/xtra/pgagent# ps aux |grep pgagent
dpage 7466 0.0 0.2 5796 2188 pts/1 S 07:35 0:00 ./pgagent
-l 2 -s /tmp/pgagent.log hostaddr=127.0.0.1 dbname=postgres user=postgres
dpage(at)developer:/usr/local/src/pgadmin3/xtra/pgagent# tail -f
/tmp/pgagent.log
DEBUG: Checking for jobs to run
DEBUG: Sleeping...
DEBUG: Clearing inactive connections
DEBUG: Connection stats: total - 1, free - 0, deleted - 0
DEBUG: Checking for jobs to run
DEBUG: Sleeping...
DEBUG: Clearing inactive connections
DEBUG: Connection stats: total - 1, free - 0, deleted - 0
DEBUG: Checking for jobs to run
DEBUG: Sleeping...

I'm not sure what to suggest - I assume you're stating it from an init
script or similar; I assume there are no typos in there?

Regards, Dave