Esri / Esri/ops-server-config

When creating the SDE connection file during the install include fully qualified domain name of database server

Open
#634 2 comments 0 reactions 0 assignees View on GitHub
B - Bug G - Release Team Install and Publishing
Dominant language
Python
Stars
33
Forks
12
PR merge metrics
No merged PRs in 30d

Description

Currently, the PostgreSQL SDE connect files that are created during the install process only include the name of the machine and not the fully qualified name. Under certain deployment scenarios, you can't connect to the PostgreSQL databases from a client machine unless the "instance" property in the connection file references the fully qualified domain name.

Contributor guide

Open the contributing guide

Research direction

Trace the install process that creates PostgreSQL SDE connection files and find where the database machine name is written to the instance property. Confirm the expected fully qualified domain name behavior for client connections; done means newly created connection files use the database server FQDN and connect successfully in the affected deployment scenarios.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python
Domain
databases, devops
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
42/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.