问题描述
求大神解答,我安装了ARCgis10.2,安装了postgresql-9.0.18-2-windows,进行连接,出现问题,提示YoumustcopythelatestST_GEOMETRYanddependentlibrariestothePostgreSQLsoftwarelocation.RefertotheArcGIShelptopicsformoredetails.已连接的RDBMS实例未针对Esri空间类型配置进行相应设置。执行(CreateEnterpriseGeodatabase)失败。我已经将st_geometry.dll放在了具体位置,求大神解答
解决方案
解决方案二:
firstofall,IwillNOTrecommendinstallingPostgreSQLonaWindowsServeratall.ItworksbetteronaUnix/Linuxsystem.Second,pleasefollowingtheinstructiononESRIwebsiteforthisprocedure:SettingupageodatabaseinPostgreSQLonaWindowsserverThefollowingisasummaryofthestepsyoutaketocreateageodatabaseinPostgreSQLonWindows:ObtainandinstallasupportedreleaseofPostgreSQLandconfigurethedatabasecluster.YoucandownloadPostgreSQLinstallationsfromtheEsriCustomerCareportal.Ifyouusethisinstallation,nospecificnondefaultsettingsareneededtousePostgreSQLwithArcGIS.Justbesuretochangethelocaleandlocationsettingsifyouwanttousethoseotherthanthedefault.Alternatively,youcanobtainthePostgreSQLinstallationyourself.SeethedocumentationonthePostgreSQLwebsiteforinstructionsoninstallingandconfiguringPostgreSQL.Configurethedatabaseclustertoacceptconnections.Thisincludesalteringthepg_hba.conffiletoallowthedatabaseclustertoacceptremoteconnections.InstalltheArcGISclientfromwhichyouwillcreatethegeodatabase.DownloadthePostgreSQLclientlibraries(ifyourArcGISclientisonWindows)orRPM(ifyourArcGISclientisonLinux)fromtheEsriCustomerCareportalandplacetheminthebindirectoryoftheArcGISclientyouinstalledinthelaststep.SeeSettingupaconnectiontoPostgreSQLformoreinformation.Copythest_geometrylibrarytothePostgreSQLinstallationdirectory.Thest_geometry.dllfileforusewithPostgreSQL9.0canbefoundintheDatabaseSupportdirectoryofyourArcGISclientinstallationdirectory.Movethest_geometry.dllfilefromtheArcGISclienttothePostgreSQLlibdirectoryonyourPostgreSQLserver.IfyouwillbeconnectingtoaPostgreSQL9.1database,usethest_geometry.dlllibraryfoundinthe9.1directoryinstead.IfyouwillbeconnectingtoaPostgreSQL9.2database,usethest_geometry.dlllibraryfoundinthe9.2directoryinstead.NoteNote:Ifyoudonotplacethecorrectst_geometry.dlllibraryinthePostgreSQLlibfolder,youwillnotbeabletocreateageodatabase.Alsonotethatthest_geometry.dllrequirestheMicrosoftVisualC++2008SP1RedistributablePackage(x64).IfthispackageisnotpresentonthePostgreSQLserver,downloaditfromtheMicrosoftsiteandinstallit.Createatablespaceinthedatabaseclusterinwhichtostoreyourdatabase.Ifyoudonotcreateatablespace,thepg_defaulttablespacewillbeused.Createadatabase,sdeuserandschema,andgeodatabasebydoingoneofthefollowing:RuntheCreateEnterpriseGeodatabasegeoprocessingtoolfromArcGISforDesktop(Standard.RunaPythonscriptfromacomputerrunningArcGISforDesktop(StandardorAdvanced),ArcGISEnginewiththeGeodatabaseUpdateextension,orArcGISforServerEnterprise(StandardorAdvanced).AnexamplescriptcanbecopiedfromScriptingdatabaseandgeodatabasecreationinPostgreSQLandalteredtorunatyoursite.Alternatively,youcanmanuallycreateadatabase,sdeuser,andschema,thenruntheEnableEnterpriseGeodatabasegeoprocessingtoolorPythonscripttocreateageodatabaseinthepre-createddatabase.Ifyoucompletelyfollowedtheinstructionaboveandstillexperiencetechnicaldifficulty,pleaserestartthepostgresqlserviceandseeifthatmakeanydifference.Or,youcansimplyrebootthewindowsserverandtryagain...