postgis after pg_upgrade

From: Slavcho Trnkovski <strnkovski(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: postgis after pg_upgrade
Date: 2018-11-30 13:11:10
Message-ID: CACwHmfHTZGhM-dPXsyQs9vKPUbwTgbYa3GW3n=QP_3b55qvzbw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have postgresql 9.4 with postgis extension installed (latest version,
2.4.5). I upgraded postgresql from 9.4 to 9.6.
After upgrading to 9.6 I get the following result
from PostGIS_full_version()
select PostGIS_full_version();

postgis_full_version
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
POSTGIS="2.4.5 r16765" *PGSQL="94" (procs need upgrade for use with
"96") *GEOS="3.6.2-CAPI-1.10.2
4d2925d6" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 1.11.4, released
2016/01/25" LIBXML="2.9.1" LIBJSON="0.11" RASTER
(1 row)

Is there any way to resolve this besides recreating the extension?

Regards,
Slavcho

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francesco Nidito 2018-11-30 15:10:50 Log level of logical decoding
Previous Message Stephen Frost 2018-11-30 13:05:49 Re: surprising query optimisation