Data Steward Studio Installation and Upgrade
Also available as:
PDF

Configure Postgres external database

You must configure a Postgres database and add the profileragent database user to the database.

  1. Log in to postgres shell using admin user like postgres:
    psql -U postgres
  2. Create profileragent database and user and grant all previleges:

    CREATE DATABASE $profileragentdb;

    CREATE USER $profileragentuser WITH PASSWORD '$password';

    GRANT ALL PRIVILEGES ON DATABASE $profileragentdb TO $profileragentuser;

    The default value for $profileragentdb and $profileragentuser is profileragent.

  3. Add $profileragentuser to pg_hba.conf to have access from profiler agent host.