Alfresco Community Edition 5.2 (Default settings)
Has anyone done anything with the logging on the Postgresql database side for Alfresco?
In the postgresql.conf file, I have the following properties
log_destination = 'stderr'
logging_collector = on
log_directory = 'pg_log'
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
log_min_messages = debug5
log_min_error_statement = debug5
log_min_duration_statement = 0
log_checkpoints = on
log_connections = on
log_disconnections = on
log_duration = on
log_error_verbosity = default
log_lock_waits = on
log_statement = 'none'
I tried different values for few of the properties above.
I could never make it to work for my situation.
Sometimes, a log file has been created in this pg_log folder, but always with 0 bytes. Nothing gets written there.
For some settings, no file has been created.
My purpose is to get the Postgresql query for the CMIS select query that I am running from my application.
We know this CMIS query takes more than 20 seconds consistently.
This query has our own metadata custom (aspect) properties in the where clause.
In order to tune the database with indices, I would like to see the raw database query on the other side.