{"update": {"autokarma": true, "autotime": false, "stable_karma": 3, "stable_days": 0, "unstable_karma": -3, "require_bugs": true, "require_testcases": true, "display_name": "", "notes": "update to 9.4.5 per release notes http://www.postgresql.org/docs/9.4/static/release-9-4-5.html\n", "type": "security", "status": "stable", "request": null, "severity": "unspecified", "suggest": "unspecified", "locked": false, "pushed": true, "critpath": false, "critpath_groups": null, "close_bugs": true, "date_submitted": "2015-10-08 13:43:39", "date_modified": "2015-10-10 10:26:04", "date_approved": null, "date_testing": "2015-10-09 11:24:47", "date_stable": "2015-10-11 16:01:25", "alias": "FEDORA-2015-7fac92f49c", "test_gating_status": null, "from_tag": null, "date_pushed": "2015-10-11 16:01:25", "meets_testing_requirements": false, "url": "https://bodhi.fedoraproject.org/updates/FEDORA-2015-7fac92f49c", "title": "postgresql-9.4.5-1.fc23", "version_hash": "9d85750e98c5c44435a5fecc48d631e06e309603", "release": {"name": "F23", "long_name": "Fedora 23", "version": "23", "id_prefix": "FEDORA", "branch": "f23", "dist_tag": "f23", "stable_tag": "f23-updates", "testing_tag": "f23-updates-testing", "candidate_tag": "f23-updates-candidate", "pending_signing_tag": "f23-signing-pending", "pending_testing_tag": "f23-updates-testing-pending", "pending_stable_tag": "f23-updates-pending", "override_tag": "f23-override", "mail_template": "fedora_errata_template", "state": "archived", "composed_by_bodhi": true, "create_automatic_updates": null, "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": "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"}]}, "comments": [{"karma": 0, "karma_critpath": 0, "text": "This update has been submitted for testing by praiskup. ", "timestamp": "2015-10-08 13:43:39", "update_id": 41616, "user_id": 91, "id": 335037, "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": "2015-10-09 13:56:32", "update_id": 41616, "user_id": 91, "id": 336413, "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": 1, "karma_critpath": 0, "text": "Works", "timestamp": "2015-10-10 09:44:38", "update_id": 41616, "user_id": 202, "id": 336659, "bug_feedback": [], "testcase_feedback": [], "user": {"name": "dandim", "email": "dan.dim@seznam.cz", "id": 202, "avatar": "https://seccdn.libravatar.org/avatar/f0f96b1ac727426da54b2b24ac6b98a5f075783c24214b710f8893cd9b1ae00e?s=24&d=retro", "openid": "dandim.id.fedoraproject.org", "groups": [{"name": "ipausers"}]}}, {"karma": 0, "karma_critpath": 0, "text": "praiskup edited this update.", "timestamp": "2015-10-10 10:26:04", "update_id": 41616, "user_id": 91, "id": 336665, "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": 1, "karma_critpath": 0, "text": "+1", "timestamp": "2015-10-11 08:54:47", "update_id": 41616, "user_id": 2267, "id": 337034, "bug_feedback": [{"karma": 0, "comment_id": 337034, "bug_id": 1270314, "bug": {"bug_id": 1270314, "title": "CVE-2015-5288 CVE-2015-5289 postgresql: various flaws [fedora-all]", "security": true, "parent": false}}], "testcase_feedback": [], "user": {"name": "asleqia", "email": "asleqia@gmail.com", "id": 2267, "avatar": "https://seccdn.libravatar.org/avatar/7a1cd681bc9af94594f75cd4f6e505815a3378181b0c820632d1f5fa0a4cdb69?s=24&d=retro", "openid": "asleqia.id.fedoraproject.org", "groups": []}}, {"karma": 0, "karma_critpath": 0, "text": "This update has been submitted for stable by bodhi. ", "timestamp": "2015-10-11 11:21:38", "update_id": 41616, "user_id": 91, "id": 337061, "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": 1, "karma_critpath": 0, "text": "Works for me", "timestamp": "2015-10-11 11:21:38", "update_id": 41616, "user_id": 308, "id": 337062, "bug_feedback": [{"karma": 0, "comment_id": 337062, "bug_id": 1270314, "bug": {"bug_id": 1270314, "title": "CVE-2015-5288 CVE-2015-5289 postgresql: various flaws [fedora-all]", "security": true, "parent": false}}], "testcase_feedback": [], "user": {"name": "chr77", "email": "chr77@protonmail.com", "id": 308, "avatar": "https://seccdn.libravatar.org/avatar/c9ddae9d692ab2ea6cecd787db18332407bb29982c8a1eae39771bfb270b71fd?s=24&d=retro", "openid": "chr77.id.fedoraproject.org", "groups": [{"name": "packager"}, {"name": "ipausers"}, {"name": "fedora-contributor"}, {"name": "signed_fpca"}, {"name": "fedorabugs"}, {"name": "trust admins"}]}}, {"karma": 0, "karma_critpath": 0, "text": "This update has been pushed to stable.", "timestamp": "2015-10-11 16:05:12", "update_id": 41616, "user_id": 91, "id": 337103, "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-9.4.5-1.fc23", "signed": true, "release_id": 11, "type": "rpm", "epoch": 0}], "bugs": [{"bug_id": 1270314, "title": "CVE-2015-5288 CVE-2015-5289 postgresql: various flaws [fedora-all]", "security": true, "parent": false, "feedback": [{"karma": 0, "comment_id": 337034, "bug_id": 1270314, "comment": {"karma": 1, "karma_critpath": 0, "text": "+1", "timestamp": "2015-10-11 08:54:47", "update_id": 41616, "user_id": 2267, "id": 337034, "testcase_feedback": [], "user": {"name": "asleqia", "email": "asleqia@gmail.com", "id": 2267, "avatar": "https://seccdn.libravatar.org/avatar/7a1cd681bc9af94594f75cd4f6e505815a3378181b0c820632d1f5fa0a4cdb69?s=24&d=retro", "openid": "asleqia.id.fedoraproject.org", "groups": []}}}, {"karma": 0, "comment_id": 337062, "bug_id": 1270314, "comment": {"karma": 1, "karma_critpath": 0, "text": "Works for me", "timestamp": "2015-10-11 11:21:38", "update_id": 41616, "user_id": 308, "id": 337062, "testcase_feedback": [], "user": {"name": "chr77", "email": "chr77@protonmail.com", "id": 308, "avatar": "https://seccdn.libravatar.org/avatar/c9ddae9d692ab2ea6cecd787db18332407bb29982c8a1eae39771bfb270b71fd?s=24&d=retro", "openid": "chr77.id.fedoraproject.org", "groups": [{"name": "packager"}, {"name": "ipausers"}, {"name": "fedora-contributor"}, {"name": "signed_fpca"}, {"name": "fedorabugs"}, {"name": "trust admins"}]}}}, {"karma": 0, "comment_id": 355390, "bug_id": 1270314, "comment": {"karma": 0, "karma_critpath": 0, "text": "$ tar -xf dtf-postgresql-fedora-22-x86_64-0.0.tar.xz \ntar: dtf-postgresql-fedora-22-x86_64-0.0/upstream-testsuite/testcase: time stamp 2015-11-20 19:47:35 is 3443.160348867 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/upstream-testsuite/run: time stamp 2015-11-20 19:47:35 is 3443.15971492 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/upstream-testsuite: time stamp 2015-11-20 19:47:35 is 3443.159418477 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/upgrade/locale/utf8-syntax/testcase: time stamp 2015-11-20 19:47:35 is 3443.158883277 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/upgrade/locale/utf8-syntax/run: time stamp 2015-11-20 19:47:35 is 3443.158653481 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/upgrade/locale/utf8-syntax: time stamp 2015-11-20 19:47:35 is 3443.158454596 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/upgrade/locale/changed/testcase: time stamp 2015-11-20 19:47:35 is 3443.158172077 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/upgrade/locale/changed/run: time stamp 2015-11-20 19:47:35 is 3443.15694062 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/upgrade/locale/changed: time stamp 2015-11-20 19:47:35 is 3443.156744448 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/upgrade/locale/run: time stamp 2015-11-20 19:47:35 is 3443.156449154 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/upgrade/locale: time stamp 2015-11-20 19:47:35 is 3443.15627126 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/upgrade/basic/testcase: time stamp 2015-11-20 19:47:35 is 3443.155981226 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/upgrade/basic/run: time stamp 2015-11-20 19:47:35 is 3443.155756119 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/upgrade/basic: time stamp 2015-11-20 19:47:35 is 3443.155584335 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/upgrade/run: time stamp 2015-11-20 19:47:34 is 3442.155311976 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/upgrade: time stamp 2015-11-20 19:47:35 is 3443.155136346 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/initdb/old-syntax/run: time stamp 2015-11-20 19:47:34 is 3442.154775909 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/initdb/old-syntax: time stamp 2015-11-20 19:47:34 is 3442.154597091 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/initdb/basic/testcase: time stamp 2015-11-20 19:47:34 is 3442.154262761 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/initdb/basic/run: time stamp 2015-11-20 19:47:34 is 3442.154018658 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/initdb/basic: time stamp 2015-11-20 19:47:34 is 3442.153839884 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/initdb/run: time stamp 2015-11-20 19:47:34 is 3442.153611463 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/initdb: time stamp 2015-11-20 19:47:34 is 3442.153356623 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/run: time stamp 2015-11-20 19:47:34 is 3442.153109398 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0/library: time stamp 2015-11-20 19:47:34 is 3442.152714865 s in the future\ntar: dtf-postgresql-fedora-22-x86_64-0.0: time stamp 2015-11-20 19:47:35 is 3443.152477381 s in the future\n$ DTF_DBG_KEYWORDS=dtf_lib ./dtf-postgresql-fedora-22-x86_64-0.0/run\n\n ** going to initdb **\n\n initdb/basic\n ~ making sure findutils is installed\n ~ checking whether 'findutils' is installed\n ~ running service postgresql status\n ~ making sure postgresql-server is installed\n ~ checking whether 'postgresql-server' is installed\n ~ running postgresql-setup --initdb\n ~ running service postgresql start\n ~ running service postgresql stop\n ~ running test -f /var/lib/pgsql/data/PG_VERSION\n ~ running rm -r /var/lib/pgsql/data/*\n ~ running rm /var/lib/pgsql/*.log\n ~ running postgresql-setup initdb\n ~ running service postgresql start\n ~ running service postgresql stop\n ~ running test -f /var/lib/pgsql/data/PG_VERSION\n ~ running rm -r /var/lib/pgsql/data/*\n ~ running rm /var/lib/pgsql/*.log\n\n ** group initdb: Ok. **\n\n\n ** going to upgrade **\n\n upgrade/basic\n ~ making sure findutils is installed\n ~ checking whether 'findutils' is installed\n ~ running service postgresql status\n ~ making sure postgresql-server is installed\n ~ checking whether 'postgresql-server' is installed\n ~ making sure postgresql-upgrade is installed\n ~ checking whether 'postgresql-upgrade' is installed\nchecking upgrade from: fedora 20 upgrade\n ~ running postgresql-setup --upgrade\n ~ running service postgresql start\n ~ running service postgresql status\n ~ running service postgresql stop\n ~ running service postgresql status\n ~ running rm -r /var/lib/pgsql/data/*\n ~ running rm -r /var/lib/pgsql/data-old\nchecking upgrade from: fedora 21 upgrade\n ~ running postgresql-setup --upgrade\n ~ running service postgresql start\n ~ running service postgresql status\n ~ running service postgresql stop\n ~ running service postgresql status\n ~ running rm -r /var/lib/pgsql/data/*\n ~ running rm -r /var/lib/pgsql/data-old\nchecking upgrade from: fedora 22 run\n ~ running service postgresql start\n ~ running service postgresql status\n ~ running service postgresql stop\n ~ running service postgresql status\n ~ running service postgresql stop\n ~ running service postgresql status\n ~ running rm -r /var/lib/pgsql/data/*\n ~ running rm /var/lib/pgsql/*.log\n\n ** going to upgrade/locale **\n\n upgrade/locale/changed\n ~ making sure postgresql-upgrade is installed\n ~ checking whether 'postgresql-upgrade' is installed\n ~ making sure findutils is installed\n ~ checking whether 'findutils' is installed\n ~ running service postgresql status\n ~ making sure postgresql-server is installed\n ~ checking whether 'postgresql-server' is installed\nchecking upgrade from: fedora 20 upgrade\n ~ running postgresql-setup --upgrade\n ~ running service postgresql start\n ~ running service postgresql status\n ~ running service postgresql stop\n ~ running service postgresql status\n ~ running rm -r /var/lib/pgsql/data/*\n ~ running rm -r /var/lib/pgsql/data-old\nchecking upgrade from: fedora 21 upgrade\n ~ running postgresql-setup --upgrade\n ~ running service postgresql start\n ~ running service postgresql status\n ~ running service postgresql stop\n ~ running service postgresql status\n ~ running rm -r /var/lib/pgsql/data/*\n ~ running rm -r /var/lib/pgsql/data-old\nchecking upgrade from: fedora 22 run\n ~ running service postgresql start\n ~ running service postgresql status\n ~ running service postgresql stop\n ~ running service postgresql status\n ~ running service postgresql stop\n ~ running service postgresql status\n ~ running rm -r /var/lib/pgsql/data/*\n ~ running rm /var/lib/pgsql/*.log\n upgrade/locale/utf8-syntax\n ~ making sure postgresql-upgrade is installed\n ~ checking whether 'postgresql-upgrade' is installed\n ~ making sure findutils is installed\n ~ checking whether 'findutils' is installed\n ~ running service postgresql status\n ~ making sure postgresql-server is installed\n ~ checking whether 'postgresql-server' is installed\nchecking upgrade from: fedora 20 upgrade\n ~ running postgresql-setup --upgrade\n ~ running service postgresql start\n ~ running service postgresql status\n ~ running service postgresql stop\n ~ running service postgresql status\n ~ running rm -r /var/lib/pgsql/data/*\n ~ running rm -r /var/lib/pgsql/data-old\nchecking upgrade from: fedora 21 upgrade\n ~ running postgresql-setup --upgrade\n ~ running service postgresql start\n ~ running service postgresql status\n ~ running service postgresql stop\n ~ running service postgresql status\n ~ running rm -r /var/lib/pgsql/data/*\n ~ running rm -r /var/lib/pgsql/data-old\nchecking upgrade from: fedora 22 run\n ~ running service postgresql start\n ~ running service postgresql status\n ~ running service postgresql stop\n ~ running service postgresql status\n ~ running service postgresql stop\n ~ running service postgresql status\n ~ running rm -r /var/lib/pgsql/data/*\n ~ running rm /var/lib/pgsql/*.log\n\n ** group upgrade/locale: Ok. **\n\n\n ** group upgrade: Ok. **\n\n upstream-testsuite\n ~ making sure postgresql-test is installed\n ~ checking whether 'postgresql-test' is installed\n ~ making sure make is installed\n ~ checking whether 'make' is installed\n ~ making sure findutils is installed\n ~ checking whether 'findutils' is installed\n ~ running service postgresql status\n ~ making sure postgresql-server is installed\n ~ checking whether 'postgresql-server' is installed\n ~ running postgresql-setup --initdb\n ~ running service postgresql start\n ~ running service postgresql status\n ~ running service postgresql stop\n ~ running service postgresql status\n ~ running rm -r /var/lib/pgsql/data/*\n ~ running rm /var/lib/pgsql/*.log\n\n ** Success. **\n", "timestamp": "2015-11-20 18:56:14", "update_id": 41617, "user_id": 827, "id": 355390, "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"}]}}}, {"karma": 0, "comment_id": 355391, "bug_id": 1270314, "comment": {"karma": 0, "karma_critpath": 0, "text": "$ rpm -q postgresql-server fedora-release\npostgresql-server-9.4.5-1.fc22.x86_64\nfedora-release-22-1.noarch\n", "timestamp": "2015-11-20 18:56:57", "update_id": 41617, "user_id": 827, "id": 355391, "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"}]}}}]}], "updateid": "FEDORA-2015-7fac92f49c", "karma": 3, "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}