topic postgreSQL, geodatabases, Openshift how to place st_geometry.so in ArcGIS Enterprise in the cloud Questions

postgreSQL, geodatabases, Openshift how to place st_geometry.so

RiccardoKlinger — Fri, 12 Nov 2021 12:29:06 GMT

We plan to move our enterprise infrastructure to openshift in the next months/years to come. Yet we still see the need to use ArcGIS Pro and also ArcGIS Enterprise on kubernetes to work with a PostgreSQL running on kubernetes (Openshift) as a cloud native database. Are there any guidelines, how-to's or best practices how to do so as I currently don't have a clue, how and where to put this awesome st_geometry.so file...

Maybe this question is a bit naive, but I don't want to host the DB on a somewhat regular machine nor on an EC2/Compoute machine with a full blown Linux below...

If this sde spatialtype is not an option right now, what are the disadvantages I will face switching to postgis instead?

Help is much appreciated.

Re: postgreSQL, geodatabases, Openshift how to place st_geometry.so

George_Thompson — Fri, 12 Nov 2021 13:20:48 GMT

I am not sure that this is currently supported. It would be best to work with technical support to see what options are available.

Here is the current docs on this: https://enterprise.arcgis.com/en/system-requirements/latest/windows/databases-in-the-cloud.htm

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-postgresql/setup-geodatabase-postgresql-linux.htm

Re: postgreSQL, geodatabases, Openshift how to place st_geometry.so

ChristopherPawlyszyn — Tue, 16 Nov 2021 13:43:40 GMT

If you are running PostgreSQL as a pod within your cluster, you should be able to build a custom image that includes the st_geometry.so library in the correct location on the image. It may take some dockerfile knowledge to achieve that goal. Alternately on a truly cloud-managed PostgreSQL offering, this may not be an option depending on whether you have access to the underlying instance running the DBMS.