[postgis-users] pg_dump on upgraded server

[Paolo Cavallini]

Hi all

On 03/04/19 20:15, Paolo Cavallini wrote:
> Hi again
> 
> On 03/04/19 19:44, Sandro Santilli wrote:
> 
>> 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.
> 
> to do so I think the only way is to recompile it, right?
> 
>>> 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.
> 
> 2.1.4 reached EOL long ago, I don't think this is the case.
> thanks.

solved by forcing install of official deb postgresql-9.4-postgis-2.1
from there on, things work. so, why does apt remove the needed package?
it seems appropriate to me keeping it until postgresql 9.4 is purged.
am I missing something?
thanks a lot for the help.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS.ORG Chair:
http://planet.qgis.org/planet/user/28/tag/qgis%20board/