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).
You may want to use a panel to highlight important steps.
|
Below is a configuration file ready to go with the above changes.
Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.