mljv(at)planwerk6(dot)de wrote:
> Unfortunatly i can not tell at which time this happens as the log doesn't
> show the time of day.
>
Start with your postgresql.conf -
http://www.postgresql.org/docs/8.2/interactive/runtime-config-logging.html
points of interest :-
log_min_messages - debug1 to get some more info in the log
log_line_prefix - %t will show the timestamp of the log entry
log_statement - can record the queries to the log so you can see just
what is being run as you go through the log.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz