pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPgAgent logging verbosity
4+ messages / 3 participants
[nested] [flat]
* PgAgent logging verbosity
@ 2007-03-13 16:38 Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
2007-03-13 16:42 ` Re: [GENERAL] PgAgent logging verbosity Dave Page <dpage@postgresql.org>
0 siblings, 1 reply; 4+ messages in thread
From: Ezequias Rodrigues da Rocha @ 2007-03-13 16:38 UTC (permalink / raw)
To: pgsql-sql; pgsql general <pgsql-general@postgresql.org>; Pgadmin-Support <pgadmin-support@postgresql.org>
Hi list,
I would like to know if I set the debug mode to 2 (-l 2) in the pgAgent
connection string it could spend much cpu processing.
I have other things running in the server and I don't like to create problem
to others.
--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com/
use Mozilla Firefox:http://br.mozdev.org/firefox/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [GENERAL] PgAgent logging verbosity
2007-03-13 16:38 PgAgent logging verbosity Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
@ 2007-03-13 16:42 ` Dave Page <dpage@postgresql.org>
2007-03-13 16:47 ` Re: [ADMIN] [GENERAL] PgAgent logging verbosity Ezequias R. da Rocha <ezequias@fastcon.com.br>
0 siblings, 1 reply; 4+ messages in thread
From: Dave Page @ 2007-03-13 16:42 UTC (permalink / raw)
To: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>; +Cc: pgsql-sql; pgsql general <pgsql-general@postgresql.org>; Pgadmin-Support <pgadmin-support@postgresql.org>
Ezequias Rodrigues da Rocha wrote:
> Hi list,
>
> I would like to know if I set the debug mode to 2 (-l 2) in the pgAgent
> connection string it could spend much cpu processing.
>
> I have other things running in the server and I don't like to create
> problem to others.
Please stop cross posting to lots of lists!
-l 2 is extremely unlikely to cause excessive CPU or IO, but it will
clutter logs, so you wouldn't want to leave it on permanently.
Regards, Dave
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [ADMIN] [GENERAL] PgAgent logging verbosity
2007-03-13 16:38 PgAgent logging verbosity Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
2007-03-13 16:42 ` Re: [GENERAL] PgAgent logging verbosity Dave Page <dpage@postgresql.org>
@ 2007-03-13 16:47 ` Ezequias R. da Rocha <ezequias@fastcon.com.br>
2007-03-13 16:53 ` Re: [ADMIN] [GENERAL] PgAgent logging verbosity Dave Page <dpage@postgresql.org>
0 siblings, 1 reply; 4+ messages in thread
From: Ezequias R. da Rocha @ 2007-03-13 16:47 UTC (permalink / raw)
To: Dave Page <dpage@postgresql.org>; pgsql-sql
Ok I will use only on error ok ?
-l 0
:)
Thank you
Dave Page escreveu:
> Ezequias Rodrigues da Rocha wrote:
>> Hi list,
>>
>> I would like to know if I set the debug mode to 2 (-l 2) in the
>> pgAgent connection string it could spend much cpu processing.
>>
>> I have other things running in the server and I don't like to create
>> problem to others.
>
> Please stop cross posting to lots of lists!
>
> -l 2 is extremely unlikely to cause excessive CPU or IO, but it will
> clutter logs, so you wouldn't want to leave it on permanently.
>
> Regards, Dave
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [ADMIN] [GENERAL] PgAgent logging verbosity
2007-03-13 16:38 PgAgent logging verbosity Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
2007-03-13 16:42 ` Re: [GENERAL] PgAgent logging verbosity Dave Page <dpage@postgresql.org>
2007-03-13 16:47 ` Re: [ADMIN] [GENERAL] PgAgent logging verbosity Ezequias R. da Rocha <ezequias@fastcon.com.br>
@ 2007-03-13 16:53 ` Dave Page <dpage@postgresql.org>
0 siblings, 0 replies; 4+ messages in thread
From: Dave Page @ 2007-03-13 16:53 UTC (permalink / raw)
To: Ezequias R. da Rocha <ezequias@fastcon.com.br>; +Cc: pgsql-sql
Ezequias R. da Rocha wrote:
> Ok I will use only on error ok ?
>
> -l 0
>
> :)
In the normal case, yes, that is what I'd use (0 is the default in fact,
so you can omit the option altogether).
Regard,s Dave
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2007-03-13 16:53 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-03-13 16:38 PgAgent logging verbosity Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
2007-03-13 16:42 ` Dave Page <dpage@postgresql.org>
2007-03-13 16:47 ` Ezequias R. da Rocha <ezequias@fastcon.com.br>
2007-03-13 16:53 ` Dave Page <dpage@postgresql.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox