English

ArcGIS 10.1 SP1 for (Desktop, Engine, Server) PostgreSQL Versioning Patch

Summary

This patch addresses three situations that can be incurred while editing data on PostgreSQL through a versioning environment.

Description

Introduction

Esri® announces the ArcGIS 10.1 SP1 for (Desktop, Engine, Server) PostgreSQL Versioning Patch. This patch addresses three situations that pertain specifically to a versioning environment on PostgreSQL. In two situations, states may be lost or incorrectly returned through a version. In the third scenario, a user may not be able to unregister a feature class as versioned with the option to compress. It deals specifically with the issues listed below under Issues Addressed with this Patch.

Issues Addressed with this Patch


  • NIM090555 - With a high volume of edits, data loss may occur during a geodatabase compression.
  • NIM089024 - Added logic that creates and releases savepoints on a cursor for Replication in certain circumstances.
  • NIM091439 - Unregistering a versioned feature class with the option, "Compress all edits in the Default version into the base table" chosen in the Unregister as Versioned dialog will fail.

Files Installed in this Patch


Under the Windows <ArcGIS Product Installation Directory>\bin folder:
    gsrvrpg101.dll
    sde.dll
    sdepgsrvr101.dll
Under the Linux <ArcGIS for Server Installation Directory>/bin folder:
    gsrvrpg101.dll
    sde.dll
    sdepgsrvr101.dll
Under the Linux <ArcGIS Engine Installation Directory>/bin folder:
    libgsrvrpg101.so
    libsde.a
    libsde.so
    libsdepgsrvr101.so

Installing this patch on Windows

Installation Notes:

System Administrators: A technical paper is available that discusses the enterprise deployment of ArcGIS 10.1 setups using Microsoft Systems Management Server (SMS), System Center Configuration Manager (SCCM), and Group Policy, including additional system requirements, suggestions, known issues, and Microsoft Software Installation (MSI) command line parameters. Deployment in a lockdown environment is also covered. ArcGIS 10.1 Enterprise Deployment.

Enterprise geodatabase upgrades:

You must upgrade geodatabases in the following database management systems. Geodatabase upgrades are run from an ArcGIS client. Therefore, you must apply ArcGIS 10.1 SP1 for (Desktop, Engine, Server) PostgreSQL and Parcel Editing Performance Patch and then the ArcGIS 10.1 SP1 for (Desktop, Engine, Server) PostgreSQL Versioning Patch before upgrading your geodatabase. See the topic specific to your DBMS and its related links for instructions to upgrade a geodatabase:

Installation Steps:

ArcGIS 10.1 Service Pack 1 for Desktop, Engine, or Server and the ArcGIS 10.1 SP1 for (Desktop, Engine, Server) PostgreSQL and Parcel Editing Performance Patch must be installed before installing this patch.

  1. Download the appropriate file to a location other than your ArcGIS installation location.

  2.     Checksum
    ArcGIS for Desktop ArcGIS-101SP1-DT-PSQLV-Patch.msp D558EBACE6E782F51B913783DEA7161D
         
    ArcGIS Engine ArcGIS-101SP1-E-PSQLV-Patch.msp 6F84C5AE101296E0F897DF2B5D8B9311
         
    ArcGIS for Server ArcGIS-101SP1-S-PSQLV-Patch.msp B6940275F4EB0A8A07AB9B94C87188A6

  3. Make sure you have write access to your ArcGIS installation location.

  4. Double-click ArcGIS-101SP1-<Product>-PSQLV-Patch.msp to start the install process.

    NOTE: If double clicking on the MSP file does not start the Patch installation, you can start the Patch installation manually by using the following command:

    msiexec.exe /p [location of Patch]\ArcGIS-101SP1-<Product>-PSQLV-Patch.msp


Installing this patch on Linux

Installation Notes:

Enterprise geodatabase upgrades:

You must upgrade geodatabases in the following database management systems. Geodatabase upgrades are run from an ArcGIS client. Therefore, you must apply ArcGIS 10.1 SP1 for (Desktop, Engine, Server) PostgreSQL and Parcel Editing Performance Patch and then the ArcGIS 10.1 SP1 for (Desktop, Engine, Server) PostgreSQL Versioning Patch before upgrading your geodatabase. See the topic specific to your DBMS and its related links for instructions to upgrade a geodatabase:

Installation Steps:

Complete the following install steps as the ArcGIS Install owner. The Install owner is the owner of the arcgis folder.

ArcGIS 10.1 Service Pack 1 for Desktop, Engine, or Server and the ArcGIS 10.1 SP1 for (Desktop, Engine, Server) PostgreSQL and Parcel Editing Performance Patch must be installed before installing this patch.

  1. Download the appropriate file to a location other than your ArcGIS installation location.


        Checksum
    ArcGIS Engine ArcGIS-101SP1-E-PSQLV-Patch-lx.tar 479E2A97A30AD1F31773B4A5D01F51F2
         
    ArcGIS for Server ArcGIS-101SP1-S-PSQLV-Patch-lx.tar BE7706C1535B0C515EF902AB6C6402B2

  2. Make sure you have write access to your ArcGIS installation location, and that no one is using ArcGIS.

  3. Extract the specified tar file by typing:

    % tar -xvf ArcGIS-101SP1-<Product>-PSQLV-Patch-<Platform>.tar

  4. Start the installation by typing:

    % ./applypatch

    This will start the dialog for the menu-driven installation procedure. Default selections are noted in parentheses ( ). To quit the installation procedure, type 'q' at any time.

Patch Updates

Check the Patches and Service Packs page periodically for the availability of additional patches. New information about this patch will be posted here.

Update 02/14/2013: PostgreSQL users only; After installing this patch, geodatabase replication may stop working with PostgreSQL geodatabases. This issue is resolved by installing the ArcGIS 10.1 SP1 for (Desktop, Engine, Server) Geodatabase Replication for PostgreSQL Patch.

How to identify which patch is installed

To determine which ArcGIS products are installed, Choose the appropriate version of the PatchFinder utility for your environment and run it from your local machine.

Getting Help

Domestic sites, please contact Esri Technical Support at 1-888-377-4575, if you have any difficulty installing this patch. International sites, please contact your local Esri software distributor.