Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0711

...

Use the following steps to initialize the databases of the the 

D s platform
rtrue
.

Info

NOTE: These steps assume that the

D s node
is the host of these databases. Please modify the following steps if you are connecting to databases on other nodes.

...

  • The initializing user must have write permissions to the directory from which the commands are executed.
  • The initializing user must have sudo privileges.

PostgreSQL

Info

NOTE: The In the following steps are for configuring , the default version is PostgreSQL 9.6.

  1. For CentOS 7.x, CentOS 8.x:

    Code Block
    sudo /usr/pgsql-9.6/bin/postgresql96-setup initdb
  2. For CentOS 7.x - PostgreSQL 12.3:

    Code Block
    sudo /usr/pgsql-12/bin/postgresql12-setup initdb
  3. For RHEL 7.x, RHEL 8.x:

    Code Block
    sudo /usr/pgsql-9.6/bin/postgresql96-setup initdb
  4. For Ubuntu 16.04 / 18.04:

    Code Block
    pg_createcluster -d /var/lib/postgresql/9.6/main 9.6 main

...

Use the following steps to set custom database names, usernames, and passwords in the the 

D s platform
:

  1. Edit 

    D s triconf
    pathtrue

  2. For each database, you can review the parameters in the listed area and make modifications as needed.

    Info

    NOTE: For each database, you should change the default password. This change must also be applied on the database server. See Change Database Passwords for PostgreSQL . See Change Database Passwords for MySQL.

    Info

    NOTE: The type is set to POSTGRESQL by default. Modify the value if you are installing the databases into a different database server.


    DatabaseParameter area
    Main databasewebapp.database.*
    Jobs databasebatch-job-runner.database.*
    Scheduling databasescheduling-service.database.*
    Time-Based Trigger databasetime-based-trigger-service.database.*
    Configuration Service databaseconfiguration-service.database.*
    Job Metadata Service databasejob-metadata-service.database.*
    Artifact Storage Service database

    artifact-storage-service.database.*

    Authorization Service databaseauthorization-service.database.*
    Orchestration Service databaseorchestration-service.database.*
    Job Metadata
    Optimizer Service database
    job-metadata
    optimizer-service.database.*

    For more information, see Database Parameter Reference.

  3. Make changes in the file as needed and save.

...

If you have customized database properties, you must apply the edits from the new sample file to the existing configuration file after you have upgrade the the 

D s platform
.

If you are using all defaults, you can just overwrite the existing file with the new version's sample file. 

...

  1. Locate the sample Postgres configuration file:

    Code Block
    /opt/trifacta/bin/setup-utils/db/pg_hba.conf.SAMPLE
  2. If you are upgrading and have customizations in your existing version, you must apply the edits in the above to the following file. Otherwise, overwrite the following file with the above one based on your operating system:
    1. CentOS/RHEL dir: /var/lib/pgsql/9.6/data/pg_hba.conf
    2. Ubuntu dir: /etc/postgresql/9.6/main/pg_hba.conf

  3. From the SAMPLE file file, copy the following declarations and paste them into the production pg_hba.conf file  file above any other declarations:

    Info

    NOTE: You can substitute different database usernames and groups for the ones listed below (trifacta and trifacta). These values may be needed for other configuration.

     

    1. D s item
      itemdatabase
      :

      Code Block
      local   trifacta         trifacta                               md5
      host    trifacta         trifacta         127.0.0.1/32          md5
      host    trifacta         trifacta         ::1/128               md5
    2. Jobs database:

      Code Block
      local   trifacta-activiti         trifactaactiviti                               md5
      host    trifacta-activiti         trifactaactiviti         127.0.0.1/32          md5
      host    trifacta-activiti         trifactaactiviti         ::1/128               md5
    3. Scheduling database: 

      Code Block
      local   trifactaschedulingservice         trifactaschedulingservice                               md5
      host    trifactaschedulingservice         trifactaschedulingservice         127.0.0.1/32          md5
      host    trifactaschedulingservice         trifactaschedulingservice         ::1/128               md5
    4. Time-based Trigger database:

      Code Block
      local   trifactatimebasedtriggerservice         trifactatimebasedtriggerservice                               md5
      host    trifactatimebasedtriggerservice         trifactatimebasedtriggerservice         127.0.0.1/32          md5
      host    trifactatimebasedtriggerservice         trifactatimebasedtriggerservice         ::1/128               md5
    5. Configuration Service database:

      Code Block
      local   trifactaconfigurationservice         trifactaconfigurationservice                               md5
      host    trifactaconfigurationservice         trifactaconfigurationservice         127.0.0.1/32          md5
      host    trifactaconfigurationservice         trifactaconfigurationservice         ::1/128               md5
    6. Artifact Storage Service database:

      Code Block
      local   trifactaartifactstorageservice         trifactaartifactstorageservice                               md5
      host    trifactaartifactstorageservice         trifactaartifactstorageservice         127.0.0.1/32          md5
      host    trifactaartifactstorageservice         trifactaartifactstorageservice         ::1/128               md5
    7. Job Metadata Service database:

      Code Block
      local   trifactajobmetadataservice         trifactajobmetadataservice                               md5
      host    trifactajobmetadataservice         trifactajobmetadataservice         127.0.0.1/32          md5
      host    trifactajobmetadataservice         trifactajobmetadataservice         ::1/128               md5
    8. Authorization Service database:

      Code Block
      local   trifactaauthorizationservice         trifactaauthorizationservice                               md5
      host    trifactaauthorizationservice         trifactaauthorizationservice         127.0.0.1/32          md5
      host    trifactaauthorizationservice         trifactaauthorizationservice         ::1/128               md5
    9. Orchestration Service database:

      Code Block
      local   trifactaorchestrationservice         trifactaorchestrationservice                               md5
      host    trifactaorchestrationservice         trifactaorchestrationservice         127.0.0.1/32          md5
      host    trifactaorchestrationservice         trifactaorchestrationservice         ::1/128               md5
    10. Optimizer Service database:

      Code Block
      local   trifactoptimizerservice         trifactoptimizerservice                               md5
      host    trifactoptimizerservice         trifactoptimizerservice         127.0.0.1/32          md5
      host    trifactoptimizerservice         trifactoptimizerservice         ::1/128               md5
    11. Save the file.
  4. Restart the databases:

    1. If you are have also restarted the operating system, please execute the following first, followed by the O/S-specific commands:

      Info

      NOTE: This command is valid only if the Postgres DB is also hosted in the

      D s node
      .


      Code Block
      chkconfig postgresql-9.6 on

      For PostgreSQL 12.3 on CentOS 7:

      Code Block
      chkconfig postgresql-12 on
    2. CentOS/RHEL:

      Code Block
      sudo service postgresql-9.6 start
    3. CentOS/RHEL 7 (PostgreSQL 12.3):

      Code Block
      sudo service postgresql-12 start
    4. Ubuntu:

      Code Block
      sudo service postgresql start

...

  1. If the configuration files indicate that the databases are listening on a port other than the default, this port number must be applied within the 
    D s platform
     configuration. For more information, see Change Database Port.
  2. If you are using non-default usernames and passwords, they must must be applied within the 
    D s platform
     configuration. For more information, see Change Database Passwords for PostgreSQL.
  3. When you have completed the above configuration, you can create the databases and their roles (users) and perform additional configuration. See See Create Databases and Users.