[postgis-users] pg_dump on upgraded server

[Paolo Cavallini]

same error, mismatching versions
# pg_dropcluster --stop 9.6 main
# pg_upgradecluster 9.4 main


On 03/04/19 18:23, Paul Ramsey wrote:
> Use a pg_upgrade process instead of a pg_dump. You should be able to that with just the old data area and the new server software.
> 
>> On Apr 3, 2019, at 9:21 AM, Paolo Cavallini <cavallini at faunalia.it> wrote:
>>
>> I mean: server versions don't match (9.4 vs 9.6)
>>
>> On 03/04/19 18:20, Paolo Cavallini wrote:
>>> done already, but it complains that the versions don't match
>>> thanks
>>>
>>> On 03/04/19 18:10, Paul Ramsey wrote:
>>>> Put a symlink to the postgis-2.3.so file, named as postgis-2.1.so
>>>>
>>>> P
>>>>
>>>>> On Apr 3, 2019, at 9:08 AM, Paolo Cavallini <cavallini at faunalia.it> wrote:
>>>>>
>>>>> Hi all,
>>>>> I'm on a difficult situation: a debian sever with a pg9.4/pgis2.1 db has
>>>>> been upgraded to stretch, therefore to pg9.6/pgis2.3. Now pg_dump will
>>>>> complain of the missing pgis2.1 lib, even if I dump only a non public
>>>>> (thus without pgis functions) schema.
>>>>> How could I fix this?
>>>>> Thanks a lot.
>>>>> -- 
>>>>> Paolo Cavallini - www.faunalia.eu
>>>>> QGIS.ORG Chair:
>>>>> http://planet.qgis.org/planet/user/28/tag/qgis%20board/
>>>>> _______________________________________________
>>>>> postgis-users mailing list
>>>>> postgis-users at lists.osgeo.org
>>>>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>>>
>>>> _______________________________________________
>>>> postgis-users mailing list
>>>> postgis-users at lists.osgeo.org
>>>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>>>
>>>
>>
>> -- 
>> Paolo Cavallini - www.faunalia.eu
>> QGIS.ORG Chair:
>> http://planet.qgis.org/planet/user/28/tag/qgis%20board/
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
> 

-- 
Paolo Cavallini - www.faunalia.eu
QGIS.ORG Chair:
http://planet.qgis.org/planet/user/28/tag/qgis%20board/