{"action":"created","issue":{"url":"https://api.github.com/repos/alphagov/govuk-puppet/issues/4849","repository_url":"https://api.github.com/repos/alphagov/govuk-puppet","labels_url":"https://api.github.com/repos/alphagov/govuk-puppet/issues/4849/labels{/name}","comments_url":"https://api.github.com/repos/alphagov/govuk-puppet/issues/4849/comments","events_url":"https://api.github.com/repos/alphagov/govuk-puppet/issues/4849/events","html_url":"https://github.com/alphagov/govuk-puppet/pull/4849","id":175510959,"number":4849,"title":"Exclude the events table from the Publishing API database backup","user":{"login":"cbaines","id":1130010,"avatar_url":"https://avatars.githubusercontent.com/u/1130010?v=3","gravatar_id":"","url":"https://api.github.com/users/cbaines","html_url":"https://github.com/cbaines","followers_url":"https://api.github.com/users/cbaines/followers","following_url":"https://api.github.com/users/cbaines/following{/other_user}","gists_url":"https://api.github.com/users/cbaines/gists{/gist_id}","starred_url":"https://api.github.com/users/cbaines/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cbaines/subscriptions","organizations_url":"https://api.github.com/users/cbaines/orgs","repos_url":"https://api.github.com/users/cbaines/repos","events_url":"https://api.github.com/users/cbaines/events{/privacy}","received_events_url":"https://api.github.com/users/cbaines/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-09-07T14:03:16Z","updated_at":"2016-09-07T15:15:28Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/alphagov/govuk-puppet/pulls/4849","html_url":"https://github.com/alphagov/govuk-puppet/pull/4849","diff_url":"https://github.com/alphagov/govuk-puppet/pull/4849.diff","patch_url":"https://github.com/alphagov/govuk-puppet/pull/4849.patch"},"body":"This takes up a large proportion of the of the backup, and is used by very few people.\r\n\r\nMy testing on integration shows that this drops the size of the Publishing API backup by ~2GB (from 2.7GB to 723MB)."},"comment":{"url":"https://api.github.com/repos/alphagov/govuk-puppet/issues/comments/245313790","html_url":"https://github.com/alphagov/govuk-puppet/pull/4849#issuecomment-245313790","issue_url":"https://api.github.com/repos/alphagov/govuk-puppet/issues/4849","id":245313790,"user":{"login":"cbaines","id":1130010,"avatar_url":"https://avatars.githubusercontent.com/u/1130010?v=3","gravatar_id":"","url":"https://api.github.com/users/cbaines","html_url":"https://github.com/cbaines","followers_url":"https://api.github.com/users/cbaines/followers","following_url":"https://api.github.com/users/cbaines/following{/other_user}","gists_url":"https://api.github.com/users/cbaines/gists{/gist_id}","starred_url":"https://api.github.com/users/cbaines/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cbaines/subscriptions","organizations_url":"https://api.github.com/users/cbaines/orgs","repos_url":"https://api.github.com/users/cbaines/repos","events_url":"https://api.github.com/users/cbaines/events{/privacy}","received_events_url":"https://api.github.com/users/cbaines/received_events","type":"User","site_admin":false},"created_at":"2016-09-07T15:15:28Z","updated_at":"2016-09-07T15:15:28Z","body":"> Personally I don't think the backups should differ in their contents from the production environment. It risks adding confusion and setting a bad precedent.\r\n> \r\n> I'd prefer it if we could resolve this table issue in a way that didn't require intervening with the backups.\r\n\r\nI agree.\r\n\r\nHowever, I think that this is the best short term solution to reduce the impact that the Publishing API is having on the amount of data downloaded by the sync-postgresql script, as my tests on integration show that this will drop the size of the downloaded file from 3GB to 1.1GB.\r\n\r\nI guess we could hold off on merging this until more people start complaining (I'm not even sure if anyone has complained yet) at the Publishing API team (and maybe we would end up sorting out this events situation in the mean time)."}}
{"actor":{"display_login":"cbaines"}}