Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group