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.
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
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.