I cannot connect to postgresql 9.0.5 with ArcSDE 10.1, using ArcCatalog 10.1 on Win 7 professional 64 bit.
I followed the steps described here, and installed the Pg-Agent from Stack builder. When I execute "Create Enterprise Geodatabase", I set "instance" to "localhost:5432", but I got this error:
Cannot connect to database because the database client software failed to load. Be sure the database client software is installed and configured correctly.
Failed to execute (CreateEnterpriseGeodatabase).
I've made sure that the service is running and restarted the whole machine after these installations, but it still gives me the error.
Any help, please?
Best Answer
I may be too late, but in case someone else comes across this forum for the same problem (as I did ;)). This is because you have to install the correct files for your client: http://resources.arcgis.com/en/help/main/10.1/index.html#/Setting_up_a_connection_to_PostgreSQL/002p0000003q000000/.
It took me a while to figure this out as the ESRI online documentation is a labyrinth.