MIME-Version: 1.0
References: <6E6059F6-E5A1-4A8D-8A5E-A41B921BBE67@gmail.com>
 <E0EC05FB-783D-4A24-81B9-0C345A5EC45A@gmail.com> <CANzqJaCj4uf-7_ErTP9eHn_rxomRHMDbKAm7M15eAWiRbxZgmA@mail.gmail.com>
 <1DA96F05-D9BF-4D68-80D3-3F3F99691C8D@gmail.com> <7FC835F0-FE59-45B3-8866-83E8549191D7@thebuild.com>
 <B78EC89A-032D-40DB-88AE-C213CEA20FDE@gmail.com> <CANzqJaCfAc-5v==VHEEizejAbg3OXfjN25Psz2sHRad_OQeajg@mail.gmail.com>
 <843A9EE2-BAA1-4C4B-8DE6-74ECAFB113B4@gmail.com>
In-Reply-To: <843A9EE2-BAA1-4C4B-8DE6-74ECAFB113B4@gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Wed, 12 Mar 2025 16:50:25 -0400
Message-ID: <CANzqJaAK7yTv0=DVAjMGwqZBhhEogLL=h=t=qudeAgqPXoNLgg@mail.gmail.com>
Subject: Re: Moving from Linux to Linux?
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000095845806302b5be7"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaAK7yTv0%3DDVAjMGwqZBhhEogLL%3Dh%3Dt%3DqudeAgqPXoNLgg%40mail.gmail.com>
Precedence: bulk

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

On Wed, Mar 12, 2025 at 4:16=E2=80=AFPM Paul Foerster <paul.foerster@gmail.=
com>
wrote:

> Hi Ron,
>
> > On 12 Mar 2025, at 17:59, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
> >
> > Developers making DDL changes on production databases?
>
> Of course not. But I can't block developer databases. That'd make a few
> hundred developers happy.
>
> > Or are there prod and dev databases on the same instance?  If so, then
> know that you don't have to logically replicate the whole instance.
>
> Also of course not. There is development, pre-production and production.
>
> Outages on development databases make a few hundred developers happy,
> while outages of production databases are appreciated by up to almost 40K
> users, depending on the application.
>
> Anyway, this is our concern. In our environment, logical replication is
> impossible for development databases, hard for pre-production because of
> automatic deployments and only possible on production databases.
>
> Anyway, this is going off-topic now.
>

No, I think it's 100% on point: logically replicate the Prod databases,
while pg_dump/pg_restore of the dev and pre-prod databases happen on
weekends.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Mar 12, 2025 at 4:16=E2=80=AFPM P=
aul Foerster &lt;<a href=3D"mailto:paul.foerster@gmail.com">paul.foerster@g=
mail.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_containe=
r"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bord=
er-left:1px solid rgb(204,204,204);padding-left:1ex">Hi Ron,<br>
<br>
&gt; On 12 Mar 2025, at 17:59, Ron Johnson &lt;<a href=3D"mailto:ronljohnso=
njr@gmail.com" target=3D"_blank">ronljohnsonjr@gmail.com</a>&gt; wrote:<br>
&gt; <br>
&gt; Developers making DDL changes on production databases?<br>
<br>
Of course not. But I can&#39;t block developer databases. That&#39;d make a=
 few hundred developers happy.<br>
<br>
&gt; Or are there prod and dev databases on the same instance?=C2=A0 If so,=
 then know that you don&#39;t have to logically replicate the whole instanc=
e.<br>
<br>
Also of course not. There is development, pre-production and production.<br=
>
<br>
Outages on development databases make a few hundred developers happy, while=
 outages of production databases are appreciated by up to almost 40K users,=
 depending on the application.<br>
<br>
Anyway, this is our concern. In our environment, logical replication is imp=
ossible for development databases, hard for pre-production because of autom=
atic deployments and only possible on production databases.<br>
<br>
Anyway, this is going off-topic now.<br></blockquote><div><br></div><div>No=
, I think it&#39;s 100% on point: logically replicate the Prod databases, w=
hile pg_dump/pg_restore of the dev and pre-prod databases happen on weekend=
s.</div><div><br></div></div><span class=3D"gmail_signature_prefix">-- </sp=
an><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to=
 &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still a=
live.<br><div><div>&lt;Redacted&gt; lobster!</div></div></div></div></div><=
/div>

--00000000000095845806302b5be7--