[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] [External] RE: [External] Re: Postgis 3.0.3 extension for AWS RDS Postgres 13.3
From:       Raj Talati <rajtalati () gmail ! com>
Date:       2022-02-15 19:22:32
Message-ID: CAP7G0B7cj-+CoBRa9yZ+q2EEQs7AejQzA-umzbg9WvXGGwhD1Q () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Yes that will be better option if you can upgrade to 11.14 it's available
on RDS not sure for Gov cloud and it's not available for Aurora too.
Minor upgrade will take some time to but not long as major upgrade as I
think minor upgrade they bring up new binaries and stuff still much faster
and better option to not go through 2 major version upgrade and hopefully
with Postgis upgraded to 3.01 you should able to go direct from PG11 to
PG13 .

Raj

On Tue, Feb 15, 2022 at 1:24 PM Regina Obe <lr@pcorp.us> wrote:

> So I'm curious is 11.14 not supported on GovCloud.
> 
> 
> 
> Doing micro updates should not require any downtime or very miniscule
> downtime because the data doesn't need to be fixed to go up to 11.14.
> 
> So it really should be just flipping the switch.
> 
> 
> 
> So 11.14 is really where you want to be for security /bugfix patches
> anyway.
> 
> 
> 
> *From:* Allan Chase [mailto:allan.chase@bluestaq.com]
> *Sent:* Monday, February 14, 2022 10:52 PM
> *To:* Regina Obe <lr@pcorp.us>; 'PostGIS Users Discussion' <
> postgis-users@lists.osgeo.org>
> *Subject:* RE: [External] RE: [postgis-users] [External] Re: Postgis
> 3.0.3 extension for AWS RDS Postgres 13.3
> 
> 
> 
> Thanks Regina,
> 
> 
> 
> Yeah, I saw that link that you referenced (a few days back) and I kind of
> went…hmmmm.  From that chart, you can upgrade to 3.1.X if you just go from
> 11.12 to 11.13 (or 14), but the thing that caught me a little off guard was:
> 
> 
> 
> PostgreSQL on Amazon RDS - Amazon Relational Database Service
> <https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.FeatureSupport.Extensions.13x>
>  
> 
> 
> I will definitely try your suggestions below.  All this is technically for
> a system that currently only goes as high as 13.3, so I'm currently stuck
> with 3.0.3 (this is all on "Gov Cloud").
> 
> 
> 
> The main driver for me to want to jump right to 13 was to minimize our
> down time since it is a production system.  If the best answer is to jump
> from 11 to 12 to 13, I'll just need to make sure I quantify the downtime
> (probably 45 minutes – hour) which is fine.
> 
> 
> 
> Allan Chase
> 
> Data Engineer
> 
> 
> 
> *From:* Regina Obe <lr@pcorp.us>
> *Sent:* Monday, February 14, 2022 7:10 PM
> *To:* 'PostGIS Users Discussion' <postgis-users@lists.osgeo.org>; Allan
> Chase <allan.chase@bluestaq.com>
> *Subject:* [External] RE: [postgis-users] [External] Re: Postgis 3.0.3
> extension for AWS RDS Postgres 13.3
> 
> 
> 
> **************************************************************************
> ATTENTION: External email
> Please verify the sender before taking any actions or clicking any links.
> **************************************************************************
> 
> Allan,
> 
> 
> 
> Looking at this chart, it looks like you can upgrade from PostGIS 2.5 to
> 3.1 on PostgreSQL 11 right?
> 
> 
> https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.FeatureSupport.Extensions.11x
>  
> Says PostGIS 3.1 is available for 11.14.
> 
> 
> 
> That would be a safer bet to upgrade your PostgreSQL 11 first to 3.1.
> 
> PostgreSQL 13 removed CREATE EXTENSION from unpackaged, which I think the
> 3.0 release relies on, so that would be one reason why you can't go from
> 2.5.2 to 3.0.3.
> 
> 
> 
> I think we introduced the work-around for that in PostGIS 3.1.
> 
> 
> 
> So options that theoretically should work
> 
> 
> 
> Go from your PG 11-  PostGIS 2.5.2 to PostGIS 3.1.4
> 
> Then upgrade from
> 
> PG 11 PostGIS 3.1.4 -> PG 13 PostGIS 3.1.4
> 
> 
> 
> Or if you really badly want to go straight to 13
> 
> 
> 
> PG 11 2.5.2 -> PG 13.5 (which does have PostGIS 3.1.4)
> 
> 
> 
> 
> https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.FeatureSupport.Extensions.13x
>  
> 
> 
> 
> 
> Hope that helps,
> 
> Regina
> 
> 
> 
> 
> 
> 
> 
> *From:* Regina Obe [mailto:lr@pcorp.us <lr@pcorp.us>]
> *Sent:* Monday, February 14, 2022 8:46 PM
> *To:* 'PostGIS Users Discussion' <postgis-users@lists.osgeo.org>; 'Allan
> Chase' <allan.chase@bluestaq.com>
> *Cc:* 'Sandro Santilli' <strk@kbt.io>
> *Subject:* RE: [postgis-users] [External] Re: Postgis 3.0.3 extension for
> AWS RDS Postgres 13.3
> 
> 
> 
> strk,
> 
> AWS doesn't allow the below. But I think it should work as part of the
> ALTER EXTENSION as you have it in 3.3 as that runs under a higher level
> account.
> 
> 
> 
> Allan,
> 
> 
> 
> Can you output what your
> 
> 
> 
> SELECT * FROM pg_extension WHERE extname ='postgis';
> 
> 
> 
> Shows and confirm it does say 2.5.2.
> 
> 
> 
> If it says something like 2.5.2next then do:
> 
> 
> 
> ALTER EXTENSION postgis UPDATE TO '2.5.2';
> 
> 
> 
> Also run:
> 
> 
> 
> SELECT postgis_full_version();
> 
> 
> 
> At any rate, Raj might be right that upgrading from 11 to 13 for PostGIS
> is not supported on AWS.  Most people I've known on AWS first upgrade to 12
> first.
> 
> 
> 
> Thanks,
> 
> Regina
> 
> 
> 
> 
> 
> 
> 
> 
> 
> *From:* postgis-users [mailto:postgis-users-bounces@lists.osgeo.org
> <postgis-users-bounces@lists.osgeo.org>] *On Behalf Of *Allan Chase
> *Sent:* Monday, February 14, 2022 6:26 PM
> *To:* Raj Talati <rajtalati@gmail.com>; PostGIS Users Discussion <
> postgis-users@lists.osgeo.org>
> *Subject:* Re: [postgis-users] [External] Re: Postgis 3.0.3 extension for
> AWS RDS Postgres 13.3
> 
> 
> 
> According to Upgrading the PostgreSQL DB engine for Amazon RDS - Amazon
> Relational Database Service
> <https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.PostgreSQL.html>,
>  one can upgrade from 11.12 right to 13.3.
> 
> 
> 
> Allan Chase
> 
> Data Engineer
> 
> 
> 
> *From:* Raj Talati <rajtalati@gmail.com>
> *Sent:* Monday, February 14, 2022 4:08 PM
> *To:* Allan Chase <allan.chase@bluestaq.com>; PostGIS Users Discussion <
> postgis-users@lists.osgeo.org>
> *Subject:* [External] Re: [postgis-users] Postgis 3.0.3 extension for AWS
> RDS Postgres 13.3
> 
> 
> 
> **************************************************************************
> ATTENTION: External email
> Please verify the sender before opening attachments or clicking links.
> **************************************************************************
> 
> If this AWS RDS you cannot upgrade directly from 11.x to 13.x . You will
> need to upgrade to 12.x and if you did like upgraded 11.x to 12.x and the.
> Upgraded fro 12.x to 13.3 then when you upgraded from 11.x to 12.x you need
> to upgrade Postgis too as AWS as that should allow you to upgrade postgis
> and then when you upgrade Postgres to 13 you should able to upgrade Postgis
> too. If we bypass Postgis upgrade while going from 11-> 12 and just so
> while doing 12->13 you will face this issue .
> 
> 
> 
> Hope this helps.
> 
> 
> 
> On Mon, Feb 14, 2022 at 5:40 PM Sandro Santilli <strk@kbt.io> wrote:
> 
> On Mon, Feb 14, 2022 at 03:33:29PM -0500, Regina Obe wrote:
> 
> > the workaround is below, but not sure it will work on AWS
> > RDS as updating system tables might be off limits.
> > 
> > UPDATE pg_extension SET extversion = 'ANY'
> > WHERE extname = 'postgis';
> 
> Allan: please let us know if AWS RDS allows or not the above
> UPDATE, as we are planning to use that construct for
> the postgis_extensions_upgrade() function in PostGIS-3.3.0
> 
> --strk;
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
> 


[Attachment #5 (text/html)]

<div dir="auto">Yes that will be better option if you can upgrade to 11.14 it's \
available on RDS not sure for Gov cloud and it's not available for Aurora \
too.</div><div dir="auto">Minor upgrade will take some time to but not long as major \
upgrade as I think minor upgrade they bring up new binaries and stuff still much \
faster and better option to not go through 2 major version upgrade and hopefully with \
Postgis upgraded to 3.01 you should able to go direct from PG11 to PG13 .</div><div \
dir="auto"><br></div><div dir="auto">Raj  </div><div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Feb 15, 2022 at 1:24 PM \
Regina Obe &lt;<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left-width:1px;border-left-style:solid;padding-left:1ex;border-left-color:rgb(204,204,204)"><div \
lang="EN-US" link="blue" vlink="purple"><div \
class="m_-5065050637501482261WordSection1"><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">So I'm curious is 11.14 not supported on \
GovCloud.<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">Doing micro updates should not require any downtime or \
very miniscule downtime because the data doesn't need to be fixed to go up to \
11.14.<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">So it really should be just flipping the \
switch.<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">So 11.14 is really where you want to be for security \
/bugfix patches anyway. <u></u><u></u></span></p></div></div><div lang="EN-US" \
link="blue" vlink="purple"><div class="m_-5065050637501482261WordSection1"><p \
class="MsoNormal"><span style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><div \
style="border-style:none none none solid;border-left-width:1.5pt;padding:0in 0in 0in \
4pt;border-left-color:blue"><div><div style="border-style:solid none \
none;border-top-width:1pt;padding:3pt 0in 0in;border-top-color:rgb(225,225,225)"><p \
class="MsoNormal"><b>From:</b> Allan Chase [mailto:<a \
href="mailto:allan.chase@bluestaq.com" target="_blank">allan.chase@bluestaq.com</a>] \
<br><b>Sent:</b> Monday, February 14, 2022 10:52 PM<br><b>To:</b> Regina Obe &lt;<a \
href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>&gt;; &#39;PostGIS Users \
Discussion&#39; &lt;<a href="mailto:postgis-users@lists.osgeo.org" \
target="_blank">postgis-users@lists.osgeo.org</a>&gt;<br><b>Subject:</b> RE: \
[External] RE: [postgis-users] [External] Re: Postgis 3.0.3 extension for AWS RDS \
Postgres 13.3<u></u><u></u></p></div></div><p class="MsoNormal"><u></u>  \
<u></u></p><p class="MsoNormal">Thanks Regina,<u></u><u></u></p><p \
class="MsoNormal"><u></u>  <u></u></p><p class="MsoNormal">Yeah, I saw that link that \
you referenced (a few days back) and I kind of went…hmmmm.   From that chart, you \
can upgrade to 3.1.X if you just go from 11.12 to 11.13 (or 14), but the thing that \
caught me a little off guard was:<u></u><u></u></p><p class="MsoNormal"><u></u>  \
<u></u></p><p class="MsoNormal"><a \
href="https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.FeatureSupport.Extensions.13x" \
target="_blank">PostgreSQL on Amazon RDS - Amazon Relational Database \
Service</a><u></u><u></u></p><p class="MsoNormal"><u></u>  <u></u></p><div><p \
class="MsoNormal">I will definitely try your suggestions below.   All this is \
technically for a system that currently only goes as high as 13.3, so I'm currently \
stuck with 3.0.3 (this is all on "Gov Cloud").<u></u><u></u></p><p \
class="MsoNormal"><u></u>  <u></u></p><p class="MsoNormal">The main driver for me to \
want to jump right to 13 was to minimize our down time since it is a production \
system.   If the best answer is to jump from 11 to 12 to 13, I'll just need to make \
sure I quantify the downtime (probably 45 minutes – hour) which is \
fine.<u></u><u></u></p><p class="MsoNormal"><span style="font-family:&quot;Comic Sans \
MS&quot;"><u style="font-family:&quot;Comic Sans MS&quot;"></u>  <u \
style="font-family:&quot;Comic Sans MS&quot;"></u></span></p><p \
class="MsoNormal"><span style="font-family:&quot;Comic Sans MS&quot;">Allan Chase<u \
style="font-family:&quot;Comic Sans MS&quot;"></u><u style="font-family:&quot;Comic \
Sans MS&quot;"></u></span></p><p class="MsoNormal">Data \
Engineer<u></u><u></u></p></div><p class="MsoNormal"><u></u>  <u></u></p><div><div \
style="border-style:solid none none;border-top-width:1pt;padding:3pt 0in \
0in;border-top-color:rgb(225,225,225)"><p class="MsoNormal"><b>From:</b> Regina Obe \
&lt;<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>&gt; <br><b>Sent:</b> \
Monday, February 14, 2022 7:10 PM<br><b>To:</b> &#39;PostGIS Users Discussion&#39; \
&lt;<a href="mailto:postgis-users@lists.osgeo.org" \
target="_blank">postgis-users@lists.osgeo.org</a>&gt;; Allan Chase &lt;<a \
href="mailto:allan.chase@bluestaq.com" \
target="_blank">allan.chase@bluestaq.com</a>&gt;<br><b>Subject:</b> [External] RE: \
[postgis-users] [External] Re: Postgis 3.0.3 extension for AWS RDS Postgres \
13.3<u></u><u></u></p></div></div><p class="MsoNormal"><u></u>  <u></u></p><p \
class="MsoNormal">**************************************************************************<br>ATTENTION: \
External email <br>Please verify the sender before taking any actions or clicking any \
links. <br>************************************************************************** \
<u></u><u></u></p><div><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">Allan,<u></u><u></u></span></p><p \
class="MsoNormal"><span style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p \
class="MsoNormal"><span style="color:rgb(31,73,125)">Looking at this chart, it looks \
like you can upgrade from PostGIS 2.5 to 3.1 on PostgreSQL 11 \
right?<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)"><a \
href="https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.FeatureSupport.Extensions.11x" \
target="_blank">https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL \
.html#PostgreSQL.Concepts.General.FeatureSupport.Extensions.11x</a><u></u><u></u></span></p><p \
class="MsoNormal"><span style="color:rgb(31,73,125)">Says PostGIS 3.1 is available \
for 11.14.<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">That would be a safer bet to upgrade your PostgreSQL 11 \
first to 3.1.<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">PostgreSQL 13 removed CREATE EXTENSION from unpackaged, \
which I think the 3.0 release relies on, so that would be one reason why you can't go \
from 2.5.2 to 3.0.3.<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">I think we introduced the work-around for that in \
PostGIS 3.1.<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">So options that theoretically should \
work<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">Go from your PG 11-   PostGIS 2.5.2 to PostGIS \
3.1.4<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">Then upgrade from<u></u><u></u></span></p><p \
class="MsoNormal"><span style="color:rgb(31,73,125)">PG 11 PostGIS 3.1.4 -&gt; PG 13 \
PostGIS 3.1.4<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">Or if you really badly want to go straight to \
13<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">PG 11 2.5.2 -&gt; PG 13.5 (which does have PostGIS \
3.1.4)<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)"><a \
href="https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.FeatureSupport.Extensions.13x" \
target="_blank">https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL \
.html#PostgreSQL.Concepts.General.FeatureSupport.Extensions.13x</a><u></u><u></u></span></p><p \
class="MsoNormal"><span style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p \
class="MsoNormal"><span style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p \
class="MsoNormal"><span style="color:rgb(31,73,125)">Hope that \
helps,<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">Regina<u></u><u></u></span></p><p \
class="MsoNormal"><span style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p \
class="MsoNormal"><span style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p \
class="MsoNormal"><span style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><div \
style="border-style:none none none solid;border-left-width:1.5pt;padding:0in 0in 0in \
4pt;border-left-color:blue"><div><div style="border-style:solid none \
none;border-top-width:1pt;padding:3pt 0in 0in;border-top-color:rgb(225,225,225)"><p \
class="MsoNormal"><b>From:</b> Regina Obe [<a href="mailto:lr@pcorp.us" \
target="_blank">mailto:lr@pcorp.us</a>] <br><b>Sent:</b> Monday, February 14, 2022 \
8:46 PM<br><b>To:</b> &#39;PostGIS Users Discussion&#39; &lt;<a \
href="mailto:postgis-users@lists.osgeo.org" \
target="_blank">postgis-users@lists.osgeo.org</a>&gt;; &#39;Allan Chase&#39; &lt;<a \
href="mailto:allan.chase@bluestaq.com" \
target="_blank">allan.chase@bluestaq.com</a>&gt;<br><b>Cc:</b> &#39;Sandro \
Santilli&#39; &lt;<a href="mailto:strk@kbt.io" \
target="_blank">strk@kbt.io</a>&gt;<br><b>Subject:</b> RE: [postgis-users] [External] \
Re: Postgis 3.0.3 extension for AWS RDS Postgres 13.3<u></u><u></u></p></div></div><p \
class="MsoNormal"><u></u>  <u></u></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">strk,<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">AWS doesn't allow the below. But I think it should work \
as part of the ALTER EXTENSION as you have it in 3.3 as that runs under a higher \
level account.<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">Allan,<u></u><u></u></span></p><p \
class="MsoNormal"><span style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p \
class="MsoNormal"><span style="color:rgb(31,73,125)">Can you output what \
your<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">SELECT * FROM pg_extension WHERE extname \
='postgis';<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">Shows and confirm it does say \
2.5.2.<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">If it says something like 2.5.2next then \
do:<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">ALTER EXTENSION postgis UPDATE TO \
&#39;2.5.2&#39;;<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">Also run:<u></u><u></u></span></p><p \
class="MsoNormal"><span style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p \
class="MsoNormal"><span style="color:rgb(31,73,125)">SELECT \
postgis_full_version();<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">At any rate, Raj might be right that upgrading from 11 \
to 13 for PostGIS is not supported on AWS.   Most people I've known on AWS first \
upgrade to 12 first.<u></u><u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p class="MsoNormal"><span \
style="color:rgb(31,73,125)">Thanks,<u></u><u></u></span></p><p \
class="MsoNormal"><span \
style="color:rgb(31,73,125)">Regina<u></u><u></u></span></p><p \
class="MsoNormal"><span style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p \
class="MsoNormal"><span style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p \
class="MsoNormal"><span style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><p \
class="MsoNormal"><span style="color:rgb(31,73,125)"><u></u>  <u></u></span></p><div \
style="border-style:none none none solid;border-left-width:1.5pt;padding:0in 0in 0in \
4pt;border-left-color:blue"><div><div style="border-style:solid none \
none;border-top-width:1pt;padding:3pt 0in 0in;border-top-color:rgb(225,225,225)"><p \
class="MsoNormal"><b>From:</b> postgis-users [<a \
href="mailto:postgis-users-bounces@lists.osgeo.org" \
target="_blank">mailto:postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of \
</b>Allan Chase<br><b>Sent:</b> Monday, February 14, 2022 6:26 PM<br><b>To:</b> Raj \
Talati &lt;<a href="mailto:rajtalati@gmail.com" \
target="_blank">rajtalati@gmail.com</a>&gt;; PostGIS Users Discussion &lt;<a \
href="mailto:postgis-users@lists.osgeo.org" \
target="_blank">postgis-users@lists.osgeo.org</a>&gt;<br><b>Subject:</b> Re: \
[postgis-users] [External] Re: Postgis 3.0.3 extension for AWS RDS Postgres \
13.3<u></u><u></u></p></div></div><p class="MsoNormal"><u></u>  <u></u></p><p \
class="MsoNormal">According to <a \
href="https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.PostgreSQL.html" \
target="_blank">Upgrading the PostgreSQL DB engine for Amazon RDS - Amazon Relational \
Database Service</a>, one can upgrade from 11.12 right to 13.3.<u></u><u></u></p><p \
class="MsoNormal"><u></u>  <u></u></p><div><p class="MsoNormal"><span \
style="font-family:&quot;Comic Sans MS&quot;">Allan Chase<u \
style="font-family:&quot;Comic Sans MS&quot;"></u><u style="font-family:&quot;Comic \
Sans MS&quot;"></u></span></p><p class="MsoNormal">Data \
Engineer<u></u><u></u></p></div><p class="MsoNormal"><u></u>  <u></u></p><div><div \
style="border-style:solid none none;border-top-width:1pt;padding:3pt 0in \
0in;border-top-color:rgb(225,225,225)"><p class="MsoNormal"><b>From:</b> Raj Talati \
&lt;<a href="mailto:rajtalati@gmail.com" target="_blank">rajtalati@gmail.com</a>&gt; \
<br><b>Sent:</b> Monday, February 14, 2022 4:08 PM<br><b>To:</b> Allan Chase &lt;<a \
href="mailto:allan.chase@bluestaq.com" \
target="_blank">allan.chase@bluestaq.com</a>&gt;; PostGIS Users Discussion &lt;<a \
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" \
target="_blank">postgis-users@lists.osgeo.org</a><br> <a \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" \
target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br> \
</blockquote></div></div>



_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic