[postgis-users] Postgis upgrade with Postgresql 9.6 to 11 upgrade

[Paul Ramsey]

Just run 

  SELECT postgis_full_version()

You should see the right version and libraries referenced.

P

> On Jan 25, 2019, at 8:46 AM, Bo Guo <bo.guo at gisticinc.com> wrote:
> 
> OK.  Is there a way to validate the success of a Postgis upgrade?
> 
> On 1/25/19 9:33 AM, Paul Ramsey wrote:
>> You have two options, or maybe less, depending on where you get your PostgreSQL and PostGIS from. If you get them from some packager or other you might not have the freedom to mix-and-match versions.
>> 
>> OPTION: Simple And Lots of Steps
>> 
>> - Install Pg11 and PostGIS 2.4.4 for Pg11. 
>> - Run your PgSQL pg_upgrade process
>> - Install PostGIS 2.5 for Pg11
>> - Run the PostGIS ‘ALTER EXTENSION postgis UPDATE’ process
>> - Celegrate
>> 
>> OPTION: More harder
>> 
>> - Install Pg11 and PostGIS 2.5 for Pg11
>> - Try and run your pg_upgrade
>> - If you’re lucky, it “just works”
>> - If you’re not lucky, you might have to find the Pg11 install of postgis-2.5.so and make a symlink to it from postgis-2.4.so
>> - If you’re not lucky, you might have to track down and remove old versions of geos that are interfering with newer versions
>> 
>> Note that in both options, you do have to install a version of PostGIS that has been built against your new database version. The PostGIS 2.4 you already have installed for Pg9.6 is only serving your 9.6 databases, it does nothing for your new Pg11 databases.
>> 
>> ATB,
>> P
>> 
>> 
>> 
>> 
>>> On Jan 25, 2019, at 8:26 AM, Bo Guo <bo.guo at gisticinc.com> <mailto:bo.guo at gisticinc.com> wrote:
>>> 
>>> Hi all,
>>> 
>>> We plan to upgrade PostgreSQL 9.6 (PostGIS "2.4.4 r16526") to PostgreSQL 11 in the next couple of weeks.
>>> 
>>> I am just wondering if there is anything I should be concerned about on the side of Postgis, such as will postgis version upgrade automatically?  If not, should I upgrade Postgis after the PostgreSQL update?, etc.
>>> 
>>> Thanks!
>>> 
>>> Bo
>>> 
>>> 
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org>
>>> https://lists.osgeo.org/mailman/listinfo/postgis-users <https://lists.osgeo.org/mailman/listinfo/postgis-users>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org>
>> https://lists.osgeo.org/mailman/listinfo/postgis-users <https://lists.osgeo.org/mailman/listinfo/postgis-users>-- 
> Bo Guo, PhD, PE 
> Gistic Research, Inc.
> 2033 E Warner Rd. Ste 105 
> Tempe, AZ 85284 
> www.gisticinc.com <applewebdata://0471FB6C-8D27-46DE-85E1-D6CB69C86404> 
> Tel: 480-656-9962
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190125/54b14d89/attachment.html>