[imp] How could I reduce the amount of log in postgress
Alain Plante
alain.plante at mcgill.ca
Wed Feb 4 07:56:13 PST 2004
Hi!
I'd like to get rid of those lines in my serverlog for postgres...
2004-02-04 10:47:38 [27395] LOG: query: BEGIN;
2004-02-04 10:47:38 [27395] LOG: query: ROLLBACK;
2004-02-04 10:47:38 [27400] LOG: query: BEGIN;
2004-02-04 10:47:38 [27400] LOG: query: ROLLBACK;
2004-02-04 10:47:38 [27335] LOG: query: BEGIN;
2004-02-04 10:47:38 [27335] LOG: query: ROLLBACK;
2004-02-04 10:47:38 [27442] LOG: query: BEGIN;
2004-02-04 10:47:38 [27442] LOG: query: ROLLBACK;
2004-02-04 10:47:38 [27306] LOG: query: BEGIN;
2004-02-04 10:47:38 [27306] LOG: query: ROLLBACK;
2004-02-04 10:47:39 [27306] LOG: query: BEGIN;
2004-02-04 10:47:39 [27306] LOG: query: ROLLBACK;
2004-02-04 10:47:39 [27392] LOG: query: BEGIN;
2004-02-04 10:47:39 [27392] LOG: query: ROLLBACK;
2004-02-04 10:47:39 [27306] LOG: query: BEGIN;
2004-02-04 10:47:39 [27306] LOG: query: ROLLBACK;
2004-02-04 10:47:39 [27307] LOG: query: BEGIN;
here's some part of my postgresql.conf
# Message display
#
server_min_messages = notice # Values, in order of decreasing detail:
# debug5, debug4, debug3, debug2, debug1,
# info, notice, warning, error, log,
fatal,
# panic
client_min_messages = notice # Values, in order of decreasing detail:
# debug5, debug4, debug3, debug2, debug1,
# log, info, notice, warning, error
silent_mode = false
log_connections = true
#log_connections = false
log_pid = true
log_statement = true
log_duration = false
log_timestamp = true
log_min_error_statement = info # Values in order of increasing severity:
We have postgress 7.3, horde 2.2.4, imp 3.2.2
Any suggestions?
Thanks
Alain PLante
More information about the imp
mailing list