Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tsTBF-002KkK-W4 for pgsql-general@arkaria.postgresql.org; Wed, 12 Mar 2025 20:59:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tsTBE-00Dfcx-BF for pgsql-general@arkaria.postgresql.org; Wed, 12 Mar 2025 20:59:56 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tsTBE-00DfY6-0D for pgsql-general@lists.postgresql.org; Wed, 12 Mar 2025 20:59:56 +0000 Received: from mail-wm1-x332.google.com ([2a00:1450:4864:20::332]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tsTBB-002Udt-2p for pgsql-general@postgresql.org; Wed, 12 Mar 2025 20:59:54 +0000 Received: by mail-wm1-x332.google.com with SMTP id 5b1f17b1804b1-4393dc02b78so1332925e9.3 for ; Wed, 12 Mar 2025 13:59:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1741813192; x=1742417992; darn=postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=hwBiVFl+/ly8K8VA/YyLHZzpeYhHQSvqLvILRBJy5+U=; b=aQwbReNnxsiL5bpMwD48VSgJdm+cF98aavShJ0+OnDt7HqdkIOFYCeRZOXfgYOLLc6 8vGq7Pf6b4Z+XIc1gUn1pnQwLfO82gBVjj5doWgcFou3E/CebAc0Em7khFCdkPgSyAa2 u7hTkQ2SH0LRgT0OVtkmBR8Mfi+Cii4l9wSgnFRhNWGT+oRa9vFDtfQDtjXWVMWFFzkU hmItTVWzoXH+u0CQTcwuWM3YpTARnV4mnuTKheQZrdRxMPjPpFXxim38oksdrWzKv9+4 3rz1AUs9vBXVActq/9VsZ/RAVPzA6QUedCBaaHY5Xw0oChf7ayyt+Mdg22CAOeMja8KC RXlg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741813192; x=1742417992; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=hwBiVFl+/ly8K8VA/YyLHZzpeYhHQSvqLvILRBJy5+U=; b=JzFyvaBV0RTI1JDYZ+Ag9SL1X2cONJ5t4Y+Faum7+meTZ9Zq7PtxaagPYjZx5pA6az lCk9hNNUa73ZSkil6UJW01aOE7q9QAr7GnT9yBynCQCP+nrmu1DaVan3PTMuGPuNxBD9 1qEPK8E9gSLUWoQ2nWa2gle2HnSkbYWZivh+k7+Thc/x1O9Scxu4gMFXwWN2mERS1oNi 5IRywDE989T7dptwwmB2YPxiYb+VEW/EyuvCfodZyd9git50q43Z1G/oOy9iS9SZ2gUo 41gC1c/K7w0JnGhbbOC5uQEV7XRrduTwPEf3tWIqYCFq/rTSfCjdgk96Xz4En6QsPQWr LVeg== X-Gm-Message-State: AOJu0YzwqJPDF4ZBrP7RiIae1qr4b0qGh0ZVWIT7I/vAvWM5oBf8BYbE HP3zht1n1wmNV81nCdyUyV3KeNKkju9SR9XDa9kHBJ2rbQlIvKjw X-Gm-Gg: ASbGncu1uVNR+vg4PhtB9EZV++N97xw8zwGa7u+NtkFGlwGUalOk0XiR9XqtlDmpoMQ CK66ToNbXViTf8fghme85sqtH2SHF1dqbtEkFG8uJKNIAszZgV2fxHi8wwatzWPFVCXIRQxdlmM c8rHYpPU3857i/IL+AWMtBf4N9dcPFrR3x1B6THW/vzDp7cxcTQqMLVPyMFC+amqYpzywqqdpbC 9clbrzsvF+n4RlwCeOWmD994JAbcxEtuTpEL4Nv0g/3d48jKco2lZVvWXYX456d+kLffVhP71Lt GWXJ6M3r0hZfOGedj8Nv4F54qcoK1sGCTSFjHWXNdxrRO9jhaEpYyUKfxax1IxsRAIY2IiGbK5d 3dQzUdKZv7+75TC5nmjBMMA== X-Google-Smtp-Source: AGHT+IGXi1oIbvx/BmnDQiSVSAp+sOFWJgmMCocNqoGldBaXsFc4BFfPNojj1q9n94DI0sNppQi7pw== X-Received: by 2002:a05:6000:178b:b0:391:122c:8ac with SMTP id ffacd0b85a97d-392641bd253mr9809179f8f.21.1741813191617; Wed, 12 Mar 2025 13:59:51 -0700 (PDT) Received: from smtpclient.apple (143-45-239-77.dyn.cable.qlnet.ch. [77.239.45.143]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-3912c103aa5sm22387160f8f.94.2025.03.12.13.59.50 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 12 Mar 2025 13:59:51 -0700 (PDT) Content-Type: text/plain; charset=utf-8 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 In-Reply-To: Date: Wed, 12 Mar 2025 21:59:20 +0100 Cc: pgsql-general Content-Transfer-Encoding: quoted-printable Message-Id: References: <6E6059F6-E5A1-4A8D-8A5E-A41B921BBE67@gmail.com> <1DA96F05-D9BF-4D68-80D3-3F3F99691C8D@gmail.com> <7FC835F0-FE59-45B3-8866-83E8549191D7@thebuild.com> <843A9EE2-BAA1-4C4B-8DE6-74ECAFB113B4@gmail.com> To: Ron Johnson X-Mailer: Apple Mail (2.3826.400.131.1.6) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Ron, > On 12 Mar 2025, at 21:50, Ron Johnson wrote: >=20 > 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. Yes, I live for and in the company. =F0=9F=A4=A3 SNCR. No, seriously, I'm one of only two PostgreSQL DBAs and our working = capacity is limited by biological and other factors. Next tob working a = normal day, capacities to to frequent things like these are limited. Cheers, Paul=