Select to view content in your preferred language

Migrate from PostgreSQL ST_Geom to PostGIS native

412
2
04-25-2023 03:27 AM
DuarteCarreira
Occasional Contributor II

Hey. I am considering migrating our geodb from ST_Geom to PostGIS with sde schema (a "proper" geodatabase).

My question is if there's any tool that simply converts a FC from ST_Geom to PostGIS type? It would really make a difference...

If not, does anyone have a suggestion on how to proceed to avoid export/import or copy/paste every single FC?

Thanks,

Duarte

2 Replies
reggis_1
New Contributor

Hi, what did you end up doing or finding out?

0 Kudos
DuarteCarreira
Occasional Contributor II

Hey, well I didn't really...

Still on the todo list.

I learned there's a new way to use PostGIS in esri world: since esri needed to be compatible with cloud offerings it's now possible to have a "pure" PostGIS geodatabase without even installing st_geom libraries (https://www.esri.com/arcgis-blog/products/arcgis-pro/data-management/create-an-on-premises-postgis-o...).

On the other hand, the libs for PostgreSQL 15 are now available (included in the Pro 3.2 download), so the delay to the latest Pg version is not that big ("only" 1 major release).

So I'm pondering... do I just keep st_geom or do I ditch it...

As for how to migrate, my guess is copy/paste every single FC using a script. Which obviously forces a rebuild of all views that reference those FCs and that's why I haven't moved yet.

0 Kudos