Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.400.131.1.6\))
Subject: Re: Moving from Linux to Linux?
From: Paul Foerster <paul.foerster@gmail.com>
In-Reply-To: <CANzqJaCfAc-5v==VHEEizejAbg3OXfjN25Psz2sHRad_OQeajg@mail.gmail.com>
Date: Wed, 12 Mar 2025 21:16:18 +0100
Cc: Pgsql-General List <pgsql-general@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <843A9EE2-BAA1-4C4B-8DE6-74ECAFB113B4@gmail.com>
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>
To: Ron Johnson <ronljohnsonjr@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/843A9EE2-BAA1-4C4B-8DE6-74ECAFB113B4%40gmail.com>
Precedence: bulk

Hi Ron,

> On 12 Mar 2025, at 17:59, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
>=20
> 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.

Cheers,
Paul=