MIME-Version: 1.0
References: <61c36bcd640f421eae98cfdee06214ce@bcv.ch>
 <ZsPynKPjCbZpdXpw@momjian.us>
In-Reply-To: <ZsPynKPjCbZpdXpw@momjian.us>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Mon, 19 Aug 2024 22:45:46 -0400
Message-ID: 
 <CANzqJaD=PhYv+QnZ=C4H3mYdpi8R1Bz71416y2b7EajwJ_9R=A@mail.gmail.com>
Subject: Re: Containerizing PostgreSQL
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d0a1e80620146cf9"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaD%3DPhYv%2BQnZ%3DC4H3mYdpi8R1Bz71416y2b7EajwJ_9R%3DA%40mail.gmail.com>
Precedence: bulk

--000000000000d0a1e80620146cf9
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Aug 19, 2024 at 9:34=E2=80=AFPM Bruce Momjian <bruce@momjian.us> wr=
ote:

> On Mon, Jul 22, 2024 at 06:01:46AM +0000, Cainzos Yvan wrote:
> > Dear All,
> >
> >
> >
> > What is your experience with containerizing PostgreSQL, particularly on
> > OpenShift?
> >
> > I am looking to identify the advantages and disadvantages of this type =
of
> > architecture, mainly from an operational standpoint.
> >
> > I am interested in preferred use cases and those to be avoided.
> >
> > Thank you for sharing your experience.
>
> This presentation might be helpful, and its videos:
>
>         https://momjian.us/main/presentations/administration.html#cloud
>
>
https://www.youtube.com/watch?v=3DwKJBpcoRAsc#t=3D1h26m46s

The important bits start here, I think.

Distilled:
1. Do you have an existing VM infrastructure, like VMware?
2a. Do you *frequently* create new PG instances?
2b. Do you have *hundreds* of PG instances?

For me, the answers are "yes" and "no,no".

I've got a "design document" and common config files in a shared
directory.  Need a new PG server?  I give a standard list of mount points
and port numbers to the VM build team, and they come back with a server
that has RHEL installed, and ports open.  "yum install" a set of RPMs from
PGDG.  Five minutes later, I sudo to postgres, cp config file templates and
run some sed commands.  Up comes PG!

Patching happens every three months; yum and bash scripts which I've
developed over time make that pretty darned fast and painless.

Thus, PG containers are of no use *to us*.  Lots of application containers,
but that's outside my domain.

--=20
Death to America, and butter sauce.
Iraq lobster!

--000000000000d0a1e80620146cf9
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, Aug 19, 2024 at 9:34=E2=80=AFPM B=
ruce Momjian &lt;<a href=3D"mailto:bruce@momjian.us">bruce@momjian.us</a>&g=
t; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D"gmail_qu=
ote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,20=
4);padding-left:1ex">On Mon, Jul 22, 2024 at 06:01:46AM +0000, Cainzos Yvan=
 wrote:<br>
&gt; Dear All,<br>
&gt; <br>
&gt;=C2=A0 <br>
&gt; <br>
&gt; What is your experience with containerizing PostgreSQL, particularly o=
n<br>
&gt; OpenShift?<br>
&gt; <br>
&gt; I am looking to identify the advantages and disadvantages of this type=
 of<br>
&gt; architecture, mainly from an operational standpoint.<br>
&gt; <br>
&gt; I am interested in preferred use cases and those to be avoided.<br>
&gt; <br>
&gt; Thank you for sharing your experience.<br>
<br>
This presentation might be helpful, and its videos:<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 <a href=3D"https://momjian.us/main/presentation=
s/administration.html#cloud" rel=3D"noreferrer" target=3D"_blank">https://m=
omjian.us/main/presentations/administration.html#cloud</a><br>
<br></blockquote><div><br></div><div><a href=3D"https://www.youtube.com/wat=
ch?v=3DwKJBpcoRAsc#t=3D1h26m46s">https://www.youtube.com/watch?v=3DwKJBpcoR=
Asc#t=3D1h26m46s</a><br></div><div><br></div><div>The important bits start =
here, I think.</div><div><br></div><div>Distilled:</div><div>1. Do you have=
 an existing VM infrastructure, like VMware?</div><div>2a. Do you <i>freque=
ntly</i> create new PG instances?</div><div>2b. Do you have <i>hundreds</i>=
=C2=A0of PG instances?</div><div><br></div><div>For me, the answers are &qu=
ot;yes&quot; and &quot;no,no&quot;.</div></div><div><br></div><div>I&#39;ve=
 got a &quot;design document&quot; and common config files in a shared dire=
ctory.=C2=A0 Need a new PG server?=C2=A0 I give a standard list of mount po=
ints and port numbers to the VM build team, and they come back with a serve=
r that has RHEL installed, and ports open.=C2=A0 &quot;yum install&quot; a =
set of RPMs from PGDG.=C2=A0 Five minutes later, I sudo to postgres, cp con=
fig file templates and run some sed commands.=C2=A0 Up comes PG!</div><div>=
<br></div><div>Patching happens every three months; yum and bash scripts wh=
ich I&#39;ve developed over time make that pretty darned fast and painless.=
</div><div><br></div><div>Thus, PG containers are of no use <b>to us</b>.=
=C2=A0 Lots of application containers, but that&#39;s outside my domain.</d=
iv><div><br></div><span class=3D"gmail_signature_prefix">-- </span><br><div=
 dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to America, a=
nd butter sauce.<div>Iraq lobster!</div></div></div></div>

--000000000000d0a1e80620146cf9--