Setting up multiple geodatabases in one PostgreSQL database cluster

You can have more than one database in a PostgreSQL database cluster. Therefore, you can have more than one geodatabase in a PostgreSQL database cluster—one geodatabase per database.

The steps to create the second geodatabase are the same as for the first. Just be sure that, if you are using an ArcSDE service for connections, you create a unique service for the second geodatabase.

Steps:

1. Run the Create Enterprise Geodatabase geoprocessing tool or a Python script to create a second geodatabase.

   See Creating a database and geodatabase in PostgreSQL for instructions.

2. If you want to use an ArcSDE service for connections, do the following:
   1. Add an entry for the service for the new geodatabase to the services.sde and operating system services files.
   2. On Windows, run the sdeservice command with the create operation to create a service for the second geodatabase.
   3. Run the sdeservice command with the register operation to register the new geodatabase with the service.
   4. Run the sdemon command with the start operation to start the new service.

      If the ArcSDE application server is installed on a different server than the database, see Starting a remote ArcSDE service on Windows or Starting a remote ArcSDE service on Linux or UNIX.

3. Create schemas in the new database for users who will own data.
4. Grant appropriate permissions on the schemas to other users in the database.