topic Re: Upgrade to 10.6 - how to uninstall st_raster in ArcGIS Enterprise Questions

Upgrade to 10.6 - how to uninstall st_raster

DuarteCarreira — Thu, 12 Jul 2018 09:26:57 GMT

st_raster is no longer distributed with 10.6, so what happens when upgrading from 10.5? Obviously I can't copy the libst_raster_pg.dll to the database as I used to.

So the question is: how to remove st_raster from our database?

Database is postgresql 9.3, that we need to upgrade to 9.6 before upgrading the geodatabase, to have a supported postgresql.

To upgrade we are going to use pg_upgrade which is the recommended approach instead of a backup/restore.

Thanks.

Duarte

Re: Upgrade to 10.6 - how to uninstall st_raster

George_Thompson — Thu, 12 Jul 2018 14:29:25 GMT

If you have raster data in the geodatabase (which is not recommended) then you can follow this help: Convert raster data from ST_Raster to RASTERBLOB storage—Help | ArcGIS Desktop

You basically change the Configuration Keyword and remove the ST_Raster option.

Geodatabase‌

Re: Upgrade to 10.6 - how to uninstall st_raster

DuarteCarreira — Thu, 12 Jul 2018 15:05:51 GMT

I don't have any raster data and config word is not st_raster.

My doubt is what to do with the libst_raster_pg.dll I have on the lib folder that's v 10.5.1.

When upgrading we're told to replace esri's dll's with the new versions. so st_geometry will be replaced with the new 10.6. But what about libst_raster_pg.dll?

Thanks

Re: Upgrade to 10.6 - how to uninstall st_raster

George_Thompson — Thu, 12 Jul 2018 16:01:54 GMT

Delete it

Re: Upgrade to 10.6 - how to uninstall st_raster

MichaelVolz — Thu, 12 Jul 2018 16:07:40 GMT

I would take a database backup before deleting anything just in case.

Re: Upgrade to 10.6 - how to uninstall st_raster

George_Thompson — Thu, 12 Jul 2018 16:31:47 GMT

That is a good idea, but if you did not use the ST_Raster, there should not be any impact. It is just an "extra" file that is not part of the standard DB install.

But I do agree to take a full backup before the Postgres or GDB upgrade.

Re: Upgrade to 10.6 - how to uninstall st_raster

DuarteCarreira — Thu, 12 Jul 2018 17:05:05 GMT

arcgis creates a series of objects in the sde schema that depend on that libst_raster_pg.dll, namely the st_raster type and a series of st_* functions. Once you delete the dll all of these will provoke errors in postgresql.

Also, if you deleted the dll, in the future when you try to upgrade say to postgresql 9.6, the missing dll will prevent restoring of objects that depend on the missing dll. Also, you will not be able to use pg_upgrade - the preferred way to upgrade postgresql - since all binaries must be present in both versions - the old and the new.

I hope the recommended way to upgrade a geodatabase is not to "brute force delete" a library in use by objects of the geodatabase.

Re: Upgrade to 10.6 - how to uninstall st_raster

George_Thompson — Thu, 12 Jul 2018 17:16:15 GMT

I am not sure, I thought that you added the ST_Raster, as a file, **if you wanted ST_Raster**. I do not think that it is required.

I have never had to add it before. I only added the ST_Geometry library with my Postgres DB's.

Here is the information related to v 10.5 and ST_Raster:

The ST_Raster data type—Help | ArcGIS Desktop

Install ST_Raster in PostgreSQL—Help | ArcGIS Desktop

Re: Upgrade to 10.6 - how to uninstall st_raster

DuarteCarreira — Thu, 12 Jul 2018 17:22:25 GMT

I'm sorry I must not have been clear from the start. The problem only appears when you have a geodatabase with st_raster installed. Which is my case. When I heard st_raster was to be discontinued I moved all raster out of the database. But the sde system types and functions, etc., still exist. Hence the difficulty to upgrade without i) removing them or ii) having a 10.6 dll.

Thanks for your comments.

Re: Upgrade to 10.6 - how to uninstall st_raster

George_Thompson — Thu, 12 Jul 2018 18:37:01 GMT

Ok, I do not think that would be an issue as long as the data is not in ST_RASTER. The underlying functions should still work. I do not think that you should have to "remove" anything.

Have you attempted and upgrade and received an error?

Re: Upgrade to 10.6 - how to uninstall st_raster

DuarteCarreira — Fri, 13 Jul 2018 08:24:45 GMT

I was trying to go from 9.3 to 9.6 and that's impossible without the dll for 9.6.

So now I've done the upgrade from 9.3 to 9.5, keeping with geodatabase at 10.5.1.

The next step is to try upgrade that geodatabase to 10.6 and see how that goes. Hopefully arcmap will automatically remove all traces of st_raster, and I'll be able to delete the dll.

Only then will I be able to upgrade postgresql from 9.5 to 9.6.

Note that arcgis 10.6 does not support postgresql 9.3 so I had to ugprade postgresql.

Re: Upgrade to 10.6 - how to uninstall st_raster

DuarteCarreira — Fri, 13 Jul 2018 09:37:43 GMT

I have now upgrade postgresql 9.5 + esri 10.5.1 to esri 10.6.

st_raster type and functions in sde schema are not deleted.

This means it is not possible to upgrade to postgresql 9.6.

Re: Upgrade to 10.6 - how to uninstall st_raster

George_Thompson — Fri, 13 Jul 2018 10:50:59 GMT

At this point, you should create an Esri support case and talk to an analyst for more guidance.

Re: Upgrade to 10.6 - how to uninstall st_raster

DuarteCarreira — Wed, 20 Feb 2019 15:11:42 GMT

So I forgot to close this with the final answer.

I started with tech support on July 7th.

On 2018/08/31:

BUG-000107835 : Upgrading PostgreSQL from 9.4.5 to 9.5.3 using the pg_upgrade command fails when ST_Geometry is configured.

On 2018/11/07:

The status of Esri BUG-000116414 - Unable to upgrade or restore ArcGIS 10.5.1 geodatabase/PostgreSQL 9.5 to ArcGIS 10.6/PostgreSQL 9.6 when ST_Raster is installed. - that you have been associated with has been changed to Implemented.

Public Explanation:

Case Number: 02147567

Version Fixed: 10.7.0

2 months to get an actionable answer. Which was: don't use the latest release that you payed for. No hot-fix made no work-around.

Still waiting for 10.7 to see with my own eyes if I'll be able to upgrade. Fingers crossed.

Not a happy camper.

UPDATE Nov-2020

I found a tech article with a script to remove st_raster objects:

Bug: Cannot upgrade/restore ArcGIS 10.5.1 geodatabase/PostgreSQL 9.5 to ArcGIS 10.6/PostgreSQL 9.6 when ST_RASTER is ins…

No one notified me of this, so I'm putting this here for any one in the same boat.