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

Re: Logging in postgres

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: Antony Stace <s45652001(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Logging in postgres
Date: 2002-01-26 15:42:57
Message-ID: 1012059778.1754.5.camel@saphir (view raw or flat)
Thread:
Lists: pgsql-admin
On Sat, 2002-01-26 at 16:51, Antony Stace wrote:
> 
> > 
> > > 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?

hmm, that is my postgresql.conf:

tcpip_socket = true
port = 5432 
hostname_lookup = false
sort_mem = 128
shared_buffers = 12288 # min 16
fsync = off
deadlock_timeout = 10000
wal_buffers = 64 # min 4
wal_files = 4 # range 0-64
log_connections = true
log_timestamp = true
log_pid = true
debug_print_query = true
debug_print_rewritten = false
show_executor_stats = false
show_query_stats = false

what is different?

btw: I presume we talk about 7.1.x

Markus Bertheau


In response to

pgsql-admin by date

Next:From: Antony StaceDate: 2002-01-26 15:51:12
Subject: Re: Logging in postgres
Previous:From: Antony StaceDate: 2002-01-26 15:12:00
Subject: Re: Logging in postgres

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