Hello all our city just aquired Esri enterprise system about a month ago. We currently have no servers, and not much of any hardware. However we will be getting budget for all of the below including managed cloud services. However that will take anywhere from 9-13 months. 🙄
So I was able to secure a very decent work station for my office and two mid level PC's for my gis Specialist, I am trying to improvise with what we have I was able to install Arc pro on my work station and arc map on both my employees PC. And they work great. Since we need to get to work like right now because all the GIS was in go old PDF format before I took over. I wanted to start of with planning a enterprise Geodatabase.
I was able to create a Development environment enterprise GDB dataBase on my local workstation using postgres 12 UI on my C drive. I Created the post GIS ext and created the necessary users and was able to load some layers into the Database using Arc pro. And it's working great. This is my first install from complete scratch do any advice is welcomed.
I created the project package on my PC using Pro and connected to the SDE database I created in postgres using local host port 5432 and the user name and password I created. I saved the project in my network drive under utilities directory in the S drive and saved the project in a GIS folder u there. All connections to the SDE worked fine when I open it.
But when my specialist tried to open the project on the network drive it opened up however the DB connection could not connect. When I open the pro project the layers and everything connects. But if one of my other staff tries to connect or open the project the DB is not connecting. I work for the city so we are on a local network. Fiber optic lines
So we don't need to share it with the entire world. I want to administer Postgresql from the local network and administer it on the same subnet. Is this possible since it's not on a server basically from one PC to another. I have tried the links below and have tried several different methods. If this is possible can anyone advise. I am trying to get to a point where we can all edit at the same time. Any thoughts would be greatly appreciated. GIS also has their own drive.
Just to be clear the SDE DB and postgres UI is installed on my work station. Originally it was just to test until I found out how long it is going to take for us to get servers and other equipment. So now I am trying to make use of what we have.
Any suggestions or resources would be greatly welcomed thank you all!
https://stackoverflow.com/questions/42378278/allow-access-to-postgresql-from-any-computer
https://www.microfocus.com/documentation/idol/IDOL_12_0/MediaServer/Guides/html/English/Content/Gett...
https://www.microfocus.com/documentation/idol/IDOL_12_0/MediaServer/Guides/html/English/Content/Gett...
https://radumas.info/blog/tutorial/2016/08/08/Migrating-PostgreSQL-Data-Directory-Windows.html
Thank you!! And happy holidays to everyone.
Deoraj Ramsaran