Re: Logging/Debugging

Colm

Thank you very much.

This in postgresql.conf gives me exactly what I wanted:

log_connections = true
log_timestamp = true
log_pid = true
debug_level = 2
debug_print_query = true

THOUGH I would prefer a further option to only display the
query/date/pid/db_name

(the rest are completely "lost' for an entry level user like me)

Logging the above information helps me to check when certain web pages take
exceptional strain, and when/if I should cache them to relive the strain ...

Tielman J de Villiers
BondNet Pty Ltd

-----Original Message-----
From: Colm McCartan [mailto:colmm(at)owl(dot)co(dot)uk]
Sent: Monday, December 10, 2001 11:23 AM
To: Tielman J de Villiers
Subject: Re: [GENERAL] Logging/Debugging

Tielman J de Villiers wrote:

> Hi,
>
> I went through the man pages for postmaster, as well as "pg_ctl
> --help" for options to log a date/time stamp in the "serverlog" but
> could not find it. It was also not clear to me what debug levels are
> available (other than 1) and what they log. How would I go about this?

Tielman,

you'll find lots of basic information on this in the idocs at:

http://www.postgresql.org/idocs/index.php?runtime-config.html

However, I too would like a little more detail as to what each of the
debugging levels signifies - does anyone have any more detailed info?

Thanks,

colm