nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Upgrade to 10.6 - how to uninstall st_raster

Duarte_Carreira

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

Encuentra más publicaciones etiquetadas con

Accepted answers

Duarte_Carreira

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.

All comments

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‌

Duarte_Carreira

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

MikeVolz

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

Duarte_Carreira

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:

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.

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.