[postgis-users] Error upgrading to PostGIS 2.4.3

[Sandro Santilli]

On Tue, Mar 20, 2018 at 02:27:47PM -0400, Tom Kazimiers wrote:
> Hi Ross,
> 
> On Tue, Mar 20, 2018 at 05:59:37PM +0000, McDonaldR wrote:
> > Maybe you can point me in the right direction.  I'm running PostgreSQL
> > 9.6.8 (64bit) on Windows 2008 R2 with PostGIS 2.3.5 installed.  I have
> > installed the 2.4.3 binaries and when I try to run ALTER EXTENSION
> > postgis UPDATE TO "2.4.3"; I get the following error:
> > 
> > ERROR could not load library PostgreSQL/9.6/lib/postgis-2.4.dll The
> > specified procedure could not be found.
> 
> This is just a random guess, but one problem I encountered on all my
> Postgres setups to upgrade from PostGIS 2.3 to 2.4 is the following: There
> was a single function definition which isn't updated by the PostGIS 2.4 SQL
> script to point the new binary:
> 
>  geog_brin_inclusion_add_value().

You're referring to:
https://trac.osgeo.org/postgis/ticket/3956

That bug was supposedly fixed in version 2.4.3 so should
not be the one Ross is hitting. I cannot read the
"specified procedure" in Ross' ERROR message, typical
"friendliness" of those proprietary operating systems ?
May I suggest you use a serious system for PostGIS ?

--strk;