Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m0cw9-0002IU-0k for pgsql-admin@arkaria.postgresql.org; Tue, 06 Jul 2021 04:43:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m0cw7-0001kL-RA for pgsql-admin@arkaria.postgresql.org; Tue, 06 Jul 2021 04:43:55 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m0cw7-0001kD-0x for pgsql-admin@lists.postgresql.org; Tue, 06 Jul 2021 04:43:55 +0000 Received: from sonic303-23.consmr.mail.gq1.yahoo.com ([98.137.64.204]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m0cw3-0004AQ-Pi for pgsql-admin@postgresql.org; Tue, 06 Jul 2021 04:43:53 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1625546625; bh=pqwJ4haCyUoR74FL2JGismTp2WPWansQbw7kgiyRz4c=; h=From:Subject:Date:References:Cc:In-Reply-To:To:From:Subject:Reply-To; b=YUITTV5Sn6A5mWe1ZvmZj/Ee7HPiEhfvPVsz0PtjXFZIi9l5M9rDNgddLUYEf4wJLUvIPOWrhh9YgCLJds0Eu9Evag3orWpZG5+eybX8OQzy7v9d2cRLDt+NzTjCFqts3mTTNDO6Xi06byw6E3HURMdm+jdEWQpKRGfepSJ9vjw84tiCsoTAiGwcpGhn5N9LWGMUqvxnoFU34U5id3Hi96xxDBQv50bdbO8wUBXsbNWkK/nvI3awonzt14zRXXx64nuKdlPYJTGRjmK5DgG7tM1yjBgsLOkzpjvXXUKxi9TqPYXABdhdEbPMzCI2CzlHRzbIPDZqsxtIHauCJhYjVw== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1625546625; bh=cUESG+2WYf0nCueIDt4ZvxPbh/4HmNbGSHRqfWUfTYZ=; h=X-Sonic-MF:From:Subject:Date:To:From:Subject; b=XwQ8+dOdhZ9F4FdfoxcCuyLYkwWEQkctFkxepDBgjAOjbTGVjxav87iek6zw4NEhQ+BN+D8JziflstZ2jJL4s3uqxTd+L+airlx3Lx4nJyO+N3en8QoPtJnXNa/dK+59P/E2W4phE+3pHOGN1ZpCkDXrEZ3ncBCGdthOEU0KhaYRQ/+OkwYHaETAH5Bmi90+45YFgmLAy+4zV3/T49J3ae7T7aca/aN78B+yMzopT9Ru+8gW/mWSXyRP2WE/aqOl9wMsQYM2ohyBpKjIeyX3aMg/sLfYY23ntvxpDBXj3EU2rtdMJ1Y1WDF4RLnUPHaFE4sKdQmO/l1KdR6I2HryuQ== X-YMail-OSG: wp8rmtoVM1m6AtKx3TXgMcI.j5gVBUWNCxk4YMePGR_Ze5CafUUoWnwi_6W8KRJ QnZxDw8lyo79AS5Zar7HJtyCOfyp6NSYX.5LiLGnmkbLTJWE4l2DmUvgeBxxvt15no46WfPflolm 6.kbD4iuAU3Ugr57Huc5hx1Uc9PKM2zFfJEHqv1b30viT5D1r37P_xzFdtF4HRgXX6IxMb1BNBLt iDuatypVHymoFG8bJclERtSCwP2mTCs4Pmf9I7ufsVcASdDiNNtpHVawmKx7N1OwD8dRNOjk1_YV jmW8vhHjw0ntNxD2Bkr6C5CQK04IGl1k85BF2Xch8MQkA3BUqvUlPf3SY1J7li2akEEbgrKyQ.vd 3OM7f0Csn_NkPyKqjJ46x2vUEPp5HQHE6cNT_7CYTHrnhtQP.3WNnsrSlL7mOlpqDgn2HBv9P4Xc 2BEzfVi3F0xKqlt5jEurJ3Ss5u_mtb0G4A.K.9NaIyTrNbDzK7Hjhb1hWoKKP23Wzz_FisQV669i N.V0WsyeNqX6Q3UyA0k6P6CqwZJ5BTi64sZcu85YwzsWbG41vBpOg81wR0dwD93jd5Phlm_.qGBA xIfnw4EQR62xdg6IZmRj7sJaH4Oz.ly9IRAuZpmEtZo.AOb7zCh269EFqy1E7wYI2PEfIsH0j4XW wPmfgz6zDO9_Xjq0qWq7TSbMoiQ1VN5t_dp6tUerV.5Vvs2q9gzS8t.IdAFynsCD_97hx7lYdbSv sWjtzL.Uzm9Hf5X43UwH44xSVPTRiUYIAgCbcQleX6eLfrDTDGXJe7NBk0vzk7XFSjoQ6h4plnrF 1h8RJ7MksKAVY6lsI2wAKQALNiILpE5I.qaM.7d3ClLppPISSOxfaxirrSVZyA1Q2rs6ymCFL74z Zyu7L0bLQPBqgk.lM0_boz8PMmXyVPQEacTMlMdmHuSxhuMh.M_hOIPwy4iCJmJ8yDw4inLqRhNM 8DHKX5cd3vsPiyBYRCn8zgweWF2vJvKDwySXmvohLPOpYnqo71Rqfed01.bf0vDTRCsdD_WD1P.4 KVc4eE_HeE4g0qM8KTSKa8K7FWPRpR0bTfLNZqYmRb3nbmnNCrOle2JS8blczCxrXDZfz6.tSGnS yTu7fZm69kRC9a69Uj41.B_ahJXmNdKCWn4Ch5w2i4N8yCj3cqHbxsL85I1hxVJ4CAj8YViPIM0C LneprxitH0Tl9SsHuL2PRhPva9rU3IdRZulkBQlXRgZjcJR72AZhHDp1jp3nCeixZ8IqG3o4XFCZ WDWW3JAYDf4vT59Pc8_5uvnHo.5bxMnxiWzj9Hun8_7l8uXwfbMEWSXEF4zlWllXnpjPCk2jkXRI f6JHtAzUFCZ7TiBtGcQ0zNFLpqKQTP0uFzGA0f_Fu0S5YfdxLBxW2vyyL6y..c5VMmFIs0_01sDW bgID5z8.ozWnKWqITvtkCaMXJgDBINjWwb0KU2XPaJTZSHFsFg7A9MNnanPeVOguVmP9mrTI34iP uCSxgqzGkfqB4TTJCLyqacUCrjf3fWPR.sYtYfSdeXHRDU8I6p9WOpkH.9Lq02INsJQ7r6BzfYUj ln_Zi7_NtBJ9qSNNObnNoWBFbQiSKxcMQcIMYvn4Ni6rrHUu5gl0c63awVUQ82UJ_EC_B86dRIdn fUzBriX7yJG396EldlA0MASu4oUplO4zgwKxyOoIIgktnNXiEMu2sArbXAL5d8F_xXGiZ_FJUhY7 96j4b0_6d8ma7hYJQfQSfp0PU4eOFwUdQjNF8WIZVctN7SjuS.e5mxEJa_Lbl61DNVuFnlOPEPMz KYjES50shG1Add6pdZQHBxnxFlX3yzv7n2mVq28REgS3.3abFNT.3MTyjFwMzq_Y3QQ6o3GNSWlk VY0CYUz65HFCD5Ua3mUVa0iSYRwuonGGSMwfjqudRH_cDjdWzs9Ji_V_B9PS1xURhKyAkRCtiCoI 8sw.VJiYYwiN_fGZQXWPCjT6SV0pFMWV.bOoWuXUoBBj6hdqxdCl8SOvJbWhu292OmpXz9XsHkO9 6IvSQRHXuVToK7hsMNuDyd4zkKxeOo2HX16pB3r4zq39TLBGJ9jPLy8wT_nFtPTCjnNeu7WlZDoJ 9v9kjKMdRh8s4ewShKrhSdwzoCCeXGoPFfmaU1TyUnhqHRReqz9TATZSjVJxPrhJuCITTKie.kPo 2eGDSGgme5SDYBmjVU9NWVMYTaNdh70YJkMedBRp2PlQoXfM3Kt4N2xRQkM7G4MPbiE.Q.ipoPj7 8hMszoVSQsJYpKlp.fzkYp3SalIfbcDFoeqo4bf7CVuyjKkTII_tqVq5BD_knNYFG8fpShmeo4uK hs_gYoTQ0RuBJfHVEql.0ctNMWwL4m4hHkFQJcFLkIx2hhgX1KE8XWuw_Vv0v3A8DFLO8eD0TAiR GMV9KIaKBkS6xpg591gpC3IBDs0Q6A2epyiBXTWaox_cngvVGkX88YLvuRPenYjdAUqU1jZfuW7n QQ1HBpPTQWtJfWTJ4Q4_wPBOvxJR5aZzuV2MPoN62n7PZ7VVGg5oHsHt2IIHC X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic303.consmr.mail.gq1.yahoo.com with HTTP; Tue, 6 Jul 2021 04:43:45 +0000 Received: by kubenode517.mail-prod1.omega.sg3.yahoo.com (VZM Hermes SMTP Server) with ESMTPA ID 36fb5608eed2be04c62d1d7a2cc2f462; Tue, 06 Jul 2021 04:43:39 +0000 (UTC) Content-Type: multipart/alternative; boundary=Apple-Mail-F992BA08-2E38-4FED-A697-29BB18B27252 Content-Transfer-Encoding: 7bit From: abbas alizadeh Mime-Version: 1.0 (1.0) Subject: Re: Upgrade postgresql Date: Tue, 6 Jul 2021 12:43:36 +0800 Message-Id: <6696AE88-3B1C-4DAA-A3AE-62EB08140FD8@yahoo.com> References: Cc: pgsql-admin In-Reply-To: To: "David G. Johnston" X-Mailer: iPhone Mail (18F72) Content-Length: 3436 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-F992BA08-2E38-4FED-A697-29BB18B27252 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Thanks David I did the same, the big issue is postgresql v9.2 suport postgis up to bersio= n 2.3 and minimum postgis version which is support bty postgresql v13 is ver= sion 2.5. So what I did was to upgrade postgres v9.2 ti v9.6, then upgrade postgis on p= g v9.6 to postgis v.3 and again I upgraded the postgres v9.6 to 13. But out of curiosity I asked this question to figure out if there is any bet= ter solution to upgrade directly from 9.2 to 13 or no Best regards Abbas > On 6 Jul 2021, at 11:01 AM, David G. Johnston = wrote: >=20 > =EF=BB=BFOn Monday, July 5, 2021, abbas alizadeh wrote:= >> Hi guys >> Do we have any chance to upgrade postgresql v9.2 with postgis 2.0 to post= gresql v13.3 with postgis 3.0 using pg_upgrade? >=20 > I=E2=80=99m gonna say probably not, but you can do your own research if yo= u want to figure whether you might be able to get away with it. >=20 > https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS >=20 > My assumption is that you need to upgrade PostGIS independently from upgra= ding PostgreSQL - i.e., the PostGIS version should not change during the upg= rade. >=20 > David J. >=20 --Apple-Mail-F992BA08-2E38-4FED-A697-29BB18B27252 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Thanks David
I did the same, the big is= sue is postgresql v9.2 suport postgis up to bersion 2.3 and minimum postgis v= ersion which is support bty postgresql v13 is version 2.5.
So what= I did was to upgrade postgres v9.2 ti v9.6, then upgrade postgis on pg v9.6= to postgis v.3 and again I upgraded the postgres v9.6 to 13.
But o= ut of curiosity I asked this question to figure out if there is any better s= olution to upgrade directly from 9.2 to 13 or no
=
Best regards
Abbas

On 6 Jul 2021, at 11:01 AM, Davi= d G. Johnston <david.g.johnston@gmail.com> wrote:

=
=EF=BB=BFOn Monday, July 5,= 2021, abbas alizadeh <ramkly@yahoo.c= om> wrote:
Hi guys
Do we have any chance to upgrade postgresql v9.2 with postgis 2.0 to postgre= sql v13.3 with postgis 3.0 using pg_upgrade?

I=E2=80=99m gonna say probably not, but you= can do your own research if you want to figure whether you might be able to= get away with it.


My assumption= is that you need to upgrade PostGIS independently from upgrading PostgreSQL= - i.e., the PostGIS version should not change during the upgrade.

David J.

= --Apple-Mail-F992BA08-2E38-4FED-A697-29BB18B27252--