On Mon, Sep 25, 2017 at 7:09 AM Gustav Karlsson <gustav.karlsson@xxxxxxx> wrote:
- Anybody running production databases in Docker? Have you experienced many issues?
- What are the risks of doing it? (We would of course mount an external volume for the data-directory)
Rather than particular risks, there is some work you may have to do to enjoy all the benefits of deploying Postgres in Docker, specifically regarding deploying images with the appropriate configuration for automated backups and automated/assisted distributed cluster management, which you generally want for production.
There's a lot of experience with these problems collected in some open-source projects, though! You may be interested in Spilo https://github.com/zalando/spilo and Patroni https://github.com/zalando/patroni — and keep an eye out for Kubernetes-native support currently being tested in Patroni: https://github.com/zalando/patroni/pull/500
Note there are some relevant talk videos listed here: https://github.com/zalando/patroni#how-patroni-works
(Full disclosure: I work in the team that develops and provides support for internal use of these projects at Zalando.)