Update the Configuration File for PostgreSQL Datastores

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 that includes entries to one or more datastores.

  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:
    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 data source for your datastores, region databases, and cross-region databases. Each <dsn> element contains the following attributes, depending on the type of database:
    • name - the name of the data source.
    • type - the type of database. For datastores, this is type="datastore".
    • dsname - the name to which Enterprise Server will refer to the datastore; this is the name specified as <datastore-name> when the ODBC data source was created for the database.
    • optio - the optimizations that are applied to database file handling operations at run-time. The available options are none (no optimizations applied), or all (currently, this only applies for line-sequential files opened for input). If this attribute is not specified, no optimizations are applied.
    • 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="datastore" dsname=<name> optio=<opt> userid=<user> password=<pass>/>
       </server>
    </datastores>
  6. Save the configuration file, ensuring that 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" 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 use the dbfhdeploy command line utility to create the datastore and add files to it.