{"action":"created","issue":{"url":"https://api.github.com/repos/netdata/netdata/issues/4904","repository_url":"https://api.github.com/repos/netdata/netdata","labels_url":"https://api.github.com/repos/netdata/netdata/issues/4904/labels{/name}","comments_url":"https://api.github.com/repos/netdata/netdata/issues/4904/comments","events_url":"https://api.github.com/repos/netdata/netdata/issues/4904/events","html_url":"https://github.com/netdata/netdata/pull/4904","id":386776389,"node_id":"MDExOlB1bGxSZXF1ZXN0MjM1NDE0NTcw","number":4904,"title":"Fix integer out of range error on Postgres 11","user":{"login":"arenddeboer","id":7022204,"node_id":"MDQ6VXNlcjcwMjIyMDQ=","avatar_url":"https://avatars2.githubusercontent.com/u/7022204?v=4","gravatar_id":"","url":"https://api.github.com/users/arenddeboer","html_url":"https://github.com/arenddeboer","followers_url":"https://api.github.com/users/arenddeboer/followers","following_url":"https://api.github.com/users/arenddeboer/following{/other_user}","gists_url":"https://api.github.com/users/arenddeboer/gists{/gist_id}","starred_url":"https://api.github.com/users/arenddeboer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/arenddeboer/subscriptions","organizations_url":"https://api.github.com/users/arenddeboer/orgs","repos_url":"https://api.github.com/users/arenddeboer/repos","events_url":"https://api.github.com/users/arenddeboer/events{/privacy}","received_events_url":"https://api.github.com/users/arenddeboer/received_events","type":"User","site_admin":false},"labels":[{"id":1131633615,"node_id":"MDU6TGFiZWwxMTMxNjMzNjE1","url":"https://api.github.com/repos/netdata/netdata/labels/area/collectors","name":"area/collectors","color":"0f34c6","default":false},{"id":1065921486,"node_id":"MDU6TGFiZWwxMDY1OTIxNDg2","url":"https://api.github.com/repos/netdata/netdata/labels/area/external/python","name":"area/external/python","color":"0f34c6","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-12-03T11:32:38Z","updated_at":"2018-12-03T19:59:44Z","closed_at":null,"author_association":"NONE","pull_request":{"url":"https://api.github.com/repos/netdata/netdata/pulls/4904","html_url":"https://github.com/netdata/netdata/pull/4904","diff_url":"https://github.com/netdata/netdata/pull/4904.diff","patch_url":"https://github.com/netdata/netdata/pull/4904.patch"},"body":"\r\n<!--\r\nDescribe the change in summary section, including rationale and degin decisions.\r\nInclude \"Fixes #nnn\" if you are fixing an existing issue.\r\n\r\nIn \"Component Name\" section write which component is changed in this PR. This\r\nwill help us review your PR quicker.\r\n\r\nIf you have more information you want to add, write them in \"Additional\r\nInformation\" section. This is usually used to help others understand your\r\nmotivation behind this change. A step-by-step reproduction of the problem is\r\nhelpful if there is no related issue.\r\n-->\r\n\r\n##### Summary\r\nFix integer out of range error on Postgres 11\r\n\r\n##### Component Name\r\ncollectors/python.d.plugin/postgres/postgres.chart.py\r\n\r\n##### Additional Information\r\nOn PostgreSQL 11 (haven't tested on other versions) an integer out of range error is thrown due to casting to INT:\r\n```\r\n2018-12-03 03:22:25: python.d ERROR: postgres: socket: update() unhandled exception: integer out of range\r\n```\r\nCasting to BIGINT solves this error.\r\nThe PostgreSQL Docs do not list wal_block_size as bigint, so I do not fully understand why this is required.\r\nhttps://www.postgresql.org/docs/11/functions-info.html\r\n\r\nNetdata: 1.11.1-68-g0fad9bf5\r\nOS: \tUbuntu 18.10\r\nPostgreSQL: PostgreSQL 11.1 (Ubuntu 11.1-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.3.0-27ubuntu1~18.04) 7.3.0, 64-bit"},"comment":{"url":"https://api.github.com/repos/netdata/netdata/issues/comments/443849322","html_url":"https://github.com/netdata/netdata/pull/4904#issuecomment-443849322","issue_url":"https://api.github.com/repos/netdata/netdata/issues/4904","id":443849322,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0Mzg0OTMyMg==","user":{"login":"anayrat","id":6862220,"node_id":"MDQ6VXNlcjY4NjIyMjA=","avatar_url":"https://avatars1.githubusercontent.com/u/6862220?v=4","gravatar_id":"","url":"https://api.github.com/users/anayrat","html_url":"https://github.com/anayrat","followers_url":"https://api.github.com/users/anayrat/followers","following_url":"https://api.github.com/users/anayrat/following{/other_user}","gists_url":"https://api.github.com/users/anayrat/gists{/gist_id}","starred_url":"https://api.github.com/users/anayrat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/anayrat/subscriptions","organizations_url":"https://api.github.com/users/anayrat/orgs","repos_url":"https://api.github.com/users/anayrat/repos","events_url":"https://api.github.com/users/anayrat/events{/privacy}","received_events_url":"https://api.github.com/users/anayrat/received_events","type":"User","site_admin":false},"created_at":"2018-12-03T19:59:44Z","updated_at":"2018-12-03T19:59:44Z","author_association":"CONTRIBUTOR","body":"Thanks but it is is little bit more complicated. The unit of wal_segment_size has changed in 11 : \r\nIn PG 10:\r\n```\r\nname            | wal_segment_size\r\nsetting         | 2048\r\nunit            | 8kB\r\n```\r\nIn PG 11:\r\n```\r\nname            | wal_segment_size\r\nsetting         | 16777216\r\nunit            | B\r\n```"}}
{"actor":{"display_login":"anayrat"}}