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 something else I should show you?

Best,

David