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 1m3zTL-00061c-84 for pgsql-admin@arkaria.postgresql.org; Thu, 15 Jul 2021 11:24:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m3zTJ-0002Go-Ur for pgsql-admin@arkaria.postgresql.org; Thu, 15 Jul 2021 11:24:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m3zTJ-0002Ga-Cl for pgsql-admin@lists.postgresql.org; Thu, 15 Jul 2021 11:24:05 +0000 Received: from sonic317-34.consmr.mail.ne1.yahoo.com ([66.163.184.45]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m3zTE-0004Wn-9U for pgsql-admin@postgresql.org; Thu, 15 Jul 2021 11:24:04 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1626348236; bh=osnwwCVYPgSJ5MLSIEnHkQHG3LeSg/eagoSiQ5CGAFI=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=hyZmTeXeEJnhpBrM1zWSSfUJYhY20V3WLfkDy94UQK6LKnULuOngwDLEcPYeSnPsK/swfWS/Ivi7KZiSq930jtV6MB7jRDtCml6x8m7FUMQZdTa4LuLjJot5bzNoptJ0CUXBjmmiyByn2bOkCnyQW3bl1/iIOQ0LGEcQIsrRvoTzLI14o2XKeMRH6MZ/CtZWqqhGVjOQ6wfMFKBMzIUR2vVga789TbHviL3x/fb+b5vInsTuU7yKgzuF7DWg/jFMSeW2mrLfX0rWEf2+TNCEPboAnCBINikPRqrfpaNWhJbkF+lu+oent15lGMMnZVpvsebxdhZqWr1Vb1QTLdbGLg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1626348236; bh=9v/dBSbCBJX39NXVN00m/EFsFcNiE8O+7UBhveKBCD0=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=Qj1salFHKX8Upyp5SKwEp9cHPmprZfOPBs6gpCPboqScM4/qeQkEBz7XHPVyZ8hF1+MGfb85B5lFuLT1uy41sGN83zcPHOdaTLijWe3ufz+PNYEd0cSnLskE0WrLYNfkgTQVPVpdzoYsR0Ep8PHiP9sNqtv3RQMBpEItD7msxQhZO0oqFi3WOlA8GlBL01bfpBJxly0j3QufYbW9gRmrd6bM6BfVLY6WloAbYO7p2cJKJyn8wF1n8Q7qDa0giZMCOI6LOLxevW792yiKkAAviCVGB7FoJ2JT6RlBNY4IFlfREu0hm0TJJUlm7NeNz9BkmQc3sXSAX+fQnit36iDhNg== X-YMail-OSG: ULCGUukVM1nvy71_2vgZEIWO9c2HKJqMgFtCJhtTgW.lrMJd48fpbc9P5.kPJ5y TDnNPja0SWilPK0rIRppZR3MlDsEspRVL2HlwrGEVkfTXFgT9mqwEjwLRi1FNVvXZAjpfqx84qrh tCqu.gpKlgaflZ0XvoXoahlNYnStZOkffr2UJpD0kAoXwtuTe6Bair.1IEhrlwpLC69i5ZFtV5GJ cbQ6febpVblCeVqqO2XMcF38pUz1pZvLZEkZqmHFRCPEkc.2vAFESw.tacd1ekKFeTRnV0P28h0R Q.7jc07VXsrhm7sxvasaekxIEf5ooXizRCFFe8_cAb1J0BwGz38vm6jcdH2nY9zf2qJMNsyAbWub 3l5r.VZ1G4qp1SOBR.lA_rEvMNXNLnnxGpho6ztOYk0a8ircJOL4m8HE96m4UpRVa1k4ONTRNKLk 0Vd7OrULTvEJ7HX9cLjpR1yWbvR3FhgCnVIJOW3MIgize42e0P1as9Yj6DKRkqsRVNPqLCDr4HC8 e.36FgGqPvhGAPJckanywUo.l_EUWgozd_XsZ5VSRqyXi4AMpPXhTnoD5y7wW.9uyP0Eek0fV_sf QVn0YaqVYY2HC0tFK7bZve8yNm1yGqCiNVV.q4JaMffC31tXX3ybLoM32cD6W25UthOku_ZrQYPr xZRh6A601l0M8WYJtCznaJHQwRLSQNMpFVz15fF6kp3w.UvkzZBIIvDFXSzRmB_ufDaExdqiqzWS NvWjewyoXeNJllGJJXsM6wWMENPNX_zVx8PBLR12GL7cktyENmG61FHAdQ8X9owuxkyKlhMgwfae mSILsAf._P3LGtj2dxFuH6UG6IRJ9kbOtR9B63jVgWeV3L.3v6dOCqIYoVUp.1YjOPxFWstAjOCk jG3YdSP.J8nT_8Yt_oQ60rCAMjx_JQAoat51fxLObv6KGZIGfFU1LqP0rLwfB54yqqFwafRlAF1a hKbOm2qTUdDiAlsCBSAK5EPvOTyc7KsHECTYo6mLXV8d1RUT.CSl7ze.efFJ_QzMpZqvQn3wy4yH saKV_K77tOuuD2Sgcxzei0B2SnR5H_N.OiKOvj3MnWRNtUjcPonEkToxxahfwCWL.H3bxoHhBisd 0aoJU23Lj9Im0foOivC.cNHbSRy0YzrDGOWTqmTchBudSlyvHxNRXhj2C9NxWQoVIqoOVlUNtHla mStcrBc0HYsO2ckpdFDmP4JuygZKoe62ySa4T7f3s6VSPZi9CwAgJfAh7nfFMIgouVYq1X1TPbgc dXKvYzNt3_u0h6VRCV8zoMvmuLa0kdgAk7TuCoSjH9QQk_JMp245OuNHJLr_gilNsE3cpb6deIoQ U7dlVHlGRPBCg9X_Mu8N2S40xE0YGttrogDZOBx_UG_AgO.dEWidEBuScpT3HP6HVlhNsSTA_Is9 96DUC8SXhtlqBjigDo7EO98hIxQ9h_FUirE6na47sOXmOiP7DMrx1MDvHvRnIRAcFH8sokOss9o_ gijm_EVQqriXTtAQqEsxWWdU5Tk3_ohQMbKgb_vP_JiE9teM2DfAURoPG7rZGewy8VhaC26AVz9e 4Twl9mzDmapfbfLrpF3mM02Or6FnTidM6YATrj8FpPDsKuBkb7tIHYhiKbDe__Uuz5Jg4Oh2Hecb iSJWkxgRi35Jmy3Osd7O_.r2ur1leeeQ6XQLeBSZ_FoOtsf9Fgh2eR_4b._e.LASsBUme4TDRC0x TaCBSPaDiKGltW1FEra_CDU.fpi3pRbE6lppAhUPZeKlifAk7XZkh6eECCz9v7gy91BOncI5pwK9 G_4o2lYm6fiWLAOu6v2u4p1z6duqdaOAKRENDu1hTvzTJzxBF32YEDVrSR3h_F2qB4z.bI8Oxztm so3u9GkAW0snoRtOMrcIfX62DczxAkO8Bf6MOfNfQi9lnLZX_GvKX7ox5d8k3cfLWq95ta9pNBgV B4h0g2aWQPvxSJMvhOIJ9_j2S6t7OxH5HrXlwm2ujaEUxo2euEM4mlqbFI5dJIa3ESiS3_7HXE9E HjFjhWplWO6QuXb0z1LcmeKd.GW3viN6kjbMv3G1tKrDw8IaUHQdrsBeSvVsfflK0F2K_sAz2abw xss.vh_HePogL5WZFJxDoBVNcVJVLXTsMTEvVsh6P2Wr9lAfryalqP08kd7FAO5hf.QRGeHHg4Yu LNDDfLZ9WmOopA1yJu99YsXQchXCNXW10HF_HK9iCjjwCW1_3MDC7sWYtrV19mnlAl9ZKBEbwO2e AaRPNg8ZqPa5mJo3jQF0R7ODCU.8cGU1DI1YWmrpvxXcyRG1OTS7TJsgJB7OuFRAnICjhtJaE1bT LaKfyd4bKCpRjDmEkqPSFpM8wPI.8R0wtg7frMlAn19zs8JAAG0sJIAxpXHqfCYhPcYu1HFQvY52 9uZ4UTf.Mhfb2tKrNmq6BJDQWwcgfU3H9f7tup73EBOxRyi6FPeHFLFveAFqDOCjZFnBGPT1E9X6 RQ5C.p8xCj79uw.qzzlzJZWsYZKVWskwtZwHvUeR96dOg52uZRgjHxa2ky4QZ X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic317.consmr.mail.ne1.yahoo.com with HTTP; Thu, 15 Jul 2021 11:23:56 +0000 Date: Thu, 15 Jul 2021 11:23:53 +0000 (UTC) From: Matti Linnanvuori To: "David G. Johnston" , abbas alizadeh Cc: pgsql-admin Message-ID: <172713955.3216472.1626348233909@mail.yahoo.com> In-Reply-To: <6696AE88-3B1C-4DAA-A3AE-62EB08140FD8@yahoo.com> References: <6696AE88-3B1C-4DAA-A3AE-62EB08140FD8@yahoo.com> Subject: Re: Upgrade postgresql MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3216471_786599743.1626348233907" X-Mailer: WebService/1.1.18469 YMailNoble Content-Length: 4805 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_3216471_786599743.1626348233907 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi! There is PostGIS hard upgrade from e.g. PostgreSQL 9.2 to PostgreSQL 13.=C2= =A0https://postgis.net/docs/manual-3.1/postgis_administration.html#hard_upg= radeI could not make pg_upgrade work for that. Best regards, Matti Linnanvuori On Thursday, July 15, 2021, 02:14:51 PM GMT+3, abbas alizadeh wrote: =20 =20 Thanks DavidI did the same, the big issue is postgresql v9.2 suport postgi= s up to bersion 2.3 and minimum postgis version which is support bty postgr= esql 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 po= stgres v9.6 to 13.But out of curiosity I asked this question to figure out = if there is any better solution to upgrade directly from 9.2 to 13 or no Best regardsAbbas On 6 Jul 2021, at 11:01 AM, David G. Johnston = wrote: =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 postgr= esql 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. https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS My assumption is that you need to upgrade PostGIS independently from upgrad= ing PostgreSQL - i.e., the PostGIS version should not change during the upg= rade. David J. =20 ------=_Part_3216471_786599743.1626348233907 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi!

There is PostGIS hard upgrade fro= m e.g. PostgreSQL 9.2 to PostgreSQL 13. 
https://postgis.net= /docs/manual-3.1/postgis_administration.html#hard_upgrade
I could= not make pg_upgrade work for that.

Best regards, = Matti Linnanvuori

=20
=20
On Thursday, July 15, 2021, 02:14:51 PM GMT+3, abbas al= izadeh <ramkly@yahoo.com> wrote:


Thanks David=
I did the same, the big issue is postgresql v9.2 suport postgis up to = bersion 2.3 and minimum postgis version 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 out of curiosity I asked this question = to figure out if there is any better solution to upgrade directly from 9.2 = to 13 or no

Best rega= rds
Abbas

On 6 Jul 2021, at 11:01 AM, David G. Johnston <david.g.johnsto= n@gmail.com> wrote:

=
=EF=BB=BFOn Monday, July 5, 2021, abbas alizadeh <ramkly@ya= hoo.com> wrote:
Hi guys
Do we have any chance to upgrade postgresql v9.2 with postgis 2.0 to postgr= esql v13.3 with postgis 3.0 using pg_upgrade?

I=E2=80=99m gonna say probably not, but yo= u 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 PostGI= S independently from upgrading PostgreSQL - i.e., the PostGIS version shoul= d not change during the upgrade.

David J.

------=_Part_3216471_786599743.1626348233907--