Re: Logging in postgres - Mailing list pgsql-admin

From Antony Stace
Subject Re: Logging in postgres
Date
Msg-id 20020127005112.05f1f063.s45652001@yahoo.com
Whole thread Raw
In response to Re: Logging in postgres  (Markus Bertheau <twanger@bluetwanger.de>)
Responses Re: Logging in postgres  (Markus Bertheau <twanger@bluetwanger.de>)
Re: Logging in postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-admin by date:

Previous
From: Markus Bertheau
Date:
Subject: Re: Logging in postgres
Next
From: Chris Ruprecht
Date:
Subject: Re: Increasing Shared Memory - on MacOS X