Upgrade to 10.6 - how to uninstall st_raster

[DuarteCarreira]

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

[George_Thompson]

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‌

[DuarteCarreira]

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

[George_Thompson]

Delete it

[MichaelVolz]

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

[George_Thompson]

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.

[DuarteCarreira]

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.

[George_Thompson]

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 

[DuarteCarreira]

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.

[George_Thompson]

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?