Creating the Region Database

Because database creation can be slow for some RDBMS, Micro Focus recommends that you create the region database before you start the PAC:

From your Windows desktop, click Start > Micro Focus Enterprise Developer > Enterprise Developer Command Prompt (64-bit).
At the command prompt, type the following:
```
dbfhadmin -script -type:region -provider:pg -name:MYPAC -file:create_region_db.sql
```
This creates a file containing the PostgreSQL statements to create the region database.

At the command prompt, type the following:

dbfhadmin -createdb -provider:pg -type:region -name:MYPAC -file:create_region_db.sql -user:postgres

Note: Ensure that the PostgreSQL server is running and that the folder containing the psql PostgreSQL utility has been added to your PATH environment variable. Typically, you can find this located at C:\Program Files\PostgreSQL\10\bin.

When using the dbfhadmin -createdb -provider:pg -user:postgres ... command, it is assumed that an entry for the postgress user has been created in a password file, located at %APPDATA%\postgresql\pgpass.conf on Windows, or .pgpass in the user's home directory on Linux. On Linux, PostgreSQL also supports the use of the PGPASSFILE environment variable to specify the location of the password file. See Configure Region and Cross-Region Databases in PostgreSQL for more information.

The password file takes the form:

#hostname:port:database:username:password
      localhost:5432:postgres:mfdbfh:MfdbfhAdmin1!