Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id E28249FA311 for ; Wed, 31 Jan 2007 09:47: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 95631-02 for ; Wed, 31 Jan 2007 09:46:43 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.234]) by postgresql.org (Postfix) with ESMTP id 723D19FB282 for ; Wed, 31 Jan 2007 09:47:00 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id i11so192895nzh for ; Wed, 31 Jan 2007 05:46:59 -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=UQJeAEAxY/4xM8XjwV/+ydD6oCDqXkLtdTNhGOETxK55FiWeZUYZibCbEU6uwGsrw0Bk0d1fleN7GHV4GWEsN/6g9WbD9n0AoDRYcH/U3VFCgkKR2IXMOI7+J6izSsRq30PRPDPyoldWQVvPAvivUx7uJVWAkvP3vaCADzUxotA= Received: by 10.65.213.4 with SMTP id p4mr1294592qbq.1170251218777; Wed, 31 Jan 2007 05:46:58 -0800 (PST) Received: by 10.65.206.17 with HTTP; Wed, 31 Jan 2007 05:46:58 -0800 (PST) Message-ID: Date: Wed, 31 Jan 2007 18:46:58 +0500 From: "Shoaib Mir" To: "Ezequias Rodrigues da Rocha" Subject: Re: Log, Logs and more Logs Cc: Joe , "Andrew Sullivan" , pgsql-sql@postgresql.org In-Reply-To: <55c095e90701310538p2a6a1024r5006c545fd16b9b5@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1738_18535591.1170251218721" References: <55c095e90701300901y41197404q4c26032ff0a28e22@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> <55c095e90701310538p2a6a1024r5006c545fd16b9b5@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/180 X-Sequence-Number: 27332 ------=_Part_1738_18535591.1170251218721 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline No problemo :) What was the query and the statement for error? that way we might be able t= o 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 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 > > > 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 ditaduras > > > 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/ > ------=_Part_1738_18535591.1170251218721 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline No problemo :)

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

-------------
Shoaib Mir
Enter= priseDB (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
        = ;            &n= bsp;            = ; 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/

------=_Part_1738_18535591.1170251218721--