Re: Log, Logs and more Logs

From: "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com>
To: "Andrew Sullivan" <ajs(at)crankycanuck(dot)ca>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Log, Logs and more Logs
Date: 2007-01-30 18:41:13
Message-ID: 55c095e90701301041u68c5acc7i99517994724aa6d4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-sql

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 <ajs(at)crankycanuck(dot)ca>:
> On Tue, Jan 30, 2007 at 03:01:05PM -0200, Ezequias Rodrigues da Rocha wrote:
> > 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(at)crankycanuck(dot)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
>

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Andrew Sullivan 2007-01-30 21:33:04 Re: Log, Logs and more Logs
Previous Message Andrew Sullivan 2007-01-30 17:26:51 Re: Log, Logs and more Logs

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2007-01-30 18:59:36 Re: Differentiate Between Zero-Length String and NULLColumn Values
Previous Message Geoff Tolley 2007-01-30 18:14:26 Re: Differentiate Between Zero-Length String and NULLColumn Values