[ADMIN] postgres 9.0 date aberration in logs

The server seems to have written the wrong date for the first 45 minutes or so of Tuesday before switching in mid-stream: <...> 2012-01-31 23:58:05 PST [13586]: [29677-1] LOG:  checkpoint starting: time 2012-01-31 23:58:08 PST [13586]: [29678-1] LOG:  checkpoint complete: wrote 16 buffers (0.0%);

Re: [ADMIN] postgres 9.0 date aberration in logs

To me seems that it just appended the data to your log. To avoid this set the log_truncate_on_rotation to on, but notice that it will replace the old logs. -- Matheus de Oliveira Bacharelado em Ciências de Computação Laboratório de Computação de Alto Desempenho - LCAD

Re: [ADMIN] postgres 9.0 date aberration in logs

Matheus -- > >To me seems that it just appended the data to your log. To avoid this set the >log_truncate_on_rotation to on, but notice that it will replace the old logs. > > Thanks for the suggestion, but we seem to be using this already: -bash-3.2$ grep  log_truncate_on_rotation  postgresql.