972
社区成员
发帖
与我相关
我的任务
分享求大神解答，我安装了ARCgis10.2，安装了postgresql-9.0.18-2-windows，进行连接，出现问题
我安装了ARCgis10.2，安装了postgresql-9.0.18-2-windows，进行连接，出现问题，提示
You must copy the latest ST_GEOMETRY and dependent libraries to the PostgreSQL software location. Refer to the ArcGIS help topics for more details.
已连接的 RDBMS 实例未针对 Esri 空间类型配置进行相应设置。
执行(CreateEnterpriseGeodatabase)失败。
我已经将st_geometry.dll放在了具体位置， libeay32.dll、libintl.dll、libpq.dll 和 ssleay32.dll也放在了指定位置，求大神解答
You must copy the latest ST_GEOMETRY and dependent libraries to the PostgreSQL software location. Refer to the ArcGIS help topics for more details.
已连接的 RDBMS 实例未针对 Esri 空间类型配置进行相应设置。
执行(CreateEnterpriseGeodatabase)失败。
我已经将st_geometry.dll放在了具体位置， libeay32.dll、libintl.dll、libpq.dll 和 ssleay32.dll也放在了指定位置，求大神解答
...全文
请发表友善的回复…
发表回复
fatstrongfatfat 2015-07-27
- 打赏
- 举报
抱歉打扰您了，我想问下那个postgresql连接arcgis 我也出现了和您一样的问题 想问下后来您解决了么 ？
qingyimengwu 2015-01-14
- 打赏
- 举报
出现你这个问题要确定下一下几个 问题：1、pg 32位dll文件是否正确复制到了desktop的 bin文件夹下 2、desktop自带的数据库支持文件是否正确的放到pg lib文件夹下。这里最重要的是版本一定要对应好 9.1 9.2 9.0 你拷贝不对肯定通不过的
小笨和漂向北方 2014-12-24
- 打赏
- 举报
first of all, I will NOT recommend installing PostgreSQL on a Windows Server at all. It works better on a Unix/Linux system.
Second, please following the instruction on ESRI website for this procedure:
Setting up a geodatabase in PostgreSQL on a Windows server
The following is a summary of the steps you take to create a geodatabase in PostgreSQL on Windows:
Obtain and install a supported release of PostgreSQL and configure the database cluster.
You can download PostgreSQL installations from the Esri Customer Care portal. If you use this installation, no specific nondefault settings are needed to use PostgreSQL with ArcGIS. Just be sure to change the locale and location settings if you want to use those other than the default.
Alternatively, you can obtain the PostgreSQL installation yourself. See the documentation on the PostgreSQL website for instructions on installing and configuring PostgreSQL.
Configure the database cluster to accept connections.
This includes altering the pg_hba.conf file to allow the database cluster to accept remote connections.
Install the ArcGIS client from which you will create the geodatabase.
Download the PostgreSQL client libraries (if your ArcGIS client is on Windows) or RPM (if your ArcGIS client is on Linux) from the Esri Customer Care portal and place them in the bin directory of the ArcGIS client you installed in the last step. See Setting up a connection to PostgreSQL for more information.
Copy the st_geometry library to the PostgreSQL installation directory.
The st_geometry.dll file for use with PostgreSQL 9.0 can be found in the DatabaseSupport directory of your ArcGIS client installation directory. Move the st_geometry.dll file from the ArcGIS client to the PostgreSQL lib directory on your PostgreSQL server.
If you will be connecting to a PostgreSQL 9.1 database, use the st_geometry.dll library found in the 9.1 directory instead.
If you will be connecting to a PostgreSQL 9.2 database, use the st_geometry.dll library found in the 9.2 directory instead.
NoteNote:
If you do not place the correct st_geometry.dll library in the PostgreSQL lib folder, you will not be able to create a geodatabase.
Also note that the st_geometry.dll requires the Microsoft Visual C++ 2008 SP1 Redistributable Package (x64). If this package is not present on the PostgreSQL server, download it from the Microsoft site and install it.
Create a tablespace in the database cluster in which to store your database. If you do not create a tablespace, the pg_default tablespace will be used.
Create a database, sde user and schema, and geodatabase by doing one of the following:
Run the Create Enterprise Geodatabase geoprocessing tool from ArcGIS for Desktop (Standard.
Run a Python script from a computer running ArcGIS for Desktop (Standard or Advanced), ArcGIS Engine with the Geodatabase Update extension, or ArcGIS for Server Enterprise (Standard or Advanced). An example script can be copied from Scripting database and geodatabase creation in PostgreSQL and altered to run at your site.
Alternatively, you can manually create a database, sde user, and schema, then run the Enable Enterprise Geodatabase geoprocessing tool or Python script to create a geodatabase in the pre-created database.
If you completely followed the instruction above and still experience technical difficulty, please restart the postgresql service and see if that make any difference. Or, you can simply reboot the windows server and try again...
