Re: pgAgent STDERR and Time Zone Questions

On Dec 23, 2011, at 2:25 AM, Dave Page wrote:

> Hmm, that looks like it should work. I've just run some tests here,
> and can't find anything wrong. Successes are reported as such, and
> non-zero return values are reported as whatever the "on error" setting
> says they should be. Subsequent steps in a job are either processed or
> skipped correctly based on the return value and on error setting of
> the previous step(s).
>
> postgres=# postgres=# select * from pgagent.pga_jobsteplog;
> jslid | jsljlgid | jsljstid | jslstatus | jslresult |
> jslstart            |   jslduration   |       jsloutput
>
-------+----------+----------+-----------+-----------+-------------------------------+-----------------+------------------------
>     1 |        1 |        1 | s         |       127 | 2011-12-23
> 10:14:37.108296+00 | 00:00:00.182375 |
>     2 |        2 |        1 | s         |       127 | 2011-12-23
> 10:15:02.155214+00 | 00:00:00.052011 |

Should those 127s be "s"?

>     3 |        3 |        1 | f         |       127 | 2011-12-23
> 10:16:02.334791+00 | 00:00:00.0732   |
>     4 |        4 |        1 | f         |       127 | 2011-12-23
> 10:17:02.514272+00 | 00:00:00.113905 |
>     5 |        5 |        1 | f         |       127 | 2011-12-23
> 10:18:02.645482+00 | 00:00:00.087998 | This will be an error.
>     6 |        6 |        1 | f         |       127 | 2011-12-23
> 10:19:02.780288+00 | 00:00:00.08348  | This will be an error.
>     7 |        7 |        1 | i         |       127 | 2011-12-23
> 10:20:02.903824+00 | 00:00:00.201093 | This will be an error.
>     8 |        7 |        3 | s         |         0 | 2011-12-23
> 10:20:03.106797+00 | 00:00:00.004515 | This will be a success
>     9 |        8 |        1 | i         |       127 | 2011-12-23
> 10:21:03.088051+00 | 00:00:00.006627 | This will be an error.
>    10 |        8 |        3 | s         |         0 | 2011-12-23
> 10:21:03.096869+00 | 00:00:00.006623 | This will be a success
> (10 rows)
>
> Is it possible you've got the config right now, but the logs you
> posted were from a different config?

Haven’t changed anything. I believe it’s the default configuration, as installed by Devrim’s new RPMs. Is there
somethingelse I should show you? 

Best,

David