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: 03-26-2020

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.

Issue/Introduction

This article explains the process of enabling or disabling the logging for PostgreSQL database 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.