In this article we will enable PostgreSQL detailed SQL trace logging to a plain text file. If required VSoft may request further information from your PostgreSQL installation in order to assist in progressing a support case for you. Detailed trace logging in not enabled with the default install of PostgreSQL.
NOTE: As part of this process we will be stopping the ContinuaCI Server service, as a result it is highly recommended to make the below changes during a low activity period. Enabling tracing requires a restart of the primary database. It is also recommended to ensure adequate disk space on the server where tracing will be enabled (~80 megabytes per hour or greater will be required).
Changes to postgresql.conf
```
log_destination = 'stderr'
logging_collector = on
log_directory = 'pg_log'
log_statement = 'all'
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
log_hostname = on
log_duration = on
```
10. Once the issue has been replicated, ZIP these files up and contact VSoft support (support@finalbuilder.com) in order to arrange a file transfer.