[postgis-users] pg_dump on upgraded server

[Sandro Santilli]

On Wed, Apr 03, 2019 at 07:34:33PM +0200, Paolo Cavallini wrote:
> 
> 
> On 03/04/19 19:04, Sandro Santilli wrote:
> > Can you show the ALTER EXTENSION command you're issuing and the
> > error you're getting ? Also please show the output of
> > 
> >   SELECT postgis_full_version();
> 
> I tried both
> ALTER EXTENSION postgis UPDATE;
> with something like
> the 2.1.4 version is already installed

This is unexpected, if 2.3.1 was _really_ installed.
Can it be you manually installed 2.1.4 again on top
of 2.3.1 ? What version you update to depends on
the contents of postgis.control file.

> ALTER EXTENSION postgis
>  UPDATE TO "2.3.1"
> with
> ERRORE:  l'estensione "postgis" non ha un percorso di aggiornamento
> dalla versione "2.1.4" alla versione "2.3.1"

It could be 2.1.4 was released _after_ 2.3.1 (check the NEWS file).
In this case you could try a more recent 2.3.x version of PostGIS.

--strk;