Re: Logging in postgres

From: Antony Stace <s45652001(at)yahoo(dot)com>
To: Markus Bertheau <twanger(at)bluetwanger(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Logging in postgres
Date: 2002-01-26 15:51:12
Message-ID: 20020127005112.05f1f063.s45652001@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


>
> > log_connections = yes
> > log_timestamp = true
> > log_pid = true
> > syslog = 2
> >
> > to my postgresql.conf file but it dosent seem to have caused any logging to occur in
> >
> > /var/log/postgresql
> >
> > Anything else I need to do?
>
> add
>
> debug_print_query = true
>
I just added

debug_print_query

restarted postgres and then did a few queries in the database. But nothing
is being logged in /var/log/postgresql. Any ideas what else might be wrong?

Cheers

Tony
---------------------------------------------------------------------

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Ruprecht 2002-01-26 16:11:40 Re: Increasing Shared Memory - on MacOS X
Previous Message Markus Bertheau 2002-01-26 15:42:57 Re: Logging in postgres