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 <[EMAIL PROTECTED]>:
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 < [EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>:
> >
> > 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/
