[postgis-users] save restor postgis.

[Jeff McKenna]

Hi Alain,

That's exactly how I move from Windows to Unix, for clients.  I do 
sometimes have to execute on the new system:

   SELECT postgis_extensions_upgrade();


but it seems everything is already fine in your case.

-jeff



-- 
Jeff McKenna
GatewayGeo: Developers of MS4W, MapServer Consulting and Training
co-founder of FOSS4G
http://gatewaygeo.com/



On 2021-11-22 4:43 a.m., Alain Benard wrote:
> Hi,
> 
> I need to change serveur (Centos + Postgresql 12.8 and Postgis 3.0.4)  
> and the new server is Ubuntu LTS 20.04 + postgresql 12.9 and postgis 3.1.4.
> 
> I test pg_dump on the old server and pg_restore on the new and no errors 
> occurs (postgis_full_version on the databse restor is ok with 3.1.4).
> 
> I know this process is ok or Postgresql but what about postgis ? The log 
> pg_restor says creation extension Postgis …. Does anyone have an opinion 
> on this way of doing ? Do we need to check something in particular ?
> 
> Is there another way ? Is there a risk ?
> 
> Thanks for advance.
> 
> Alain.
> 
> INRA
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>