arcgis添加postgresql的连接 - cytggit/Map-openlayers GitHub Wiki

  1. 拷贝 C:\Program Files (x86)\PostgreSQL\9.3\bin【PG Bin路径】下的libeay32.dll, libiconv-2.dll, libintl-8.dll, libpq.dll, and ssleay32.dll到C:\Program Files (x86)\ArcGIS\Desktop10.2\bin

  2. 拷贝 C:\Program Files (x86)\ArcGIS\Desktop10.2\DatabaseSupport\PostgreSQL\9.2\Linux64下的st_geometry.so到/usr/pgsql-9.2/lib/postgresql

  3. 如果没有安装postGIS而是下载了PostGIS Shp2PgSQL Graphical Loader的话就把下载包里的postgisgui文件夹放到【PG Bin路径】下,然后修改安装pgAdmin文件夹下的plugins.ini文件,在该文件中添加如下几行:

     ;
     ; PostGIS shp2pgsql-gui (Windows):
     ;
     Title=PostGIS Shapefile and DBF loader
     Command="$$PGBINDIR\postgisgui\shp2pgsql-gui.exe" -h "$$HOSTNAME" -p $$PORT -U "$$USERNAME" -d "$$DATABASE" -W "$$PASSWORD"
     Description=Open a PostGIS ESRI Shapefile or Plain dbf loader console to the current database.
     KeyFile=$$PGBINDIR\postgisgui\shp2pgsql-gui.exe
     Platform=windows
     ServerType=postgresql
     Database=Yes
     SetPassword=Yes
    
  4. 重启pgAdmin后插件项就会出现

参考:http://blog.csdn.net/st5173413161/article/details/6169192