Re: Logging in postgresql.conf - no SQL statements are logged

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Logging in postgresql.conf - no SQL statements are logged
Date: 2006-11-10 10:00:17
Message-ID: 20061110100017.GA23830@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

am Fri, dem 10.11.2006, um 10:48:12 +0100 mailte Nico Grubert folgendes:
> Dear list members,
>
> I would like to enable logging and write every SQL command that is
> executed in a logfile so I modified the "postgresql.conf" file in order
> ...
> Did I miss something?

Yes, change this line:

#log_statement = 'none' # none, mod, ddl, all

to:

log_statement = 'all'

and then reload the config

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shane Ambler 2006-11-10 10:06:37 Re: postgres at startup
Previous Message Nico Grubert 2006-11-10 09:48:12 Logging in postgresql.conf - no SQL statements are logged