darksabersan Posted September 19, 2014 Report Share Posted September 19, 2014 Hi guys,I need your help to configure PostgreSQL and ArcCatalog.First, the technical details about my installation:Based on Windows Se7en x64I've installed PostgreSQL 9.0.18 as Geo Database in order to use QGIS 2.4.0 and all was fine.Why PostgreSQL 9.0.5? Just simply because I have ArcGIS Desktop 10.1 and I put the Client Libraries 9.0.5 inside "C:\Program Files (x86)\ArcGIS\Desktop10.1\bin"Now, when I want to connect in ArcCatalog then the problem appear (even with localhost as Instance info). I know that is possible to do so even without ArcSDE. All comments and helps are welcome! darksabersan. Quote Link to comment Share on other sites More sharing options...
Lurker Posted September 19, 2014 Report Share Posted September 19, 2014 please explain in english the sentences after FATAL, it looks like in france have you try to check the postgresql log for this error? maybe you will find interesting clue Quote Link to comment Share on other sites More sharing options...
darksabersan Posted September 19, 2014 Author Report Share Posted September 19, 2014 please explain in english the sentences after FATAL, it looks like in france have you try to check the postgresql log for this error? maybe you will find interesting clue [FATAL: the databaseSQL state: ] Where is the postgreSQL log file? I am completely new with it. Quote Link to comment Share on other sites More sharing options...
Lurker Posted September 20, 2014 Report Share Posted September 20, 2014 you may set logging via eventlog , but first you need to set up postgresql.conf. see here for detail : http://www.postgresql.org/docs/9.0/static/runtime-config-logging.html http://gorthx.wordpress.com/2012/02/24/postgres-logging-on-windows/ Quote Link to comment Share on other sites More sharing options...
bdsmolla Posted September 20, 2014 Report Share Posted September 20, 2014 Interesting topic. I also like to learn it! Quote Link to comment Share on other sites More sharing options...
adnan0001 Posted September 20, 2014 Report Share Posted September 20, 2014 Hi.. I made a video for database connection using sqlserver for arcgis You have a look.. Thanks Quote Link to comment Share on other sites More sharing options...
darksabersan Posted September 20, 2014 Author Report Share Posted September 20, 2014 Hi adnan0001, Thank you for your SQLServer Connection Tutorial, but I'm looking more specifically for PosgreSQL. Until now, I didn't found something to solve my issue. darksabersan. Quote Link to comment Share on other sites More sharing options...
Team_Evil Posted September 20, 2014 Report Share Posted September 20, 2014 darksabersan, you need first to licensed your version of arcsde otherwise arcatalog wont connect through porstgresql..While you get the license you need to enable the geodb feature in arccatalog, by inserting the location of the license file with extension .ecp Quote Link to comment Share on other sites More sharing options...
adnan0001 Posted September 20, 2014 Report Share Posted September 20, 2014 yes .. It is shown in my video plz watch.. The steps for oracle , sql n postgre for connecting are same i think soo... thanks Quote Link to comment Share on other sites More sharing options...
bdsmolla Posted September 20, 2014 Report Share Posted September 20, 2014 I think darksabersan not asked anything related to Esri Enterprise Geodatabase which is in fact refer to ArcSDE, he probably likes to configure the following thing: http://www.esri.com/library/whitepapers/pdfs/how-to-set-up-geoportal-server-122.pdf interesting notes are below: http://northredoubt.com/n/2013/08/22/postgresqlpostgis-and-arcgis-arcmap-10-2/ 2 Quote Link to comment Share on other sites More sharing options...
infinity007 Posted September 20, 2014 Report Share Posted September 20, 2014 Hi guys, I need your help to configure PostgreSQL and ArcCatalog. First, the technical details about my installation: Based on Windows Se7en x64 I've installed PostgreSQL 9.0.18 as Geo Database in order to use QGIS 2.4.0 and all was fine. Why PostgreSQL 9.0.5? Just simply because I have ArcGIS Desktop 10.1 and I put the Client Libraries 9.0.5 inside "C:\Program Files (x86)\ArcGIS\Desktop10.1\bin" Now, when I want to connect in ArcCatalog then the problem appear (even with localhost as Instance info). I know that is possible to do so even without ArcSDE. All comments and helps are welcome! darksabersan. Try to write following in Instance: localhost,5432 Hope it will work. In my PC it works. 1 Quote Link to comment Share on other sites More sharing options...
darksabersan Posted September 21, 2014 Author Report Share Posted September 21, 2014 Thank you adnan0001 for your video, bdsmolla for the interesting links and infinity007 for the trick. Finally it works. Instance: localhost,5432 (was the solution) And It is also really important to take care about the naming convention. I mean no capital or mixed letters (Upper and Lower). i.e: My_Database MY_DATABASE but: my_database darksabersan. 1 Quote Link to comment Share on other sites More sharing options...
adnan0001 Posted September 21, 2014 Report Share Posted September 21, 2014 You are most welcome.. If possible try to make a short video for installation of postgre sql n configuration of it n how ti connect it at enterprise level.. Quote Link to comment Share on other sites More sharing options...
infinity007 Posted September 21, 2014 Report Share Posted September 21, 2014 No problem! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.