Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id DB2A79FB282 for ; Wed, 31 Jan 2007 09:39:04 -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 56579-07 for ; Wed, 31 Jan 2007 09:38:42 -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.173]) by postgresql.org (Postfix) with ESMTP id 7B0629FA311 for ; Wed, 31 Jan 2007 09:38:59 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so152148ugf for ; Wed, 31 Jan 2007 05:38:57 -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:references; b=NZRZmdSSk2An5Prr0qLl9Ae5HVgDwbb23QTXtI3AYTHLT6hxBGmy5ZXxRxGZYdfSBmVyiZk62ympUplJIQkqS7ik52uIGNKTq1zuT9h0MtGzduqMIpf/MyRn3YHNaI1fvdaSjzu1+jXrWrgvBosAKk6JgJ9eingNxEyCs9mhy7U= Received: by 10.67.100.17 with SMTP id c17mr1035604ugm.1170250737702; Wed, 31 Jan 2007 05:38:57 -0800 (PST) Received: by 10.66.217.13 with HTTP; Wed, 31 Jan 2007 05:38:57 -0800 (PST) Message-ID: <55c095e90701310538p2a6a1024r5006c545fd16b9b5@mail.gmail.com> Date: Wed, 31 Jan 2007 11:38:57 -0200 From: "Ezequias Rodrigues da Rocha" To: "Shoaib Mir" Subject: Re: Log, Logs and more Logs Cc: Joe , "Andrew Sullivan" , pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2740_17330582.1170250737633" References: <55c095e90701300901y41197404q4c26032ff0a28e22@mail.gmail.com> <55c095e90701301041u68c5acc7i99517994724aa6d4@mail.gmail.com> <20070130213304.GA561@phlogiston.dyndns.org> <55c095e90701310335x12d824a4q8798638503e45388@mail.gmail.com> <55c095e90701310404q64c9e33cgc821268cb8723ac@mail.gmail.com> <55c095e90701310412h5a5954dbg11edd0e27231937d@mail.gmail.com> <1170246081.691.1.camel@pampa> <55c095e90701310439qc3a9cdoab3653e7edcda06f@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/179 X-Sequence-Number: 27331 ------=_Part_2740_17330582.1170250737633 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Great. Now the log is working. Thank you, Thank you, Thank you, But my statement does not report an error anymore. I really confused now. Any suggestion ? Ezequias 2007/1/31, Shoaib Mir : > > You need to set it like this: > > log_destination =3D 'syslog,stderr' > redirect_stderr =3D on > > and then restart the server. It should show up the log from then > onwards.... > > --------------- > Shoaib Mir > EnterpriseDB (www.enterprisedb.com) > > On 1/31/07, Ezequias Rodrigues da Rocha < ezequias.rocha@gmail.com> wrote= : > > > > I really don't know how to set it. I created my pg_log on: > > /var/lib/pgsql/data. > > > > the settings on pgsql.conf is like this: > > > > > > #----------------------------------------------------------------------= ----- > > # ERROR REPORTING AND LOGGING > > > > #----------------------------------------------------------------------= ----- > > > > # - Where to Log - > > > > #log_destination =3D 'stderr' # Valid values are combinations of > > # stderr, syslog and eventlog, > > # depending on platform. > > > > # This is used when logging to stderr: > > #redirect_stderr =3D off # Enable capturing of stderr into l= og > > # files > > > > > > Ezequias > > 2007/1/31, Joe : > > > > > > On Wed, 2007-01-31 at 10:12 -0200, Ezequias Rodrigues da Rocha wrote= : > > > > I restart the server but the pg_log folder doesn't appears. > > > > > > > > My log session is like this on postgresql.conf: > > > > > > > > # These are only used if redirect_stderr is on: > > > ^^^^^^^^^^^^^^^^^^^^^^^^ > > > Did you look at the setting of redirect_stderr, and the various > > > logging > > > settings just above it? > > > > > > Joe > > > > > > > > > > > > -- > > =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/ > > > > --=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/ ------=_Part_2740_17330582.1170250737633 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Great. Now the log is working. Thank you, Thank you, Thank you,

But= my statement does not report an error anymore. I really confused now.
<= br>Any suggestion ?

Ezequias

2007/1/31, Shoaib Mir <shoaibmir@gmail.com>: You need to set it like this:

log_destination =3D 'syslog,stderr= '
redirect_stderr =3D on

and then restart the server. It shou= ld show up the log from then onwards....

---------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.= com)

O= n 1/31/07,=20 Ezequias Rodrigues da Rocha < ezequias.rocha@gmail.com> wrote:
I really don't know how to set it. I created my pg_log on: /var/lib/pgs= ql/data.

the settings on pgsql.conf is like this:

#------------------= ---------------------------------------------------------
# ERROR REPORT= ING AND LOGGING
#----------------------------------------------------------------------= -----

# - Where to Log -

#log_destination =3D 'stderr'= ;        # Valid values are combinations of <= br>              &nb= sp;     # stderr, syslog and eventlog,=20
              &n= bsp;     # depending on platform.

# This is used when= logging to stderr:
#redirect_stderr =3D off     &nb= sp;      # Enable capturing of stderr into log
&nbs= p;               &nb= sp;   # files


Ezequias
2007/1/31, Joe <dev@freedomcircle.net>:<= blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, 2= 04, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> On Wed, 2007-01-31 at 10:12 -0200, Ezequias Rodrigues da Rocha wrote:
&g= t; I restart the server but the pg_log folder doesn't appears.
><= br>> My log session is like this on postgresql.conf:
>
> # T= hese are only used if redirect_stderr is on:
          &nbs= p;            &= nbsp;^^^^^^^^^^^^^^^^^^^^^^^^
Did you look at the setting of redirect_st= derr, and the various logging
settings just above it?

Joe

=



--
=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
  =             &nb= sp;            =        Atenciosamente (Sincerely)
&nb= sp;            =            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 ditadurasThe worst of democracies is still better than the better of dictatorships=
http://ezequiasrocha.blogspot.com/




--
=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
      = ;            &n= bsp;            = ;   Atenciosamente (Sincerely)
    &n= bsp;            = ;       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<= br>The worst of democracies is still better than the better of dictatorship= s
http://ezequiasrocha.blo= gspot.com/ ------=_Part_2740_17330582.1170250737633--