Multiple geodatabases in PostgreSQL

For PostgreSQL, you store one geodatabase per database. You can create multiple databases on the same PostgreSQL database cluster, but clients connect to one database at a time.

Storing more than one geodatabase in the same PostgreSQL database cluster

You can use the Create Enterprise Geodatabase geoprocessing tool or a Python script to create additional databases and geodatabases on the PostgreSQL database cluster. If clients only use direct connections to each separate geodatabase, you do not need to create an ArcSDE service. However, if clients connect using an ArcSDE service, you must create an additional service for each additional geodatabase. These different ArcSDE services can be running on the same server machine but do not have to be. To create ArcSDE services, you must do the following:

  1. Download the ArcSDE application server installation from the Esri Customer Care Portal.
  2. Install the ArcSDE application server on your server.
  3. Add entries for the new services to the services.sde and operating system services files.
  4. If the service is running on a Windows server, run the sdeservice command to create each service and register each one with a separate geodatabase.
  5. Run the sdemon command to start the services.

Each connection to the ArcSDE service, or direct connection to a geodatabase, accesses and uses only one database.

For instructions on using multiple ArcSDE for PostgreSQL geodatabases, see Setting up multiple geodatabases in one PostgreSQL database cluster.

Related Topics

8/21/2013