{"action":"created","issue":{"url":"https://api.github.com/repos/AmericanRedCross/posm/issues/89","repository_url":"https://api.github.com/repos/AmericanRedCross/posm","labels_url":"https://api.github.com/repos/AmericanRedCross/posm/issues/89/labels{/name}","comments_url":"https://api.github.com/repos/AmericanRedCross/posm/issues/89/comments","events_url":"https://api.github.com/repos/AmericanRedCross/posm/issues/89/events","html_url":"https://github.com/AmericanRedCross/posm/issues/89","id":135899086,"number":89,"title":"Periodically feed APIDB edits back into rendering DB","user":{"login":"mojodna","id":45,"avatar_url":"https://avatars.githubusercontent.com/u/45?v=3","gravatar_id":"","url":"https://api.github.com/users/mojodna","html_url":"https://github.com/mojodna","followers_url":"https://api.github.com/users/mojodna/followers","following_url":"https://api.github.com/users/mojodna/following{/other_user}","gists_url":"https://api.github.com/users/mojodna/gists{/gist_id}","starred_url":"https://api.github.com/users/mojodna/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mojodna/subscriptions","organizations_url":"https://api.github.com/users/mojodna/orgs","repos_url":"https://api.github.com/users/mojodna/repos","events_url":"https://api.github.com/users/mojodna/events{/privacy}","received_events_url":"https://api.github.com/users/mojodna/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/AmericanRedCross/posm/labels/P2","name":"P2","color":"fbca04"}],"state":"open","locked":false,"assignee":{"login":"hallahan","id":556367,"avatar_url":"https://avatars.githubusercontent.com/u/556367?v=3","gravatar_id":"","url":"https://api.github.com/users/hallahan","html_url":"https://github.com/hallahan","followers_url":"https://api.github.com/users/hallahan/followers","following_url":"https://api.github.com/users/hallahan/following{/other_user}","gists_url":"https://api.github.com/users/hallahan/gists{/gist_id}","starred_url":"https://api.github.com/users/hallahan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hallahan/subscriptions","organizations_url":"https://api.github.com/users/hallahan/orgs","repos_url":"https://api.github.com/users/hallahan/repos","events_url":"https://api.github.com/users/hallahan/events{/privacy}","received_events_url":"https://api.github.com/users/hallahan/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/AmericanRedCross/posm/milestones/1","html_url":"https://github.com/AmericanRedCross/posm/milestones/Field%20Test%201","labels_url":"https://api.github.com/repos/AmericanRedCross/posm/milestones/1/labels","id":1601083,"number":1,"title":"Field Test 1","description":"Functionality needed in time for Liberia and Ecuador field tests. The Liberia team departs on 3/10, Ecuador on 3/13.","creator":{"login":"mojodna","id":45,"avatar_url":"https://avatars.githubusercontent.com/u/45?v=3","gravatar_id":"","url":"https://api.github.com/users/mojodna","html_url":"https://github.com/mojodna","followers_url":"https://api.github.com/users/mojodna/followers","following_url":"https://api.github.com/users/mojodna/following{/other_user}","gists_url":"https://api.github.com/users/mojodna/gists{/gist_id}","starred_url":"https://api.github.com/users/mojodna/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mojodna/subscriptions","organizations_url":"https://api.github.com/users/mojodna/orgs","repos_url":"https://api.github.com/users/mojodna/repos","events_url":"https://api.github.com/users/mojodna/events{/privacy}","received_events_url":"https://api.github.com/users/mojodna/received_events","type":"User","site_admin":false},"open_issues":7,"closed_issues":18,"state":"open","created_at":"2016-02-23T21:09:06Z","updated_at":"2016-03-29T20:40:57Z","due_on":"2016-03-09T08:00:00Z","closed_at":null},"comments":3,"created_at":"2016-02-23T23:27:39Z","updated_at":"2016-03-31T23:27:02Z","closed_at":null,"body":"Osmosis `--read-apidb` → `osm2pgsql` (replacing the existing rendering DB)."},"comment":{"url":"https://api.github.com/repos/AmericanRedCross/posm/issues/comments/204173231","html_url":"https://github.com/AmericanRedCross/posm/issues/89#issuecomment-204173231","issue_url":"https://api.github.com/repos/AmericanRedCross/posm/issues/89","id":204173231,"user":{"login":"hallahan","id":556367,"avatar_url":"https://avatars.githubusercontent.com/u/556367?v=3","gravatar_id":"","url":"https://api.github.com/users/hallahan","html_url":"https://github.com/hallahan","followers_url":"https://api.github.com/users/hallahan/followers","following_url":"https://api.github.com/users/hallahan/following{/other_user}","gists_url":"https://api.github.com/users/hallahan/gists{/gist_id}","starred_url":"https://api.github.com/users/hallahan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hallahan/subscriptions","organizations_url":"https://api.github.com/users/hallahan/orgs","repos_url":"https://api.github.com/users/hallahan/repos","events_url":"https://api.github.com/users/hallahan/events{/privacy}","received_events_url":"https://api.github.com/users/hallahan/received_events","type":"User","site_admin":false},"created_at":"2016-03-31T23:27:02Z","updated_at":"2016-03-31T23:27:02Z","body":"I have attempted to create a temporary render db so that when we are rebuilding, the db isnt in an odd state for mapnik.\r\n\r\nHowever, For a reason I haven't uncovered, sometimes that temp db is missing POSTGIS and HSTORE, though I explicitly create it in posm-build:\r\n\r\nhttps://github.com/AmericanRedCross/posm-build/blob/master/kickstart/scripts/carto-deploy.sh#L19-L20\r\n\r\nFor now, I'm just rebuilding the `gis` db until I figure out what's going on here. Also, if mapnik is using the gis database, I need to restart postgres to drop all the users accexsing it before the rename.\r\n\r\nhttps://github.com/AmericanRedCross/posm-admin/blob/d1d0f7bf4ce68686de328649becccc4a5033cb48/scripts/gis_render-db-pbf2render.sh#L32\r\n\r\ncc/ @mojodna "}}