topic Upgrade Geodatabase issue in Geodatabase Questions

Upgrade Geodatabase issue

PawelGanczarski — Wed, 31 Jan 2018 23:16:51 GMT

Hi everyone,

I am attempting to Upgrade Geodatabase and the following error prevents the upgrade.

"Connected RDBMS instance is not setup for ST_GEOMETRY configuration.You must copy the latest ST_GEOMETRY library to the PostgreSQL software location"

The GDB was created a couple of years ago using ArcMap 10.3.1, very recently ArcMap was upgraded to 10.6

PostgreSQL 9.3.5 is running on Windows Server 2012 R2

The original st_geometry file exists in PostgreSQL lib folder. Since the error message suggests the latest ST_GEOMETRY file needs to be copied, I've tried copying the files from DataSupport folder in Postgres 9.4, 9.5, 9.6 but that wouldn't even allow connections to be made.

Also the libeay32.dll, libpg.dll,libintl-8.dll and ssleay32.dll files are in the intended location.

Any ideas any help will be much appreciated

Best regards,

Pawel

Re: Upgrade Geodatabase issue

Asrujit_SenGupta — Thu, 01 Feb 2018 03:58:39 GMT

You did kind off answer the question yourself..

ArcMap was upgraded to 10.6
PostgreSQL 9.3.5 is running on Windows Server 2012 R2
I've tried copying the files from DataSupport folder in Postgres 9.4, 9.5, 9.6

As you can see, the ArcGIS 10.6 Database Support does not have any 9.3 folder. The reason being, PostgreSQL 9.3.x is not a supported database for ArcGIS 10.6.

PostgreSQL database requirements for ArcGIS 10.6—System Requirements | ArcGIS Desktop

To upgrade any further than 10.3.x, you will have to upgrade the version of PostgreSQL.

PostgreSQL database requirements for ArcGIS 10.4.x—System Requirements | ArcGIS Desktop (Needs atleast PostgreSQL 9.3.10)

PostgreSQL database requirements for ArcGIS 10.5.x—System Requirements | ArcGIS Desktop (Needs atleast PostgreSQL 9.3.13)

Re: Upgrade Geodatabase issue

George_Thompson — Thu, 01 Feb 2018 13:24:38 GMT

Make sure that you have Visual Studio VC++ 2017 installed on the Windows PostgreSQL server:

For PostgreSQL on Windows, you'll need the latest Visual Studio VC++ 2017 installed on the PostgreSQL instance machine. See https://support.microsoft.com/en-us/help/2977003/the-latest-supported-visual-c-downloads for more information.

PostgreSQL database requirements for ArcGIS 10.6—System Requirements | ArcGIS Desktop

Re: Upgrade Geodatabase issue

PawelGanczarski — Thu, 01 Feb 2018 18:47:04 GMT

Thanks Asrujit, somehow I managed to miss this important piece of the puzzle.

Hopefully won't encounter any snags during the Postgres upgrade.

Re: Upgrade Geodatabase issue

PawelGanczarski — Thu, 01 Feb 2018 18:48:21 GMT

Thanks for the tip, George.

Re: Upgrade Geodatabase issue

Arturo_FranciscoAcosta_Bazán — Tue, 03 Apr 2018 15:09:03 GMT

have been trying to create a GDB on Postgres, copying st_geometry (C: \ Program Files \ PostgreSQL \ 9.6 \ lib) and I got an error from library latest. The solution was to install VC ++ 2017 Thanks George