[postgis-users] pg_dump on upgraded server

Paul Ramsey pramsey at cleverelephant.ca
Wed Apr 3 09:23:26 PDT 2019


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



More information about the postgis-users mailing list