Products | Versions |
---|---|
TIBCO Data Virtualization | 7.0.6 and higher |
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'
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.