[postgis-users] Help to upgrade postgresql10 with postgis 2.5

[pham lan]

Hello,

I have very less experience with postgres and postgis. However i receive a
task to upgrade an old database which has postgresql10 with postgis 2.5.
The database has some extensions: postgis, postgis_sfcgal,
postgis_topology, raster and have a lot of materialized views which depends
on functions on postgis and sfcgal libraries. Could someone please instruct
me to upgrade my postgres DB to a newer postgres and postgis version
without having to drop all those materialized views? Idealy to postgis 3.x?

Thanks in advance.

Best regards
Lan Pham
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20230315/4bfe6c3e/attachment.htm>