Creating a Repository on PostgreSQL Server

To create a repository on the PostgreSQL server in Linux OS:

Make sure that BI server is installed on PostgreSQL server.
Download and unpack the archive:

Script_example_public.zip if the public scheme is used.
Script_example_custom_scheme.zip is a custom scheme is used.

Start the script depending on the unpacked archive:

create_repo_public.sh;
create_repo_custom_scheme.sh.

NOTE. The script contains predefined parameters for creating a repository with default values. See the list of parameters and if required replace default values before running the script.

After executing the script with parameters with default values, the following changes on the PostgreSQL server:

A database with the NEW_DATABASE identifier is created under the postgres administrator.
A database user named NEW_USER is created. User password - NEW_USER.
A service user named SERVICE_USER is created. Service user password - SERVICE_USER.
A custom scheme with the NEW_SCHEMA identifier in a database with the NEW_DATABASE identifier.

NOTE. A custom scheme is created only if the create_repo_custom_scheme.sh script is executed.

The identifier of the created database is used as a unique identifier of metadata repository.

Changing Parameter Values

To change parameter values that should differ from default values, open the script for edit. Repository creation parameters are used as variables in the following script block:

# postgres credentials
export PGUSERNAME=postgres
export PGPASSWORD=$PGUSERNAME
# create database
export SERVER=localhost
export PORT=5432
export DBNAME=NEW_DATABASE
# create database role
export DBROLE=NEW_USER
# set password for created role
export DBPASSWORD=NEW_USER
# set repository id
export REPOSITORY_ID=$DBNAME
# create custom scheme
export SCHEMA_NAME=NEW_SCHEMA
# work directory
export RM_WORKDIR=/opt/foresight/fp10.x-biserver/bin
export RM_FILE=/opt/foresight/fp10.x-biserver/bin/rm/current.rm4
# service user credentials
export SUSERNAME=SERVICE_USER
export SUSERPASSWORD=$SUSERNAME

Description of variables:

PGUSERNAME. DBMS administrator name with the SUPERUSER privilege. Default value: postgres.
PGPASSWORD. DBMS administrator password. Default value: postgres.
SERVER. IP address or DNS name, under which the DBMS database server is registered. Default value: localhost.
PORT. DBMS server port. Default value: 5432.
DBNAME. Identifier of created database. Default value: NEW_DATABASE.
DBROLE. Name of created database user. Default value: NEW_USER.
DBPASSWORD. Password of created database user. Default value: NEW_USER.
REPOSITORY_ID. Repository identifier. Default value: NEW_DATABASE.
SCHEMA_NAME. Custom schema identifier. Default identifier: NEW_SCHEMA.

NOTE. A variable is contained in the create_repo_custom_scheme.sh script.

RM_WORKDIR. The path to the folder with installed BI server. Default path: /opt/foresight/fp10.x-biserver/bin.
RM_FILE. The path to the current.rm4 file with repository creation scripts. Default path: /opt/foresight/fp10.x-biserver/bin/rm/current.rm4.
SUSERNAME. Name of the created service user. Default value: SERVICE_USER.

IMPORTANT. The P4AUDIT server user name is reserved by the system and cannot be used.

SUSERPASSWORD. Password of created service user. Default value: SERVICE_USER.

NOTE. The sent credentials will be available only within a single console session, in which the script is to be executed.