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 1tIGjH-00DKDw-NI for pgsql-general@arkaria.postgresql.org; Tue, 03 Dec 2024 00:25:27 +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 1tIGjE-005DQF-NI for pgsql-general@arkaria.postgresql.org; Tue, 03 Dec 2024 00:25:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tIGjE-005DQ6-9k for pgsql-general@lists.postgresql.org; Tue, 03 Dec 2024 00:25:25 +0000 Received: from sonic308-10.consmr.mail.ne1.yahoo.com ([66.163.187.33]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tIGjC-000juE-90 for pgsql-general@postgresql.org; Tue, 03 Dec 2024 00:25:24 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1733185519; bh=SYSjGW8PDwMksmQXoho+lScaGW87GHi2jELGaxwGaBY=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=LKALFH/YKWj9mhDLlkaI/U8ejlZ6ZsSAGef3DA52CpiocVoXmOk2BsxBixk1ZBEIlRCDVa+JibeJVz+y++GPMmJQU1WG4cwPapMsbSLmE2ocv3h7/arfXl44XM0zFoeum9SCmrKdCf8s5IiJLtd7mO4gmC5lt0MYOS/TV56Y+dYYlQR6FNEmbau/WoR0uyJZiHbE/titVgnRsGf4WlyNl3GVw1mT/WxwNB0BHoMnnBn13kj26swaPSOTj2NfKo3pPdox8oh+9nXbvoNNfQO7RnFvjpW/pLxx9WU9IaBlgT1G6MMGSA3YCtNjWtzXaQUbpXpavmYK6dOOO9SC1ZFm/A== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1733185519; bh=0czc9bKlPlvFYy/lNwRS5+zacfKOOlVTNC0S1MXymKO=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=dn6kRnHKhpeOhWGKt2JX5BNX79UWtK28KaP5hbKcaDhgjABc08iCR8i8Sp/s49s4+wYRnBLkE03CUpE46Tppmt4NjJXVXxs3JRdyq+6zyKeL3KZMoF1+QlvwW9lTFqWKyPeuOHV1Etxga/e8+e6ItQPxrUdaYE2DoUAo+5Zign5R6ch+guoKDAd/4cRp9L9Zql8ZEIPtXMa6EcVMKXK+vBKV5FofypDp08cxTDyb80d66WE9r5irg9OSjeAj6Y95TPsl1Bg+JRpEJTsS+eaecFgyPCLhcKp7d8DwNmgLU1pDahT39dmfC0VsHhkg1BxVgbw5Oqt2HocG7XJUzKcmuw== X-YMail-OSG: 7VMHNmIVM1nauB7BmuVnIyT4cuCxxOesS0.KYDaGmF5f8VNqp_4wRO6FEF.fnIR u9fPx7xZwmerCGxgIZrI5GiZxzl3_nHcq2SW_sKI6ZPGb0Om16XxD.KaQfmzcfddm43.ptpJmLyv CNFRv2pqUbztizEx_c2cfzawIELjzSDTm4y9WqNshjoxowv0l9Uxf65s2GyEmOJFMPtLsXIBVXOi BmURigp1pr3ArLalOR0s6aLShNwQLZdGIPkHbbhb.8UK59Ot2BmjEyS5GFYFP.VR0LgGtMOCuTiG cntG6mzT.P.bHLwIyBrDvQyxdUoJP14Ut_N8ifp5HMGJCJHM20NB3pLM0exVPqDkE2VbYRXeMvAd Dq6BcylX9m5AsOjiL.p3.rT6I1bdsEsNsvmly6VJELM8h.Qlm_pCH26S1UqjTPYTCR7E9JRUxJll IYzQEAIFV7zYzhSdUuE7_XYRvnhHwPikXX91IBAOKOTYUrzR5udE9Iao5nxL9F_.MQMsPF2ADdSc goF2_aa56ZRtGR3RntBBsQJOiWFAod.JiJ7D1HJ1sR_FUVKFUkqWGlGqTtF0h1n.XbcXJqD2lAw8 9eQ0G0tr9TXkMMXOJNLZFDbwi5NLnq_lmbIMUeq8fcKsuGhrIfhYB0eDPvfkvCRAO5nC2XhUv_z2 YyLpe8iW4v_IxLVVFrC3VUdiSY9_KIfLCGM9O86Wsxqj9fGnUcFp1Usb98UQS3afthb9y7cGcyY6 vczUeTE6sAbeXSuVFJBO6FZcsVnkd.tbS4SfDMCeMOml.mjDA6RXbCGMTRitLEcWh.2N9J6XP9ml IfhDyG3Ioxea_oKfLzsxGF2I8XOxN.kY7T.t8ESB_CDy3tv_tjvMC98vJov0V54V0qNFNJEzbbeG Odq3tldCtD.hzctdpQoHC6Nt_x.D2w7.ZBFr7Ki7IlDTYygR8gJI41M5AGUbxCLqQOvE8hpdLNXM zLyKOeGFEjwiNvF3B3pCbezr4iL6SlcdhIPm_Gqf_7mgTW.Bw64LXx3z7r3WAeMdARoW0yb_8CBo oTpqikPUQnsyMW3QUV.USYCG7xq91rg9zTk6tjs4ZBB7TArnSIqSCDV58ljoJ_SLen35nGd5BvsO IovD5oD3gfurRQPsx1Jy.FpdzBlEalSQPzZEeDE4KVctKbI3WFNo29pFshRqK8s_3QW9lLfFpRG9 OfmK0llwOntMuNIysZE52clD3Gq_N_NMacaGLuBqE02KaNGrUoZPQlTU3up9IgpoVTh.tw48oGqd vJ9GojHYAD8eih5FyVykoJ98VHdhRptvC1j44Ay27Gv_fZEOVnE5N1T8M3NgiVpdkmjr_CmuDHxq ZVr4YmqE2lsK7yGwHOdeOrJV3nJoMzQneKo9r_TvxjYMU.I6KPMZgYrHM0RXyTNiddLZEbXzGCAU fNhwi4WvhVKl3ldft9BVE7X7l2I3Ijwr7bIrORG9Z_tzJL4VOlwRmHBMjmvrXUSo.S2KiBxwgm.H VTr2_ewLj_aEC4nWAH4K4O0ppBvF5c7cZ72M_BTG935oyioROS1o_h_4f0G3P9tBXrG_Ld69X2gl .f5H.CqvD07IxGUqTl8N7nAfCssnGwr6Wdtp0aQruQITm4SP_PrxT2wroY0AoHNkx0.fNw..wIYT Rdck6NvwhYoi8YVOOTU54sK9H8mZEfVgkKFtsoNa6kF783Dd331FKC33HewV7yBzrV8AQ9SGKm2J LcXKo0BWu8OpQPcyD5ACdz7OE2mkd7p2UwWm2TOpdlq_XEoqThlx74Me7mrE7LleS6yyTvrxRWY. 8VU0TnAZo5QeeDOCSTvL0idg0bw9g032nDdZhF3acCas5BxxO72uBMaB1fScFkL.PtpjZDgzywzX DoUc0rWO2xTYMdZxpq2ldVal2AbQbE1UYAS0AH8nWBDb.Ev4B9xMcuLfknlXAaz6OeYqCM.m7blD bOuHn.oIzuW0GJwpgTrLkoGi46h9WHilmnVGfv2nUE1E6TFqnfm0S7P8Umh7A7358ZX.zreMHqdU jrIUYpiTysqK1s46l.ZumwWy6w2LwuxoI0rO5sFMm.M6lTgcn9pU8Ag1XVt3zwtZjYmEoN2dphPf 7TUJHzQ85NzZ4GLkxXf83qoYMyfB2iLPErfiV_3LFjdAgB8f3Gpu1iODhmiIJC1pV07WFzhcGUIY DemSj_lDw2aBkC68LXxWkpLekAJ4CSkg_Aj2qRz_1T_3IpLjwIar8It.1TKIAMHGn91WcHzh3oQg kEc.2B9jdqPSGGf8r7a4T_RJHypIVQuaRKhuuD4pyTxCHjkzCh2dp2Eh5vMzfTuvlyLrfagq_Vdn qTb1OpY.gPAReUXm4NGZd01suHlic X-Sonic-MF: X-Sonic-ID: fbdbf76f-16b6-4759-8453-e6c3e8a164e8 Received: from sonic.gate.mail.ne1.yahoo.com by sonic308.consmr.mail.ne1.yahoo.com with HTTP; Tue, 3 Dec 2024 00:25:19 +0000 Date: Tue, 3 Dec 2024 00:25:15 +0000 (UTC) From: Bharani SV-forum To: Ron Johnson , pgsql-general , Adrian Klaver Message-ID: <2102730591.3974293.1733185515380@mail.yahoo.com> In-Reply-To: <78f9dd08-4d28-4ed8-897e-b94889dbfd46@aklaver.com> References: <0558ddd4d71641bdb41fa49b2425f73c@safrangroup.com> <98965993.3138805.1731699978332@mail.yahoo.com> <564950518.5117550.1733177884387@mail.yahoo.com> <07ab2d83-ffe5-4bec-9626-22a68f732579@aklaver.com> <273a88dc-4134-47d5-bc19-30ff5f97926c@aklaver.com> <1760813407.5166251.1733182880136@mail.yahoo.com> <32763ce5-76e6-454d-bd64-53db8b2b9af6@aklaver.com> <54665410.4461273.1733183579920@mail.yahoo.com> <78f9dd08-4d28-4ed8-897e-b94889dbfd46@aklaver.com> Subject: Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3974292_687303204.1733185515379" X-Mailer: WebService/1.1.22941 YMailNorrin Content-Length: 7396 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_3974292_687303204.1733185515379 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable AdrianNoted about, Logical replication would not have issue with this as t= hat is one of it's use cases. qsn1: What is the size of database(s) you are dealing with? ans1: roughly 25 GB=C2=A0 (maximum size) qsn2 : What sort of downtime can you afford? ans2: can be maximum 30 mins or so qsn3:=C2=A0EC2 --> EC2, are they the same region?ans3: Right Question. I as= sume the same region Can you pl provide your insight now=C2=A0 On Monday, December 2, 2024 at 07:20:52 PM EST, Adrian Klaver wrote: =20 =20 On 12/2/24 15:52, Bharani SV-forum wrote: > Adrian >=20 > Proposed new Server is intended to have higher OS Version (centos ver=20 > 9.0) and higher Postgres Version 15.10 Alright I did not catch this " ... with new OS" from your original post.=20 I saw "Take offline full backup (PG_DATA folder alone)=C2=A0 using OS=20 command" and "Restore offline full backup (PG_DATA folder alone) using=20 OS command" and assumed like to like on the OS, my mistake. >=20 > Does logical replication will have issues , if the existing asis server= =20 > is having Postgres ver 13.16.2 with Cent Os 7.0 > with the new server having higher OS version Centos Ver 9.0 and then=20 > propose to have the Postgres to be upgraded > from ver 13.16.2 to 15.10 Logical replication would not have issue with this as that is one of=20 it's use cases. The question now becomes whether that is the quickest/=20 most efficient way to do this. That depends on: 1) What is the size of database(s) you are dealing with? 2) What sort of downtime can you afford? 3) EC2 --> EC2, are they the same region? >=20 > Hope u have understood my question >=20 > On Monday, December 2, 2024 at 06:47:10 PM EST, Adrian Klaver=20 > wrote: >=20 --=20 Adrian Klaver adrian.klaver@aklaver.com =20 ------=_Part_3974292_687303204.1733185515379 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Adrian
Noted = about, Logical replication would not have issue with this as that is one of=
it's use cases.


qsn1: What is the size of database(s)= you are dealing with?
ans1: roughly 25 GB  (maximu= m size)

qsn2 : What sort of downtime can you afford?
ans2: can = be maximum 30 mins or so

qsn3: EC2 --> EC2, are t= hey the same region?
ans3: Right Question. I assume the same re= gion

Can you pl provide your insight now
 

=20
=20
On Monday, December 2, 2024 at 07:20:52 PM EST, Adr= ian Klaver <adrian.klaver@aklaver.com> wrote:


=20 =20
On 12/2/24 15:52, Bharani SV-forum wr= ote:
> Adrian
>
> Proposed new Server is intended to have higher OS Version (centos ve= r
> 9.0) and higher Postgres Version 15.10

Alright I did not catch this " ... with new OS= " from your original post.
I saw "Take offline full back= up (PG_DATA folder alone)  using OS
command" and "R= estore offline full backup (PG_DATA folder alone) using
= OS command" and assumed like to like on the OS, my mistake.

>
> Does logical replication= will have issues , if the existing asis server
> is = having Postgres ver 13.16.2 with Cent Os 7.0
> with th= e new server having higher OS version Centos Ver 9.0 and then
> propose to have the Postgres to be upgraded
&g= t; from ver 13.16.2 to 15.10

Logical r= eplication would not have issue with this as that is one of
it's use cases. The question now becomes whether that is the quickest/ =
most efficient way to do this.

That depends on:

1) What i= s the size of database(s) you are dealing with?

2) What sort of downtime can you afford?

3) EC2 --> EC2, are they the same region?



>
> Hope u have u= nderstood my question
>
> On Mon= day, December 2, 2024 at 06:47:10 PM EST, Adrian Klaver
= > <adrian.klaver@aklaver.com> wrote:
>

--
Adrian Klaver
adrian.klaver@aklave= r.com

------=_Part_3974292_687303204.1733185515379--