Re: Log, Logs and more Logs

["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/