Re: pgAgent STDERR and Time Zone Questions

On Fri, Dec 16, 2011 at 5:47 PM, David E. Wheeler <david(at)justatheory(dot)com> wrote:
> Howdy,
>
> I have a few questions about pgAgent, which I’ve just set up and am using at work.
>
> • I’m using -s to send errors to a log file. However, it only seems to log STDOUT, not STDERR. Is that right? Do I need to modify my batch scripts to 2>&1 to get STDERR output?

All of the internal logging goes to the file if specified, or stdout,
with the exception of a couple of serious errors, like "failed to open
the logfile". wxWidgets might be writing some of it's own logging
output to stderr though I guess.

> • When scheduling execution times in pgAdmin, what time zone does it use?

It doesn't, as you don't typically specify absolute dates in schedule
(except sometimes for exceptions and
start/end dates - then it'll default to whatever the connection will use)

> And what time zone does pgagent use to determine when it's time to run a job?

Whatever the default is for the client that causes the execution time
to be recalculated.

In truth though, when this was originally written I don't think anyone
really considered different timezones. Patches are welcome if you want
to improve.

> And on a side note: What are the chance the pgAgent daemon could be modified so that it does not use the wx library. Seems kind of silly to include a GUI library in a daemon, though I don’t doubt that it makes windows compatibility easier.

wxWidgets isn't just a GUI library - it consists of various individual
libraries offering different features, some of which are GUI related,
and some are not. pgAgent doesn't use any of the GUI ones, so there's
no requirement to install any GUI components on your server (unless
your chosen packaging for wxWidgets doesn't separate the GUI and
non-GUI parts of course).

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company