Update the Configuration File for PostgreSQL Region and Cross-Region Databases

Attention: This feature is in Early Adopter Product (EAP) release status. We will continue the development of additional features and provide additional interfaces via patch updates and future releases. Please contact Micro Focus SupportLine if you require further clarification.

Use these steps to create or update a configuration file to include entries to one or more region databases, and a cross-region databases.

  1. If you do not already have a database configuration file (MFDBFH.cfg), in a text editor, create a simple text file and name it MFDBFH.cfg. If you already have a configuration file, skip to step 3.)
  2. Code the base element:
    <datastores>
    </datastores>
  3. Add a <server> element for each database server instance you intend to connect to. Each <server> element contains 3 attributes:
    Note: If you are editing a configuration file that already contains entries to the required server instance, skip to step 5.
    • name - the name of the instance.
      Tip: An entry of localhost:<port> defaults to your machine name when the file is processed.
      Note: You can use an environment variable as the name of the data source: set a variable in your environment, and then use the following syntax:
      <server name=$(env-name) type="postgresql" access="odbc"/>
    • type - the type of database. For PostgreSQL databases this is postgresql.
    • access - the type of protocol for the database connection. Currently only odbc is supported.

    For example, for a local PostgreSQL connection on the default port:

    <datastores>
       <server name="localhost:5432" type="postgresql" access="odbc">
       </server>
    </datastores>
  4. Firstly, you need to create a reference to the postgres database - this is one of the default databases supplied with any PostgreSQL server:
    Note: If the <server> element for your database server instance already exists, this reference should already exist.
    <datastores>
       <server name="localhost:5432" type="postgresql" access="odbc">
          <dsn name=<data-source> type="database" dbname="postgres" userid=<user> password=<pass>/>
       </server>
    </datastores>
  5. Next, you need to add further <dsn> elements for each region and cross-region database. Each <dsn> element contains the following attributes:
    • name - the name of the data source.
    • type - the type of database. For region databases, this is type="region.cas", and for cross-region databases, this is type="crossregion.cas".
    • region - the name of an enterprise server region. This attribute is only applicable to region database types.
    • feature - the features of an enterprise server region that are stored in a database. This attribute is only applicable to region database types. See the table in Types of Database for a list of valid options.
    • userid and password - a set of valid credentials used to access the database.
    <datastores>
       <server name="localhost:5432" type="postgresql" access="odbc">
          <dsn name=<data-source> type="database" dbname="postgres" userid=<user> password=<pass>/>
          <dsn name=<data-source> type="region.cas" region=<region-name> feature=<options> userid=<user> password=<pass>/>
          <dsn name=<data-source> type="crossregion.cas" userid=<user> password=<pass>/>
       </server>
    </datastores>
  6. Save the configuration file, ensuring it is named MFDBFH.cfg.

Example MFDBFH.cfg

The following is an example of a configuration file that contains a datastore, a region database, and a cross-region database.

<datastores>
   <server name="localhost:5432" type="postgresql" access="odbc">
      <dsn name="PG.POSTGRES" type="database" dbname="postgres" userid="clerk" password="clerk321"/>
      <dsn name="PG.VSAM" type="datastore" dsname="VSAM" optio="none +ooseq" userid="clerk" password="clerk321"/>
      <dsn name="PG.ESDEMO" type="region.cas" region="PGDEMO" feature="all" userid="clerk" password="clerk321"/>
      <dsn name="PG.CROSSREGION" type="crossregion.cas" userid="clerk" password="clerk321"/>
   </server>
</datastores>

Next, you must configure the enterprise server region to use the region and cross-region databases.