Recommendations for Working with Database

When updating the host, port, dbname, username, password database parameters, corrections must be made:

  • in table org_unidata_mdm_data.nodes_info in db,

  • in the configuration file .env.

This is relevant for cases such as transferring the db to another server, renaming the db or changing the login / password to the db.

In the file .env/setenv.sh parameters of variables taken from the file backend.properties.

Parameter names for 5.x:

POSTGRES_USERNAME="postgres" - user db PostgreSQL.
POSTGRES_ADDRESS="localhost:5432" - adress server PostgreSQL.
POSTGRES_PASSWORD="notpostgres" - user password PostgreSQL.
DATABASE_NAME="universe" - database name.

Parameter names for 6.x:

MDM_POSTGRES_USER=postgres - user db PostgreSQL.
MDM_POSTGRES_PASSWORD=postgres - password db PostgreSQL.
MDM_POSTGRES_DB_NAME=postgres - database name.
POSTGRES_OUTER_PORT=15431 - outer port.