Setting CLIENT_MIN_MESSAGES dynamically...

Hi,

My config file has the following setting:

log_min_messages = fatal

This setting assures that postgres logging is minimal. However, I would
like to change this setting dynamically - while our embedded application
is running, without restarting postgres. For example, in the case where
the application appears to be running sluggishly, I would like to change
this setting to debug1 so that I can collect detailed information. The
problem is the SET command applies only to the current session:

set log_min_messages='debug1';

Is there a way to accomplish this?

Currently, we have postgres generate a lot of debug messages (debug1)
and then have syslog filter the messages as required. This works since
I can edit the syslog.conf and restart syslog independent of our
application. This is a less than ideal situation since we normally
don't want postgres producing lots of log data (wasting cpu) since we
require it only when doing debugging.

Thanks

Ike