{"update": {"autokarma": true, "autotime": false, "stable_karma": 3, "stable_days": 0, "unstable_karma": -3, "require_bugs": true, "require_testcases": true, "display_name": "", "notes": "New upstream release 10.9\n    \nPer release notes:\nhttps://www.postgresql.org/docs/10/release-10-9.html", "type": "security", "status": "stable", "request": null, "severity": "medium", "suggest": "unspecified", "locked": false, "pushed": true, "critpath": false, "critpath_groups": null, "close_bugs": true, "date_submitted": "2019-07-17 07:10:26", "date_modified": null, "date_approved": null, "date_testing": "2019-07-18 03:35:41", "date_stable": "2019-07-26 01:50:50", "alias": "FEDORA-2019-e43f49b428", "test_gating_status": "ignored", "from_tag": null, "date_pushed": "2019-07-26 01:50:50", "meets_testing_requirements": true, "url": "https://bodhi.fedoraproject.org/updates/FEDORA-2019-e43f49b428", "title": "postgresql-10.9-1.fc29", "version_hash": "c28e6760dea8ff7901ddfceb0026659e1cab064c", "release": {"name": "F29", "long_name": "Fedora 29", "version": "29", "id_prefix": "FEDORA", "branch": "f29", "dist_tag": "f29", "stable_tag": "f29-updates", "testing_tag": "f29-updates-testing", "candidate_tag": "f29-updates-candidate", "pending_signing_tag": "f29-signing-pending", "pending_testing_tag": "f29-updates-testing-pending", "pending_stable_tag": "f29-updates-pending", "override_tag": "f29-override", "mail_template": "fedora_errata_template", "state": "archived", "composed_by_bodhi": true, "create_automatic_updates": false, "package_manager": "dnf", "testing_repository": "updates-testing", "released_on": null, "eol": null, "critpath_mandatory_days_in_testing": 14, "mandatory_days_in_testing": 7, "critpath_min_karma": 2, "min_karma": 1, "setting_status": null}, "user": {"name": "pkubat", "email": "pkubat@redhat.com", "id": 2917, "avatar": "https://seccdn.libravatar.org/avatar/e339947135b276e5a3f45cdfb0d665b3ed828b58e92a4ddd292f6bcc50cd3ed2?s=24&d=retro", "openid": "pkubat.id.fedoraproject.org", "groups": [{"name": "packager"}]}, "comments": [{"karma": 0, "karma_critpath": 0, "text": "This update has been submitted for testing by pkubat. ", "timestamp": "2019-07-17 07:10:26", "update_id": 142967, "user_id": 91, "id": 973589, "bug_feedback": [], "testcase_feedback": [], "user": {"name": "bodhi", "email": null, "id": 91, "avatar": "https://apps.fedoraproject.org/img/icons/bodhi-24.png", "openid": "bodhi.id.fedoraproject.org", "groups": []}}, {"karma": 0, "karma_critpath": 0, "text": "This update test gating status has been changed to 'waiting'.", "timestamp": "2019-07-17 07:10:27", "update_id": 142967, "user_id": 91, "id": 973590, "bug_feedback": [], "testcase_feedback": [], "user": {"name": "bodhi", "email": null, "id": 91, "avatar": "https://apps.fedoraproject.org/img/icons/bodhi-24.png", "openid": "bodhi.id.fedoraproject.org", "groups": []}}, {"karma": 0, "karma_critpath": 0, "text": "This update test gating status has been changed to 'ignored'.", "timestamp": "2019-07-17 07:10:31", "update_id": 142967, "user_id": 91, "id": 973591, "bug_feedback": [], "testcase_feedback": [], "user": {"name": "bodhi", "email": null, "id": 91, "avatar": "https://apps.fedoraproject.org/img/icons/bodhi-24.png", "openid": "bodhi.id.fedoraproject.org", "groups": []}}, {"karma": 0, "karma_critpath": 0, "text": "This update has been pushed to testing.", "timestamp": "2019-07-18 03:36:09", "update_id": 142967, "user_id": 91, "id": 974086, "bug_feedback": [], "testcase_feedback": [], "user": {"name": "bodhi", "email": null, "id": 91, "avatar": "https://apps.fedoraproject.org/img/icons/bodhi-24.png", "openid": "bodhi.id.fedoraproject.org", "groups": []}}, {"karma": 0, "karma_critpath": 0, "text": "This update has reached 7 days in testing and can be pushed to stable now if the maintainer wishes", "timestamp": "2019-07-25 03:36:10", "update_id": 142967, "user_id": 91, "id": 977353, "bug_feedback": [], "testcase_feedback": [], "user": {"name": "bodhi", "email": null, "id": 91, "avatar": "https://apps.fedoraproject.org/img/icons/bodhi-24.png", "openid": "bodhi.id.fedoraproject.org", "groups": []}}, {"karma": 0, "karma_critpath": 0, "text": "This update has been submitted for stable by pkubat. ", "timestamp": "2019-07-25 05:04:11", "update_id": 142967, "user_id": 91, "id": 977379, "bug_feedback": [], "testcase_feedback": [], "user": {"name": "bodhi", "email": null, "id": 91, "avatar": "https://apps.fedoraproject.org/img/icons/bodhi-24.png", "openid": "bodhi.id.fedoraproject.org", "groups": []}}, {"karma": 0, "karma_critpath": 0, "text": "This update has been pushed to stable.", "timestamp": "2019-07-26 01:51:16", "update_id": 142967, "user_id": 91, "id": 977914, "bug_feedback": [], "testcase_feedback": [], "user": {"name": "bodhi", "email": null, "id": 91, "avatar": "https://apps.fedoraproject.org/img/icons/bodhi-24.png", "openid": "bodhi.id.fedoraproject.org", "groups": []}}], "builds": [{"nvr": "postgresql-10.9-1.fc29", "signed": true, "release_id": 23, "type": "rpm", "epoch": 0}], "bugs": [{"bug_id": 1719698, "title": "CVE-2019-10164 PostgreSQL: stack-based buffer overflow via setting a password", "security": true, "parent": true, "feedback": [{"karma": 0, "comment_id": 979007, "bug_id": 1719698, "comment": {"karma": 1, "karma_critpath": 0, "text": "thanks for the update!", "timestamp": "2019-07-27 17:31:08", "update_id": 143577, "user_id": 827, "id": 979007, "testcase_feedback": [], "user": {"name": "praiskup", "email": "praiskup@redhat.com", "id": 827, "avatar": "https://seccdn.libravatar.org/avatar/16e1a710f35d917226ef12b6515ecc9743c03176e809752af95aeb1c36249008?s=24&d=retro", "openid": "praiskup.id.fedoraproject.org", "groups": [{"name": "provenpackager"}, {"name": "packager"}, {"name": "sysadmin-noc"}, {"name": "db-sig"}, {"name": "communishift"}, {"name": "pgjdbc-sig"}, {"name": "sysadmin"}, {"name": "aws-copr"}, {"name": "ipausers"}, {"name": "fedora-contributor"}, {"name": "signed_fpca"}, {"name": "copr-sig"}, {"name": "gitmock"}, {"name": "sysadmin-copr"}, {"name": "sysadmin-dns"}, {"name": "libarchive-sig"}, {"name": "gitcodescan-diff"}, {"name": "fedorabugs"}, {"name": "gitcopr"}, {"name": "communishift-log-detective"}, {"name": "sysadmin-main"}, {"name": "communishift-fedora-review-service"}, {"name": "communishift-lightspeed-build"}]}}}, {"karma": 0, "comment_id": 975291, "bug_id": 1719698, "comment": {"karma": 1, "karma_critpath": 0, "text": "", "timestamp": "2019-07-20 10:21:34", "update_id": 142966, "user_id": 124, "id": 975291, "testcase_feedback": [{"karma": 0, "comment_id": 975291, "testcase_id": 394, "testcase": {"name": "QA:Testcase database server remote client", "id": 394}}, {"karma": 0, "comment_id": 975291, "testcase_id": 427, "testcase": {"name": "QA:Testcase postgresql server installation", "id": 427}}], "user": {"name": "filiperosset", "email": "rosset.filipe@gmail.com", "id": 124, "avatar": "https://seccdn.libravatar.org/avatar/f4394b8fb4c9a99c4b534dc724912fe75a5b87fe15048985ece8388c2441d0ca?s=24&d=retro", "openid": "filiperosset.id.fedoraproject.org", "groups": [{"name": "proventesters"}, {"name": "packager"}, {"name": "provenpackager"}, {"name": "ipausers"}, {"name": "fedora-contributor"}, {"name": "signed_fpca"}, {"name": "fedorabugs"}, {"name": "ambassadors"}, {"name": "l10n"}, {"name": "cvsl10n"}, {"name": "fedora-br"}, {"name": "trust admins"}]}}}]}, {"bug_id": 1723413, "title": "CVE-2019-10164 postgresql: stack-based buffer overflow via setting a password [fedora-all]", "security": true, "parent": false, "feedback": [{"karma": 0, "comment_id": 979007, "bug_id": 1723413, "comment": {"karma": 1, "karma_critpath": 0, "text": "thanks for the update!", "timestamp": "2019-07-27 17:31:08", "update_id": 143577, "user_id": 827, "id": 979007, "testcase_feedback": [], "user": {"name": "praiskup", "email": "praiskup@redhat.com", "id": 827, "avatar": "https://seccdn.libravatar.org/avatar/16e1a710f35d917226ef12b6515ecc9743c03176e809752af95aeb1c36249008?s=24&d=retro", "openid": "praiskup.id.fedoraproject.org", "groups": [{"name": "provenpackager"}, {"name": "packager"}, {"name": "sysadmin-noc"}, {"name": "db-sig"}, {"name": "communishift"}, {"name": "pgjdbc-sig"}, {"name": "sysadmin"}, {"name": "aws-copr"}, {"name": "ipausers"}, {"name": "fedora-contributor"}, {"name": "signed_fpca"}, {"name": "copr-sig"}, {"name": "gitmock"}, {"name": "sysadmin-copr"}, {"name": "sysadmin-dns"}, {"name": "libarchive-sig"}, {"name": "gitcodescan-diff"}, {"name": "fedorabugs"}, {"name": "gitcopr"}, {"name": "communishift-log-detective"}, {"name": "sysadmin-main"}, {"name": "communishift-fedora-review-service"}, {"name": "communishift-lightspeed-build"}]}}}, {"karma": 0, "comment_id": 975291, "bug_id": 1723413, "comment": {"karma": 1, "karma_critpath": 0, "text": "", "timestamp": "2019-07-20 10:21:34", "update_id": 142966, "user_id": 124, "id": 975291, "testcase_feedback": [{"karma": 0, "comment_id": 975291, "testcase_id": 394, "testcase": {"name": "QA:Testcase database server remote client", "id": 394}}, {"karma": 0, "comment_id": 975291, "testcase_id": 427, "testcase": {"name": "QA:Testcase postgresql server installation", "id": 427}}], "user": {"name": "filiperosset", "email": "rosset.filipe@gmail.com", "id": 124, "avatar": "https://seccdn.libravatar.org/avatar/f4394b8fb4c9a99c4b534dc724912fe75a5b87fe15048985ece8388c2441d0ca?s=24&d=retro", "openid": "filiperosset.id.fedoraproject.org", "groups": [{"name": "proventesters"}, {"name": "packager"}, {"name": "provenpackager"}, {"name": "ipausers"}, {"name": "fedora-contributor"}, {"name": "signed_fpca"}, {"name": "fedorabugs"}, {"name": "ambassadors"}, {"name": "l10n"}, {"name": "cvsl10n"}, {"name": "fedora-br"}, {"name": "trust admins"}]}}}]}], "updateid": "FEDORA-2019-e43f49b428", "karma": 0, "content_type": "rpm", "test_cases": [{"name": "QA:Testcase database server remote client", "id": 394}, {"name": "QA:Testcase postgresql server installation", "id": 427}]}, "can_edit": false, "ci_allowed": false}