Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 514969FB432 for ; Tue, 30 Jan 2007 14:41:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 61759-06 for ; Tue, 30 Jan 2007 14:41:08 -0400 (AST) 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 4D8EA9FB42C for ; Tue, 30 Jan 2007 14:41:15 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so1532868ugf for ; Tue, 30 Jan 2007 10:41:13 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=S84dbud+sO1o9UxzdZ5AexOHwhB0HYbPPqqPt7AKC/GmTMwUeu0mfr9AuPw3PNH5S8evl33ixc5AqtVaHc8++B8pN7JP176xg88ll3Xt6BcF9XZ28MsyN7rTYTV9k/ARWsDM1QSfQ+eHIdXzwp75VcY/sj8/HnKQfSjugg0L9UE= Received: by 10.67.21.11 with SMTP id y11mr10524421ugi.1170182473675; Tue, 30 Jan 2007 10:41:13 -0800 (PST) Received: by 10.66.217.13 with HTTP; Tue, 30 Jan 2007 10:41:13 -0800 (PST) Message-ID: <55c095e90701301041u68c5acc7i99517994724aa6d4@mail.gmail.com> Date: Tue, 30 Jan 2007 16:41:13 -0200 From: "Ezequias Rodrigues da Rocha" To: "Andrew Sullivan" Subject: Re: Log, Logs and more Logs Cc: pgsql-sql@postgresql.org In-Reply-To: <20070130172651.GD32170@phlogiston.dyndns.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <55c095e90701300901y41197404q4c26032ff0a28e22@mail.gmail.com> <20070130172651.GD32170@phlogiston.dyndns.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/164 X-Sequence-Number: 27316 So you are tell me that it is impossible to retrieve it ok ? Just by changing this values (what I did now) it is possible to get the error messages and their statements OK?. My best Regards Ezequias 2007/1/30, Andrew Sullivan : > On Tue, Jan 30, 2007 at 03:01:05PM -0200, Ezequias Rodrigues da Rocha wro= te: > > I know there are many logs in postgresql but I don't have many > > familiarity with all them. > > It's not totally plain what you want to have happen -- whether you > want all queries, whether you merely want ERRORs to show up in your > logs, or whether you want only ERRORS to show their queries. If it's > the latter, then my suggestion is to set log_min_messages to ERROR > and log_min_error_statement to ERROR as well. > > The section of the manual you really want to read is > http://www.postgresql.org/docs/8.2/static/runtime-config-logging.html > > A > > > -- > Andrew Sullivan | ajs@crankycanuck.ca > If they don't do anything, we don't need their acronym. > --Josh Hamilton, on the US FEMA > > ---------------------------(end of broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate > --=20 =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- A pior das democracias ainda =E9 melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequiasrocha.blogspot.com/