Administering ArcSDE for PostgreSQL
Administering ArcSDE for PostgreSQL
Release 9.3
This topic contains links to administration concepts and instructions. Some of these are topics that apply to all database management systems; others are specific to ArcSDE for PostgreSQL.
Setting up the geodatabase
Be sure to read the
ArcSDE for PostgreSQL installation guide
for specific preinstallation, installation, and postinstallation setup steps for your operating system. The following are links to provide summaries and help with configuring the geodatabase.
Tuning tips to configure the DBMS to work with ArcSDE
PostgreSQL initialization parameters
Tuning memory in PostgreSQL
User logins and permissions
The ArcSDE administrative account
User permissions
User permissions for geodatabases in PostgreSQL
Installing ArcSDE for PostgreSQL
Installation summary for the ArcSDE component for PostgreSQL
Sample scripts provided with ArcSDE for PostgreSQL
Managing multiple ArcSDE component installations on the same machine
Using multiple geodatabases in PostgreSQL
Upgrade summary for ArcSDE geodatabases
Postinstallation setup
The following are topics about tuning the ArcSDE geodatabase repository creation:
The giomgr.defs file and the SERVER_CONFIG system table
ArcSDE initialization parameters
The dbinit.sde file
The dbtune file and the DBTUNE table
DBTUNE configuration keywords
Default configuration keywords specific to PostgreSQL
Composite configuration keywords
Making configuration keywords available in ArcGIS
The DATA_DICTIONARY keyword
PostgreSQL DATA_DICTIONARY keyword
The DEFAULTS keyword
PostgreSQL DEFAULTS keyword
Log file configuration options
Log file keywords
LOGFILE_DEFAULTS for PostgreSQL
DBTUNE configuration parameter name-configuration string pairs
PostgreSQL DBTUNE configuration parameters
These topics discuss other geodatabase setup configurations:
Language support in the geodatabase
Language support for PostgreSQL
XML columns in the geodatabase
Configuring a PostgreSQL database to support XML columns
Making connections to the geodatabase
The following are general topics about connecting to a geodatabase:
An overview of ArcSDE geodatabase connections
Compatibility between clients and geodatabases
ArcSDE connection syntax
Creating spatial database connections
These topics are specific to making connections using an ArcSDE service:
Starting an ArcSDE service
Stopping an ArcSDE service
Pausing and resuming an ArcSDE service
Accessing an ArcSDE service through a firewall
Displaying ArcSDE service statistics and session information
Removing ArcSDE service user processes
Troubleshooting the ArcSDE service
These topics deal with direct connections to the geodatabase:
Properties of a direct connection to an ArcSDE geodatabase
Setting up a direct connection to PostgreSQL
Troubleshooting direct connections to an ArcSDE geodatabase
Working with the geodatabase
These topics cover working with data in an ArcSDE geodatabase:
About data types
PostgreSQL data types
About geometry storage types
Registering tables to be used by ArcGIS Desktop
Granting and revoking privileges on datasets
PostgreSQL backups
Recovery models for PostgreSQL
Using database views
Views in PostgreSQL
Locators in the geodatabase
About compressing a geodatabase
Compressing an ArcSDE geodatabase licensed under ArcGIS Server Enterprise
Updating statistics on a geodatabase licensed under ArcGIS Server Enterprise
Updating geodatabase statistics in PostgreSQL databases
It would also be helpful to understand how the geodatabase is structured and how data is stored in it. For this, consult the section "Geodatabase data storage and schema" found in this help. There is a specific book for PostgreSQL in this section: "Inside a geodatabase in PostgreSQL."
See Also
An overview of ArcSDE geodatabase administration
