Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id D0E009FB3EB for ; Wed, 31 Jan 2007 08:39:35 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 38285-07 for ; Wed, 31 Jan 2007 08:39:27 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.188]) by postgresql.org (Postfix) with ESMTP id 9E0F79FA354 for ; Wed, 31 Jan 2007 08:39:31 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so538487nfb for ; Wed, 31 Jan 2007 04:39:30 -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=ahiR+N1WTQgGJWz/nqTiqnbOVZ3TVBPWm2TIPJzFSHxpo4d1MCyPlTLeg6MvGZxZi3crm1PDHTj3cc0qLrZ0Go9OA8rFYYS4DlLNO/23kccDHN6vwziW+L/7NvzvqNBYjL/Sq085zmk/6rxypplYliUq7VFuZ80k6uixT4vh3vY= Received: by 10.49.29.2 with SMTP id g2mr2392449nfj.1170247169576; Wed, 31 Jan 2007 04:39:29 -0800 (PST) Received: by 10.66.217.13 with HTTP; Wed, 31 Jan 2007 04:39:29 -0800 (PST) Message-ID: <55c095e90701310439qc3a9cdoab3653e7edcda06f@mail.gmail.com> Date: Wed, 31 Jan 2007 10:39:29 -0200 From: "Ezequias Rodrigues da Rocha" To: Joe Subject: Re: Log, Logs and more Logs Cc: "Shoaib Mir" , "Andrew Sullivan" , pgsql-sql@postgresql.org In-Reply-To: <1170246081.691.1.camel@pampa> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1976_3579697.1170247169509" 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> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/176 X-Sequence-Number: 27328 ------=_Part_1976_3579697.1170247169509 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 > > --=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_1976_3579697.1170247169509 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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:

#----------= -----------------------------------------------------------------
# ERRO= R REPORTING 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:
            = ;            ^^= ^^^^^^^^^^^^^^^^^^^^^^
Did you look at the setting of redirect_stderr, a= nd 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.blo= gspot.com/ ------=_Part_1976_3579697.1170247169509--