libst_raster_pg.dll for PostgreSQL 9.2

[المشرف العام]

I need to store my raster in an enterprise geodatabase with st_raster data type. Copying libst_raster_pg.dll from

C:\Program Files (x86)\ArcGIS\Desktop10.3\DatabaseSupport\PostgreSQL\9.2\Windows64

to postgresql lib

C:\Program Files\PostgreSQL\9.2\lib

folder is part of installation and setup.

I have done this but when I use,

sdesetup.exe -o install_st_raster -d postgresql -D dbName -s localhost -u sde -p sdePass

command to install the st_raster data type, I get this error:

[Fri Jun 06 00:23:46 2014] ST_RASTER support being upgraded...
Upgrade from release 0 to 100000 [Fri Jun 06 00:23:46 2014] ev.SQLstate = XX000 SDE DBMS Error: -51 ERROR: incompatible library "C:/Program Files/PostgreSQL/9.2/lib/libst_raster_pg.dll": version mismatch DETAIL: Server is version 9.2, library is version 9.0.

[Fri Jun 06 00:23:46 2014] Error creating ST_RASTER TYPE and functions:-51. [Fri Jun 06 00:24:47 2014] ST_RASTER support being upgraded... Upgrade from release 0 to 100000 [Fri Jun 06 00:24:47 2014] ev.SQLstate = XX000 SDE DBMS Error: -51 ERROR: incompatible library "C:/Program Files/PostgreSQL/9.2/lib/libst_raster_pg.dll": version mismatch DETAIL: Server is version 9.2, library is version 9.0.

[Fri Jun 06 00:24:47 2014] Error creating ST_RASTER TYPE and functions:-51.

​

It seems libst_raster_pg dll is for postgres 9.0 and isn't upgraded to work with newer versions of postgresql!

I had this problem since version 10.2.1 of ArcGIS. I have tested it with ArcGIS 10.3 dlls and the problem still exists.

There is a Geonet thread about this problem but in that thread ESRI guys mentioned this dll is going to be upgraded in ArcGIS 10.3.

Can anybody here tell, when this dll is going to get upgraded to install it on postgresql 9.2 (or 9.3). Do we have to stick to binary storage rasters forever?

Thanks



أكثر...