ArcGIS SDE 10.1 For postgresql service connection Configuration

Last year, I wrote ArcGIS 10.1 how to connect to PostgreSQL database (http://blog.csdn.net/arcgis_all/article/details/8202709). At that time, the default direct connection method of ArcGIS 10.1 was adopted. In the communication with the customer, I learned that the customer still wants to use the connection method of the service, here, I will record how to use the service connection method in the form of a document, hoping to help you.
SP1 must be installed to support PostgreSQL databases of the 10.1 series during ArcGIS 9.1. This is a hard requirement. ArcGIS 10.2 will be released soon. In ArcGIS 10.2, more options are available for PostgreSQL database support, including 9.0 series, 9.1 series, and 9.2 series PostgreSQL databases. The benefits of this are self-evident.
1. installation environment

2 Installation Process
2.1 create an SDE user
To install SDE on Linux, you must create an operating system account named SDE. This account will be responsible for SDE startup, stop, and other operations. The command is as follows:

Upload the SDE software to Linux. You can use SSH or FTP to directly mount the ISO file on the VM. Here, I directly upload the required file (pg_64) to Linux and put it in the/var/SDE directory to ensure that the SDE user has read and write permissions on this folder, use the SDE user to enter the/var/SDE/pg_64 directory and perform the following operations:

Note: SDE is changed in 10.1 (SDE is composed of application server and command line tools. The latter is an optional part, and the latter can be operated through the command line ), only the application server is installed here. You can install SDE as prompted (installation directory:/var/pgsde /).
2.2 configure Environment Variables
Write the environment information of SDE and PostgreSQL in the/home/SDE/. bash_pfofile file, as follows:

It indicates that sdehome is the home directory of Sde installation, and pghome is the home directory of PostgreSQL.
2.3 edit the services. Sde file and/etc/services file
Set services under the $ sdehome/etc directory. remove "#" in front of esri_sde In the SDE file. The following 5151 is the SDE service port. You can modify it as needed. Here I keep the default value and the final result is as follows:

Use the root user to add the same content in the/etc/services file and the service. Sde file, as follows:

2.4 copy st_geometry.so

Copy \ databasesupport \ PostgreSQL \ linux64 st_geometry.so in the ArcGIS for desktop installation directory or ArcGIS for Server installation directory to $ pghome/lib/PostgreSQL /, make sure that the SDE user applies to the ST _ geometry. so has 755 permissions.

Note: In Windows, copy st_geometry.dll under Windows 64 to the lib directory installed in PostgreSQL.
If you do not copy this file, the following error occurs during database creation:

2.5 create an SDE Database

Because ArcGIS for desktop is 32-bit, a 32-bit database client is required to connect to a 64-bit database. Therefore, you must install a 32-bit database client on the machine of ArcGIS for desktop, for more information, see (http://blog.csdn.net/arcgis_all/article/details/8202773)
Use the Create enterprise Geodatabase tool to create SDE In ArcMap, as shown below:

2.6 start the service
After the SDE database is created, run the sdemon-o start command on Linux to start the service. For example:

The above error may occur. libssl. so.6 cannot be found. You can use the following two commands (switch to the root user ):
In-SF/usr/lib64/libssl. so.10/usr/lib64/libssl. so.6
Ln-SF/usr/lib64/libcrypto. so.10/usr/lib64/libcrypto. so.6

Then run the sdemon-o start command again, for example:

You can view the status, because there is no database connection, the value 0 is displayed here, as shown below:

2.7 create an ArcSDE connection file
Use the create ArcSDE connection file tool to create an ArcSDE connection file, for example:

2.8 import data
After the file is successfully created, find the file in catlogu and import a data file, for example:

2.9 use pgadmin to view
Use the pgadmin client to connect to the PostgreSQL database. You can see that the SDE database and the data you just imported are already in use.