{"action":"created","issue":{"url":"https://api.github.com/repos/greenplum-db/gpdb/issues/2765","repository_url":"https://api.github.com/repos/greenplum-db/gpdb","labels_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/2765/labels{/name}","comments_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/2765/comments","events_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/2765/events","html_url":"https://github.com/greenplum-db/gpdb/pull/2765","id":241972141,"number":2765,"title":"Backport Postgres TAP SSL tests ","user":{"login":"pf-qiu","id":19681088,"avatar_url":"https://avatars0.githubusercontent.com/u/19681088?v=3","gravatar_id":"","url":"https://api.github.com/users/pf-qiu","html_url":"https://github.com/pf-qiu","followers_url":"https://api.github.com/users/pf-qiu/followers","following_url":"https://api.github.com/users/pf-qiu/following{/other_user}","gists_url":"https://api.github.com/users/pf-qiu/gists{/gist_id}","starred_url":"https://api.github.com/users/pf-qiu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pf-qiu/subscriptions","organizations_url":"https://api.github.com/users/pf-qiu/orgs","repos_url":"https://api.github.com/users/pf-qiu/repos","events_url":"https://api.github.com/users/pf-qiu/events{/privacy}","received_events_url":"https://api.github.com/users/pf-qiu/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2017-07-11T08:48:54Z","updated_at":"2017-07-11T14:02:24Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/greenplum-db/gpdb/pulls/2765","html_url":"https://github.com/greenplum-db/gpdb/pull/2765","diff_url":"https://github.com/greenplum-db/gpdb/pull/2765.diff","patch_url":"https://github.com/greenplum-db/gpdb/pull/2765.patch"},"body":"OpenSSL upgrade needs verification, backport related tests from Postgres.\r\nAlso, add config options to enable tap tests, adapt test framework to gpdb, allow SSL configuration to be updated with gpstop -u.\r\n"},"comment":{"url":"https://api.github.com/repos/greenplum-db/gpdb/issues/comments/314453519","html_url":"https://github.com/greenplum-db/gpdb/pull/2765#issuecomment-314453519","issue_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/2765","id":314453519,"user":{"login":"hlinnaka","id":191602,"avatar_url":"https://avatars1.githubusercontent.com/u/191602?v=3","gravatar_id":"","url":"https://api.github.com/users/hlinnaka","html_url":"https://github.com/hlinnaka","followers_url":"https://api.github.com/users/hlinnaka/followers","following_url":"https://api.github.com/users/hlinnaka/following{/other_user}","gists_url":"https://api.github.com/users/hlinnaka/gists{/gist_id}","starred_url":"https://api.github.com/users/hlinnaka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hlinnaka/subscriptions","organizations_url":"https://api.github.com/users/hlinnaka/orgs","repos_url":"https://api.github.com/users/hlinnaka/repos","events_url":"https://api.github.com/users/hlinnaka/events{/privacy}","received_events_url":"https://api.github.com/users/hlinnaka/received_events","type":"User","site_admin":false},"created_at":"2017-07-11T14:02:24Z","updated_at":"2017-07-11T14:02:24Z","body":"On 07/11/2017 04:56 PM, Peifeng Qiu wrote:\n> In fact I already modified the original SIGHUP patch to make reload\n> operation only carried out on QD, since QE usually don't have needed\n> certificate and key files within its data directory.\n\nMy point was that, if we don't backport the SIGHUP patch, you only need \nto stop and restart the QD node, to reload the certificates. So you \ncould modify the test case so that instead of restarting the whole \ncluster with gpstop + gpstart, only bounce the QD node, perhaps with a \ndirect \"pg_ctl restart\" call.\n\nThat's surely a lot slower than SIGHUP, but a lot faster than restarting \nall the nodes in the cluster. If I counted correctly, the test case \nreloads the certificates 4 times, and restarting just the QD node should \ntake a lot less than 20 minutes.\n\n- Heikki\n\n"}}
{"actor":{"display_login":"hlinnaka"}}