Creating an ArcSDE service on Windows using the sdeservice command

You can create and register an ArcSDE service on Windows servers using the ArcSDE for PostgreSQL Post Installation wizard. However, you can also create a service from an MS-DOS prompt using the sdeservice command. That process is described in this topic.

You must first execute the sdeservice command with the create operation, then execute the sdeservice command with the register operation to specify to which database this new service will be used.

The syntax to execute this against a geodatabase in PostgreSQL is as follows:

sdeservice -o create -d POSTGRESQL,PGINSTANCE -i <service> –p <ArcSDE_admin_password> 
[–n] [–H <sde_directory>] [–u <service_user>] [–P <service_user_password>] 
[–s <data_source>]

sdeservice -o register -d POSTGRESQL,PGINSTANCE -r ADMIN_DATABASE 
-v <registry_value> -i <service> -p <ArcSDE_admin_password>

The contents in brackets ([ ]) are optional depending on your situation. For more information on using the sdeservice command, see the sdeservice command topic in the Administration Command Reference provided with the ArcSDE component of ArcGIS Server at the Enterprise level.

Steps:

1. Open an MS-DOS command prompt window on a computer from which you have access to the ArcSDE commands.
2. Type the sdeservice command with the create operation.

   sdeservice -o create -d POSTGRESQL,pgsql -i sdesvc -p nomira -s myserver

   Note:

   If you do not specify a name with the –i option, the default name of esri_sde is used.

   This step creates a registry key for that service.

3. Type the sdeservice command with the register operation.

   sdeservice -o register -d POSTGRESQL,PGINSTANCE -r ADMIN_DATABASE 
   -v mygdb -i sdesvc -p nomira

   This creates an ADMIN_DATABASE value in the registry for the service.