VisibleThread -
Help Center Find helpful articles on different VisibleThread Products

Follow

How to configure VT Docs on RHEL to connect to an external database

Create the VT Docs user and database

Download the sql file from here:

https://docs.visiblethread.com/download/VTDocsDbBootstrap/createDB.sql

 On a system that has access to the Postgresql database run the file 'createDB.sql' as the postgres user: 

# psql -h <postgresql server name> -U postgres

postgres=> \i createDB.sql

postgres=> \q 

This will create the VisibleThread user in PostgreSQL and the VisibleThread database

Bootstrap the VisibleThread Docs database with the required table structure and data

Download the sql file from here:

https://docs.visiblethread.com/download/VTDocsDbBootstrap/createTables.sql

Run the attached file 'createTables.sql' as the visiblethread user (the password is 'password'):

#psql -h <postgresql server name> -U visiblethread 

postgres=> \i createTables.sql

postgres=> \q

 

Modify the VT Docs application config to point to your Database server

  1. On the RHEL server that is running VT Docs, navigate to the ‘/opt/visiblethread/tomcat/conf’ folder
  2. Open the ‘server.xml’ file for editing
  3. Replace the line that contains “url="jdbc:postgresql://127.0.0.1:5432/visiblethread"”  with “url="jdbc:postgresql://<db server address>:5432/visiblethread"
  4. Open the ‘context.xml’ fie for editing
  5. Replace the line that contains “url="jdbc:postgresql://127.0.0.1:5432/visiblethread"”  with “url="jdbc:postgresql://<db server address>:5432/visiblethread"
  6. Restart the VT Docs services:
sudo service visiblethread-docs restart

The application should startup and be connected to the external database.

Recommended config for external Postgres

We recommend that you make this change to your external postgres.conf :

max_locks_per_transaction=500

 

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful

Get Additional Help

Visit our Helpdesk for additional help and support.