Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 133DE9FAD5A for ; Wed, 31 Jan 2007 15:49:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 87532-08 for ; Wed, 31 Jan 2007 15:49:41 -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 699409FA0E7 for ; Wed, 31 Jan 2007 15:49:39 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so239480ugf for ; Wed, 31 Jan 2007 11:49:38 -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=GznhcMMB57zI0rPblSM8Bs9Ouw/6l+DNHyyV5SLsCR7aiCDIKjbodPN11Rnynant72V5EPMHNemBhwyq/ske3Q8MBmbwAfzBaSgvzWA1aXtuLJhC76LZvvS2QMu2deOBLO1SsKYW4QBKOiYphzd7mK7RN/cSUi0y9fYmVdYd4DM= Received: by 10.66.216.6 with SMTP id o6mr1489090ugg.1170272977896; Wed, 31 Jan 2007 11:49:37 -0800 (PST) Received: by 10.66.217.13 with HTTP; Wed, 31 Jan 2007 11:49:37 -0800 (PST) Message-ID: <55c095e90701311149v29f870d5u949f7ddfb359abbc@mail.gmail.com> Date: Wed, 31 Jan 2007 17:49:37 -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_9629_22732720.1170272977833" References: <55c095e90701300901y41197404q4c26032ff0a28e22@mail.gmail.com> <55c095e90701310335x12d824a4q8798638503e45388@mail.gmail.com> <55c095e90701310404q64c9e33cgc821268cb8723ac@mail.gmail.com> <55c095e90701310412h5a5954dbg11edd0e27231937d@mail.gmail.com> <1170246081.691.1.camel@pampa> <55c095e90701310439qc3a9cdoab3653e7edcda06f@mail.gmail.com> <55c095e90701310538p2a6a1024r5006c545fd16b9b5@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/182 X-Sequence-Number: 27334 ------=_Part_9629_22732720.1170272977833 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Thank you Shoiab, Now everything is working like I desire. Thank you all very much. I am notthing without Postgresql community. Ezequias 2007/1/31, Shoaib Mir : > > No problemo :) > > What was the query and the statement for error? that way we might be able > to help... > > ------------- > Shoaib Mir > EnterpriseDB (www.enterprisedb.com) > > On 1/31/07, Ezequias Rodrigues da Rocha wrote: > > > > 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 combination= s > > > > of > > > > # stderr, syslog and eventlog, > > > > # depending on platform. > > > > > > > > # This is used when logging to stderr: > > > > #redirect_stderr =3D off # Enable capturing of stderr in= to > > > > log > > > > # 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 ditadur= as > > > > The 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 > > 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_9629_22732720.1170272977833 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Thank you Shoiab,

Now everything is working like I desire. Thank you= all very much.

I am notthing without Postgresql community.

<= span style=3D"font-weight: bold;">Ezequias

2007/1/31, Shoaib Mir <shoaibmir@= gmail.com>:
No problemo :)

What was the query and the statement for error? that = way we might be able to help...

-------------

Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)

On 1/31/07, Ezequias Rodrigues da Rocha < ezequias.rocha@gmail.com> wrote:
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)

On 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
  =             &nb= sp;            =        Atenciosamente (Sincerely)
            = ;            Ez= equias 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/




--
=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 d= a 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_9629_22732720.1170272977833--