Re: Log, Logs and more Logs

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 <shoaibmir(at)gmail(dot)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(dot)rocha(at)gmail(dot)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(at)gmail(dot)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(dot)rocha(at)gmail(dot)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(at)freedomcircle(dot)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/
> >
>
>

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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/