Select to view content in your preferred language

Behaviour of sdesetup option -s (ArcSDE 10 SP2 for Postgres)

1775
1
05-25-2011 04:52 AM
elright
Deactivated User
When I use sdesetup -o prerequisite_check, I am able to append ";pgport=5433" to option -s. However, if I do the same for sdesetup -o install, the utility reports in response to "Creating ST_GEOMETRY and ArcSDE schema . . . . .":

Connection to database 'test' failed.
could not translate host name "myserver;pgport=5433" to address: Unknown server error
Error: Underlying DBMS error (-51).
       SDE release install not completed.
Check SDEHOME\etc\sde_setup.log for more details.

Is it not logical to expect that in both cases sdesetup accepts -s with variables?
0 Kudos
1 Reply
tKasiaTuszynska
Regular Contributor
Hi El,
Yes, it would be logical to expect that if the -s can be given ;pgport=5433 in the prerequisite check operation it should be able to consume it in the install operation. I can reproduce your error, and logged a bug for it. We will be addressing it in SP3, sometime in the fall.
Sorry for the inconvenience, you can work around this issue by setting an environment variable called PGPORT and assigning it a value of 5433.
Sincerely,
Kasia
0 Kudos