{"action":"created","issue":{"url":"https://api.github.com/repos/michaelpq/pg_plugins/issues/21","repository_url":"https://api.github.com/repos/michaelpq/pg_plugins","labels_url":"https://api.github.com/repos/michaelpq/pg_plugins/issues/21/labels{/name}","comments_url":"https://api.github.com/repos/michaelpq/pg_plugins/issues/21/comments","events_url":"https://api.github.com/repos/michaelpq/pg_plugins/issues/21/events","html_url":"https://github.com/michaelpq/pg_plugins/pull/21","id":302716020,"number":21,"title":"jsonlog: Use as compatible as possible ISO-8601 date format","user":{"login":"gsstark","id":484000,"avatar_url":"https://avatars3.githubusercontent.com/u/484000?v=4","gravatar_id":"","url":"https://api.github.com/users/gsstark","html_url":"https://github.com/gsstark","followers_url":"https://api.github.com/users/gsstark/followers","following_url":"https://api.github.com/users/gsstark/following{/other_user}","gists_url":"https://api.github.com/users/gsstark/gists{/gist_id}","starred_url":"https://api.github.com/users/gsstark/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gsstark/subscriptions","organizations_url":"https://api.github.com/users/gsstark/orgs","repos_url":"https://api.github.com/users/gsstark/repos","events_url":"https://api.github.com/users/gsstark/events{/privacy}","received_events_url":"https://api.github.com/users/gsstark/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-03-06T14:12:14Z","updated_at":"2018-03-21T03:34:51Z","closed_at":null,"author_association":"NONE","pull_request":{"url":"https://api.github.com/repos/michaelpq/pg_plugins/pulls/21","html_url":"https://github.com/michaelpq/pg_plugins/pull/21","diff_url":"https://github.com/michaelpq/pg_plugins/pull/21.diff","patch_url":"https://github.com/michaelpq/pg_plugins/pull/21.patch"},"body":"If log_timezone is GMT use the maximally compatible format\r\n1975-08-19T23:15:30.000Z as generated by JavaScript (see the demo at\r\nhttps://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date/toJSON)\r\nand which is accepted by jq.\r\n\r\nOtherwise respect log_timezone (even though it seems like a bad idea\r\nto use non-GMT in a machine-readable format) but use ISO-8601 numeric\r\ntimezone offset such as 1975-08-19T23:15:30.000+05:00 which at least\r\nwill be readable by Joda-based parsers such as ElasticSearch.\r\n\r\nThis should guarantee that the logs are usable on ElasticSearch and if\r\nyou use log_timezone=GMT then they should be readable by any json\r\nparsing tool.\r\n\r\n(Use pg_get_timezone_offset so it doesn't matter how you spell GMT but\r\nthe timestamp format doesn't just change back and force spontaneously\r\nif you use a timezone that has offset 0 for part of the year)"},"comment":{"url":"https://api.github.com/repos/michaelpq/pg_plugins/issues/comments/374825726","html_url":"https://github.com/michaelpq/pg_plugins/pull/21#issuecomment-374825726","issue_url":"https://api.github.com/repos/michaelpq/pg_plugins/issues/21","id":374825726,"user":{"login":"michaelpq","id":985332,"avatar_url":"https://avatars2.githubusercontent.com/u/985332?v=4","gravatar_id":"","url":"https://api.github.com/users/michaelpq","html_url":"https://github.com/michaelpq","followers_url":"https://api.github.com/users/michaelpq/followers","following_url":"https://api.github.com/users/michaelpq/following{/other_user}","gists_url":"https://api.github.com/users/michaelpq/gists{/gist_id}","starred_url":"https://api.github.com/users/michaelpq/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/michaelpq/subscriptions","organizations_url":"https://api.github.com/users/michaelpq/orgs","repos_url":"https://api.github.com/users/michaelpq/repos","events_url":"https://api.github.com/users/michaelpq/events{/privacy}","received_events_url":"https://api.github.com/users/michaelpq/received_events","type":"User","site_admin":false},"created_at":"2018-03-21T03:34:51Z","updated_at":"2018-03-21T03:34:51Z","author_association":"OWNER","body":"> So I'm going to update this pull request to ignore log_timezone entirely. I really think that's the only sensible approach.\r\n\r\nOK. If you have a new patch I'll try to look at it asap. On my side, I have been thinking a bit about it and at the end I don't want to make you unhappy as you seem to be using this plugin more than I do ;)"}}
{"actor":{"display_login":"michaelpq"}}