How to enable/disable PostgreSQL database logging in TIBCO Data Virtualization?

How to enable/disable PostgreSQL database logging in TIBCO Data Virtualization?

book

Article ID: KB0075798

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 7.0.6 and higher

Description

In certain scenarios, it may be needed to disable and enable the PostgreSQL database logging in TDV.

Environment

All supported operating systems

Resolution

Follow below steps to enable/disable the PostgreSQL logging :

1) Login into TDV server and Browse to folder <Server Installation directory>>Repository>>Data.

2) Take the backup of "postgresql.conf" file and then open it in a text editor like Notepad++.

3) Change the configuration value to "on/off" in below line and save the changes.

      logging_collector=

4) Restart the service for TDV repository.
 

Issue/Introduction

This article explains the process of enabling or disabling the logging for PostgreSQL database in TDV.