Re: Statement logging - Mailing list pgsql-general

From A. Kretschmer
Subject Re: Statement logging
Date
Msg-id 20070314094407.GD615@a-kretschmer.de
Whole thread Raw
In response to Re: Statement logging  ("hubert depesz lubaczewski" <depesz@gmail.com>)
Responses Re: Statement logging  ("hubert depesz lubaczewski" <depesz@gmail.com>)
List pgsql-general
am  Wed, dem 14.03.2007, um 10:10:02 +0100 mailte hubert depesz lubaczewski folgendes:
> On 3/14/07, Hannes Dorbath <light@theendofthetunnel.de> wrote:
> >Is there any way to enable statement logging at runtime without a restart?
> >If not I think that would be a nice feature, as one sometimes need to
> >debug applications that are already in production..
>
> change log_min_duration_statement and do pg_ctl reload
> works without restart.

Not necessary, you can set it via session without reload or restart.


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

pgsql-general by date:

Previous
From: "hubert depesz lubaczewski"
Date:
Subject: Re: Statement logging
Next
From: Jorge Godoy
Date:
Subject: Multiple TRIGGERs and OLD versus NEW "records"