Re: Log, Logs and more Logs - Mailing list pgsql-sql
From | Ezequias Rodrigues da Rocha |
---|---|
Subject | Re: Log, Logs and more Logs |
Date | |
Msg-id | 55c095e90701311149v29f870d5u949f7ddfb359abbc@mail.gmail.com Whole thread Raw |
In response to | Re: Log, Logs and more Logs ("Shoaib Mir" <shoaibmir@gmail.com>) |
List | pgsql-sql |
Thank you Shoiab,
Now everything is working like I desire. Thank you all very much.
I am notthing without Postgresql community.
Ezequias
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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/
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@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 ?
Ezequias2007/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
Ezequias2007/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/
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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/