English

How To: Install ArcSDE for PostgreSQL on SUSE 10

Summary

Installing ArcSDE for PostgreSQL on SUSE 10 results in an error, when creating a geodatabase.

ArcSDE for PostgreSQL is built on Red Hat 5 and certified on SUSE 10, resulting in PostgreSQL client libraries having a dependency on Red Hat 5 specific operating system libraries. Substituting the PostgreSQL client libraries supplied with ArcSDE with the libraries already present on SUSE 10 from the PostgreSQL installation resolves the error.

Procedure

Following the documentation to install ArcSDE for PostgreSQL on SUSE 10 results in errors, when creating a geodatabase.

Code:
sdesetup -o install -d POSTGRESQL -u sde -p sde -D dbname -l Server10_Ent_Adv.ecp

ESRI ArcSDE Server Setup Utility Thu Apr 8 17:25:27 2010
------------------------------------------
Error: libssl.so.6: cannot open shared object file: No such file or directory
Error creating ArcSDE direct connection (-324)


Follow the steps below to resolve the error.

  1. Install PostgreSQL:
    Follow the instructions in the PostgreSQL documentation to install PostgreSQL.
    Among other things, the installation creates PostgreSQL client libraries (libpq.so*) with dependencies specific to SUSE 10.
  2. Install ArcSDE for PostgreSQL:
    Follow the instructions in the ArcSDE for PostgreSQL installation guide to install ArcSDE.
    The installation places libpq libraries in the SDEHOME lib location. These libraries are compiled on Red Hat 5 Linux, and therefore depend on libraries specific to Red Hat 5 Linux and will not work on SUSE 10. They must be replaced with libraries from the PostgreSQL lib directory.
  3. Copy libpq.so* libraries:
    As the sde user, copy the libpq.so* libraries from the PostgreSQL lib location to the SDEHOME lib location.

    Note:
    If the default installation location is being used, the following is the location of the PostgreSQL lib location: /usr/local/pgsql/lib


    Note:
    If the default installation location is being used, the following is the SDEHOME lib location: /home/sde/sdeexe100/lib


    The libpq libraries to copy:
    libpq.so
    libpq.so.5
    libpq.so.5.1
  4. Proceed with the geodatabase setup as described in the ArcSDE for PostgreSQL installation guide.

Related Information