{"action":"created","issue":{"url":"https://api.github.com/repos/odoo/odoo/issues/12275","repository_url":"https://api.github.com/repos/odoo/odoo","labels_url":"https://api.github.com/repos/odoo/odoo/issues/12275/labels{/name}","comments_url":"https://api.github.com/repos/odoo/odoo/issues/12275/comments","events_url":"https://api.github.com/repos/odoo/odoo/issues/12275/events","html_url":"https://github.com/odoo/odoo/issues/12275","id":158180013,"number":12275,"title":"Unable to create DB backup within docker container","user":{"login":"Petrievn","id":10955716,"avatar_url":"https://avatars.githubusercontent.com/u/10955716?v=3","gravatar_id":"","url":"https://api.github.com/users/Petrievn","html_url":"https://github.com/Petrievn","followers_url":"https://api.github.com/users/Petrievn/followers","following_url":"https://api.github.com/users/Petrievn/following{/other_user}","gists_url":"https://api.github.com/users/Petrievn/gists{/gist_id}","starred_url":"https://api.github.com/users/Petrievn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Petrievn/subscriptions","organizations_url":"https://api.github.com/users/Petrievn/orgs","repos_url":"https://api.github.com/users/Petrievn/repos","events_url":"https://api.github.com/users/Petrievn/events{/privacy}","received_events_url":"https://api.github.com/users/Petrievn/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":12,"created_at":"2016-06-02T16:09:54Z","updated_at":"2016-06-06T17:09:42Z","closed_at":"2016-06-05T14:42:08Z","body":"Impacted versions:\r\n9.0\r\n\r\nSteps to reproduce:\r\n\r\n- Install docker container (default installation)\r\n- Try to make a backup\r\n\r\nCurrent behavior:\r\n\r\nGives error: \r\n\r\n```\r\nDatabase backup error: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmpijZcLi/dump.sql', u'planetfeeds_db') error 1\r\n```\r\n\r\nExpected behavior:\r\n\r\nMust succeed\r\n\r\nVideo/Screenshot link (optional):\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/odoo/odoo/issues/comments/224023063","html_url":"https://github.com/odoo/odoo/issues/12275#issuecomment-224023063","issue_url":"https://api.github.com/repos/odoo/odoo/issues/12275","id":224023063,"user":{"login":"kanderson450","id":7154425,"avatar_url":"https://avatars.githubusercontent.com/u/7154425?v=3","gravatar_id":"","url":"https://api.github.com/users/kanderson450","html_url":"https://github.com/kanderson450","followers_url":"https://api.github.com/users/kanderson450/followers","following_url":"https://api.github.com/users/kanderson450/following{/other_user}","gists_url":"https://api.github.com/users/kanderson450/gists{/gist_id}","starred_url":"https://api.github.com/users/kanderson450/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kanderson450/subscriptions","organizations_url":"https://api.github.com/users/kanderson450/orgs","repos_url":"https://api.github.com/users/kanderson450/repos","events_url":"https://api.github.com/users/kanderson450/events{/privacy}","received_events_url":"https://api.github.com/users/kanderson450/received_events","type":"User","site_admin":false},"created_at":"2016-06-06T17:09:42Z","updated_at":"2016-06-06T17:09:42Z","body":"## Problem\r\nThis most definitely isn't \"_User Error_\".  The Odoo Docker image instructions are broken since they completely ignore this postgres version incompatbility.\r\n\r\nThe instructions tell users to start up a postgres database:\r\n\r\n`$ docker run -d -e POSTGRES_USER=odoo -e POSTGRES_PASSWORD=odoo --name db postgres`\r\n\r\nSince this line omits the version tag, it defaults to latest which points to version [9.5](https://hub.docker.com/_/postgres/)\r\n\r\nThis version is incompatible with the Odoo Docker image since it points to the debian build which includes version [9.4](https://github.com/odoo/odoo/blob/9.0/debian/control#L19).  You may be fooled initially that things are okay since the Odoo server starts up.  But when you need to backup the database, you're in for a rude awakening.\r\n\r\nThere are a few different ways to mitigate this issue\r\n\r\n## Solutions\r\n\r\n- Change the Odoo Docker image instructions to indicate that you need to use **postgres:9.4** since the postgres client bundled with the debian build is also version 9.4\r\n \r\n- Update the Odoo Docker image to include postgres 9.5 so that it will work with the existing instructions out of the box.\r\n \r\n- Update the Odoo debian build to include postgres 9.5 so that it will work with the existing instructions out of the box.\r\n\r\n## Related\r\n\r\nGitHub issues about this problem has been opened on this repo and the Odoo Docker repo without resolution:\r\n\r\n[49: Database backup](https://github.com/odoo/docker/issues/49)\r\n[54: missing pg_dump tool](https://github.com/odoo/docker/issues/54)\r\n[59: Database backup error](https://github.com/odoo/docker/issues/59)\r\n\r\nWe can debate where this issue should live but make no mistake, this isn't User Error and needs to be addressed by Odoo officially."}}
{"actor":{"display_login":"kanderson450"}}