7

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?

Improve this question
5
  • The default port for postgresql is 5132. The port is defined in postgresql.conf (if i remember the file name correct).
    – Nicklas Avén
    Jul 15, 2012 at 15:51
  • BTW, 10.1? Is it some beta version?
    – Nicklas Avén
    Jul 15, 2012 at 15:53
  • 1
    yeah the default port is 5432 , i'm using ArcSDE Windows 1.01 build 129054 final version
    – geogeek
    Jul 15, 2012 at 16:05
  • Edit your pg_hba.conf file - you can verify this in pgAdminIII pgadmin.org/docs/dev/connect-error.html
    – Mapperz ♦
    Jul 16, 2012 at 13:17
  • there's no errors in Pgadmin or Pg Agent level , but error pop up when i try to make a geodatabase from ArcCatalog
    – geogeek
    Jul 16, 2012 at 13:31

1 Answer 1

Reset to default
10

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.

Improve this answer
2
  • 1
    I just sat in on a presentation at the Esri conference and they said this the most common mistake that users make in trying to set up the connection to a postgres database with ArcSDE.
    – RyanKDalton
    Jul 27, 2012 at 22:59
  • Thank you for this post, I have just used this information to download the client from the 'ESRI Customer Care portal' to allow a connection to ArcSDE 9.3.1 from a 10.1 client. Although the versions don't appear to match (8.3 vs 9.0.5) the installation was successful. It can be a little difficult to find the right file, it's under DBMS Support files.
    – Michael Stimson
    Sep 10, 2013 at 5:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.