{"action":"created","issue":{"url":"https://api.github.com/repos/alphagov/cf-terraform/issues/40","labels_url":"https://api.github.com/repos/alphagov/cf-terraform/issues/40/labels{/name}","comments_url":"https://api.github.com/repos/alphagov/cf-terraform/issues/40/comments","events_url":"https://api.github.com/repos/alphagov/cf-terraform/issues/40/events","html_url":"https://github.com/alphagov/cf-terraform/pull/40","id":110055169,"number":40,"title":"[#104897322] Use BOSH deployed postgres instead of RDS on AWS","user":{"login":"keymon","id":280032,"avatar_url":"https://avatars.githubusercontent.com/u/280032?v=3","gravatar_id":"","url":"https://api.github.com/users/keymon","html_url":"https://github.com/keymon","followers_url":"https://api.github.com/users/keymon/followers","following_url":"https://api.github.com/users/keymon/following{/other_user}","gists_url":"https://api.github.com/users/keymon/gists{/gist_id}","starred_url":"https://api.github.com/users/keymon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/keymon/subscriptions","organizations_url":"https://api.github.com/users/keymon/orgs","repos_url":"https://api.github.com/users/keymon/repos","events_url":"https://api.github.com/users/keymon/events{/privacy}","received_events_url":"https://api.github.com/users/keymon/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"dcarley","id":260438,"avatar_url":"https://avatars.githubusercontent.com/u/260438?v=3","gravatar_id":"","url":"https://api.github.com/users/dcarley","html_url":"https://github.com/dcarley","followers_url":"https://api.github.com/users/dcarley/followers","following_url":"https://api.github.com/users/dcarley/following{/other_user}","gists_url":"https://api.github.com/users/dcarley/gists{/gist_id}","starred_url":"https://api.github.com/users/dcarley/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dcarley/subscriptions","organizations_url":"https://api.github.com/users/dcarley/orgs","repos_url":"https://api.github.com/users/dcarley/repos","events_url":"https://api.github.com/users/dcarley/events{/privacy}","received_events_url":"https://api.github.com/users/dcarley/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2015-10-06T17:09:44Z","updated_at":"2015-10-08T13:24:58Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/alphagov/cf-terraform/pulls/40","html_url":"https://github.com/alphagov/cf-terraform/pull/40","diff_url":"https://github.com/alphagov/cf-terraform/pull/40.diff","patch_url":"https://github.com/alphagov/cf-terraform/pull/40.patch"},"body":"Related: [#104897322 Use postgres instead of using RDS for BOSH database in AWS](https://www.pivotaltracker.com/story/show/104897322)\r\n\r\n# What\r\n\r\nOn AWS we currently use RDS for the UAA and Cloudcountroller in CF instead of a VM deployed by BOSH, which is slower to deploy and is more expensive (doesn't shut down with the rest of the environment).\r\n\r\nWe want to change this to use the same structure as in AWS and GCE\r\n\r\n## Scope \r\n\r\nWe want to: \r\n\r\n * Stop using RDS but a VM running postgres for CCDB and UAADB,\r\nin the same way as we do in GCE.\r\n * make both environments more similar, using the common\r\ndenominator\r\n * Remove the RDS references\r\n\r\n# How to review this?\r\n\r\nIf you already have a running environment on AWS, the fastest option without destroying everything:\r\n \r\n 1. Delete the deployment with `bosh delete deployment cloudfoundry-<env>`\r\n 2. Deploy it again: `bosh deploy`\r\n 3. Apply terraform to delete the RDS references: `make apply-aws DEPLOY_ENV=...`\r\n 4. Run the tests `make test-aws DEPLOY_ENV=...` (note, you need #39 )\r\n 5. Run again a end-to-end deployment to be sure: `make aws DEPLOY_ENV=....`\r\n\r\nIf you don't have an environment:\r\n\r\n  1. Deploy everything: `make aws DEPLOY_ENV=...`\r\n  2. Run smoke tests:  `make test-aws DEPLOY_ENV=...` (note, you need #39 )\r\n\r\n## who can review this?\r\n\r\nAnyone but @saliceti or @keymon\r\n"},"comment":{"url":"https://api.github.com/repos/alphagov/cf-terraform/issues/comments/146544297","html_url":"https://github.com/alphagov/cf-terraform/pull/40#issuecomment-146544297","issue_url":"https://api.github.com/repos/alphagov/cf-terraform/issues/40","id":146544297,"user":{"login":"keymon","id":280032,"avatar_url":"https://avatars.githubusercontent.com/u/280032?v=3","gravatar_id":"","url":"https://api.github.com/users/keymon","html_url":"https://github.com/keymon","followers_url":"https://api.github.com/users/keymon/followers","following_url":"https://api.github.com/users/keymon/following{/other_user}","gists_url":"https://api.github.com/users/keymon/gists{/gist_id}","starred_url":"https://api.github.com/users/keymon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/keymon/subscriptions","organizations_url":"https://api.github.com/users/keymon/orgs","repos_url":"https://api.github.com/users/keymon/repos","events_url":"https://api.github.com/users/keymon/events{/privacy}","received_events_url":"https://api.github.com/users/keymon/received_events","type":"User","site_admin":false},"created_at":"2015-10-08T13:24:58Z","updated_at":"2015-10-08T13:24:58Z","body":"I got that error a pair of times with the smoke test. They seem related to logs.\r\n\r\nCan you please check if `cf logs any_deployed_app --recent` works? If it does, just rerun the test. "}}