Connect my enterprise Geo DB on my C drive to another PC in the same network?

889
3
Jump to solution
12-23-2021 01:13 PM
DeorajRamsaran4
New Contributor III

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
0 Kudos
1 Solution

Accepted Solutions
jcarlson
MVP Honored Contributor

It's definitely possible, though certainly sub-optimal. If it's just for internal use and you only have a handful of people who need to access the database, it's probably fine.

My first suggestion was already covered in one of the articles you linked, to make sure the pg_hba.conf file is set up correctly. You also ought to make sure that you don't have other firewall settings on your computer that could be limiting this.

Another suggestion: check in your Pro settings how the DB connection is stored. Is it connecting via an IP address?

From the other machines in the network, try to ping the machine generally, and also ping the specific port. That will tell you whether or not your machines are communicating.

- Josh Carlson
Kendall County GIS

View solution in original post

3 Replies
jcarlson
MVP Honored Contributor

It's definitely possible, though certainly sub-optimal. If it's just for internal use and you only have a handful of people who need to access the database, it's probably fine.

My first suggestion was already covered in one of the articles you linked, to make sure the pg_hba.conf file is set up correctly. You also ought to make sure that you don't have other firewall settings on your computer that could be limiting this.

Another suggestion: check in your Pro settings how the DB connection is stored. Is it connecting via an IP address?

From the other machines in the network, try to ping the machine generally, and also ping the specific port. That will tell you whether or not your machines are communicating.

- Josh Carlson
Kendall County GIS
DeorajRamsaran4
New Contributor III

Thank you I will give it a try. And yes it's only for internal use between me and the three specialist so we are not stuck waiting to edit on all the work we need to do. I think I will check with my IT and make sure we are all connected. I have been using the articles I posted to help me so far, only issue is getting the other machines to connect to it. One I am back in the office I will get a snap shot of the error. Thank you! 

Deoraj Ramsaran
0 Kudos
DeorajRamsaran4
New Contributor III

Hello J just wanted to let you know I was able to get the small the enterprise GDB to work. Once all the steps where completed the last piece I was missing was adding my cpu IP address to the instance along with the port number. I used the option to only allow my 2 GIS staff to read from the disk, but considering we will be waiting for another 9-12 months for the servers. This has been a big help in allowing all three of us to be able to edit in a multi-user DB. 

Deoraj Ramsaran
0 Kudos