pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Running postgresql databases in Docker
4+ messages / 3 participants
[nested] [flat]

* Running postgresql databases in Docker
@ 2019-03-21 08:28  M Jane <mskiesewetter@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: M Jane @ 2019-03-21 08:28 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org

Hi everyone,
I am investigating using Docker for our Postgresql databases and I have rad
a lot of oppinions on forums.
The main thing that comes up is how to persist the data, and that it is not
advised to run production with docker.
I would like your advise.
What is your experience with Docker and databases?
What is the best practise to do this?
Your help is much appreciated.
Thanks in advance.
regards,
Marian

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Running postgresql databases in Docker
@ 2019-03-21 15:10  Evan Bauer <evanbauer@mac.com>
  parent: M Jane <mskiesewetter@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Evan Bauer @ 2019-03-21 15:10 UTC (permalink / raw)
  To: M Jane <mskiesewetter@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org

Docker can certainly work, but for any kind of production application don’t keep the storage inside of the containers.  Take a look at the approach Crunchy Data (crunchydata.com) has done in their Kubernetes orchestrator for PostgreSQL clusters as a solid implementation example.  Sarah Conway good a good presentation at PostgresOpn SV last September, it may be online somewhere. 

Cheers,

- Evan

Evan Bauer
eb@evanbauer.com
+1 646 641 2973
Skype: evanbauer


> On Mar 21, 2019, at 04:28, M Jane <mskiesewetter@gmail.com> wrote:
> 
> Hi everyone,
> I am investigating using Docker for our Postgresql databases and I have rad a lot of oppinions on forums.
> The main thing that comes up is how to persist the data, and that it is not advised to run production with docker.
> I would like your advise.
> What is your experience with Docker and databases?
> What is the best practise to do this?
> Your help is much appreciated.
> Thanks in advance.
> regards,
> Marian





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Running postgresql databases in Docker
@ 2019-03-21 15:47  M Jane <mskiesewetter@gmail.com>
  parent: Evan Bauer <evanbauer@mac.com>
  0 siblings, 1 reply; 4+ messages in thread

From: M Jane @ 2019-03-21 15:47 UTC (permalink / raw)
  To: Evan Bauer <evanbauer@mac.com>; +Cc: pgsql-admin@lists.postgresql.org

Hi Evan,

Thanks for the info. I will look into that.
regards,
Marian

Op do 21 mrt. 2019 om 16:10 schreef Evan Bauer <evanbauer@mac.com>:

> Docker can certainly work, but for any kind of production application
> don’t keep the storage inside of the containers.  Take a look at the
> approach Crunchy Data (crunchydata.com) has done in their Kubernetes
> orchestrator for PostgreSQL clusters as a solid implementation example.
> Sarah Conway good a good presentation at PostgresOpn SV last September, it
> may be online somewhere.
>
> Cheers,
>
> - Evan
>
> Evan Bauer
> eb@evanbauer.com
> +1 646 641 2973
> Skype: evanbauer
>
>
> > On Mar 21, 2019, at 04:28, M Jane <mskiesewetter@gmail.com> wrote:
> >
> > Hi everyone,
> > I am investigating using Docker for our Postgresql databases and I have
> rad a lot of oppinions on forums.
> > The main thing that comes up is how to persist the data, and that it is
> not advised to run production with docker.
> > I would like your advise.
> > What is your experience with Docker and databases?
> > What is the best practise to do this?
> > Your help is much appreciated.
> > Thanks in advance.
> > regards,
> > Marian
>
>

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Running postgresql databases in Docker
@ 2019-03-22 08:27  Rafia Sabih <rafia.pghackers@gmail.com>
  parent: M Jane <mskiesewetter@gmail.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Rafia Sabih @ 2019-03-22 08:27 UTC (permalink / raw)
  To: M Jane <mskiesewetter@gmail.com>; +Cc: Evan Bauer <evanbauer@mac.com>; pgsql-admin@lists.postgresql.org

On Thu, 21 Mar 2019 at 16:47, M Jane <mskiesewetter@gmail.com> wrote:
>
> Hi Evan,
>
> Thanks for the info. I will look into that.
> regards,
> Marian
>
Hi Marian,

If you are on that topic, I would like to bring your attention on Zalando's
Postgresql with Kubernetes infrastructure as well. You may have a look
at Zalando
tech blog
<https://jobs.zalando.com/tech/blog/postgresql-in-a-time-of-kubernetes/?gh_src=4n3gxh1;,
you may also find their GitHub repositories for their open sourced tools as
well. Much of their business is based on this infrastructure so I am sure
it is something quite functional and cool.

> Op do 21 mrt. 2019 om 16:10 schreef Evan Bauer <evanbauer@mac.com>:
>>
>> Docker can certainly work, but for any kind of production application
don’t keep the storage inside of the containers.  Take a look at the
approach Crunchy Data (crunchydata.com) has done in their Kubernetes
orchestrator for PostgreSQL clusters as a solid implementation example.
Sarah Conway good a good presentation at PostgresOpn SV last September, it
may be online somewhere.
>>
>> Cheers,
>>
>> - Evan
>>
>> Evan Bauer
>> eb@evanbauer.com
>> +1 646 641 2973
>> Skype: evanbauer
>>
>>
>> > On Mar 21, 2019, at 04:28, M Jane <mskiesewetter@gmail.com> wrote:
>> >
>> > Hi everyone,
>> > I am investigating using Docker for our Postgresql databases and I
have rad a lot of oppinions on forums.
>> > The main thing that comes up is how to persist the data, and that it
is not advised to run production with docker.
>> > I would like your advise.
>> > What is your experience with Docker and databases?
>> > What is the best practise to do this?
>> > Your help is much appreciated.
>> > Thanks in advance.
>> > regards,
>> > Marian
>>


-- 
Regards,
Rafia Sabih

^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2019-03-22 08:27 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-03-21 08:28 Running postgresql databases in Docker M Jane <mskiesewetter@gmail.com>
2019-03-21 15:10 ` Evan Bauer <evanbauer@mac.com>
2019-03-21 15:47   ` M Jane <mskiesewetter@gmail.com>
2019-03-22 08:27     ` Rafia Sabih <rafia.pghackers@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox