Using Cloud Service PostgreSQL to Replace Hengshi metadb

Preparing Users

• Prepare Hengshi database account

1. Create a Hengshi user
2. Create a Hengshi database, and grant all privileges of this database to the "Hengshi user"
3. Have the privilege to create databases

For example, to create a hengshi user and a hengshi database. The requirements above correspond to general operations:

create user hengshi with createdb createrole login password 'hengshi';
set role hengshi;
create database hengshi;
reset role;

• Prepare Hengshi log service account

1. Create a Hengshi log user
2. Create a Hengshi log database, and grant all privileges of this database to the "Hengshi log user"

The requirements above correspond to general operations:

create user syslog with createdb createrole login password 'syslog';
set role syslog;
create database syslog;
reset role;

Configuration Corresponding to conf/hengshi-sense-env.sh

HS_PG_HOST=xxx         # Hengshi business database host
HS_PG_PORT=5432        # Hengshi business database port
HS_PG_DB="hengshi"     # Hengshi business database dbname
HS_PG_USR=hengshi      # Hengshi business database user
HS_PG_PWD="hengshi"    # Hengshi business database password

HS_SYSLOG_HOST=xxxx    # Hengshi log database host (usually the same as the business database)
HS_SYSLOG_PORT=5432    # Hengshi log database port (usually the same as the business database)
HS_SYSLOG_DB=syslog    # Hengshi log database dbname
HS_SYSLOG_USR=syslog   # Hengshi log database user
HS_SYSLOG_PWD=syslog   # Hengshi log database password