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/
