Setting up multiple geodatabases in one PostgreSQL database cluster on Windows

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. If you plan to use different settings in the dbtune.sde, giomgr.defs, or dbinit.sde files, these changes must be made before running the Post Installation wizard. To specify different geodatabase storage information for the second geodatabase, make copies of your giomgr.defs and dbtune.sde files, giving them different names. For example, you could name them giomgr2.defs and dbtune2.sde. Alter the contents of these new files. When you run the Post Installation wizard, you will specify these custom files.
2. To set variables in the dbinit.sde file to connect to the second geodatabase, make a copy of your dbinit.sde file, giving it a new name. This name must include the name of the new ArcSDE service. For example, if the new service name is sdepgsql2, name the dbinit file dbinit_sdepgsql2.sde. Add the appropriate variables to the new dbinit file. When running the Post Installation wizard, specify the new dbinit file.
3. Run the Post Installation wizard for ArcSDE for PostgreSQL.

   You can access this from the Windows Start menu: Start > All Programs > ArcGIS > ArcSDE > ArcSDE for PostgreSQL Post Installation.

4. Choose the Complete option on the Post Installation wizard unless you are not using ArcSDE service client connections.

   If you are not using an ArcSDE service for connections, choose Custom, then uncheck the option to create an ArcSDE service on the next dialog box.

5. Complete the Post Installation wizard to create a new database, tablespace, and geodatabase; authorize the new geodatabase with the ArcGIS Server Enterprise license; and create a separate service to connect to the new geodatabase (if using a service).

   Be sure to specify a different service name and port number and the correct database name on the ArcSDE service information dialog box. The Post Installation wizard adds the new service information to the services.sde file and the Windows services file.

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