{"action":"created","issue":{"url":"https://api.github.com/repos/deis/postgres/issues/24","repository_url":"https://api.github.com/repos/deis/postgres","labels_url":"https://api.github.com/repos/deis/postgres/issues/24/labels{/name}","comments_url":"https://api.github.com/repos/deis/postgres/issues/24/comments","events_url":"https://api.github.com/repos/deis/postgres/issues/24/events","html_url":"https://github.com/deis/postgres/pull/24","id":126044533,"number":24,"title":"[WIP] feat(postgres): install wal-e for continuous backups","user":{"login":"bacongobbler","id":1360539,"avatar_url":"https://avatars.githubusercontent.com/u/1360539?v=3","gravatar_id":"","url":"https://api.github.com/users/bacongobbler","html_url":"https://github.com/bacongobbler","followers_url":"https://api.github.com/users/bacongobbler/followers","following_url":"https://api.github.com/users/bacongobbler/following{/other_user}","gists_url":"https://api.github.com/users/bacongobbler/gists{/gist_id}","starred_url":"https://api.github.com/users/bacongobbler/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bacongobbler/subscriptions","organizations_url":"https://api.github.com/users/bacongobbler/orgs","repos_url":"https://api.github.com/users/bacongobbler/repos","events_url":"https://api.github.com/users/bacongobbler/events{/privacy}","received_events_url":"https://api.github.com/users/bacongobbler/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/deis/postgres/labels/awaiting%20review","name":"awaiting review","color":"e11d21"},{"url":"https://api.github.com/repos/deis/postgres/labels/LGTM1","name":"LGTM1","color":"009800"},{"url":"https://api.github.com/repos/deis/postgres/labels/needs%20manual%20testing","name":"needs manual testing","color":"fbca04"}],"state":"open","locked":false,"assignee":{"login":"bacongobbler","id":1360539,"avatar_url":"https://avatars.githubusercontent.com/u/1360539?v=3","gravatar_id":"","url":"https://api.github.com/users/bacongobbler","html_url":"https://github.com/bacongobbler","followers_url":"https://api.github.com/users/bacongobbler/followers","following_url":"https://api.github.com/users/bacongobbler/following{/other_user}","gists_url":"https://api.github.com/users/bacongobbler/gists{/gist_id}","starred_url":"https://api.github.com/users/bacongobbler/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bacongobbler/subscriptions","organizations_url":"https://api.github.com/users/bacongobbler/orgs","repos_url":"https://api.github.com/users/bacongobbler/repos","events_url":"https://api.github.com/users/bacongobbler/events{/privacy}","received_events_url":"https://api.github.com/users/bacongobbler/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/deis/postgres/milestones/2","html_url":"https://github.com/deis/postgres/milestones/v2.0-beta1","labels_url":"https://api.github.com/repos/deis/postgres/milestones/2/labels","id":1467092,"number":2,"title":"v2.0-beta1","description":"","creator":{"login":"slack","id":28873,"avatar_url":"https://avatars.githubusercontent.com/u/28873?v=3","gravatar_id":"","url":"https://api.github.com/users/slack","html_url":"https://github.com/slack","followers_url":"https://api.github.com/users/slack/followers","following_url":"https://api.github.com/users/slack/following{/other_user}","gists_url":"https://api.github.com/users/slack/gists{/gist_id}","starred_url":"https://api.github.com/users/slack/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/slack/subscriptions","organizations_url":"https://api.github.com/users/slack/orgs","repos_url":"https://api.github.com/users/slack/repos","events_url":"https://api.github.com/users/slack/events{/privacy}","received_events_url":"https://api.github.com/users/slack/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":7,"state":"open","created_at":"2015-12-18T17:56:59Z","updated_at":"2016-02-22T19:38:25Z","due_on":null,"closed_at":null},"comments":7,"created_at":"2016-01-11T21:49:10Z","updated_at":"2016-02-22T20:21:43Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/deis/postgres/pulls/24","html_url":"https://github.com/deis/postgres/pull/24","diff_url":"https://github.com/deis/postgres/pull/24.diff","patch_url":"https://github.com/deis/postgres/pull/24.patch"},"body":"To test, build the image, modify the deis-database-rc manifest in the deis-dev chart then run it:\r\n\r\n```\r\n$ helm install deis-dev\r\n$ kubectl --namespace=deis get po\r\n$ kubectl --namespace=deis logs -f deis-database-ecqur # ensure database is up\r\n$ kubectl --namespace=deis exec -it deis-database-ecqur gosu postgres psql\r\npostgres=# create database foo;\r\npostgres=# \\q\r\n$ kubectl --namespace=deis delete po deis-database-ecqur\r\n```\r\n\r\nAfter that, ensure the new database pod comes back up and has the `foo` database:\r\n\r\n```\r\n$ kubectl --namespace=deis exec -it deis-database-asdqr gosu postgres psql\r\npostgres=# \\l\r\npostgres=# \\l\r\n                                            List of databases\r\n               Name               |  Owner   | Encoding |  Collate   |   Ctype    |   Access privileges   \r\n----------------------------------+----------+----------+------------+------------+-----------------------\r\n eJmZkwZc4CFuzg641lEoxuX8tTrnC9lr | postgres | UTF8     | en_US.utf8 | en_US.utf8 | \r\n postgres                         | postgres | UTF8     | en_US.utf8 | en_US.utf8 | \r\n template0                        | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +\r\n                                  |          |          |            |            | postgres=CTc/postgres\r\n template1                        | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +\r\n                                  |          |          |            |            | postgres=CTc/postgres\r\n foo                              | postgres | UTF8     | en_US.utf8 | en_US.utf8 | \r\n(5 rows)\r\n```"},"comment":{"url":"https://api.github.com/repos/deis/postgres/issues/comments/187367828","html_url":"https://github.com/deis/postgres/pull/24#issuecomment-187367828","issue_url":"https://api.github.com/repos/deis/postgres/issues/24","id":187367828,"user":{"login":"bacongobbler","id":1360539,"avatar_url":"https://avatars.githubusercontent.com/u/1360539?v=3","gravatar_id":"","url":"https://api.github.com/users/bacongobbler","html_url":"https://github.com/bacongobbler","followers_url":"https://api.github.com/users/bacongobbler/followers","following_url":"https://api.github.com/users/bacongobbler/following{/other_user}","gists_url":"https://api.github.com/users/bacongobbler/gists{/gist_id}","starred_url":"https://api.github.com/users/bacongobbler/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bacongobbler/subscriptions","organizations_url":"https://api.github.com/users/bacongobbler/orgs","repos_url":"https://api.github.com/users/bacongobbler/repos","events_url":"https://api.github.com/users/bacongobbler/events{/privacy}","received_events_url":"https://api.github.com/users/bacongobbler/received_events","type":"User","site_admin":false},"created_at":"2016-02-22T20:21:43Z","updated_at":"2016-02-22T20:21:43Z","body":"etcd's no longer a dependency which means half of the network flakiness issues are gone. It's just postgres and minio so we got that going for us, which is nice. :)\r\n\r\nI agree that a better backup/recovery scenario is required for testing. What kind of scenario would you suggest us test?"}}