From: Shoaib Mir <shoaibmir@gmail.com>
To: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
Cc: Joe <dev@freedomcircle.net>
Cc: Andrew Sullivan <ajs@crankycanuck.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: Log, Logs and more Logs
Date: Wed, 31 Jan 2007 18:46:58 +0500
Message-ID: <bf54be870701310546n7e8eeb40ie9bcebfa16075456@mail.gmail.com> (raw)
In-Reply-To: <55c095e90701310538p2a6a1024r5006c545fd16b9b5@mail.gmail.com>
References: <55c095e90701300901y41197404q4c26032ff0a28e22@mail.gmail.com>
<20070130213304.GA561@phlogiston.dyndns.org>
<55c095e90701310335x12d824a4q8798638503e45388@mail.gmail.com>
<bf54be870701310339n3413e7b8rd1f6927a0c89dc9e@mail.gmail.com>
<55c095e90701310404q64c9e33cgc821268cb8723ac@mail.gmail.com>
<55c095e90701310412h5a5954dbg11edd0e27231937d@mail.gmail.com>
<1170246081.691.1.camel@pampa>
<55c095e90701310439qc3a9cdoab3653e7edcda06f@mail.gmail.com>
<bf54be870701310451u12c6ac58uf16a6d899348d182@mail.gmail.com>
<55c095e90701310538p2a6a1024r5006c545fd16b9b5@mail.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.
>
> Any suggestion ?
>
> Ezequias
>
> 2007/1/31, Shoaib Mir <shoaibmir@gmail.com>:
> >
> > You need to set it like this:
> >
> > log_destination = 'syslog,stderr'
> > redirect_stderr = 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 = 'stderr' # Valid values are combinations of
> > > # stderr, syslog and eventlog,
> > > # depending on platform.
> > >
> > > # This is used when logging to stderr:
> > > #redirect_stderr = off # Enable capturing of stderr into
> > > log
> > > # files
> > >
> > >
> > > Ezequias
> > > 2007/1/31, Joe <dev@freedomcircle.net>:
> > > >
> > > > 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
> > > >
> > > >
> > >
> > >
> > > --
> > > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> > > Atenciosamente (Sincerely)
> > > Ezequias Rodrigues da Rocha
> > > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > >
> > > A pior das democracias ainda é melhor do que a melhor das ditaduras
> > > The worst of democracies is still better than the better of
> > > dictatorships
> > > http://ezequiasrocha.blogspot.com/
> > >
> >
> >
>
>
> --
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Atenciosamente (Sincerely)
> Ezequias Rodrigues da Rocha
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> A pior das democracias ainda é melhor do que a melhor das ditaduras
> The worst of democracies is still better than the better of dictatorships
> http://ezequiasrocha.blogspot.com/
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: shoaibmir@gmail.com, ezequias.rocha@gmail.com, dev@freedomcircle.net, ajs@crankycanuck.ca
Subject: Re: Log, Logs and more Logs
In-Reply-To: <bf54be870701310546n7e8eeb40ie9bcebfa16075456@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox