When would I need to enable PostgreSQL Diagnostics
If required VSoft may request further information from your PostgreSQL installation in order to assist in progressing a support case for you.
Why do I do?
- Locate your PostgreSQL postgresql.conf file. By default this is located within the 'C:\ProgramData\VSoft\Continua\Data' folder
- Take a backup copy of this file and store it in a safe place. This file will be required in order to reverse the process.
- Create a folder in order to place the log files (this folder can be any location on the local machine). This is the directory which will be placed in the 'log_directory' configuration option (in line 5 below).
Open the postgresql.conf file and amend the below lines:
Changes to postgresql.conflog_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
- Save the file
- Restart your Continua PostgreSQL service
Log files should now be start recording into the desired location:
Included below is a default configuration file which has been prepared with the above mentioned changes.