topic Re: Publishing to PostgreSQL database in ArcGIS Enterprise Questions

Publishing to PostgreSQL database

ChristianLutz — Tue, 22 Jan 2013 08:10:43 GMT

Hello,

i have a shapefile on the client and want to publish that to a PostgreSQL database on my server where also ArcGIS for Server is running. Could someone give me the general steps to accomplish that, please? The ArcGIS Help was not a great help yet?

Thanks!!

Re: Publishing to PostgreSQL database

ChristianLutz — Fri, 25 Jan 2013 17:17:57 GMT

What i want to do is described here http://localhost:6080/arcgis/help/en/index.html#//0154000003rn000000#ESRI_SECTION1_3DDF21D6C99748179085FD64F650EE34
(see the image of the 2nd choice: "If the service type you want to publish requires an enterprise geodatabase")

Here are the errors so far:
Now, when want to publish from the log in Manager i get the following errors:
SEVERE 25.01.2013 19:46:16 Error executing tool.: ERROR 001369: Failed to create the service. Failed to execute (Publish Service Definition). System/PublishingTools.GPServer
SEVERE 25.01.2013 19:46:16 Failed to create the service.: Can't init GeoDataServer with a workspace that isn't a geodatabase. System/PublishingTools.GPServer
SEVERE 25.01.2013 19:46:16 Corrupt configuration. Unable to find the connection file to the target enterprise geodatabase. System/PublishingTools.GPServer
SEVERE 25.01.2013 19:46:16 Failed processing the databases in the service definition. System/PublishingTools.GPServer

What i did were all steps from here http://resources.arcgis.com/en/help/main/10.1/index.html#//002p00000001000000 respectively here http://localhost:6080/arcgis/help/en/index.html#//002p000000t4000000 to make postgresql fine for arcgis. But when i came to the point "create enterprise geodatabase" it was creating one but could never completely finish the job.

Then i was "Registering ArcGIS Server's Managed Database" from here http://localhost:6080/arcgis/help/en/index.html#/Registering_your_data_with_ArcGIS_Server_using_ArcGIS_for_Desktop/015400000504000000/ (which is the last point). when i do it from arcgis desktop it only takes the db connection from "Hinzufügen" (add) in "Datenbank registrieren" (register database).
[ATTACH=CONFIG]21061[/ATTACH]
Otherwise when i use import it says "the managed db must be an enterprise db". When I do it in arcgis for server manager it is ok and I can use import.

Thanks a lot for any help!!!!!!!!!!!!!!!!!!!!!!!!

Re: Publishing to PostgreSQL database

ChristianLutz — Mon, 28 Jan 2013 19:32:52 GMT

Ok.. solved.

For those who are interested, means that want to achive publishing shapefiles or (i am quite sure) databases (work too) from ArcGIS Desktop like here http://resources.arcgis.com/en/help/main/10.1/index.html#/Copying_data_to_the_server_automatically_when_publishing/0154000003rn000000/ (see the image of the 2nd choice: "If the service type you want to publish requires an enterprise geodatabase") to ArcGIS for Server respectively PostgreSQL:

1. Do this Tutorial http://resources.arcgis.com/en/help/main/10.1/#/Tutorial_Getting_started_with_geodatabases_in_PostgreSQL/002p000000t4000000/ !!Download everything from the Esri Customer Care portal and just use lower case letters for your geodatabase name!! and go until the point "Create a geodatabase" included which for me took 2 hours that it creates the geodatabase. So be patient 🙂

2. Connect your created geodatabase to ArcGIS Desktop respectively make a publisher connection to ArcGIS Server from ArcGIS Desktop as described here http://resources.arcgis.com/en/help/main/10.1/index.html#/Making_a_publisher_connection_to_ArcGIS_Server_in_ArcGIS_for_Desktop/01540000041t000000/ If you need more info for special configs look here http://resources.arcgis.com/en/help/main/10.1/index.html#/Geodatabase_connections_in_ArcGIS_Desktop/002p00000036000000/ under PostgreSQL

3. Register your created geodatabase respectively the .sde file that was created in the previous step to ArcGIS Server as described here http://resources.arcgis.com/en/help/main/10.1/index.html#//015400000504000000 under the point "Registering ArcGIS Server's Managed Database". Btw where you can find the "Data Store" tab is written at the beginning of this page.

4. Publish your services.

Cheers