nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Connection to PostgreSQL no longer workd

DennisFalkenberg

We have a postgres server (9.2 with PostGIS 2.0.3) that we are trying to connect to with ArcGIS 10.2. All the files from the Customer Care portal have been downloaded (the 32 bit version) and copied to the bin folder on the local pcs. The connetion was working fine for one day & then the next morning the user name and passwords could not be found. Any ideas on what may be happening? The pg_hba.conf allows for all County users (which would be the users in question) are allowed access to the server.
Thanks - Dennis

Find more posts tagged with

Accepted answers

KimPeter

Is it possible that the IP addresses changed for the machines that can no longer connect?

All comments

DennisFalkenberg

Thanks for your help guys.
I have found what the trouble was. The IT Department made some changes to the network, which changed the ranges of the IP addresses for some computers. They gave me the new IPs to cover all the possible addresses, I put them in the pg_hba.conf file and all connections are happy once again.
Thank you for your time & help - Dennis

KimPeter

Is it possible that the IP addresses changed for the machines that can no longer connect?

VinceAngelo

The question that needs to be asked anytime functionality suddenly changes is:
What changed on the PostgreSQL server?

- V

DennisFalkenberg

Thanks Nidhin,
We did check the save username and password the first day when the connection was allowed.
In the C:\Users\[username]\AppData\Local\Temp\sdedc_PostgreSQL.log file, the following error is reported:

CAN'T OPEN INSTANCE: sde:postgresql.
Spatial Engine Connection Failed (-9).
Cannot Get Access to Instance sde:postgresql

The most "odd" part of this to me is that the connection worked one day for many users, but then failed to connect the next day. I have been able to maintain access to the postgresql server throughout, but other users have lost it.

NidhinKarthikeyan

The connetion was working fine for one day & then the next morning the user name and passwords could not be found. Any ideas on what may be happening?

'Save username and password' check box would be unchecked in ArcSDE Connection Properties. Provide the username/password, check the 'Save username and password' check box and connect to the database.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.