English

How To: Make a Direct Connection from ArcGIS Server or ArcGIS Engine Runtime on SUSE to ArcSDE for PostgreSQL

Summary

To make a direct connect from ArcGIS Server or ArcGIS Engine Runtime installed on SUSE Linux 10 to an ArcSDE for PostgreSQL geodatabase installed on Red Hat Linux (RHEL) 5 or SUSE 10, follow the procedures below.

The ArcGIS Server and ArcGIS Engine RunTime installation contains libpq libraries in the bin directory. By design, these libraries are compiled on RHEL 5 and are therefore specific to RHEL 5, which do not work on SUSE 10. They must be replaced with SUSE 10 libpq libraries from the PostgreSQL client lib directory (on the SUSE 10 machine) to make a direct connect to ArcSDE for PostgreSQL. These libraries are created when the PostgreSQL client is compiled on SUSE 10.

The reason for this issue is ArcSDE for PostgreSQL is built on RHEL 5 and certified with SUSE 10. Because ArcSDE for PostgreSQL is compiled on RHEL 5, PostgreSQL client libraries have a dependency on specific RHEL 5 operating system libraries.

Procedure

Follow the appropriate step based on your system configuration below.

  • Scenario A: ArcGIS Server or ArcGIS Engine installed on SUSE 10 and ArcSDE for PostgreSQL installed on SUSE 10

    1. Copy new libpq.so* libraries from ArcSDE for PostgreSQL to the client's (ArcGIS Server, ArcGIS Engine) bin directory.

    Note:
    Optionally, obtain the source files from the PostgreSQL Web site or the one-click installer from EnterpriseDB, and install PostgreSQL. Follow the instructions provided by PostgreSQL and refer to ArcSDE 10 PostgreSQL Database Requirements. After installing PostgreSQL on SUSE 10, copy the libpq.so* libraries from the PostgreSQL lib directory to the ArcGIS client’s bin directory.


    2. For ArcGIS Server only, stop ArcGIS Server.
    3. cd to the ArcGIS Server or ArcGIS Engine bin directory. Backup the three libpq.so* files (a backup of libpq.a is not needed).
    4. As the ArcGIS Server or ArcGIS Engine user (not root), copy the libpq.so* libraries (not including libpq.a) from the PostgreSQL lib location to the ArcGIS Server bin location. To determine the PostgreSQL lib location, log in as the postgres user, type 'pg_config', and look at the PKGLIBDIR value.

    The libpq libraries are:

        •  libpq.so
    • libpq.so.5
    • libpq.so.5.1


    5. For ArcGIS Server only, start ArcGIS Server.
  • Scenario B: ArcGIS Server or ArcGIS Engine installed on SUSE 10 and ArcSDE for PostgreSQL installed on RHEL 5

    1. Obtain source files from the PostgreSQL Web site or the one-click installer from EnterpriseDB, and install PostgreSQL. Follow the instructions provided by PostgreSQL and refer to ArcSDE 10 PostgreSQL Database Requirements;http://help.arcgis.com/en/systemrequirements/index.html#//015100000075000000.
    After installing PostgreSQL on SUSE 10, copy the libpq.so* libraries from the PostgreSQL lib directory to the ArcGIS client's bin directory.

    2. For ArcGIS Server only, stop ArcGIS Server.

    3. cd to the ArcGIS Server or ArcGIS Engine bin directory. Backup the three libpq.so* files (backup of libpq.a is not needed).

    4. As the ArcGIS Server or ArcGIS Engine user (not root), copy the libpq.so* libraries (not including libpq.a) from the PostgreSQL lib location to the ArcGIS Server bin location. To determine the PostgreSQL lib location, log in as the PostgreSQL user, type 'pg_config', and then look at the PKGLIBDIR value.

    The libpq libraries are:

        • libpq.so
    • libpq.so.5
    • libpq.so.5.1


    5. For ArcGIS Server only, start ArcGIS Server.

Related Information