How to set trace logging to 'ALL' for PostgreSQL database in TIBCO Data Virtualization?
Article ID: KB0075797
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 7.0.6 and higher |
Description
By default, PostgreSQL does not have many options to control logging. The main one is "log_statement", which can be set to different values as below.
1) 'none' (Most users never set it to this!)
2) 'ddl' or 'mod' (decent but flawed values)
3) 'all'
1) 'none' (Most users never set it to this!)
2) 'ddl' or 'mod' (decent but flawed values)
3) 'all'
Issue/Introduction
This article contains the steps to enable logging trace to 'ALL' for Postgres database in TDV.
Environment
All supported operating systems.
Resolution
Follow below steps to enable TRACE logging on PostgreSQL:
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) Paste below line at the end of the file.
log_statement =
4) Set the configuration value to "none/all" and save the changes.
5) Restart the service for TDV repository.
Additional Information
Note : Revert back the changes to original configuration once the debug trace is collected, as excessive logging may affect on TDV server performance.
Feedback
Yes
No
Powered by
