1. Remove all log files from "infobright\pg_data\pg_log\" directory that are more than seven days old.
2. Replace the attached "postgresql.conf" with the one exist on "infobright\pg_data\" directory.
This files includes modified log settings to reduce the log printing.
In order to reduce the log messages and the log file, the following log settings will be modified in the default
log_rotation_size = 10MB
client_min_messages = notice
log_min_messages = warning
log_min_error_statement = error
log_connections = off
log_disconnections = off
log_duration = off
log_statement = 'none'
3. Restart the SQL PI (postgress) database in order for the new log settings to take place. The restart should be done as follows:
4. Deactivate the SPIRepository agent
a)Deactivate the SPIRepository agent under Administration | Agents | Agent Status | search for "SPIRepository"
on the host where the SPIREpository agent is being or has been previously deployed, open Windows Explorer.
Browse to \Quest_Software\Infobright (typically the same path as the FglAM install)
b) Kill all the following processes in the Task Manager: "ibengine" "postgres" and "bhloader-pure"
c) Activate the SPIRepository agent. This agent will launch the SQL PI repository once again.
Please, consult with the development team first before applying these steps.
Beginning with the 220.127.116.11 SQL Server cartridge the enhancement SSDB-13751 was added to this cartridge and later releases to automatically clean old SQL PI repository files.
This enhancement runs a new 'collection' once a day in the SPIRepository agent that will delete any log that is older than 7 days.