[EMAIL PROTECTED] 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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org/

Reply via email to