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