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 1rfe99-001M6L-Oq for pgsql-general@arkaria.postgresql.org; Thu, 29 Feb 2024 11:00:16 +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 1rfe97-002slz-9S for pgsql-general@arkaria.postgresql.org; Thu, 29 Feb 2024 11:00:13 +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 1rfe96-002slr-Lp for pgsql-general@lists.postgresql.org; Thu, 29 Feb 2024 11:00:13 +0000 Received: from sonic320-52.consmr.mail.bf2.yahoo.com ([74.6.128.233]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rfe90-00275F-UA for pgsql-general@lists.postgresql.org; Thu, 29 Feb 2024 11:00:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1709204404; bh=GvphzuyhPfaEJ3Yd0ZRZ/3Z/HgZndqEId5UVmQyQBvQ=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=BVcOgbmTfZJz3ZU1ZPxPFAbDS/kNmU01ZLc1p6cMkIdcWq2v4BC2KOUXpOn7D0pDqJrpK1XvrqZBdkXkF+eqMEJx+fJ7F06KTmgK5slwVhmVnKv8JHfXEyIZdGTUeCW1HxcbeEhjUyjHCRgGiaNBCwQb3LjW//MzYPjaDf+x3JKCTKDh5uXX68cVZZAvdovfvDcOhXFfadz26N+/vVoKDd61KvOq96F02loBzE9hqEYAz2SUtd9Oe03RNT228msOrjPanLw4yexjMQyoyY4Dr/oGnurbswZt1FSPyuT6ATE09o71oY6bn+TecPoonjby/n+4esbsLtmgipFXIZn7Gw== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1709204404; bh=nf9Uq+vWxvYYwjuje9cXzYMlAkDVyZBIXqgxVQltLoz=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=iOAS6CgRSgSK7F3EOPqowTr9XYxdP6+9C7qxg+OkmPK3dyTIcWJW0kOPUlVARVtcudcwb2l5tx3h+Cyw2SV5ZYJiDYecoX31NPBUQehVRd7010VG660C72Pi5Jpa2IoATwHF72lxSbmxqUKqZ05JEnfFCmSXhY+JCobCW+z/ANVQ4IkE7eiLBrZKm3VavFcp3vW0NdB0LeItMPihj/MXxyBL6ljGdv5FEXlZ/0lhjhZvGOA0Ud8NuFUfwLKXxfCTCVqdJrk8dbtm7XVQ7nRyKmcgzOa3Xbr6BMem414OpbInKIzyjinEUD8+J6b9cxZvspwR7ZQqg+pXrqC3a5Vf2Q== X-YMail-OSG: mccODh0VM1mfmhmLpT2_KWrlUHOFYqBe2772emVIgnTBRcmUWtc8T_LT6T97weQ If3vAFLQr6gdbaOHawy5JEF5QdOrqqYljojlAJCSTmv9OzIjdyZlINxSqTCAOo.odlc1s0RDIP46 akZJs7BfKr2rADjUCkVcnxr7ZI.U36gm6b0oe4RoiQxDJBDl_VnntMX3ihdw25hoSDz8Ka1m5Oy2 1q4sBJDGK5HWFied5zHTtSaksu7xhvwYCk3Hwd3LDBIdcH5h7bZS6Lkh2NJjsyqGIUxQU6rBhyWz Bo4aKF6vV..nUYmJG0K928VlD7vttyFTICWfW96qS7Kodn7XecVVD86dCQo5wG4fZru0sk.gw.o9 rd_aoVDmVGwQVGQpVis1lA2irMGTDVPBK0h7mKKwfRowfVQ6i6RJBstfsnjElOOCftwjkIXIyMoL 9EWRc7sIpmONDnQ4FtfVIEy11y60lDGKFmr1zRZwctaqtHwvuHYP0uSVJznXLl6NqW1wJxTkDXGq _lLRY28DRk6Fdczxddom_J_.u3vXGn67klYd5sZSccUc6pna6hxbuX8qr0PYwkbZjYWA7K0Kl2rf 1GkLwcDgPEteSN.Cb5WphrRobUyOWm6h07gvovmOn68ZgU.DcMxUa5VhFYi4YzHLDUvOiJBPlkK_ qNZnH0JO5xuMO6AQ878sHe96XOvcVJ6BKS_Q3vQT6iYFYTqpR5o6jWom6TQ.T.EuBLND1iXk4FjD vbAEvSRefI9l1gvpCpGX7kmuJS654_APgr_OOqKg3NwjcPlaZ8mB5oLngfTBG3su0tNzPGZit_ij 7_A8RQnhc6XgsxvsDNwBGQRz7S8BdVZD0p87bWg.A69mCTuHmh1z.LxAkQJV_DYELtrqxWWy.n58 tDvuOMfP1PC.mns9PAhr3lSmvdLm_61VsC10kOGemYeqLG.Q0Ln3LmidqQjmKZYP2EcDaG3mfwQQ jz0gWOquoxG0Ba7N2IVnWmwQ7Ic50OHeKhVsLBvj7Pk1hvzCYEdR8SUQxLJ8jjLZDHgkqU9_XDGr 2Dydc.a6A.gq22UjBHCT0N5lbvUvTABiVetiq4cGHS7UvZULUemIuOx8i95thlvbKgriIYKf3Eob UQLr_2NMn0oQdxrQj.9nO.IkhD8MmLtsu_PKEkb.vVnpODN6DzNesWvW_iQsnLEs7TFEl6YB9O5o 2jeE76XW0ZVZ6w_nNws6yKGDqNrgueZh_8Neg3VmSPSqK4NL3HYiOOjErY9S5PvFCbyPuLy_ypbS yayaDVxEzHKaQXDCqF0G6IuyMBl8Kaou59tc8EykwTPfCbqLHSRyN4qFYqLekAK2ZBocs.5e7ze6 2p_D2x.haoibB2rn9PVEHEwPTVJiD_YZkcwYjxZxD_Nc_1sDOad4.Z7xjR3V2OEiu8nA82todZnQ JWZP9DyPjiDbXplOCqSEOqF.v8Qxr4O8FXsuJZokSTdyevDRoBTFmq0XqD6._XRmVsRQSJ_FDD0n LsRCm_5k99qIvXofNEMa3eqcKzY5VnghlDr_2F6Q3Y.1tVjQOw_PJX920fa9j3qWAIj.cCHnK_sO ho86kkUtpEXckkFvvrTTOtyPCuYtvRXNfeNEmLOyXtwmYKp8x_HuzjJRuwnSqfvHznreHXUx7VVE 1uO1P0R4SHH2aioNob_0rh7pKVEfMdD6Ijm3z6BP0KoNKTzlEfdAe1mcrl31ARIIyTHP_GVrDo1v p7fpImE.1uVWJYy_urX4y56RauzQkkKVMyzR0.ndCBJhgnQsgPlQ5egojhZF.UahUO88NhLDXSLa tHTjzJiOvRVi6vqIuXOM1gqU1zXq_nmrysJH5t4167DxiDuQMiXKRpn2ra_.I4IN1TxDYlVL2MFx 5vLsDIepT.x57yv6HA2HiMFTQ3AVtFskp6m_kZz45BxkKw6jQ29GzS8ijJ0hc7aCy5Mirdv4u8fO .lZDDvEFxKUocdkJ7yeIJ0Nj.N4dP__ECcG5szHtV5x8Pdh1u_BJ223CzkJjEc1vZIBePqercxHD ipIF53n.Oti6yP6NtVdtN5jzR4lEcZEV8QGzUakx.63em_LKw1LtQwBmtDu1IFnFS2yUfeJtyWid K9_EHqxK9k3VwpppWV89flc_GLr5T0q5Zh8hjpywPglkMuQ_SJcg2SEU4VnDiCKEkKws5KscxvHB ePHseO.XQqHb9UkaY7czQIy8GtE85cBdIuN9rl1ojOb6MsSpW45mPTsl97Uf0RjiBThkAph7Ej63 nQwXJDCqcC80aTCe7NXNiLffMxMgwqvT5Zp0k5lALBmDgo4xNEnLDTVgNDCSObxlPBq0e93eV28B EXdA7ZMSUcbxvG7XBCxdGY1r7waZhHcYd57E.hr62Md8OIvSsfnuKzaNvAKUBa8dU0gCWV.8yfJr t.fmpKzgfx7f6zviMVF8AoM4- X-Sonic-MF: X-Sonic-ID: a2c10b66-c417-4fa8-9b12-f0557f0bcb63 Received: from sonic.gate.mail.ne1.yahoo.com by sonic320.consmr.mail.bf2.yahoo.com with HTTP; Thu, 29 Feb 2024 11:00:04 +0000 Date: Thu, 29 Feb 2024 10:57:59 +0000 (UTC) From: Jason Long Reply-To: Jason Long To: normandavis1990@proton.me, "pgsql-general@lists.postgresql.org" Message-ID: <1272053772.1292318.1709204279661@mail.yahoo.com> In-Reply-To: References: Subject: Re: Moving PostgreSQL servers to a new server MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1292317_696495483.1709204279660" X-Mailer: WebService/1.1.22103 YahooMailAndroidMobile Content-Length: 4170 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_1292317_696495483.1709204279660 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hello,I have the same question. I hope someone can answer this question cle= arly.=20 =20 On Wed, Feb 28, 2024 at 10:04 PM, normandavis1990 wrote: Hi,I am new to PostgreSQL.=C2=A0My scenario is as follows: https://cdn.bloghunch.com/uploads/uNxNoi5uVKeDibd5.webp I have a Master server and two Replica (Replica-1 and Replica-2) servers.= =C2=A0One of these Replica servers is in read-only mode and a report is pre= pared from it using Microsoft PowerBI.=C2=A0Due to a series of issues, I wa= nt to transfer the Master server and one of the Replica servers to other se= rvers in two steps, but I don't want to have any interruptions. A) Assuming PostgreSQL is installed on the new server, what should I do fir= st to migrate the Master?=C2=A0Please show me a tutorial and share your exp= eriences. B) After transferring the Master, I want to transfer one of the Replica ser= vers. =C2=A0What should I do to transfer this server? Cheers. =20 ------=_Part_1292317_696495483.1709204279660 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hello,
I have the same question. I hope someone can answer this question = clearly.

On Wed, Feb 28, 2= 024 at 10:04 PM, normandavis1990
<normandavis1990@proton.me>= ; wrote:
Hi,
I am new to PostgreSQL. My scen= ario is as follows:


I have a Master server and two Replica (Replica-1 and Re= plica-2) servers. One of these Replica servers is in read-only m= ode and a report is prepared from it using Microsoft PowerBI. Du= e to a series of issues, I want to transfer the Master server and one of th= e Replica servers to other servers in two steps, but I don't want to have a= ny interruptions.
A) Assuming PostgreSQL is installed o= n the new server, what should I do first to migrate the Master? = Please show me a tutorial and share your experiences.<= /span>

B) After transferri= ng the Master, I want to transfer one of the Replica servers.  What sh= ould I do to transfer this server?
=
Cheers.
------=_Part_1292317_696495483.1709204279660--