Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] Risks of running Postgres as a Docker container? - Mailing list pgsql-admin

From Gustav Karlsson
Subject Re: [ADMIN] Risks of running Postgres as a Docker container?
Date
Msg-id AM0PR0402MB33806940CC6D830354AFC4CDEB7A0@AM0PR0402MB3380.eurprd04.prod.outlook.com
Whole thread Raw
In response to Re: [ADMIN] Risks of running Postgres as a Docker container?  (Manuel Gómez <targen@gmail.com>)
List pgsql-admin
Tree view

Thank you all for the feedback! It seems my concerns may be a bit out-dated 😊


Manuel, I have been looking quite a bit at Patroni, and will quite possibly be using that in our setup. Thank you for sharing it with the community! (and ofc also a thank you to Compose for Governor)


Regards,

Gustav

Fra: Manuel Gómez <targen@gmail.com>
Sendt: 25. september 2017 13:37:46
Til: Gustav Karlsson; pgsql-admin@postgresql.org
Emne: Re: [ADMIN] Risks of running Postgres as a Docker container?
 
On Mon, Sep 25, 2017 at 7:09 AM Gustav Karlsson <gustav.karlsson@bekk.no> 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.)

pgsql-admin by date:

Previous
From: Manuel Gómez
Date:
Subject: Re: [ADMIN] Risks of running Postgres as a Docker container?
Next
From: Tom Lane
Date:
Subject: Re: [ADMIN] Risks of running Postgres as a Docker container?