Bonjour,

J'ai des petits problémes avec ma configuration de log (postgresql.conf). Je n'arrive pas à afficher le temps (en tout cas je ne vois rien de semblable dans le fichier de log) malgré log_min_duration_statement = 0 ou log_duration = true.
2éme chose, avec log_destination = 'stderr' tous les logs apparaissent dans ma console psql (dés que j'utilise de l'auto complétion par exemple). Suis je obligé d'utiliser syslog pour éviter cela.

Voici ma conf de log :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
# - Where to Log -
 
log_destination = 'stderr'      # Valid values are combinations of stderr,
                                # syslog and eventlog, depending on
                                # platform.
 
# This is relevant when logging to stderr:
redirect_stderr = true    # Enable capturing of stderr into log files.
# These are only relevant if redirect_stderr is true:
log_directory = 'pg_log'   # Directory where log files are written.
                            # May be specified absolute or relative to PGDATA
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # Log file name pattern.
                            # May include strftime() escapes
log_truncate_on_rotation = false  # If true, any existing log file of the
                            # same name as the new log file will be truncated
                            # rather than appended to.  But such truncation
                            # only occurs on time-driven rotation,
                            # not on restarts or size-driven rotation.
                            # Default is false, meaning append to existing
                            # files in all cases.
log_rotation_age = 1440    # Automatic rotation of logfiles will happen after
                            # so many minutes.  0 to disable.
log_rotation_size = 10240  # Automatic rotation of logfiles will happen after
                            # so many kilobytes of log output.  0 to disable.
 
# These are relevant when logging to syslog:
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
 
# - When to Log -
 
client_min_messages = log       # Values, in order of decreasing detail:
 
client_min_messages = log       # Values, in order of decreasing detail:
                                #   debug5, debug4, debug3, debug2, debug1,
                                #   log, notice, warning, error
 
log_min_messages = log  # Values, in order of decreasing detail:
                                #   debug5, debug4, debug3, debug2, debug1,
                                #   info, notice, warning, error, log, fatal,
                                #   panic
 
log_error_verbosity = verbose   # terse, default, or verbose messages
 
log_min_error_statement = info # Values in order of increasing severity:
                                 #   debug5, debug4, debug3, debug2, debug1,
                                 #   info, notice, warning, error, panic(off)
 
log_min_duration_statement = 0 # -1 is disabled, in milliseconds.
 
silent_mode = true             # DO NOT USE without syslog or redirect_stderr
 
# - What to Log -
 
debug_print_parse = false
debug_print_rewritten = false
debug_print_plan = false
debug_pretty_print = false
log_connections = true
log_disconnections = true
log_duration = false
log_line_prefix = '%t [%p]: [%l-1] ' # e.g. '<%u%%%d> '
                                # %u=user name %d=database name
                                # %r=remote host and port
                                # %p=PID %t=timestamp %i=command tag
                                # %c=session id %l=session line number
                                # %s=session start timestamp %x=transaction id
                                # %q=stop here in non-session processes
                                # %%='%'
log_statement = 'all'           # none, mod, ddl, all
log_hostname = true