Обсуждение: Statement logging

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..


Thanks!


--
Regards,
Hannes Dorbath

am  Wed, dem 14.03.2007, um  9:57:41 +0100 mailte Hannes Dorbath folgendes:
> 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..

set log_statement = 'all';

Without restart, simply at runtime.


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

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.

depesz

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

On 3/14/07, A. Kretschmer <andreas.kretschmer@schollglas.com> wrote:
> Not necessary, you can set it via session without reload or restart.

but then it will work only for the connection that did set it. and i
understood that hannes wanted to profile working application - so it's
not really useful.

depesz

--
http://www.depesz.com/ - nowy, lepszy depesz

hubert depesz lubaczewski wrote:
> On 3/14/07, A. Kretschmer <andreas.kretschmer@schollglas.com> wrote:
>> Not necessary, you can set it via session without reload or restart.
>
> but then it will work only for the connection that did set it. and i
> understood that hannes wanted to profile working application - so it's
> not really useful.

Ah, but you can do ALTER USER ... SET or ALTER DATABASE ... SET too.

--
   Richard Huxton
   Archonet Ltd

On 14.03.2007 10:10, hubert depesz lubaczewski wrote:
> 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.

Great. Thanks!


--
Regards,
Hannes Dorbath