Installing ArcSDE and PostgreSQL on separate Windows servers

If you are installing both ArcSDE and PostgreSQL on separate servers that each have a Windows operating system (OS), you can first run the installation executable on the PostgreSQL server to install PostgreSQL, then run the executable on the ArcSDE server to install ArcSDE. You must manually perform the database and postinstallation setup.

Note:

You must be a Windows administrator on the server to install software.

Steps:

1. Make sure the ArcSDE server meets the requirements for ArcSDE installation and the PostgreSQL server meets the requirements for a PostgreSQL installation. This includes making sure an older version of PostgreSQL does not already exist on the PostgreSQL server.
2. Access the ArcSDE installation files on the PostgreSQL server.
   • If you have a DVD, place it in the appropriate drive on the server.
   • If you have an ISO image, use an ISO extractor to access the files.
3. Run the executable for ArcSDE for PostgreSQL installation for Windows.
4. When you get to the Installation Options dialog box, uncheck ArcSDE for PostgreSQL and just install the PostgreSQL software on this server.
5. Follow the instructions in Installing PostgreSQL on Windows to complete the PostgreSQL installation.
6. Configure the PostgreSQL database cluster to accept client connections. See Configuring a PostgreSQL database cluster on Windows to accept client connections for instructions.
7. Create a role named sde in the PostgreSQL database cluster using either psql or a PostgreSQL administration tool, such as pgAdminIII.
8. Grant the sde user super user permissions. If granting through pgAdminIII, also grant the sde user the privilege to modify a catalog directly.
9. Create a database in the PostgreSQL database cluster using either psql or one of the PostgreSQL administration tools. Make the sde user the owner of the database.
   Note:

   If you will be using the PostGIS geometry type, be sure the database is created from the PostGIS template.

10. Create a schema named sde in your newly created database. Make the sde user the owner of the schema.
11. Grant USAGE on the sde schema to the public role or to each group and role you add to the geodatabase.
12. Either remove the installation DVD from the PostgreSQL server's drive and insert it into the drive on the ArcSDE server or move the ISO image from the PostgreSQL server to the ArcSDE server.
13. Run the ArcSDE for PostgreSQL on Windows installation again, this time uncheck PostgreSQL on the Installation Options dialog box and only install ArcSDE.
14. Follow the instructions in Installing ArcSDE for PostgreSQL on Windows to install ArcSDE using the wizard.
15. Do not proceed with the Post Installation wizard.

    When ArcSDE is finished installing, you are prompted to run the Post Installation wizard. Cancel out of this.

16. Copy the st_geometry.dll file and, if you are going to use ST_Raster, the libst_rasterpg.dll file from the SDEHOME\bin on the ArcSDE server to the lib folder in PostgreSQL home on the database server.
17. Copy the following files from the lib folder in PostgreSQL home to the SDEHOME\bin on the ArcSDE server: comerr32.dll, gssapi32.dll, k5sprt32.dll, krb5_32.dll, libeay32.dll, libiconv2.dll, libintl3.dll, libpq.dll, and ssleay32.dll.
18. Set the PGHOST and PGPORT environment variables in the dbinit.sde file in the SDEHOME/etc directory on the server where ArcSDE is installed.

    PGHOST is the name of the server on which PostgreSQL is installed. PGPORT is the port number through which the PostgreSQL postmaster process is listening. See The dbinit.sde file for information on setting variables in this file.

19. Run the sdesetup command as the sde user to create the ArcSDE geodatabase repository and authorize the software.

    sdesetup -o install -d POSTGRESQL 
    -s <DBMS_server_name> -D <database_name> 
    -l <authorization_key> -u sde
    

20. If you will be using an ArcSDE service, add the name and port number for the ArcSDE service to the Windows services file and the ArcSDE services.sde file.
    Note:

    You must be an administrator on the server to alter the Windows services file.

21. If using an ArcSDE service, see Creating an ArcSDE service from a remote Windows server.
22. Run the sdemon command to start the service if you are using one.

    sdemon -o start -i <ArcSDE_service_port_number>
    

See the ArcSDE Administration Command Reference provided with ArcGIS Server Enterprise for details on using the sdesetup and sdemon commands.