From ezequias.rocha@gmail.com Tue Mar 13 16:38:16 2007 Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 434B59FB97C for ; Tue, 13 Mar 2007 13:38:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 30121-03-2 for ; Tue, 13 Mar 2007 13:38:11 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171]) by postgresql.org (Postfix) with ESMTP id E3CF69FB982 for ; Tue, 13 Mar 2007 13:38:11 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id k3so312639ugf for ; Tue, 13 Mar 2007 09:38:08 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=bD1q+zC9qjWRmG6OwqhIISBvIXX+m+9QF0y9vaCi9+FfEQDAtfyf7ZHO6G0gCv7qCReHIaHgPxhf9EOqBynj8r6q1pg/EiLI1xhneMHihdS6sqhA+JdcREqB8NWWRkXjcHGlnzSlXOs+Y0QA2YkdkdWKiIvH/XMeY7saWuSHTRU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=KAQCv7x63rFmVgmhu/pP4c8wShGQmISIdwtItVqnlSX0kWMlaFC024TpfEbghXUXOQPELxNpE+EPDLmQ8CgXyW/p1USXkU1tcxvDqjDWPy8QF0qZ2Ctww7GIhdkq3WTTF99ly/YHMH2f6HP9S3yGqnQa3sHOLIizky4LmCeIeW0= Received: by 10.67.93.6 with SMTP id v6mr1844026ugl.1173803887938; Tue, 13 Mar 2007 09:38:07 -0700 (PDT) Received: by 10.67.94.13 with HTTP; Tue, 13 Mar 2007 09:38:07 -0700 (PDT) Message-ID: <55c095e90703130938n31a03c12x75046c9e970ab2e3@mail.gmail.com> Date: Tue, 13 Mar 2007 13:38:07 -0300 From: "Ezequias Rodrigues da Rocha" To: pgsql-admin@postgresql.org, PostgreSQL , "pgsql general" , Pgadmin-Support Subject: PgAgent logging verbosity MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_14439_30931867.1173803887905" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/57 X-Sequence-Number: 6772 ------=_Part_14439_30931867.1173803887905 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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/ ------=_Part_14439_30931867.1173803887905 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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/ ------=_Part_14439_30931867.1173803887905-- From dpage@postgresql.org Tue Mar 13 16:43:07 2007 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 92D309FBAF2; Tue, 13 Mar 2007 13:43:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 44771-04; Tue, 13 Mar 2007 13:43:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from developer.pgadmin.org (developer.pgadmin.org [63.246.23.140]) by postgresql.org (Postfix) with ESMTP id 054739FBAE9; Tue, 13 Mar 2007 13:43:03 -0300 (ADT) Received: from [172.24.32.131] ([62.232.55.118]) (authenticated bits=0) by developer.pgadmin.org (8.13.8/8.13.8) with ESMTP id l2DGgReX016680 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 13 Mar 2007 16:42:29 GMT Message-ID: <45F6D491.8020904@postgresql.org> Date: Tue, 13 Mar 2007 16:42:57 +0000 From: Dave Page User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: Ezequias Rodrigues da Rocha CC: pgsql-admin@postgresql.org, PostgreSQL , pgsql general , Pgadmin-Support Subject: Re: [GENERAL] PgAgent logging verbosity References: <55c095e90703130938n31a03c12x75046c9e970ab2e3@mail.gmail.com> In-Reply-To: <55c095e90703130938n31a03c12x75046c9e970ab2e3@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/59 X-Sequence-Number: 6774 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 From ezequias@fastcon.com.br Tue Mar 13 16:50:12 2007 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 2277B9FA4BB; Tue, 13 Mar 2007 13:50:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 45837-07; Tue, 13 Mar 2007 13:49:52 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from correio2.docasdoporto.com.br (8.144.199.200.docasdoporto.com.br [200.199.144.8]) by postgresql.org (Postfix) with ESMTP id 073DD9FBBEE; Tue, 13 Mar 2007 13:49:49 -0300 (ADT) Received: from [201.30.172.2] (account ezequias@fastcon.com.br HELO [192.168.0.110]) by correio2.docasdoporto.com.br (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 46379027; Tue, 13 Mar 2007 14:06:59 -0300 Message-ID: <45F6D5AF.7080209@fastcon.com.br> Date: Tue, 13 Mar 2007 13:47:43 -0300 From: "Ezequias R. da Rocha" User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: Dave Page , pgsql-sql@postgresql.org Subject: Re: [ADMIN] [GENERAL] PgAgent logging verbosity References: <55c095e90703130938n31a03c12x75046c9e970ab2e3@mail.gmail.com> <45F6D491.8020904@postgresql.org> In-Reply-To: <45F6D491.8020904@postgresql.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/173 X-Sequence-Number: 27811 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 > From dpage@postgresql.org Tue Mar 13 16:53:53 2007 Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id C69719FB3BB for ; Tue, 13 Mar 2007 13:53:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 33398-05 for ; Tue, 13 Mar 2007 13:53:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from developer.pgadmin.org (developer.pgadmin.org [63.246.23.140]) by postgresql.org (Postfix) with ESMTP id 5D9D49FB4D0 for ; Tue, 13 Mar 2007 13:53:44 -0300 (ADT) Received: from [172.24.32.131] ([62.232.55.118]) (authenticated bits=0) by developer.pgadmin.org (8.13.8/8.13.8) with ESMTP id l2DGr7wv016882 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 13 Mar 2007 16:53:09 GMT Message-ID: <45F6D711.9060502@postgresql.org> Date: Tue, 13 Mar 2007 16:53:37 +0000 From: Dave Page User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: "Ezequias R. da Rocha" CC: pgsql-sql@postgresql.org Subject: Re: [ADMIN] [GENERAL] PgAgent logging verbosity References: <55c095e90703130938n31a03c12x75046c9e970ab2e3@mail.gmail.com> <45F6D491.8020904@postgresql.org> <45F6D5AF.7080209@fastcon.com.br> In-Reply-To: <45F6D5AF.7080209@fastcon.com.br> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/174 X-Sequence-Number: 27812 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