Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D97ED9FB1D9 for ; Wed, 31 Jan 2007 08:51:40 -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 69017-01 for ; Wed, 31 Jan 2007 08:51:37 -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 2409B9FA315 for ; Wed, 31 Jan 2007 08:51:36 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id i11so180551nzh for ; Wed, 31 Jan 2007 04:51:34 -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=hMzhckf99htvtunPLRrTs0+K3OjJDkpp8iz+EVJpgAPSbuQf5tE3PpRT9KUmPQTlX0lty2dz+cwhXGsEq3i3fgQCHERkW5hANYDJQFzN/BBjpKg2aK5PMd1yhevKuYIccvk9i83Zo+R7/G1BfhNgGLv0edzXF3m60Wvxcqo3gS8= Received: by 10.64.91.15 with SMTP id o15mr1162345qbb.1170247894798; Wed, 31 Jan 2007 04:51:34 -0800 (PST) Received: by 10.65.206.17 with HTTP; Wed, 31 Jan 2007 04:51:34 -0800 (PST) Message-ID: Date: Wed, 31 Jan 2007 17:51:34 +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: <55c095e90701310439qc3a9cdoab3653e7edcda06f@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1210_3347980.1170247894745" References: <55c095e90701300901y41197404q4c26032ff0a28e22@mail.gmail.com> <20070130172651.GD32170@phlogiston.dyndns.org> <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/177 X-Sequence-Number: 27329 ------=_Part_1210_3347980.1170247894745 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 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/ > ------=_Part_1210_3347980.1170247894745 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 M= ir
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 creat= ed my pg_log on: /var/lib/pgsql/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/

------=_Part_1210_3347980.1170247894745--