[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